Calling stored procedure in asp.net

What problem you are facing?

Not yet

Kavita
Query resolved?

Do like this


private void fill_grid()
  {
  SqlConnection con = new SqlConnection(@"Data Source=AXIOMSERVER\SQL2005;" + "Initial Catalog=mydata;  Integrated Security=True");
  con.Open();
  SqlCommand cmd = new SqlCommand;
cmd.CommandType=CommandType.StoreProcedure;
cmd.ComandText="Your Stored Procedure Name";

cmd.Connection=con;
  SqlDataAdapter da = new SqlDataAdapter(cmd);

  DataSet ds = new DataSet();
  da.Fill(ds, "Details");

  GridView1.DataSource = ds.Tables["Details"];

  GridView1.DataBind();
}

Download the code from this page and check it out...
you will definitely get an idea...

http://www.c-sharpcorner.com/UploadFile/jitendra1987/3848/

This is my code to fill the grid view:

private void fill_grid()
  {
  SqlConnection con = new SqlConnection(@"Data Source=AXIOMSERVER\SQL2005;" + "Initial Catalog=mydata;  Integrated Security=True");
  con.Open();
  SqlCommand cmd = new SqlCommand("select distinct Name,Address,Phone from Details", con);
  SqlDataAdapter da = new SqlDataAdapter(cmd);
  DataSet ds = new DataSet();
  da.Fill(ds, "Details");

  GridView1.DataSource = ds.Tables["Details"];

  GridView1.DataBind();
}

I want to call the stored procedure here... In the line marked red what changes should i do to call the stored procedure?

My stored procedure which i want to call is :

create procedure select_details
@Name varchar(50),
@Address varchar(50),
@Phone varchar(50)
AS
Select Name,Address,Phone from Details

Grid view binding code behind
 gridViewName.Datasource=;
gridViewName.Databind();

Aspx

 
        
          
        

Hi, Go through this link..

http://www.c-sharpcorner.com/UploadFile/jitendra1987/3848/

 refer article

 DataGridView - Insert, Update, Delete and Retrieve records using stored procedure

create table login and 


copy and paste the coding below

create procedure as

create procedure proc_login
@un varchar(50),
@pwd varchar(50)
as
insert into login values(@un,@pwd)

where login in is the table name

in sourcecode of ur page write coding as

sqlconnection con=new sqlconnection("");

sqlcommand cmd=new sqlcommand("proc_login",con);//where proc_login is the procedure name u have created


cmd.command type=comandtype.storedprocedure;

cmd.parameters.add("@un",sqldbtype.varchar).value=textboxname.text;
 
cmd.parameters.add("@pwd",sqldbtype.varchar).value=textboxname.text;  
 
 con.open();
int rows=cmd.executenonquery();
 con.close();
if(rows==1)
{
messagebox.show("inserted");

 
}else{messagebox.show("error");
}



the above is the sample source for using procedures u can implement it as u like


regards,
gowtham