DataTable Example For Dynamically create Row and bind to Gridview in asp.net ~ Asp .Net Solution Kirit Kapupara

Description:-

In this Example we Explain that how to store Temporary Data in Gridview From more than one Table. We all know that Temporary store,update,Delete is very Difficult task than simply as an Retrieve Data From table.

In this Example we simply Fetch Data from product and rate table. Both table are have a relation eachother.but the main problem in Temporary store data is you can not fetch data from the table so you have to store all record in DataTable Session and you can easily Bind it.

For Example:-

dt = Session["dtd"] as DataTable;

Session["dtd"] = dt;

You can also Edit and Delete Record in temporary Gridview and we provide Submit Button when user click on this Button at that time this Gridview Data are Stored in Database.

The Best Example of the Temporary insert update and Delete Record in Gridview is used in any Online Shopping Application. In Online Shopping user First Select More than one Thing and after he/she Replace this thing and finally it will purchase Item as per his/her Budget so at that time you must have to save your data in temporary Gridview and perform temporary operation after that user final Declare his Decision tehn after only data are transfer in database and Change the data in Databse.

ModalPopup Example for Insert,Update,Delete in Gridview CRUD operation in ModalPopup

Upload File to database and bind to Gridview Upload File and bind Image in Gridview

Ajax Password Strength Example Check Password Strong or weak in Ajax

prorelgrid.aspx:-

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="prorelgrid.aspx.cs" Inherits="prorelgrid" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

</head>

<body>

<div>

<asp:Panel ID="p" runat="server" BorderColor="#FFFF99" BorderStyle="Solid"

GroupingText="Registration" ScrollBars="Auto"

<asp:RequiredFieldValidator ID="rfvFirstName"

runat="server"

ControlToValidate="txtcnm"

ErrorMessage="company Name can't be left blank"

Display="Dynamic"> </asp:RequiredFieldValidator>

<label for="email">description</label>

<asp:TextBox ID="txtpnm" runat="server" TextMode="MultiLine" CssClass="txtfield"></asp:TextBox>

<asp:RequiredFieldValidator

ID="RequiredFieldValidator1" runat="server"

ControlToValidate="txtpnm"

ErrorMessage="person name can't be left blank"

Display="Dynamic"> </asp:RequiredFieldValidator>

<label for="email">Quantity</label>

<asp:TextBox ID="txtqu" runat="server" CssClass="txtfield"

> </asp:TextBox>

<asp:RequiredFieldValidator ID="RequiredFieldValidator2"

runat="server"

ControlToValidate="txtqu"

ErrorMessage="Id can't be left blank"

SetFocusOnError="True" Display="Dynamic"></asp:RequiredFieldValidator>

<asp:CompareValidator ID="CompareValidator2" runat="server"

ErrorMessage="only digit is allowed" ControlToValidate="txtqu" Display="Dynamic"

Font-Bold="True" Type="Double" Operator="DataTypeCheck"></asp:CompareValidator>

<asp:TextBox ID="txtrate" runat="server" CssClass="txtfield"

> </asp:TextBox>

<asp:RequiredFieldValidator ID="RequiredFieldValidator4"

runat="server"

ControlToValidate="txtrate"

ErrorMessage="Id can't be left blank"

SetFocusOnError="True" Display="Dynamic"></asp:RequiredFieldValidator>

<asp:CompareValidator ID="CompareValidator3" runat="server"

ErrorMessage="only digit is allowed" ControlToValidate="txtrate" Display="Dynamic"

Font-Bold="True" Type="Double" Operator="DataTypeCheck"></asp:CompareValidator>

<br /> <asp:Button id="Button1"

Text="Register"

CommandName="register"

CommandArgument="register"

OnCommand="Button1_Click1" CssClass="btn"

runat="server"/>

<asp:Button id="Button3"

Text="Update"

CommandName="update"

CommandArgument="update"

OnCommand="Button1_Click1" CssClass="btn" Visible="false"

runat="server"/>

<asp:Button ID="Button4" runat="server" Text="Delete All" CssClass="btn"

CausesValidation="false" onclick="Button4_Click1" />

<asp:GridView ID="GridView1" runat="server"

Font-Size="Large"

ForeColor="#333333" ShowFooter="True" CellPadding="4" GridLines="None"

AutoGenerateColumns="False"

onrowdeleting="GridView1_RowDeleting" onrowediting="GridView1_RowEditing" onrowdatabound="GridView1_RowDataBound"

<asp:TemplateField HeaderText="Delete All">

<asp:CheckBox ID="chkSelectAll" runat="server"

AutoPostBack="true"

OnCheckedChanged="chkSelectAll_CheckedChanged"/>

</HeaderTemplate>

<asp:CheckBox ID="CheckBox1" runat="server" AutoPostBack="true" />

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="name">

<asp:Label ID="Label1" runat="server" Text='<%# Eval("name") %>'></asp:Label>

</ItemTemplate>

<asp:TextBox ID="TextBox2" runat="server" Text='<%# Eval("name") %>'></asp:TextBox>

</EditItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Description">

<asp:Label ID="Label2" runat="server" Text='<%# Eval("descp") %>'></asp:Label>

</ItemTemplate>

<asp:TextBox ID="TextBox3" runat="server" Text='<%# Eval("descp") %>'></asp:TextBox>

</EditItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Quantity">

<asp:Label ID="Label3" runat="server" Text='<%# Eval("quantity") %>'></asp:Label>

</ItemTemplate>

<asp:TextBox ID="TextBox4" runat="server" Text='<%# Eval("quantity") %>'></asp:TextBox>

</EditItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Rate">

<asp:Label ID="Label4" runat="server" Text='<%# Eval("rate") %>'></asp:Label>

</ItemTemplate>

<asp:TextBox ID="TextBox5" runat="server" Text='<%# Eval("rate") %>'></asp:TextBox>

</EditItemTemplate>

<asp:Label ID="lbl" runat="server" Text="GrandTotal"></asp:Label>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Total" >

<asp:Label ID="Label6" runat="server" Text='<%# Eval("total") %>'></asp:Label>

</ItemTemplate>

<asp:Label ID="lblgrand" runat="server"></asp:Label>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField>

<asp:LinkButton ID="LinkButton2" runat="server" CommandName="Delete" CausesValidation="False">Delete</asp:LinkButton>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField>

<asp:LinkButton ID="LinkButton1" runat="server" CommandName="Edit" CausesValidation="False">Edit</asp:LinkButton>

</ItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

<asp:Button ID="Button2" runat="server" Text="submit" CausesValidation="false" Visible="false" CssClass="btn" onclick="Button2_Click" />

</center>

</asp:Panel>

</div>

</form>

</body>

</html>

prorelgrid.aspx.cs:-

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.SqlClient;

using System.Data;

using System.IO;

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

{

DataTable dt;

DataTable ds;

int xxx, xx = 0;

Double tot = 0;

static int temp = 0;

static int chk = 0;

protected void Page_Load(object sender, EventArgs e)

{

if (!Page.IsPostBack)

{

Session["dtd"] = null;

chk = 0;

}

dt = Session["dtd"] as DataTable;

if (Request.QueryString["id"] != null && chk == 0)

{

chk++;

ds = new DataTable();

string con = @"Data Source=SQLDB;Initial Catalog=Demo;User ID=Demod;Password=Demo1@";

string q = "select p.name,p.descp,pr.quantity,pr.rate,pr.total from hk_product p INNER JOIN hk_rproduct pr ON p.pid = pr.rpid where p.pid='" + Request.QueryString["id"].ToString() + "'";

SqlConnection conn = new SqlConnection(con);

SqlCommand cmd = new SqlCommand(q, conn);

SqlDataAdapter sa = new SqlDataAdapter();

conn.Open();

cmd.ExecuteNonQuery();

sa.SelectCommand = cmd;

sa.Fill(ds);

GridView1.DataSource = ds;

GridView1.DataBind();

dt = ds;

Session["dtd"] = dt;

}

protected void Button1_Click1(object sender, CommandEventArgs e)

{

if (e.CommandName == "register")

{

if (dt == null)

{

dt = new DataTable();

dt.Columns.Add("name").ToString();

dt.Columns.Add("descp").ToString();

dt.Columns.Add("quantity").ToString();

dt.Columns.Add("rate").ToString();

//dt.Columns.Add("rpid").ToString();

dt.Columns.Add("total").ToString();

}

DataRow dr = dt.NewRow();

dr["name"] = txtcnm.Text;

dr["descp"] = txtpnm.Text;

dr["quantity"] = txtqu.Text;

dr["rate"] = txtrate.Text;

dr["total"] = Double.Parse(txtqu.Text) * Double.Parse(txtrate.Text);

/* for (int i = 0; i < dt.Rows.Count; i++)

{

if (txtcid.Text.Equals(dt.Rows[i][0].ToString()))

{

xxx = 1;

break;

}

}*/

string con = @"Data Source=SQLDB;Initial Catalog=Demo;User ID=Demod;Password=Demo1@";

string q = "select name from hk_product";

SqlConnection conn = new SqlConnection(con);

SqlCommand cmd = new SqlCommand(q, conn);

conn.Open();

SqlDataReader sr = cmd.ExecuteReader();

while (sr.Read())

{

if (Request.QueryString["id"] == null)

if (sr["name"].ToString().Equals(dr["name"].ToString()))

{

xxx = 1;

break;

}

if (Request.QueryString["id"] != null)

if (!dt.Rows[0][0].ToString().Equals(txtcnm.Text))

{

xx = 1;

break;

}

if (xx == 1)

{

Response.Write("<script>alert('you can insert only " + dt.Rows[0][0].ToString() + " record because you are in editin mode');</script>");

txtcnm.Focus();

}

else

{

if (xxx == 1)

{

Response.Write("<script>alert('the product " + txtcnm.Text + " is exists in databse plz insert another product name');</script>");

txtcnm.Focus();

// txtcid.BackColor = System.Drawing.Color.Red;

}

else

{

dt.Rows.Add(dr);

GridView1.DataSource = dt;

GridView1.DataBind();

Session["dtd"] = dt;

clear();

Button2.Visible = true;

txtcnm.ReadOnly = true;

txtpnm.ReadOnly = true;

txtqu.Focus();

}

if (e.CommandName == "update")

{

/* foreach (GridViewRow r1 in GridView1.Rows)

{

if (GridView1.DataKeys[r1.RowIndex].Value.ToString().Equals(Session["id"].ToString()))

{

Label l = (Label)GridView1.Rows[r1.RowIndex].FindControl("i1");*/

//dt.Rows[r1.RowIndex][0] = txtcid.Text;

dt.Rows[temp][0] = txtcnm.Text;

dt.Rows[temp][1] = txtpnm.Text;

dt.Rows[temp][2] = txtqu.Text;

dt.Rows[temp][3] = txtrate.Text;

// dt.Rows[r1.RowIndex][5] = txtcid.Text;

dt.Rows[temp][4] = Double.Parse(txtqu.Text) * Double.Parse(txtrate.Text);

/* break;

}

}*/

GridView1.DataSource = dt;

GridView1.DataBind();

Button1.Visible = true;

Button3.Visible = false;

Button2.Visible = true;

Session["dtd"] = dt;

clear();

txtqu.Text = "";

txtrate.Text = "";

txtcnm.ReadOnly = false;

txtpnm.ReadOnly = false;

ClientScript.RegisterClientScriptBlock(this.GetType(), "key", "<script> alert('updated successfully');</script>");

}

public string id()

{

string con = @"Data Source=SQLDB;Initial Catalog=Demo;User ID=Demod;Password=Demo1@";

string q = "select MAX(pid) from hk_product";

SqlConnection conn = new SqlConnection(con);

SqlCommand cmd = new SqlCommand(q, conn);

conn.Open();

SqlDataReader sr = cmd.ExecuteReader();

string s = null;

while (sr.Read())

{

s = sr[0].ToString();

}

return s;

}

protected void Button2_Click(object sender, EventArgs e)

{

int j = 0;

txtpnm.ReadOnly = false;

txtcnm.ReadOnly = false;

if (Request.QueryString["id"] == null)

{

for (int i = 0; i < dt.Rows.Count; i++)

{

string con = @"Data Source=SQLDB;Initial Catalog=Demo;User ID=Demod;Password=Demo1@";

// string s1 = "insert into hk_product,hk_rproduct values('" + dt.Rows[i][0].ToString() + "','" + dt.Rows[i][1].ToString() + "','" + dt.Rows[i][2].ToString() + "','" + dt.Rows[i][3].ToString() + "','" + dt.Rows[i][4].ToString() + "','" + dt.Rows[i][5].ToString() + "')";

string s1 = "insert into hk_product values('" + dt.Rows[i][0].ToString() + "','" + dt.Rows[i][1].ToString() + "')";

SqlConnection conn = new SqlConnection(con);

SqlCommand cmd = new SqlCommand(s1, conn);

conn.Open();

j = cmd.ExecuteNonQuery();

if (j > 0)

break;

conn.Close();

}

string a = id();

for (int i = 0; i < dt.Rows.Count; i++)

{

string con = @"Data Source=SQLDB;Initial Catalog=Demo;User ID=Demod;Password=Demo1@";

string s2 = "insert into hk_rproduct values('" + dt.Rows[i][2].ToString() + "','" + dt.Rows[i][3].ToString() + "','" + a + "')";

SqlConnection conn = new SqlConnection(con);

SqlCommand cmd1 = new SqlCommand(s2, conn);

conn.Open();

cmd1.ExecuteNonQuery();

conn.Close();

}

if (j > 0)

Response.Redirect("showpro1.aspx");

}

else

{

string con = @"Data Source=SQLDB;Initial Catalog=Demo;User ID=Demod;Password=Demo1@";

string s1 = "delete from hk_rproduct where rpid='" + Request.QueryString["id"].ToString() + "'";

SqlConnection conn = new SqlConnection(con);

SqlCommand cmd = new SqlCommand(s1, conn);

conn.Open();

// j = cmd.ExecuteNonQuery();

cmd.ExecuteNonQuery();

conn.Close();

dt = (DataTable)Session["dtd"];

for (int i = 0; i < dt.Rows.Count; i++)

{

//string con = @"Data Source=SQLDB;Initial Catalog=Demo;User ID=Demod;Password=Demo1@";

// string s1 = "delete from hk_rproduct where rpid='" + Request.QueryString["id"].ToString() + "'";

//SqlConnection conn = new SqlConnection(con);

string s2 = "insert into hk_rproduct values('" + dt.Rows[i][2].ToString() + "','" + dt.Rows[i][3].ToString() + "','" + Request.QueryString["id"].ToString() + "')";

// SqlCommand cmd = new SqlCommand(s1, conn);

SqlCommand cmd1 = new SqlCommand(s2, conn);

conn.Open();

// j = cmd.ExecuteNonQuery();

cmd1.ExecuteNonQuery();

conn.Close();

}

Response.Redirect("showpro1.aspx");

}

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)

{

//Label l = (Label)GridView1.Rows[e.NewEditIndex].FindControl("Label10");

Label l1 = (Label)GridView1.Rows[e.NewEditIndex].FindControl("Label1");

Label l2 = (Label)GridView1.Rows[e.NewEditIndex].FindControl("Label2");

Label l3 = (Label)GridView1.Rows[e.NewEditIndex].FindControl("Label3");

Label l4 = (Label)GridView1.Rows[e.NewEditIndex].FindControl("Label4");

// Session["id"] = l.Text;

// txtcid.Text = l.Text;

//txtcid.ReadOnly = true;

temp = e.NewEditIndex;

txtcnm.Text = l1.Text;

txtpnm.Text = l2.Text;

txtqu.Text = l3.Text;

txtrate.Text = l4.Text;

Button3.Visible = true;

Button1.Visible = false;

txtcnm.ReadOnly = true;

txtpnm.ReadOnly = true;

}

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

/* if (Request.QueryString["id"] == null)

{

dt.Rows.RemoveAt(e.RowIndex);

GridView1.DataSource = dt;

GridView1.DataBind();

}

else

{

string con = @"Data Source=SQLDB;Initial Catalog=Demo;User ID=Demod;Password=Demo1@";

string s1 = "delete from hk_rproduct where rpid='" + Request.QueryString["id"].ToString() + "' AND quantity='"+dt.Rows[e.RowIndex][2].ToString()+"'";

SqlConnection conn = new SqlConnection(con);

SqlCommand cmd = new SqlCommand(s1, conn);

conn.Open();

// j = cmd.ExecuteNonQuery();

cmd.ExecuteNonQuery();

conn.Close();*/

dt.Rows.RemoveAt(e.RowIndex);

GridView1.DataSource = dt;

GridView1.DataBind();

}

protected void Button4_Click(object sender, EventArgs e)

{

clear();

}

public void clear()

{

// txtcid.Text = "";

// txtcnm.Text = "";

//txtpnm.Text = "";

txtqu.Text = "";

txtrate.Text = "";

}

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)

{

Label l = null;

Label l1 = null;

Double tt = 0;

if (e.Row.RowType == DataControlRowType.Footer)

{

l = (Label)e.Row.FindControl("lblgrand");

if (dt != null)

{

for (int i = 0; i < dt.Rows.Count; i++)

{

tt += Double.Parse(dt.Rows[i][4].ToString());

l.Text = tt.ToString();

}

else

{

l.Text = tot.ToString();

}

if (e.Row.RowType == DataControlRowType.DataRow)

{

l1 = (Label)e.Row.FindControl("Label6");

tot += Double.Parse(l1.Text);

}

protected void Button4_Click1(object sender, EventArgs e)

{

int to = dt.Rows.Count;

int cc = 0;

for (int z = 0; z < to; z++)

{

CheckBox c = (CheckBox)GridView1.Rows[z].FindControl("CheckBox1");

if (c.Checked)

{

if (cc == 0)

dt.Rows.RemoveAt(z);

else

dt.Rows.RemoveAt(z - cc);

cc++;

}

GridView1.DataSource = dt;

GridView1.DataBind();

}

protected void chkSelectAll_CheckedChanged(object sender, EventArgs e)

{

CheckBox chkAll =

(CheckBox)GridView1.HeaderRow.FindControl("chkSelectAll");

if (chkAll.Checked == true)

for (int i = 0; i < dt.Rows.Count; i++)

{

CheckBox c = (CheckBox)GridView1.Rows[i].FindControl("CheckBox1");

c.Checked = true;

}

else

{

for (int i = 0; i < dt.Rows.Count; i++)

{

CheckBox c = (CheckBox)GridView1.Rows[i].FindControl("CheckBox1");

c.Checked = true;

}

Wednesday, 13 March 2013

DataTable Example For Dynamically create Row and bind to Gridview in asp.net

Description:-

0 comments:

Post a Comment

Like my Page on facebook

Popular Posts

Author

Label