Is there a way to check which version of SQL Server is running using
the SQLClient Managed Provider in dot_net 1.1?
TIA,
Joel

We are developing an asp.net web application. When we drag and drop the sql
connection object to the form we set the in the dynamic properties connection
string to use the connection string in the web.config file.  Works Great
except everytime we need drag and drop a new data ...

I don't understand this error. This form was working, and I decided I wanted
to put a datagrid to show child records of contacts at companies. But I
can't get the dgrid to work. THEN my sql string began having this weird
invalidcast problem. I am NOT trying to cast, and the datatype ...

This is my code
Public Function UpdateData(ByVal MyDataSet As DataSet) As Boolean
Dim ODBC_Adapter As OdbcDataAdapter
ODBC_Adapter = New OdbcDataAdapter(Me.ODBC_SelectCommand, ODBC_Connection)

i have an aspx form in wich i have a textbox.
i have a validation function on this textbox in wich i want to set the focus
back to this text box if validation returned false
the syntax is :

is it possible to insert a expression column into DataTable.Columns? I do
not want to add to the end of the position of the DataTable.Columns.
Any advise will be appreciated.
Jimmy

and Close() it too?
Thanks

I'm using a SqlDataReader to return results from a stored procedure where I
cursor through rows to flatten out my data.  For example, instead of
returning all Customers and then all Orders, I return a consolidated result
set, with columns named like this:

index was outside the bounds of the array 2003
I added two tables to my access database.  When I try to add them to
datasources through configure dataset with wizard, I get the error
index was outside the bounds of the array

I have and application that I would like to reset the IDENTITY VALUE. Is
there a way to change it in C# .NET?  My application uses SQL Server 2000.
Thanks in Advance.

I have been having problems updating rows with my VB 2003. New rows save
fine. Updates have consistently given me system.data errors no matter
whether I use stored procs or TSQL.
An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred

Hi, I've tried the SQL Server newsgroups and it seems nobody did it there, I
got no replies, or those that did it don't want to tell.
I have VS2005 Beta 2 installed with VS2003 and everything works good enough
with an occasional Beta hick-up but nothing serious.

I am in the middle of a large (many forms, many tables) database
project - my first using C# and ADO.NET.
As I code up each form, I find myself bouncing around considerably
between instantiating data objects and data bindings entirely in code

I suppose I could simply use a SQL command with a data adapter to add a new
column to a database table.
Where can I find an example of how to do this?
Regards

I am a newbie in ADO.NET. I use MYSQL in combination with ASP.NET VB. To
make it more perfect I like to do a SQL Update command with variables.
Please help. I found a lot of samples, most of them returning no errors at
all. But the record isn´t changed.