Hi sathish75,
Refer below sample.
HTML
<asp:GridView ID="Gridview1" runat="server" ShowFooter="true" AutoGenerateColumns="false">
<Columns>
<asp:TemplateField HeaderText="Header 1">
<ItemTemplate>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Header 2">
<ItemTemplate>
<asp:CheckBox ID="chkMrng" runat="server" />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Header 3">
<ItemTemplate>
<asp:CheckBox ID="chkNoon" runat="server" />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Header 4">
<ItemTemplate>
<asp:CheckBox ID="chkNyt" runat="server" />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Header 5">
<ItemTemplate>
<asp:DropDownList runat="server" ID="ddlName">
<asp:ListItem Text="Please Select" />
<asp:ListItem Text="India" />
<asp:ListItem Text="United State" />
<asp:ListItem Text="France" />
<asp:ListItem Text="Russia" />
</asp:DropDownList>
</ItemTemplate>
<FooterStyle HorizontalAlign="Right" />
<FooterTemplate>
<asp:Button ID="ButtonAdd" runat="server" Text="Add New Row" OnClick="ButtonAdd_Click" />
</FooterTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<asp:Button ID="Button1" runat="server" Text="Save" OnClick="Insert" />
<asp:Button Text="Display" runat="server" OnClick="Display" />
<br />
<asp:Repeater ID="rptPrint" runat="server">
<HeaderTemplate>
<table border="1px">
<tr>
<th>
Name
</th>
<th>
Country
</th>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr>
<td>
<asp:Label ID="lblName" runat="server" Text='<%# Eval("Name") %>' />
</td>
<td>
<asp:Label ID="lblCountry" runat="server" Text='<%# Eval("Country") %>' />
</td>
</tr>
</ItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:Repeater>
<div align="center">
<asp:Button ID="btnPrint" runat="server" Text="Print" OnClick="PrintCurrentPage" />
</div>
Namespaces
C#
using System.Data;
using System.Data.SqlClient;
using System.Text;
using System.Collections.Specialized;
using System.IO;
VB.Net
Imports System.Data
Imports System.IO
Imports System.Data.SqlClient
Code
C#
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
SetInitialRow();
}
}
private void SetInitialRow()
{
DataTable dt = new DataTable();
DataRow dr = null;
dt.Columns.Add(new DataColumn("Column1", typeof(string)));
dt.Columns.Add(new DataColumn("Column2", typeof(string)));
dt.Columns.Add(new DataColumn("Column3", typeof(string)));
dt.Columns.Add(new DataColumn("Column4", typeof(string)));
dt.Columns.Add(new DataColumn("Column5", typeof(string)));
dr = dt.NewRow();
dt.Rows.Add(dr);
ViewState["CurrentTable"] = dt;
Gridview1.DataSource = dt;
Gridview1.DataBind();
}
private void AddNewRowToGrid()
{
int rowIndex = 0;
if (ViewState["CurrentTable"] != null)
{
DataTable dtCurrentTable = (DataTable)ViewState["CurrentTable"];
DataRow drCurrentRow = null;
int rowCount = dtCurrentTable.Rows.Count;
bool isChecked = false;
if (dtCurrentTable.Rows.Count > 0)
{
int index = 0;
for (int i = 1; i <= dtCurrentTable.Rows.Count; i++)
{
bool checkedChk = false;
//extract the TextBox values
TextBox box1 = (TextBox)Gridview1.Rows[index].Cells[0].FindControl("TextBox1");
CheckBox box2 = (CheckBox)Gridview1.Rows[index].Cells[1].FindControl("chkMrng");
CheckBox box3 = (CheckBox)Gridview1.Rows[index].Cells[2].FindControl("chkNoon");
CheckBox box4 = (CheckBox)Gridview1.Rows[index].Cells[3].FindControl("chkNyt");
DropDownList box5 = (DropDownList)Gridview1.Rows[index].Cells[4].FindControl("ddlName");
if (box2.Checked || box3.Checked || box4.Checked)
{
checkedChk = true;
isChecked = checkedChk;
}
if (!checkedChk)
{
isChecked = false;
ScriptManager.RegisterStartupScript(this, this.GetType(), "Message", "alert('Atlease one checkbox should be selected in row " + index + "');", true);
break;
}
index++;
}
if (isChecked)
{
for (int i = 1; i <= dtCurrentTable.Rows.Count; i++)
{
//extract the TextBox values
TextBox box1 = (TextBox)Gridview1.Rows[rowIndex].Cells[0].FindControl("TextBox1");
CheckBox box2 = (CheckBox)Gridview1.Rows[rowIndex].Cells[1].FindControl("chkMrng");
CheckBox box3 = (CheckBox)Gridview1.Rows[rowIndex].Cells[2].FindControl("chkNoon");
CheckBox box4 = (CheckBox)Gridview1.Rows[rowIndex].Cells[3].FindControl("chkNyt");
DropDownList box5 = (DropDownList)Gridview1.Rows[rowIndex].Cells[4].FindControl("ddlName");
drCurrentRow = dtCurrentTable.NewRow();
drCurrentRow["Column1"] = box1.Text;
drCurrentRow["Column2"] = box2.Checked ? "1" : "0";
drCurrentRow["Column3"] = box3.Checked ? "1" : "0";
drCurrentRow["Column4"] = box4.Checked ? "1" : "0";
drCurrentRow["Column5"] = box5.SelectedItem.Value;
rowIndex++;
}
if (drCurrentRow != null)
{
dtCurrentTable.Rows.Add(drCurrentRow);
ViewState["CurrentTable"] = dtCurrentTable;
}
}
Gridview1.DataSource = dtCurrentTable;
Gridview1.DataBind();
}
}
else
{
Response.Write("ViewState is null");
}
SetPreviousData();
}
private void SetPreviousData()
{
int rowIndex = 0;
if (ViewState["CurrentTable"] != null)
{
DataTable dt = (DataTable)ViewState["CurrentTable"];
if (dt.Rows.Count > 0)
{
for (int i = 1; i < dt.Rows.Count; i++)
{
TextBox box1 = (TextBox)Gridview1.Rows[rowIndex].Cells[0].FindControl("TextBox1");
CheckBox box2 = (CheckBox)Gridview1.Rows[rowIndex].Cells[1].FindControl("chkMrng");
CheckBox box3 = (CheckBox)Gridview1.Rows[rowIndex].Cells[2].FindControl("chkNoon");
CheckBox box4 = (CheckBox)Gridview1.Rows[rowIndex].Cells[3].FindControl("chkNyt");
DropDownList box5 = (DropDownList)Gridview1.Rows[rowIndex].Cells[4].FindControl("ddlName");
box1.Text = dt.Rows[i]["Column1"].ToString();
box2.Checked = dt.Rows[i]["Column2"].ToString() == "1" ? true : false;
box3.Checked = dt.Rows[i]["Column3"].ToString() == "1" ? true : false;
box4.Checked = dt.Rows[i]["Column4"].ToString() == "1" ? true : false;
box5.Items.FindByValue(dt.Rows[i]["Column5"].ToString()).Selected = true;
rowIndex++;
}
}
}
}
protected void ButtonAdd_Click(object sender, EventArgs e)
{
AddNewRowToGrid();
}
protected void Insert(object sender, EventArgs e)
{
int rowIndex = 0;
StringCollection sc = new StringCollection();
if (ViewState["CurrentTable"] != null)
{
DataTable dtCurrentTable = (DataTable)ViewState["CurrentTable"];
if (dtCurrentTable.Rows.Count > 0)
{
for (int i = 1; i <= dtCurrentTable.Rows.Count - 1; i++)
{
//extract the TextBox values
TextBox box1 = (TextBox)Gridview1.Rows[rowIndex].Cells[0].FindControl("TextBox1");
CheckBox box2 = (CheckBox)Gridview1.Rows[rowIndex].Cells[1].FindControl("chkMrng");
CheckBox box3 = (CheckBox)Gridview1.Rows[rowIndex].Cells[2].FindControl("chkNoon");
CheckBox box4 = (CheckBox)Gridview1.Rows[rowIndex].Cells[3].FindControl("chkNyt");
DropDownList box5 = (DropDownList)Gridview1.Rows[rowIndex].Cells[4].FindControl("ddlName");
//get the values from the TextBoxes
//then add it to the collections with a comma "," as the delimited values
sc.Add(box1.Text + "," + box2.Text + "," + box3.Text + "," + box4.Text + "," + box5.SelectedItem.Value);
rowIndex++;
}
//Call the method for executing inserts
InsertRecords(sc);
}
}
}
private string GetConnectionString()
{
return System.Configuration.ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
}
private void InsertRecords(StringCollection sc)
{
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[] { new DataColumn("Name", typeof(string)), new DataColumn("Country", typeof(string)) });
SqlConnection conn = new SqlConnection(GetConnectionString());
StringBuilder sb = new StringBuilder(string.Empty);
string[] splitItems = null;
foreach (string item in sc)
{
const string sqlStatement = "INSERT INTO SampleTable (Column1,Column2,Column3,Column4,Column5) VALUES";
if (item.Contains(","))
{
splitItems = item.Split(",".ToCharArray());
sb.AppendFormat("{0}('{1}','{2}','{3}','{4}','{5}'); ", sqlStatement, splitItems[0], splitItems[1], splitItems[2], splitItems[3], splitItems[4]);
dt.Rows.Add(splitItems[0], splitItems[4]);
}
}
try
{
conn.Open();
SqlCommand cmd = new SqlCommand(sb.ToString(), conn);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
ViewState["dt"] = dt;
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "Script", "alert('Records Successfuly Saved!');", true);
}
catch (System.Data.SqlClient.SqlException ex)
{
string msg = "Insert Error:";
msg += ex.Message;
throw new Exception(msg);
}
finally
{
conn.Close();
}
}
protected void Display(object sender, EventArgs e)
{
DataTable dt = ViewState["dt"] as DataTable;
rptPrint.DataSource = dt;
rptPrint.DataBind();
}
protected void PrintCurrentPage(object sender, EventArgs e)
{
DataTable dt = ViewState["dt"] as DataTable;
rptPrint.DataSource = dt;
rptPrint.DataBind();
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
rptPrint.RenderControl(hw);
string gridHTML = sw.ToString().Replace("\"", "'").Replace(System.Environment.NewLine, "");
StringBuilder sb = new StringBuilder();
sb.Append("<script type = 'text/javascript'>");
sb.Append("window.onload = new function(){");
sb.Append("var printWin = window.open('', '', 'left=0");
sb.Append(",top=0,width=1000,height=600,status=0');");
sb.Append("printWin.document.write(\"");
sb.Append(gridHTML);
sb.Append("\");");
sb.Append("printWin.document.close();");
sb.Append("printWin.focus();");
sb.Append("printWin.print();");
sb.Append("printWin.close();};");
sb.Append("</script>");
ClientScript.RegisterStartupScript(this.GetType(), "GridPrint", sb.ToString());
rptPrint.DataSource = dt;
rptPrint.DataBind();
}
VB.Net
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
If Not Page.IsPostBack Then
SetInitialRow()
End If
End Sub
Private Sub SetInitialRow()
Dim dt As DataTable = New DataTable()
Dim dr As DataRow = Nothing
dt.Columns.Add(New DataColumn("Column1", GetType(String)))
dt.Columns.Add(New DataColumn("Column2", GetType(String)))
dt.Columns.Add(New DataColumn("Column3", GetType(String)))
dt.Columns.Add(New DataColumn("Column4", GetType(String)))
dt.Columns.Add(New DataColumn("Column5", GetType(String)))
dr = dt.NewRow()
dt.Rows.Add(dr)
ViewState("CurrentTable") = dt
Gridview1.DataSource = dt
Gridview1.DataBind()
End Sub
Private Sub AddNewRowToGrid()
Dim rowIndex As Integer = 0
If ViewState("CurrentTable") IsNot Nothing Then
Dim dtCurrentTable As DataTable = CType(ViewState("CurrentTable"), DataTable)
Dim drCurrentRow As DataRow = Nothing
Dim rowCount As Integer = dtCurrentTable.Rows.Count
Dim isChecked As Boolean = False
If dtCurrentTable.Rows.Count > 0 Then
Dim index As Integer = 0
For i As Integer = 1 To dtCurrentTable.Rows.Count
Dim checkedChk As Boolean = False
Dim box1 As TextBox = CType(Gridview1.Rows(index).Cells(0).FindControl("TextBox1"), TextBox)
Dim box2 As CheckBox = CType(Gridview1.Rows(index).Cells(1).FindControl("chkMrng"), CheckBox)
Dim box3 As CheckBox = CType(Gridview1.Rows(index).Cells(2).FindControl("chkNoon"), CheckBox)
Dim box4 As CheckBox = CType(Gridview1.Rows(index).Cells(3).FindControl("chkNyt"), CheckBox)
Dim box5 As DropDownList = CType(Gridview1.Rows(index).Cells(4).FindControl("ddlName"), DropDownList)
If box2.Checked OrElse box3.Checked OrElse box4.Checked Then
checkedChk = True
isChecked = checkedChk
End If
If Not checkedChk Then
isChecked = False
ScriptManager.RegisterStartupScript(Me, Me.[GetType](), "Message", "alert('Atlease one checkbox should be selected in row " & index & "');", True)
Exit For
End If
index += 1
Next
If isChecked Then
For i As Integer = 1 To dtCurrentTable.Rows.Count
Dim box1 As TextBox = CType(Gridview1.Rows(rowIndex).Cells(0).FindControl("TextBox1"), TextBox)
Dim box2 As CheckBox = CType(Gridview1.Rows(rowIndex).Cells(1).FindControl("chkMrng"), CheckBox)
Dim box3 As CheckBox = CType(Gridview1.Rows(rowIndex).Cells(2).FindControl("chkNoon"), CheckBox)
Dim box4 As CheckBox = CType(Gridview1.Rows(rowIndex).Cells(3).FindControl("chkNyt"), CheckBox)
Dim box5 As DropDownList = CType(Gridview1.Rows(rowIndex).Cells(4).FindControl("ddlName"), DropDownList)
drCurrentRow = dtCurrentTable.NewRow()
drCurrentRow("Column1") = box1.Text
drCurrentRow("Column2") = If(box2.Checked, "1", "0")
drCurrentRow("Column3") = If(box3.Checked, "1", "0")
drCurrentRow("Column4") = If(box4.Checked, "1", "0")
drCurrentRow("Column5") = box5.SelectedItem.Value
rowIndex += 1
Next
If drCurrentRow IsNot Nothing Then
dtCurrentTable.Rows.Add(drCurrentRow)
ViewState("CurrentTable") = dtCurrentTable
End If
End If
Gridview1.DataSource = dtCurrentTable
Gridview1.DataBind()
End If
Else
Response.Write("ViewState is null")
End If
SetPreviousData()
End Sub
Private Sub SetPreviousData()
Dim rowIndex As Integer = 0
If ViewState("CurrentTable") IsNot Nothing Then
Dim dt As DataTable = CType(ViewState("CurrentTable"), DataTable)
If dt.Rows.Count > 0 Then
For i As Integer = 1 To dt.Rows.Count - 1
Dim box1 As TextBox = CType(Gridview1.Rows(rowIndex).Cells(0).FindControl("TextBox1"), TextBox)
Dim box2 As CheckBox = CType(Gridview1.Rows(rowIndex).Cells(1).FindControl("chkMrng"), CheckBox)
Dim box3 As CheckBox = CType(Gridview1.Rows(rowIndex).Cells(2).FindControl("chkNoon"), CheckBox)
Dim box4 As CheckBox = CType(Gridview1.Rows(rowIndex).Cells(3).FindControl("chkNyt"), CheckBox)
Dim box5 As DropDownList = CType(Gridview1.Rows(rowIndex).Cells(4).FindControl("ddlName"), DropDownList)
box1.Text = dt.Rows(i)("Column1").ToString()
box2.Checked = If(dt.Rows(i)("Column2").ToString() = "1", True, False)
box3.Checked = If(dt.Rows(i)("Column3").ToString() = "1", True, False)
box4.Checked = If(dt.Rows(i)("Column4").ToString() = "1", True, False)
box5.Items.FindByValue(dt.Rows(i)("Column5").ToString()).Selected = True
rowIndex += 1
Next
End If
End If
End Sub
Protected Sub ButtonAdd_Click(ByVal sender As Object, ByVal e As EventArgs)
AddNewRowToGrid()
End Sub
Protected Sub Insert(ByVal sender As Object, ByVal e As EventArgs)
Dim rowIndex As Integer = 0
Dim sc As StringCollection = New StringCollection()
If ViewState("CurrentTable") IsNot Nothing Then
Dim dtCurrentTable As DataTable = CType(ViewState("CurrentTable"), DataTable)
If dtCurrentTable.Rows.Count > 0 Then
For i As Integer = 1 To dtCurrentTable.Rows.Count - 1
Dim box1 As TextBox = CType(Gridview1.Rows(rowIndex).Cells(0).FindControl("TextBox1"), TextBox)
Dim box2 As CheckBox = CType(Gridview1.Rows(rowIndex).Cells(1).FindControl("chkMrng"), CheckBox)
Dim box3 As CheckBox = CType(Gridview1.Rows(rowIndex).Cells(2).FindControl("chkNoon"), CheckBox)
Dim box4 As CheckBox = CType(Gridview1.Rows(rowIndex).Cells(3).FindControl("chkNyt"), CheckBox)
Dim box5 As DropDownList = CType(Gridview1.Rows(rowIndex).Cells(4).FindControl("ddlName"), DropDownList)
sc.Add(box1.Text & "," + box2.Text & "," + box3.Text & "," + box4.Text & "," + box5.SelectedItem.Value)
rowIndex += 1
Next
InsertRecords(sc)
End If
End If
End Sub
Private Function GetConnectionString() As String
Return System.Configuration.ConfigurationManager.ConnectionStrings("constr").ConnectionString
End Function
Private Sub InsertRecords(ByVal sc As StringCollection)
Dim dt As DataTable = New DataTable()
dt.Columns.AddRange(New DataColumn() {New DataColumn("Name", GetType(String)), New DataColumn("Country", GetType(String))})
Dim conn As SqlConnection = New SqlConnection(GetConnectionString())
Dim sb As StringBuilder = New StringBuilder(String.Empty)
Dim splitItems As String() = Nothing
For Each item As String In sc
Const sqlStatement As String = "INSERT INTO SampleTable (Column1,Column2,Column3,Column4,Column5) VALUES"
If item.Contains(",") Then
splitItems = item.Split(",".ToCharArray())
sb.AppendFormat("{0}('{1}','{2}','{3}','{4}','{5}'); ", sqlStatement, splitItems(0), splitItems(1), splitItems(2), splitItems(3), splitItems(4))
dt.Rows.Add(splitItems(0), splitItems(4))
End If
Next
Try
conn.Open()
Dim cmd As SqlCommand = New SqlCommand(sb.ToString(), conn)
cmd.CommandType = CommandType.Text
cmd.ExecuteNonQuery()
ViewState("dt") = dt
Page.ClientScript.RegisterClientScriptBlock(GetType(Page), "Script", "alert('Records Successfuly Saved!');", True)
Catch ex As System.Data.SqlClient.SqlException
Dim msg As String = "Insert Error:"
msg += ex.Message
Throw New Exception(msg)
Finally
conn.Close()
End Try
End Sub
Protected Sub Display(ByVal sender As Object, ByVal e As EventArgs)
Dim dt As DataTable = TryCast(ViewState("dt"), DataTable)
rptPrint.DataSource = dt
rptPrint.DataBind()
End Sub
Protected Sub PrintCurrentPage(ByVal sender As Object, ByVal e As EventArgs)
Dim dt As DataTable = TryCast(ViewState("dt"), DataTable)
rptPrint.DataSource = dt
rptPrint.DataBind()
Dim sw As StringWriter = New StringWriter()
Dim hw As HtmlTextWriter = New HtmlTextWriter(sw)
rptPrint.RenderControl(hw)
Dim gridHTML As String = sw.ToString().Replace("""", "'").Replace(System.Environment.NewLine, "")
Dim sb As StringBuilder = New StringBuilder()
sb.Append("<script type = 'text/javascript'>")
sb.Append("window.onload = new function(){")
sb.Append("var printWin = window.open('', '', 'left=0")
sb.Append(",top=0,width=1000,height=600,status=0');")
sb.Append("printWin.document.write(""")
sb.Append(gridHTML)
sb.Append(""");")
sb.Append("printWin.document.close();")
sb.Append("printWin.focus();")
sb.Append("printWin.print();")
sb.Append("printWin.close();};")
sb.Append("</script>")
ClientScript.RegisterStartupScript(Me.[GetType](), "GridPrint", sb.ToString())
rptPrint.DataSource = dt
rptPrint.DataBind()
End Sub
Screenshot
After Print
