public int Update(tblQuesBankMst obj)
{
if (cnnstr.State == ConnectionState.Closed)
{
cnnstr.Open();
}
sql = "Update tblQuesBankMst set Subject = '" + obj.Subject + "', QuesBankName = '" + obj.QuesBankName + "' where QID = " + obj.QID + " ";
scmd = new SqlCommand(sql, cnnstr);
scmd.ExecuteNonQuery();
cnnstr.Close();
return(1);
}
public int Delete(tblQuesBankMst obj)
{
if (cnnstr.State == ConnectionState.Closed)
{
cnnstr.Open();
}
sql = "delete from tblQuesBankMst where QID = " + obj.QID + "";
scmd = new SqlCommand(sql, cnnstr);
scmd.ExecuteNonQuery();
cnnstr.Close();
return(1);
}
public int Insert(tblQuesBankMst obj)
{
if (cnnstr.State == ConnectionState.Closed)
{
cnnstr.Open();
}
sql = "Insert Into tblQuesBankMst (Subject ,QuesBankName) values ('" + obj.Subject + "','" + obj.QuesBankName + "')";
scmd = new SqlCommand(sql, cnnstr);
scmd.ExecuteNonQuery();
cnnstr.Close();
return(1);
}
public DataTable GetSingleRecord(tblQuesBankMst obj)
{
if (cnnstr.State == ConnectionState.Closed)
{
cnnstr.Open();
}
sql = "Select * from tblQuesBankMst where QID = " + obj.QID + "";
SqlDataAdapter adp = new SqlDataAdapter(sql, cnnstr);
DataTable dt = new DataTable();
adp.Fill(dt);
cnnstr.Close();
return(dt);
}
