[omart]

Hi there,
I want to display a table from my database in the datagridview, but the problem is that the datagridview is always empty,there not an error message.
My code is:

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.SqlClient;
using System.Data.Sql;

namespace gestock
{
	public partial class Form2 : Form
	{

		 SqlConnection c=new SqlConnection();
		public Form2()
		{
			InitializeComponent();
			FillData();
		}

		/*public Form2(SqlConnection cn)
		{
			InitializeComponent();
			c = cn;
		}*/

		private void Form2_Load(object sender, EventArgs e)
		{
			//dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
			  
		}
		 
		 void FillData()
		{
			string connectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=C:\\Documents and Settings\\Administrateur\\Mes documents\\stock.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
			c.ConnectionString = connectionString;
			SqlDataAdapter d = new SqlDataAdapter("select * from fournir", c);
			MessageBox.Show("La connexion avec la base de donnée est faite!!!!!");
			DataTable dt = new DataTable();
			d.Fill(dt);
			//d.Fill(dt);
			dataGridView1.DataSource = dt;
			   
		}
	  
	}
}

Thanks everybody

[PsychoCoder]

It's empty because you never call FillData (thus telling it to populate your grid). Try calling it in the Load event

private void Form2_Load(object sender, EventArgs e)
{
	   FillData();			 
}

EDIT: Did see you were calling it from the constructor (my bad) Try chaning this line

 dataGridView1.DataSource = dt;

To this

 dataGridView1.DataSource = dt.DefaultView;

[FlashM]

From my experience your data grid view should get populated. Do you have your table in database populated? :-)

PsychoCoder, on 14 Dec, 2009 - 12:28 PM, said:

It's empty because you never call FillData (thus telling it to populate your grid). Try calling it in the Load event

private void Form2_Load(object sender, EventArgs e)
{
	   FillData();			 
}

This method is called in form's constructor and I see no reason why this wouldn't work...

[omart]

Hi there
thank you guys for your help
I changed the location of the function call in load event, the result is that the pc crashes for a few seconds, then displays an error message "An unhandled exception of type 'System.StackOverflowException" occurred in mscorlib.dll ".What's wrong? ,and what can I do to solve this problem?
What's that mean a database populated?

THANK YOU EVERYTBODY

[FlashM]

http://msdn.microsof...28VS.71%29.aspx

How many records does your fournir table have?

[omart]

FlashM, on 15 Dec, 2009 - 01:37 AM, said:

http://msdn.microsof...28VS.71%29.aspx

How many records does your fournir table have?

This table contains 4 records.

[PsychoCoder]

Just for the fun of it try this modified code

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.SqlClient;
using System.Data.Sql;

namespace gestock
{
	public partial class Form2 : Form
	{

		 SqlConnection c = null;

		public Form2()
		{
			InitializeComponent();
		}

		private void Form2_Load(object sender, EventArgs e)
		{
					  FillData();
		}
		 
		 void FillData()
		{
			c = new SqlConnection(@"Data Source=.\\SQLEXPRESS;AttachDbFilename=C:\Documents and Settings\Administrateur\Mes documents\stock.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");
			SqlDataAdapter d = new SqlDataAdapter("select * from fournir", c);
			MessageBox.Show("La connexion avec la base de donnée est faite!!!!!");
			DataTable dt = new DataTable();
			d.Fill(dt);
			//d.Fill(dt);
			dataGridView1.DataSource = dt.DefaultView;
			   
		}
	 
	}
}

[omart]

Hi,
I tested your code, but it does not, an error message appears: "Instance failure" at the call of the function d.Fill (dt)

[omart]

Hi guys,
Finally I could see the table in the datagridview, the problem is that I have misconfigured my database, now it's OK
The code works very well.
The code is as follows:

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.SqlClient;

namespace gestock1
{

	public partial class Form2 : Form
	{

		SqlConnection c = new SqlConnection();
		public Form2()
		{
			InitializeComponent();
			FillData();
		}

		private void Form2_Load(object sender, EventArgs e)
		{
			//dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;

			//FillData();
		}

		void FillData()
		{
			string connectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=C:\\Documents and Settings\\Administrateur\\Mes documents\\stockage.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
			c.ConnectionString = connectionString;
			SqlDataAdapter d = new SqlDataAdapter("select * from fournir", c);
			//MessageBox.Show("La connexion avec la base de donnée est faite!!!!!");
			DataTable dt = new DataTable();
			d.Fill(dt);
			//d.Fill(dt);
			dataGridView1.DataSource = dt.DefaultView;

		}

	}
}

Thank you all