what is the problem with this code in c#

baskaran chellasamy

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.

4 Replies

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

Hemant Kumar14y ago
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(cmd6,Dob);
cmd6.Parameter.AddWithValue("@InDate",DateTime.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
0
baskaran chellasamy14y ago
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.
0
Santhosh Kumar Jayaraman14y ago
Dude ,

whats your connection ??

you said Dob.Open()

and in the command you said Dob.con
0
Hemant Kumar14y ago
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(cmd6,Dob);
DataSet ds = new DataSet();
sda.Fill(ds);
DataTable dt = ds.Tables["Acadamic_year"];
return dt;
0