Hi , " Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. " I am getting this error in my application. All requests to the Database go through the Data A...more >>

I found the following code on microsoft.support.com which is supposed to with of a column '---------------------------------------------- Dim ts As New DataGridTableStyle( ts.MappingName = "tbl_Client DataGrid1.TableStyles.Clear( DataGrid1.TableStyles.Add(ts DataGrid1.TableStyles("tbl_Client"...more >>

This has been addressed several times and I've read several articles and posts and I still can't get this to work. (This is VB .NET) My understanding is that if I append a select statement to my DataAdapter's Insert statement that I should be able to get an updated resultset. I've got this: ...more >>

Hi! I'm using ODBC to connect to an Oracle database. I want to do something like the following: --------- var conn: OdbcConnection = new OdbcConnection("my connect string here"); var sql: String = "update mytable set col1=?, col2=? where keycol=?"; var command: OdbcCommand = new OdbcCo...more >>

Hi, I have a question regarding PRINT statement in transact-SQL. The following is my test environment * Vuisual Studion 2003, server explorer * either in SQL pane or using stored procedur The scenerio are like belo * alter procedure myProcedure as PRINT 'HELLO' <===== I...more >>

Hi, I have a datatable with 2 keys columns, i need get this datatable with agregate totals. How can i do that? datatable Key1 Key2 Total 1 1 100 1 1 200 1 2 50 1 2...more >>

Dear all I have written a windows service that connects to an Oracle 9 database on start up. I use a DataTable to hold a set of near static data. Recently there have been some overnight external batch updates to this table and my DataTable needs to be refreshed. Since this change of circumst...more >>

Hi! I have this problem... In Visual Basic I am work with ADODB and the next code work perfectly... Dim cmd as New ADODB.Command cmd.Properties(15).Value = 2 .... But in .NET.. OleDbCommand cmd = new OleDbCommand(); cmd.Parameters.add("15",2); .... this code throws an error: "An u...more >>

hello, In my asp.net projects I like to seperate the database connection and lookups/executes from the code-behind pages using shared functions. I find myself often using a function that returns a datatable given a sql query and it works great. The function is contained in my 'dataaccess' ...more >>

I'm loading a key values into a database and two may be identical except for maybe 1 or 2 trailing spaces. This causes a unique constraint error because for some reason it's trimming the string values when checking the unique contstraint I can clearly see in the dataset the string has spaces on...more >>

Hi all, I need a SQL stored procedure that has an input parameter of type array of datetimes. How to define such a procedure? if possible Thanks, ...more >>

I have a dataset loaded with an xml that looks like this: <associations xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <association> <associationid>{8a3aca06-a7de-41a5-b584-063e7cf391bb}</associationid> <createdon>2004-02-17T12:05:40.3430000-05:00</createdon> <modifiedon>2004-02-17T12...more >>

Hi, I am attempting to updata a SQL Server record using the stored procedure's UpdateCommand. Everything works fine if all fields are full, but if a user clears out a textBox that originally contained a number in it, then the update bombs out. The field in the table is setup to accept nulls. W...more >>

Hi, We have an Asp.Net applcation with Sql Server as back end. I have a base class function that takes a SqlCommand Object as a parameter and returns a datatable. I want to set the Isolation to "Read Uncommited" (Sql Server's default Isolation Level is "Read Commited") as I am just selec...more >>

Hi I bind a textbox to a field in the database through CurrencyManager. Everything works find exept one thing: I cannot type Null, blank, nothing in the textfield. The property in the database allows NULL but I cannot type blank in the textbox. Whatever I type that isn't numeric is changed then I ...more >>

Hello, I am having a problem with ADODB connection class. This was all working fine until I restarted the pc with last known good configuration, which seems to have screwed things up In the code below the conn.open command fails with a "cannot find stored procedure error". and system.runti...more >>

Hi al I have PK with Guid type in typed dataset Is anybody have any suggestion how 2 implement autogeneration of P thnks...more >>

Couldn't understand why following line of code is failing <%@ Import namespace="System.Data.OracleClient" % I am getting following error BC30466: Namespace or type 'OracleClient' for the Imports 'System.Data.OracleClient' cannot be foun Although I can see the System.Data.OracleClient in Ref...more >>

I'm using vs.net, clr 1.1, c# web application. I get the following error connecting to foxpro using its oledb driver. I've tried several ways to connect. No error information available: REGDB_E_CLASSNOTREG(0x80040154). [OleDbException (0x80040154): No error information available: REGDB_E_C...more >>

Hi there! I am using MSDE 2000 SP3, Sql.Net provider on Win2k server. When I try to execute very simple query of inserting/selecting a row into a table, I am getting following error, "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not resp...more >>

Hi All I'm experiencing the problem of dataset.getchanges returning unmodified rows only : myDs.ReadXml("c:\Parsley.xml", xmlReadMode.Auto) For Each t In myDs.Tables For Each r In t.Rows If r.Item("Deleted").ToString = "True" Then r.Delete() Exit For End If Ne...more >>