Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Deployment + Vista
Steven Spencer (Spinalogic) - 10 Mar 2007 1:25 AM - 9 messages
We use strongly typed datasets, and thus our connection string is bound to an application setting. Currently we can deploy and alter the app.exe.config file at installation time to successfully install, and use some basic XML editing to allow the ...
Score Writing xml file from dataset different than the original
Bmack500 - 9 Mar 2007 9:07 PM - 5 messages
Hello all. I'm reading the data from an XML file similiar to below, using the code below. When the file is edited in the datagridview and then re-written, it doesn't write the xml file as it was originally written. ...
Score Insert a whole datatable
Q. John Chen - 9 Mar 2007 5:32 PM - 3 messages
I have two access database (with identical schema). One is the master and the other is SHOULD be a subset of master data (Let call them MasterDB and SubDB The user enters data into the SubDB and I need to bring the new ...
Score Eliminating CRUD procedures
Colin Robinson - 9 Mar 2007 3:08 PM - 17 messages
Your know the ones, you have a table and it  has  Create,Read,Update and Delete Stored procedures and the app always uses these to talk to the DB eliminating dynamic sql in your apps. Makes perfect sense when you have a table however when you have 500 tables ...
Score Some ADO.NET Mobile Advice please.
iKiLL - 9 Mar 2007 10:14 AM - 4 messages
Hi all I am building an Windows Mobile 5 forms control in C#, for a Windows Mobile 5 application. I am using CF2.0 and SQL Mobile 2005. The control is a Questions and answer control. Basically I have 3 applications using the same code to dynamically display ...
Score Datatable
meka - 9 Mar 2007 5:59 AM - 4 messages
For i = 0 To dtSubOpt.Rows.Count - 1    intOptNo = dtSubOpt.Rows(i)(1) strSelectSubOpt = "select tblOptions.strOptName as OptionName,tblOptions.intParent ,tblMOMT.strMOTag as MessageSentFromServer,tblMOMT.strMTTag as MessageSentToServer from tblOptions  inner join tblMOMT on tblMOMT.intOptId=tblOptions.intOptId ...
Score Problem saving 24 hour date/time in SQL
JL - 8 Mar 2007 6:34 PM - 3 messages
I have an SQL table(MS SQL 2005) with a field called SignInDate and have created this as DateTime. When I save the current time using the Now function, it does not save the value in 24 hour format. For example, if it is 2:15:36 PM (i.e. 14:15:36) it saves the value in ...
Score SQLBulkCopy and SQL Server 2000?
Spam Catcher - 8 Mar 2007 5:04 AM - 3 messages
Hi all, Does .NET 2.0's SQLBulkCopy class work with SQL Server 2000? Thanks! ...
Score Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services
Se0 Guy - 8 Mar 2007 4:08 AM - 1 message
Search Engine Optimization [link] Seo Optimization , Semantic Results, Artificial intelligence in Search, Auto Content Generators, Search Engine Results. SEO optimizer. SEO consulting ...
Score how does ado.net SqlDataReader.GetString() know which encoding to read the data into a string as? Do
Daniel - 7 Mar 2007 11:15 PM - 1 message
how does ado.net SqlDataReader.GetString() know which encoding to read the data into a string as? Does sql sever set this at the column data type level, server wide encoding setting, os encoding? ...
Score Using Sql2005's OUTPUT
Arthur Dent - 7 Mar 2007 10:45 PM - 2 messages
Hello all... Here is what i want to do (in VB code)... <code> Dim SQL As String = "SELECT ROWID FROM (INSERT INTO STATIC_CONTENT (NAME, CONTENT) OUTPUT INSERTED.ROWID SELECT 'Contact Us', '') SRC" Dim newId As Integer myDbObject.ExecuteScalar(SQL) ...
Score PARSE a Blank Space???
Brad Isaacs - 7 Mar 2007 10:29 PM - 2 messages
Using ASP.NET 2.0 with SQL Server 2000 Inside my dropdown list box I am using an SQL DataSource to select the following data SELECT RTRIM(c.Name_First) + ' ' + RTRIM(c.Name_Last) AS Contact,                             c.phone As PriPortPhone ...
Score Dynamic access to DataTable during DataAdapter.Fill
Andrew - 7 Mar 2007 8:51 PM - 2 messages
Hello, Does anyone know if its  possible to access the row/column values of a DataTable while a DataAdapter is filling the table? Maybe using a new thread? I am currently trying to use a seperate thread for access while the main ...
Score can I alias an ADO.Net table (tablename)?
Rich - 7 Mar 2007 8:51 PM - 2 messages
Greetings, Is it possible to alias an ADO.Net table?  I have this one table that has a pretty long name dsDataEntry.Tblsomebigtablename.  I tried Dim dt As DataTable = ds...Tbl... Welll, that created table dt, but it did not populate the table.  I guess I ...
Score UPDATE a DropDownList box~ HElp Please
Brad Isaacs - 7 Mar 2007 8:41 PM - 2 messages
Using ASP.NET 2.0 with SQL Server 2000 Inside my dropdown list box I am using an SQL DataSource SELECT RTRIM(c.Name_First) + ' ' + RTRIM(c.Name_Last) AS Contact,                             c.phone As PriPortPhone ...
Score Parameterized query problem using Access Database in VS.NET2005
JohnAdams - 7 Mar 2007 7:22 PM - 8 messages
New to the VS.NET 2005 and I am writing a program using an access database as the datasource in visual studio.NET 2005   The problem I have is I am trying to write a parameterized query where a wildcard can be used to pull a ...
Score problem with Ole DB on Windows XP
Nadav Popplewell - 7 Mar 2007 1:41 PM - 3 messages
Hi Everybody, I've got a strange problem on one of our clients computers: I've got a dotnet 1.1 application that connects to a database using .Net OleDB provider for Visual FoxPro. On most of our clients' computers everything works as expected, ...
Score Please HELP!!!!
SISTEC - 7 Mar 2007 12:23 AM - 3 messages
Hi, I have this problem, I do an update to VFP table, using oledb all works fine while I run the asp net application from visual net IDE when I close the IDE (same computer) and open explorer to run the ...
Score Confused a bit...
Admin - 6 Mar 2007 10:23 PM - 1 message
<HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft DHTML Editing Control"> <TITLE></TITLE> </HEAD> <BODY> <P>I tried this out, I was hoping I could get another say. I ...
Score Date and Time field concatination
Joe - 6 Mar 2007 9:56 PM - 9 messages
I have field with a Date and a field with a Time; is there anyway to make a complete DateTime using an expression in ADO.NET? I don't have an option to do this in a database before getting the data into ...
Score Stored procedure returns two result sets
Ken VdB - 6 Mar 2007 9:35 PM - 2 messages
Hi everyone, I have a stored procedure called 'PagingTable' that I use for performing searches and returning just the results for the current 'page'.  That way I can do my paging on the server and only the data that actually gets ...
Score How to cancel execution of an asynchronously executing SqlCommand?
Henrik Dahl - 6 Mar 2007 9:04 PM - 4 messages
Hello! ADO.NET 2.0 offers the possibility to execute SqlCommands asynchronously, for instance SqlCommand.BeginExecuteReader. Let's assume it takes quite some time to execute such an SqlCommand. Is there a way to cancel the execution of an SqlCommand executing in this asynchronous manner? ...
Score System.Data.OracleClient InvalidOperationException on Inline queri
de_guinsa - 6 Mar 2007 8:49 PM - 1 message
I'm using ADO.Net (Framework 1.1) against an Oracle database. I need a resolution to the inline query problem posted at [link] It appears that someone from the ADO.Net team(Alazel Acheson) posted a bug ...
Score Create new table in DataSet
Peter A - 6 Mar 2007 4:05 PM - 8 messages
I have a DataSet that contains one table. I want to create two new tables each of which contains all the rows but only some of the columns from that first table. Can I do this without going back to the original ...
Score index to foxpro files
ray well - 6 Mar 2007 4:01 PM - 1 message
i need to access a legacy database that uses dBase files running under foxpro for read only purposes, within net 2.0, ado 2.0 using vb and sql statements. i have no problem getting the info i need, but it is very slow. ...
Score Updateing event of datagridview
abhya - 6 Mar 2007 8:02 AM - 1 message
I m using the datagridview. Except Update event rest of the all i.e. Edit cancel, delete. I want to read the cell content . if its a Quantity user may change it so tht bases on tht i m going to calculet the price. ...
Score ^*^*^^*^*^*^^*^*^ Microsoft Vista ^*^*^^*^*^*^^*^*^*^^*
Deep Six - 6 Mar 2007 3:01 AM - 1 message
1.01 million is perfect I need the land , I will bleed purple in july and christ help me you hang me out on this one I will do myself. [link] ...
Score Economic
Harboured Criminal - 6 Mar 2007 2:23 AM - 1 message
Abuiltcomputer to go public soon Fundamentalist [link] Do you want money or love I got both. ...
Score Filling tableadapaters in master/child dataset
Flomo Togba Kwele - 6 Mar 2007 2:16 AM - 9 messages
I have defined a strongly-typed dataset with two tableadapters in a master/child relationship. On the master tableadapter, there is a parameter which restricts the fill of the tableadapter to less than the entire contents of master table. After filling the master table, do I simply fill the child tableadapter with a ...
Score DataAdapter.Fill, ConstraintException, and Primary Keys
Caitlin - 5 Mar 2007 11:01 PM - 1 message
I am running into ConstraintExceptions with the following VB.NET code:   Dim daResult As SqlDataAdapter = New SqlDataAdapter   Dim Result As DataSet = Nothing   [code to set up the data adapter with a stored procedure, parameters, connection, etc.]   daResult.MissingSchemaAction = MissingSchemaAction.AddWithKey ...
Score FXCop and Asp.net sample programs
Nick nkw - 5 Mar 2007 9:17 PM - 2 messages
I tried to use FxCop on the sample of [link] And I got the following error. Basically the code defined a member with type of TableAdapter and no Disposable method is defined. It sounds it's not ...
Score Strange Dataset update problem passing to Webservice
Neil.Smith - 5 Mar 2007 12:39 PM - 3 messages
I've encountered a strange problem when trying to update data in two tables using a dataset.  My application is split between a client (presentation) and webservice (business and DAL). I have a typed dataset, HSEDataset, containing two tables related by a ...
Score DataAdapter.Fill very slow with SqlParameters?
Jonas Knaus - 5 Mar 2007 12:34 PM - 3 messages
Hi there I found a starnage behavior. I have a method 'GetDataFromDB', which i use internaly in my class to get data from the db. Now if i build the query using SqlParameters for the date my query takes up to 60 sec vs. 2 sec if I ...
Score Does DataSet.Copy() remove event handlers?
Bjørn Terje Svennes - 5 Mar 2007 12:14 PM - 1 message
I'm wireing some event handlers to tables in a DataSet. This is performed in EndInit(). Everything works well untill I use the Copy() method of the DataSet class. I see that the EndInit is run for the copy, so that the event ...
Score SqlParameter slower in combination with DataAdabter.Fill method???
Jonas Knaus - 5 Mar 2007 12:13 PM - 2 messages
Hi there I found a starnage behavior. I have a method 'GetDataFromDB', which i use internaly in my class to get data from the db. Now if i build the query using SqlParameters for the date my query takes up to 60 sec vs. 2 sec if I ...
Score Closing Jet Database seems unreliable
Heinz Kiosk - 5 Mar 2007 9:48 AM - 12 messages
I am having difficulty getting Jet databases to close by calling the DbConnection.Dispose method. The method seems to work, and the connection state changes to closed, but about 25% of the time at some level the process is keeping hold of the connection, and not deleting ...
Score Cannot update the cursor mytable, since it is read-only
SISTEC - 5 Mar 2007 4:07 AM - 1 message
Hi, When I test my application inside the visual studio net, all works fine, but as soon I close IDE and test in this way: http://localhost/myapp/default.aspx the application open, but at time I try to update I get this error ...
Score import large text file
mfrsousa - 4 Mar 2007 9:10 PM - 23 messages
hi there, i have a huge large text file (350.000 lines) that i want to import to a MS Acccess Database, of course i don't want to use Access, but do it with C#. i already have tried the AddRow method or Insert, reading each line of ...
Score CSV (from URL) to DataSet ?
Yannick Létourneau - 4 Mar 2007 7:51 PM - 3 messages
I want to pull some data from a CSV URL (from yahoo's website) directly into a DataSet.  Is there a way to do this without having to save the CSV file on disk ? Thanks, Yannick L. ...
Score Select query question
John - 4 Mar 2007 6:01 PM - 6 messages
Hi I am using below query to retrieve records from backend sql server 2005 db; SELECT     ID, Company .... FROM         tblClients WHERE     (Status = @status) Problem is that sometimes I need all records regardless of what is status. ...
Score Enterprise Library and Access databases
nostradumbass77 - 4 Mar 2007 10:35 AM - 1 message
Using Enterprise Library 2.0 (Jan 06) and .NET 2.0 (VB.Net 2005) Dim dbPF As Data.Common.DbProviderFactory         Try             dbPF = ...
Score Update and delete sql not generated by wizard
John - 4 Mar 2007 2:26 AM - 8 messages
Hi In my vb winform data app with sql server 2005 backend, when in dataset I run the data adapter configuration wizard it generates insert and select sql statements but not delete and update. As a result the data is not updated ...
Next »