what is the problem with this code in c#

Question

hello friends

        this is my code to get data from database table.

try
{
Dob.open();
SqlCommand cmd6 = new SqlCommand("sp_combo1", Dob.con);
cmd6.CommandType = CommandType.StoredProcedure;
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = cmd6;
DataSet ds = new DataSet();
sda.Fill(ds);
DataTable dt = ds.Tables["Acadamic_year"];
return dt;
What is the error in this code.dateset does not getting table from database.

Hemant Kumar · Answer

baskaran chellasamy  You have to pass the Parameter as given below try { Dob .open(); SqlCommand cmd6 = new SqlCommand ( sp_combo1  Dob .con); cmd6.CommandType = CommandType .StoredProcedure; SqlDataAdapter sda = new SqlDataAdapter (cmd6Dob); cmd6.Parameter.AddWithValue(@InDateDateTime.Now); DataSet ds = new DataSet (); sda.Fill(ds); DataTable dt = ds.Tables[ Acadamic_year ]; return dt; } catch(Exception ex) { } refer this link http://stackoverflow.com/questions/3806229/how-to-pass-value-to-a-stored-procedure-using-c-sharp

baskaran chellasamy · Answer

thanks for reply.i solved this problem.my problem was that i didnt add table name in dateset filling condition as a parameter.and one more thing i have declare datetime for localvariable in storeprocedure parameter. how to pass value for this value at the time of execution.

Santhosh Kumar Jayaraman · Answer

Dude  whats your connection ?? you said Dob.Open() and in the command you said Dob.con

Hemant Kumar · Answer

Whas is this Dob?If this is a SqlConnection object then you need to pass that object to the DataAdapter. try { Dob .open(); SqlCommand cmd6 = new SqlCommand ( sp_combo1  Dob .con); cmd6.CommandType = CommandType .StoredProcedure; SqlDataAdapter sda = new SqlDataAdapter (cmd6Dob); DataSet ds = new DataSet (); sda.Fill(ds); DataTable dt = ds.Tables[ Acadamic_year ]; return dt;