Had a doubt with DataReader? [Resolved]

Posted by Rajeshk under ASP.NET on 1/5/2013 | Points: 10 | Views : 1806 | Status : [Member] | Replies : 7

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

hi all,

i heard that datareader is sequential and we can read data in forword direction only but i need a requirement like if i want to read all the table data at a time from db using datareader and bind with gridview to display data what i need to do plz give me an example with your explanation?

Thanks&Regards
rajeshkommireddy@gmail.com

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: muralikrishnasurap-12704 on: 1/8/2013 [Member] Starter | Points: 50

0	Hi Rajeshk try this part of code SqlCommand cmd = new SqlCommand("SQl Query", SQlConnectionObject); SqlDataReader dr = cmd.ExecuteReader(); gridview.DataSource = dr; gridview.DataBind(); Best Regards Murali Krishna.S Rajeshk, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Saratvaddilli on: 1/8/2013 [Member] [MVP] Bronze | Points: 50

0	Hi rajesh , Murali krishna answer was good apart from that we trythis also string strConnString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString; using (SqlConnection con = new SqlConnection(strConnString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.CommandText = "Your Query"; cmd.Connection = con; con.Open(); GridView1.DataSource = cmd.ExecuteReader(); GridView1.DataBind(); con.Close(); } } Thanks and Regards V.SaratChand Show difficulties that how difficult you are Rajeshk, if this helps please login to Mark As Answer. \| Alert Moderator

Hi rajesh ,
Murali krishna answer was good apart from that we trythis also

 string strConnString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;

    using (SqlConnection con = new SqlConnection(strConnString))

    {

        using (SqlCommand cmd = new SqlCommand())

        {

            cmd.CommandText = "Your Query";

            cmd.Connection = con;

            con.Open();

            GridView1.DataSource = cmd.ExecuteReader();

            GridView1.DataBind();

            con.Close();

        }

    }

Thanks and Regards
V.SaratChand
Show difficulties that how difficult you are

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

Posted by: Saratvaddilli on: 1/6/2013 [Member] [MVP] Bronze | Points: 25

0	make me clear one thing, you want to get data from db and bind using datareader or you just want to filter and bind to gridview Thanks and Regards V.SaratChand Show difficulties that how difficult you are Rajeshk, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Elephant12 on: 1/8/2013 [Member] Starter | Points: 25

0	Datareader is to support the SetPosition/GetPosition interface and returning UMC_ERR_FAILED is not an option any more. Rajeshk, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Rajeshk on: 1/8/2013 [Member] Starter | Points: 25

0	i want to display the whole table data in gridview using DataReader(simply it has to read entire table but not one by one records) Thanks&Regards rajeshkommireddy@gmail.com Rajeshk, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Rajeshk on: 1/9/2013 [Member] Starter | Points: 25

0	hi , onething guys will it work with both windows&web apps? Thanks&Regards rajeshkommireddy@gmail.com Rajeshk, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Saratvaddilli on: 1/9/2013 [Member] [MVP] Bronze | Points: 25

0	ya with out fail Thanks and Regards V.SaratChand Show difficulties that how difficult you are Rajeshk, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts