How to refer to a text in an Ms Access table?

Posted by manuel on Stack Overflow See other posts from Stack Overflow or by manuel
Published on 2010-04-19T04:21:07Z Indexed on 2010/04/19 4:23 UTC
Read the original article Hit count: 213

Filed under:

oledb

|

vb.net

|

ms-access

I want to refer to a data cell, which if it is equals to some string, it will do something. The codes:

If ds.Tables(0).Rows(i)("Status") = "Reserved" Then
MessageBox.Show("Can't reserve")
End If

Is this the correct way to do this? Because I failed doing so..

© Stack Overflow or respective owner

Related posts about oledb

Running OLEDB VB6 Windows Progam Under Wine

as seen on Super User - Search for 'Super User'
I'm trying to install a VB6 Windows program that uses OLEDB to access VFP tables to run under Wine 1.0.1 on Ubuntu 9.10. Wine is configured to Windows version Windows XP. The program install ran okay, and I used winetricks to install MDAC 2.8 and JET 4.0 sp7. I also installed Microsoft's vfpoledb… >>> More
Using OLEDB parameters in .NET when connecting to an AS400/DB2

as seen on Stack Overflow - Search for 'Stack Overflow'
I have been pulling my hair out trying to figure out what I can't get parameters to work in my query. I have the code written in VB.NET trying to do a query to an AS/400. I have IBM Access for Windows installed and I am able to get queries to work, just not with parameters. Any time I include a parameter… >>> More
How to determine MS Access field size via OleDb

as seen on Stack Overflow - Search for 'Stack Overflow'
The existing application is in C#. During startup the application calls a virtual method to make changes to the database (for example a new revision may need to calculate a new field or something). An open OleDb connection is passed into the method. I need to change a field width. The ALTER TABLE… >>> More
OleDb database to DataSet and back in c#?

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm writing a program that lets a user: Connect to an (arbitrary) View all of the tables in that database in separate DataGridViews Edit them in the program, generate random data, and see the results Choose to commit those changes or revert So I discovered the DataSet class, which looks like it's… >>> More
Exception:Cannot Start your application.The Workgroup information file is missing or opened exclusiv

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
We were getting this error when trying to connect to a password protected access file. This is what the connection string looked likestring conString =@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="Path to your access file";User Id=;Password=password";To fix the issue this is what… >>> More

Related posts about vb.net

VB.NET How Do I skin a vb.net app

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to skin a vb.net app I made ive googled some stuff and I've seen skinned vb.net apps. However it seems like any time i try to find someone explaining it its a link to a pay for product. Does anyone have anything useful on this? >>> More
VB.NET IF() Coalesce and “Expression Expected” Error

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
I am trying to use the equivalent of the C# “??” operator in some VB.NET code that I am working in. This StackOverflow article for “Is there a VB.NET equivalent for C#'s ?? operator?” explains the VB.NET IF() statement syntax which is exactly what I am looking for... and I thought I was going to… >>> More
Would a programmer knowing C# and VB.Net ever choose VB.Net?

as seen on Programmers - Search for 'Programmers'
Now before someone tells me VB.Net isn't bad like VB was, I know it isn't. But, I've yet to speak to a programmer who is completely content that some project they work on is written in VB.Net. Basically, my question is would a programmer knowing both C# and VB.Net (and all of their team knowing both)… >>> More
Do I lose anything by coding in c# and using free online vb.net code convertors?

as seen on Programmers - Search for 'Programmers'
The company I work for uses vb.net since there are many programmers who moved up from vb6 to vb.net. Basically more vb.net resources in the company for support/maintenance vs c#. I am a c# coder and was wondering if I could just continue coding in c# and just use the many online free c# to vb.net… >>> More
What are some good/reputable/widely-used libraries written in VB.NET?

as seen on Stack Overflow - Search for 'Stack Overflow'
Generally speaking, when VB.NET and C# are compared, there is a lot of strong support for C#, accompanied by some bashing of VB.NET until a respected developer comes along and acts as The Voice Of Reason, pointing out that while VB prior to VB.NET had its fair share of issues, VB.NET is really a very… >>> More