none
Visual Studio C# For Loop working with Database RRS feed

  • Question

  • Database

    john smith   9234839  
    ken williams 3293432
    mary davis  9234323  

    jan will        5832934

    kc bing        3892343

    //////////////////////////////

    This is a multiline Text Box wanting to input more then one item at a time

     input Box      9234839,
                         3293432 ,

                         5832934,

                         3892343

     Button
    //////////////////////////////////

    private void submitbutton_Click(object sender, EventArgs e)
            {

                string connString = ConfigurationManager.ConnectionStrings["data"].ConnectionString;
                using (SqlConnection con = new SqlConnection(connString))


                {
                    for (int i = 1; i <= "Contact.Text.Count(); i++)
                    {
                        if (1 < i)
                        {
                           
                            con.Open();

                            SqlCommand cmd = new SqlCommand("NameAddress", con);
                            cmd.CommandType = System.Data.CommandType.StoredProcedure;

                           
                            cmd.Parameters.AddWithValue("@NameAddress", SqlDbType.VarChar).Value = Contact.Text.Trim();


                            SqlDataReader dr = cmd.ExecuteReader();
     ---------------------  dr.Read();  //'Invalid attempt to read when no data is present.'

                            textBox1.Text = dr[1].ToString() + " " +  dr[2].ToString() + " " + dr[3].ToString() + " " + i.ToString();

                            con.Close();
                        }

    what I want it to do is print out like this below, but I am getting this 'Invalid attempt to read when no data is present.'. I am just not sure what I am doing wrong?                      

    john smith   9234839  1
    ken williams 3293432  2
    mary davis  9234323   3

    jan will        5832934   4

    kc bing        3892343   5

    Sunday, August 4, 2019 7:05 PM