HTML DESIGN CRUD WITH BOOSTRAP
DESIGN:--->>>>>>>>>
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="QREG.aspx.cs" Inherits="QREG" %>
Registration Form
-----------------------------------------------------------------
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 CrystalDecisions.CrystalReports.Engine;
using System.Diagnostics;
using System.IO;
public partial class QREG : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
showdegree();
showgrid();
}
}
SqlConnection cn = new SqlConnection(ConfigurationManager.AppSettings["db1"]);
protected void btnPhoto_Click(object sender, EventArgs e)
{
PicUpload.SaveAs(Server.MapPath("~") + "//PIC//" + PicUpload.FileName);
Image1P.ImageUrl = "~/PIC/" + PicUpload.FileName;
Label1P.Text = PicUpload.FileName;
}
protected void btnDoc_Click(object sender, EventArgs e)
{
DOCupload.SaveAs(Server.MapPath("~") + "//DUC//" + DOCupload.FileName);
Label2D.Text = DOCupload.FileName;
}
protected void showdegree()
{
cn.Open();
SqlCommand cm = new SqlCommand("SELECT * FROM AMSDPT", cn);
SqlDataReader dr = cm.ExecuteReader();
ddldegree.DataSource = dr;
ddldegree.DataTextField = "Degree";
ddldegree.DataValueField = "Id";
ddldegree.DataBind();
ddldegree.Items.Insert(0, "Select");
dr.Close();
}
protected void showbranch()
{
cn.Open();
SqlCommand cm = new SqlCommand("SELECT * FROM AMSDPTB WHERE Id='" + ddldegree.SelectedItem.Value + "'", cn);
SqlDataReader dr = cm.ExecuteReader();
ddlbranch.DataSource = dr;
ddlbranch.DataTextField = "Branch";
ddlbranch.DataBind();
ddlbranch.Items.Insert(0, "Select");
dr.Close();
}
protected void ddldegree_SelectedIndexChanged(object sender, EventArgs e)
{
showbranch();
}
protected void showreg123()
{
SqlCommand cm = new SqlCommand("SELECT COUNT(Id)+1 FROM AMSDPTREG", cn);
txtid.Text = cm.ExecuteScalar().ToString();
cm = new SqlCommand("INSERT INTO AMSDPTREG(Id,SName,Gender,Email,Mobile,Age,Degree,Branch,Photo,Document,Status)" +
" VALUES(@Id1,@SName1,@Gender1,@Email1,@Mobile1,@Age1,@Degree1,@Branch1,@Photo1,@Document1,@Status1)", cn);
cm.Parameters.AddWithValue("Id1", txtid.Text);
cm.Parameters.AddWithValue("SName1", txtname.Text);
if (RadioButton1.Checked == true)
{
cm.Parameters.AddWithValue("Gender1", RadioButton1.Text);
}
else
{
cm.Parameters.AddWithValue("Gender1", RadioButton2.Text);
}
cm.Parameters.AddWithValue("Email1", txtemail.Text);
cm.Parameters.AddWithValue("Mobile1", txtmob.Text);
cm.Parameters.AddWithValue("Age1", txtage.Text);
cm.Parameters.AddWithValue("Degree1", ddldegree.SelectedItem.Text);
cm.Parameters.AddWithValue("Branch1", ddlbranch.Text);
cm.Parameters.AddWithValue("Photo1", Label1P.Text);
cm.Parameters.AddWithValue("Document1", Label2D.Text);
cm.Parameters.AddWithValue("Status1", labelstatus.Text);
cm.ExecuteNonQuery();
Response.Write("");
showgrid();
}
protected void btnreg_Click(object sender, EventArgs e)
{
cn.Open();
if (CheckBox1.Checked == true)
{
if(ddldegree.Text == "Select")
{
Response.Write("");
}
if(ddlbranch.Text == "Select")
{
Response.Write("");
}
if(txtmob.Text == "")
{
Response.Write("");
}
showreg123();
}
else
{
Response.Write("");
}
}
protected void showgrid()
{
SqlConnection cn = new SqlConnection(ConfigurationManager.AppSettings["db1"]);
cn.Open();
SqlCommand cm = new SqlCommand("SELECT * FROM AMSDPTREG", cn);
SqlDataReader dr = cm.ExecuteReader();
GridView1.DataSource = dr;
GridView1.DataBind();
foreach (GridViewRow r1 in GridView1.Rows)
{
TextBox txtn = (TextBox)r1.FindControl("txtn");
TextBox txtem = (TextBox)r1.FindControl("txtem");
TextBox txtmb = (TextBox)r1.FindControl("txtmb");
Label txtst = (Label)r1.FindControl("LGSTATUS");
if (dr.Read())
{
txtn.Text = dr["txtn"].ToString();
txtem.Text = dr["txtem"].ToString();
txtmb.Text = dr["txtmb"].ToString();
txtst.Text = dr["LGSTATUS"].ToString();
}
}
dr.Close();
}
protected void btncncl_Click(object sender, EventArgs e)
{
txtid.Text = "";
txtname.Text = "";
txtemail.Text = "";
txtmob.Text = "";
txtage.Text = "";
ddldegree.SelectedItem.Text = "Select";
ddlbranch.Text = "Select";
Label1P.Text = "";
Label2D.Text = "";
labelstatus.Text = "";
}
protected void btnrep_Click(object sender, EventArgs e)
{
//Process.Start(@"CrystalReport.exe");
//Process notePad = new Process();
//notePad.StartInfo.FileName = "crw32.exe";
//ReportDocument cryRpt = new ReportDocument();
//string reportPath = Path.GetDirectoryName(Application.ExecutablePath);
//string reportFullPath = Path.Combine(reportPath, "CrystalReport3.rpt");
//notePad.StartInfo.Arguments = reportFullPath;
//notePad.Start();
//showgrid();
}
protected void btnedit_Click(object sender, EventArgs e)
{
cn.Open();
GridViewRow r1 = ((Button)sender).NamingContainer as GridViewRow;
TextBox txtn = (TextBox)r1.FindControl("txtn");
TextBox txtem = (TextBox)r1.FindControl("txtem");
TextBox txtmb = (TextBox)r1.FindControl("txtmb");
Label txtst = (Label)r1.FindControl("LGSTATUS");
DropDownList ddlst = (DropDownList)r1.FindControl("ddlstatus1");
SqlCommand cm = new SqlCommand("UPDATE AMSDPTREG SET SName=@SName1,Email=@Email1,Mobile=@Mobile1,Status=@Status1 WHERE Id=@Id1", cn);
cm.Parameters.AddWithValue("Id1", txtid.Text);
cm.Parameters.AddWithValue("SName1", txtn.Text);
cm.Parameters.AddWithValue("Email1", txtem.Text);
cm.Parameters.AddWithValue("Mobile1", txtmb.Text);
cm.Parameters.AddWithValue("Status1", ddlst.Text);
cm.ExecuteNonQuery();
Response.Write("");
}
}
Comments
Post a Comment