public static void StoreInDB(Decimal xno ,String xurl, DateTime DTime, String ConAscii) { //Insertion DataClasses1DataContext d = new DataClasses1DataContext(conn); request_info s1 = new request_info { srno = xno, url = xurl.ToString(), date_time = Convert.ToDateTime(DTime), contain_NON_ascii = ConAscii }; d.request_infos.InsertOnSubmit(s1); // Submit the change to the database. try { d.SubmitChanges(); } catch (Exception e) { d.SubmitChanges(); } }
public BindingSource ViewReq() { request_info r = new request_info(); BindingSource bs1 = new BindingSource(); bs1.DataSource = from u in d.request_infos orderby u.srno descending select u; return bs1; }
partial void Updaterequest_info(request_info instance);
partial void Deleterequest_info(request_info instance);
partial void Insertrequest_info(request_info instance);