pass value to textbox from dataset oncombobox selectedindex changed

Question

0.00/5 (No votes)

See more:

.NET2.0

.NET3.5

, +

I want to get the details of employee in textbox on combobox selected index changed event. I have done the following code. but when I run the project it shows an error that there is no row at position 0.
Thanks in Advance !!!

C#

private void cmbEmp_ID_SelectedIndexChanged(object sender, EventArgs e)
        {
            //string F_name, L_name, dob, Desig, dept, join_date;
            //string var = cmbEmp_ID.SelectedValue.ToString();
            //fillData(var);
            string a = cmbEmp_ID.SelectedValue.ToString();
            fillData(a);
        }

        public void fillData(string lvVar)
        {
            string cnstr = ConfigurationManager.ConnectionStrings["abc_ConnectionString"].ConnectionString;
            SqlConnection cont = new SqlConnection(cnstr);
            SqlDataAdapter adp = new SqlDataAdapter("Select First_Name, Last_Name, DOB, Designation, Department, Join_Date from Employee where Emp_ID = '" + lvVar + "'", cont);
            DataSet ds = new DataSet();
            adp.Fill(ds);
            DataTable dt = ds.Tables[0];
            txtFirst_Name.Text = dt.Rows[0]["First_Name"].ToString();
            txtLast_Name.Text = dt.Rows[0]["Last_Name"].ToString();
        }

Posted 9-Feb-12 22:54pm

Ank_ush

Updated 9-Feb-12 23:09pm

Jαved

v2

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Aniket Yadav · Answer 1 · 2012-02-09T23:25:00

Solution 3

C#

private void cmbEmp_ID_SelectedIndexChanged(object sender, EventArgs e)
        {
            if(cmbEmp_ID.SelectedIndex != -1) //Check For This First
            {
                string a = cmbEmp_ID.SelectedValue.ToString();
                fillData(a);
            }
        }

If Any Problem Than Ask Again

Posted 9-Feb-12 23:25pm

Aniket Yadav

Comments

Ank_ush 11-Feb-12 11:18am

When I run the project, the actual value is not passed to textbox, Value passed is System.Dataview.something.

Aniket Yadav 11-Feb-12 23:50pm

private void cmbEmp_ID_SelectedIndexChanged(object sender, EventArgs e)
{
if(cmbEmp_ID.SelectedIndex != -1) //Check For This First
{
string a = cmbEmp_ID.SelectedText.ToString(); // Try This
fillData(a);
}
}

Jαved · Answer 2 · 2012-02-09T23:17:00

I think the problem is with emp_id column. You are considering it as String but in the Database you might have its datatype as Integer/ Number.

If the emp_id column is numeric then use -

C#

Convert.ToInt32(lvVar);

in your code as-

C#

SqlDataAdapter adp = new SqlDataAdapter("Select First_Name, Last_Name, DOB, Designation, Department, Join_Date from Employee where Emp_ID = " + Convert.ToInt32(lvVar) + "", cont);

Otherwise rest of the code is correct i think...

MadhuCodePro · Answer 3 · 2012-02-09T23:02:00

Solution 1

I think you are getting error on below line of code.

CSS

txtFirst_Name.Text = dt.Rows[0]["First_Name"].ToString();

check the row count of the datatable before getting the row from datatable.
And also cmbEmp_ID.SelectedValue should not be a null value.

Posted 9-Feb-12 23:02pm

MadhuCodePro

Updated 9-Feb-12 23:03pm

v2