public static DataTable databind(int newstype,string tablename)
{SqlConnection con=DB.createcon();
con.Open();
SqlDataAdapter sda=new SqlDataAdapter();
sda.SelectCommand=new SqlCommand("select * from " + tablename,con);
DataSet ds=new DataSet();
sda.Fill(ds,tablename);
return ds.Tables[tablename];
}