Comments by rajah rajah (Top 19 by date)

Thanks chris

if we want to do without having XML below one is the only solution to pass values to a SP . right ?


create procedure insert_data
(
@Id int, @Name Varchar(20) , @address varchar(50)
)
begin

Insert into table1(Id,Name,address) values(@Id,@Name,@address)

end


sqlConnection con = new SqlConnection(dbConnectionString);
SqlCommand comm= new SqlCommand("insert_data", con);
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.Add("@Id", SqlDbType.VarChar).Value = txtId.Text;
comm.Parameters.Add("@Name", SqlDbType.DateTime).Value = txtName.Text;
comm.Parameters.Add("@Address", SqlDbType.DateTime).Value = txtaddress.Text;
sqlConnection.Open();
return comm.ExecuteNonQuery();
sqlConnection.Close();