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();
Auf dieser Seite können Sie das Online-Video Insert Method using ObjectDataSource in Asp.Net | Insert Data in GridView using Object Data Source mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Hariti Study Hub - Easy Learn 30 Januar 2017 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 1,133 Mal angesehen und es wurde von 7 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!