Reply to thread

Message: <blockquote data-quote="amarawansadinith" data-source="post: 13814203" data-attributes="member: 221521">1. Uba connection ekak hadaganin Database ekata.... Then eke ItemID Field eka ganinprivate void cmbx_SelectedIndexChanged(object sender, EventArgs e){SqlConnection myConnection = ???? // Ube Connection ekaSqlCommand myCommand = new SqlCommand("select ItemID from Table where category="'+cmbx.SelectedValue+'"ORDER BY ItemID DESC", myConnection); // Ube Table names n field names ekka meka edit karaganin ( waradda ganna epa )SqlDataReader myReader = myCommand.ExecuteReader();String S = myReader["Item ID"].ToString(); // While ekak danna epa because Last record eka ganna one nisa2. Then Substring karapan ena value eka and convert to Integerstring substrng = S.Substring(3, 6); // Database eken gaththu record eka kadagannawaint convertedstrng = int.Parse(substrng) // Convert karanawa integer walata mokada DB eken retrieve wenne text ekak nisa3. Finally Append karapan if (cmbx.SelectedValue == "Large")Textbox1.text = "LGR"+"convertedstrng";else if (cmbx.SelectedValue == "Small")Textbox1.text = "SML"+"convertedstrng";else if (cmbx.SelectedValue == "Extra Large")Textbox1.text = "EXL"+"convertedstrng";}Hope this will do</blockquote>

Top Bottom