Gridview - StoredProcedures - OOPS concept

Question

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?

Ruchi H · Answer

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.

Santosh Kumar · Answer

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 UserNamePasswordName 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 Lenka · Answer

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 Hussain · Answer

Hi Please refer the below link http://www.aspdotnet-suresh.com/2011/02/how-to-inserteditupdate-and-delete-data.html Regards Iftikar