stored procedure using dataadapter

Question

I would like to get the results of stored procedure using a data adapter and data set by passing input parameters. How do I do this? Any suggestions or solutions would be appreciated. Thanks!!!

arjun · Answer

hi hope this may help u..... sqlconnection con=new sqlconnection(conectionString); sqlcommand cmd=new sqlcommand(SP_namecon); cmd.commandtype=CommandType.StoredProcedure; cmd.parameters.addwithvalue(@param_nameparameter value here); sqldataAdapter sda=new sqldataAdapter(cmd); dataset ds=new dataset(); sda.Fill(ds); get values from dataset like ds.Tabels[0].rows[0].columns[0].values sothing like....

Satyapriya Nayak · Answer

http://www.c-sharpcorner.com/UploadFile/dclark/UseSPwithDP11282005035417AM/UseSPwithDP.aspx