Database table to Datatable in C#???????? [Resolved]

Posted by Sabarimahesh under C# on 4/12/2012 | Points: 10 | Views : 2631 | Status : [Member] | Replies : 7

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

private void LoadDataToTable()
{
 DataTable Tb1= null;
            using (SqlConnection connection =new SqlConnection("con"))
            {
                using (SqlCommand cmd=connection.CreateCommand())
                {
                    cmd.CommandText = "select * from Student";
                    cmd.CommandType = System.Data.CommandType.Text;
                    using (SqlDataReader read=cmd.ExecuteReader())
                    {
                        if (reader.HasRows)
                        {
                            Tb1= new DataTable();
                            Tb1.FIll(read);
                        }
                    }
                }
            }
}

Life is a Race
Thanks & Regards
By
Sabari Mahesh P M

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Leila on: 4/12/2012 [Member] Starter | Points: 50

0	private void LoadDataToTable() { DataTable Tb1= null; using (SqlConnection connection =new SqlConnection("con")) { using (SqlCommand cmd=connection.CreateCommand()) { cmd.CommandText = "select * from Student"; cmd.CommandType = System.Data.CommandType.Text; DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(ds); Tb1 = ds.Tables[0]; } } } Thanks, Leila Sabarimahesh, if this helps please login to Mark As Answer. \| Alert Moderator

private void LoadDataToTable()

{

 DataTable Tb1= null;

            using (SqlConnection connection =new SqlConnection("con"))

            {

                using (SqlCommand cmd=connection.CreateCommand())

                {

                    cmd.CommandText = "select * from Student";

                    cmd.CommandType = System.Data.CommandType.Text;

                    DataSet ds = new DataSet();

                    SqlDataAdapter da = new SqlDataAdapter(cmd);

                    da.Fill(ds);

                    Tb1 = ds.Tables[0];

 }

            }

}

Thanks,
Leila

Sabarimahesh, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Leila on: 4/12/2012 [Member] Starter | Points: 25

0	Can you please precise what the question? Did the code you wrote give error? Thanks, Leila Sabarimahesh, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Sabarimahesh on: 4/12/2012 [Member] Bronze | Points: 25

0	Database table to datatable Life is a Race Thanks & Regards By Sabari Mahesh P M Sabarimahesh, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Rajni.Shekhar on: 4/12/2012 [Member] Bronze | Points: 25

0	Hi, Did you have any Load method to fill your datatable? Leila code is correct to fill data table. Thanks, Rajni Shekhar Sabarimahesh, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Sabarimahesh on: 4/12/2012 [Member] Bronze | Points: 25

0	Sorry i changed it Life is a Race Thanks & Regards By Sabari Mahesh P M Sabarimahesh, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Leila on: 4/12/2012 [Member] Starter | Points: 25

0	If so, can u plz mark it as an answer:) Thanks, Leila Sabarimahesh, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Sabarimahesh on: 4/12/2012 [Member] Bronze | Points: 25

0	Leila Thank You Life is a Race Thanks & Regards By Sabari Mahesh P M Sabarimahesh, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts