| Binding DataTable vs. SqlDataReader vs. ArrayList (5 replies) |
| microsoft.public.dotnet.framework.adonet |
| Gentlepersons, I'm building n tier application and I hate the thought of using a DataSet/DataTable for most of my middle tier needs because it has so much I don't need. In binding tests of SqlDataReader VS DataTable, the reader performs much better as the client threads increase. But, I also noticed that it holds more open connections against SQL than the DataTable given the same load. This begs t... |
|
| OLEDB data reader not reading Extended ASCII values properly -Help (2 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| In our intranet website Login passwords are encrypted using a function in Login.asp and stored in Oracle database. When a user logs in his password information are retrieved from the oracle table with recordset object, then we encrypt the password entered by the user with same function and match both values, accordingly user may allow or deny login. Now we started working on a new project using AS... |
|
| DataAdapter.Update? (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I am getting the following error when calling the Adapters update method after i have done some deletions from my dataset through a datagrid. "Delete row information cannot be accessed through the row." Can anyone please tell me what i am doing wrong? Regards Darryn |
|
| ObjectSpaces (4 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hi All, Does anybody know whether the ObjectSpaces (an Object Relational Mapping tool) is included in the Beta 1 of VS 2005 which was recently released? if not when are they planning on releasing it (atleast a beta) ? Thanks, Chamith |
|
| recommended way to get id of just added record (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| 2 tables. The ID field in table1 is primary key in table1 and foriegn key in table2. In older MS access apps I used something like the following for handling the need to have the autonumber field automatically generated by Access to create the next set of records in a related table. With rst 'table one .AddNew .Fields("Name") UCase(Trim(Me.txtImageName)) .Fields("Sysprepped") Trim(Me.cboSysprepped... |
|
| Check SQL syntax (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello, I don't know if it is the right place for my question but I would like to know if ther's a way to validate a SQL request before sending it to the database. I was thinking abut using Regular Expresssion or something like that . Thanks for your answer. |
|
| Which Oracle Version? (7 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hi folks, I am writing an application that uses the Microsoft Oracle Client. I am aware that this provider requires the Oracle 8.1.7 client or newer to be installed on the users machine. I have searched for hours on the internet and Oracles site as to how to determine if the Oracle Client is installed and if so what version is installed programmatically with C# code. Is there someone out there tha... |
|
| Problems with Password Protected Access DB (5 replies) |
| microsoft.public.dotnet.framework.adonet |
| I can access a password protected mdb file just fine when I write a VB dotnet windows application. However using the same connection string and running in a VB dotnet web application I get an exception: "The Microsoft Jet database engine cannot open the file 'C:\Inetpub\wwwroot\fpdb\NewGoodGas.mdb'. It is already opened exclusively by another user, or you need permission to view its data." It is n... |
|
| Authenticating SQL Users from VB.NET Application. (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi there, I'm posting this message again cause my lat message was totally wrong. What I'm looking for is how do I authenticate SQL users from a VB.NET application using VB.NET language? I know there is a sp addlogin stored procedure in the master database, but do I call it from my application? Thanks very much, Manuel. |
|
| SqlConnection.ConnectionString: Data Source parameter (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| I used to te able to specify the port in my Data Source parameter like that: Data Source myIp,myPort but it does not work anymore! (I have somewhat the feeling I'm a victim of windows update) Any comments? How do you specify the port? Lloyd Dupont, Software Architect Get Your Data Mobile http://www.ihookdb.com |
|
| Ado.Net can't create Adapter ? (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I create a table in SQL 2000 with 100 columns, want to use SqlAdapter or OleDbAdapter access it, but I can't create Insert,Delete,Update command, why? How to do it? thanks! create table kjcg ( itemid numeric identity, item cglb nvarchar(1) not null, item 32 nchar(1) not null, item 140 nchar(1) not null, item 110 nchar(1) not null, item 64 nvarchar(3) not null, item 304 nchar(1) not null, item 47 n... |
|
| Parameters vs. Dynamic SQL (3 replies) |
| microsoft.public.dotnet.framework.adonet |
| Ok I know the pro's and con's of this subject http://www.knowdotnet.com/articles/dynamisql.html I'm trying to convert my colleagues, but they are stuck on one thing with dynamic sql, when they have a problem it is much easier to get the exact view of the sql statement with the values they've loaded onto it when they debug. So if they see an error they can cut/paste the entire string to query analy... |
|
| ¿Se puede ejecutar scripts con C# al igual que podía con VBScript? (5 replies) |
| microsoft.public.dotnet.framework.adonet |
| Se puede ejecutar scripts con C# al igual que podía con VBScript? Con VBScript escribo codigo en un archivo .vbs o .vbe y lo ejecuto, como puedo hacer esto con C#, pues hago un .cs pero no se como ejecutarlo? Otra consulta: con Sqlserver 2000, puedo ejecutar trabajos con ActiveX, con VBScript y Javascript, puedo hacer lo mismo con C#, es decir ejecutar scripts hechos en C#, con trabajos de Sqlserv... |
|
| dataGrid detail view refresh (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I click the " " sign on my datagrid to display a detail view. I then edit the detail table by code and call AcceptChanges(), the datagrid would automatically collasp and go back to the master view. How do I stop the detail view on a datagrid from going back to the master view? Thanks david |
|
| OLAP (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I want to migrate my COM application to .NET. In my application I'm using ADOMD. Are there new .NET classes for the old ADOMD classes? Best regards, Thorsten |
|
| Need help with Parent/Child table update (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| Sorry if this has been addressed before, but I can't find a good reference for what I'm trying to do. I'm trying to figure out the "best" way to design and code a windows app. that allows a user to enter data that will be stored in two related tables in an Access 2000 database. (ya ya, I know, use SQL Server...can't right now). I've got a grid bound to a typed Data Set. The DS contains two tables ... |
|
| Newbie: Light-weight database for a C# client app? MSDE? (9 replies) |
| microsoft.public.dotnet.framework.adonet |
| Do all database solutions require a database server to be installed on the client? My goal is to reduce installer complications and bloat and an evolution path to a smart client version where the database is located on a centralized Internet server. The options in "The MSDE Deployment Toolkit (RC) in Action" sound like they are going to complicate my install and result in more tech support calls. ... |
|
| Where's my Oracle namespace? (2 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Using VS 2005 Beta1, C#. If I type: using system.data. There's no Oracle namespace in the completion list. Does it come with VS or does it have to be installed with the Oracle client (using 10G)? Thanks Arnie |
|
| Dataset and typed datasets (4 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, is there a way to cast a normal dataset to a typed dataset? I tried using the directcast but that didn't seem to work. Thx |
|
| Page Counter... (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hi, I am developing C#.net web base application. I want to know how I can page count a same page. I want to this type. 1) When a new user open page he/she see the number of pages open same time and total how many time this page open. Suppose 10 user open search.aspx every user see this page count 10; And also see total open 12,000 (it is total time's opened this page) 2) If user refers page page c... |
|
| MS Oracle Client - OCI throws "Specified module could not be found (3 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| Hi, We are trying to connect oracle 9i database through windows services application using ADO.NET [MS Oracle Client]. When the service tries to connect oracle 9i database, OCI.DLL throws an exception as "The specified module could not be found". The same code is working good when we run as a windows application or web application. The issue is only when we call the same code from windows services... |
|
| Using parameters with LIKE comparison (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello I have trayed to create SQLCommand with sql query: SELECT * FROM [table] WHERE [field] LIKE @Param If I'm using symbols '%' in @Param value it doesn't gives any results. However sybols ' ' are working fine. How I can make this query work with symbols '%' ? |
|
| db2 connection problem (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| I am having a problem when trying to add a DB2 data connection using the IBM DB2 provider for a backend AS400 system. On the "Add DB2 DataConnection" window, I'm entering the following: I'm entering the IP address of the server I just put in any alias name I put the "UserName" and "Password" in I put the default schema in I get the following error: Test connection failed: 0: Error occurred: [IBM] ... |
|
| Oracle ADO Provider and infomessage (2 replies, VIP) |
| microsoft.public.dotnet.framework.adonet |
| I'm trying to catch the ora 28002 message, informing the user that is password will expire in 'X' days, but on openning the connection nothing happens, the corresponding handler (Oracleinfomessageeventhandler) is never called. Is it a problem with my code, the framework or the data provider ? The same problem exist in the Microsoft Oracle data provider(system.data.oracleclient) or the Oracle provi... |
|
| Simple 'NULL' / Databiding prob got me stumped.. (2 replies) |
| microsoft.public.dotnet.framework.adonet |
| Ok, I'm new at this and learning as I go, but under extreme pressure from work.. So many bugs and little tricky obsticals have got me very far behind, and this is the latest.. I made a simple databinding form, but not using the wizard, because it doesn't use the SQL driver. I'm keeping it simple right now with a very normal table with a primary key 'SIN' (social insurance number). Well I'm followi... |
|
