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

[@raduluchian7008]

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

[@haftomkahsay7902]

thank you very much!!!!!!

[@foxlearn]

You're welcome. Thank you !

[@haftomkahsay7902]

@@foxlearn Sorry it doesn't work for me Could you Show me in other way or more clear way??? thanks more .Am Waiting your great legend code....

[@mutahhirkhan]

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

[@mutahhirkhan]

please reply fast . TY

[@jagadeeshbarfa]

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

[@foxlearn]

Hi, Yes you can do the same with mysql. thanks

[@vasyafoonken5382]

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())
{
checkedListBox1.Items.Add(dr[0].ToString());
}
dr.Close();
cn.Close();
}
}