private void DeveloperDropDownList_SelectedIndexChanged(object sender, System.EventArgs e) { /* * get developer info and display it ... * * */ //initialize the DB object DBDriver myDB = new DBDriver(); //set the appropriate SQL query myDB.Query = "select person.ID, firstName, lastName, competence" + " from person, compLevels" + " where person.ID = compLevels.ID and person.ID=@devID;"; myDB.addParam("@devID", DeveloperDropDownList.SelectedValue); //initialize the datareader SqlDataReader dr = myDB.createReader(); //fill the datareader dr.Read(); this.CancelButton.Visible = true; //reset buttons this.SaveButton.Visible = true; this.CompetenceDropDownList.Visible = true; try { this.devFirstLabel.Text = Convert.ToString(dr["firstName"]); this.devLastLabel.Text = Convert.ToString(dr["lastName"]); this.CompetenceDropDownList.SelectedValue = dr["competence"].ToString(); } catch { this.devFirstLabel.Text = "ERROR"; this.devLastLabel.Text = "ERROR"; } myDB.close(); DeveloperPanel.Visible = true; }
private void Page_Load(object sender, System.EventArgs e) { // Put user code to initialize the page here DBDriver myDB=new DBDriver(); string mID=Request.QueryString["id"]; myDB.Query="select u.userName sender, m.subject subject, m.timestamp date, m.body body from users u, messages m where m.ID=@mID and u.ID=m.senderID;"; myDB.addParam("@mID", mID); SqlDataReader dr=myDB.createReader(); dr.Read(); this.subjectLabel.Text=Convert.ToString(dr["subject"]); this.senderLabel.Text=Convert.ToString(dr["sender"]); this.dateLabel.Text=Convert.ToString(dr["date"]); this.messageLabel.Text=Convert.ToString(dr["body"]); myDB.close(); }
private void syncCompetenceText() { //initialize the DB object DBDriver myDB = new DBDriver(); //set the appropriate SQL query myDB.Query = "select ID, competence" + " from compLevels" + " where compLevels.ID=@devID;"; myDB.addParam("@devID", DeveloperDropDownList.SelectedValue); //initialize the datareader SqlDataReader dr = myDB.createReader(); //fill the datareader dr.Read(); this.CompetenceDropDownList.SelectedValue = Convert.ToString(dr["competence"]); myDB.close(); }
private void Page_Load(object sender, System.EventArgs e) { // Put user code to initialize the page here DBDriver myDB = new DBDriver(); string mID = Request.QueryString["id"]; myDB.Query = "select u.userName sender, m.subject subject, m.timestamp date, m.body body from users u, messages m where m.ID=@mID and u.ID=m.senderID;"; myDB.addParam("@mID", mID); SqlDataReader dr = myDB.createReader(); dr.Read(); this.subjectLabel.Text = Convert.ToString(dr["subject"]); this.senderLabel.Text = Convert.ToString(dr["sender"]); this.dateLabel.Text = Convert.ToString(dr["date"]); this.messageLabel.Text = Convert.ToString(dr["body"]); myDB.close(); }
private void Page_Load(object sender, System.EventArgs e) { // Put user code to initialize the page here if (!Page.IsPostBack) { /// fill drop down list // initialize the DB object DBDriver myDB = new DBDriver(); //set the query to select all projects myDB.Query = "select p.ID as ID, p.lastName as lastName, p.firstName as firstName\n" + "from users u, person p\n" + "where u.security = 'Developer'\n" + "and p.ID = u.ID;"; //create a data set //DataSet ds=new DataSet(); //initialize the data adapter //fill the data set with the data adapter SqlDataReader dr = myDB.createReader(); int i = 1; DeveloperDropDownList.Items.Insert(0, ""); while (dr.Read()) { DeveloperDropDownList.Items.Insert(i, dr["lastName"].ToString() + ", " + dr["firstName"].ToString()); DeveloperDropDownList.Items[i].Value = dr["ID"].ToString(); i++; } myDB.close(); CompetenceDropDownList.Items.Insert(0, "Low"); CompetenceDropDownList.Items[0].Value = "Low"; CompetenceDropDownList.Items.Insert(1, "Medium"); CompetenceDropDownList.Items[1].Value = "Medium"; CompetenceDropDownList.Items.Insert(2, "High"); CompetenceDropDownList.Items[2].Value = "High"; } }
private void DeveloperDropDownList_SelectedIndexChanged(object sender, System.EventArgs e) { /* * get developer info and display it ... * * */ //initialize the DB object DBDriver myDB=new DBDriver(); //set the appropriate SQL query myDB.Query = "select person.ID, firstName, lastName, competence" + " from person, compLevels" + " where person.ID = compLevels.ID and person.ID=@devID;"; myDB.addParam("@devID", DeveloperDropDownList.SelectedValue); //initialize the datareader SqlDataReader dr = myDB.createReader(); //fill the datareader dr.Read(); this.CancelButton.Visible = true; //reset buttons this.SaveButton.Visible = true; this.CompetenceDropDownList.Visible= true; try { this.devFirstLabel.Text=Convert.ToString(dr["firstName"]); this.devLastLabel.Text=Convert.ToString(dr["lastName"]); this.CompetenceDropDownList.SelectedValue = dr["competence"].ToString(); } catch { this.devFirstLabel.Text="ERROR"; this.devLastLabel.Text="ERROR"; } myDB.close(); DeveloperPanel.Visible = true; }
private void syncCompetenceText() { //initialize the DB object DBDriver myDB=new DBDriver(); //set the appropriate SQL query myDB.Query="select ID, competence" +" from compLevels" +" where compLevels.ID=@devID;"; myDB.addParam("@devID", DeveloperDropDownList.SelectedValue); //initialize the datareader SqlDataReader dr = myDB.createReader(); //fill the datareader dr.Read(); this.CompetenceDropDownList.SelectedValue = Convert.ToString(dr["competence"]); myDB.close(); }
private void Page_Load(object sender, System.EventArgs e) { // Put user code to initialize the page here if(!Page.IsPostBack) { /// fill drop down list // initialize the DB object DBDriver myDB=new DBDriver(); //set the query to select all projects myDB.Query = "select p.ID as ID, p.lastName as lastName, p.firstName as firstName\n" + "from users u, person p\n" + "where u.security = 'Developer'\n" + "and p.ID = u.ID;"; //create a data set //DataSet ds=new DataSet(); //initialize the data adapter //fill the data set with the data adapter SqlDataReader dr = myDB.createReader(); int i = 1; DeveloperDropDownList.Items.Insert(0,""); while( dr.Read() ) { DeveloperDropDownList.Items.Insert(i,dr["lastName"].ToString() + ", " + dr["firstName"].ToString()); DeveloperDropDownList.Items[i].Value = dr["ID"].ToString(); i++; } myDB.close(); CompetenceDropDownList.Items.Insert(0,"Low"); CompetenceDropDownList.Items[0].Value= "Low"; CompetenceDropDownList.Items.Insert(1,"Medium"); CompetenceDropDownList.Items[1].Value= "Medium"; CompetenceDropDownList.Items.Insert(2,"High"); CompetenceDropDownList.Items[2].Value= "High"; } }