Store procedure

Richa Chunekar

i have made a function in class file to call store procedure to fatch data from data base, the function is written below.

public DataTable odrsrch()
{
using (SqlConnection connection = new SqlConnection(GetConnectionString()))
{
connection.Open();
SqlCommand com = new SqlCommand("ordersp", connection);
com.CommandType = CommandType.StoredProcedure;

SqlDataAdapter adp = new SqlDataAdapter(com);
DataSet ds = new DataSet();
adp.Fill(ds, "ordersp");
connection.Close();
return ds.Tables[0];
}
}

and at button i have called the mathed using class object, but i am not getting result.

protected void btnsrch_Click(object sender, EventArgs e)
{
ordercls oc = new ordercls();
string srch = Convert.ToString(txtsrch.Text).Trim();
DataTable objdt = oc.odrsrch();
gv.DataSource = objdt;
gv.DataBind();

}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta8y ago
Accepted answer
Have you tried calling SP in SSMS? Does it returns any value?

You have to share your SP
Nitin Sontakke8y ago
1/ You have declared a string variable called srch but have never used it effectively at all. Not being passed to sp as a parameter or anything like that.

2/ Do not use variable names, column names, stored procedures like "odrsrch". What is this? And most importantly why unnecessary cryptic names? Give proper names like OrderSearch or SearchOrders. You have done this everywhere, txtsrch? why not txtSearch?

3/ So far as possible use DataReader and List of custom class for example, List. Try not to use data adataptor, data set and data table. These are strain on memory and honestly overkill and expensive option to perform something very simple.