Click here to Skip to main content
15,926,703 members
Home / Discussions / C#
   

C#

 
GeneralRe: Windows collision Pin
MasterSharp14-Oct-07 7:23
MasterSharp14-Oct-07 7:23 
GeneralRe: Windows collision Pin
Kristian Sixhøj14-Oct-07 7:27
Kristian Sixhøj14-Oct-07 7:27 
GeneralRe: Windows collision Pin
MasterSharp14-Oct-07 7:30
MasterSharp14-Oct-07 7:30 
Generalcarrer gudiance Pin
sid_si14-Oct-07 4:56
sid_si14-Oct-07 4:56 
GeneralRe: carrer gudiance Pin
J4amieC14-Oct-07 5:15
J4amieC14-Oct-07 5:15 
GeneralRe: carrer gudiance Pin
sid_si14-Oct-07 5:25
sid_si14-Oct-07 5:25 
Questionhow to write? Pin
s4_sabahatf14-Oct-07 4:24
s4_sabahatf14-Oct-07 4:24 
AnswerRe: how to write? Pin
Roger CS14-Oct-07 6:14
Roger CS14-Oct-07 6:14 
Essentially you have four things you can do: SELECT, INSERT, UPDATE and DELETE. When you edit a record you first SELECT the record, make changes then use UPDATE to save the changes to the database. Go to msdn.com and click the Library link, search for OleDbDataAdapter. Here's an example from...

<br />
public DataSet CreateCmdsAndUpdate(DataSet myDataSet,string myConnection,string mySelectQuery,string myTableName) <br />
{<br />
    OleDbConnection myConn = new OleDbConnection(myConnection);<br />
    OleDbDataAdapter myDataAdapter = new OleDbDataAdapter();<br />
    myDataAdapter.SelectCommand = new OleDbCommand(mySelectQuery, myConn);<br />
    OleDbCommandBuilder custCB = new OleDbCommandBuilder(myDataAdapter);<br />
<br />
    myConn.Open();<br />
<br />
    DataSet custDS = new DataSet();<br />
    myDataAdapter.Fill(custDS);<br />
<br />
    //code to modify data in dataset here<br />
<br />
    myDataAdapter.Update(custDS, myTableName);<br />
<br />
    myConn.Close();<br />
<br />
    return custDS;<br />
 }<br />

QuestionOleDB Pin
s4_sabahatf14-Oct-07 4:10
s4_sabahatf14-Oct-07 4:10 
AnswerRe: OleDB Pin
Hesham Amin14-Oct-07 4:31
Hesham Amin14-Oct-07 4:31 
QuestionMethod timeout Pin
martin_hughes14-Oct-07 3:40
martin_hughes14-Oct-07 3:40 
AnswerRe: Method timeout Pin
TJoe15-Oct-07 4:07
TJoe15-Oct-07 4:07 
QuestionToolTip Pin
half-life14-Oct-07 2:51
half-life14-Oct-07 2:51 
AnswerRe: ToolTip Pin
il_masacratore14-Oct-07 21:26
il_masacratore14-Oct-07 21:26 
Questionget the local system's ipaddress Pin
karthick.n.mca14-Oct-07 2:30
karthick.n.mca14-Oct-07 2:30 
AnswerRe: get the local system's ipaddress Pin
pmarfleet14-Oct-07 2:45
pmarfleet14-Oct-07 2:45 
GeneralRe: get the local system's ipaddress Pin
karthick.n.mca14-Oct-07 3:21
karthick.n.mca14-Oct-07 3:21 
GeneralRe: get the local system's ipaddress Pin
pmarfleet14-Oct-07 3:41
pmarfleet14-Oct-07 3:41 
QuestionAbout keyword "out " Pin
jason_mf14-Oct-07 2:16
jason_mf14-Oct-07 2:16 
AnswerRe: About keyword "out " Pin
Luc Pattyn14-Oct-07 2:30
sitebuilderLuc Pattyn14-Oct-07 2:30 
QuestionDataGridView Pin
karoitay14-Oct-07 0:26
karoitay14-Oct-07 0:26 
AnswerRe: DataGridView Pin
Justin Perez14-Oct-07 0:42
Justin Perez14-Oct-07 0:42 
QuestionTransfer Value from Data Grid on one form to text box in another form Pin
Student1113-Oct-07 13:07
Student1113-Oct-07 13:07 
AnswerRe: Transfer Value from Data Grid on one form to text box in another form Pin
Christian Graus13-Oct-07 14:19
protectorChristian Graus13-Oct-07 14:19 
QuestionSquares Pin
MasterSharp13-Oct-07 12:05
MasterSharp13-Oct-07 12:05 

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.