Dear all. I'm wondering why it's so hard to bind a lookup value from
a
related table into a textbox on my form.
Say I've got two tables, product and productcategory. I'm paging

I m a newbie to VB.NET. So, i have problem in doing some tasks like
Master/Detail working with DATAGRID VIEW object along with BindNavigator.
How can i implement Master / Detail that work with the BindingNavigator?
Your advice will be highly appreciated.

We are working on a project where we are converting our client server
application to a n-tier model to make it more scalable. The question I
have here for the group is to see if I can get some ideas on how the
security should be implemented for this kind of architecture.

Hi! I have a couple of questions about TransactionScope...
What exactly is the scope of a transaction? Is it only connections that are
created in the actual code block where the TransactionScope is defined, or
is it all connections created on the same thread as the ...

I am working through the manual for course 2524 (Developing XML web services
using ASP.NET). It is at least 4 years old so hopeless outdated (:-) but I
think I can salvage it to still be useful. I actually tried this with just
the express editions of visual web developer, C#, and ...

I'm using VBExpress and SQL Server 2000 which means that I can't use the
wizards/database explorer to do this stuff.  It has to be done in code.
I've figured out how to connect to the database and execute a query, but so
for I've Only been able to put the results into a messagebox ...

My .NET application writes to an Access 2003 db through OleDb.  I'm
using a stored query in Access to insert a new row. The app's C# code
sample includes:
myCommand.CommandType = CommandType.StoreQuery;

I've written a small app which has 2 buttons.
The 1st button goes away to a directory full of SQL Scripts, and then
runs them against the database.
The 2nd button has code to do some modifications to the database,

I'm converting over a ADO.NET provider I wrote in 1.1 .NET to 2.0.  I don't
understand why the DbCommand.ExecuteReader methods (it's overloaded) is not
virtual or abstract.  This method would most likely need to be modified by
any class inheriting DbCommand.  On the other hand, ...

Can somebody explain to me in plain language what is the meaning of
each value in the LoadOption enumeration?
Or some clear articles about DataTable.Load and DataRowVersion.
Thanks,

Which was updated by the sql UPDATE instruction.
Is there some objects returning the number
or I have to do explicit SELECT nevertheless?
Thanks in advance.

I've a standard DataTable, is there a way to get an array of value like that
one I obtain in SQL Server suppying the SELECT DISTINCT [field] statement?
Have I to loop trough the datatable to build the array or is there a simpler
way?

I'm fairly new to ASP.NET/ADO.NET and SQL. I worked out a few issues with
the help of some nice folks here.
Now, I'm starting a clean Web site project but am having trouble right off
again.

I don't think there is a way. There seems to be a black hole of info
about this unless you are using the older ADO technology.
If you know, please share...!
Dennis

I have a DataSet with two tables in it, with a relation between them.
I fill the tables with records programmatically with these commands:
System.Data.DataRow newRow = myTable.NewRow();
//give values to each column in the row