Retuning Data From SQL Server database into Class

Question

I'm trying to fill a class with data from a SQL Server table.

I've done the exact thing before using Java for another application (see below)

public LanguageList getSystemLanguages() throws SQLException 
{
    String sql;
    LanguageList language;
    sql = "Select DISTINCT code_language From CODE";
    prest = conn.prepareStatement(sql);
    rset = prest.executeQuery();
    language = new LanguageList(rset);
    return language;
}

In C# I have so far:

public Incident GetIncidentViaLogID(String LogID)
{
     Incident incident;
     SqlCommand cmd = new SqlCommand();
     cmd.CommandText = "SELECT * FROM dbo.Incident WHERE LogID = @LogID";
     cmd.Connection = conn;
     SqlParameter p1 = cmd.Parameters.Add("@LogID", SqlDbType.VarChar);
     p1.Value = LogID;
     p1.Size = -1;
     cmd.Prepare();

     //Load data into class
}

I've tried numerous things to finish off this method but none have worked. What would be the approach to complete this method?

Thanks!

In which way do I execute it and return it? Thanks!

ASPCoder1450
– ASPCoder1450

2014-01-18 19:30:48 +00:00
Commented Jan 18, 2014 at 19:30 — ASPCoder1450
– ASPCoder1450, Commented Jan 18, 2014 at 19:30

Patrick Hofman · Accepted Answer · 2014-01-18 19:43:40Z

1

I think that you mean: how do I load this into a class. There are several options for that, but the most used solution is Entity Framework

answered Jan 18, 2014 at 19:43

Patrick Hofman

158k23 gold badges270 silver badges343 bronze badges

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

Comments

prograshid · Accepted Answer · 2014-01-18 20:33:17Z

Here is an example that may help you.

let your class is

          class Person
                {
                   public int age;
                   public string name;
                }

Create an object

                Person p1 = null; 

                List<Person> personList = new List<Person>(); //To fill with data retrieve from database 
//Method to fill Class with data


               public void getAllPersonData()
                {

                    try
                    {
                        if (con.State == ConnectionState.Closed)
                        {
                            con.Open();
                        }

                        string query = "SELECT * FROM Persons";

                        SqlCommand cmd = new SqlCommand(query, con);

                        SqlDataReader rdr = cmd.ExecuteReader();

                        while (rdr.Read())
                        {
                            p1 = new Person(); //Create Instances
                            p1.age = rdr.GetInt32(0);
                            p1.name = rdr.GetString(1);
                            personList.Add(p1);                                
                        }
                    }
                    catch (SqlException x)
                    {
                        MessageBox.Show(x.Message);
                    }
                }

Collectives™ on Stack Overflow

Retuning Data From SQL Server database into Class

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related