How to retrieve multiple column from SQL database?

Question

I'm trying to get two column details like this way:

    public string GetData()
    {

        using (SqlConnection con = new SqlConnection(this.Connection))
        {
            con.Open();

            SqlCommand command = new SqlCommand("Select TITTLE,VALUE from T_PROJECTS ", con);



            // int result = command.ExecuteNonQuery();
            using (SqlDataReader reader = command.ExecuteReader())
            {
                reader.Read();
                return reader["TITTLE,VALUE"]?.ToString();
            }

        }
    }

How can I do this?

Sajeetharan · Accepted Answer · 2016-09-16 06:07:21Z

1

You need to have a custom class of columns that you want to retrieve, for example,

 public class Project
        {
          public int Title { get; set; }
          public string Value { get; set; }         
        }

and then like this,

 public Project GetData()
    {

        using (SqlConnection con = new SqlConnection(this.Connection))
        {
            con.Open();
            SqlCommand command = new SqlCommand("Select TITTLE,VALUE from T_PROJECTS ", con);
            Project proObj = new Project();            
            using (SqlDataReader reader = command.ExecuteReader())
            {
                reader.Read();
                proObj.Title = reader["TITTLE"].ToString();
                proObj.Value = reader["VALUE"].ToString();
            }

        }
     return proObj;
    }

answered Sep 16, 2016 at 6:07

Sajeetharan

223k65 gold badges370 silver badges409 bronze badges

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

8 Comments

Manu Padmanabhan Over a year ago

can i do with out creating class. means like Convert string builder to json type?

Sajeetharan Over a year ago

Yes you can do that too

Manu Padmanabhan Over a year ago

please help me to convert string bulider to jason type

Sajeetharan Over a year ago

@mr.cool Look at this sample stackoverflow.com/questions/5554472/…, mark as answer if the above has helped you

Manu Padmanabhan Over a year ago

sure,can you please re edit this syntax sb.Append("["{tittle:).append("["{duration:"); like this way

|

Paul Swetz · Accepted Answer · 2016-09-16 14:41:07Z

You could also return a Tuple although I feel a custom class is a much better solution. -> https://msdn.microsoft.com/en-us/library/system.tuple(v=vs.110).aspx

public IEnumerable<Tuple<string,string>> GetData()
{
    List<Tuple<string,string> results = new List<Tuple<string,string>>();
    using (SqlConnection con = new SqlConnection(this.Connection))
    {
        con.Open();
        SqlCommand command = new SqlCommand("Select TITTLE,VALUE from T_PROJECTS ", con);
        using (SqlDataReader reader = command.ExecuteReader())
        {
            while(reader.Read())
                results.add(new Tuple<string,string>(reader["TITLE"].ToString(),reader["VALUE"].ToString()));
        }
        return results;
    }
}

Collectives™ on Stack Overflow

How to retrieve multiple column from SQL database?

2 Answers 2

8 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

8 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related