Crurd operation in Asp.net
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 _Default : System.Web.UI.Page
{
SqlConnection con;
SqlCommand cmd;
String sql, name, f_name, add,qua, gen, dob,mail,id,pho;
protected void Page_Load(object sender, EventArgs e)
{
con = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Database.mdf;Integrated Security=True;User Instance=True");
con.Open();
}
protected void Button1_Click(object sender, EventArgs e)
{
id = id_txt.Text;
name = name_txt.Text;
f_name = fname_txt.Text;
add = add_txt.Text;
pho = phone_txt.Text;
dob = dob_txt.Text;
mail = mail_txt.Text;
qua += DropDownList1.SelectedItem.Text.ToString();
gen = RadioButtonList1.SelectedItem.Value.ToString();
sql = "insert into log values('"+id+"','" + name + "','" + f_name + "','" + add + "','" + pho + "','" + gen + "','" + qua + "','" + dob + "','"+mail+"')";
cmd = new SqlCommand(sql, con);
cmd.ExecuteNonQuery();
id_txt.Text = "";
name_txt.Text = "";
fname_txt.Text = "";
add_txt.Text = "";
phone_txt.Text = "";
dob_txt.Text = "";
mail_txt.Text = "";
Response.Write("Value Saved Successfully");
}
protected void Button2_Click1(object sender, EventArgs e)
{
sql = "delete from log where ID='" + id_txt.Text + "'";
cmd = new SqlCommand(sql, con);
cmd.ExecuteNonQuery();
Response.Write("Record is Deleted");
}
protected void Button3_Click(object sender, EventArgs e)
{
SqlDataReader dr;
int MyId;
MyId = int.Parse(id_txt.Text);
sql = "select * from log where ID='" + MyId + "'";
cmd = new SqlCommand(sql, con);
dr = cmd.ExecuteReader();
if (dr.Read() == true)
{
name_txt.Text = dr["Name"].ToString();
fname_txt.Text = dr["F_Name"].ToString();
add_txt.Text = dr["Address"].ToString();
phone_txt.Text = dr["Phone"].ToString();
RadioButtonList1.SelectedValue = dr["Gender"].ToString();
DropDownList1.SelectedItem.Text = dr["Qualification"].ToString();
dob_txt.Text = dr["DOB"].ToString();
mail_txt.Text = dr["Mail"].ToString();
}
else
Response.Write("value not found");
name_txt.Text = " ";
fname_txt.Text = " ";
add_txt.Text = " ";
phone_txt.Text = " ";
dob_txt.Text = " ";
mail_txt.Text = " ";
}
protected void Button4_Click(object sender, EventArgs e)
{
sql = "update log set Name='" + name_txt.Text + "',F_Name='" + fname_txt.Text + "',Address='" + add_txt.Text + "',Phone='" + phone_txt.Text + "',Gender='" + RadioButtonList1.SelectedItem.Value + "',Qualification='" + DropDownList1.SelectedItem.Text + "',DOB='" + dob_txt.Text + "',Mail='" + mail_txt.Text + "' where ID='"+id_txt.Text+"'";
cmd = new SqlCommand(sql, con);
cmd.ExecuteNonQuery();
Response.Write("Record Successfully Updated");
}
protected void Button5_Click(object sender, EventArgs e)
{
if (FileUpload1.HasFile)
{
string FileName = "";
string FilePath = "";
FilePath = Server.MapPath("~\\photo\\");
FileName = FileUpload1.FileName;
FilePath += FileName;
FileUpload1.PostedFile.SaveAs(FilePath);
Image1.ImageUrl = "~/photo/" + FileName;
Label1.Visible = true;
Label1.Text = "Record Display & Save";
}
else
{
Label1.Text = "You have not specified a file.";
}
}
}
0 Comments