private void fac_name_bind()
{
string cmd = "SELECT * from faculty where name= '" + TextBox1.Text + "' ";
SqlDataAdapter adp = db.GridData(cmd);
DataSet ds = new DataSet();
adp.Fill(ds, "Searh_FacName");
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
private void stuid_bind()
{
string cmd = "SELECT * from student where enrollid= '" + TextBox1.Text + "' ";
SqlDataAdapter adp = db.GridData(cmd);
DataSet ds = new DataSet();
adp.Fill(ds, "Searh_StuId");
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
private void stu_Fine()
{
string cmd = "SELECT stuid,name,bid,bname,book.dept,fine,issuedate,duedate FROM book,student WHERE book.stuid=student.enrollid and book.fine!=0 and book.stuid!='0'";
SqlDataAdapter adp = db.GridData(cmd);
DataSet ds = new DataSet();
adp.Fill(ds, "StuFine");
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
private void iss_date()
{
Label1.Text = Convert.ToDateTime(TextBox1.Text).ToShortDateString();
string cmd = "SELECT bid, bname, dept, stuid, facusername FROM report WHERE (issuedate = '" + Convert.ToDateTime(TextBox1.Text).ToShortDateString() + "')";
SqlDataAdapter adp = db.GridData(cmd);
DataSet ds = new DataSet();
adp.Fill(ds, "Report_IssDate");
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
private void stu_Fine()
{
string cmd = "SELECT b.stuid,s.name,b.bid,b.bname,b.dept,b.fine,b.issuedate,b.duedate FROM book b,student s WHERE b.stuid=s.enrollid and b.stuid='100010107001' and b.fine!='0' ";
SqlDataAdapter adp = db.GridData(cmd);
DataSet ds = new DataSet();
adp.Fill(ds, "StuFine");
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
private void stu_Fine()
{
string cmd = "SELECT bid,bname,dept,fine,issuedate,duedate FROM book WHERE stuid='" + uid + "'";
SqlDataAdapter adp = db.GridData(cmd);
DataSet ds = new DataSet();
adp.Fill(ds, "StuRepo");
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
private void sug_call()
{
string qury = "select * from suggestions";
SqlDataAdapter adp = db.GridData(qury);
DataSet ds = new DataSet();
adp.Fill(ds, "Suggestion");
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}