> CLICK HERE PS: I am assuming you are referring to a PL/SQL Stored Procedure. 'Hope it helps.

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(); } }

हेहे स्तोर प्रोसीदुर को कोइसन नि साझा मा सोध्ने हो त !!! अलि खतरा देदीक्एतेत फोरम मा गएर सोध्ने नि !!! :D

Read this book.. http://www.quantrimang.com/download/ebooks/(ebook%20pdf)%20Teach%20Yourself%20SQL%20in%2021%20Days.pdf