manju: December 2011

Monday 26 December 2011

manjunath

</div>

Output:

Tuesday 20 December 2011

Simple form validation in javascript

<html>
<head>

<script type="text/javascript">
function validateForm()
{
var x=document.forms["myForm"]["fname"].value;
if (x==null || x=="")
{
alert("First name must be filled out");
return false;
}

var y=document.forms["myForm"]["mail"].value;
var atpos=y.indexOf("@");
var dotpos=y.lastIndexOf(".");
if (atpos<1 || dotpos<atpos+2 || dotpos+2>=y.length)
{
alert("Not a valid e-mail address");
return false;
}

var z=document.forms["myForm"]["phone"].value;
if (z==null || z=="")
{
alert("phone number required")
return false;
}
else if(isNaN(z)||z.indexOf(" ")!=-1)
{
alert("Enter numeric value")
return false;
}
else if (z.length<10)
{
alert("enter 10 characters");
return false;
}
else if(z.length>10)
{
alert("Number exceeds 10 characters ........ please enter 10 digit number");
return false;
}

var a=document.forms["myForm"]["subject"].value;
if (a==null || a=="")
{
alert("Subject required");
return false;
}

var b=document.forms["myForm"]["message"].value;
if (b==null || b=="")
{
alert(" Enter your message");
return false;
}
}
</script>

</head>
<body>

<form name="myForm" action="demo_form.asp" onsubmit="return validateForm()" method="post">
<table border="0" height="393" align="center" bordercolor="#CCCCCC" cellpadding="0" cellspacing="0">
<tr>
<td width="95"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">First
Name *</font></td>
<td colspan="2">
<input type="text" name="fname" size="30"/>
</td>
</tr>
<tr>
<td width="95"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Your
E-mail *</font></td>
<td colspan="2">
<input type="text" name="mail" size="30" />
</td>
</tr>
<tr>
<td width="95"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">City</font></td>
<td colspan="2">
<input name="city" type="text" size="30" />
</td>
</tr>
<tr>
<td width="95"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">County</font></td>
<td colspan="2">
<input name="county" type="text" size="30" />
</td>
</tr>
<tr>

<td width="95"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Phone
* </font></td>
<td colspan="2">
<input name="phone" type="text" size="30" onkeypress="return numere(event)" onkeyup="return limitarelungime(this, 10)" />
</td>
</tr>
<tr>
<td width="95"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Subject
*</font></td>
<td colspan="2">
<input name="subject" type="text" size="30" />
</td>
</tr>
<tr>
<td width="95"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Message
*</font></td>

<td colspan="2">
<textarea name="message" onKeyUp="return limitarelungime(this, 255)" cols="35" rows="5"></textarea>
</td>
</tr>

<tr>
<td width="95"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"></font>
</td>
<td colspan="2"> </td>
</tr>
<tr>
<td width="95"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"></font></td>
<td align="right" width="132">
<div align="left">
<input type="submit" name="Submit" value="Submit">
<input type="submit" name="Submit2" value="Cancel" onClick="this.form.reset()" >
</div>
</td>
<td align="right" width="70"> </td>

</tr>
</table>
</form>

</body>

-------------------------------------------------------------------------------------------------
output:

Monday 5 December 2011

Binding dropdownlist in asp

protected void ddlload()
{
SqlDataAdapter da = new SqlDataAdapter("select regno from student", cn);
DataTable dt = new DataTable();
da.Fill(dt);
ddl.DataSource = dt;
ddl.DataTextField = "columnname"; /// "regno" in the above query
ddl.DataValueField = "columnname"; /// "regno" in the above query
ddl.DataBind();
ddl.Items.Insert(0, "Select regno");/// first item like Select

ddl.Items.Insert(ddlcountry.Items.Count, "Others");////last item like others
}

Call this function in Pageload...........

We can download any .dll files from this website

http://www.alldll.net

explore once its actually good one for developer.........
fixing .dll files may be bigger issue if u dont know about .dll files............

Friday 2 December 2011

login page in asp .net

using System;

using System.Data;

using System.Configuration;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

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

{

protected void Page_Load(object sender, EventArgs e)

{

}

protected void Login1_Authenticate(object sender,AuthenticateEventArgs e)

{

try

{

string uname = Login1.UserName.Trim(); //Get the username from the control

string password = Login1.Password.Trim(); //get the Password from the control

bool flag = AuthenticateUser(uname, password);

if (flag == true)

{

e.Authenticated = true;

Login1.DestinationPageUrl = “After_Login.aspx”;

}

else

e.Authenticated = false;

}

catch (Exception)

{

e.Authenticated = false;

}

private bool AuthenticateUser(string uname, string password)

{

bool bflag = false;

string connString =“Server=localhost;Database=mproi;Uid=sa;Pwd=;”;

string strSQL = “select * from tbl_user where user_name =’” + uname + “‘ AND user_password =’” + password + “‘”;

DataSet userDS = new DataSet();

SqlConnection m_conn;

SqlDataAdapter m_dataAdapter;

SqlCommand m_Command;

try

{

m_conn = new SqlConnection(connString);

m_conn.Open();

m_dataAdapter = new SqlDataAdapter(strSQL, m_conn);

m_dataAdapter.Fill(userDS);

m_conn.Close();

}

catch (Exception ex)

{

userDS = null;

}

if (userDS != null)

{

if(userDS.Tables[0].Rows.Count > 0)

bflag = true;

}

return bflag;

}