Help

Question

Sir/Madam I have doubt with calling stored procedure from front end. Create Procedure ProcedureName (@Input1 DataType @Input2 DataType) AS Begin SELECT * FROM Table1 Insert INTO Table1 VALUES(@Input1 @Input2) End In the above procedure how to get value for select command. With Regards Gomathi.P

R J · Answer

Create Procedure ProcedureName (@Input1 DataType @Input2 DataType) AS Begin SELECT * FROM Table1 Insert INTO Table1 VALUES(@Input1 @Input2) SELECT * FROM Table1 End ------- now execute the stored procedure like this exec ProcedureName 'input1'  'input2' -----

Gomathi Palaniswamy · Answer

Hi friend Is it possible to exec select command alone with this procedure? With Regards Gomathi.P

R J · Answer

hi.. to call the stored procedure from front end... follow this 1. Create a new C# Windows Application project. 2. From the Toolbox drag and drop a DataGrid onto the Form. Resize it as necessary. 3. Double-click on the Form to generate the Form_Load event handler. Before entering any code add using System.Data.SqlClient at the top of the file. Enter the following code: private void Form1_Load( object sender System.EventArgs e) { SqlConnection conn = new SqlConnection(Data Source=localhost;Database=databasename;Integrated Security=SSPI); SqlCommand command = new SqlCommand(Procedurename conn); SqlDataAdapter adapter = new SqlDataAdapter(command); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(@Input1 SqlDbType.Datatype).Value = input1; command.Parameters.Add(@Input2 SqlDbType.datatype).Value = input2; int rows = command.ExecuteNonQuery(); // to show gridview with ur table data DataSet ds = new DataSet(); adapter.Fill(ds tablename); this .dataGrid1.DataSource = ds; this .dataGrid1.DataMember = tablename; } if my answer helps you click on accept answer... @ J R

Manikavelu Velayutham · Answer

Modify your procedure as below Create Procedure ProcedureName (@Input1 DataType @Input2 DataType) AS Begin SELECT * FROM Table1 Insert INTO Table1 VALUES(@Input1 @Input2) SELECT * FROM Table1 End