DataSource Controls :: Using Dataadapter For Custom Add / Delete Of Database Table

Feb 12, 2010

My code is not updating the sql database. I am definately passing the correct information in to this function, and it runs without errors. If I exec the procedure with the passed in data, it works great. Can someone tell me what is missing?

public DataTable UpdateEmailList(int listId, string connectionString, DataTable EmailList)
{
//DataTable dt = new DataTable();
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
SqlDataAdapter da = new SqlDataAdapter(null, conn);
SqlCommand cmd = null;
//add
cmd = new SqlCommand("dbo.fp_ServiceAwards_AddEmailToList", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@emailList_id", SqlDbType.Int)).Value = listId;
cmd.Parameters.Add(new SqlParameter("@email_address", SqlDbType.NVarChar, 255, "email_address"));
cmd.Connection = conn;
da.InsertCommand = cmd;
//delete
cmd = new SqlCommand("dbo.fp_ServiceAwards_DeleteEmailFromList", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@emailList_id", SqlDbType.Int)).Value = listId;
cmd.Parameters.Add(new SqlParameter("@email_address", SqlDbType.NVarChar, 255, "email_address"));
cmd.Connection = conn;
da.DeleteCommand = cmd;
try
{
da.Update(EmailList);
}
catch (Exception ex)
{
string msg = ex.Message;
}
conn.Close();
conn.Dispose();
return EmailList;
}

View 3 Replies


Similar Messages:

DataSource Controls :: Delete Multiple Rows From Database In A Table?

May 1, 2010

I've have to delete multiple rows from database in a table . Which is the best way to delete data to optimize performance of sql server as well as asp.net.

View 6 Replies

DataSource Controls :: Unable To Delete Data In The Third Table.

Mar 18, 2010

I have three tables:

Colour(Colour ID, Colour)
DogColours(ColourID, Dog ID)
Dog(Dog ID, Breed)

Colour ID and Dog are primary keys.

I have three web forms, one for each table. Dog colours consists of data that is already in the system from the other two tables. It basically joins a breed to a colour. My problem is this:

When i try delete a dog which is being used in dog colours the program crashes. How can i prevent this crash?

The second problem, the data source in the dog colours web form has the insert, update and delete tick boxes greyed out in the 'configure the select statement' so i am unable to delete a colour and dog joined together. how can i delete something in the dog colours?

View 13 Replies

DataSource Controls :: How To Delete Multiple Records In A Table Using Linq

May 14, 2010

i am new to this linq concept,

i have used the following code to delete multiple records in my table,

but when i hit the button insteading deleting multiple records only one record is getting deleted

below is the code

protected void Button1_Click(object sender, EventArgs e)

View 10 Replies

DataSource Controls :: How To Delete The Duplicate Rows From Data Table

Mar 4, 2010

How do I remove duplicate rows from a data table based upon a two column values;I want to pass in a Data Table and a column names and get the data table back with data rows where that columns value are unique.

I have a Data Table with Duplicate Rows i want to delete the duplicates rows based upon two column values if both columns values are there then Delete the row.

View 8 Replies

DataSource Controls :: Add Parameters On Dataadapter?

Jun 23, 2010

How could I add parameters on dataadapter? I tried

[Code]....

But parameters is unknown for dataadapter.

View 4 Replies

Forms Data Controls :: Update One Or Two Columns In A Table Without Using Dataadapter / Dataset?

Mar 14, 2010

1. As per my knowledge we use dataadapters/dataset when we want to deal with the huge amount of column/data. Is there anyway that if I want to update one or two columns in a table without using dataadapter/dataset?

2. There is a way that without clicking a button we can get the data using objectdatasource, I mean to say that there is no vb.net data in the code behind then how to debug if there is not data in vb.net in code behind.

View 6 Replies

DataSource Controls :: Delete Records Based On Join Condition From Other Table?

Feb 25, 2010

I want to delete recodrs from based on some join condition between two tables.

One table belongs to my DB ( table name : FeeDetails)

and second table ( TargetTable) is on different server.

I have delete records from TargetTable table based on join condition between two tables.

I am able to select records

[Code]....

View 3 Replies

DataSource Controls :: Getting Values To The Dataset From Dataadapter?

Dec 23, 2010

public static DataSet GetSubCategories(int category_id)

View 4 Replies

DataSource Controls :: Sql DataAdapter - Read Data From Sql DB

Feb 24, 2010

i'm tring to read data from a sql DB, where is email == mystring - then display its name here is the code:

string mystring;
mystring = "email@email.com";//"Welcome " + System.Convert.ToString(Session["user"]);
generalTableTableAdapters.kurtula_generalTableAdapter generals = new
generalTableTableAdapters.kurtula_generalTableAdapter();
generalTable.kurtula_generalDataTable genaraltab = generals.Getgeneral();
foreach (DataRow row in genaraltab.Rows)
{
if (Convert.ToString(row["email"])== user)
{
Label1.Text = System.Convert.ToString(row["name"]);
}
}

as you can see I'm a table adapter but is giving me the following error: i realy dont know what this error means - though i did a simular action using access DB (and it did work), where i had to user the following: using System.Data.OleDb; now because im using SQL DB im using: using System.Data.SqlClient; //sql server

View 3 Replies

DataSource Controls :: DataAdapter Update Method?

Feb 19, 2010

i am having a datatable with 10 rows.

Out of this 10 rows 3 Rows have their RowState as Added, 2 rows as Modified, and 4 as Deleted.

Now i want to use Datadapter's InsertCommand, UpdateCommand and DeleteCommand

Is it possible to update datatable's changes to Database with Single DataAdpater.Update(DataTable) Call.

Means i will call DataAdapter.Update(DataTable) method only once and with this all new added rows should be inserted in database, modified rows should be updated and deleted rows should be deleted from Database.

View 3 Replies

DataSource Controls :: Batchupdate Is Not Working For Dataadapter?

Feb 10, 2010

Im trying to do the batchinsert (bulk) in sqldataadapter using dataset.but somehow its not inserting (even no error as well), i dunno where i went wrong.my coding..

Dim _cmd As New SqlCommand

View 6 Replies

DataSource Controls :: Stored Procedure For Delete Records From Parent And Child Table

Jan 16, 2010

I have two tables dept and employees those table have parent and child relation ship link column is deptno i want to delte department even this departmetn contains employees i want to write storedprocedure for first delte employees and after department if i wrtie these two querys in storedprocedure will i get any problems

Begin
Delete from tbl_employees where Department_Id=@Department_Id
Delete from tbl_Department where Department_Id=@Department_Id
RETURN
END

View 5 Replies

DataSource Controls :: Retrieving Identity Value After Using DataAdapter.Update?

Jul 29, 2010

I am not sure how to do this. I would like to merge the identity back into the dataset.

View 2 Replies

DataSource Controls :: Can't Delete Record From Database

Mar 5, 2010

I have 3 pages, one to add a category, one to edit the category, and one to delete the category. The add and edit work fine. The delete is not working for some reason. I click the link on my site to delete it, and I'm just staring at the green bar in my browser taking a long time. The add and edit don't take long at all to perform their function. I'm thinking this is a connection string issue, but I don't see how it can be the case. It relies on web.config for it just like the other pages. Following is the delete page code behind and also delete cascade from the business logic area. After the page refreshes, I'm not getting any diagnostics or error messages which I have in the code. Doesn't this have to mean a db connection issue?

[Code]....

View 10 Replies

DataSource Controls :: How To Delete Data And Its Dependcies From Database

Feb 24, 2010

that is i want to delete my all he data of database but i want taht all the tables a andreletion will be remain same how can i do it easily

View 7 Replies

DataSource Controls :: Conversion Failed When Converting From A Character String To Uniqueidentifier - Delete Photo Table

Jan 12, 2011

Trying simple delete against a Photo table but hitting error as conversion type error.

[Code]....

Is there a better way to write this sql statement? or convert the UserId to int32 before executing? Not sure how to do that.

View 6 Replies

DataSource Controls :: Insert A Record Error - Can't Perform Create, Update, Or Delete Operations On 'Table?

May 11, 2010

when i want insert a record i see an error like this Can't perform Create, Update, or Delete operations on 'Table(MainMenuLink)' because it has no primary key. with this codes:

MyLinqDataClassesDataContext db = new MyLinqDataClassesDataContext();
MainMenuLink li = new MainMenuLink { Link = "www.tprogrammer.com", LinkSubject = "subject" };
db.MainMenuLinks.InsertOnSubmit(li); [code]....

View 2 Replies

DataSource Controls :: Database Table: Move Row To The Top Of The Table?

Sep 5, 2010

I have a table in my aspnet database. I added a bottom row "Not Selected", if the user doesn't select from a databound drop down list. This row is at the bottom, because I just added it to the table data. Is there any way to move this one row to the top of the table manually? There is not "cut" and "paste" when I select the whole row.

View 3 Replies

DataSource Controls :: How To Insert And Delete Image In To Sql Server Database

Mar 1, 2010

How to write a Sql Query for insert, Delete for Image from sql server 2005.

View 2 Replies

Web Forms :: Delete Image Filename From Database Table And Then Delete Image From Disk

Jul 9, 2012

This is my House_p table

Iamge3 Image2 Image1 Name ID

3.JPG 2.JPG 1.JPG SARA 1

View 1 Replies

DataSource Controls :: Create .net Service - Delete Specific Records From The Database?

Jun 1, 2010

i am trying to create an asp.net service where it can delete specific records from the databas, this is by code so far:

View 1 Replies

DataSource Controls :: Update / Insert And Delete SQL Statements For Define Custom Statements Wizard

Feb 23, 2011

I'm using the 'Configure Data Source' wizard to connect to my database and show the dataset in Gridview. I want to be able to update, insert and delete entries but am unsure how to build the query. I can write simple update statments to change database entries but how can I do this for entries that have been changed within the gridview?

View 6 Replies

Update - Delete 2 Different Database Table In Gridview

Oct 2, 2012

How can i update, delete 2 table in gridview?

I have created 2 table in access

1. Recipient (Userid, RecipientId, RecipientName, Company, DeliveryAddressId)
2. MailingAddress (Id, BuildingInfo, StreetInfo, City, Province)

I connected this gridview with sqldatasource

"SELECT Recipient.UserId, Recipient.RecipientId, Recipient.RecipientName, Recipient.Company, MailingAddress.BuildingInfo, MailingAddress.StreetInfo, MailingAddress.City, MailingAddress.Province FROM (Recipient INNER JOIN MailingAddress ON Recipient.DeliveryAddressId = MailingAddress.Id)"

The gridview it can select from 2 table, (RecipientId, RecipientName, Company, BuildingInfo, StreetInfo, City, Province) but cannot update 2 table.

View 1 Replies

SQL Server :: How To Delete From Parent And Child Table Using Sql Datasource

Dec 2, 2010

i am trying to delete using Gridview from child first and check if there is no child to delete in parent table i am using sql datasource in the delete tab in sql datasource i put DELETE FROM table1 WHERE (IDtable = @IDtable) IF (SELECT count(*) FROM table1 WHERE parent_dtl_id = 66) =0
BEGIN delete from parent_dtl where order_dtl_id= 66 END

i deleted all items,deleting from 2 tables child and parent was successfully on the last row from gridview but i have this error on my page on the last delete Specified argument was out of the range of valid values. Parameter name: value

View 2 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved