SQL query string result to fill in to datagridview columns

Question

I have 3 sqlquery string , the first query result i would like to fill in to datagridview columns1 the secound sqlquery result i would like to fill in to datagridview columns2
some one can help me on this?

meko weldys · Answer

Hi Nayak, Have you looked my code? if you have any Idea please let me know. Regard Meko

meko weldys · Answer

string strSQL1; string strSQL2; int volt = 250; DataTable table = new DataTable(); while (volt { strSQL1 = " SELECT COUNT(ID) [column1] FROM [tablename]" + " WHERE (ID = '112') AND (DVolt BETWEEN " + volt + " AND (" + volt + "+ 25)) AND (APower / (RPower) BETWEEN 0.0 AND 0.05)"; strSQL2 = " SELECT COUNT(ID)[column2] FROM [tablename]" + " WHERE (ID = '112') AND (DVolt BETWEEN " + volt + " AND (" + volt + "+ 25)) AND (Apower / (RPower) BETWEEN 0.05 AND 0.1)"; volt = volt + 25; using (SqlConnection conn = new SqlConnection(string connection) { conn.Open(); using (SqlDataAdapter adapter1 = new SqlDataAdapter(strSQL1, conn)) { adapter1 .Fill(table) ; dataGridView1.DataSource = table ; } using (SqlDataAdapter adapter2 = new SqlDataAdapter(strSQL2, conn)) { adapter2.Fill(table); dataGridView1.DataSource = table; } conn.close(); } } This is my code, I am able to fill the column1 and column2 in dataGridView1 but the rows are not proportinal. I need help regard Meko

Satyapriya Nayak · Answer

Hi Meko, Run the attachments. using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace Datagridview_bind { public partial class Form1 : Form { string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dsn"]; OleDbCommand com; OleDbDataAdapter oda; DataSet ds; string str; public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = "select customer.custname,product.prodname from customer, product where customer.prodid = product.prodid"; com = new OleDbCommand(str, con); oda = new OleDbDataAdapter(com); ds = new DataSet(); oda.Fill(ds, "customer"); dataGridView1.DataMember = "customer"; dataGridView1.DataSource = ds; con.Close(); } } } Thanks If this post helps you mark it as answer

SQL query string result to fill in to datagridview columns

Answers (3)