<pre>private void button1_Click(object sender, EventArgs e) { //Load Main Table SQLiteConnection dbConnectionString; dbConnectionString = new SQLiteConnection(@"Data Source = F:\Omega\Drawing Register\DRDB.sqlite; Version = 3"); dbConnectionString.Open(); string sql = "SELECT * FROM Jobs"; SQLiteCommand command = new SQLiteCommand(sql, dbConnectionString); var sqlDataAdapt = new SQLiteDataAdapter(sql, dbConnectionString); using (DataTable dt = new DataTable()) { sqlDataAdapt.Fill(dt); dataGridView1.DataSource = dt; //Set Font dataGridView1.Font = new Font("MS Sans Serif", 8); //Set Column Widths dataGridView1.Columns[0].Width = 100; //Set Column Names dataGridView1.Columns[0].HeaderText = "Enq No"; } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)