Gridview data source problem with ado in asp.net

Question

1.00/5 (1 vote)

See more:

I added reference Microsoft ActiveX Data Objects 6.1 Library and add GridView1 control and one button1 in my asp.net page. In button i put below code.

Dim res As New ADODB.Recordset
      res.Open("Select * from Table1", con, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic)

      GridView1.DataSource = res.Fields()
      GridView1.DataBind()

When i click on button1, it gives this error "The data source for GridView with id 'GridView1' did not have any properties or attributes from which to generate columns. Ensure that your data source has content".

I want to show res records into GridView without using any loop like i want like this

dbconn = New OleDbConnection("Provider=SQLOLEDB.1;Persist Security Info=False;User ID=rizwan;Password=censored;Initial Catalog=chattha;Data Source=chattha.mssql.somee.com,1433")
        dbconn.Open()
        sql = "SELECT * FROM Users"
        dbcomm = New OleDbCommand(sql, dbconn)
        dbread = dbcomm.ExecuteReader()
        Table1.DataSource = dbread
        Table1.DataBind()
        dbread.Close()
        dbconn.Close()

In above code data transfered from dbread to Table1 without using any loop. Is there any way to do like this in case of GridView usin ado.

Posted 16-Jul-15 2:20am

Robot Sun

Updated 16-Jul-15 2:22am

v2

Add a Solution

1 solution

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)

F-ES Sitecore · Accepted Answer · 2015-07-16T02:34:00

Solution 1

Google "bind grid view ado.net" and you'll find thousands of examples. The ADO project you have referenced shouldn't be used (the ADODB namespace), that is technology well over a decade old. Instead use the likes of System.Data.SqlClient.SqlConnection etc. as found in Systen.Data.dll

Posted 16-Jul-15 2:34am

F-ES Sitecore

Comments

[no name] 16-Jul-15 8:43am

I am googling from many hours, there are many examples and other ways to do this task but i want to do this according to my mentioned way. I know this is too old but i still like it and using it every where. If you can do please solve it.

F-ES Sitecore 16-Jul-15 8:50am

You mean you *want* to use ADODB? Just learn ado.net, it's not that hard. .net components like the grid view uses .net interfaces like IEnumerable etc that ADODB components don't support as they are just .net wrappers around COM objects.

[no name] 16-Jul-15 8:55am

I know data adapter, data sets and data fill techniques but i don,t know why i still like adodb. May be this is due to too much practice in adodb. Is there any technology which is modern but like adodb?

F-ES Sitecore 16-Jul-15 9:06am

Yes, ado.net. What you are using is "ADO", not "ADO.net" - ADO is the COM version and ADO.net the .net version.

[no name] 16-Jul-15 9:15am

You wrote above this "System.Data.SqlClient.SqlConnection". Does this ado.net or only ado.

F-ES Sitecore 16-Jul-15 9:22am

Anything in System.Data is ado.net, anything in ADODB is ado.

[no name] 16-Jul-15 9:39am

It means there is no way to bind data with gridview usin adodb.

F-ES Sitecore 16-Jul-15 9:48am

Probably not, no. You'd need to loop through your recordset a row at a time, creating a .net custom class from each row, add that object to a List and then bind the grid to the List.

Seriously, just learn ado.net, I don't understand your reluctance.

[no name] 16-Jul-15 10:01am

I wrote this code also but it also giving error
<pre>
res.Open("Select * from Table1", con, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic)
res.MoveFirst()
Dim arr(res.Fields.Count) As String
For i = 1 To res.Fields.Count
arr(i) = res.Fields("Name").Value
res.MoveNext()
Next
GridView1.DataSource = arr
GridView1.DataBind()
</pre>

Actually i never practiced in ado.net. First time i understood ado.net only and after that i did not practice it again. I always used ado because it is on my finger tips. I used always listview with ado. I shall try to adopt ado.net.

[no name] 16-Jul-15 10:11am

usin arraylist it is possible to bind data with GridView. I wrote this code and it is working but i don,t know why single dimension array is not binding with GridView.

Dim ItemList As New ArrayList()
For i = 1 To res.Fields.Count
ItemList.Add(res.Fields("Name").Value)
res.MoveNext()
Next
GridView1.DataSource = ItemList
GridView1.DataBind()

[no name] 17-Jul-15 2:04am

Below code works in windows form but it is not working in web form how to do it in web form

string source = "Server = CHATTHA; Database = Test; User Id = sa; Password = pak123";
SqlConnection con = new SqlConnection(source);
con.Open();
SqlDataAdapter da = new SqlDataAdapter("Select * from Table1", con);
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;

[no name] 17-Jul-15 3:29am

Problem solved. I used this one and above code is working using system.data and using system.data.sqlclient