get data in datagridview
-
i m making an application in c#.net2005, window application. How can i connect datagridview to database(sqlserver2000) at runtime? - not from design, only by coding. i have written this code, but no data is listed in grid : SqlConnection conn = new SqlConnection("Data Source=......"); private void Form1_Load(object sender, EventArgs e) { conn.Open(); SqlDataAdapter da = new SqlDataAdapter("select * from tblsummary", conn); DataSet ds = new DataSet(); da.Fill(ds, "tblsummary"); //dataGridView1.Columns.Add(sitehit); dataGridView1.DataSource = ds; conn.Close(); } Does i miss something else for connection? Hope to get a reply.. thank you in adv. nekshan.
-
i m making an application in c#.net2005, window application. How can i connect datagridview to database(sqlserver2000) at runtime? - not from design, only by coding. i have written this code, but no data is listed in grid : SqlConnection conn = new SqlConnection("Data Source=......"); private void Form1_Load(object sender, EventArgs e) { conn.Open(); SqlDataAdapter da = new SqlDataAdapter("select * from tblsummary", conn); DataSet ds = new DataSet(); da.Fill(ds, "tblsummary"); //dataGridView1.Columns.Add(sitehit); dataGridView1.DataSource = ds; conn.Close(); } Does i miss something else for connection? Hope to get a reply.. thank you in adv. nekshan.
private void Form1_Load(object sender, EventArgs e) { ' Create Instance of Connection and Command Object Dim myConnection As SqlConnection = New SqlConnection(System.Configuration.ConfigurationManager.AppSettings("ConnectionString")) Dim myCommand As SqlCommand = New SqlCommand("select statement", myConnection) ' Execute the command myConnection.Open() Dim result As SqlDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection) DataSet ds = new DataSet(); da.Fill(ds); dataGridView1.DataSource = ds.tables(0); } convert this in c# some code is paste from vb.net that's y. open www.meebo.com to chat with me this site give facility to chat by using yahoo login ok.
-
private void Form1_Load(object sender, EventArgs e) { ' Create Instance of Connection and Command Object Dim myConnection As SqlConnection = New SqlConnection(System.Configuration.ConfigurationManager.AppSettings("ConnectionString")) Dim myCommand As SqlCommand = New SqlCommand("select statement", myConnection) ' Execute the command myConnection.Open() Dim result As SqlDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection) DataSet ds = new DataSet(); da.Fill(ds); dataGridView1.DataSource = ds.tables(0); } convert this in c# some code is paste from vb.net that's y. open www.meebo.com to chat with me this site give facility to chat by using yahoo login ok.
Dim myConnection As SqlConnection = New SqlConnection(write u'r connecting string over here) in prev code.
-
i m making an application in c#.net2005, window application. How can i connect datagridview to database(sqlserver2000) at runtime? - not from design, only by coding. i have written this code, but no data is listed in grid : SqlConnection conn = new SqlConnection("Data Source=......"); private void Form1_Load(object sender, EventArgs e) { conn.Open(); SqlDataAdapter da = new SqlDataAdapter("select * from tblsummary", conn); DataSet ds = new DataSet(); da.Fill(ds, "tblsummary"); //dataGridView1.Columns.Add(sitehit); dataGridView1.DataSource = ds; conn.Close(); } Does i miss something else for connection? Hope to get a reply.. thank you in adv. nekshan.
private void Form1_Load(object sender, EventArgs e) { Dim connectionString As String = "server='(local)'; trusted_connection=true; database='webstore'" Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection("Data Source=write connecting string over here") Dim queryString As String = "SELECT [Categories].[CategoryID], [Categories].[CategoryText] FROM [Categories]" Dim dbCommand As System.Data.IDbCommand = New System.Data.SqlClient.SqlCommand dbCommand.CommandText = queryString dbCommand.Connection = dbConnection Dim dataAdapter As System.Data.IDbDataAdapter = New System.Data.SqlClient.SqlDataAdapter dataAdapter.SelectCommand = dbCommand Dim dataSet As System.Data.DataSet = New System.Data.DataSet dataAdapter.Fill(dataSet) dataGridView1.DataSource = ds.tables(0); conn.Close(); }
-
private void Form1_Load(object sender, EventArgs e) { ' Create Instance of Connection and Command Object Dim myConnection As SqlConnection = New SqlConnection(System.Configuration.ConfigurationManager.AppSettings("ConnectionString")) Dim myCommand As SqlCommand = New SqlCommand("select statement", myConnection) ' Execute the command myConnection.Open() Dim result As SqlDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection) DataSet ds = new DataSet(); da.Fill(ds); dataGridView1.DataSource = ds.tables(0); } convert this in c# some code is paste from vb.net that's y. open www.meebo.com to chat with me this site give facility to chat by using yahoo login ok.
-
private void Form1_Load(object sender, EventArgs e) { ' Create Instance of Connection and Command Object Dim myConnection As SqlConnection = New SqlConnection(System.Configuration.ConfigurationManager.AppSettings("ConnectionString")) Dim myCommand As SqlCommand = New SqlCommand("select statement", myConnection) ' Execute the command myConnection.Open() Dim result As SqlDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection) DataSet ds = new DataSet(); da.Fill(ds); dataGridView1.DataSource = ds.tables(0); } convert this in c# some code is paste from vb.net that's y. open www.meebo.com to chat with me this site give facility to chat by using yahoo login ok.
thanx its working. www.meebo.com is not allowed :-( i'll try again. how r u? wen r u coming?? c u soon!! nekshan.
-
thanx its working. www.meebo.com is not allowed :-( i'll try again. how r u? wen r u coming?? c u soon!! nekshan.
use this & check. http://wwwl.meebo.com/index-en-GB.html fine.i m coming on 1st may.after 1 week.
-
i m making an application in c#.net2005, window application. How can i connect datagridview to database(sqlserver2000) at runtime? - not from design, only by coding. i have written this code, but no data is listed in grid : SqlConnection conn = new SqlConnection("Data Source=......"); private void Form1_Load(object sender, EventArgs e) { conn.Open(); SqlDataAdapter da = new SqlDataAdapter("select * from tblsummary", conn); DataSet ds = new DataSet(); da.Fill(ds, "tblsummary"); //dataGridView1.Columns.Add(sitehit); dataGridView1.DataSource = ds; conn.Close(); } Does i miss something else for connection? Hope to get a reply.. thank you in adv. nekshan.
just an alternate method by using the data reader
SqlConnection conn = new SqlConnection("Data Source=" + Environment.MachineName + "\\WINCC;Integrated Security=SSPI;Initial Catalog=Logger; Packet Size = 32766;");
SqlCommand cmd = new SqlCommand("SELECT * FROM RDPLogViewer WHERE SubSystem = '" + SubSystemComboBox.Text + "'", conn);
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
LoggerDatagrid.Rows.Add(rdr["TypeLevel"].ToString(), rdr["TimeStamp"].ToString(), rdr["SubSystem"].ToString(), rdr["ClassName"].ToString(), rdr["FunctionUsed"].ToString(), rdr["Memory"].ToString(), rdr["Statement"].ToString());
}Assuming that the variables are existing in the respective tables/database
Keshav Kamat :) India
-
i m making an application in c#.net2005, window application. How can i connect datagridview to database(sqlserver2000) at runtime? - not from design, only by coding. i have written this code, but no data is listed in grid : SqlConnection conn = new SqlConnection("Data Source=......"); private void Form1_Load(object sender, EventArgs e) { conn.Open(); SqlDataAdapter da = new SqlDataAdapter("select * from tblsummary", conn); DataSet ds = new DataSet(); da.Fill(ds, "tblsummary"); //dataGridView1.Columns.Add(sitehit); dataGridView1.DataSource = ds; conn.Close(); } Does i miss something else for connection? Hope to get a reply.. thank you in adv. nekshan.
You can also use a dataset/data table to bind the database table contents to the datagrid.
Keshav Kamat :) India
-
You can also use a dataset/data table to bind the database table contents to the datagrid.
Keshav Kamat :) India