Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Need some help on forms
harrypotter - 19 Aug 2006 4:18 PM - 7 messages
Hey,         YO...., I NEED SOME HELP HERE !  Actually, I got some info from a good guy called ScottT, but I need more. You see, I'm kind of stuck in here.                         I need to connect two forms. But the problem ...
Score StoredProc commits results in QueryAnalyzer but not in ADO.NET
tracybannon - 19 Aug 2006 2:47 PM - 5 messages
I'm hoping someone can help! I have a stored procedure in an MSDE database.  When I use Query Analyser to run this stored procedure the correct results appear in the database.   My stored procedure returns resultCode. ...
Score RE: Please help *PLEASE PUT ME ON YOUR EMAIL LIST*
Wardy - 19 Aug 2006 1:19 PM - 1 message
This is a message board for framework related chat not your personal spam box !!! GET LOST ! ...
Score CSV header conating "." dot and after loading it into dataset its converting into "#"
Line_Eater - 19 Aug 2006 8:21 AM - 4 messages
CSV header conating "." dot and after loading it into dataset its converting into "#" LIKE. First.Name First # Name waiting for your reply ...
Score How to know the first sheet name of an Excel
ad - 19 Aug 2006 2:41 AM - 2 messages
I use the codes below to import the first  sheet of an Excel  file into a DataSet. But if the name of the first sheet is not "Sheet1", the SelectCommand will fail. How can I know the sheet name of the first Sheet in an Excel file? ...
Score How to determinate if a string in the Field names of a dataTable?
ad - 19 Aug 2006 12:50 AM - 2 messages
Hi, I have a dataTable with some fields. How can I determinate if a string in the Field names of a dataTable? ...
Score Bound DataGridView & DataTable - Which should be updated?
Liddle Feesh - 18 Aug 2006 10:37 PM - 1 message
Good evening all, I have a DataGridView, which is bound to a DataTable within a Dataset (which contains other DataTables, some are used as lookups for comboboxes in some of the cells). However, I want to manually allow rows to be removed and added and the ...
Score Using Oracle.ClientAccess.Data with System.Data.Common
John Wright - 18 Aug 2006 9:13 PM - 2 messages
I am trying to return a datatable using the Oracle driver. In order to return a dataset from the stored proc I need a cursor type to receive the data.  How is this possible with the Common namespace since it does not have a cursor or ...
Score Lady Only
SEXBLOG - 18 Aug 2006 4:02 PM - 1 message
Lady only 24-Hrs +91 9810577227 OR email to i***@lenstar.org ...
Score Lady Only
SEXBLOG - 18 Aug 2006 4:02 PM - 1 message
Lady only 24-Hrs +91 9810577227 OR email to i***@lenstar.org ...
Score RE: Occasional error opening a connection
Stephen - 18 Aug 2006 3:19 PM - 1 message
Hey Roger did u fix the error? i have the same problem From [link] Posted via DevelopmentNow.com Groups [link] ...
Score Trying to restore a .bak in C#
Jayyde - 18 Aug 2006 3:18 PM - 4 messages
Can I run a SQL command like: RESTORE DATABASE NewDB FROM DISK = 'ApplicationStartupPath\SQLSE2005\DevDB.bak' WITH RECOVERY, MOVE 'DevDB_Data' TO 'C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\Data\\NewEB_Data.mdf', MOVE 'DevDB_Log' TO 'C:\\Program Files\\Microsoft SQL ...
Score rastreadores GPS Ratreador gps localizadores bloqueadores 4764608
rastreador gps rastreadores gps de =?ISO-8859-1?Q?Ve=EDculos?= - 18 Aug 2006 1:58 PM - 1 message
CENTRAL ÚNICA DE VENDAS       10 Marcas de ratreadores, Compare e Compre.       Rastreador de Veículo       Rastreadores de Veículos       Rastreador GPS ...
Score SqlTypes Decimal
carlospedr - 18 Aug 2006 12:32 PM - 4 messages
Hi, I'm using .Net Framework 2.0. I Querying an Sql 2000 Database to fill a Dataset, the user dynamically choses what tables to query to fill the dataset. I need to provide information to the user about the tables, information such as the type ...
Score Read
Weman - 18 Aug 2006 12:23 PM - 1 message
Lady only 24-Hrs +91 9810577227 Send email to i***@lenstar.org get access code. ...
Score Stored Proc problem
manoj241176 - 18 Aug 2006 6:04 AM - 2 messages
Hi,    I am having stored proc which returns 2 resultsets, now i want to call this stored proc within another stored proc, but i want to use only the second resultset from the previous stored proc. So please tell ...
Score SqlCommandBuilder - not setting my identity column
rtennys - 18 Aug 2006 4:15 AM - 2 messages
I ran into a problem when I tried to use SqlCommandBuilder to generate my insert statement.  The problem was the identity column wasn't being set when I called Update.  It was set correctly in the database, it ...
Score Love Hotline
Beauty - 18 Aug 2006 2:05 AM - 1 message
Lady only 24-Hrs +91 9810577227 ...
Score database writing efficiency
Jeff Boeker - 17 Aug 2006 9:34 PM - 5 messages
I need to log 400 values every second into an access database.  Previously I did this in C++ using OLEDB and after a lot of experimentation, I minimized the peak CPU usage by writing out the data in a separate thread every 10ms.  ...
Score Datatable size in memory
klj_mcsd - 17 Aug 2006 7:38 PM - 2 messages
Does anyone know of a way to estimate how much memory a datatable is using? Are they any user-friendly tools that I can find this info out? Thanks ...
Score ADO.NET 2.0 - Simple question for you...
VB Programmer - 17 Aug 2006 6:07 PM - 8 messages
I have an ASP.NET 2.0 website.  I want to write a function in ADO.NET 2.0 (VB.NET) that does the following: 1. Opens up a connection to my SqlExpress db.  (The connectionstring is in ...
Score MS Access modules
zdrakec - 17 Aug 2006 5:18 PM - 3 messages
Hullo all: Is there a nifty way to retrieve a list of the macros / code modules in an MS Access database using ADO.NET, a la OleDB.OleDBConnection.GetOleDbSchemaTable for retrieving tables and views? Thanks much, zdrakec ...
Score Simple SQL INSERT
Scott at Cedar Creek - 17 Aug 2006 7:43 AM - 2 messages
I have a SQL INSERT statement.  I'm pretty well-versed in SQL but NOT in VB.NET / ASP.NET.  I would like to know what VB code is for inserting a new row into a database.  I have a SQL Table established already.  I would like ...
Score Simple SQL INSERT
Scott at Cedar Creek - 17 Aug 2006 7:40 AM - 5 messages
I have a SQL INSERT statement.  I'm pretty well-versed in SQL but NOT in VB.NET / ASP.NET.  I would like to know what VB code is for inserting a new row into a database.  I have a SQL Table established already.  I would like ...
Score DataGridViewComboBoxColumn seperate items
gabe - 17 Aug 2006 7:23 AM - 4 messages
I'd like to have separate items in the DataGridViewComboBoxColumn for each row, For an example look at the vs2005 query builder. Column(0) is the fieldName and contains a list of the fields from the table named in column(2). If the table selected in column(2) of a particular row is ...
Score downloading of a file from internet explorer
kamal - 17 Aug 2006 6:48 AM - 5 messages
Hi,      Generally we will download the files using internet exlorer defalut download manager.By using  C# or VB.Net how will we get the file information which we are trying to download from the Internet explorer. Is it possible. ...
Score DataRelation problem
manoj241176 - 17 Aug 2006 5:02 AM - 2 messages
Hi,    I want to use DataRelation object for setting up relationship between two different datatable, but i want to use multiple columns to set up relation between two tables. For example. DataRelation dRelationOrgInd = new DataRelation("OrgInd", ds.Tables["OrgList"].Columns["iIDOrganization, iIDSeries"], ...
Score Problem with a readonly table in a dataset (data source) in VS 200
Cathy - 16 Aug 2006 8:52 PM - 3 messages
I created a data source that point to an Access database with 3 tables in it. My problem is that the tables are designated read only and I don't know how to change the setting so I can copy data to them.  I can see the public ...
Score DataSet designer in VS2005
Nils Magnus Englund - 16 Aug 2006 6:53 PM - 5 messages
Hi, I have two questions about the DataSet designer in Visual Studio 2005: 1. How can I make another TableAdapter under a DataTable which already has one? I'm sharing the DataSet with the DataTable between two applications, and they need separate TableAdapters... ...
Score Newbie and 2005 Concurrecny
Oh-its-all-gone-wrong - 16 Aug 2006 4:01 PM - 2 messages
Hi All, Hope you all fine? Can I ask you all a quick question? I`ve been trying to get concurrency to work for my project in VB2005. I have the following code, which to be fair i`ve got so lost with but here it is: ...
Score SQL UPDATE for Dates ??
glenn - 16 Aug 2006 3:22 PM - 2 messages
Hi folks, I have 2 code snippets.  One works and one does not.         This first hard-coded snippet works Dim queryString As String = "UPDATE [rfi] SET [dateresolved] = '8/16/2006' WHERE ([rfi].[id] = @id)" ...
Score Auto uncrement column
Adrian - 16 Aug 2006 1:26 PM - 2 messages
Im am trying to create an auto increment column in a table. Where in the code below, should I make which changes in order to do that? Adrian                 /* ...
Score DataSet Designer/adding multiple tables to a dataset/ how?
Curtis - 16 Aug 2006 10:27 AM - 2 messages
In the VS2005 DataSet Designer if i try to add multiple tables from an OLEDB database, i get an error: "Failed to add TableAdapter." "An item with the same key has already been added." What does this mean? How do i get around it? ...
Score Changing ConnectionString programmatically
Ole - 16 Aug 2006 8:23 AM - 7 messages
Have the following situation: I have an old C++ application, which I have managed to compile with /clr to make it access .net functionality. For some of the new functionality I have decided to create a C# DLL, being a ...
Score what ado.net object to use problem
ads - 16 Aug 2006 8:15 AM - 2 messages
I need to accomplish this tasks: 1. i need to query sql database 2. check if null, if not continue 3. check a certain column if null,if not continue 4. filter or split the data into two sets, these 2 will be the datasources ...
Score SQL UPDATE with a DATE data-type
glenn - 16 Aug 2006 12:45 AM - 2 messages
Hi folks, I am doing an UPDATE to a table that has a field for a DATE data type.  I am using MS Access. The UPDATE works fine but when I try to place the DATE field in the mix it ...
Score Challenging ADO.NET situation (long)
Erik Funkenbusch - 15 Aug 2006 11:21 PM - 4 messages
I've implemented a solution that I don't really think is very efficient, but I can't really think of a better way to do it.  If anyone has any suggestions or citicisms, i'd be grateful to hear them.  .NET 2.0/SQL 2000 ...
Score SQL2000 error: ... When connecting to SQL Server 2005
prefersgolfing - 15 Aug 2006 10:22 PM - 3 messages
The complete error is : An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. ...
Score Speed and memory usage of Dataset
dougd - 15 Aug 2006 10:18 PM - 8 messages
I will start by saying I am somewhat new to ADO.net, that said here goes. I have a dbase file with 450,000+ records, (400MB+ file size) I am loading only the UniqueID field into a DataSet and I have 2 problems. ...
Score Multi-step OLE DB operation generated errors
Don - 15 Aug 2006 8:43 PM - 1 message
I'm getting the dreaded "Multi-step OLE DB operation generated errors" exception when trying to connect to a local Access 97 database.  My program connects fine when run on other machines, but on one computer it's giving me ...
Score Please Help! "Relation Relation1 cannot be merged, because keys have mismatch columns."
redintegra - 15 Aug 2006 8:00 PM - 1 message
"Relation Relation1 cannot be merged, because keys have mismatch columns." I get that error when I try to merge two datasets. Both datasets have a Relation named "Relation1". It is refering to the parent key, child key? How can i figure out which columns are messed up? ...
Score Please Help! "Relation Relation1 cannot be merged, because keys have mismatch columns."
redintegra - 15 Aug 2006 8:00 PM - 1 message
"Relation Relation1 cannot be merged, because keys have mismatch columns." I get that error when I try to merge two datasets. Both datasets have a Relation named "Relation1". It is refering to the parent key, child key? How can i figure out which columns are messed up? ...
Score Read XML and transform result table
abentov - 15 Aug 2006 7:45 PM - 1 message
Hi, I have the following scenario: 1. I have an application which includes a database with a DataMain table. I have a Strong Typed DataSet (MyDB)having the DataMain typed DataTable in it. 2. I have an external xml with constant fields. i've created a xsd and a ...
Score Timestamps, SQLServer, VS2005, ADO datasets and concurrency checking
Jim Rand - 15 Aug 2006 7:14 PM - 1 message
I'm using timestamps for concurrency checking when updating SQLServer from a modified dataset.  After each insert or update, the new timestamp value is needed for a subsequent update. If the timestamp is treated as a timestamp, the original concurrency check ...
Score Failed to enable constraints but please tell me sth.
DariuszTarczynski - 15 Aug 2006 4:42 PM - 7 messages
Hello. I'm know, there is tones of pages in google, etc. about problem: "Failed to enable constraints. One or more rows  contain values violating non-null, unique, or foreign-key  constraints." I'v read a lot, but this solutions doesn't resolve my problem. I'm using Strongly ...
Score Loop Through a Folder of Excel Workbooks in VB.NET
kvenkatu - 15 Aug 2006 2:49 PM - 2 messages
Hi, Can anyone tell me how to Loop Through a Folder of Excel Workbooks using VB.Net? I have a folder with Excel files.  Each spreadsheet has multiple worksheets. I need to read each worksheet and get the data and transfer that data ...
Score PARAMETERS/value in SQL, how to set?
Edwin Knoppert - 15 Aug 2006 2:02 PM - 3 messages
I would like to use access (for testing, then ASP.NET) to execute a query which uses another query where a value must be set like ID = 2 or so. How can i do that? Here is my example, i created Table2 with an ID field and a name field ...
Score Locking Datatable / Data Row
Prem - 15 Aug 2006 11:55 AM - 4 messages
Hello, if you have defined a DataSet in the HttpApplicationState which is shared by all current users ... what I have to do, to make the Dataset, DataTables and DataRows thread-safe? Following my assumptions: 1) If I change a Row: ...
Score Problems using SqlConnection
Mika M - 15 Aug 2006 7:28 AM - 2 messages
When my application uses OleDb-provider like... Private Sub TryOleDbConnection()          Try              Dim i As Integer              Using cn As OleDbConnection = New OleDbConnection() ...
Score RE: Beginner getting "Prepared statement...expects parameter...not supplied" error
Dan - 15 Aug 2006 1:07 AM - 1 message
Please make sure you're passing DBNull.Value for null parameters, not null or nothing. I believe this is what almost all beginners hit. From [link] ...
Score OleDB Stored Procedure returns Data Rows
DaveR - 15 Aug 2006 12:19 AM - 3 messages
I'm trying to Exceute a Stored Procedure with OleDB in C# I've looked all over the net and can't seem to find how to do it and have had minimal sucess: here is the sniplet of code i'm using: ...
Score change the database password (Access)
JohnK - 14 Aug 2006 11:26 PM - 3 messages
ok, ya got me, how do I change the database password via code? ...
Score Retrieving schema for a stored procedure.
Kevin Burton - 14 Aug 2006 8:47 PM - 3 messages
I am able to retrieve the schema for a set of stored procedures by running each of the stored procedures and then calling GetSchemaTable but I don't want to run the stored procedure if it is going to modify the database. How ...
Score refresh from DataGridView to bound DataSet
roybrew - 14 Aug 2006 7:33 PM - 10 messages
I can easily programmatically add a new row to a DataSet, fill the columns with the appropriate data and the new row is in the corresponding DataGridView is conveniently updated when the DataSet changes.  Is there any way to do this in the other direction?  That is, ...
Score Retrieving primary key of newly added record
jeff.ranney - 14 Aug 2006 7:01 PM - 4 messages
Hi all. I have three burning ado.net questions about using the DataAdapter.Update technique of updating data (rather than calling a stored proc explicty).  I can't figure them out and I'm hoping it won't be too hard for some of you ado.net gurus out there! ...
Score newbie - simple Master/Details question
James Vickers - 14 Aug 2006 4:05 PM - 9 messages
Hi all, I am a bit of "noob" when it comes to using c#.NET datagrids, and always look at them in terms of what i could have done in VB6. I have been reading around, and understand the ideas and logic of DataSets, ...
Score creating a folder
kamal - 14 Aug 2006 11:40 AM - 2 messages
Hi , when we accessing some application from the server then a folder has to create on the client system . When accessing the application from server the folder has to created on the client system at any where. Any solution. Thanks in advance. ...
Score How to supress deleting a Row
Hamed - 14 Aug 2006 9:34 AM - 10 messages
Hello I have a DataGrid that a is bound to a DataTable. Some of the rows in the DataTable should not be deleted. How can I prohibit deleting of some identified rows? The problem could be specified in the following format too: ...
Score DBnull in dataTable.Columns.Add()
Adrian - 14 Aug 2006 8:30 AM - 12 messages
Re the code line: dataTable.Columns.Add("columnName",System.Type.GetType("System.[whatever]")) ; (I am working in c#) Can one add that null is / is not allowed? And, if so. what is the syntax? Adrian. ...
Score HowTo: Updating Data in tables with an 1:n Relation
Caroline König - 13 Aug 2006 9:56 PM - 8 messages
Hi, I have a problem updating data in two tables which are related to each other. The parent table is called "Owners" and each owner can have multiple animals, standing in a table "Animals". "Owners" has a column "ID", which is ...
Score ORA-12154 connecting to Oracle XE database
dchman - 13 Aug 2006 8:22 PM - 1 message
I have Oracle XE installed on my workstation, which is running Windows XP Professional x64.  I can connect to the database through the Oracle interface or through Toad, but I cannot connect to it through Visual Studio 2005. In a new project, I add the reference to Oracle.DataAccess.  When I try to ...
Score Cannot pass NULL to SelectParameters?
John - 13 Aug 2006 3:38 AM - 4 messages
Hi, I just cannot manage to perform a SELECT query with NULL parameter... My TCATEGORY table does have one row where TCATEGORYPARENTID is null (real DB null value). TCATEGORYID and TCATEGORYPARENTID are uniqueidentifier columns. My questions: - is Type="Object", below, necessary? ...
Next »