Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Unicode with SQL Server
Hamilton Colyer-Long - 29 Sep 2007 1:51 PM - 2 messages
Hi all, I have a TableAdapter with a connection to an SQL Server database that uses stored procedures to insert and update records. Problems occur when I attempt to insert unicode (Chinese) characters in the database; all that comes through is question marks. The parameter to insert the string with ...
Score Strongly typed dataset problem in a mobile form
Tony Staker - 28 Sep 2007 10:13 PM - 2 messages
I'm new to mobile app development so I'm going through Glen Gordon's on-demand webcast series "Mobile Web Development with ASP.Net 2.0"  Using VS2005 I created a mobile app, a connection to Northwind and a dataset named ...
Score ASA9 dbengine in VB.net
Vanny - 28 Sep 2007 8:15 PM - 1 message
I'm using this piece of code to registrer the ASA9 database in VB.net: Dim DbEngine As New DAO.DBEngine DbEngine.RegisterDatabase("Mydb", "Adaptive Server Anywhere 9.0", True, strAttributes) How to write it using ADO.net instead of DAO. ...
Score Question about connecting client programs to Sql server 2005 running on local area network
ali - 28 Sep 2007 7:19 PM - 3 messages
I have a program that has hand written database connections and DataGridView that connects to my database on sql server using computer's name .this works fine locally BUT problem occures when running my app on local area network causes this exception ...
Score Filtering DataSets for Reporting Application
Need2CSharp - 28 Sep 2007 6:17 PM - 2 messages
Hi All, I'm working on reporting (web) application for my company that displays order information.  It has approximately 15 - 20 different filter options so that various departments can extract data they need to view.  I'm using a normalized, relational MSSQL 2005 database, ...
Score How to run multiple SQL Scripts from VB.net (Application_Start method in Global.asax)
gamesforums - 28 Sep 2007 4:23 PM - 2 messages
Hi Everyone! I work in a company that has developed several VB.Net Web applications. Currently we use SourceGear's Vault for source control and versioning for the application files. One area that have been left behind a little bit is the version control on database level. Our ...
Score Accessing legacy data for a web application
JL - 28 Sep 2007 2:59 PM - 2 messages
Not sure where to post this, so will start here... I am developing an web application that my company will host. The data back end on the web wil be SQL server. For each customer that subscribes to our product, I need to build a data bridge from their ...
Score Easy Question - Oracle Ref Cursors
Knickerless Parsons - 28 Sep 2007 12:25 PM - 2 messages
Afternoon all, Just after confirmation that I can read from an oracle ref_cursor using the Microsoft data connector supplied with Visual Studio 2005 rather that having to get oracles latest ODP offering. Reading other posts here it seems to imply I can but I just need ...
Score update dataset
antonello - 28 Sep 2007 12:20 PM - 3 messages
Hi to all, I've a sqlserver 2005 database and an application developed with vb.net 2005. To manage data I used typed datasets created by the wizard. Now I need to change the data type of a db field from interger to floating. ...
Score Show data from a SqlConnection and a OleDbConnection in one table
Torben Laursen - 28 Sep 2007 10:09 AM - 3 messages
Hi I have some data in a access database and some in a sqldatabase. Both us the same index. I can connect to both and display the results. However now I would like to pick 2 columns from each and show the 4 columns ...
Score RE: KB928365 and 'Internal .Net Framework Data Provider error 6' issue
Jason Coombes - 28 Sep 2007 9:09 AM - 7 messages
We have been experiencing the exact same issue and currently have an open support ticket with Microsoft to try and resolve the problem. Interestingly, if you check the application event logs on the failover sql server you should see an event like this (at the exact time of the .Net error ...
Score Best way to handle multi field queries
Bill Gower - 27 Sep 2007 10:10 PM - 3 messages
I am currently reevaluating how I do look ups and searches.  What is the best method for handling forms where user can search by different criteria. Example, A member form allows users to look up a member by either SSN, ...
Score Maybe dumb questions, but what is DataDirectory?
bz - 27 Sep 2007 9:17 PM - 4 messages
Hi, I developed several NET applications with SQL server and Access databases, and I feel really stupid asking this question, but everytime I used SQL database name in connection strings or I used a connection string with placeholders for Access databases, and I ...
Score TransactionScope vs DAAB DbTransaction
rmgalante - 27 Sep 2007 8:04 PM - 1 message
I have a web application running on a web farm with a separate database server. I use DAAB in my business objects to update with the database. I was using TransactionScope around two or three business object updates. All business objects use the same db connection. But ...
Score Re: TDS and character encoding
bzh_29 - 27 Sep 2007 3:54 PM - 6 messages
raymond_b_jime***@yahoo.com a écrit : Hi, I've exactly the same trouble ... My apps is responding fine on a LAN but when I goes on a WAN, getting horrible ! network usage with network analyser and find the same result a you ! ...
Score "DataTable.CaseSensitive" problem
MikeP - 27 Sep 2007 2:26 PM - 1 message
Hi there, Can anyone explain why I should get the following error when creating a "Relation" between two tables in Visual Studio: "Cannot add a DataRelation or Constraint that has different Locale or CaseSensitive settings between its parent and child table" ...
Score Detecting BindingSource "row deleted" event
Tomasz J - 27 Sep 2007 1:50 PM - 8 messages
Hello Developers, I have a DataGridView and BindingNavigator controls bound to a BindingSource control. User can delete a record using different methods: by pressing the DEL key, pressing BindingNavigator Delete button. I may also want to add some other methods calling BindingSource.RemoveCurrent(). ...
Score example of Inserting and Retrieving data from xml file
hanusoft - 27 Sep 2007 12:49 PM - 2 messages
This is an example of Inserting and Retrieving data from xml file. [link] private void Page_Load(object sender, System.EventArgs e)         {             // Put user code to initialize the page here ...
Score How to access an SQL function via .NET DataAdapter?
Dick Swager - 26 Sep 2007 11:19 PM - 4 messages
Is there a way to use a DataAdapter to retrieve data via an SQL function?  I have done what I need to do using a stored procedure that returns a 1x1 table, but it seems like it would be much cleaner if the single value ...
Score DataContract question
WebBuilder451 - 26 Sep 2007 3:30 PM - 4 messages
I do not really understand this concept if it is a concept. I've heard of it in relation to MCF, but it seems that it is refered to as if it is more of a concept. Can any one explain what a DataContract is or where i can find a ...
Score sqlbulkcopy and total rows inserted.
Archana - 26 Sep 2007 3:10 PM - 2 messages
Hi all, i am using sqlbulkcopy to insert content to table, how will i get total rows inserted into table without using any eventing. and is it possible to do bulk copy from sql table to csv file? thanks in advance. ...
Score Transaction Scope and DTC Configuration
Blezoo Varghese - 26 Sep 2007 2:14 PM - 1 message
Hello We are trying to use the Transaction Scope for our distributed transaction application. But we were unable to use it since the MS DTC is not configured properly(may be). We need some help or guidance to make this happen. ...
Score Transaction Scope and DTC Configuration
Blezoo Varghese - 26 Sep 2007 2:10 PM - 1 message
Hello We are trying to use the Transaction Scope for our distributed transaction application. But we were unable to use it since the MS DTC is not configured properly(may be). We need some help or guidance to make this happen. ...
Score Enterprise Library 3.1 Data Access Application Block Connection St
Patrick - 26 Sep 2007 12:00 PM - 2 messages
Using .NET 2 with the above. Instead of doing Database myDB= DatabaseFactory.CreateDatabase("myDBNameDefinedInConfigFile"); to connect to an Oracle 10g database How can I programatically set the UserID and password (which I take from the User Interface) at run time? ...
Score Jet database engine could not find the object 'Expr...'
Orgil - 26 Sep 2007 8:54 AM - 4 messages
I have been connecting to MS-Access database using Jet 4.0 from C#.NET. My application works finely on my computer on which I've made the application. But I observed a strange behavior. When I run my application on other ...
Score How to find the databases on a server
Dom - 25 Sep 2007 5:45 PM - 7 messages
I'm trying to write an all-purpose program that will: 1.  list all the servers on the network. 2.  list all the databases on any one server once it is clicked. 3.  list all the tables in a database once it is clicked. ...
Score SQL server vs mySQL ???
calderara - 25 Sep 2007 2:02 PM - 6 messages
Dear all, I am buidling application where most of my back end database is SQL server. Now I have a set of customer requesting for instance to use mySQL instead of SQL server. They are many programming language as many database product, so knowing them ...
Score do release builds have the same amount of info in exceptions? e.g. will exceptions cought in release
Daniel - 24 Sep 2007 11:00 PM - 2 messages
do release builds have the same amount of info in exceptions? e.g. will exceptions cought in release builds contain stack trace etc.? ...
Score Would you like to have access contents about .net totally free?
Jeff - 24 Sep 2007 6:57 PM - 1 message
Would you like to  have access contents about .net totally free? Enter right now in [link] and get to know our content on net totally for FREE! Here you find articles, tips and many video tutorials. ...
Score "'System.DBNull' is a 'type', which is not valid in the given context" - aka what type is DataRow co
mark4asp - 24 Sep 2007 3:00 PM - 3 messages
'System.DBNull' is a 'type', which is not valid in the given context If dr["OfficeName"] is not an object then what is it?  It is certainly not a string because it hasn't yet been cast as one. ...
Score Command timeout in MS DAAB
jzogg7272 - 24 Sep 2007 1:43 AM - 1 message
I am using SqlHelper from the MS Data Access Application Block and the stored procedure I am calling takes about 1 minute to execute. Therefore, a command timeout occurs because the default timeout value is 30 seconds.  Since the Command object is created in the Application ...
Next »