<table width="100%" bgcolor="#ffffcc"> <tbody> <tr> <td><code></code>
I have been using a ms access database with my online booking application. My host upgraded me to a 64 bit server and ms access do not for my asp.net app. anymore.
I upgraded to MS SQL and now my ms access query will not work. I am not that great at MS sQL yet and I would like someone to please
convert Line 98 for me. Thanks so much in advance. I appreciate it a lot.
Line 98: str1 = "insert into tblBookings(bookingName,bookingTel,bookingEmail,bookingDate,bookingTimeFrom,bookingTimeTo,staffID) values('" + Convert.ToString(Session["username"]) + "','" + tel + "','" + email + "','" + bdate1 + "','" + btform + "','" + btto + "','" + Convert.ToInt32(Session["hstyle"]) + "')";
Line 99: OleDbCommand mycommand = new OleDbCommand(str1, con);
Line 100: mycommand.ExecuteNonQuery();
Line 101:
Line 102:</td></tr></tbody></table>
I have been using a ms access database with my online booking application. My host upgraded me to a 64 bit server and ms access do not for my asp.net app. anymore.
I upgraded to MS SQL and now my ms access query will not work. I am not that great at MS sQL yet and I would like someone to please
convert Line 98 for me. Thanks so much in advance. I appreciate it a lot.
Line 98: str1 = "insert into tblBookings(bookingName,bookingTel,bookingEmail,bookingDate,bookingTimeFrom,bookingTimeTo,staffID) values('" + Convert.ToString(Session["username"]) + "','" + tel + "','" + email + "','" + bdate1 + "','" + btform + "','" + btto + "','" + Convert.ToInt32(Session["hstyle"]) + "')";
Line 99: OleDbCommand mycommand = new OleDbCommand(str1, con);
Line 100: mycommand.ExecuteNonQuery();
Line 101:
Line 102:</td></tr></tbody></table>
