Simple C # Call with SQL stored procedure

Stored Procedure

 

Create proc Test
@ Lc_code varchar (50)
As
Select lc_name from lc_location where lc_code = @ lc_code

Dataset

Sqlconnection conn = new sqlconnection ("Server = dserver; database = lawmanfepos; uid = sa; Pwd = ");
Sqldataadapter SAR = new sqldataadapter ("test", Conn );
Sar. selectcommand. commandtype = commandtype. storedprocedure;
Sar. selectcommand. Parameters. Add ("@ lc_code", sqldbtype. varchar, 50 );
Sar. selectcommand. Parameters ["@ lc_code"]. value = "001 ";

Dataset DS = new dataset ();
Sar. Fill (DS, "AA ");

Datatable dt = Ds. Tables [0];
Datagridview1.datasource = DT;

Datareader

Sqlconnection conn = new sqlconnection ("Server = dserver; database = lawmanfepos; uid = sa; Pwd = ");

Sqlcommand cmd = new sqlcommand ("test", Conn );
Cmd. commandtype = commandtype. storedprocedure;
Cmd. Parameters. Add ("@ lc_code", sqldbtype. varchar, 50 );
Cmd. Parameters ["@ lc_code"]. value = "001 ";

Conn. open ();
sqldatareader SDR = cmd. executereader ();
while (SDR. read ()
{< br> MessageBox. show (SDR ["lc_name"]. tostring ();
}< br>