Now take some UI Controls and arrange them like given figure.



Write the following code.

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace storedprocedureinadodotnet
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

SqlConnection conn;
SqlCommand comm;
SqlParameter prn, pname, page, pcity, pcourse; // instance of sqlparameter
string connstring = "database=student;server=.;user=sa;password=wintellect";
private void btnsave_Click(object sender, EventArgs e)
{
conn = new SqlConnection(connstring);
conn.Open();
comm = new SqlCommand();
comm.Connection = conn;
comm.CommandType = CommandType.StoredProcedure;
comm.CommandText = "MYSTOREDPROCEDURE";

prn = new SqlParameter("@rn", SqlDbType.Int);
pname = new SqlParameter("@NAME", SqlDbType.VarChar);
page = new SqlParameter("@AGE", SqlDbType.Int);
pcity = new SqlParameter("@CT", SqlDbType.VarChar);
pcourse = new SqlParameter("@COURSE", SqlDbType.VarChar);

comm.Parameters.Add(prn);
comm.Parameters.Add(pname);
comm.Parameters.Add(page);
comm.Parameters.Add(pcity);
comm.Parameters.Add(pcourse);

prn.Value = Convert.ToInt32(txtrollno.Text );
pname.Value = txtname.Text ;
page.Value = Convert.ToInt32(txtage.Text );
pcity.Value = txtcity.Text;
pcourse.Value = txtcourse.Text;

try
{
comm.ExecuteNonQuery();
MessageBox.Show("Saved");
}
catch (Exception)
{
MessageBox.Show("Not Saved");
}

}
}
}

Run the application.

Fill in the form and click the "Save" button. It will show a message "Saved" or "Not Saved".

Here are some related resources

• Stored Procedure in ADO.NET Data Service

• Selection Based Crystal Report using Stored Procedure

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

• Executing multiple stored procedures within a single transaction context from ADO.Net