Click here to Skip to main content
15,922,584 members
Home / Discussions / C#
   

C#

 
AnswerRe: XamlParseException whenever assigning values to C# class member Pin
Ed.Poore23-Jun-07 9:52
Ed.Poore23-Jun-07 9:52 
AnswerRe: XamlParseException whenever assigning values to C# class member Pin
WillemM23-Jun-07 10:16
WillemM23-Jun-07 10:16 
QuestionAbstract and inheriting Pin
Brendan Vogt23-Jun-07 7:04
Brendan Vogt23-Jun-07 7:04 
AnswerRe: Abstract and inheriting Pin
DavidNohejl23-Jun-07 7:16
DavidNohejl23-Jun-07 7:16 
AnswerRe: Abstract and inheriting Pin
Luc Pattyn23-Jun-07 9:16
sitebuilderLuc Pattyn23-Jun-07 9:16 
QuestionIs Unicode or not? Pin
Dominik Reichl23-Jun-07 5:56
Dominik Reichl23-Jun-07 5:56 
AnswerRe: Is Unicode or not? Pin
Giorgi Dalakishvili23-Jun-07 6:16
mentorGiorgi Dalakishvili23-Jun-07 6:16 
QuestionUpdate Database from DataSet Question Pin
Rick van Woudenberg23-Jun-07 1:59
Rick van Woudenberg23-Jun-07 1:59 
Dear all,

I have the following code :

private void button2_Click(object sender, EventArgs e)<br />
        {<br />
<br />
            // Create a new Connection and SqlDataAdapter<br />
<br />
            NpgsqlConnection conn = new NpgsqlConnection("Server=192.168.24.24;Port=5432;User Id=postgres;Password=S3cr33t;Database=Database;");<br />
<br />
            NpgsqlDataAdapter mySqlDataAdapter = new NpgsqlDataAdapter("Select * from points", conn);<br />
            DataSet myDataSet = new DataSet();<br />
            DataRow myDataRow;<br />
<br />
            // Create command builder. <br />
            <br />
            NpgsqlCommandBuilder myCommandBuilder = new NpgsqlCommandBuilder(mySqlDataAdapter);<br />
<br />
            mySqlDataAdapter.Fill(myDataSet, "points");<br />
            myDataRow = myDataSet.Tables["points"].NewRow();<br />
           <br />
<br />
                myDataSet.Tables["points"].Rows.Add(myDataRow);<br />
<br />
                foreach (DataRow myDataRow1 in myDataSet.Tables["points"].Rows)<br />
                {<br />
                myDataSet.Tables["points"].Rows[0]["track_easting"] = "665544";<br />
            }<br />
            mySqlDataAdapter.Update(myDataSet, "points");<br />
        }


This code 'appears' to run fine. However, if I check back in the database, it has only updated the first row. But I want it to update every single row in the Dataset / Database. So I dreamed up the Foreach statement but I think I'm using it wrong. Can someone point me in the right direction ?

Cheers
AnswerRe: Update Database from DataSet Question Pin
Luc Pattyn23-Jun-07 2:12
sitebuilderLuc Pattyn23-Jun-07 2:12 
AnswerRe: Update Database from DataSet Question Pin
PaulPrice23-Jun-07 2:25
PaulPrice23-Jun-07 2:25 
GeneralRe: Update Database from DataSet Question Pin
Rick van Woudenberg23-Jun-07 2:30
Rick van Woudenberg23-Jun-07 2:30 
GeneralRe: Update Database from DataSet Question Pin
Luc Pattyn23-Jun-07 2:46
sitebuilderLuc Pattyn23-Jun-07 2:46 
GeneralRe: Update Database from DataSet Question Pin
PaulPrice24-Jun-07 21:26
PaulPrice24-Jun-07 21:26 
Questionhow to use Rdlc Report to Run Time Pin
imran_Shaikh23-Jun-07 1:08
imran_Shaikh23-Jun-07 1:08 
QuestionCross development platform form embedding. Pin
daviiie23-Jun-07 0:20
daviiie23-Jun-07 0:20 
AnswerRe: Cross development platform form embedding. Pin
Kevin McFarlane23-Jun-07 0:36
Kevin McFarlane23-Jun-07 0:36 
QuestionDataTable performance issue. Pin
syntaxed22-Jun-07 21:58
syntaxed22-Jun-07 21:58 
AnswerRe: DataTable performance issue. Pin
kubben23-Jun-07 1:55
kubben23-Jun-07 1:55 
GeneralRe: DataTable performance issue. Pin
syntaxed24-Jun-07 18:58
syntaxed24-Jun-07 18:58 
GeneralRe: DataTable performance issue. Pin
kubben25-Jun-07 1:35
kubben25-Jun-07 1:35 
GeneralRe: DataTable performance issue. Pin
syntaxed25-Jun-07 22:06
syntaxed25-Jun-07 22:06 
AnswerRe: DataTable performance issue. Pin
Malcolm Smart23-Jun-07 12:19
Malcolm Smart23-Jun-07 12:19 
GeneralRe: DataTable performance issue. Pin
syntaxed24-Jun-07 19:02
syntaxed24-Jun-07 19:02 
QuestionPopulating the TreeView control from the SQL server in C# .NET application [modified] Pin
thachil22-Jun-07 21:40
thachil22-Jun-07 21:40 
AnswerRe: Populating the TreeView control from the SQL server in C# .NET application Pin
Christian Graus22-Jun-07 21:42
protectorChristian Graus22-Jun-07 21:42 

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.