-
Notifications
You must be signed in to change notification settings - Fork 0
/
addqp.ascx.cs
72 lines (70 loc) · 2.47 KB
/
addqp.ascx.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
public partial class addqp : System.Web.UI.UserControl
{
SqlCommand cmd = new SqlCommand();
protected void Page_Load(object sender, EventArgs e)
{
dbconnection db = new dbconnection();
cmd.CommandText = "select qp_id from tb_id";
SqlDataReader dr = db.executeread(cmd);
dr.Read();
int x = dr.GetInt32(0);
x++;
String s = "QPJHQ" + x.ToString();
TextBox1.Text = s;
if (!IsPostBack)
{
DropDownList1.Items.Add("--Select--");
dbconnection db1 = new dbconnection();
cmd.CommandText = "select stream from tb_course";
SqlDataReader dr1 = db1.executeread(cmd);
while (dr.Read())
{
String st = dr1[0].ToString();
DropDownList1.Items.Add(st);
}
}
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList2.Items.Clear();
DropDownList2.Items.Add("--Select--");
dbconnection db = new dbconnection();
cmd.CommandText = "select no_sem from tb_course where stream=@d";
cmd.Parameters.AddWithValue("@d", DropDownList1.SelectedItem.Text);
SqlDataReader dr = db.executeread(cmd);
while (dr.Read())
{
String s = dr[0].ToString();
DropDownList2.Items.Add(s);
}
}
protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList3.Items.Clear();
DropDownList3.Items.Add("--Select--");
dbconnection db1 = new dbconnection();
cmd.CommandText = "select crs_id from tb_course where stream=@f and no_sem=@g";
cmd.Parameters.AddWithValue("@f", DropDownList1.SelectedItem.Text);
cmd.Parameters.AddWithValue("@g", DropDownList2.SelectedItem.Text);
SqlDataReader dr1 = db1.executeread(cmd);
dr1.Read();
String id = dr1.GetString(0);
dbconnection db = new dbconnection();
cmd.CommandText = "select subject from tb_subject where crs_id=@d";
cmd.Parameters.AddWithValue("@d",id);
SqlDataReader dr = db.executeread(cmd);
while (dr.Read())
{
String s = dr[0].ToString();
DropDownList2.Items.Add(s);
}
}
}