CRUD Operations in ASP.NET Web Application using Microsoft SQL Server| Visual Studio 2022 | GridView

Published: 05 April 2024
on channel: RK Keynotes

367

#aspcrud #crudapplications #asp.net #crudinasp #visualstudio2022 #sqldemo #mssqlserver #ado #asp.netcrud #btechprojects #bcaprojects #ugprojectcenters #visualstudio2022 #bscprojects #computerscience #computerscienceproject
CRUD Operations in ASP.NET Web application

Code:

using System; using System.Web.UI; using System.Data; using System.Data.SqlClient;
namespace CRUD_ASP_ADO_DEMO{
public partial class WebForm1 : System.Web.UI.Page{
protected void Page_Load(object sender, EventArgs e){
if (!IsPostBack)
{
LoadRecord();
} }
SqlConnection con = new SqlConnection("Data Source = ravikumar\\sqlexpress; Initial Catalog = Demo; User ID = sa; Password=123;Integrated Security=True");
protected void Button1_Click(object sender, EventArgs e)
{
con.Open();
SqlCommand comm = new SqlCommand("Insert into crudtbl values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "')", con);
comm.ExecuteNonQuery();
con.Close();
ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "alert('Successfully Inserted');", true);
LoadRecord(); ClearData(); }

void LoadRecord()
{
SqlCommand comm = new SqlCommand("select * from crudtbl", con);
SqlDataAdapter d = new SqlDataAdapter(comm);
DataTable dt = new DataTable();
d.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();
}
void ClearData()
{
TextBox1.Text = "";
TextBox2.Text = "";
TextBox3.Text = "";
TextBox4.Text = "";
TextBox5.Text = ""; }

protected void Button2_Click(object sender, EventArgs e)
{
con.Open();
SqlCommand comm = new SqlCommand("update crudtbl set Name= '" + TextBox2.Text + "', Address= '"+TextBox3.Text+"', Age='"+TextBox4.Text+"', Contact='"+TextBox5.Text+"' where StuID= '"+TextBox1.Text+"' ", con);
comm.ExecuteNonQuery();
con.Close();
ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "alert('Successfully Updated');", true);
LoadRecord();
ClearData();
}

protected void Button3_Click(object sender, EventArgs e)
{
con.Open();
SqlCommand comm = new SqlCommand("delete crudtbl where StuID = '" + TextBox1.Text + "' ", con);
comm.ExecuteNonQuery();
con.Close();
ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "alert('Successfully Deleted');", true);
LoadRecord();
ClearData();

}
}
}

Watch video CRUD Operations in ASP.NET Web Application using Microsoft SQL Server| Visual Studio 2022 | GridView online without registration, duration hours minute second in high quality. This video was added by user RK Keynotes 05 April 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 367 once and liked it 8 people.

14,283

390