M
Mary21student
Guest
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
Continue reading...
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
Continue reading...