DropDownlist Error

Aman Jen

13y1.5kVisual Basic .NET

Hi ,
I have DropDownList and few text boxes . Showing error... Invalid Argument

protected void btnSelect_Click(object sender, EventArgs e)

{

LabTestClass LB = new LabTestClass();

DataTable dtn = LB.ShowRec(DP1.SelectedItem.Value);

tbId.Text = dtn.Rows[0]["ID"].ToString();

tbName.Text = dtn.Rows[0]["Name"].ToString();

tbDesig.Text=dtn.Rows[0]["Desgn"].ToString();

}

at dropdownlist

I have sqldb with ID Autogenrated which I m bind to DRopdown..
based on selected value..it show records from db.....

Plz help....

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sanjeeb Lenka13y ago
hi,

share your dropdownlist bind code.
Aman Jen13y ago
If I do Like Above then it says

Input string was not in a correct format.
Aman Jen13y ago
Same as Drop DownList Valuse...Its Auto generated IN DB...And I have 3 records in table
Aman Jen13y ago
Still Same Error DropDownlist Error
Aman Jen13y ago
public DataTable ShowRec(int id)
{
cmd.Connection = cn;
cmd.CommandText="Select * From Labtest_Table where ID='"+ id +"'";
cn.Open();
SqlDataReader dr = cmd.ExecuteReader();
DataTable dt = new DataTable("Labtest_Table");
dt.Load(dr);
cn.Close();
return dt;
}
Prasenjit Dey13y ago
Use this :

protected void btnSelect_Click(object sender, EventArgs e)
{
LabTestClass LB = new LabTestClass();
DataTable dtn = LB.ShowRec(DP1.SelectedValue);
tbId.Text = dtn.Rows[0]["ID"].ToString();
tbName.Text = dtn.Rows[0]["Name"].ToString(); tbDesig.Text=dtn.Rows[0]["Desgn"].ToString();
}
13y ago
Make sure, you don't have any typo error in the following lines.

tbId.Text = dtn.Rows[0]["ID"].ToString();
tbName.Text = dtn.Rows[0]["Name"].ToString();
tbDesig.Text=dtn.Rows[0]["Desgn"].ToString();

How many records are retrieved from the database ?

What is the value of dtn.Rows.Count?
Sanjeeb Lenka13y ago
hi,

plz provide ShowRec() function code.

As i think id is int in your function. if its correct try this:

DataTable dtn = LB.ShowRec(Convert.ToInt32(DP1.SelectedItem.Value));
Kunal Vaishya13y ago
Hi , In which part you are getting problem . In getting data or binding.

DropDownlist Error

Input string was not in a correct format.