I can't find how to do this on google anywhere. How do you save to a SQL DB using just C# code? Is it possible? The save method that comes default when you create a DB using the wizard dosen't actually save the DB:
this.Validate();
this.studentsBindingSource.EndEdit();
this.studentsTableAdapter.Update(this.studentsDataSet.FirstClass);
It looks to me as though you are doing it correctly.
You should check your table adapter and verify that there is an update statement assigned. If you're using sprocs and only have the select sproc assigned then it'll be read only (and won't prompt you for the update/insert/delete sprocs).
I can't get it to execute my query because I don't know how to do the connection string thing:
private void button1_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("server=localhost;db=Database1;");
SqlCommand x = new SqlCommand("SELECT ID, Name FROM People", conn);
MessageBox.Show(x.ExecuteReader().ToString());
}
Your connection string can be a few things depending on how you are configured to log into SQL.
Data Source=ServerName;Initial Catalog=DatabaseName;User Id=myUsername;Password=myPassword;
or
Data Source=ServerName;Initial Catalog=DatabaseName;Integrated Security=SSPI;
The latter is if you are using Windows Authentication; i.e. using the same user account you log into windows with.
DataSource is usually your machine's name or you can use (local) to get you over the hump should it be on the same machine you are working on.
i want to develop a c# program to display two shapes(circle and rectangle). the two shapes is enclosed within another rectangle. both shapes moves about inside the outer rectangle. then when you click on either of the shapes, it change to the second one and the position or co-ordinate(x,y) on which the shape is clicked is stored in database. Finally pressing escape exit the application but the total sum of x and y is displayed before exiting.