DropDownList in data binding

Sign in to leave a comment.

• AC

  ashish chauhan15y agoPosted Sep 24, 2011, 2:50 AM

  hiiiiii rahul kumar thnks to help me i have one quetion that tell me about some code or some sites link they can help me to send the mobile sms using the asp.net application or send me mail my id [email protected] plssss help me i have try that but i cant sucess to send sms
• T

  tari16y agoPosted Nov 9, 2010, 1:54 PM

  very usefull post tanksssssxxxx
• AB

  Avi Birvatkar16y agoPosted Jul 14, 2010, 8:48 AM

  How to add or store Sub-menus to main menus in sql database and retrive from sql database ? let me explain, in above exmple, in dropdown box there is one main menu "Rahul". if want to add sub-menus to " Rahu " menu like 1)home 2)book 3)college. then what i need to do. how i add these submenus in sql database and retrive form database. please help me... my carrer depends on this project... please send me code as soon as posible
• ID

  Ivan Diana18y agoeditedPosted Nov 17, 2008, 12:03 AMEdited Nov 17, 2008, 12:12 AM

  hi Raahul, i've tried the code u write to binding data from database to dropdownlist. but it don't show anything at the dropdownlist. it appears to error with the message "'cmbKabupaten' has a SelectedValue which is invalid because it does not exist in the list of items.\r\nParameter name: value" string. the code i write is shown below : protected void cmbPropinsi_SelectedIndexChanged(object sender, EventArgs e) { //cmbPropinsi is a dropdownlist which items has been listed manual (not from database) fillCmbKabupaten(); } private void fillCmbKabupaten() { //cmbKabupaten is a dropdownlist which items i tried to bind from database according to the selected item on cmbPropinsi cmbKabupaten.Text = String.Empty; try { DataSet ds1 = pendaftaranM.getKabupatenByPropName(cmbPropinsi.SelectedValue.ToString()); cmbKabupaten.DataSource = ds1; cmbKabupaten.DataTextField = "nama_kabupaten"; cmbKabupaten.DataBind(); } catch (System.Data.SqlClient.SqlException e1) { cmbKabupaten.Text = String.Empty + e1.Message; } catch (Exception e2) { cmbKabupaten.Text = String.Empty + e2.Message; } } the method getKabupatenByPropName is shown below : public DataSet getKabupatenByPropName(string nama_prop) { try { DataSet ds = new DataSet(); con.Open(); SqlCommand cmd = new SqlCommand("GetKabupatenByPropName", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@nama_prop", SqlDbType.VarChar, 50)); cmd.Parameters["@nama_prop"].Value = nama_prop; SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(ds, "REF_KABUPATEN"); return ds; } catch (SqlException ex) { throw new ApplicationException(ex.Message); } catch (Exception ex) { throw new ApplicationException(ex.Message); } finally { con.Close(); } } i used stored procedure here CREATE PROCEDURE GetKabupatenByPropName @nama_prop varchar(50) AS select kab.nama_kabupaten from ref_kabupaten kab, ref_propinsi prop where kab.kd_prop = prop.kd_prop and prop.nama_prop = @nama_prop please help me, i'm really stressout with this... please reply me ASAP thank u very much...
  • LR

    Lawrence raja17y agoPosted Sep 18, 2009, 1:31 AM

    Thanks for ur kindly information. It's good to us....
• SG

  Surya Gangwar18y agoPosted Mar 7, 2008, 12:41 PM

  I have not user webservices. Can you tell me the complete procedure how we can create webservices and how we can subscribe them. Please, reply me ASAP.
  • 

    Rahul Kumar Saxena18y agoPosted Mar 10, 2008, 5:16 AM

    Thanx SURYA TO View Amy Article I will With u With Ur Need Very Soon Thanx
  • PA

    Priyu Arya15y agoPosted Jul 13, 2011, 1:20 AM

    I saw your Post which is very helpful for me , i want to learn asp.net from you, my mail id is [email protected] and give me your mail id by which i take your help ................. thanks your Post i waiting for your Response.......