SqlConnection conn =
new SqlConnection(Conn.CLNXCnnString());
conn.Open();
string sql = "select * from tblAddProject where ProjectName='" + strProjectName +
"'";
SqlCommand cmd =
new SqlCommand(sql, conn);
SqlDataAdapter da =
new SqlDataAdapter(cmd);DataTable dt =
new DataTable();
//Compare assigned members to database. check appropriate checkboxes
string Members = dt.Rows[0]["AssignedMembers"].ToString();
string[] splitMembers = Members.Split(',');
//for (int i=0; i <cblMembersAssigned.Items.Count; i++)
for (int i=0; i < splitMembers.Length; i++)
//if it's equal then check the items in the CHeckBox
//cblMembersAssigned.Items[i].Selected = true;
string strItem = splitMembers[i].ToString();if (int.Parse(strItem)
== i)
kcrewjap
Member
15 Points
188 Posts
Re: Populate fields from dropdown selection
Jun 24, 2008 08:37 PM|LINK
in my selectedindexchanged i have the following:
protected void ddlSearch_SelectedIndexChanged(object sender, EventArgs e){
FillProjectFields(ddlSearch.SelectedValue);
}
the fill projectFields is below:
private void FillProjectFields(string strProjectName){
SqlConnection conn = new SqlConnection(Conn.CLNXCnnString());conn.Open();
string sql = "select * from tblAddProject where ProjectName='" + strProjectName + "'"; SqlCommand cmd = new SqlCommand(sql, conn); SqlDataAdapter da = new SqlDataAdapter(cmd);DataTable dt = new DataTable();da.Fill(dt);
if (dt.Rows.Count > 0){
txtDate.Text = dt.Rows[0][
"RequestDate"].ToString(); txtChangeUser.Text = dt.Rows[0]["NTLogin"].ToString();txtProjectName.Text = dt.Rows[0][
"ProjectName"].ToString(); txtProjectDesc.Text = dt.Rows[0]["ProjectDesc"].ToString();ddlOccurrence.Items.Add(dt.Rows[0][
"Occurrence"].ToString()); if(dt.Rows[0]["Occurrence"].ToString() == "Reoccurring"){
ddlOccurrence.SelectedValue = "Reoccurring";}
else if (dt.Rows[0]["Occurrence"].ToString() == "One Time"){
ddlOccurrence.SelectedValue = "One Time";}
rblOccurrance.Items.Add(dt.Rows[0]["Automated"].ToString());rblOccurrance.Items.Add(dt.Rows[0][
"Manual"].ToString()); ddlStatus.Items.Add(dt.Rows[0]["StatusName"].ToString());if (dt.Rows[0]["StatusName"].ToString() == "New"){
ddlStatus.SelectedValue = "New";}
else if (dt.Rows[0]["StatusName"].ToString() == "Assigned"){
ddlStatus.SelectedValue = "Assigned";}
else if (dt.Rows[0]["StatusName"].ToString() == "Complete"){
ddlStatus.SelectedValue = "Complete";}
//cblMembersAssigned.Items.Add(dt.Rows[0]["AssignedMembers"].ToString()); txtCompletionDate.Text = dt.Rows[0]["CompletionDate"].ToString();}
conn.Close();
//Compare assigned members to database. check appropriate checkboxes string Members = dt.Rows[0]["AssignedMembers"].ToString(); string[] splitMembers = Members.Split(','); //for (int i=0; i <cblMembersAssigned.Items.Count; i++) for (int i=0; i < splitMembers.Length; i++){
//if (cblMembersAssigned.Items[i].Text == splitMembers[i].ToString()){
//if it's equal then check the items in the CHeckBox //cblMembersAssigned.Items[i].Selected = true; string strItem = splitMembers[i].ToString();if (int.Parse(strItem) == i){
cblMembersAssigned.Items.FindByText(strItem).Selected = true;}
}
}
}