how to store columns values in array in asp.net

Question

I am writing code in asp.net. I have a column named c_name in database. I want to store all my columns values in an array. Here is my incomplete code. I am confused what to do here.

String str = "select c_name from contacts where user_id = " + user_id + "";

MySqlCommand cmd = new MySqlCommand(str, dbConnection);
cmd.ExecuteNonQuery();

MySqlDataReader mdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);

while (mdr.Read())
{

}

Please help.

Rahul Nikate · Accepted Answer · 2014-12-11 09:30:33Z

1

Check below code:

   String str = "select c_name from contacts where user_id = " + user_id + "";
   MySqlCommand cmd = new MySqlCommand(str, dbConnection);
   MySqlDataReader mdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);

   List<string> list = new List<string>();
   while (mdr.Read())
   {
        list.Add(mdr.GetString(0));
   }

   string[] strMyArray = list.ToArray<string>();

edited Dec 11, 2014 at 9:30

answered Dec 11, 2014 at 9:25

Rahul Nikate

6,3555 gold badges45 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Mivaweb Over a year ago

what is reader? Please add some more details to fully describe what you are doing

Liath Over a year ago

Also I suspect ExecuteNonQuery() doesn't want to be there and has been copied in by the OP by accident

Liath · Accepted Answer · 2014-12-11 09:36:54Z

I suspect one of your your problems is this line:

cmd.ExecuteNonQuery();

You're actually executing cmd twice, once with this line and once again when you create your reader. I've also added a little code to copy the result into an element in a list. Try the following:

string str = "select c_name from contacts where user_id = " + user_id + "";

MySqlCommand cmd = new MySqlCommand(str, dbConnection);

MySqlDataReader mdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);

// create a list to hold the results in
List<string> results = new List<string>();
while (mdr.Read())
{
  // for each row read a string and add it in
  results.Add(mdr.GetString(0));
}

You've asked for an array - I've used a list because it's easier. If you REALLY want an array then just call:

var theArray = results.ToArray();

I would also suggest throwing in some using blocks around the connection, command and reader.

Collectives™ on Stack Overflow

how to store columns values in array in asp.net

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related