Query Sql Server in String

Question

I want to assign the result of a SQL Server query to a variable. This query may or may not have more than one line, but only one column.
Example:
QUERY> SELECT NAME FROM NAMES
OUTPUT

NAME

Michael

Michele

John

James

Variable > String names = ('Michael','Michele','John','James');

Sujeet Suman · Answer

Haidon you can also store in string type list. List list = new List (); string allname = (  using (SqlConnection con = new SqlConnection(Data Source=abc;Integrated Security=true;Initial Catalog=Test)) { con.Open(); SqlCommand cmd = new SqlCommand(Select Name FROM DB_Names con); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { list.Add(dr.GetValue(0).ToString()); } while (dr.Read()) { allname += dr.GetValue(0).ToString() +  ; } allname +=  ); con.Close(); }

Haidon Diogenes · Answer

Sujeet Suman but i not want write the result of query in DataGridView. I want write result in String.

Sujeet Suman · Answer

Haidon please once try below code: using (SqlConnection con = new SqlConnection(Data Source=abc;Integrated Security=true;Initial Catalog=Test)) { con.Open(); SqlCommand cmd = new SqlCommand(Select Name FROM DB_Names con); SqlDataReader dr = cmd.ExecuteReader(); // Here you can write code to show selected names with any control. Like below dgv.DataSource = dr; dgv.DataBind(); con.Close(); } If this is helpful for you then please accept my Answer .