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