i am very new to store procedure so if there is small error then also help me to solve it......
i have doing Select,add,update,delete programing with the use of store procedure ... the coding is look like.....
*********store procedure ************
ALTER procedure [dbo].[selectstudent] @firstname varchar(50),@lastname varchar(50),@gender varchar(50),@address varchar(50),@phone varchar(50),@dob datetime,@email varchar(50)
as
select * from student
ALTER procedure [dbo].[insertstudent]
@firstname varchar(50),@lastname varchar(50),@gender varchar(50),@address varchar(50),@phone varchar(50),@dob datetime,@email varchar(50)
as
Insert into Student( firstname, lastname, gender, address, phone, dob, email)
values (@firstname, @lastname, @gender, @address, @phone, @dob, @email)
********************************************************
now aspx.cs file coding..
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
namespace storeprocedure_demo
{
public partial class _Default : System.Web.UI.Page
{
SqlConnection cn = null;
protected void Page_Load(object sender, EventArgs e)
{
cn = new SqlConnection(@"Data Source=PURVPARI-PC\SQLEXPRESS;Initial Catalog=demomydb;Integrated Security=True ");
if (!Page.IsPostBack)
{
fillgrid();
}
}
protected void fillgrid()
{
SqlCommand cm = new SqlCommand("selectstudent", cn);
cm.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cm;
DataSet ds = new DataSet();
cn.Open();
da.Fill(ds, "student");
cn.Close();
gvstudent.DataSource = ds;
gvstudent.DataBind();
}
protected void btnsave_Click(object sender, EventArgs e)
{
cn.Open();
SqlCommand cm = new SqlCommand("insertstudent", cn);
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.Add("@firstname", SqlDbType.VarChar).Value = txtfirstname.Text;
cm.Parameters.Add("@lastname", SqlDbType.VarChar).Value = txtlastname.Text;
cm.Parameters.Add("@gender", SqlDbType.VarChar).Value = txtgender.Text;
cm.Parameters.Add("@address", SqlDbType.VarChar).Value = txtaddress.Text;
cm.Parameters.Add("@phone", SqlDbType.VarChar).Value = txtphone.Text;
cm.Parameters.Add("@dob", SqlDbType.DateTime).Value = Convert.ToDateTime(txtdob.Text);
cm.Parameters.Add("@email", SqlDbType.VarChar).Value = txtemail.Text;
cm.ExecuteNonQuery();
cn.Close();
fillgrid();
}
}
}
now in this coding insertstudent store procedure is perfectly working i have sxuccesfully insert data into table....but i have problem with selectstudent procedure....its shows error like...
Procedure or function 'selectstudent' expects parameter '@firstname', which was not supplied....
so what is the solution..???