exec spname '+ txt1.Text+','+ txt2.Text+'
SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@value1", txt1.Text); param[1] = new SqlParameter("@value2", txt2.Text); DataTable objDataTable = new DataTable(); SqlConnection objConnection = new SqlConnection(sConnString); objConnection.Open(); SqlCommand objCommand = new SqlCommand("spname", objConnection) { CommandType = CommandType.StoredProcedure }; objCommand.Parameters.AddRange(param); objCommand.CommandTimeout = 0; SqlDataAdapter objDataAdapter = new SqlDataAdapter(objCommand); objDataAdapter.Fill(objDataTable);
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)