Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Connect to SQL Server Remotely but not Locally
DragonslayerApps - 11 Nov 2006 8:37 PM - 2 messages
I'm so stumped by this one that I don't even know where to begin looking. I have recently created two ASP.Net 2.0 web applications. They work together with a SQL Server 2000 database. IIS & SQL Server reside on ...
Score Reading from an excel worksheet
Kaustav - 11 Nov 2006 1:36 PM - 2 messages
Hi, I am facing a peculiar problem with Excel Automation. I have a winform where in I display some data in OWC axSpreadsheet. Next I export this data to an ..xls file. When I try to open (through OleDb) and read this file, I get an ...
Score inserting string into excel table limited to 255 kar??
Britt - 11 Nov 2006 9:51 AM - 3 messages
Hi, Maybe not the right newsgroups, but it's excel and ado.net, so .... I insert strings into an excel table usind ado.net like: Dim oConnection As OleDbConnection         Dim sConnectionString As String ...
Score How to do a record lookup with mutiple datareaders ?
Gordon - 11 Nov 2006 5:14 AM - 4 messages
Hi; Why don't I get the data rows that I want when I nest two data readers ? I have two connections and I execute two reads one nested inside the other. I am trying to use the key fields of the outer read/TABLE  to look up ...
Score Reason: Not associated with a trusted SQL Server connection.
Sehboo - 11 Nov 2006 4:31 AM - 2 messages
My database is running on a seperate machine and my connection string is "user id=cc;data source=Custom;initial catalog=Dev;password=cc".  I backed and restored the database on my local machine and changed the connection string to this: "user id=cc;data source=(local);initial ...
Score Rolling back an insert
Ant - 11 Nov 2006 4:31 AM - 2 messages
VS2003, C# Hi, I am adding rows into a parent & child tbl. First the parent tbl, then the child.  I have a list box & datagrid bound to a dataset displaying parent/child rows. Both row adds are nested in a transaction. Within the ...
Score Testing app with Typed Datasets using Test & Production databases
JeffDotNet - 10 Nov 2006 9:55 PM - 3 messages
I am using typed datasets in a forms application.  I would like to use one typed dataset to run my application against my test database.  Then when I’m ready to release it I would like to point the typed dataset to the production ...
Score Using FillSchema and then dt.NewRow(), but I don't get any column default values...
0to60 - 10 Nov 2006 9:02 PM - 2 messages
Almost all of the tables in my SQL 2005 database have a dteCreated DateTime field to track when the row was first added.  Its a non-nullable field, and the default value is set to T-SQL's GetDate() function. ...
Score Disconnected model - high memory cost
Gilles Plante - 10 Nov 2006 7:42 PM - 11 messages
Hi all, I am worrying a bit about the disconnected model, using drag 'n drop approach. Fine, it generates code for me, but it looks to be very expensive regarding memory. I started and application and had a look at it. When the ...
Score Binding Format, Parse and Validating Events
Joe - 10 Nov 2006 6:57 PM - 4 messages
Is there anyway to use all 3 of these together? Since Parse doesn't get called till after Validating I have no way of doing a proper validation without Parsing the data manually in the Validating event which sort of ...
Score Oracle DELETE SP for DataAdapter.Update??
jmb - 10 Nov 2006 4:40 PM - 1 message
..Net v1.1 Im trying to get a stored procedure for a DELETE operation to work with DataAdapter.Update(). I keep getting concurrency exceptions because the affected row count is 0. How can I get a rowcount of 1 from my stored proc to the DataAdapter? btw Im using BDP.NET provider. Its very similar to any other. ...
Score DataAdapter.Update PB with a new database
bp - 10 Nov 2006 9:59 AM - 1 message
Hi, I have a auto-generate DataSet ()with menu "Add new DataSource...") with two DataTables, parentTable and childTable, and a relation between them. I fill these two tables with five records, then try to update database with these records, using the autogenerate parentDataTableTableAdapter and ...
Score Getting a custom table based on DB data
Malhavoc - 10 Nov 2006 8:18 AM - 6 messages
I have a table in the Access DB which is structured this way: ITEMID FIELDNAME FIELDVALUE The Key is ITEMID,FIELDNAME I need such a configuration because the items I need to store can have whatever fields the user could like. A simple example of the data ...
Score Column index vs column name
S. Daum - 9 Nov 2006 10:01 PM - 11 messages
When using an in memory DataTable or a DataReader has anyone tested if there is a performance difference between using the column index vs the column name to address specific columns in a row? In my application, there might be ...
Score how to create a table programmatically in excel?
Britt - 9 Nov 2006 9:00 PM - 3 messages
Hi, I want to create a table programmatically in excel. How can o do this ("create table ....")?? And then, how to put it in specific cells in the worksheet, and possibly put it into sheet2 of the same worksheet? Thanks for gelp ...
Score how to create a table in excel?
Britt - 9 Nov 2006 8:56 PM - 2 messages
Hi, I use this connection string to connect to excel: ConnectionString="Provider = Microsoft.Jet.OLEDB.4.0; Data Source = c:\\excel\mydb.xls; Extended Properties=Excel 8.0;" Doing this, it accesses the table in sheet1: sql = "select field1 from ...
Score Batch update optimization
Arne Garvander - 9 Nov 2006 6:11 PM - 4 messages
I am trying out batch update in Ado.Net. SqlCommand cmd = new SqlCommand(); cmd.commandtext = "update...;update...'"; I put semicolon between each update. I have thousand of records to update. What would be an optimal number of updates to do in one statement? ...
Score DataSet vs Custom Business Objects from performance perspective
Maxwell2006 - 9 Nov 2006 4:56 PM - 2 messages
Hi, Is there any article that compares the performance difference between using DataSet and custom business objects? We are developing a high traffic web site and we are thinking to avoid using dataset because of performance overhead. We need some whitepapers or ...
Score ORA-24338 and REFCURSOR
dave_93_98 - 9 Nov 2006 4:20 PM - 2 messages
I am receiving the above error (ORA-24338 statement handle not executed) when an exception is thrown from the stored procedure I am calling. One of the arguments to this procedure is an output parameter containing a refcursor, which I suspect is the problem. Has anyone else ...
Score to sqlDataSource or not - scenario
djc - 9 Nov 2006 3:03 PM - 3 messages
1) I am wondering if I should be using an sqlDataSource object for my particular scenario. I need to loop through a listbox and perform an INSERT sql operation for each item. Could be a few or several items. The reason I'm ...
Score Dataset clear and refill problem
BVA3105 - 9 Nov 2006 2:44 PM - 2 messages
I have  a probleme with a dataset in a VB.net Form when i want to clear and refill a dataset i have to wait 3 seconds to have the updated values. If i don't wait for this time, i have always the old values. ...
Score what to actually do on dbconcurrency exception?
jarb - 9 Nov 2006 12:43 AM - 2 messages
..Net v1.1 If I get a dbconcurrency exception during a DataAdapter.Update() call what should I actually do to continue the update? I would like to give the user 2 options. Cancel the update, and get the server's most recent values overwriting ...
Score C# SQLConnection Issues
saidin69@hotmail.com - 9 Nov 2006 12:02 AM - 1 message
Hi all. I have created a Library in C#.  This library uses the SQLConnection object to connect to a database.  Everything works fine in a .NET app. If I compile the library using a strong name key, register it on the ...
Score sqlDataSource parameters question
djc - 8 Nov 2006 10:44 PM - 4 messages
I am playing with the (new to me) sqlDataSource class. I used it to bind data from a database table into a listbox with no code, worked great. Now I need to do an INSERT for every item in a listbox. I used to just code the ...
Score DataBinding and Dataset
BVA3105 - 8 Nov 2006 9:55 PM - 1 message
I have a problem with my Dataset. When i want to refill this dataset, i retreive always the old values. see the following code: MyDataset.MyTable.Item(Position).Tarif = "MD4"          ' Update the field ...
Score Stongly-typed DataSet & Relationships
Kyle K. - 8 Nov 2006 9:48 PM - 2 messages
I'll put what I'm trying to accomplish in the context the Northwind Database. I have a DataSet defined in my application (NorthwindDataSet), that has the Customers, Orders, & OrderDetails tables defined within it. I need to create a new Order record, that has several OrderDetails ...
Score Invalid Column on Update on table with extra column
sutphinwb@nospam.nospam - 8 Nov 2006 8:30 PM - 2 messages
Hi I am trying to update a dataset table that I have added a column to that is not in the database.  I load the column in the table RowChanged event.  I don't want the column to be updated along with the rest of ...
Score How do you export table data in a DataBase project?
Big Daddy - 8 Nov 2006 5:30 PM - 1 message
I have created a database project using Visual Studio 2005 and SQL Server 2000. In the Server Explorer, by right-clicking on a database table with the context menu, I am able to "Generate Create script to project". But, In the Server Explorer, by right-clicking on database table, I am ...
Score general SqlDataSource questions
djc - 8 Nov 2006 4:06 PM - 7 messages
I had previously (in asp.net 1.1 and asp.net web matrix) just done this to populate a listbox with data from a database: ------------ this was from the page load event ---------------- 'fill recipient address list box Dim cnn As SqlConnection ...
Score Paging subreport to match main report
dotnetme - 8 Nov 2006 3:54 PM - 1 message
I have report that has invoice numbers and inovice detial in the "Details" section of the report. I then have the a subreport at the bottom right of the "Report Footer" which just lists the the invoices numbers.  The problem is ...
Score Slash problem in SQL
Arne Garvander - 8 Nov 2006 2:24 PM - 4 messages
I execute: cmd.CommandText = "INSERT INTO drawings (drawings_path) VALUES ('p:\\E-Switch Secure\\PDF_dwgs\\B-FILE\\B010002D_SHT1.pdf')"; cmd.ExecuteNonQuery(); The result is 21249    p:E-Switch SecurePDF_dwgsB-FILEB010002D_SHT1.pdf Why did my slashes disappeared? ...
Score Custom Installer Action asking Database Information
Lucas Ponzo - 8 Nov 2006 5:55 AM - 2 messages
How to do custom action in a Install Project that asks for database conectivity and set these information in the web.config or app.config ? Can I run a custom .NET program in this custom action to, for example, encrypt the datase password or insert other configuration, like AppSettings ? ...
Score KNOW THE SIZE OF A FIELD
Raul - 8 Nov 2006 12:33 AM - 4 messages
In visual basic 6 xxx.recordset.fields(1). size and in the fields of type string it indicated you the maximum that allowed In. net opposing net anything resemblance. thank you ...
Score BindingNavigator
JJ - 8 Nov 2006 12:07 AM - 8 messages
OK, I have a new form and I'm still a newbie, and am using a dataset created with the designer based on SQL Server 2005 tables.  Have dragged a field from the Data Sources on to my form, and VS2005 ...
Score MSDE and TransactionScope
Scott.B.Fitzpatrick - 7 Nov 2006 5:56 PM - 1 message
I have a C# application that applys a set of scripts to a database to create the structures.  When each script is applied, I encapsulate the call within a TransactionScope.  Everything works fine on SQL Server 2000 sp4, 2005 sp1, and Express 2005 sp1 databases. ...
Score Middle Tier Code
Sharat Koya - 7 Nov 2006 5:34 PM - 1 message
Hi I have just written the following in a prototype just as a try out. My intention is to host an ADO.NET cache on a WCF service. I was just wondering if it is ok or if there are better ways of communicating with the middle tier ...
Score Missed Inspections During the last period.
Jay Balapa - 7 Nov 2006 4:31 PM - 6 messages
Note: I have also posted this in SqlProgramming goup and forgot to include this group. Hello, I have three tables- TBLINSPECTION with the following fields- BARCODE  ITEMTYPE PASS DATEINSPECTED 1000                    x         YES  01/12/2006 ...
Score DataReader - network problems or benefits?
Doug - 7 Nov 2006 3:13 PM - 6 messages
If I am grabbing a lot of rows (say 10,000 from SQL) would I be helping or hurting the network by using a DataReader?  I would think helping because it's really only returning 1 row at a time, but I'm not sure. ...
Score MSDE and TransactionScope
Twig - 7 Nov 2006 2:18 PM - 1 message
I have a C# application that applys a set of scripts to a database to create the structures.  When each script is applied, I encapsulate the call within a TransactionScope.  Everything works fine on SQL Server 2000 sp4, 2005 sp1, ...
Score SQL Server does not exist or access denied. at System.Data.SqlClient
g_sharad - 7 Nov 2006 1:31 PM - 3 messages
Hi all tthe full mssg is ::: A database-related exception occurred! System.Data.SqlClient.SqlException: SQL Server does not exist or access denied. at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) at ...
Score How to join two datatables and show them in DataGridView
Maxwell2006 - 7 Nov 2006 3:56 AM - 3 messages
Hi, I have a strongly typed dataset that contains two tables with parent child relationship. I need to show all child's rows with related parent's data in a single DataGridView. Is there any DataBinding technique that allows me show Child ...
Score CSV and mixed data type problem
Hardy Wang - 6 Nov 2006 9:45 PM - 6 messages
Hi all, I have a program to read CSV files uploaded by customers. Ons column is zip code like: 77477 77479-5627 77478 77479-5418 77479-1225 77083 My C# code to read uploaded file is like: uploadSourceFile.PostedFile.SaveAs(savePath + fileName); ...
Score Connection Pooling Explanation
Phenglai - 6 Nov 2006 7:47 PM - 4 messages
OK, I have been digging for and cant find the answer to this question. I have created a DAL DLL that will hit both MySQL and MSSQL with a unified code base. That much is easy. Where I am having problems is with the connectin pooling. I wrote an ...
Score Getting error "Communication with the underlying transaction manager has failed."
Rod - 6 Nov 2006 5:41 PM - 1 message
I am writing my first distributed transaction application, using C# (but the language isn't pertinent), and running against SQL Server 2005 on a Windows 2003 Server. Both Windows 2003 Server and SQL Server 2005 have their respective service pack 1's applied on this server. I am using Visual Studio ...
Score Password protected Access database connection error..!!! Please help....!
serkansatuk - 6 Nov 2006 4:21 PM - 3 messages
everthing was fine, until i protected the database with password "123456". now i am trying to connect the database with password protection and listing data to combobox, i am getting this error. ------------------------- An unhandled exception of type 'System.Data.OleDb.OleDbException' ...
Score Typed Dataset Events
Lucas Ponzo - 6 Nov 2006 2:42 PM - 23 messages
I'm reposting this problem, but now with the No-Spam Alias configured. Just for registration, and with a few corrections in the text: ---------->> I have a standard typed dataset (.net 2005). And created a separete class file to handle the RowChanging event. The dataset name is dalCadastro and the ...
Score SqlDataReader.GetString() WITHOUT converting backslashes
Hans - 6 Nov 2006 1:14 PM - 2 messages
Hi! When a string is read from an NVARCHAR, every '\' gets converted to "\\". When a string like that is shown in a message box, I get a "\\n" rather than the carriage return I want to have. Does anyone know how I can talk SqlDataReader out of modifying the data I ...
Score Excel Problem
Solution_4u - 6 Nov 2006 12:54 PM - 5 messages
Hey Guys, I wanted to know if the format in a word file can be read by word itself?? Do you have any VBA macro for that?? Is it possible to do the same by using Excel ...
Score Bind Ms Word Documents on CrystalReports
swathikarnati - 6 Nov 2006 7:00 AM - 1 message
HI Group i am developing a Windows project where i need to display my RTF files on to crystal Reports can this be achieved Thanks in Advance Have a nice day ...
Score definining currency in ADO.NET 2.0
Andre Ranieri - 6 Nov 2006 12:23 AM - 8 messages
I have a procedural question - in ADO.NET 1.1 when I created DataSets from an XSD schema I would create a SimpleType named "Money" and set the FractionDigits to 2.  Thus, my USD fields were always correctly formated ...
Score filter on child row
sebastian gereck - 5 Nov 2006 8:00 PM - 1 message
hello, i have a problem with filtering in a parent-child relationship. what i wanna do is to filter the child table and after that filter the parent to see if the rows in the parent has child rows. i do that with an expression column ( "count(child.[col]) in the parent ...
Score NEED a datagridview tutorial! plz HELP!!!!
giddy - 5 Nov 2006 7:11 AM - 4 messages
hi , i'm an ex vb programmer , i need a GOOD and COMPLETE tutorial for filling a datagridVIEW via an access database file (.mdb) i want to be able to add a context menu for the cells much like excel and i  want to ...
Score Using MS Access in ADO.NET - coming from VB6
Garry - 5 Nov 2006 6:45 AM - 29 messages
One of the annoying problems of distributing my VB6 MS Access orientated financial application to paying customers was that there were many problems with the MDac installations which caused the application to crash.. Mostly they could be solved by telling the customer to download the latest ...
Next »