Retrieve data from an SQL server.

[Arkie]

This is how i retrieve data from an SQL database.

Code

GeSHi (csharp):
  public void getDataFromPersonID(int id)
        {
            string sqlQuery = "select * from table, where Person_ID = " + id;
            SqlCommand cmd = new SqlCommand(sqlQuery, conn);
 
            conn.Open();
            a = new SqlDataAdapter(cmd);
            s = new DataSet();
            a.Fill(s);
            conn.Close();
 
            foreach (DataRow dr in s.Tables[0].Rows)
            {
                this._Persoon_ID = (int)dr["Person_ID"];
                //other columns
            }
        }
 
 
Created by GeSHI 1.0.7.20

[jurka]

I would say it's cleaner and easier to understand then it's in Java. Good job!

[Arkie]

I would say it's cleaner and easier to understand then it's in Java. Good job!

The code above is using ado.net but it can be done much easier using TableAdapters, read this: http://www.engineeringser...ableadapters-t2973.0.html