This is code for submit, update, delete in Window Form C#.

Code For Submit

private void Submit_txt_Click(object sender, EventArgs e)

{

string str = "server = MUNESH\\SQL2008R2;Database=datastore;UID=sa;Password=123;";

SqlConnection con = new SqlConnection(str);

string query = "insert into table(ID,Name,Father) values('" + this.id_txt.Text + "','" + this.textBox1.Text + "','" + this.textBox2.Text +"')";

SqlCommand cmd = new SqlCommand(query, con);

SqlDataReader dbr;

try

{

con.Open();

dbr = cmd.ExecuteReader();

// MessageBox.Show("save");

MessageBox.Show("Records saved successfully", "user information");

while (dbr.Read())

{

}

textBox2.Text = string.Empty;

textBox3.Text = string.Empty;

id_txt.Text = string.Empty;

con.Close();

}

Code For Update

private void Update_txt_Click(object sender, EventArgs e)

{

string str = "server = MUNESH\\SQL2008R2;Database=datastore;UID=sa;Password=123;";

SqlConnection con = new SqlConnection(str);

string query = "UPDATE data1 set Name = '" + this.textBox1.Text + "', Father = '" + this.textBox2.Text + "' where ID= '" + this.id_txt.Text + "' ";

SqlCommand cmd = new SqlCommand(query, con);

SqlDataReader myreader;

try

{

con.Open();

myreader = cmd.ExecuteReader();

MessageBox.Show(" successfully record Updated", "user information");

while (myreader.Read())

{

}

con.Close()

}

catch (Exception ec)

{

MessageBox.Show(ec.Message);

}

}

Code For Delete

private void Delete_txt_Click(object sender, EventArgs e)

{

if (!(id_txt.Text == string.Empty))

{

string str = "server = MUNESH\\SQL2008R2;Database=datastore;UID=sa;Password=reladmin@123;";

SqlConnection con = new SqlConnection(str);

string query = "Delete from data1 where ID= '" + this.id_txt.Text + "'";

SqlCommand cmd = new SqlCommand(query, con);

SqlDataReader myreader;

try

{

con.Open();

myreader = cmd.ExecuteReader();

MessageBox.Show("successfully data Deleted","user information");

while (myreader.Read())

{

}

con.Close();

}

catch (Exception ec)

{

MessageBox.Show(ec.Message);

}

}

else

{

MessageBox.Show("enter ID which you want to delete","User information");

}

}