Click here to Skip to main content
15,877,246 members
Home / Discussions / Database
   

Database

 
GeneralRe: datetime problem Pin
FishiFishi28-Jun-07 3:16
FishiFishi28-Jun-07 3:16 
AnswerRe: datetime problem Pin
Pratik Vasant Shah28-Jun-07 20:19
Pratik Vasant Shah28-Jun-07 20:19 
Questionhow to pass null values to a query in the design time Pin
pashitech28-Jun-07 0:12
pashitech28-Jun-07 0:12 
AnswerRe: how to pass null values to a query in the design time Pin
Xandip28-Jun-07 20:13
Xandip28-Jun-07 20:13 
QuestionDate Time String Transformation sample mssql Pin
cutequencher27-Jun-07 23:18
cutequencher27-Jun-07 23:18 
AnswerRe: Date Time String Transformation sample mssql Pin
andyharman28-Jun-07 0:18
professionalandyharman28-Jun-07 0:18 
GeneralRe: Date Time String Transformation sample mssql Pin
cutequencher28-Jun-07 0:39
cutequencher28-Jun-07 0:39 
Questionsql data adapter.update Pin
Sebastian T Xavier27-Jun-07 22:42
Sebastian T Xavier27-Jun-07 22:42 
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: sql data adapter.update Pin
Vimalsoft(Pty) Ltd28-Jun-07 22:35
professionalVimalsoft(Pty) Ltd28-Jun-07 22:35 
QuestionMySQL - C# - problem with charset encoding Pin
yarns27-Jun-07 22:26
yarns27-Jun-07 22:26 
AnswerRe: MySQL - C# - problem with charset encoding Pin
Giorgi Dalakishvili27-Jun-07 22:45
mentorGiorgi Dalakishvili27-Jun-07 22:45 
GeneralRe: MySQL - C# - problem with charset encoding Pin
yarns27-Jun-07 22:51
yarns27-Jun-07 22:51 
GeneralRe: MySQL - C# - problem with charset encoding Pin
Giorgi Dalakishvili27-Jun-07 22:53
mentorGiorgi Dalakishvili27-Jun-07 22:53 
GeneralRe: MySQL - C# - problem with charset encoding Pin
yarns27-Jun-07 23:19
yarns27-Jun-07 23:19 
GeneralRe: MySQL - C# - problem with charset encoding Pin
Giorgi Dalakishvili27-Jun-07 23:24
mentorGiorgi Dalakishvili27-Jun-07 23:24 
QuestionSaving Sybase Data to Excel Pin
meeram39527-Jun-07 20:26
meeram39527-Jun-07 20:26 
QuestionSQL Server 2005 Reporting Services Pin
Pratik Vasant Shah27-Jun-07 19:38
Pratik Vasant Shah27-Jun-07 19:38 
AnswerRe: SQL Server 2005 Reporting Services Pin
martin_hughes28-Jun-07 8:20
martin_hughes28-Jun-07 8:20 
QuestionRe: SQL Server 2005 Reporting Services Pin
Pratik Vasant Shah28-Jun-07 20:21
Pratik Vasant Shah28-Jun-07 20:21 
AnswerRe: SQL Server 2005 Reporting Services Pin
martin_hughes29-Jun-07 1:35
martin_hughes29-Jun-07 1:35 
QuestionSQL Inner Join? Pin
Expert Coming27-Jun-07 14:56
Expert Coming27-Jun-07 14:56 
AnswerRe: SQL Inner Join? Pin
Chinnakasu27-Jun-07 16:31
Chinnakasu27-Jun-07 16:31 
AnswerRe: SQL Inner Join? Pin
Guffa27-Jun-07 20:51
Guffa27-Jun-07 20:51 
QuestionVB.Net 64 bit long to SQL [modified] Pin
Polymorpher27-Jun-07 12:18
Polymorpher27-Jun-07 12:18 
AnswerRe: VB.Net 64 bit long to SQL Pin
Mike Dimmick27-Jun-07 23:13
Mike Dimmick27-Jun-07 23:13 

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.