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();
On this page of the site you can watch the video online Insert Method using ObjectDataSource in Asp.Net | Insert Data in GridView using Object Data Source with a duration of hours minute second in good quality, which was uploaded by the user Hariti Study Hub - Easy Learn 30 January 2017, share the link with friends and acquaintances, this video has already been watched 1,133 times on youtube and it was liked by 7 viewers. Enjoy your viewing!
