Hi micah
Refer below code.
HTML
<div class="form-group-inner">
<div class="row">
<div class="col-lg-3 col-md-3 col-sm-3 col-xs-12">
<label class="login2 pull-right pull-right-pro">ID </label>
</div>
<div class="col-lg-9 col-md-9 col-sm-9 col-xs-12">
<div class="input-group mg-b-pro-edt">
<span class="input-group-addon"><i class="fa fa-sticky-note-o" aria-hidden="true"></i></span>
<asp:TextBox ID="txtid" runat="server" CssClass="form-control" placeholder=" ID"></asp:TextBox>
</div>
</div>
</div>
</div>
<div class="form-group-inner">
<div class="row">
<div class="col-lg-3 col-md-3 col-sm-3 col-xs-12">
<label class="login2 pull-right pull-right-pro">Date</label>
</div>
<div class="col-lg-9 col-md-9 col-sm-9 col-xs-12">
<div class="form-group data-custon-pick" id="data_1">
<div class="input-group date">
<span class="input-group-addon"><i class="fa fa-calendar"></i></span>
<asp:TextBox ID="txtdate" runat="server" CssClass="form-control" placeholder="Collection Date- DD/MM/YY" type="text" ReadOnly="True"></asp:TextBox>
</div>
</div>
</div>
</div>
</div>
<div class="form-group-inner">
<div class="row">
<div class="col-lg-3 col-md-3 col-sm-3 col-xs-12">
<label class="login2 pull-right pull-right-pro">Receipt </label>
</div>
<div class="col-lg-9 col-md-9 col-sm-9 col-xs-12">
<div class="input-group mg-b-pro-edt">
<span class="input-group-addon"><i class="fa fa-sticky-note-o" aria-hidden="true"></i></span>
<asp:TextBox ID="txtcode2" runat="server" CssClass="form-control" placeholder=" Receipt" ReadOnly="True"></asp:TextBox>
</div>
</div>
</div>
</div>
<div class="text-right">
<asp:LinkButton ID="btnorder" runat="server" CssClass="btn btn-default" OnClick="btnorder_Click"> Submit Order</asp:LinkButton>
</div>
<div class="text-right">
<asp:LinkButton ID="btnorder2" runat="server" CssClass="btn btn-default" OnClick="btnorder2_Click" Visible="false">Final Submit Order</asp:LinkButton>
</div>
Code
C#
protected void btnorder_Click(object sender, EventArgs e)
{
// Insert code.
int inserted = 0;
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = str;
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
//Change the query like below
//Make sure the column name matches the with the name provided in code as per your table
cmd.CommandText = "INSERT INTO ItemOrdered1 (ID,Date,Receipt) VALUES(@ID,@Date,@Receipt)";
// cmd.Parameters.AddWithValue("@UserName", HttpContext.Current.User.Identity.Name);
cmd.Parameters.AddWithValue("@ID", txtid.Text.Trim());
cmd.Parameters.AddWithValue("@Date", txtdate.Text.Trim);
cmd.Parameters.AddWithValue("@Receipt", txtcode2.Text.Trim());
con.Open();
inserted = cmd.ExecuteNonQuery();
con.Close();
grandtotal();
BindDatalist();
string message = string.Empty;
ScriptManager.RegisterClientScriptBlock(btnorder, this.GetType(), "alert", "<script>alert('Data Submitted Successfully ... !!')</script>", false);
}
}
btnorder.Visible = false;
btnorder2.Visible = true;
}
protected void btnorder2_Click(object sender, EventArgs e)
{
// Insert code.
btnorder.Visible = true;
btnorder2.Visible = false;
}
VB.Net
Protected Sub btnorder_Click(ByVal sender As Object, ByVal e As EventArgs)
Dim inserted As Integer = 0
Using con As SqlConnection = New SqlConnection()
con.ConnectionString = str
Using cmd As SqlCommand = New SqlCommand()
cmd.CommandType = CommandType.Text
cmd.Connection = con
cmd.CommandText = "INSERT INTO ItemOrdered1 (ID,Date,Receipt) VALUES(@ID,@Date,@Receipt)"
cmd.Parameters.AddWithValue("@ID", txtid.Text.Trim())
cmd.Parameters.AddWithValue("@Date", txtdate.Text.Trim)
cmd.Parameters.AddWithValue("@Receipt", txtcode2.Text.Trim())
con.Open()
inserted = cmd.ExecuteNonQuery()
con.Close()
grandtotal()
BindDatalist()
Dim message As String = String.Empty
ScriptManager.RegisterClientScriptBlock(btnorder, Me.[GetType](), "alert", "<script>alert('Data Submitted Successfully ... !!')</script>", False)
End Using
End Using
btnorder.Visible = False
btnorder2.Visible = True
End Sub
Protected Sub btnorder2_Click(ByVal sender As Object, ByVal e As EventArgs)
btnorder.Visible = True
btnorder2.Visible = False
End Sub