asp.net grid view data binding

Question

0.00/5 (No votes)

See more:

guys i have this code in the page load event

VB

SqlDataSource2.SelectCommand = "SELECT EMPNO,EMPNAME FROM EMPLOYEE"
                SqlDataSource2.DataBind()
                GRD1.DataBind()

i cant see the grid on the page no data retrieves
but when i execute sql in sqlserver i have 4 rows what is the point

Posted 30-Nov-11 23:11pm

ahmad7_8

Add a Solution

Comments

sriman.ch 1-Dec-11 5:16am

Where you are assigning datasource to gridview?

5 solutions

Solution 3

VB

GRD1.DataSource = SqlDataSource2
              GRD1.DataBind()

Posted 30-Nov-11 23:29pm

Abhi KA

Comments

ahmad7_8 4-Dec-11 3:39am

i try all solution above but there is strange thing i don't what to do
my SqlDataSource2 is build by wizard ok

Solution 1

have a look at :
http://www.devexpress.com/Support/Center/p/Q290537.aspx[^]

OR
try in the following way :

C#

string strConn = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
            string strProvider = ConfigurationManager.ConnectionStrings["ConnectionString"].ProviderName;
            
SqlDataSource ds = new SqlDataSource(strProvider, strConn);
            ds.SelectCommand = "SELECT * FROM rammekategori";

Then i bind the SqlDataSource to a GridView:

C#

GridView1.DataSource = ds;
           GridView1.DataBind();

Posted 30-Nov-11 23:19pm

member60

Comments

ahmad7_8 4-Dec-11 3:39am

i try all solution above but there is strange thing i don't what to do
my SqlDataSource2 is build by wizard ok

Ajay238 3-Dec-13 12:03pm

It saying Connection string has not been initialializedddd!!!>>>??? where to open the connection and close??

Solution 4

i try all solution above but there is strange thing i don't what to do
my SqlDataSource2 is build by wizard ok

Posted 1-Dec-11 0:35am

ahmad7_8

Comments

RaviRanjanKr 1-Dec-11 14:24pm

A suggestion :- its not a good practice to post your feedback or comment as an answer. you can use have a question or Comment.

Solution 5

USE SqlCommand object to run the query. that will be a good approach and fill dataset using SqlDataAdapter. and set dataSource to dataset object and bind funcion of grid.

Posted 4-Dec-11 0:51am

Sarvesh Kumar Gupta

Updated 4-Dec-11 0:53am

v2

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)

shek124 · Accepted Answer · 2011-11-30T23:27:00

Solution 2

SQL

SqlDataSource2.SelectCommand = "SELECT EMPNO,EMPNAME FROM EMPLOYEE"
                SqlDataSource2.DataBind()
                GRD1.DataSource = SqlDataSource2
                GRD1.DataBind()

Posted 30-Nov-11 23:27pm

shek124

Comments

[no name] 1-Dec-11 21:09pm

my 5.

ahmad7_8 4-Dec-11 3:39am

i try all solution above but there is strange thing i don't what to do
my SqlDataSource2 is build by wizard ok