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

Question

how to insert data in access database from asp.net c#? fields : name,gender,phonenumber,photourl

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