Bypass ADO

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Ado
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Using Widows Authentication and accesssing SQL with SQL Authentication Hi I am working on an application with .NET 2005 and SQL server 2000. I am using windows authentication for my web application authentication and trying to connect to the SQL server with SQL authentication credentials. My web.config reads as follows: web application Authentication: <authentication mode="Windows" /> <authorization> <allow users="*" />   </authorization> <identity impersonate="true" /> SQL Authentication: <connectionStrings> <add name="DevDBConnection" connectionString="Server=MyServer;database=MyDB;uid=MyUser;pwd=MyPwd;" providerName="System.Data.SqlClient" /> </connectionStrings> MY IIS directory security is set to "Integrated Windows authentication". I am validating the user againt the Active Directory for authentication and reading the user details and groups which works fine. But trying to open a connection object fails. I am getting a "{"Cannot open database requested in login 'MyDB'. Login fails.\r\nLogin failed for user 'MyUser'."}" I have tried searching for a solution to my best, but could not solve this problem. I hope some one might have come accross the same problem ahd looking forward for your help. Thanks, Valar Tag: Bypass ADO Tag: 125676
  - 2
    - tranferring data from Access to SQL Server Express I created a VB.Net 1.1 application that iterates through all the tables in any basic Access 2000 database passed to it and generates the same table structure in a SQL Server Express database. The structure is created fine (with minor data conversions from one to the other, e.g. yes/no --> bit, memo --> text, etc). My problem now is transferring the data over from Access to SQL Server. I thought it would be a fairly straight forward process, but I don't think I thought it through that well, unless I am missing something. I currently have the code retrieving a DataTable object from Access one at a time. The only way I can think of now to get the data into SQL Server is to create a DataAdapter for each table in SQL Server and create an InsertCommand for each of adapters. This will involve iterating through all the columns of each table, determing their data types and length, and then adding the parameters. Is this what I have to do, or is there a shorter method? Perhaps dump the Access table to a file and then use bulk import utility (bcp) for example??? Hmmm... Thanks for any help, Marcus *** Please respond to this group. I do not check this email address *** Tag: Bypass ADO Tag: 125675
  - 3
    - Strongly Typed Dataset (1.1) and DataRelation for Navigation Only I am trying to create a strongly typed dataset in .NET 1.1 and am having a problem with adding relations via the design time XSD editor. When you generate a relation at runtime, you have the option of specifying "createConstriants". Normally I would want to have constraints on a relationship, but I am working on a dataset where I only need it for navigation. I can't create a relation with the designer that does not enforce them. Any one know how to do this? Thanks, Eric Marvets MVP - Developer Security Tag: Bypass ADO Tag: 125656
  - 4
    - ORA-01460: unimplemented or unreasonable conversion requested Hi All, We are currently getting a following error ORA-01460: unimplemented or unreasonable conversion requested When we try to insert a double-byte character from our ASP.Net application through ODP.Net version 9. We have our server setting for UTF 8 encoding. This works when we insert diretly through a query or executing the stored proc with the same value using the backend. But the above error is trigerred when we try to do the insert through the ODP Parameter. The Datatype we tried include NVarchar2 and Varchar2. Note: We have made this work by passing datatype as NClob. Like to more information about this error and how to solve it? Regards, Syed. Tag: Bypass ADO Tag: 125649
  - 5
    - Must declare the scalar variable "@" - paramaterized sqlclient insert - HELP!! Below is my code, the error occurs when it is executed. I don't quite understand it; What am I doing wrong? Sub insertADRecords(ByVal oEntry As SearchResult) Dim iIndex1 As Integer Dim strSql, strDN, strProxyAdd, strProxy(), strMyString As String, rowsAffected As Integer strSql = "INSERT INTO Tradoc.dbo.CurrAD (objclass, cn, mailnickname, targetAddress, proxyAddresses, displayname, givenName,initials,sn,title,telephoneNumber,company,department,physicalDeliveryOfficeName,l,st,postalcode, co,adspath) VALUES (@,@,@,@,@,@,@,@,@,@,@,@,@,@,@,@,@,@,@))" Dim sqlCMD As SqlClient.SqlCommand = New SqlCommand(strSql, sqlConnection) 'sqlCMD.Connection() = sqlConnection sqlCMD.CommandType = CommandType.Text writeLog(strSql) 'Dim oResult As SearchResult Dim item, strtemp As String sqlCMD.Parameters.Add(New SqlParameter("@objclass", SqlDbType.VarChar, 50)) sqlCMD.Parameters.Add(New SqlParameter("@cn", SqlDbType.VarChar, 100)) sqlCMD.Parameters.Add(New SqlParameter("@mailnickname", SqlDbType.VarChar, 100)) sqlCMD.Parameters.Add(New SqlParameter("@targetAddress", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@proxyAddresses", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@displayName", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@givenName", SqlDbType.VarChar, 100)) sqlCMD.Parameters.Add(New SqlParameter("@initials", SqlDbType.VarChar, 50)) sqlCMD.Parameters.Add(New SqlParameter("@sn", SqlDbType.VarChar, 100)) sqlCMD.Parameters.Add(New SqlParameter("@title", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@telephoneNumber", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@company", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@department", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@physicalDeliveryOfficeName", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@l", SqlDbType.VarChar, 50)) sqlCMD.Parameters.Add(New SqlParameter("@st", SqlDbType.VarChar, 50)) sqlCMD.Parameters.Add(New SqlParameter("@postalcode", SqlDbType.VarChar, 50)) sqlCMD.Parameters.Add(New SqlParameter("@co", SqlDbType.VarChar, 50)) sqlCMD.Parameters.Add(New SqlParameter("@adspath", SqlDbType.VarChar, 400)) '*********************************************************** sqlCMD.Parameters("@objclass").Value = "contact" Try sqlCMD.Parameters("@cn").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("cn")(0)))) Catch ex As Exception sqlCMD.Parameters("@cn").Value = "" End Try Try sqlCMD.Parameters("@mailnickname").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("mailnickname")(0)))) Catch ex As Exception sqlCMD.Parameters("@targetAddress").Value = "" End Try Try sqlCMD.Parameters("@targetAddress").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("targetAddress")(0)))) Catch ex As Exception sqlCMD.Parameters("@targetAddress").Value = "" End Try Try sqlCMD.Parameters("@proxyAddresses").Value() = Convert.ToString(oEntry.Properties("proxyAddresses")(0)) Catch ex As Exception sqlCMD.Parameters("@proxyAddresses").Value() = "" End Try Try sqlCMD.Parameters("@displayName").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("displayName")(0)))) Catch ex As Exception sqlCMD.Parameters("@displayName").Value() = "" End Try Try sqlCMD.Parameters("@givenName").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("givenName")(0)))) Catch ex As Exception sqlCMD.Parameters("@givenName").Value = "" End Try Try sqlCMD.Parameters("@initials").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("initials")(0)))) Catch ex As Exception sqlCMD.Parameters("@initials").Value = "" End Try Try sqlCMD.Parameters("@sn").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("sn")(0)))) Catch ex As Exception sqlCMD.Parameters("@sn").Value = "" End Try Try sqlCMD.Parameters("@title").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("title")(0)))) Catch ex As Exception sqlCMD.Parameters("@title").Value = "" End Try Try sqlCMD.Parameters("@telephoneNumber").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("telephoneNumber")(0)))) Catch ex As Exception sqlCMD.Parameters("@telephoneNumber").Value = "" End Try Try sqlCMD.Parameters("@company").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("company")(0)))) Catch ex As Exception sqlCMD.Parameters("@company").Value = "" End Try Try sqlCMD.Parameters("@department").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("department")(0)))) Catch ex As Exception sqlCMD.Parameters("@department").Value = "" End Try Try sqlCMD.Parameters("@physicalDeliveryOfficeName").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("physicalDeliveryOfficeName")(0)))) Catch ex As Exception sqlCMD.Parameters("@physicalDeliveryOfficeName").Value = "" End Try Try sqlCMD.Parameters("@l").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("l")(0)))) Catch ex As Exception sqlCMD.Parameters("@l").Value = "" End Try Try sqlCMD.Parameters("@st").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("st")(0)))) Catch ex As Exception sqlCMD.Parameters("@st").Value = "" End Try Try sqlCMD.Parameters("@postalcode").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("postalcode")(0)))) Catch ex As Exception sqlCMD.Parameters("@postalcode").Value = "" End Try Try sqlCMD.Parameters("@co").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("co")(0)))) Catch ex As Exception sqlCMD.Parameters("@co").Value = "" End Try sqlCMD.Parameters("@adspath").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("adspath")(0)))) If sqlConnection.State = ConnectionState.Closed Then sqlConnection.Open() End If Try 'Here's where the error occurs, of course... rowsAffected = sqlCMD.ExecuteNonQuery() Catch ex As Exception writeLog(ex.Message) End Try sqlCMD.Dispose() End Sub Tag: Bypass ADO Tag: 125646
  - 6
    - Must declare the scalar variable "@" - paramaterized sqlclient insert - HELP!! Below is my code, the error occurs when it is executed. I don't quite understand it; What am I doing wrong? Sub insertADRecords(ByVal oEntry As SearchResult) Dim iIndex1 As Integer Dim strSql, strDN, strProxyAdd, strProxy(), strMyString As String, rowsAffected As Integer strSql = "INSERT INTO Tradoc.dbo.CurrAD (objclass, cn, mailnickname, targetAddress, proxyAddresses, displayname, givenName,initials,sn,title,telephoneNumber,company,department,physicalDeliveryOfficeName,l,st,postalcode, co,adspath) VALUES (@,@,@,@,@,@,@,@,@,@,@,@,@,@,@,@,@,@,@))" Dim sqlCMD As SqlClient.SqlCommand = New SqlCommand(strSql, sqlConnection) 'sqlCMD.Connection() = sqlConnection sqlCMD.CommandType = CommandType.Text writeLog(strSql) 'Dim oResult As SearchResult Dim item, strtemp As String sqlCMD.Parameters.Add(New SqlParameter("@objclass", SqlDbType.VarChar, 50)) sqlCMD.Parameters.Add(New SqlParameter("@cn", SqlDbType.VarChar, 100)) sqlCMD.Parameters.Add(New SqlParameter("@mailnickname", SqlDbType.VarChar, 100)) sqlCMD.Parameters.Add(New SqlParameter("@targetAddress", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@proxyAddresses", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@displayName", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@givenName", SqlDbType.VarChar, 100)) sqlCMD.Parameters.Add(New SqlParameter("@initials", SqlDbType.VarChar, 50)) sqlCMD.Parameters.Add(New SqlParameter("@sn", SqlDbType.VarChar, 100)) sqlCMD.Parameters.Add(New SqlParameter("@title", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@telephoneNumber", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@company", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@department", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@physicalDeliveryOfficeName", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@l", SqlDbType.VarChar, 50)) sqlCMD.Parameters.Add(New SqlParameter("@st", SqlDbType.VarChar, 50)) sqlCMD.Parameters.Add(New SqlParameter("@postalcode", SqlDbType.VarChar, 50)) sqlCMD.Parameters.Add(New SqlParameter("@co", SqlDbType.VarChar, 50)) sqlCMD.Parameters.Add(New SqlParameter("@adspath", SqlDbType.VarChar, 400)) '*********************************************************** sqlCMD.Parameters("@objclass").Value = "contact" Try sqlCMD.Parameters("@cn").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("cn")(0)))) Catch ex As Exception sqlCMD.Parameters("@cn").Value = "" End Try Try sqlCMD.Parameters("@mailnickname").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("mailnickname")(0)))) Catch ex As Exception sqlCMD.Parameters("@targetAddress").Value = "" End Try Try sqlCMD.Parameters("@targetAddress").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("targetAddress")(0)))) Catch ex As Exception sqlCMD.Parameters("@targetAddress").Value = "" End Try Try sqlCMD.Parameters("@proxyAddresses").Value() = Convert.ToString(oEntry.Properties("proxyAddresses")(0)) Catch ex As Exception sqlCMD.Parameters("@proxyAddresses").Value() = "" End Try Try sqlCMD.Parameters("@displayName").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("displayName")(0)))) Catch ex As Exception sqlCMD.Parameters("@displayName").Value() = "" End Try Try sqlCMD.Parameters("@givenName").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("givenName")(0)))) Catch ex As Exception sqlCMD.Parameters("@givenName").Value = "" End Try Try sqlCMD.Parameters("@initials").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("initials")(0)))) Catch ex As Exception sqlCMD.Parameters("@initials").Value = "" End Try Try sqlCMD.Parameters("@sn").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("sn")(0)))) Catch ex As Exception sqlCMD.Parameters("@sn").Value = "" End Try Try sqlCMD.Parameters("@title").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("title")(0)))) Catch ex As Exception sqlCMD.Parameters("@title").Value = "" End Try Try sqlCMD.Parameters("@telephoneNumber").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("telephoneNumber")(0)))) Catch ex As Exception sqlCMD.Parameters("@telephoneNumber").Value = "" End Try Try sqlCMD.Parameters("@company").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("company")(0)))) Catch ex As Exception sqlCMD.Parameters("@company").Value = "" End Try Try sqlCMD.Parameters("@department").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("department")(0)))) Catch ex As Exception sqlCMD.Parameters("@department").Value = "" End Try Try sqlCMD.Parameters("@physicalDeliveryOfficeName").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("physicalDeliveryOfficeName")(0)))) Catch ex As Exception sqlCMD.Parameters("@physicalDeliveryOfficeName").Value = "" End Try Try sqlCMD.Parameters("@l").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("l")(0)))) Catch ex As Exception sqlCMD.Parameters("@l").Value = "" End Try Try sqlCMD.Parameters("@st").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("st")(0)))) Catch ex As Exception sqlCMD.Parameters("@st").Value = "" End Try Try sqlCMD.Parameters("@postalcode").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("postalcode")(0)))) Catch ex As Exception sqlCMD.Parameters("@postalcode").Value = "" End Try Try sqlCMD.Parameters("@co").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("co")(0)))) Catch ex As Exception sqlCMD.Parameters("@co").Value = "" End Try sqlCMD.Parameters("@adspath").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("adspath")(0)))) If sqlConnection.State = ConnectionState.Closed Then sqlConnection.Open() End If Try 'Here's where the error occurs, of course... rowsAffected = sqlCMD.ExecuteNonQuery() Catch ex As Exception writeLog(ex.Message) End Try sqlCMD.Dispose() End Sub Tag: Bypass ADO Tag: 125645
  - 7
    - Must declare the scalar variable "@" - paramaterized sqlclient insert Below is my code, the error occurs when it is executed. I don't quite understand it; What am I doing wrong? Sub insertADRecords(ByVal oEntry As SearchResult) Dim iIndex1 As Integer Dim strSql, strDN, strProxyAdd, strProxy(), strMyString As String, rowsAffected As Integer strSql = "INSERT INTO Tradoc.dbo.CurrAD (objclass, cn, mailnickname, targetAddress, proxyAddresses, displayname, givenName,initials,sn,title,telephoneNumber,company,department,physicalDeliveryOfficeName,l,st,postalcode, co,adspath) VALUES (@,@,@,@,@,@,@,@,@,@,@,@,@,@,@,@,@,@,@))" Dim sqlCMD As SqlClient.SqlCommand = New SqlCommand(strSql, sqlConnection) 'sqlCMD.Connection() = sqlConnection sqlCMD.CommandType = CommandType.Text writeLog(strSql) 'Dim oResult As SearchResult Dim item, strtemp As String sqlCMD.Parameters.Add(New SqlParameter("@objclass", SqlDbType.VarChar, 50)) sqlCMD.Parameters.Add(New SqlParameter("@cn", SqlDbType.VarChar, 100)) sqlCMD.Parameters.Add(New SqlParameter("@mailnickname", SqlDbType.VarChar, 100)) sqlCMD.Parameters.Add(New SqlParameter("@targetAddress", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@proxyAddresses", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@displayName", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@givenName", SqlDbType.VarChar, 100)) sqlCMD.Parameters.Add(New SqlParameter("@initials", SqlDbType.VarChar, 50)) sqlCMD.Parameters.Add(New SqlParameter("@sn", SqlDbType.VarChar, 100)) sqlCMD.Parameters.Add(New SqlParameter("@title", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@telephoneNumber", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@company", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@department", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@physicalDeliveryOfficeName", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@l", SqlDbType.VarChar, 50)) sqlCMD.Parameters.Add(New SqlParameter("@st", SqlDbType.VarChar, 50)) sqlCMD.Parameters.Add(New SqlParameter("@postalcode", SqlDbType.VarChar, 50)) sqlCMD.Parameters.Add(New SqlParameter("@co", SqlDbType.VarChar, 50)) sqlCMD.Parameters.Add(New SqlParameter("@adspath", SqlDbType.VarChar, 400)) '*********************************************************** sqlCMD.Parameters("@objclass").Value = "contact" Try sqlCMD.Parameters("@cn").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("cn")(0)))) Catch ex As Exception sqlCMD.Parameters("@cn").Value = "" End Try Try sqlCMD.Parameters("@mailnickname").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("mailnickname")(0)))) Catch ex As Exception sqlCMD.Parameters("@targetAddress").Value = "" End Try Try sqlCMD.Parameters("@targetAddress").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("targetAddress")(0)))) Catch ex As Exception sqlCMD.Parameters("@targetAddress").Value = "" End Try Try sqlCMD.Parameters("@proxyAddresses").Value() = Convert.ToString(oEntry.Properties("proxyAddresses")(0)) Catch ex As Exception sqlCMD.Parameters("@proxyAddresses").Value() = "" End Try Try sqlCMD.Parameters("@displayName").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("displayName")(0)))) Catch ex As Exception sqlCMD.Parameters("@displayName").Value() = "" End Try Try sqlCMD.Parameters("@givenName").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("givenName")(0)))) Catch ex As Exception sqlCMD.Parameters("@givenName").Value = "" End Try Try sqlCMD.Parameters("@initials").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("initials")(0)))) Catch ex As Exception sqlCMD.Parameters("@initials").Value = "" End Try Try sqlCMD.Parameters("@sn").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("sn")(0)))) Catch ex As Exception sqlCMD.Parameters("@sn").Value = "" End Try Try sqlCMD.Parameters("@title").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("title")(0)))) Catch ex As Exception sqlCMD.Parameters("@title").Value = "" End Try Try sqlCMD.Parameters("@telephoneNumber").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("telephoneNumber")(0)))) Catch ex As Exception sqlCMD.Parameters("@telephoneNumber").Value = "" End Try Try sqlCMD.Parameters("@company").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("company")(0)))) Catch ex As Exception sqlCMD.Parameters("@company").Value = "" End Try Try sqlCMD.Parameters("@department").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("department")(0)))) Catch ex As Exception sqlCMD.Parameters("@department").Value = "" End Try Try sqlCMD.Parameters("@physicalDeliveryOfficeName").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("physicalDeliveryOfficeName")(0)))) Catch ex As Exception sqlCMD.Parameters("@physicalDeliveryOfficeName").Value = "" End Try Try sqlCMD.Parameters("@l").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("l")(0)))) Catch ex As Exception sqlCMD.Parameters("@l").Value = "" End Try Try sqlCMD.Parameters("@st").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("st")(0)))) Catch ex As Exception sqlCMD.Parameters("@st").Value = "" End Try Try sqlCMD.Parameters("@postalcode").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("postalcode")(0)))) Catch ex As Exception sqlCMD.Parameters("@postalcode").Value = "" End Try Try sqlCMD.Parameters("@co").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("co")(0)))) Catch ex As Exception sqlCMD.Parameters("@co").Value = "" End Try sqlCMD.Parameters("@adspath").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("adspath")(0)))) If sqlConnection.State = ConnectionState.Closed Then sqlConnection.Open() End If Try 'Here's where the error occurs, of course... rowsAffected = sqlCMD.ExecuteNonQuery() Catch ex As Exception writeLog(ex.Message) End Try sqlCMD.Dispose() End Sub Tag: Bypass ADO Tag: 125644
  - 8
    - Have you stopped using ADO? Just wondering - has everyone switched to ADONet, or do you still use 'old' ADO for something? Vayse Tag: Bypass ADO Tag: 125643
  - 9
    - Must declare the scalar variable "@" - paramaterized sqlclient insert Below is my code, the error occurs when it is executed. I don't quite understand it; What am I doing wrong? Sub insertADRecords(ByVal oEntry As SearchResult) Dim iIndex1 As Integer Dim strSql, strDN, strProxyAdd, strProxy(), strMyString As String, rowsAffected As Integer strSql = "INSERT INTO Tradoc.dbo.CurrAD (objclass, cn, mailnickname, targetAddress, proxyAddresses, displayname, givenName,initials,sn,title,telephoneNumber,company,department,physicalDeliveryOfficeName,l,st,postalcode, co,adspath) VALUES (@,@,@,@,@,@,@,@,@,@,@,@,@,@,@,@,@,@,@))" Dim sqlCMD As SqlClient.SqlCommand = New SqlCommand(strSql, sqlConnection) 'sqlCMD.Connection() = sqlConnection sqlCMD.CommandType = CommandType.Text writeLog(strSql) 'Dim oResult As SearchResult Dim item, strtemp As String sqlCMD.Parameters.Add(New SqlParameter("@objclass", SqlDbType.VarChar, 50)) sqlCMD.Parameters.Add(New SqlParameter("@cn", SqlDbType.VarChar, 100)) sqlCMD.Parameters.Add(New SqlParameter("@mailnickname", SqlDbType.VarChar, 100)) sqlCMD.Parameters.Add(New SqlParameter("@targetAddress", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@proxyAddresses", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@displayName", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@givenName", SqlDbType.VarChar, 100)) sqlCMD.Parameters.Add(New SqlParameter("@initials", SqlDbType.VarChar, 50)) sqlCMD.Parameters.Add(New SqlParameter("@sn", SqlDbType.VarChar, 100)) sqlCMD.Parameters.Add(New SqlParameter("@title", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@telephoneNumber", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@company", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@department", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@physicalDeliveryOfficeName", SqlDbType.VarChar, 400)) sqlCMD.Parameters.Add(New SqlParameter("@l", SqlDbType.VarChar, 50)) sqlCMD.Parameters.Add(New SqlParameter("@st", SqlDbType.VarChar, 50)) sqlCMD.Parameters.Add(New SqlParameter("@postalcode", SqlDbType.VarChar, 50)) sqlCMD.Parameters.Add(New SqlParameter("@co", SqlDbType.VarChar, 50)) sqlCMD.Parameters.Add(New SqlParameter("@adspath", SqlDbType.VarChar, 400)) '*********************************************************** sqlCMD.Parameters("@objclass").Value = "contact" Try sqlCMD.Parameters("@cn").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("cn")(0)))) Catch ex As Exception sqlCMD.Parameters("@cn").Value = "" End Try Try sqlCMD.Parameters("@mailnickname").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("mailnickname")(0)))) Catch ex As Exception sqlCMD.Parameters("@targetAddress").Value = "" End Try Try sqlCMD.Parameters("@targetAddress").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("targetAddress")(0)))) Catch ex As Exception sqlCMD.Parameters("@targetAddress").Value = "" End Try Try sqlCMD.Parameters("@proxyAddresses").Value() = Convert.ToString(oEntry.Properties("proxyAddresses")(0)) Catch ex As Exception sqlCMD.Parameters("@proxyAddresses").Value() = "" End Try Try sqlCMD.Parameters("@displayName").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("displayName")(0)))) Catch ex As Exception sqlCMD.Parameters("@displayName").Value() = "" End Try Try sqlCMD.Parameters("@givenName").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("givenName")(0)))) Catch ex As Exception sqlCMD.Parameters("@givenName").Value = "" End Try Try sqlCMD.Parameters("@initials").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("initials")(0)))) Catch ex As Exception sqlCMD.Parameters("@initials").Value = "" End Try Try sqlCMD.Parameters("@sn").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("sn")(0)))) Catch ex As Exception sqlCMD.Parameters("@sn").Value = "" End Try Try sqlCMD.Parameters("@title").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("title")(0)))) Catch ex As Exception sqlCMD.Parameters("@title").Value = "" End Try Try sqlCMD.Parameters("@telephoneNumber").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("telephoneNumber")(0)))) Catch ex As Exception sqlCMD.Parameters("@telephoneNumber").Value = "" End Try Try sqlCMD.Parameters("@company").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("company")(0)))) Catch ex As Exception sqlCMD.Parameters("@company").Value = "" End Try Try sqlCMD.Parameters("@department").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("department")(0)))) Catch ex As Exception sqlCMD.Parameters("@department").Value = "" End Try Try sqlCMD.Parameters("@physicalDeliveryOfficeName").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("physicalDeliveryOfficeName")(0)))) Catch ex As Exception sqlCMD.Parameters("@physicalDeliveryOfficeName").Value = "" End Try Try sqlCMD.Parameters("@l").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("l")(0)))) Catch ex As Exception sqlCMD.Parameters("@l").Value = "" End Try Try sqlCMD.Parameters("@st").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("st")(0)))) Catch ex As Exception sqlCMD.Parameters("@st").Value = "" End Try Try sqlCMD.Parameters("@postalcode").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("postalcode")(0)))) Catch ex As Exception sqlCMD.Parameters("@postalcode").Value = "" End Try Try sqlCMD.Parameters("@co").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("co")(0)))) Catch ex As Exception sqlCMD.Parameters("@co").Value = "" End Try sqlCMD.Parameters("@adspath").Value = strQuoteReplace(Trim(Convert.ToString(oEntry.Properties("adspath")(0)))) If sqlConnection.State = ConnectionState.Closed Then sqlConnection.Open() End If Try 'Here's where the error occurs, of course... rowsAffected = sqlCMD.ExecuteNonQuery() Catch ex As Exception writeLog(ex.Message) End Try sqlCMD.Dispose() End Sub Tag: Bypass ADO Tag: 125639
  - 10
    - How to persist an ADO recordset from Sql Server into Access Is there a simple way to persist a recordset from a SQL Server db into a table in an Access database, for example DAO allows a "select * into tablex in 'c:\externaldb.mdb' from..." Or is a disconnected recordset the way to go, but then how do I persist this back into another table in an Access database or even a file? Thanks in advance, WayneM Tag: Bypass ADO Tag: 125638
  - 11
    - Binding DataGridView without default DataVeiw, it's possible? I know that when binding DataGridView to Datatable, the ADO.NET create Dataview. the problem is with large data, this process take long time and consume RAM. if i not need sorting service have a way to avoid the default dataView? Tag: Bypass ADO Tag: 125635
  - 12
    - Primary Key I'm dev. a app with typed datasets and I would not use a self-inc field for the primary key. Instead of I would like make my own pk control. What's the best way to make that with VS 2005 + SQL 2005? Just make a sp like the old good times? :-) Tag: Bypass ADO Tag: 125628
  - 13
    - Transactions with TableAdapters in ADo.Net 2.0 I have a VS2005 C# winforms app connecting to SQL2005. Having discovered the limitations of the new TableAdapter implementation, and the fact that if I use System.Transaction on updates to a DataSet with several related tables then MSDTC is automatically invoked, I've followed advice from this newsgroup and elsewhere to implement my own methods in the TableAdapter classes to apply a SQLTransaction object to each command (much as I used to do with DataAdapters in ADO 1.1). This seems to work very well, but I'm puzzled by the fact that when I trace the events in SQL Profiler I do not see any BEGIN TRAN or COMMIT statements, even though if I artificially induce a rollback the transaction is definitely completely rolled back as expected. Is there a different communication channel for transactions with SQL2005? brian smith Tag: Bypass ADO Tag: 125626
  - 14
    - Changing column order in typed dataset I create a typed dataset based upon a table, using the VS2005 designer. I then add a query to the table adapter with a select statement, changing the order of some columns, and removing others. When I select preview data, I see the columns in the original order of the dataset, with the columns I removed now showing up as empty. This can't be by design, can it? And if so, how can I order the columns? Since I am using stored procedures, I can drop the select stored procedure in the TDS and the resulting column order is correct, but I am now using a different table adapter. Are there any other options? Thanks, David R Tag: Bypass ADO Tag: 125618
  - 15
    - Binding to TextBoxes on MySQL with C# Ref: WinXP SP2, MySQL 5.0, .NET 1.1, C# I try to bind columns to TextBoxes. The column data appears in the textboxes, but if modified will not update. My code came from MySQL example, which uses a datagrid. If cols in the datagrid are modified they update fine. The following code: DataTable changes; changes = this.data.GetChanges(); x = 1; this.da.Update( changes ); this.data.AcceptChanges(); yields the error "Value cannot be null", as I guess 'changes' is null because nothing in the DataGrid has changed. So, how to get the TextBox bindings to yield non-null 'changes' FYI: 'data' is a DataTable, 'da' is MySQLDataAdapter Thanks! Tag: Bypass ADO Tag: 125615
  - 16
    - can't drag a dataset Hi, i'm a beginner, this is the scenario: i'm using vs2005 and c## Created a win form project. Created a ms database with some tables. created a win form who acts as parent and some others forms that inherits from it, in my parent form a put a label and a group box. Drag a dataset to a inherited form and work fine. The problem: Can not drag any other dataset to another inherited form. I did try dragging from datasource window (typed dataset), from server explorer, dragging a grid control and bindig to a table, but nothing really work. I was triying some options and if i create a new win form i can drag a dataset to it. *** Sent via Developersdex http://www.developersdex.com *** Tag: Bypass ADO Tag: 125612
  - 17
    - DB2CONNECTION ISSUES.. Hello I am facing a very different issue with db2 connect. DBconnection string is Database=mydatabase;UID=userid;PWD=password;pooling = false mydatabase is a system DSN created while configuring db2 node. Sometimes all of sudden i am getting this issue error "The type initializer for "IBM.Data.DB2.DB2Connection" threw an exception." at IBM.Data.DB2.DB2Connection..ctor(String connectionString) at Microsoft.Practices.EnterpriseLibrary.Data.DB2.DB2Database.GetConnection() at Microsoft.Practices.EnterpriseLibrary.Data.Database.LoadDataSet(DBCommandWrapper command, DataSet dataSet But after restarting the IIS everything works fine for 1/2 days and again starts same issue. In some developer machines i am not at all getting this issue. #1) asp.net and given permission to IWAM_USR under which worker process is running. #2) given permission to SQLLIB folder to IWAM_USR. #3)Added IWAM_USR to the db2users group. #4) Reregistered DB2client 8.1.7 plz help me out if u have any solutions.. Thanks in advance Tag: Bypass ADO Tag: 125609
  - 18
    - Connection String will not connect from ASP.NET I have been using the following connection string to connect to sql server from an asp.net page: packet size=4096;user id=xxxxxx;data source=w2k3bspsqldevvs;persist security info=True;initial catalog=xxxxxx;password=xxxxxx It worked perfectly well. I had a week off and now the asp.net page will no longer connect to the sql server. If I create a c# desktop app and use the connection string above then it works. If I create a new asp.net page and use the connection string then it doesn't work. I found a similar message in this group entitled "ASP.NET Connection String" - the solution was to restart the SQL Server. Unfortunately my sql server is in a cluster and never gets rebooted. Any one got any ideas? Thanks Tag: Bypass ADO Tag: 125596
  - 19
    - Connection String will not connect from ASP.NET I have been using the following connection string to connect to sql server from an asp.net page: packet size=4096;user id=xxxxxx;data source=w2k3bspsqldevvs;persist security info=True;initial catalog=xxxxxx;password=xxxxxx It worked perfectly well. I had a week off and now the asp.net page will no longer connect to the sql server. If I create a c# desktop app and use the connection string above then it works. If I create a new asp.net page and use the connection string then it doesn't work. I found a similar message in this group entitled "ASP.NET Connection String" - the solution was to restart the SQL Server. Unfortunately my sql server is in a cluster and never gets rebooted. Any one got any ideas? Thanks Tag: Bypass ADO Tag: 125595
  - 20
    - Convert UTC time to localtime in SqlDataAdapter I have the following method, that retrieves data from a SQL server and propergates the data in a datagrid. No problems there: ________________________________________________________________ Public Sub fetchBillPostings(ByVal stationName As String, ByRef BillpostingsDG As DataGrid) Dim dataadapter As New SqlDataAdapter( _ "SELECT dbo.Postings.[Time], dbo.Postings.Locator, dbo.Postings.PriceGroup, " & _ "dbo.Postings.License, dbo.Postings.Price, dbo.Postings.Currency " & _ "FROM dbo.Postings INNER JOIN dbo.Rooms ON dbo.Postings.Room =3D dbo.Rooms.Name " & _ "INNER JOIN dbo.Stations ON dbo.Rooms.Id =3D dbo.Stations.Room " & _ "WHERE (dbo.Stations.Name =3D '" & stationName & "')", sqlConn) Dim dataset =3D New DataSet("Testdataset") dataadapter.Fill(dataset, "Postings") BillpostingsDG.SetDataBinding(dataset, "Postings") ' Formater datagrid korrekt Dim ts1 As DataGridTableStyle ts1 =3D New DataGridTableStyle ts1.MappingName =3D "Postings" ts1.GridLineColor =3D Color.White ts1.HeaderBackColor =3D Color.FromArgb(62, 98, 144) ts1.HeaderForeColor =3D Color.White ts1.SelectionBackColor =3D Color.FromArgb(82, 118, 164) If Not BillpostingsDG.TableStyles.Contains(ts1.MappingName) Then BillpostingsDG.TableStyles.Add(ts1) BillpostingsDG.TableStyles.Add( _ ExtendedDataGrid.DataGridApplyAutomaticWidths(BillpostingsDG, BillpostingsDG.TableStyles(0), 10, 200)) 'formater s=E5dan at datoen ogs=E5 indeholder tid Dim dgtbc As DataGridTextBoxColumn =3D BillpostingsDG.TableStyles.Item(1).GridColumnStyles.Item(0) dgtbc.Format =3D "g" dgtbc.FormatInfo =3D New System.Globalization.CultureInfo(&H413) ' holland 's=F8g for at null bliver til blank: dgtbc =3D BillpostingsDG.TableStyles.Item(1).GridColumnStyles.Item(1) dgtbc.NullText =3D "" dgtbc =3D BillpostingsDG.TableStyles.Item(1).GridColumnStyles.Item(2) dgtbc.NullText =3D "" End If End Sub ________________________________________________________________ Now the problem is that that the time stored in dbo.Postings.[Time] is in UTC and I would like to display it with localtime (in my case +1 hour) How can I do that? As far as I can see there is something in .net 2.0 that enables you to change the datetime format in the dataset. But thats not an option here. Also note that I only need to display the data. I'm not changing anything in the datagrid and updating the SQL data. Thanks in advance for any input. Tag: Bypass ADO Tag: 125593
  - 21
    - Batch execute Stored Procedures with sqlcommand? Is there a way to send a couple of stored procedure requests in a single round trip to the sql server if the stored procedures have parameters? I know I could create a string and send it, but would prefer not to rely on my ability to correctly handle every problem that might come along. For instance I can do this: EXEC sp1 @param='value', @param2='value'; EXEC sp2 @param='value' In a SqlCommand, but I'd like to do this using the built in parameter features if possible. Also the sp's often return datasets, so I need to be able to navigate through the recordsets. If the above is the only way to do this, are there any references on what a safe way to construct that string is so it's not vulerable to various attacks? I'm trying to batch up most of the stuff I need to do, sending one round trip to the database, and then doing stuff with the result. Tag: Bypass ADO Tag: 125590
  - 22
    - Stored Procedure call failed in VB.NET Hi, I have a stored procedure on SQLServer2000 version (8.00.194) and 'm executing a stored procedure from vb.net. ------------------------------------------------------------------------------------------------------------------------- stored procedure in server ------------------------------------------------------------------------------------------------------------------------- CREATE PROCEDURE STP_ECLAT_FBT_TAN_MST_ADD( @TanCode int, @TanNo Varchar(50), @Active bit, @Remarks Varchar(500), @cmpid int, @ERRADD AS INT OUTPUT, @MAXIC AS INT OUTPUT) AS DECLARE @INTCNT AS INTEGER -- For the Unique Check DECLARE @ERRNO AS INTEGER -- For getting the Error Number BEGIN TRAN SET @INTCNT=(SELECT COUNT(TanCode) FROM ECLAT_FBT_TAN_MST WHERE TanCode=@TanCode) IF @INTCNT<>0 BEGIN SET @ERRADD=50001 ROLLBACK TRANSACTION RETURN END ELSE INSERT INTO ECLAT_FBT_TAN_MST (TanCode,TanNo,Active,Remarks,cmpid) VALUES (@TanCode,@TanNo,@Active,@Remarks, @cmpid); SELECT @ERRNO=@@ERROR IF @ERRNO<> 0 BEGIN SET @ERRADD=@ERRNO ROLLBACK TRANSACTION RETURN END ELSE BEGIN SET @ERRADD=0 SELECT @MAXIC=MAX(TanId) FROM ECLAT_FBT_TAN_MST END COMMIT TRAN GO ------------------------------------------------------------------------------------------------------------------------- In VB.net ------------------------------------------------------------------------------------------------------------------------- Dim dbcommand As New SqlCommand Dim BytActive As Integer If rbtActive.Checked = True Then BytActive = 1 Else BytActive = 0 End If dbcommand.CommandText = "STP_ECLAT_FBT_TAN_MST_ADD" dbcommand.CommandType = CommandType.StoredProcedure dbcommand.Connection = gConnection dbcommand.Parameters.Add(New SqlParameter("@TanCode", TanCode)) dbcommand.Parameters.Add(New SqlParameter("@TanNo", TanNo)) dbcommand.Parameters.Add(New SqlParameter("@Active", BytActive)) dbcommand.Parameters.Add(New SqlParameter("@Remarks", Remarks)) dbcommand.Parameters.Add(New SqlParameter("@cmpid", cmpid)) dbcommand.ExecuteNonQuery() I d'not know how to run stored procedure from vb.net and pass input /get output parameters, but i have excetued store procedure in vb6.0. Any help is appreciated! Tag: Bypass ADO Tag: 125585
  - 23
    - How to determine the data-provider type from a DbConnection object Im trying to use prepared SQL and need to support both Oracle and SQL server. Im only dealing with the abstraction - i.e. DbConnection object. When using DbParameters, for Oracle i have to use :myVar but for SQL Server i have to use @myVar. So the abstraction breaks down here. Consequently i need to ask "What database server are you?" to then prefix the correct parameter marker character( bring back the ? ). Iv checked the DbConnection object and there do not seem to be any appropriate methods, whereby the provider can override some method which will return the identity. How best can i determine the type of the DBMS i am currently connected too? I do not want to burden the user with having to pass across some identity... Thanks. Tag: Bypass ADO Tag: 125584
  - 24
    - Passing dataset between two web forms in c# Hi all... I wan to pass a dataset from one web form to another. i had tried with the session object but it didn't worked out....Please help... I thing its a serious problem in ADO.net and asp.net... Waiting for your response... Than u... Tag: Bypass ADO Tag: 125583
  - 25
    - connection.close vs. connection.dispose I understand that the dispose method releases umnanaged resources, but I am trying to understand what those resources are when it comes to a database connection. If my connection is closed, then what unmanaged resources does the connection object still have? Tag: Bypass ADO Tag: 125568
- Next
  - 1
    - How To Invoke a Login Prompt When Opening an ADO.Net Connection ? Hi : Does someone know if there is a way to throw a login prompt in ADO.Net similar to the ADO connection login prompt as below : Dim cn as ADODB.Connection Set cn = New ADODB.Connection With cn .Properties("Prompt") = adPromptAlways .Open End With Thanks much in advance. -- Thanks, SDRoy Tag: Bypass ADO Tag: 125565
  - 2
    - ADODB VB Code: con.Properties("Prompt") -Anything similar in ADO.N Hi: Can some please tell me if there is a way to invoke the SQL user challenge dialog from ADO.Net ? I mean what would be the equivalent (if any) code in ASP.Net/C# or VB.Net for the following VB code using ADODB: oConnection.Properties("Prompt") = adPromptAlways oConnection.Open "Driver={SQL Server};Server=" & _ m_Server & ";Database=" & m_DB & ";" Set DBConnection = oConnection Thanks in advance. -- Thanks, SDRoy Tag: Bypass ADO Tag: 125560
  - 3
    - AutoIncrement is generating null values? - OR - need to get Autonumber from Access db table Hello, I'm trying to create a datarelationship between two tables in a dataset. I've turned the autoincrement switch on to an ID field, but it's not generating anything. I am a newbie, so I'm hoping it's nothing too difficult. Here is the code; Dim sql$ = "SELECT 0 AS Selected, VendorInventoryTypes.VendorInventoryTypesID, VendorInventoryTypes.Code, VendorInventoryTypes.Category, VendorInventoryTypes.SubCategory, VendorInventoryTypes.Brand, VendorInventoryTypes.Model, VendorInventoryTypes.Description, 0 AS Quantity, VendorInventoryTypes.RequiresUniqueItems,VendorInventoryTypes.Cost FROM (VendorInventoryTypes) WHERE (((VendorInventoryTypes.VendorID)=" & lclVendorID & "));" Dim dc As New DataColumn, dt As New DataTable dsInventoryTypeOrders = mdi.dt.GenericDS(sql) dc.AutoIncrement = True dc.AutoIncrementSeed = -1 dc.AutoIncrementStep = -1 dc.ColumnName = "ID" dsInventoryTypeOrders.Tables(0).Columns.Add(dc) Console.WriteLine(dsInventoryTypeOrders.Tables(0).Columns(11)) view1 = New DataView(dsInventoryTypeOrders.Tables(0)) view1.RowFilter = "Selected = 0" view2 = New DataView(dsInventoryTypeOrders.Tables(0)) view2.RowFilter = "Selected = 1" listAvailable.DataSource = view1 listSelected.DataSource = view2 Any help would be greatly appreciated. Thanks! Tag: Bypass ADO Tag: 125559
  - 4
    - Locking a record in Access from vb.net Hi all, I need to lock a record while a user edits that record, so other users see a "Record is locked" message when try to access that specific record. I know there is a lockrecord property in Access, but I'm not sure how to lock this record from my vb.net form. Any help would be highly appreciated. Roy Tag: Bypass ADO Tag: 125558
  - 5
    - Boxing values in SqlServer ? I'm looking for a way store different simple datatypes in just one specific column, and determine at retrieving how to unbox them - what is the best (if any) datatype for this purpose? - and how is it best set and retrieved through ADO 2.0? Rune Tag: Bypass ADO Tag: 125556
  - 6
    - hierarchical Dataset In ADO we had hierarchical and the Shape command. Do we have anything similar in ADO.NET? I know I can have a hiearchy in a dataset, but how do I fill such a dataset? -- Arne Garvander Certified Geek Tag: Bypass ADO Tag: 125554
  - 7
    - access sql mobile on WM5.0 device from desktop I'm trying to create a VB2005 windows app that retrieves data from a Window Mobile 5.0 device connected by ActiveSync 4. I've added the sql mobile database as a datasource in my project and created a bound control using the drag and drop. When I run the application, I get an SQLCEexception 'The path is invalid'. The drag & drop process has automatically set the connection path to "Mobile Device\My Documents\mydb.sdf", but this is what causes the error. I can view the data perfectly in the data source browser, but I can't access it in the application. I must be ding something stupid, but I can't find any reference to similar problems in the newsgroups. Any ieas? Thanks Ian Tag: Bypass ADO Tag: 125551
  - 8
    - Microsoft .NET Framework 2.0 Data Provider for Oracle Is there a "Microsoft .NET Framework 2.0 Data Provider for Oracle" - I saw on the Oracle site that ODP.Net is not available yet to support ADO.Net features? Thx for any feedback, rgds, Joris http://jopx.blogspot.com Tag: Bypass ADO Tag: 125548
  - 9
    - SqlDataReader 2.0 In Ado.Net 1.1 I could only have one open sqldatareader on a sqlcommand. Is that still the case in ADO.Net 2.0? -- Arne Garvander Certified Geek But failed my Nerd exam Tag: Bypass ADO Tag: 125543
  - 10
    - ADO.Net 2.0 ; SqlDataReader.GetSchemaTable broken? Hi all, I'm using the GetSchemaTable method on a data reader to determine information about the table itself. One of the DataRow's items is supposed to include IsKey, which tells me if the column is part of the primary key or not. I have a simple table with an Int identity as the primary key, but IsKey is returning a null value..neither true or false. Is this a bug in the framework? IsIdentity does return correctly as do most of the other properties i've examined. Thanks Andy Tag: Bypass ADO Tag: 125535
  - 11
    - UPDATE statement on MDB failes the UPDATE statement with the OleDbCommand class wont work with me :( i cant seem to get it right i use for an example the following statement: 'update tbl_DynCountry set Country = @Country where CountryID = @CountryID' then i add the parameters, and i add the database connection to the command! when i am in debugmode, everything seems ok, dataconnection is open, parameters are attached, with the right value, then i use the method command.ExecuteNonQuery(); and the return value is 0 -- meaning 0 rows affected! i cant seem to find the problem :( insert statements are working fine, but the update aint :( did anybody have the same problem in the past??? and how do i solve it? Tag: Bypass ADO Tag: 125521
  - 12
    - System.Transactions stored procedure returns NULL value Hey everyone, First off I am a newbie at using System.Transactions. I am trying to do what would seem to be a simple task. I am using a C#.Net in a Windows Form to extract information from a powerpoint document into a Sql Server 2005 Database. On the Database side: - I have two tables for TALKS and SLIDES - I also have two corresponding sp_save_talk and sp_save_slide that return the @@IDENTITY of the newly inserted row. On the WinForm side: - I have a strongly typed dataset for talks and slides which implement the StoredProcs as TableAdapter methods and return the identity. My Questions are: - Why is the return value of @@IDENTITY is coming back null, which doesn't help, because I need it to insert the slides? It works and I get a return value if I comment out the using TransactionScope line. - Am I using the right transaction type? - Does this even make sense? - I was going to just scrape the idea and use conn.begin transaction, but I cant find anywhere in the Strongy typed DataSet to use a transaction. Does one exist? I am trying to use the following code: using (System.Transactions.TransactionScope tx = new System.Transactions.TransactionScope()) { using (SqlConnection conn = new SqlConnection(MySettings.EndocannabinoidConnectionString)) { try { conn.Open(); int? talkId = 0; using (talksTableAdapter talkAdapter = new talksTableAdapter()) { talkAdapter.Connection = conn; talkId = (int?)talkAdapter.Save(0, Path.GetFileName(this.destination.Text), this.title.Text, (int?)this.topics.SelectedValue); } using (slidesTableAdapter slideAdapter = new slidesTableAdapter()) { slideAdapter.Connection = conn; foreach (Slide s in _pres.Slides) { // Insert Slides int? slideId = (int?)slideAdapter.Save(0, talkId, (int?)s.SlideIndex, Path.GetFileName(this.destination.Text) + "-slides/" + Path.GetFileName(s.ThumbnailImageFilename), Path.GetFileName(this.destination.Text) + "-slides/" + Path.GetFileName(s.ImageFilename), s.Title, s.Notes, s.Content, s.Keywords); } } tx.Complete(); } catch (Exception ex) { MessageBox.Show("Rolled Back because " + ex.Message + (ex.InnerException == null ? "" : ", " + ex.InnerException.Message)); } } } Tag: Bypass ADO Tag: 125520
  - 13
    - MS data provider for oracle is much slower than ODP.NET Microsoft oracle data provider doesn't implement the statement caching feature which was added to Oracle data provider in version 10.1.0.3.0. I have a simple program (*) which inserts 20000 records into a table. Using Microsoft data provider for Oracle it takes 1 minute to execute. Using the Oracle Data Provider for .NET (version 10.2.0.100) and the statement chaching feature it takes 25 seconds. I know that Microsoft does not have a published schedule for including statement caching for the Oracle .NET provider. So my question is, are there plans to add features that improve the performance on that type of programs (which execute many times the same statement)?. (*): using System; using System.Data; using System.Data.OracleClient; namespace Oracle { /// <summary> /// Summary description for Class1. /// </summary> public class Class1 { static void Main(string[] args) { OracleConnection conn = new OracleConnection("Data Source=oracle10gr2;;User ID=TSDBNTAG2YI;Password=tsdbntag2yi;"); IDbTransaction trn=null; try { conn.Open(); trn = conn.BeginTransaction(IsolationLevel.ReadCommitted); IDbCommand cmdDelete = new OracleCommand("DELETE FROM TRN01", (OracleConnection) conn); cmdDelete.Transaction = trn; cmdDelete.ExecuteNonQuery(); DateTime d1 = DateTime.Now; IDbCommand cmd = new OracleCommand( "INSERT INTO TRN01 (A, B) VALUES (:A, :B)", conn); cmd.CommandTimeout=0; cmd.Transaction = trn; OracleParameter parm1 = new OracleParameter( "A", OracleType.Number, 10); OracleParameter parm2 = new OracleParameter("B", OracleType.Char, 20); cmd.Parameters.Add(parm1); cmd.Parameters.Add(parm2); int i=0; while (i < 20000) { parm1.Value=i; parm2.Value="A"; cmd.ExecuteNonQuery(); i ++; } trn.Commit(); DateTime d2 = DateTime.Now; Console.WriteLine("Tiempo: " + TimeSpan.FromTicks(d2.Ticks - d1.Ticks).Minutes + ":" + TimeSpan.FromTicks(d2.Ticks - d1.Ticks).Seconds + " seconds"); } catch(Exception e) { Console.WriteLine(e.Message); } finally { conn.Close(); } } } } Tag: Bypass ADO Tag: 125518
  - 14
    - Adding additional ResultSets to an IDataReader Hello, I am using an object oriented approach that passes a datareader object from a parent object down to it's children. When I use this approach with MS SqlServer I just run a stored procedure that includes 2 select statements and use the DataReader.NextResult when I need to get to the second resultset. The problem is that for this project I am being forced to use a database which does not have the capability to return multiple resultsets via one hit to the database (Intersystems Cache database). Since I really don't want to have to change my framework model, I am looking for alternatives. What I have come up with as a possibility is; Create a custom DataReader object implementing IDataReader. My custom object should have a way to add resultsets. If I can do this, I will be able to make multiple calls to Cache (individual selects) and call a CustomDataReader.ResultSets.Add(<new datareader results>). That way, once it's populated I can use the datareader just as I always have using CustomDataReader.NextResult() to get to my data. I think I see a few different ways to do this, but I wanted opinion from others. I could internally store a List (Of DataReader) and then have nextresult iterate those ( remember I can only get 1 resultset back from the db per datareader). I could get the rows back and store it internally and iterate an internal list (read and store just the data), etc. Suggestions are welcome! Thanks for taking the time, sorry about the lengthy post. Jeff Tag: Bypass ADO Tag: 125515
  - 15
    - Populate DataTable rows as it come? when the connection is slow, or in some situation of heavy query, the Microsoft SQL server studio 2005 put first rows as it come, and continue execute query until end (I supposed it is done by cursor not by Top x ). this behavior well-known in cursor connection like old ADO. I look after example of code that make this for ADO.NET by populate Datatable by DataReader? Tag: Bypass ADO Tag: 125514
  - 16
    - DataAdapter,SQL Sp's and update Hello All, I hope that someone might be kind enough to take a look at the following code, I am a novice when it comes to VB .net, and am trying to grasp ADO .net and SQL server. I'm using VB .Net 2003 and SQL2005 Express edition, the Code Sample is mostly from David Sceppa's Microsoft ADO .net book. I have created the stored procedures that the code calls. The problem is that I end up with an error if I change the data in the data table and click the update button, "Update requires a valid UpdateCommand when passed DataRow collection with modified rows." I have been struggling with this for the past few days, any help would be greatly appreciated. Thanks Dave. -----Start Code ------ Imports System.Data.SqlClient Public Class Form1 Inherits System.Windows.Forms.Form Dim cn As SqlConnection Dim da As SqlDataAdapter Dim tbl As DataTable = GenTable() Private Sub SubmitChangesViaStoredProcedures() da.UpdateCommand = CreateUpdateViaSPCommand() da.InsertCommand = CreateInsertViaSPCommand() da.DeleteCommand = CreateDeleteViaSPCommand() End Sub Private Function CreateUpdateViaSPCommand() As SqlCommand Dim cmd As New SqlCommand("spUpdateDetail", cn) cmd.CommandType = CommandType.StoredProcedure Dim pc As SqlParameterCollection = cmd.Parameters pc.Add("OrderID_New", SqlDbType.Int, 0, "OrderID") pc.Add("ProductID_New", SqlDbType.Int, 0, "ProductID") pc.Add("Quantity_New", SqlDbType.SmallInt, 0, "Quantity") pc.Add("UnitPrice_New", SqlDbType.Money, 0, "UnitPrice") Dim param As SqlParameter param = pc.Add("OrderID_Orig", SqlDbType.Int, 0, "OrderID") param.SourceVersion = DataRowVersion.Original param = pc.Add("ProductID_Orig", SqlDbType.Int, 0, _ "ProductID") param.SourceVersion = DataRowVersion.Original param = pc.Add("Quantity_Orig", SqlDbType.SmallInt, 0, _ "Quantity") param.SourceVersion = DataRowVersion.Original param = pc.Add("UnitPrice_Orig", SqlDbType.Money, 0, _ "UnitPrice") param.SourceVersion = DataRowVersion.Original Return cmd End Function Private Function CreateInsertViaSPCommand() As SqlCommand Dim cmd As New SqlCommand("spInsertDetail", cn) cmd.CommandType = CommandType.StoredProcedure Dim pc As SqlParameterCollection = cmd.Parameters pc.Add("OrderID", SqlDbType.Int, 0, "OrderID") pc.Add("ProductID", SqlDbType.Int, 0, "ProductID") pc.Add("Quantity", SqlDbType.SmallInt, 0, "Quantity") pc.Add("UnitPrice", SqlDbType.Money, 0, "UnitPrice") Return cmd End Function Private Function CreateDeleteViaSPCommand() As SqlCommand Dim cmd As New SqlCommand("spDeleteDetail", cn) cmd.CommandType = CommandType.StoredProcedure Dim pc As SqlParameterCollection = cmd.Parameters Dim param As SqlParameter param = pc.Add("OrderID", SqlDbType.Int, 0, "OrderID") param.SourceVersion = DataRowVersion.Original param = pc.Add("ProductID", SqlDbType.Int, 0, "ProductID") param.SourceVersion = DataRowVersion.Original param = pc.Add("Quantity", SqlDbType.SmallInt, 0, "Quantity") param.SourceVersion = DataRowVersion.Original param = pc.Add("UnitPrice", SqlDbType.Money, 0, "UnitPrice") param.SourceVersion = DataRowVersion.Original Return cmd End Function Public Function GenTable() As DataTable Dim tbl As New DataTable("Order Details") Dim col As DataColumn With tbl.Columns col = .Add("OrderID", GetType(Integer)) col.AllowDBNull = False col = .Add("ProductID", GetType(Integer)) col.AllowDBNull = False col = .Add("Quantity", GetType(Int16)) col.AllowDBNull = False col = .Add("UnitPrice", GetType(Decimal)) col.AllowDBNull = False End With tbl.PrimaryKey = New DataColumn() {tbl.Columns("OrderID"), _ tbl.Columns("ProductID")} Return tbl End Function Sub LoadData() Dim strConn, strSQL As String strConn = "integrated security=SSPI;data source=XXXXAPTIVA;" & _ "persist security info=False;initial catalog=Northwind" strSQL = "SELECT OrderID, ProductID, Quantity, UnitPrice " & _ "FROM [Order Details] WHERE OrderID = 10503 " & _ "ORDER BY ProductID" cn = New SqlConnection(strConn) da = New SqlDataAdapter(strSQL, cn) cn.Open() da.Fill(tbl) Dim MyDv As New DataView(tbl) DataGrid1.DataSource = MyDv cn.Close() End Sub Private Sub btnLoadData_Click(ByVal sender As System.Object, ByVal e _ As System.EventArgs) Handles btnLoadData.Click LoadData() End Sub Private Sub btnUpDate_Click(ByVal sender As System.Object, ByVal e _ As System.EventArgs) Handles btnUpDate.Click SubmitChangesViaStoredProcedures() Try da.Update(tbl) Catch ex As System.InvalidOperationException MessageBox.Show(ex.Message) End Try End Sub End Class Tag: Bypass ADO Tag: 125512
  - 17
    - system.data.oracleclient: trouble in insert unicode values Hi everybody, I have one table in Oralce: tblUnicode (name nvarchar2(100)) When I insert a row with these code: string commandText = "insert into tblUnicode values(:1)"; OralceCommand comm = new OracleCommand(commandText, OpenedConnection); comm.Parameters.Add("1", OralceType.NVarChar,100).Value="Unicode String"; comm.CommandType = CommandType.Text; comm.ExecuteNonQuery(); => everything is ok. but, when I try to put value in the commandText: string commandText = "insert into tblUnicode values(N'Unicode String')"; OralceCommand comm = new OracleCommand(commandText, OpenedConnection); comm.CommandType = CommandType.Text; comm.ExecuteNonQuery(); => the value is inserted to Oracle database is not correct '?*^&#' Anyone knows why? Thanks Tag: Bypass ADO Tag: 125505
  - 18
    - Avoiding & when adding a JavaScript event handler using Attributes.Add() I add a JavaScript event handler to some of my Webcontrols using the Attributes.Add() method as follows: Dim jscode as String = "return (event.keyCode>=65&&event.keyCode<=90);" TextBox2.Attributes.Add("onKeyPress", jscode) You will notice that jscode contains the JavaScript Logical And operator (&&). However, ASP.NET renders this as && in the code that is output, even though it is intended to be client-side JavaScript, not a visible onscreen character. How can I get ASP.NET to output onKeyPress="return (event.keyCode>=65&&event.keyCode<=90);" instead of onKeyPress="return (event.keyCode>=65&&event.keyCode<=90);" I am using VB.NET to write my server-side code, and am using Visual Studio .NET 2003 with .NET 1.1. Thanks in advance for any help you can give. -- Nathan Sokalski njsokalski@hotmail.com http://www.nathansokalski.com/ Tag: Bypass ADO Tag: 125497
  - 19
    - Row index property in DataTable.Rows collection? This is a multi-part message in MIME format. ------=_NextPart_000_000F_01C63CB7.AA1F5660 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi,=20 I understand that a DataTable has a collection of Rows. If it is a = collection, why is there no obvious way to get an index property from = any given row? Example code: ... int myIndex; foreach (DataRow myDataRow in myDataTable.Rows) { // I need to get the zero-based index here: myIndex =3D myDataRow.index? ... } ... I don't know if an iEnumerator (or something like it) is required, or = how to use it because of my lack of experience in this area. Can anyone = help? Thanks! Bradley ------=_NextPart_000_000F_01C63CB7.AA1F5660 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.2802" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Hi, </FONT></DIV> <DIV><FONT face=3DArial size=3D2>I understand that a DataTable has = a collection=20 of Rows. If it is a collection, why is there no obvious way to get = an index=20 property from any given row?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Example code:</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>...</FONT></DIV> <DIV><FONT face=3DArial size=3D2>int myIndex;</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>foreach (DataRow myDataRow in=20 myDataTable.Rows)</FONT></DIV> <DIV><FONT face=3DArial size=3D2>{</FONT></DIV> <DIV><FONT face=3DArial size=3D2>    // I need to get the = zero-based=20 index here:</FONT></DIV> <DIV><FONT face=3DArial size=3D2>   myIndex =3D=20 myDataRow.index?</FONT></DIV> <DIV><FONT face=3DArial size=3D2>...</FONT></DIV> <DIV><FONT face=3DArial size=3D2>}</FONT></DIV> <DIV><FONT size=3D3><FONT face=3DArial size=3D2>...</FONT></FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT size=3D3><FONT face=3DArial size=3D2>I don't know if an = iEnumerator (or=20 something like it) is required, or how to use it because of my lack of=20 experience in this area. Can anyone help?</FONT></FONT></DIV> <DIV><FONT size=3D3><FONT face=3DArial size=3D2>Thanks!=20 Bradley</FONT></DIV></FONT></BODY></HTML> ------=_NextPart_000_000F_01C63CB7.AA1F5660-- Tag: Bypass ADO Tag: 125496
  - 20
    - OleDBDataAdapter update and getting original DB values After update some modified data using an OleDBDataAdapter's Update method, if there are concurrency exceptions, is there any way to get at the values that are currently in the database without having to do another trip to the database or calling OleDBDataAdapter.Fill? I thought that having the adapter's Update command's UpdateRowSource enum set to Both would return the current (in DB) values in the dataset but the dataset only ever seems to have the Original (in the dataset) and Curent (user modified) values. Tag: Bypass ADO Tag: 125492
  - 21
    - ado.net/sql rpoblem Additional information: Cannot change ReadOnly property for column Expresion. This is an error I got. I made three alias field and and I want to fill them with textBox(ReadOnly) values. with method NewRow I tried to add new rows with string values but I got this message above. What should I do? Thanks a lot, Ivan novice Tag: Bypass ADO Tag: 125491
  - 22
    - XML string to ADODB.Recordset? I have a function that returns an XML string that represents a Recordset. Is it possible to use this string to populate an ADODB.Recordset and, if so, how? -- Richard Lewis Haggard www.Haggard-And-Associates.com Tag: Bypass ADO Tag: 125487
  - 23
    - Join Two datasets Hello All, I have a dataset that I populate using a SQL Server database, and the second one that I populate using a mySQL Server database, I need to combine the results in memory and then sort them, how do I go about doing that ? This is a search query, so I do not want to create another temp table to do this, any idea's please. Imran. Tag: Bypass ADO Tag: 125486
  - 24
    - TableAdapter Fill() returns SQL syntax error for data type bit Hi, When calling the Fill() method for a TableAdapter I get the following error: "syntax error converting the varchar value 'TRUE' to a column of data type bit" The typed DataSet to be filled maps the SQL bit columns to a System.boolean column ('TRUE' instead of 1). Any workaround for this? Thanks, -Ronen Tag: Bypass ADO Tag: 125474
  - 25
    - How to make a hierarchical XML There are four areas in my compays, every employees in my company have his duty area. I use a select join statement to make a view form Area and Employee table like below.. I want to make a hierarchical XML form the view. The XML is like below Area Employee ---------------------------------------- North Mary North John North Max East Kai West Jina West John South Tim South Peeer <?xml version="1.0"?> <AreaEmployee> <Area> North <Employee> Mary </Employee> </Area> <Area> North <Employee> John </Employee> </Area> <Area> North <Employee> Max </Employee> </Area> <Area> East <Employee> Kai </Employee> </Area> <Area> West <Employee> Jina </Employee> </Area> </AreaEmployee> Tag: Bypass ADO Tag: 125471

Hi all,

out of curiosity, is there a way to bypass ADO completely and talk
directly to SQL Server? Do I have to step in the unmanaged world or can
I still achieve it from C#?

Thanks,
Lorenzo

Top

Re: Bypass ADO by David

David
Fri Mar 03 22:21:56 CST 2006

<lbolognini@gmail.com> wrote in message
news:1141444941.872608.195050@e56g2000cwe.googlegroups.com...
> Hi all,
>
> out of curiosity, is there a way to bypass ADO completely and talk
> directly to SQL Server? Do I have to step in the unmanaged world or can
> I still achieve it from C#?
>

The low-level interfaces to SQL Server are in the System.Data.SqlClient and
System.Data.SqlTypes namespaces. Technically these are part of ADO.NET, but
you can bypass DataSets and avoid (or control) the translation of data from
SQL Server types to CLR types by working directly with the types in those
namespaces.

There is no unmanaged library that offers better or more direct access to
SQL Server than these.

David

Top

Re: Bypass ADO by lbolognini

lbolognini
Sat Mar 04 20:01:01 CST 2006

David Browne wrote:

> The low-level interfaces to SQL Server are in the System.Data.SqlClient and
> System.Data.SqlTypes namespaces. Technically these are part of ADO.NET, but
> you can bypass DataSets and avoid (or control) the translation of data from
> SQL Server types to CLR types by working directly with the types in those
> namespaces.
>
> There is no unmanaged library that offers better or more direct access to
> SQL Server than these.

Thanks David, much clearer now.

Lroenzo

Top

Re: Bypass ADO by Sahil

Sahil
Sun Mar 05 02:56:35 CST 2006

You could technically use the TDSParser internal class, if you really really
needed super custom code. For instance, if you needed to implement
UpdateBatchSize in your own business objects - not just DataAdapter, thats
how you'd do that.
But for 99.99% tasks, SqlCommand is as close to the metal as you'd want to
be.

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx
__________________________________________________________

<lbolognini@gmail.com> wrote in message
news:1141524061.929372.170760@i40g2000cwc.googlegroups.com...
>
> David Browne wrote:
>
>> The low-level interfaces to SQL Server are in the System.Data.SqlClient
>> and
>> System.Data.SqlTypes namespaces. Technically these are part of ADO.NET,
>> but
>> you can bypass DataSets and avoid (or control) the translation of data
>> from
>> SQL Server types to CLR types by working directly with the types in those
>> namespaces.
>>
>> There is no unmanaged library that offers better or more direct access to
>> SQL Server than these.
>
> Thanks David, much clearer now.
>
> Lroenzo
>

Top