Databases
StackOverflow2013
Postsdbo
PODuplicate values while using confirmbuttonextender on dropdownlist
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODuplicate values while using confirmbuttonextender on dropdownlist
    text
    copied!<p>I have a dropdownlist. I have added a default value into a dropdownlist box with this codes</p> <pre><code>&lt;asp:DropDownList ID="DDLCase" runat="server" AutoPostBack="True" OnSelectedIndexChanged="DDLCase_SelectedIndexChanged" AppendDataBoundItems="true" &gt; &lt;asp:ListItem Value=""&gt;Select Member Report ID&lt;/asp:ListItem&gt; &lt;/asp:DropDownList&gt; </code></pre> <p>For example i have DB value such as 123, 1234.</p> <p>When i run my webform and clicked 123 and 1234 nothing happened. However when i went to click the ListItem Value they gave me some error</p> <pre><code>Conversion failed when converting the varchar value 'Select Member Report ID' to data type int. </code></pre> <p>This is my back-end code for my DDL at my pageload.</p> <pre><code> protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { SqlConnection con = new SqlConnection("Data Source = localhost; Initial Catalog = project; Integrated Security = SSPI"); SqlCommand cm = new SqlCommand("Select pr.policereportid from PoliceReport pr, AdminOfficialReport aor, MemberReport mr where pr.memberreportid=mr.memberreportid and mr.caseprogress='settled' and aor.officialreport IS NULL", con); con.Open(); SqlDataReader dr; dr = cm.ExecuteReader(); while (dr.Read()) { DDLCase.Items.Add(dr["policereportid"].ToString()); } DDLCase.Items.Insert(0, new ListItem("Select Member Report ID", "-1")); dr.Close(); con.Close(); } } </code></pre> <p>This is where my error occurs. It occurs at the area around dr = cm.ExecuteReader();</p> <pre><code>protected void DDLCase_SelectedIndexChanged(object sender, EventArgs e) { SqlConnection con = new SqlConnection("Data Source = localhost; Initial Catalog = project; Integrated Security = SSPI"); con.Open(); SqlCommand cm = new SqlCommand("Select lro.fullname, lro.contact, mr.typeofcrime, mr.location,mr.crdatetime, pr.policeid, pr.prdatetime, pr.policereport, pr.image1, mr.citizenreport from MemberReport mr, PoliceReport pr, LoginRegisterOthers lro where pr.policereportid = '" + DDLCase.SelectedItem.Text + "' and mr.memberreportid=pr.memberreportid and lro.username=mr.username and mr.caseprogress='settled'", con); SqlDataReader dr; dr = cm.ExecuteReader(); if (dr.Read()) { lblFullName.Text = dr["fullname"].ToString(); lblContact.Text = dr["contact"].ToString(); lblTOC.Text = dr["typeofcrime"].ToString(); lblLocation.Text = dr["location"].ToString(); lblCRDT.Text = dr["crdatetime"].ToString(); lblPicture.Text = dr["image1"].ToString(); lblAssign.Text = dr["policeid"].ToString(); lblPRDT.Text = dr["prdatetime"].ToString(); lblCR.Text = dr["citizenreport"].ToString(); lblPR.Text = dr["policereport"].ToString(); } con.Close(); } </code></pre> <p>How do i solve this?</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload