| Thread | Last Post | Replies |
|
| WinForms connect to Hosted Database? | 26 Feb 2005 09:17 GMT | 2 |
I initially posted this on the WindowsForms group, but perhaps it's more appropriate in the ADO.NET group. Is it possible to using connect to a SQL Server database on a shared hosted web account using sqlconnection objects?
|
| DataTable.Select method bug in .Net Framework 1.1 SP1 and in KB891 | 26 Feb 2005 05:29 GMT | 1 |
There is a bug in .Net Framework 1.1 SP1 with the DataTable.Select method. Microsoft's description of the problem may be found here http://support.microsoft.com/default.aspx?scid=kb;en-us;891742 and you can ask for a fix to that issue. The problem is that the fix does
|
| SQL Server Data Access - Conversion to Unicode? | 26 Feb 2005 00:31 GMT | 3 |
If we have a SQL Server 2000 database that does not use unicode data types (nchar, nvarchar, ntext), but is instead uses character data types (char, varchar, text) does ADO.NET go through some conversion process when it, for example, retrieves these values to store in a .NET ...
|
| DataRow in ViewState | 25 Feb 2005 20:41 GMT | 2 |
When I try to put a DataRow object into ViewState, I get the following error: The type 'System.Data.DataRow' must be marked as Serializable or have a TypeConverter other than ReferenceConverter to be put in viewstate. Right now I have to create a new DataTable object with excepted ...
|
| Subject:Writing a db independent data access layer with DAAB:How? | 25 Feb 2005 20:34 GMT | 3 |
I ran into this Microsoft Patterns & Practices Enterprise Library while i was researching how i can write a database independent data access layer. In my company we already use Data Access Application Block (DAAB) in our .Net projects. We use SqlHelper in SQL based projects, and ...
|
| Maximum data size or rows | 25 Feb 2005 20:15 GMT | 2 |
Is there a maximum data size(MB) an Access table is supposed to hold? Or a maximum number or rows? concerned jj
|
| serializing dataset | 25 Feb 2005 18:33 GMT | 2 |
In my custom control, i am providing serialization / deserialization of dataset and noticed that, when a dataset table is empty, it will not be serialized. (no xml is generated for empty tables using ds.GetXml or ds.WriteXml)
|
| unicode parameter with contains() clause in OracleClient | 25 Feb 2005 18:15 GMT | 2 |
We are trying to provide keyword searching with the Oracle Text engine using the 'contains' predicate. However, it does not work when using NVarChar or DBType.String parameters like so: IDbConnection conn = database.CreateConnection();
|
| Cannot do update on a record. Please help. | 25 Feb 2005 18:03 GMT | 3 |
I am VERY NEW this whole concept of DataSet and all. I have a code that goes like this.. ============================================= conn.Open()
|
| Creating a master-details relationship between 3 tables | 25 Feb 2005 17:54 GMT | 4 |
I'm new at vb .net and I have an issue that must be a common one, but I haven't found an example of it yet. I want to create parent-child relationships for 3 tables (grandparent-parent-child?). I'm trying to create a contact management
|
| Retrieving procedure parameter information is not supported | 25 Feb 2005 17:05 GMT | 1 |
I get an error when I use OleDbCommandBuilder.DeriveParameters to retrieve procedure parameter information. The error is " Retrieving procedure parameter information is not supported by the 'Microsoft.Jet.OLEDB.4.0' provider". Below is the query in MSAccess:
|
| ERROR IN ORACLE CONNECTION | 25 Feb 2005 16:32 GMT | 1 |
I HAVE CREATED ODBC CONNECTION FOR ORACLE.But when i use the connection in vb.net i get the following error error:ORA-12154 :TNS:could not resolve servicename Posted Via Usenet.com Premium Usenet Newsgroup Services
|
| Executing stored procedures as CommandType=Text | 25 Feb 2005 15:51 GMT | 4 |
I've got an urgent problem - I'm converting a legacy VB app to .NET. I've got thousands of pre-saved strings such as "exec sp_name 'p1', 'p2', 'p3'" that execute on a VB 6 application and ADO. These now need to execute on C# and ADO.NET.
|
| ExecuteNonQuery() says I have bad SQL | 25 Feb 2005 15:37 GMT | 5 |
Here is the SQL statement that I'm trying to execute INSERT INTO Tbl_NameCharacter(Character, Code) VALUES('Rebel Generic', 'Rbl') My database has a table name 'Tbl_NameCharacter'
|
| How to retrieve the returned function value? | 25 Feb 2005 14:57 GMT | 3 |
Hi, friends, I need to call a function of SQL Server 2000. I tried to use DataSet.SelectCommand by passing a stored procedure command, and then fill the dataset. This works fine with store procedures that return record sets.
|