Insert Method using ObjectDataSource in Asp.Net | Insert Data in GridView using Object Data Source
Hello Friends,
In this Video Tutorial of ASP.Net, you will learn how to use insert method of objectdatasource in asp.net to insert data to database and update gridview.
Download Our All 400+ Videos Asp.Net Code : Just Paying Onetime Amount Rs.49/- Only
Buy and Download All 400+ Codes Here ( 100% Working Code ) :
https://beststudyguru.myinstamojo.com...
or
You can also buy our pendrive of 32GB Which will include 400+Videos in Mp4 Format So You can watch all Videos Without Internet and Learn Asp.Net in Hindi At Your Home Easily. We will send you the pendrive through Courier. You have to pay Just Rs.999/- ( Include All Source Code File + 400+Videos + 32GB Pendrive ) Only For Indian Users
Buy Our Pendrive Here :
https://www.instamojo.com/beststudygu...
---------
Coding
------------------------------
public DataSet GetCustomerDetail1()
{
String constring = "Data Source=VIKAS-PC\\SQLEXPRESS; Initial Catalog=customerdatabase; Integrated Security=true";
SqlConnection sqlcon = new SqlConnection(constring);
String query = "select * from customerdetail";
SqlCommand sqlcmd = new SqlCommand();
sqlcmd.CommandText = query;
sqlcmd.Connection = sqlcon;
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = sqlcmd;
DataSet ds = new DataSet();
da.Fill(ds);
return ds;
}
public int InsertCustomerDetail(int customerid, String customername, String city, String contact)
{
String constring = "Data Source=VIKAS-PC\\SQLEXPRESS; Initial Catalog=customerdatabase; Integrated Security=true";
SqlConnection sqlcon = new SqlConnection(constring);
String query = "Insert into customerdetail(customerid,customername,city,contact) values(" + customerid + ",'" + customername + "','" + city + "','" + contact + "')";
SqlCommand sqlcmd = new SqlCommand(query, sqlcon);
sqlcon.Open();
sqlcmd.ExecuteNonQuery();
sqlcon.Close();
return customerid;
}
----------
Button Click Coding
---
ObjectDataSource1.InsertParameters["customerid"].DefaultValue = TextBox1.Text;
ObjectDataSource1.InsertParameters["customername"].DefaultValue = TextBox2.Text;
ObjectDataSource1.InsertParameters["city"].DefaultValue = TextBox3.Text;
ObjectDataSource1.InsertParameters["contact"].DefaultValue = TextBox4.Text;
ObjectDataSource1.Insert();
GridView1.DataBind();
Sur cette page du site, vous pouvez voir la vidéo en ligne Insert Method using ObjectDataSource in Asp.Net | Insert Data in GridView using Object Data Source durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Hariti Study Hub - Easy Learn 30 janvier 2017, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 1,133 fois et il a aimé 7 téléspectateurs. Bon visionnage!
