Calling stored procedure in asp.net

Question

Hi I want to call a stored procedure and bind it to Gridview control... I am using datasets..How do i bind it?

Mayur Gujrathi · Answer

What problem you are facing?

Kavita B · Answer

Not yet

Mayur Gujrathi · Answer

Kavita Query resolved?

Mayur Gujrathi · Answer

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

Jiteendra Sampathirao · Answer

Download the code from this page and check it out... you will definitely get an idea... http://www.c-sharpcorner.com/UploadFile/jitendra1987/3848/

Kavita B · Answer

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 NameAddressPhone 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 NameAddressPhone from Details

Praneeth Kumar · Answer

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

Jiteendra Sampathirao · Answer

Hi Go through this link.. http://www.c-sharpcorner.com/UploadFile/jitendra1987/3848/

Suthish Nair · Answer

refer article DataGridView - Insert Update Delete and Retrieve records using stored procedure

Kiran Karale · Answer

//Declaration SqlCommand cmd; SqlDataAdapter da; DataSet ds; // // Write code for Click Event // cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = Select_Procedure; cmd.Connection = con; con.Open(); SqlParameter tablename = new SqlParameter(@tablenameparam); cmd.Parameters.Add(tablename); da = new SqlDataAdapter(cmd); ds = new DataSet(); da.Fill(ds Table); GridView1.DataSource = ds; GridView1.DataBind();

Gowtham manju · Answer

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_logincon);//where proc_login is the procedure name u have created cmd.command type=comandtype.storedprocedure; cmd.parameters.add(@unsqldbtype.varchar).value=textboxname.text; cmd.parameters.add(@pwdsqldbtype.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