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);
