DEAR ALL,

How to supply parameter to a storedproc from codebehind..


AMR

It all depends on how you will call the sproc:

1) Using a command object: add a parameter to the parameters collection with the details of that param.

2) Plain SQL query: construct the query with the parameter value inline.

You'll need to provide a bit more explanation about how you are building your page if you need more specific advice.

-Peter
peterlanoie.blog

dear planoie,

I am actually using an sqldatasource like sqldatasource="mystoredproc" Commandtype="Storedprocedure".In the sqlServer 2005 i created a storedproc which takes a datetime value.I can exec like exec mystoredproc '04/01/2008'
its working but where to give the parameter value to the stored proc in the code behind....

thank you,
AMR.

There is a filterparameters node of this control. Review the documentation, it should help you.

http://msdn2.microsoft.com/en-us/library/system.web.ui.webcontrols.sqldatasource.filterpara meters(VS.80).aspx

-Peter
peterlanoie.blog

SqlCommand c = new SqlCommand();
            c.CommandType = CommandType.StoredProcedure;
            c.CommandText = "YourStoredProcedureName";

            SqlParameter[] p;
            p[0] = new SqlParameter("@yourdatabaseparametername", DateTime.Now.ToShortDateString());
            c.Parameters.Add(p);

            c.ExecuteReader();

Thanks and Regards,

Senthil Kumar M.