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();
In questa pagina del sito puoi guardare il video online Insert Method using ObjectDataSource in Asp.Net | Insert Data in GridView using Object Data Source della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Hariti Study Hub - Easy Learn 30 gennaio 2017, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 1,133 volte e gli è piaciuto 7 spettatori. Buona visione!