How to insert records from database to a label?

Question

0.00/5 (No votes)

See more:

Hi Everyone!

I am having a problem on how to insert the data from the database to their specific labels assigned.First, it will search the records based from the inputted information from my two text boxes. If it matches any, it will display the information that will insert to the labels assigned to them but I got an error message,"Index was outside the bounds of the array". But I know to myself that I am accessing the right indexes in the database. Can anyone help me out? I need to present this also today :( and I really need a hand.

Here is my code:

C#

connection_repgen();
        amicassaCon_repgen.Open();
        SqlCommand searchquery = new SqlCommand("SELECT ContractBuyerCode,ContractBuyerName,ContractSBU,ContractProjectName,ContractPrjUnitDesc,ContractModel,ContractStatus FROM MC.tblContracts WHERE ContractCompanyCode ='" + company_code.Text + "' AND ContractNo = '" + contract_no.Text + "'", amicassaCon_repgen);
        SqlDataReader dr = searchquery.ExecuteReader();
        while (dr.Read())
        {
            
            buyer_code.Text = dr[7].ToString();
            company_name.Text = dr[0].ToString();
            status.Text = dr[3].ToString();
            buyer_name.Text = dr[10].ToString();
            project_name.Text = dr[11].ToString();
            unit_desc.Text = dr[12].ToString();
            model.Text = dr[18].ToString();
           
           
        }
        dr.Close();
        amicassaCon_repgen.Close();

Posted 18-Aug-14 17:14pm

DarkDreamer08

Updated 18-Aug-14 17:30pm

Snehasish_Nandy

v2

Add a Solution

3 solutions

Solution 3

And to add to the answer concerning indexing start point: To be safe from SQL injections, data conversion problems etc, you should use SqlParameter in your queries instead of directly concatenating values from the text boxes to the SQL statement.

So you code could look something like

C#

...
SqlCommand searchquery = new SqlCommand(
"SELECT tc.ContractBuyerCode,                       
        tc.ContractBuyerName, 
        tc.ContractSBU, 
        tc.ContractProjectName, 
        tc.ContractPrjUnitDesc, 
        tc.ContractModel, 
        tc.ContractStatus 
FROM MC.tblContracts tc
WHERE tc.ContractCompanyCode = @ContractCompanyCode
AND   tc.ContractNo          = @ContractNo", amicassaCon_repgen);
   searchquery.Parameters.Add( new SqlParameter() {
      ParameterName = "@ContractCompanyCode",
      DbType = SqlDbType.VarChar,
      Size = 100,
      Value = company_code.Text }; // Remember to validate the data first?
   searchquery.Parameters.Add( new SqlParameter() {
      ParameterName = "@ContractNo",
      DbType = SqlDbType.Int,
      Value = contract_no.Text };
   SqlDataReader dr = searchquery.ExecuteReader();
...

For more information, see:
- SQL injection[^]
- SqlParameter class[^]

Posted 18-Aug-14 17:56pm

Wendelius

Solution 2

Check this

how-do-i-set-my-labels-text-with-a-value-from-the-database[^]

Hope it will help...

Posted 18-Aug-14 17:37pm

Snehasish_Nandy

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)

DamithSL · Accepted Answer · 2014-08-18T17:36:00

Solution 1

index is based on position of column in your select statement, you have

ContractBuyerCode,ContractBuyerName,ContractSBU,ContractProjectName,ContractPrjUnitDesc,ContractModel,ContractStatus

columns in your select sql. so ContractBuyerCode has 0 index, ContractBuyerName has index 1, so on...
change the code accordingly

Posted 18-Aug-14 17:36pm

DamithSL

Comments

DarkDreamer08 18-Aug-14 23:37pm

Thank you so muchh..... !!!!