>these are great examples Bonnie;
>thank you for this great help.

You're welcome, Dave. =0)

>I gather that for updating current records i use the UPDATE - SQL command in Foxpro.
>Because the UPDATE - SQL command in Foxpro has a WHERE clause to limit which records get updated... the only way I can insure only 1 record is updated is by defining in hte WHERE clause the correct value for the primary key.

Of course. I only showed the code for the INSERT and left it to the reader to figure out the code for the DELETE and UPDATE.

Also, I guess I should mention that parameters are treated different for VFP than for the SQL example I posted. Either I forgot or I didn't have time to mention it in my first post ... VFP paramters are specified with a "?" and are positional rather than named. So, in this example:

         sc.CommandText = "Insert into bob (xyz, abc) VALUES ( ?, ? )";
         sc.Parameters.Clear();
         sc.Parameters.Add("xyz", Row["xyz"]);
         sc.Parameters.Add("abc", Row["abc"]);

... the first "?" corresponds to the first parameter, "xyz" in this case, the second "?" is the second parameter, etc.

~~Bonnie


>
>I'd like to examine one of your solutions in detail to insure I understand the concepts.
>

>public void UpdateMyData(DataSet ds)
>{
>	// I wouldn't actually hard-code the connection string here, it should be in your config settings
>	string TestConnection = "server=(local);database=MyDataBase;uid=sa;pwd=MyPassword";
>
>SqlCommand sc = new SqlCommand();
>sc.Connection = new SqlConnection(TestConnection);
>sc.Connection.Open();
>foreach (DataRow Row in ds.Tables[0].Rows)
>   {
>   switch (Row.RowState)
>      {
>         case DataRowState.Added :
>
>         sc.CommandText = "Insert into bob (xyz, abc) VALUES ( @xyz, @abc )";
>         // the item in quotes is basically a foxpro INSERT - SQL command
>
>         sc.Parameters.Clear();
>
>
>
>         sc.Parameters.Add("@xyz", Row["xyz"]);
>         sc.Parameters.Add("@abc", Row["abc"]);
>         // the 2 lines above replace @xyz, @abc in the INSERT command with the actual
>         // contents of the row that is in focus in current iteration of the foreach
>
>         sc.ExecuteNonQuery();
>         // here the changes are committed to the table
>         break;
>				
>			// Do the same for DataRowState Deleted and Modified
>			case DataRowState.Deleted :
>				break;
>			case DataRowState.Modified :
>				break;
>		}
>	}
>	sc.Connection.Close();
>}

>
>I gather that for updating current records i use the UPDATE - SQL command in Foxpro.
>Because the UPDATE - SQL command in Foxpro has a WHERE clause to limit which records get updated... the only way I can insure only 1 record is updated is by defining in hte WHERE clause the correct value for the primary key.