Hi! Vandam
check this site
www.w3schools.com go to chmpdf.com and download e-book of SQL server
or
here is the sample code:
//stored procedure with parameters
protected void btnParameter_Click(object sender, EventArgs e)
{
string constring = "Data Source=UTTAM;Initial Catalog=Ship;Integrated Security=True";
SqlConnection con = new SqlConnection(constring);
int phon=0;
try
{
con.Open();
SqlCommand command = new SqlCommand();
command.Connection = con;
command.CommandText = "sp_getByPhone";
command.CommandType = CommandType.StoredProcedure;
SqlParameter param = command.Parameters.AddWithValue("@Phone", TextBox1.Text);
param.Direction = ParameterDirection.Input;
param.DbType = DbType.Int32;
SqlDataAdapter adaptor = new SqlDataAdapter();
adaptor.SelectCommand = command;
DataSet data = new DataSet();
adaptor.Fill(data, "Shippers");
DataTable table = data.Tables["Shippers"];
GridView2.DataSource = table;
GridView2.DataBind();
}
finally
{
con.Close();
}
}
