Gridview - StoredProcedures

Gridview - StoredProcedures - OOPS concept

Hi,
My today task is to Create a simple screen with grid and get the record from the database. to get the record, should use the package with procedures, also OOPS concept should be used in the code.What concept shall i use here?Can anyone help me to do this?

Try this first create a procedure in database and choose your fields another ....
using System;

using System.Configuration;

using System.Data;

using System.Data.SqlClient;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

public partial class _Default : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

SqlConnection con = new SqlConnection("Data Source=abc;Initial Catalog=Test;Integrated Security=True");

SqlDataAdapter da;

da = new SqlDataAdapter("select UserName,Password,Name from users", con);

DataSet ds = new DataSet();

da.Fill(ds, "users");

GridView1.DataSource = ds.Tables["users"];

GridView1.DataBind();

}

protected void Button1_Click(object sender, EventArgs e)

{

try

{

SqlConnection con = new SqlConnection("Data Source=abc;Initial Catalog=Test;Integrated Security=True");

SqlCommand cmd = new SqlCommand();

cmd.Connection = con;

cmd.CommandText = "insert into users values (@UserName,@Password,@Name)";

cmd.Parameters.Add("@UserName", SqlDbType.NVarChar, 10).Value = TextBox1.Text;

cmd.Parameters.Add("@Password", SqlDbType.NVarChar, 10).Value = TextBox2.Text;

cmd.Parameters.Add("@Name", SqlDbType.NVarChar, 20).Value = TextBox3.Text;

cmd.Connection.Open();

cmd.ExecuteNonQuery();

cmd.Connection.Close();

TextBox1.Text = "";

TextBox2.Text = "";

TextBox3.Text = "";

}

catch (Exception ex)

{

throw ex;

}

finally

{

Response.Write("Your registration was Sucessfully!");

}

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Santosh Kumar13y ago
Try this first create a procedure in database and choose your fields another ....
using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=abc;Initial Catalog=Test;Integrated Security=True");
SqlDataAdapter da;
da = new SqlDataAdapter("select UserName,Password,Name from users", con);
DataSet ds = new DataSet();
da.Fill(ds, "users");
GridView1.DataSource = ds.Tables["users"];
GridView1.DataBind();

}
protected void Button1_Click(object sender, EventArgs e)
{
try
{

SqlConnection con = new SqlConnection("Data Source=abc;Initial Catalog=Test;Integrated Security=True");
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "insert into users values (@UserName,@Password,@Name)";
cmd.Parameters.Add("@UserName", SqlDbType.NVarChar, 10).Value = TextBox1.Text;
cmd.Parameters.Add("@Password", SqlDbType.NVarChar, 10).Value = TextBox2.Text;
cmd.Parameters.Add("@Name", SqlDbType.NVarChar, 20).Value = TextBox3.Text;
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
TextBox1.Text = "";
TextBox2.Text = "";
TextBox3.Text = "";

}
catch (Exception ex)
{
throw ex;
}
finally
{
Response.Write("Your registration was Sucessfully!");
}

}
}
Sanjeeb Lenka13y ago
for this better to go for three tier.

check this link

http://www.dotnetfunda.com/articles/article71.aspx

http://dotnetsridhar.blogspot.in/2012/04/3-tier-architecture-for-inserting-and.html
Iftikar Hussain13y ago
Hi,
Please refer the below link

http://www.aspdotnet-suresh.com/2011/02/how-to-inserteditupdate-and-delete-data.html

Regards,
Iftikar
Ruchi H13y ago
Hi,

You can use Employee Department example for this.
in where you can use OOPS concept Emploee - Head of Department or Boss
You can write insert/Delete queries in procedures.
and display data in grid.