Sradha WebCreations | mobile app designing Company In Cuttack,Bhubaneswar odisha: Student database management system

Showing posts with label Student database management system. Show all posts

Sunday, August 12, 2018

how to create Username availability Using Ajax | Sradha Webcreations

how to create Check Username availability
Using Ajax Sql Server + asp.net

http://localhost:1211/CheckUserNameAvailability/Default.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" EnableEventValidation="false" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>Check Username availability Using Ajax</title>

.waitingdiv {

background-color: #F5F8FA;

border: 1px solid #5A768E;

color: #333333;

font-size: 93%;

margin-bottom: 1em;

margin-top: 0.2em;

padding: 8px 12px;

width: 8.4em;

}

</style>

</head>

<body>

<asp:ScriptManager ID="scriptmanager1" runat="server">

</asp:ScriptManager>

Sys.WebForms.PageRequestManager.getInstance().add_beginRequest(BeginRequestHandler);

function BeginRequestHandler(sender, args) {

var state = document.getElementById('loadingdiv').style.display;

if (state == 'block') {

document.getElementById('loadingdiv').style.display = 'none';

} else {

document.getElementById('loadingdiv').style.display = 'block';

}

args.get_postBackElement().disabled = true;

}

</script>

<div>

<asp:UpdatePanel ID="PnlUsrDetails" runat="server">

<table>

<tr>

<td>

UserName:

</td>

<td>

<asp:TextBox ID="txtUsername" runat="server" AutoPostBack="true" ontextchanged="txtUsername_TextChanged"/>

</td>

<asp:Image ID="imgstatus" runat="server" Width="17px" Height="17px"/>

<asp:Label ID="lblStatus" runat="server"></asp:Label>

</div>

</td>

</tr>

</table>

<img src="LoadingImage.gif" alt="Loading" />Please wait...

</div><table>

<tr>

<td>

Password:

</td>

 <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox></td>

</div>

</td>

</tr>

<tr>

<td>

 </td>

<asp:FileUpload ID="FileUpload1" runat="server" />

</td>

 </td>

</tr>

</table>

</ContentTemplate>

</asp:UpdatePanel>

<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Create" /></div>

<asp:SqlDataSource ID="SqlDataSource1" runat="server"

ConnectionString="<%$ ConnectionStrings:dbconnection %>"

SelectCommand="SELECT * FROM [UserInformation]"

ProviderName="<%$ ConnectionStrings:dbconnection.ProviderName %>"></asp:SqlDataSource>

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"

DataSourceID="SqlDataSource1">

<asp:BoundField DataField="id" HeaderText="id" InsertVisible="False"

ReadOnly="True" SortExpression="id" />

<asp:BoundField DataField="username" HeaderText="username"

SortExpression="username" />

<asp:BoundField DataField="password" HeaderText="password"

SortExpression="password" />

<asp:BoundField DataField="imagename" HeaderText="imagename"

SortExpression="imagename" />

<asp:HyperLinkField DataNavigateUrlFields="imagepath" DataTextField="imagepath"

HeaderText="View and Download" />

</Columns>

</asp:GridView>

<br />

</form>

</body>

</html>

Default.aspx.CS

using System;

using System.Configuration;

using System.Data;

using System.Data.SqlClient;

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.IO ;

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

{

protected void Page_Load(object sender, EventArgs e)

{

}

protected void txtUsername_TextChanged(object sender, EventArgs e)

{

if(!string.IsNullOrEmpty(txtUsername.Text))

{

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString);

con.Open();

SqlCommand cmd = new SqlCommand("select * from UserInformation where UserName=@Name", con);

cmd.Parameters.AddWithValue("@Name", txtUsername.Text);

SqlDataReader dr = cmd.ExecuteReader();

if (dr.HasRows)

{

checkusername.Visible = true;

imgstatus.ImageUrl = "NotAvailable.jpg";

lblStatus.Text = "UserName Already Taken";

System.Threading.Thread.Sleep(200);

}

else

{

checkusername.Visible = true;

imgstatus.ImageUrl = "Icon_Available.gif";

lblStatus.Text = "UserName Available";

System.Threading.Thread.Sleep(200);

}

else

{

checkusername.Visible = false;

}

protected void Button1_Click(object sender, EventArgs e)

{

string connectionString = ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString;

string insertSql = "INSERT INTO userinformation(username, password,imagename,imagepath) VALUES(@username, @password,@imagename,@imagepath)";

String filename;

filename = Path.GetFileName( FileUpload1 .PostedFile.FileName );

//'Save images into Images folder

if (filename.Length == 0)

{

filename = "No Picture ";

}

else

{

FileUpload1.SaveAs(Server.MapPath("Image/" + filename));

}

using (SqlConnection myConnection = new SqlConnection(connectionString))

{

myConnection.Open();

SqlCommand myCommand = new SqlCommand(insertSql, myConnection);

myCommand.Parameters.AddWithValue("@username", txtUsername.Text.Trim ());

myCommand.Parameters.AddWithValue("@password", TextBox1.Text.Trim ());

myCommand.Parameters.AddWithValue ("@imagename", filename);

myCommand.Parameters.AddWithValue("@imagepath", "Image/"+ filename);

myCommand.ExecuteNonQuery();

myConnection.Close();

}

// "Reset" the Subject and Body TextBoxes

txtUsername .Text = string.Empty;

TextBox1 .Text = string.Empty;

}

#SradhaWebCreations Contact : +91-9040573923, +91-7008182025 http://sradhawebcreations.com/ http://sradhawebcreations.blogspot.in/ https://facebook.com/sradhawebcreations https://www.facebook.com/Sradhawebeducation/

Friday, August 10, 2018

how to create registration wizard in any website | CAF | Sradha Webcreations

how to create registration wizard in any website

Design Common Application Form (CAF) for any website

(ASP.NET + SQL SERVER)

EMPLOYEE INFORMATION WIZARD Or CAF

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Wizard_employee.aspx.cs" Inherits="Wizard_employee" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<div>

<asp:Wizard ID="Wizard1" runat="server" ActiveStepIndex="3" Height="443px"

Width="881px">

<asp:WizardStep ID="EmployeeInformation" runat="server" title="Step 1">

<tr>

<strong>              Employee Information</strong></td>

</tr>

<tr>

 </td>

<td>

 </td>

</tr>

<tr>

Name</td>

<td>

<asp:TextBox ID="TextBoxNAME" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

Designation</td>

<td>

<asp:TextBox ID="TextBoxDESIGNATION" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

Remunaretion</td>

<td>

<asp:TextBox ID="TextBoxREMUNARETION" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

Qualification</td> <asp:TextBox ID="TextBoxQUALIFICATION" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

Reg by</td>

<td>

<asp:TextBox ID="TextBoxREG_BY" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

Date Of Birth</td>

<td>

<asp:TextBox ID="TextBoxDOB" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

Joining Date</td> <asp:TextBox ID="TextBoxJOINDATE" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

Now Posting</td>

<td>

<asp:TextBox ID="TextBoxNOWPOSTING" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

 </td>

<td>

 </td>

</tr>

<tr>

 </td>

</tr>

</table>

</asp:WizardStep>

<asp:WizardStep ID="LeaveStatus" runat="server" title="Step 2">

<tr>

</tr>

<tr>

 </td>

<td>

 </td>

</tr>

<tr>

Department</td>

<td>

<asp:DropDownList ID="DropDownListDEPARTMENT" runat="server" Width="124px">

<asp:ListItem>Select 1</asp:ListItem>

<asp:ListItem>Sales</asp:ListItem>

<asp:ListItem>Production</asp:ListItem>

<asp:ListItem>Administrative</asp:ListItem>

<asp:ListItem>Transport</asp:ListItem>

<asp:ListItem>Purchase</asp:ListItem>

</asp:DropDownList>

</td>

</tr>

<tr>

Employee Name</td>

<td>

<asp:TextBox ID="TextBoxEMPNAME" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

Area Of Posting</td>

<td>

asp:TextBox ID="TextBoxAREAOFPOSTING" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

 </td>

<td>

 </td>

</tr>

</table>

</asp:WizardStep>

<asp:WizardStep ID="PostingDetails" runat="server" Title="Step 3">

<tr>

<strong>               Posting  Details</strong></td>

</tr>

<tr>

 </td>

<td>

 </td>

</tr>

<tr>

Employee Name</td>

<td>

<asp:TextBox ID="TextBoxEMPLOYEENAME" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

Designation</td>

<td>

<asp:TextBox ID="TextBoxEMPDESIGNATION" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

Date Of Join</td>

<td>

<asp:TextBox ID="TextBoxDOBJOIN" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

<strong>Conformation</strong></td>

<td>

<asp:TextBox ID="TextBoxCONFORMATION" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

(Tranfer)</td>

<td>

 </td>

</tr>

<tr>

 </td>

<td>

 </td>

</tr>

</table>

</asp:WizardStep>

<asp:WizardStep ID="CurrentSalary" runat="server" Title="Step 4">

<tr>

<strong>                  Current Salary</strong></td>

</tr>

<tr>

 </td>

<td>

 </td>

</tr>

<tr>

Emp Name</td>

<asp:TextBox ID="TextBoxEMPLOYEEFULLNAME" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

Remunaretion</td>

<td>

<asp:TextBox ID="TextBoxEMPREMUNARETION" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

Basic</td>

<td>

<asp:TextBox ID="TextBoxBASIC" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

PF</td>

<td>

<asp:TextBox ID="TextBoxPF" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

ESI</td>

<td>

<asp:TextBox ID="TextBoxESI" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

TDS</td>

<td>

<asp:TextBox ID="TextBoxTDS" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

Year Leave No.</td>

<td>

<asp:TextBox ID="TextBoxYEARLEAVE" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

 </td>

<td>

 </td>

</tr>

</table>

</asp:WizardStep>

</WizardSteps>

</asp:Wizard>

</div>

</form>

</body>

</html>

Create Database store data in SQl Server

Code View

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;

using System.Web.Security;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

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

{

protected void ButtonSAVE_Click(object sender, EventArgs e)

{

string sName = TextBoxNAME.Text;

string sDesignation = TextBoxDESIGNATION.Text;

string sRemunaretion = TextBoxREMUNARETION.Text;

string sQualification = TextBoxQUALIFICATION.Text;

string sRegBy = TextBoxREG_BY.Text;

string sDob = TextBoxDOB.Text;

string sJoinDate = TextBoxJOINDATE.Text;

string sNowPosting = TextBoxNOWPOSTING.Text;

string sDepartment = DropDownListDEPARTMENT.Text;

string sEmpName = TextBoxEMPNAME.Text;

string sAreaOfPosting = TextBoxAREAOFPOSTING.Text;

string sEmployeeName = TextBoxEMPLOYEENAME.Text;

string sEmpDesignation = TextBoxEMPDESIGNATION.Text;

string sDOJoin = TextBoxDOBJOIN.Text;

string sConformation = TextBoxCONFORMATION.Text;

string sEmpNamee = TextBoxEMPLOYEEFULLNAME.Text;

string sEremunaretion = TextBoxEMPREMUNARETION.Text;

string sEbasic = TextBoxBASIC.Text;

string sEpf = TextBoxPF.Text;

string sEESI = TextBoxESI.Text;

string sETDS = TextBoxTDS.Text;

string sYearOfLeave = TextBoxYEARLEAVE.Text;

string connectionString = ConfigurationManager.ConnectionStrings["DataBaseConnection"].ConnectionString;

string insertSql = "INSERT INTO EMPLOYEE_INFORMATIOIN(NAME,DESIGNATION,remunaretion,qualification,reg_by,dob,joindate,nowposting,department,employeeName,areaOfPosting,EmpName,Edesignation,dojoin,conformation,Empnamee,ERemunaretion,Ebasic,Epf,EESI,ETDS,YearOfLeave) VALUES(@NAME,@DESIGNATION,@remunaretion,@qualification,@reg_by,@dob,@joindate,@nowposting,@department,@employeeName,@areaOfPosting,@EmpName,@Edesignation,@dojoin,@conformation,@Empnamee,@ERemunaretion,@Ebasic,@Epf,@EESI,@ETDS,@YearOfLeave)";

using (SqlConnection myConnection = new SqlConnection(connectionString))

{

myConnection.Open();

SqlCommand myCommand = new SqlCommand(insertSql, myConnection);

myCommand.Parameters.AddWithValue("@NAME", TextBoxNAME.Text);

myCommand.Parameters.AddWithValue("@Designation",TextBoxDESIGNATION.Text);

myCommand.Parameters.AddWithValue("@REMUNARETION",TextBoxREMUNARETION.Text);

myCommand.Parameters.AddWithValue("@Qualification",TextBoxQUALIFICATION.Text);

myCommand.Parameters.AddWithValue("@REG_BY",TextBoxREG_BY.Text);

myCommand.Parameters.AddWithValue("@dob",TextBoxDOB.Text);

myCommand.Parameters.AddWithValue("@joindate",TextBoxJOINDATE.Text);

myCommand.Parameters.AddWithValue("@nowposting",TextBoxNOWPOSTING.Text);

myCommand.Parameters.AddWithValue("@department",DropDownListDEPARTMENT.SelectedValue);

myCommand.Parameters.AddWithValue("@employeeName",TextBoxEMPNAME.Text);

myCommand.Parameters.AddWithValue("@areaOfPosting",TextBoxAREAOFPOSTING.Text);

myCommand.Parameters.AddWithValue("@EmpName",TextBoxEMPLOYEENAME.Text);

myCommand.Parameters.AddWithValue("@Edesignation",TextBoxEMPDESIGNATION.Text);

myCommand.Parameters.AddWithValue("@dojoin",TextBoxDOBJOIN.Text);

myCommand.Parameters.AddWithValue("@conformation",TextBoxCONFORMATION.Text);

myCommand.Parameters.AddWithValue("@empNamee",TextBoxEMPLOYEEFULLNAME.Text);

myCommand.Parameters.AddWithValue("@ERemunaretion",TextBoxEMPREMUNARETION.Text);

myCommand.Parameters.AddWithValue("@Ebasic",TextBoxBASIC.Text);

myCommand.Parameters.AddWithValue("@Epf",TextBoxPF.Text);

myCommand.Parameters.AddWithValue("@EESI",TextBoxESI.Text);

myCommand.Parameters.AddWithValue("@ETDS",TextBoxTDS.Text);

myCommand.Parameters.AddWithValue("@YearOfLeave",TextBoxYEARLEAVE.Text);

myCommand.ExecuteNonQuery();

myConnection.Close();

}

// "Reset" the Subject and Body TextBoxes

TextBoxNAME.Text= string.Empty;

TextBoxDESIGNATION.Text= string.Empty;

TextBoxREMUNARETION.Text= string.Empty;

TextBoxQUALIFICATION.Text= string.Empty;

TextBoxREG_BY.Text= string.Empty;

TextBoxDOB.Text= string.Empty;

TextBoxJOINDATE.Text= string.Empty;

TextBoxNOWPOSTING.Text= string.Empty;

// DropDownListDEPARTMENT.Text= string.Empty;

TextBoxEMPNAME.Text= string.Empty;

TextBoxAREAOFPOSTING.Text= string.Empty;

TextBoxEMPLOYEENAME.Text= string.Empty;

TextBoxEMPDESIGNATION.Text= string.Empty;

TextBoxDOBJOIN.Text= string.Empty;

TextBoxCONFORMATION.Text= string.Empty;

TextBoxEMPLOYEEFULLNAME.Text= string.Empty;

TextBoxEMPREMUNARETION.Text= string.Empty;

TextBoxBASIC.Text= string.Empty;

TextBoxPF.Text= string.Empty;

TextBoxESI.Text= string.Empty;

TextBoxTDS.Text= string.Empty;

TextBoxYEARLEAVE.Text= string.Empty;

}

Pages

Sunday, August 12, 2018

how to create Username availability Using Ajax | Sradha Webcreations

Friday, August 10, 2018

how to create registration wizard in any website | CAF | Sradha Webcreations