Click here to Skip to main content
15,921,716 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: unable to set connectionstring property of Sqldatasource dynamically Pin
szukuro29-Jun-07 5:35
szukuro29-Jun-07 5:35 
GeneralRe: unable to set connectionstring property of Sqldatasource dynamically Pin
yogita charhate30-Jun-07 1:41
yogita charhate30-Jun-07 1:41 
QuestionData Grid Grid View Conversion Issue Pin
Sam Heller29-Jun-07 3:39
Sam Heller29-Jun-07 3:39 
AnswerRe: Data Grid Grid View Conversion Issue Pin
kubben29-Jun-07 4:18
kubben29-Jun-07 4:18 
AnswerRe: Data Grid Grid View Conversion Issue Pin
sathesh pandian29-Jun-07 4:19
sathesh pandian29-Jun-07 4:19 
GeneralRe: Data Grid Grid View Conversion Issue Pin
Sam Heller29-Jun-07 5:24
Sam Heller29-Jun-07 5:24 
GeneralRe: Data Grid Grid View Conversion Issue Pin
kubben29-Jun-07 6:03
kubben29-Jun-07 6:03 
Questionsqldataadapter. update Pin
Sebastian T Xavier29-Jun-07 3:34
Sebastian T Xavier29-Jun-07 3:34 
Hi,

I would like to know how i can perform update or delete by using Update method of sql data adapter. I have done the insert operation using update method. The code follows...
<br />
public Boolean SetStorageArea(int UID, DataTable dtStorageArea)<br />
        {<br />
            string strSql;<br />
            strSql = "SELECT [Active],[WarehouseID],[StorageAreaID],[StorageAreaShortName],[StorageAreaName], " +<br />
                     " [Alias],[Notes],[CreatedBy],[CreatedOn],[LastModifiedBy],[LastModifiedOn] FROM [StorageArea]";<br />
            try<br />
            {<br />
                DataSet dsStorageArea = new DataSet();<br />
                dsStorageArea.Tables.Add(dtStorageArea);<br />
                SqlDataAdapter sda = new SqlDataAdapter(strSql, sqlcon);<br />
                SqlCommandBuilder sqb = new SqlCommandBuilder(sda);<br />
                sda.Update(dsStorageArea, "StorageArea");<br />
                return true;<br />
<br />
            }<br />
            catch (Exception Ex)<br />
            {<br />
<br />
                throw new Exception("SetStorageArea: Could not get the records of all Storage Areas.\nOriginal message: " + Ex.Message);<br />
            }<br />
                    }<br />


.

awaiting for your valuable suggestions..

Thanks in advance

Sebastian
AnswerRe: sqldataadapter. update Pin
Pallavi Bhoite29-Jun-07 18:54
Pallavi Bhoite29-Jun-07 18:54 
GeneralRe: sqldataadapter. update Pin
Sebastian T Xavier1-Jul-07 18:21
Sebastian T Xavier1-Jul-07 18:21 
QuestionWizard Control - Finish Button Validation Pin
Jagadeesh Jupalli29-Jun-07 3:28
Jagadeesh Jupalli29-Jun-07 3:28 
AnswerRe: Wizard Control - Finish Button Validation Pin
sathesh pandian29-Jun-07 4:16
sathesh pandian29-Jun-07 4:16 
GeneralRe: Wizard Control - Finish Button Validation - PROBLEM Pin
Jagadeesh Jupalli29-Jun-07 18:10
Jagadeesh Jupalli29-Jun-07 18:10 
Questionbased on cell datagrid dropdown value want to change..., Pin
Member 387988129-Jun-07 3:18
Member 387988129-Jun-07 3:18 
AnswerRe: based on cell datagrid dropdown value want to change..., Pin
Pallavi Bhoite29-Jun-07 19:10
Pallavi Bhoite29-Jun-07 19:10 
Questionmailmessage headers Pin
hkchauhan29-Jun-07 3:05
hkchauhan29-Jun-07 3:05 
AnswerRe: mailmessage headers Pin
Sathesh Sakthivel29-Jun-07 3:12
Sathesh Sakthivel29-Jun-07 3:12 
Questionproblem in migrating from asp to asp.net 1.x Pin
Narendra Mohan29-Jun-07 2:54
Narendra Mohan29-Jun-07 2:54 
AnswerRe: problem in migrating from asp to asp.net 1.x [modified] Pin
divyesh143229-Jun-07 3:09
divyesh143229-Jun-07 3:09 
GeneralRe: problem in migrating from asp to asp.net 1.x Pin
Not Active29-Jun-07 3:23
mentorNot Active29-Jun-07 3:23 
GeneralRe: problem in migrating from asp to asp.net 1.x Pin
Narendra Mohan29-Jun-07 4:18
Narendra Mohan29-Jun-07 4:18 
GeneralRe: problem in migrating from asp to asp.net 1.x Pin
Narendra Mohan29-Jun-07 5:45
Narendra Mohan29-Jun-07 5:45 
AnswerRe: problem in migrating from asp to asp.net 1.x Pin
Not Active29-Jun-07 3:17
mentorNot Active29-Jun-07 3:17 
GeneralRe: problem in migrating from asp to asp.net 1.x Pin
Narendra Mohan29-Jun-07 4:05
Narendra Mohan29-Jun-07 4:05 
GeneralRe: problem in migrating from asp to asp.net 1.x Pin
Not Active29-Jun-07 4:25
mentorNot Active29-Jun-07 4:25 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.