public DataTable baaarname()
{
try
{
if (con.State != ConnectionState.Open)
{
con.Open();
}
DataTable sqlSet = new DataTable();
SqlDataAdapter ss2 = new SqlDataAdapter("SELECT id , shb , shm , shsh, plk ,clr , cpn , mob ,cid , rid from sanad where shb like N'" + shb.Text + "'", con);
sqlSet = new DataTable();
sqlSet.Clear();
ss2.Fill(sqlSet);
if (con.State == ConnectionState.Open)
{
con.Close();
}
return sqlSet;
}
catch (Exception x)
{
MessageBox.Show("لطفا با پشتیبانی تماس بگیرید", "!!!پیغام", MessageBoxButtons.OK, MessageBoxIcon.Stop);
return null;
}
}