Asp.net how to use validation control code
Actually im designing my web page, in that i have typed in the book id and
Nameofthebook. typed and then click the button the book are available is go to another page and then not available is display the error message is book is not available My project (Library management system) Asp.net sql server how to validate the page and how to set validate control and how to set validate control code... send me full detailsMy code
using System;
using System.Collections;
using System.Configuration;
using System.Data;
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;
using System.Data.SqlClient;
public partial class Bookcheck : System.Web.UI.Page
{
public Int64 Sid;
protected void Page_Load(object sender, EventArgs e)
{
string Id;
开发者_运维知识库 Id = Request.QueryString.Get(0);
if (!(IsPostBack == true))
{
if (Request.QueryString.Get(1) == "G")
{
Sid = Convert.ToInt64(Id);
if (PopulatedRecord (Sid ) == false)
{
}
}
}
}
private Boolean PopulatedRecord(Int64 Id)
{
DataSet DS;
DS = new DataSet();
SqlCommand cmd = new SqlCommand();
SqlDataAdapter da = new SqlDataAdapter();
SqlConnection Cnn = new SqlConnection();
string connectionstring;
connectionstring = @"Datasource=DEVI\SQLEXPRESS;Intial catalog=librarymanagement;Integrated Security=SSPI";
Cnn.ConnectionString = connectionstring;
if (Cnn.State != ConnectionState.Open)
Cnn.Open();
cmd.Connection = Cnn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usbinsertdatainto";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@bookId",txtid );
da.SelectCommand = cmd;
try
{
da.Fill(DS);
}
catch (Exception ex)
{
throw new ApplicationException(
"!!! An Error Occured While Update Record In Dtl_SecurityCapital_Upload." + ex.Message);
lblerror.Visible = true;
lblerror.Text = "!!! An Error Occured While " + ex.Message.ToString();
return false;
}
if (DS.Tables[0].Rows.Count > 0)
{
txtid.Text = DS.Tables[0].Rows[0]["bookId"].ToString();
txtnb.Text = DS.Tables[0].Rows[0]["Nameofthebook"].ToString();
}
cmd.Dispose();
Cnn.Close();
Cnn.Dispose();
return true;
}
}
protected void Button2_Click(object sender, EventArgs e)
{
if(Page.IsValid )
{
Response.Redirect ("issueofbook.aspx?bookid="+txtid.Text
+"&Nameofthebook="+txtnb.Text);
}
}
}
Error
Line 59: throw new ApplicationException(
Line 60: "!!! An Error Occured While
Update
Record In Dtl_SecurityCapital_Upload." + ex.Message);
Line 61: lblerror.Visible = true;
Line 62: lblerror.Text = "!!! An Error
Occured While " +
ex.Message.ToString();
Line 63: return false;
Dear,
Use RequiredFieldValidator
(ASP.NET control) for checking TextBox are empty or not.
or
use JavaScript to check Textbox is empty or not
Markup:
<asp:TextBox ID="txtNo" runat="server" />
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ErrorMessage="No Required " ControlToValidate="txtNo" />
<asp:TextBox ID="txtName" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ErrorMessage="Name Required " ControlToValidate="txtName" />
<asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Button" />
Button click event :
protected void Button1_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
Response.Redirect("~/Newpage.aspx?no=" + txtNo.Text + "&name=" + txtName.Text);
}
}
精彩评论