View database fields in listView

Question

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); }

abdullah · Answer

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(dataSetOrdlinie); } catch (Exception ex) { Response.Write(Connection error:  + ex.ToString()); } WeekGrid.DataSource=dataSet.Tables[Ordlinie].DefaultView; WeekGrid.DataBind(); myConnection.Close(); } } }