hi ramesh u can use stored procedures in c# as
SqlConnection conn = new SqlConnection("connectionString");
SqlCommand command = new SqlCommand("storedProcedurename", conn);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("parametername1", SqlDbType.VarChar).Value =somevalue;
command.Parameters.Add("parametername2", SqlDbType.VarChar).Value = somevalue;
.
.
.
.
.
like this u can call stored procedure in c# and u can pass parameters to stored procedures
conn.Open();
int rows = command.ExecuteNonQuery();
conn.Close();
rameshmandapelly-7781, if this helps please login to Mark As Answer. | Alert Moderator