No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
1 Posted Topic
[code=c#]SqlConnection con = new SqlConnection("server=.;database=Emp;uid=sa;pwd=sa"); con.Open(); SqlCommand cmd = new SqlCommand("Update emp set=Emp_Id where Emp_Name,Emp_Address,Emp_Sal", con); //cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter ("@name",SqlDbType.NVarChar,50)); cmd.Parameters["@name"].Value =TextBox2.Text; cmd.Parameters.Add(new SqlParameter("@add", SqlDbType.NVarChar,50)); cmd.Parameters["@add"].Value = TextBox3.Text; cmd.Parameters.Add(new SqlParameter("@sal", SqlDbType.Money,8)); cmd.Parameters["@sal"].Value = TextBox4.Text; cmd.ExecuteNonQuery(); Response.Write("Record Updated"); con.Close();[/code]
The End.