When working with the SQL CLR, should I be using "using" when referring to
the "context connection"?

I have a static function in a class, everytime I call this function, I am
creating a SQLconnection, open it, use it, and null it, All my functions and
application logic is like this,
Every connection is creating self connection object and null it after the

I have a book called "Hitchhiker's Guide to Visual Studio and SQL
Server".  It has a chapter on using dataAdapters, and another chapter
on using tableAdapters.  The problem is, they seem to overlap in what
they can do, and I don't know when I would use one and when I would

I'm a novice in .Net development (switched after 10 years Delphi).
I've created a small test app with a Dataset in it.
The Dataset contains a TableAdapter.
In my Form i'm using a grid that uses that named dataset to display an

I'm new to SQL stuff. All I have is MS SQL Express that came with Visual
Studio 2005, and SQL Server Management Studio Express, which I downloaded
and installed.
I've created a new table, and I have a comma-delimited text file of data I

How do you consume the result of a SQLCLR stored procedure when it returns a
SQLDataRow?
Thanks.

is it possible to extract the DataColumn which is a foreign key of another
table.
foreach (DataRelation dr in dsIlce.Tables[0].ParentRelations) {
Console.WriteLine("123");

I'd like to know exactly how an UpdateCommand determines that there are
concurency issues, specifically if I have supplied I created my own update
command, instead of using the SqlCommandBuilder.
The issue I am facing is I have setup a column in my DataTable to map to an

When I build a DataSet with the DataSet Designer (DataSet.xsd) every
DataTable has the property "Locale" which is set (I guess) to the current
collate of the table of the SQL Server (I'm using MSSQL). I want to build a
web application which is language neutral or translated in ...

I need to start a new win form project and I am wondering if I should choose
2008 at this stage. My questions are following;
1. Is 2008 much different from vs 2005 in terms of skill set to prohibit
smooth development of application ie is there a steep learning curve for

To run an example from ADOnet 2.0 SBS 2005 edition, I opened a web site from
File System (Microsoft Press folder).   I can review the Design and Source
tabs; however, running an example program, e.g. Chap 14-Finished, showed the
following error:

How could I get a column size from a datareader or a datatable?  We're
moving from VB6 where the code looks like this:  rcs.Fields(i).Size (rcs is
a recordset).
Thank for your help

I want to bind a proeprty of a child object to a DataGridView, but it
doesn't work.
For instance:
Imagen that I have an object Company, and this object company has a child

I have a databound gridview.
How do I skip a row if a certain condition exists?  (In VB.NET)
For example...
   Protected Sub GridView2_RowDataBound(ByVal sender As Object, ByVal e As

I've read various articles/blogs/posts about adding transactions to
TableAdapters, mainly from Sahil Malik. I'm certainly not an expert in
ADO.NET but I understand what transactions, commands and connections are.
Sadly I've been unable to get the examples I found to work.