No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
[CODE] Protected void Update(object sender, GridViewCommandEventsArg e) { if(e.CommandName == "Change") { int index = GridViewemp.EditIndex; GridViewRow grid = GridViewemp.Rows[index]; TextBox salary = (TextBox)GridViewemp.FindControl("TextBoxsalary"); sqlcon.Open(); string query = "Update Employee set Salary="+salary.Text+"where EmpID ="+GridViewemp.SelectedDataKey.Value.ToString(); sqlcom = new SqlCommand(query, sqlcon); sqlcom.ExecuteNonQuery(); sqlcon.Close(); } } [/CODE] I am getting the error Error: …
|
|
|
I am writing an output stored procedure that i access using c#. I am trying to print the output values from the stored procedure. [code] using (SqlConnection connection = new SqlConnection(connectionstring)) { connection.Open(); SqlCommand emailcmdsql; emailcmdsql = new SqlCommand("returnemail", connection); emailcmdsql.CommandType = CommandType.StoredProcedure; SqlParameter paruser = emailcmdsql.Parameters.Add("@user", SqlDbType.VarChar); paruser.Value = … 
|