C# Tutorial - How to Load selected columns data in DataGridView | FoxLearn

How to load selected columns data in DataGridView using C#

C#-How to load selected columns data in datagridview
How to Bind specific Columns of a datatable to a datagridView?
c# - How to show only certain columns in a DataGridView with custom objects
c# - How do I display only certain columns from a data table?
Show (bind) only some specific (certain) columns of DataGridView control in Windows Forms (WinForms) Application using C#
How To Get Specify Column Data From Datagridview?

[vasyafoonken]

if table 1500 columns

SqlConnection cn = new SqlConnection();
SqlCommand cmd = new SqlCommand();
SqlDataReader dr;


public NastrGrid()
{
InitializeComponent();
}

private void loaddata ()
{
cmd.CommandText = "Select column_name FROM information_schema.columns WHERE table_name= 'You table' ORDER BY ordinal_position";
cn.Open();
dr = cmd.ExecuteReader();
if (dr.HasRows)
{

while (dr.Read())
{

}
dr.Close();
cn.Close();
}
}

[raduluchian]

te rog pentru a simplifica lucrurile, ... poti face acest lucru cu o baza de date din Acces?
Multumesc anticipat!

[mutahhirkhan]

if i use this method to show selected rows... what modification would i do ?

[jagadeeshbarfa]

can i do the same using MYSQL, ? because i have some errors logging in SQL SERVER..!!