Esta e uma forma de fazer isto:
private void datagridtestar()
{
SqlConnection cn = new SqlConnection(WindowsFormsApplication2010.Properties.Settings.Default.Connection.ToString());
MessageBox.Show(cn.ToString());
SqlDataAdapter adpter = new SqlDataAdapter();
try
{
DataSet dt = new DataSet();
adpter.SelectCommand = new SqlCommand("Select * From Table_Copy",cn);
adpter.Fill(dt);
this.dataGridView1.AutoGenerateColumns = true;
for (int i = 0; i < dt.Tables[0].Columns.Count; i++)
{
DataGridViewColumn nome = new DataGridViewColumn();
nome.DataPropertyName = dt.Tables[0].Columns[i].ColumnName.ToString();
nome.Name = dt.Tables[0].Columns[i].ColumnName.ToString();
nome.CellTemplate = new DataGridViewTextBoxCell();
this.dataGridView1.Columns.Add(nome);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
finally
{
adpter.Dispose();
}
}
Vai carregar o teu datagridview com os campos.....
One word frees us of all the weight and pain of life: that word is love.
