private void txtName_KeyDown(object sender, KeyEventArgs e)
{
SqlDataAdapter DA = new SqlDataAdapter("Search_Student",
DBConnection.GetConnection());
DA.SelectCommand.CommandType = CommandType.StoredProcedure;
DA.SelectCommand.Parameters["@FirstName"].Value = (txtName.Text).Trim();
DataTable DA1 = new DataTable();
DA.Fill(DA1);
dataGridView1.DataSource = DA1;
}
-
Just curious. Is there a reason you aren't using something like EntityFramework?Cubicle.Jockey– Cubicle.Jockey2013-07-25 06:50:52 +00:00Commented Jul 25, 2013 at 6:50
Add a comment
|
4 Answers
you have to Add parameter first before assign value of parameter
SqlDataAdapter DA = new SqlDataAdapter("Search_Student",
DBConnection.GetConnection());
DA.SelectCommand.CommandType = CommandType.StoredProcedure;
SqlParameter param = new SqlParameter();
param.ParameterName = "@FirstName";
param.Value = txtName.Text;
DA.SelectCommand.Parameters.Add(param);
DataTable DA1 = new DataTable();
DA.Fill(DA1);
dataGridView1.DataSource = DA1;
Comments
Change you code as, You have not added parameter to command parameter collection.
DA.SelectCommand.Parameters.AddWithValue("@FirstName", txtName.Text.Trim());
Above perform both
Comments
You should use
DA.SelectCommand.Parameters.Add("@FirstName", txtName.Text.Trim());
Comments
Try following:
var paramFName = e.Command.CreateParameter("@FirstName", (txtName.Text).Trim());
e.Command.Parameters.Add(paramFName);
