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