how to save value in Ms Access using asp.net 2.0 C#
-
HI, i m trying to save value in access database,can i do this if yes then how can i implement. thanx in advance
-
HI, i m trying to save value in access database,can i do this if yes then how can i implement. thanx in advance
do u means to insert data into access db.
try and try untill reach success..
-
do u means to insert data into access db.
try and try untill reach success..
yes i can do in sql server,but i want to MsAccess Db. is it possible? how can i do?
-
yes i can do in sql server,but i want to MsAccess Db. is it possible? how can i do?
Try This Link It May Help http://aspalliance.com/429[^] ASP.NET Guestbook using MS Access[^]
If It Helps Click It as Answer
-
HI, i m trying to save value in access database,can i do this if yes then how can i implement. thanx in advance
Firstly u add <appSettings> tag in web config file attach data base <appSettings> <add key="ConnectionStrings" value="Provider=Microsoft.Jet.OLEDB.4.0; Data Source={0}"/> <add key="dbfile" value="~/App_Data/data.mdb"/> </appSettings> then after Pro = ConfigurationManager.AppSettings["ConnectionStrings"].ToString(); MyPath = ConfigurationManager.AppSettings["dbfile"].ToString(); Conns = String.Format(Pro, HttpContext.Current.Server.MapPath(MyPath)); con = new OleDbConnection(Conns); con.Open(); string st = "Madhaya Pradesh"; string qql = "INSERT into Registration(UniqueID,Name,FName,DOB,TMarks,OMarks,PMarks,PClass,PLine,Board,District,Division,Category,Sex,PChallange,Address,Pin,RDistrict,State,Phone,SchoolAddress,SchoolPincode,SchoolDistrict) values('" + lbluniquid.Text + "','" + txtname.Text + "','" + txtfathername.Text + "','" + tbMyDate.Text + "'," + txttotalmarks.Text + "," + txtobtainmarks.Text + "," + p + ",'" + rdpresent.SelectedItem.Text + "','" + rdpovertyline.SelectedItem.Text + "','" + rdboard.SelectedItem.Text + "','" + ddldistrict.SelectedItem.Text + "','" + lbldivision.Text + "','" + rdcategory.SelectedItem.Text + "','" + rdsex.SelectedItem.Text + "','" + rdphysically.SelectedItem.Text + "','" + txtaddress.Text + "','" + txtpincode.Text + "','" + ddldistrict1.SelectedItem.Text + "','" + st + "','" + txtcontact.Text + "','"+ txtschooladdress.Text +"','"+ txtschoolpincode.Text +"','"+ ddldistrict2.SelectedItem.Text +"')"; cmd = new OleDbCommand(qql, con); int res; &nbs
-
HI, i m trying to save value in access database,can i do this if yes then how can i implement. thanx in advance
This code useful for u.. firstly add tag in web config
After then
Pro = ConfigurationManager.AppSettings["ConnectionStrings"].ToString();
MyPath = ConfigurationManager.AppSettings["dbfile"].ToString();
Conns = String.Format(Pro, HttpContext.Current.Server.MapPath(MyPath));
con = new OleDbConnection(Conns);
con.Open();
string st = "Madhaya Pradesh";
string qql = "INSERT into Registration(UniqueID,Name,FName,DOB,TMarks,OMarks,PMarks,PClass,PLine,Board,District,Division,Category,Sex,PChallange,Address,Pin,RDistrict,State,Phone,SchoolAddress,SchoolPincode,SchoolDistrict) values('" + lbluniquid.Text + "','" + txtname.Text + "','" + txtfathername.Text + "','" + tbMyDate.Text + "'," + txttotalmarks.Text + "," + txtobtainmarks.Text + "," + p + ",'" + rdpresent.SelectedItem.Text + "','" + rdpovertyline.SelectedItem.Text + "','" + rdboard.SelectedItem.Text + "','" + ddldistrict.SelectedItem.Text + "','" + lbldivision.Text + "','" + rdcategory.SelectedItem.Text + "','" + rdsex.SelectedItem.Text + "','" + rdphysically.SelectedItem.Text + "','" + txtaddress.Text + "','" + txtpincode.Text + "','" + ddldistrict1.SelectedItem.Text + "','" + st + "','" + txtcontact.Text + "','"+ txtschooladdress.Text +"','"+ txtschoolpincode.Text +"','"+ ddldistrict2.SelectedItem.Text +"')";
cmd = new OleDbCommand(qql, con);
int res;
res = cmd.ExecuteNonQuery();
res = 1;
con.Close();