show gridview data to dropdownlist

Question

User-1447786422 posted

I have a grid view with value (date of birth),  and some dropdown list (day,month,year). Now i want that when i select a row in my gridview my date of birth split in 3 and fill the dropdownlist

Example:

In my grid view i have a date: 05/06/2018

When i click select my dropdownlist will apear:

Day:05   Month:06   Year:2018

Can any one help me

//My select button

protected void lnk_OnClick(object sender, EventArgs e)
        {

            int StuID= Convert.ToInt32((sender as LinkButton).CommandArgument);
            if (sqlCon.State == ConnectionState.Closed)
                sqlCon.Open();
            SqlDataAdapter sqlDa = new SqlDataAdapter("SelectByID", sqlCon);
            sqlDa.SelectCommand.CommandType = CommandType.StoredProcedure;
            sqlDa.SelectCommand.Parameters.AddWithValue("@StuID", StuID);
            DataTable dtbl = new DataTable();
            sqlDa.Fill(dtbl);
            sqlCon.Close();
            hfSinhVien.Value = StuID.ToString();
            txtHoDem.Text = dtbl.Rows[0]["HoDem"].ToString();
            txtTen.Text = dtbl.Rows[0]["Ten"].ToString();
            //This is the place where those dropdownlist are
            txtQueQuan.Text = dtbl.Rows[0]["QueQuan"].ToString();
            txtSDT.Text = dtbl.Rows[0]["SDT"].ToString();
            txtEmail.Text = dtbl.Rows[0]["Email"].ToString();
            ddlLop.SelectedItem.Value = dtbl.Rows[0]["Malop"].ToString();
            btnSave.Text = "Update";
            btnDelete.Enabled = true;
        }

Answer 1

User-369506445 posted

hi

<g class="gr_ gr_7 gr-alert gr_tiny gr_spell gr_inline_cards gr_run_anim ContextualSpelling multiReplace" id="7" data-gr-id="7">i</g> create a sample that you can put your date instead of my hardCode date

         string str = "05/06/2018"; //hardcode date
             
            var arr = str.Split('/');
            string newValue = String.Format("Day:{0}   Month:{1}   Year:{2}", 
                arr[0],arr[1],arr[2]);

            ddlLop.SelectedItem.Text = newValue ;

Answer 2

User-1447786422 posted

the problem is i have 3 dropdownlist that separate into day, month, year and i don't know how to present it

Answer 3

User-369506445 posted

you can define 3 <g class="gr_ gr_23 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar multiReplace" id="23" data-gr-id="23">dropdown</g> and bind them below

  string str = "05/06/2018"; //hardcode date

            var arr = str.Split('/');

            string day = arr[0];
            string month = arr[0];
            string year = arr[0];
            
            ddlDay.SelectedItem.Text = day;
            ddlMonth.SelectedItem.Text = month;
            ddlYear.SelectedItem.Text = year;

Answer 4

User-1447786422 posted

I'm new to this so can i ask what string i have to put in this " "

my gridviewdata is bind with sqlserver

string str = " ";

Answer 5

User-1171043462 posted

Refer

Select Day, Month and Year Date from DropDownList in ASP.Net

Answer 6

User-369506445 posted

based on your <g class="gr_ gr_27 gr-alert gr_gramm gr_inline_cards gr_run_anim Style multiReplace" id="27" data-gr-id="27">code <g class="gr_ gr_26 gr-alert gr_gramm gr_inline_cards gr_run_anim Style replaceWithoutSep" id="26" data-gr-id="26">,</g></g><g class="gr_ gr_26 gr-alert gr_gramm gr_inline_cards gr_disable_anim_appear Style replaceWithoutSep" id="26" data-gr-id="26">I</g> think you get your date from <g class="gr_ gr_55 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="55" data-gr-id="55">sql</g> in this line 

 ddlLop.SelectedItem.Value = dtbl.Rows[0]["Malop"].ToString();

if yes you can use

         string str = dtbl.Rows[0]["Malop"].ToString()
             
            var arr = str.Split('/');
            string newValue = String.Format("Day:{0}   Month:{1}   Year:{2}", 
                arr[0],arr[1],arr[2]);

            ddlLop.SelectedItem.Text = newValue ;

or with 3 <g class="gr_ gr_129 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar multiReplace" id="129" data-gr-id="129">drop</g> down

 string str = dtbl.Rows[0]["Malop"].ToString() 

 var arr = str.Split('/');

            string day = arr[0];
            string month = arr[0];
            string year = arr[0];
            
            ddlDay.SelectedItem.Text = day;
            ddlMonth.SelectedItem.Text = month;
            ddlYear.SelectedItem.Text = year;

Answer 7

User-1447786422 posted

Thank u very much, it work perfectly

Answer 8

User-1447786422 posted

Thank u for your suggestion

Answer 9

User-1447786422 posted

Can i have your email, need to ask some question?

Answer 10

User-158764254 posted

Can i have your email, need to ask some question?

The discussions in these forums are all intended to be public. This is so that many developers might benefit from being able to view the difficulties and solutions that other developers have contributed here.  If you were to take the discussion offline into emails, if would be counter to one of the goals of these public forums (public discussions).

I'm glad to see that the question that started this thread was sorted/solved for you.  Please don't hesitate to start another thread if you have an additional question(s).  The members that helped you out in this thread will no doubt see it and respond if they are able.