how i can get parameter value from data base in c#

[preeti13]

i have a store procedure need to get the date from the data base help me please with this. i know something missing in the code right here:

da.SelectCommand.Parameters.Add(new SqlParameter("@Datecreated",SqlDbType.DateTime));

 
    private void Page_Load(object sender, System.EventArgs e)
        {
            // Put user code to initialize the page here
 
            string employeenominationid;
            employeenominationid=Request.QueryString ["employeenominationid"];
 
 
         SqlConnection oConn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["oConn"]);
 
            SqlDataAdapter da=new SqlDataAdapter("up_reason",oConn);
 
            DataSet ds=new DataSet(); 
 
            da.SelectCommand.CommandType=CommandType.StoredProcedure;
 
            da.SelectCommand.Parameters.Add(new SqlParameter("@employeenominationid",employeenominationid));
            //SqlParameter obj=new SqlParameter("@EmployeeNominationid",SqlDbType.Int);
            da.SelectCommand.Parameters.Add(new SqlParameter("@Datecreated",SqlDbType.DateTime));
 
            oConn.Open();
            da.SelectCommand.ExecuteNonQuery();
            oConn.Close();
 
            da.Fill(ds) ;
 
            this.garidreason.DataSource=ds;
            this.DataBind();
 
            da.Dispose(); 
}
 
 
 

[weaknessforcats]

I am moving this to the .NET forum.

[kenobewan]

How do you know its not working? Do you get any errors? Have you tried using a try catch block?

[Divya08]

do you want the date value retrieved from the database ie via SP.
If this is ur requirement have you declared the data parameter as out in SP. If yes then u have to specify the parameter direction as output in .cs file