a beginner facing problem in database :(

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

hi all

i am facing a problem .. i hav a button in my web form .. and i want that when i clik this button
then a data which i made in sql server 2005 ... will be displayed in a grid view i placed just below the button
i am doing this with the code i showed u below in image but when i m clikng the button it showing me error ..
i mentioned in below image in red rectangle.. please help me..

here is the pic >>> code

Posted 15-Apr-12 6:23am

syed armaan hussain

Add a Solution

Comments

Nilesh Patil Kolhapur 16-Apr-12 1:21am

try 2 solution because this is done by using disconnected archetecture

5 solutions

Solution 1

C#

sqldatareader dr=new sqldatareader(cmd);
cmd.executereader();
datatable dt=new datatable();
dt.load(dr);
gridview1.datasource=dt;
gridview1.databind();

Posted 15-Apr-12 6:44am

Kuldeep B

Updated 15-Apr-12 17:21pm

v3

Comments

syed armaan hussain 15-Apr-12 13:53pm

thnx for ur reply
but when i used ur code i experienced these errors

Error 1---The type 'System.Data.SqlClient.SqlDataReader' has no constructors defined

Error 2--'System.Data.DataSet' does not contain a definition for 'fill' and no extension method 'fill' accepting a first argument of type 'System.Data.DataSet' could be found (are you missing a using directive or an assembly reference?)

syed armaan hussain 15-Apr-12 17:19pm

now my code is looking like this .. but am still facing the same error

SqlConnection con = new SqlConnection("Data Source=armaan-pc;Initial Catalog=ContactsDB;User ID=sa;Password=arman");
SqlCommand cmd = new SqlCommand("select * from contact;", con);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
dr.Read();
SqlDataAdapter da = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();

Solution 3

Try this:
If you receive the following error message There is already an open DataReader associated with this Command which must be closed first

and you are sure that all dataReader are closed the following workaround can help you.

The MARS default settings has changed at release RC1, so multiple Result Sets are off. To turn it on only add the following string to your Connection String.

SQL

MultipleActiveResultSets=True

Refer this link once

http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/thread/78d3989a-8975-4930-998d-1eb907966f57/[^]

Posted 15-Apr-12 19:25pm

sravani.v

Updated 15-Apr-12 19:42pm

v3

Solution 4

You are using SqlDataAdapter which is used in connectionless architecture so you don't need to write con.open(), try this I am sure it'll work
Happy coding :)

Posted 15-Apr-12 20:23pm

yogiCsharp

Solution 5

Nếu bạn muốn thì đây là câu trả lời

Posted 16-Apr-12 10:44am

phiasau_congtroi

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

pravallika tumuluri · Accepted Answer · 2012-04-15T19:10:00

SqlConnection con = new SqlConnection("Data Source=armaan-pc;Initial Catalog=ContactsDB;User ID=sa;Password=arman");
 SqlCommand cmd = new SqlCommand("select * from contact", con);
 con.Open(); 
SqlDataAdapter da = new SqlDataAdapter(cmd);
 DataSet ds = new DataSet(); 
da.Fill(ds); 
GridView1.DataSource = ds.Tables[0]; 
GridView1.DataBind();