how to insert data in access database from asp.net c#?

Question

how to insert data in access database from asp.net c#? fields : namegenderphonenumberphotourl

Hardik Patel · Answer

hello Satyapriya Nayak  how to bind dropdownlist from access database?

Hardik Patel · Answer

i want to use two database from different servers on the same page. for particular state

Satyapriya Nayak · Answer

Untitled Page Male Female Mango Ice cream Chocolate Biscuit Text=Insert /> using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.OleDb; namespace Connect_Msaccess_in_asp.net { public partial class WebForm3 : System.Web.UI.Page { OleDbConnection con; OleDbCommand com; object obj = null; protected void btn_insert_Click(object sender EventArgs e) { con = new OleDbConnection(Provider = Microsoft.Jet.OLEDB.4.0; Data Source = D:\mydb.mdb); con.Open(); com = new OleDbCommand(); com.Connection = con; com.CommandType = CommandType.Text; com.CommandText = insert into Table1 values(@IDNo@Name@Address@Gender@Favorite_Food); com.Parameters.Clear(); com.Parameters.AddWithValue(@IDNo TextBox1.Text); com.Parameters.AddWithValue(@Name TextBox2.Text); com.Parameters.AddWithValue(@Address TextBox3.Text); com.Parameters.AddWithValue(@Gender rbtGender.SelectedValue); com.Parameters.AddWithValue(@Favorite_Food CheckBoxList1.SelectedValue); if (con.State == ConnectionState.Closed) con.Open(); com.ExecuteNonQuery(); con.Close(); lblmsg.Text = Data entered successfully!!!; } } }

Iftikar Hussain · Answer

Hi Please refer the below link http://godhc.wordpress.com/2011/04/22/aspnetsimpledb/ Regards Iftikar