View database fields in listView

I have this script where it makes access to the database remotely. Now i'm trying to show the result from the database in a listView Panel . Does any one knows what scripting i will need to do in order to show the data: private void button1_Click(object sender, System.EventArgs e) { DataSet ds = new DataSet(); SqlConnection con = new SqlConnection (@"Data Source= xxx.xxx.xxx.xxx;"+ Initial Catalog = drmTest;" + "Network Library=DBMSSOCN;"+ "user id =xx;"+ "Password=xx"); // assign conString String sQuery = "SELECT LicenseID, Name, Description FROM License WHERE LicenseID = '"+169+"'"; Console.WriteLine(sQuery); }

Hi....... use dataGrid it's much better....... Check this it might help you......... protected DataGrid WeekGrid; //string strConnectString = "driver={C5ODBC}; server=localhost; //string strConnectString = "FILEDSN='C:\\Program Files\\Common //Files\\ODBC\\Data Sources\\c5booking (not sharable)'"; OdbcConnection myConnection = new OdbcConnection(strConnectString); string sql = "SELECT Nummer FROM OrdLinie"; //string sql = "select * from room"; OdbcDataAdapter myCommand = new OdbcDataAdapter(sql, myConnection); try { myConnection.Open(); DataSet dataSet = new DataSet(); myCommand.Fill(dataSet,"Ordlinie"); } catch (Exception ex) { Response.Write("Connection error: " + ex.ToString()); } WeekGrid.DataSource=dataSet.Tables["Ordlinie"].DefaultView; WeekGrid.DataBind(); myConnection.Close(); } } }