execute a stored procedure with parameter from .net

[simonakiki]

hi

how can if call a strored prosedure from sql server with parameters


my procedure is



ALTER PROCEDURE [dbo].[search_proced] ( @p_version nvarchar(100),
@p_result nvarchar(100),
@Salesman int , @from_Date datetime ,
@to_date datetime )



and i have to use the result in gridview


10x for helping me

[Plater]

Use the SQLCommand object.
Here's how I do it:

DataTable retval = new DataTable();
//dbcon is your database connection object
SqlCommand sc = new SqlCommand("search_proced", dbcon);
sc.CommandType = CommandType.StoredProcedure;
sc.Parameters.Add("@p_version", SqlDbType.NVarChar);
sc.Parameters["@p_version"].Value = "Something";
//
//repeat for your other parameters
//
SqlDataAdapter sda = new SqlDataAdapter(sc);
sda.Fill(retval);
sc.Dispose();
sda.Dispose();
//now "retval" is a DataTable that can be used as a DataSource for your GridView;
 
 

hi
how can if call a strored prosedure from sql server with parameters
my procedure is
ALTER PROCEDURE [dbo].[search_proced] ( @p_version nvarchar(100),
@p_result nvarchar(100),
@Salesman int , @from_Date datetime ,
@to_date datetime )
and i have to use the result in gridview


10x for helping me

[simonakiki]

10x Plater for helping me

i tested ur script and it work fine;