quote:

---

Originally posted by messi

SqlConnection testcon = new SqlConnection(con);
SqlCommand command = new SqlCommand("NewEmp", testcon);
command.CommandType = CommandType.StoredProcedure;
testcon.Open();
command.Parameters.Add("@Name", SqlDbType.NVarChar).Value = txtname.Text;
command.Parameters.Add("@Branch", SqlDbType.NVarChar).Value = txtbranch.Text;
command.Parameters.Add("@Salary", SqlDbType.Int).Value = txtsalary.Text;
command.ExecuteNonQuery();
testcon.Close();
txtbranch.Text = "";
txtname.Text = "";
txtsalary.Text = "";

can any one help

---

quote:

---

Originally posted by visakh16

can you post the procedure code too? Also did you try running profiler trace to see if save is happening?

---

Create Proc NewEmp
(@name nvarchar(50),@Branch nvarchar(50),@Salary int)
As
insert into Employees (Emp_Name,Emp_Branch,Emp_Salary) values (@name ,@branch ,@Salary)

quote:

---

Originally posted by afrika

quote:

---

Originally posted by messi

SqlConnection testcon = new SqlConnection(con);
SqlCommand command = new SqlCommand("NewEmp", testcon);
command.CommandType = CommandType.StoredProcedure;
testcon.Open();
command.Parameters.Add("@Name", SqlDbType.NVarChar).Value = txtname.Text;
command.Parameters.Add("@Branch", SqlDbType.NVarChar).Value = txtbranch.Text;
command.Parameters.Add("@Salary", SqlDbType.Int).Value = txtsalary.Text;
command.ExecuteNonQuery();
testcon.Close();
txtbranch.Text = "";
txtname.Text = "";
txtsalary.Text = "";

can any one help

---

I dont fully understand what you are trying to do, but the line in red closes the connection while the lines in green, set the textboxes to nothing.

What exactly are you trying to do ???

---

quote:

---

Originally posted by afrika

also next time, post this in the .net forum not sql

---