Here's my table script below @Esakki Muthu

Hold On, 

Can you share the actual table script "tblHPACoverageBenefits" , in the attachment you have shared different table script that is "tblHPAInsurance".

Is my understanding correct, Based on the HPAPlan you have selected based on that you need to bind the corresponding amount from "tblHPACoverageBenefits" table? 

 

Did u thought of using  entity framework?

Below code is what I did:

As well as for the Plan 3 to 5. This helps me attain my objective though is it very tedious. Can anyone help me to make this simple?

Hello,

Looks like you are not reading the replies with extreme care and attention, which is an absolute must.

My comment was to Mithun and not to you. So basically, you will need to use Mithun's code and integrate the improvement i suggested.

The code given by me IS NOT going work as it is.

Hope you understand.

Hi Hold On,

First you debug and check whether  dataset contains result of query. Give ids of textboxes as follows

 

txtCoverageBenefit1

txtCoverageBenefit2

txtCoverageBenefit3

 

No need to  assigning values to each textboxes in the for loop instead of that give single step

 

TextBox txtCoverageBenefit = (TextBox)Page.FindControl("txtCoverageBenefit" + i);
txtCoverageBenefit.Text = ds.Tables[0].Rows[i]["Amount"].ToString(); 

Furthermore, I just took Mithun's code and wanted to improve on it. You haven't declared the variable i. Notice all red squiggly lines below the code and hover cursor over them to read errors.

I don't know the entire context of the code. I just picked a piece of it and showed alternate way to write it.

The brackets are mismatching...Try the one below. I am surprised that you are able to run the code despite compilation errors. Did you choose to continue despite of it? You should first resolve syntactical errors before continuing...

Hi,

Visit here you will find proper example .

http://www.c-sharpcorner.com/article/autocomplete-textbox-in-C-Sharp/

@Mithun,

Purely from the aesthetics point of view it would be better to write as follows:

while(sdr.Read())

{

String value = sdr.IsDBNull(sdr.GetOrdinal("Amount") ? String.Empty : sdr["Amount"].ToString();

switch(i)

{

case 1:

txtCoverageBenefit1.Text = value;

break;

// and so on...

}

}

@Jisny Av, I tried your suggestion and did this:

but I got this error

Hi,

Try below code

protected void ddlHPACoverage_SelectedIndexChanged(object sender, EventArgs e)
{

using (SqlConnection SqlCn = DBConnection.GetDbCon())
{
String strQuery = "select HPAPlan, Amount from tblHPACoverageBenefits where HPAPlan = @HPAPlan";
SqlCommand cmd = new SqlCommand();
cmd.Parameters.AddWithValue("@HPAPlan", ddlHPACoverage.SelectedItem.Text);
cmd.CommandType = CommandType.Text;
cmd.CommandText = strQuery;
cmd.Connection = SqlCn;
try
{
SqlCn.Open();
// SqlDataReader sdr = cmd.ExecuteReader();

SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet ds = null;
adapter.Fill(ds);


for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
TextBox txtCoverageBenefit = (TextBox)Page.FindControl("txtCoverageBenefit" + i);
txtCoverageBenefit.Text = ds.Tables[0].Rows[i]["Amount"].ToString();
}

}
catch (Exception ex)
{
throw ex;
}
finally
{
SqlCn.Close();
SqlCn.Dispose();
}
}
}

Hi Hold on,

I have seen your Db structure and Code but you given this table [tblHPAInsurance] and your fetching from this table tblHPACoverageBenefits in sql command.

If you dont mind can you please, provide this table structure of tblHPACoverageBenefits..

So that I can help you out.

Hi,

You may need to assign value of textboxes like below -