How to use data controls to display data in data bound controls?

[yma]

Hello,

I tried to display a column in MS Access 2000 nwind.mdb using 3 data
controls. But I got "It is
already opened exclusively by another user, or you need permission to view
its data." I put ole DataAdapter, Connection and dataset controls and fill
in the properties of the listbox. The only code I have is
OleDbDataAdapter1.Fill(DataSet11, "employees") in page_load sub.


Then I tried to use my local sql server 2000. SqlDataAdapter1.fill() caused
an unhandled system error. Could you show me how to use data controls to
display data in data bound controls, such as listview control?

By the way, I can write code to display a column in MS Access 2000 nwind.mdb
without using 3 data controls.

I used samples from Mastering Visual Basic.net from SYBEX. They do not work
either. If you know samples from some web site, please give me the links.

Thank you.

Chris

 

[Cor]

Hi Yma,

Right above this line in the newsgroup I did give this link.

http://msdn.microsoft.com/vbasic/vbrkit/default.aspx

They are very good to learn all.

Cor

 

[Cor]

Hi YMA

Is this about a windowform or a webform project?

Cor

 

[yma]

Hi, Window form works. I still cannot display data on the listbox in a web
form.

 

[Cor]

Hi YMA,

I thought I did send you a message, but I it seems it disapeared.

It was something as this,

Open a webproject
Drag a textbox, a label and a button to your webpage.

Open your code
In the load event replace the comment string with
\\
if not ispostback then
me.textbox1.text = "I am here"
end if
///
Go back to your form and push on the button, till the code opens again.
Place there in that button click event
\\\
me.label1.text = me.textbox1.text
///
Start debug.
Type in the textbox, "I was here" and push the button.
If all went well than the text will shown up in the label.

I hope this helps?

Cor

 

[Cor]

Hi Yma,

I saw I wrote it wrong, I did not send you a message, it was to this
newsgroup.

Cor