Save and Print inserted form data in ASP.Net using C# and VB.Net

muhammad...

SOLVED CLOSED ACTIVE ANSWERED
User: muhammad12
Posted: on Dec 30, 2021 05:48 AM
Forum: Data Controls
Answer: 1
Views: 5763

Hi dharmendr sir,

Sir can you please help me by updating my code.

I wrote a code to save data into database.

I want when I click on save button then that data should be view also.

And there should be print button by clicking that to take print of that page with unique tracking ID on top of page. When I take print then on print page a unique id should be appear on that page.

My code is attached below. Please help me sir for doing this.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

namespace IT
{
    public partial class assignItemHQ : System.Web.UI.Page
    {
        protected void Button1_Click(object sender, EventArgs e)
        {
            string str = @"";
            SqlConnection con = new SqlConnection(str);
            con.Open();
            SqlCommand cmd = new SqlCommand("insert into InventoryRecord values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + DropDownList3.Text + "','" + TextBox6.Text + "','" + DropDownList2.Text + "','" + DropDownList1.Text + "','" + TextBox7.Text + "')");
            cmd.CommandType = System.Data.CommandType.Text;
            cmd.Connection = con;
            cmd.ExecuteNonQuery();
            Label1.Text = "record saved successfully";
        }
    }
}

<body>
    <form id="form2" runat="server">
        <div class="row">
            <div class="col-75">
                <div class="container">
                    <h2>ASSIGN ITEM TO AIRBLUE HQ ISB EMPLOYEES</h2>
                    <br />
                    <div class="row">
                        <div class="col-50">

                            <label>Item Name*</label>
                            <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
                            <label>Quantity*</label>
                            <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
                            <label>Model*</label>
                            <asp:TextBox ID="TextBox3" runat="server" CssClass="cc"></asp:TextBox>
                            <label>Serial #</label>
                            <asp:TextBox ID="TextBox4" runat="server" CssClass="remarks"></asp:TextBox>
                            <label>Assigned To*</label>
                            <asp:TextBox ID="TextBox6" runat="server" CssClass="fileupload"></asp:TextBox>
                        </div>
                        <div class="col-50">
                            <label for="fname">Assignment Type*</label>
                            <asp:DropDownList ID="DropDownList3" runat="server" class="icon-container">
                                <asp:ListItem>Temporary</asp:ListItem>
                                <asp:ListItem>Permanant</asp:ListItem>
                            </asp:DropDownList>
                            <label for="cname">Dept*</label>
                            <asp:DropDownList ID="DropDownList2" runat="server" class="icon-container">
                                <asp:ListItem>MIS IT</asp:ListItem>
                                <asp:ListItem>Accounts</asp:ListItem>
                                <asp:ListItem>Finance</asp:ListItem>
                                <asp:ListItem>FOC</asp:ListItem>
                                <asp:ListItem>LC</asp:ListItem>
                                <asp:ListItem>Transport</asp:ListItem>
                                <asp:ListItem>Scheduling</asp:ListItem>
                                <asp:ListItem>Revenue</asp:ListItem>
                                <asp:ListItem>Marketing</asp:ListItem>
                                <asp:ListItem>APT ops</asp:ListItem>
                                <asp:ListItem>Airside</asp:ListItem>
                                <asp:ListItem>Manuals</asp:ListItem>
                                <asp:ListItem>HR</asp:ListItem>
                            </asp:DropDownList>
                            <label for="ccnum">Assigned By*</label>
                            <asp:DropDownList ID="DropDownList1" runat="server" class="icon-container">
                                <asp:ListItem>Ali Raza</asp:ListItem>
                                <asp:ListItem>Murtaza Moghal</asp:ListItem>
                                <asp:ListItem>Khuram Bilal</asp:ListItem>
                                <asp:ListItem>Shaban Irshad</asp:ListItem>
                                <asp:ListItem>Sofia Abbasi</asp:ListItem>
                            </asp:DropDownList>
                            <label for="expmonth">Date*</label>
                            <asp:TextBox ID="TextBox7" runat="server" TextMode="Date" class="icon-container"></asp:TextBox>
                        </div>
                    </div>

                    <asp:Button ID="Button1" runat="server" Text="Add Record" class="btn" />
                    <asp:Label ID="Label1" runat="server"></asp:Label>
                </div>
            </div>
        </div>
    </form>
</body>

Download FREE API for Word, Excel and PDF in ASP.Net

arjunv

0 5

Reply
ANSWER
User: arjunv
Replied: on Dec 31, 2021 01:16 AM
Modified: on Dec 31, 2021 01:25 AM
Report

Hi muhammad12,

Please refer below Sample.

Database

I have made use of the following table Customers with the schema as follows.

I have already inserted few records in the table.

You can download the database table SQL by clicking the download link below.

Download SQL file

HTML

<table>
    <tr>
       <td>Name:</td>
       <td><asp:TextBox runat="server" ID="txtName"></asp:TextBox></td>
    </tr>
    <tr>
        <td>Country:</td>
        <td><asp:TextBox runat="server" ID="txtCountry"></asp:TextBox></td>
    </tr>
    <tr>
        <td colspan="2" style="text-align: center">
            <asp:Button Text="Save" ID="btnSave" runat="server" OnClick="Save" /></td>
    </tr>
</table>
<hr />
<asp:Panel runat="server" ID="pnlDetails">
    <table>
        <tr>
            <td>Name:</td>
            <td><asp:Label runat="server" ID="lblName"></asp:Label></td>
        </tr>
        <tr>
            <td>Country:</td>
            <td><asp:Label runat="server" ID="lblCountry"></asp:Label></td>
        </tr>
    </table>
</asp:Panel>
<hr />
<asp:Button Text="Print" ID="btnPrint" runat="server" OnClientClick="PrintPanel()" />

<script type = "text/javascript">
    function PrintPanel() {
        var panel = document.getElementById("<%=pnlDetails.ClientID %>");
        var printWindow = window.open('', '', 'height=400,width=800');
        printWindow.document.write('<html><head><title></title>');
        printWindow.document.write('</head><body >');
        printWindow.document.write(panel.innerHTML);
        printWindow.document.write('</body></html>');
        printWindow.document.close();
        setTimeout(function () {
            printWindow.print(PrintPanel);
        }, 500);
        return false;
    }
</script>

Namespaces

using System.Data;
using System.Data.SqlClient;
using System.Configuration;

VB.Net

Imports System.Data
Imports System.Data.SqlClient
Imports System.Configuration

Code

protected void Save(object sender, EventArgs e)
{
    string name = txtName.Text;
    string country = txtCountry.Text;

    this.lblName.Text = name;
    this.lblCountry.Text = country;
    string conString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    using (SqlConnection con = new SqlConnection(conString))
    {
        using (SqlCommand cmd = new SqlCommand("INSERT INTO Customers (Name, Country) VALUES (@Name, @Country)",con))
        {
            cmd.Parameters.AddWithValue("@Name", name);
            cmd.Parameters.AddWithValue("@Country", country);
            cmd.Connection = con;
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
        }
    }
}

VB.Net

Protected Sub Save(ByVal sender As Object, ByVal e As EventArgs)
    Dim name As String = txtName.Text
    Dim country As String = txtCountry.Text
    Me.lblName.Text = name
    Me.lblCountry.Text = country
    Dim conString As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
    Using con As SqlConnection = New SqlConnection(conString)
        Using cmd As SqlCommand = New SqlCommand("INSERT INTO Customers (Name, Country) VALUES (@Name, @Country)", con)
            cmd.Parameters.AddWithValue("@Name", name)
            cmd.Parameters.AddWithValue("@Country", country)
            cmd.Connection = con
            con.Open()
            cmd.ExecuteNonQuery()
            con.Close()
        End Using
    End Using
End Sub

Screenshot

Print

Output

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Save and Print inserted form data in ASP.Net using C# and VB.Net

Company

Explore

Follow us

Contact Us