Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Altering value to be returned by DataRow.Item
Joe - 9 Sep 2006 7:45 PM - 5 messages
I'm looking for a suggestion on how to do the following: We have a case when values returned by DataTable.Rows[r][c] should be different than what is actually stored. For example: DataTable dt = new DataTable(); dt.Columns.Add("Column1"); ...
Score Add Query / Add Data Source wizard won't generate Update() query
va - 9 Sep 2006 2:44 PM - 4 messages
I have a simple child table whose integer ID column contains the primary key of its parent table - nothing unusual.  While the Select, Insert and Update will be generated with "Add Data Source" for the paarent table, only the ...
Score Problem ADO.NET DataTable's parameters generated by Add Data Sourc
va - 9 Sep 2006 2:36 PM - 2 messages
I have a lookup table with only one column which is a string and the primary key like so: JOBTITLES ------------ JobTitle (string) PRIMARY KEY In another table, I reference the above table's primary column as a foreign key like so: ...
Score How to transfer SQL Express data?
VB Programmer - 9 Sep 2006 5:51 AM - 5 messages
I have a "version 1" of an ASP.NET 2.0 website.  I am creating a "version 2" of the website from scratch (re-architectured design).  The V1 SQL Express db has several tables which I want to transfer to my new site.  Any ...
Score How to persist datatable through form.post?
Bill - 9 Sep 2006 1:41 AM - 5 messages
I am still new at this but I was quite surprised to find that I cannot make a  datatable object  survive a repost! I suppose I could populate  and read back a datagrid but that seems messy. ...
Score Best way to strip qualified type names from DataSet.GetXML()
matt.skibbs - 9 Sep 2006 1:02 AM - 1 message
What is the best way to strip qualified type names from the output of DataSet.GetXML()? Override GetXML, modify the XML directly, etc...? I want: <DataType>System.Int32</DataType> but am now getting: <DataType msdata:InstanceType="Type" ...
Score DataAdapter Fails to Update Access 2002 database
v.maggs - 8 Sep 2006 6:29 PM - 6 messages
In Visual Studio 2005, I have a snippet of VB 2005 code which runs without error but does not update the Access 2002 database. Any ideas? Dim strSQL As String = "SELECT [Batch.Comments], [Batch.Is Active], [Batch.Is Pre Entered] FROM BATCH WHERE [Batch.Batch Key] = 4643" ...
Score Stored procedures
Adrian - 8 Sep 2006 4:35 PM - 6 messages
I am looking for a good tutorial on stored procedures on the Web. Any suggestions where to look? Thanks. Adrian. ...
Score Concerns about exception string revealing internals/data about dat
John K - 8 Sep 2006 4:19 PM - 7 messages
Hello, We have a global error handler in a Windows Service application (.NET 2.0).  The global handler sends out the error message to a few select individuals via e-mail (technical support.  I am wondering if there is a possiblity that ...
Score Distributing SQL with a program
Michael D. Reed - 8 Sep 2006 2:55 PM - 5 messages
I have a program that uses Access DB that is distributed with the program.  I would like to upgrade these to the SQL server that is distributed with the program.  This program needs to run as a standalone, not connected to a ...
Score How to read vfp files. VFP v9 driver not working for me.
Mike Edgewood - 8 Sep 2006 2:15 PM - 2 messages
What do I need to read VFP databases? I just migrated from one machine to a new one.  All was fine til then. Thought I copied everything, but cannot get into old VFP files as before.  Downloaded the new OLE VFP 9 drivers from MS and can open ...
Score Set Default of DateTime field to "today"?
AxelHecker - 8 Sep 2006 11:43 AM - 3 messages
Maybe someone can help me: How can I set the default of a DateTime field used in a WinForms application to "Today". This is what I tried: - The underlying ADO DataColumn of data type DateTime has a default; but this can only be set to a specific value; afaics, there is no expression ...
Score Select only nn records
Edwin Knoppert - 8 Sep 2006 10:13 AM - 2 messages
We have end-users doing a selection, the selection is copied into another table (claimed) (we do this for them in a batch during the night) To limit the endusers account balance we promote for example a max. of 500 ...
Score Create Database
Adrian - 8 Sep 2006 9:43 AM - 4 messages
When I enter the code below into the cmnd.CommandText string I get nothing but errors, presumably something else should be done: What? Adrian USE master GO CREATE DATABASE Employees ON ( NAME = Empl_dat,    FILENAME = 'f:',    SIZE = 10, ...
Score Failed to convert parameter value from a Guid to a String
Crown - 8 Sep 2006 8:27 AM - 4 messages
I am trying to use the Microsoft Oracle data provider to store a GUID as a string. Get this message: Message: Failed to convert parameter value from a Guid to a String. Inner Message: System.InvalidCastException: Object must implement IConvertible. ...
Score Adding external tables to a strongly typed dataset?
Earl - 8 Sep 2006 6:47 AM - 2 messages
My project schema looks something like this: ClassWidget     SelectWidgetAsDataTableTable     UpdateWidgetDataTable     AddToWidgetDataTable     DeleteFromWidgetDataTable What I'm trying to do is maintain separation between the data layer and the UI layer. I clearly do not want all that dataadapter gunk up in the UI ...
Score Derive from DataTable
Joe - 8 Sep 2006 4:45 AM - 5 messages
I need to make a custom DataTable which has columns that inherits from DataColumn and rows which inherit from DataRow. I would ideally like to have my own DataColumnCollection and DataRowCollection so we don't need to keep casting from a System.Data.DataRow or System.Data.DataColumn to our own. ...
Score Transaction Management - BL to DAL
ferguslogic - 7 Sep 2006 10:42 PM - 3 messages
I am looking for an answer for what seems to be a very common problem but I can't seem to find any answers for it. I am developing a simple C# 2.0 application. It is a winform app which ...
Score HELP:Trouble adding tablerow to table in typed dataset
Jon Haakon Ariansen - 7 Sep 2006 8:36 PM - 1 message
Hi, I'm using VS2005 with Fw. 2.0. I'm trying to insert a record of data into a table in my typed dataset. The record doesn't seem to be added to the sql database. Here is my code for inserting a record into tblOBJECT in a dataset called ...
Score In what order to call sever DataAdapters to update a typed dataset
s.bussing - 7 Sep 2006 6:53 PM - 2 messages
Hi all, I got this problem. I've got three table User, Group and User_Group. These tables I have put into a typed dataset and added relations to them. I also have a form in which it is possible to ...
Score RowUpdating missing in DbDataAdapter
Glen - 7 Sep 2006 4:26 PM - 3 messages
I'm trying to convert from using System.Data.SqlClient to using System.Data.Common. Everything is looking good, except that the events RowUpdating and RowUpdated do not exist in the DbDataAdapter. So,     SqlDataAdapter.RowUpdating and     OracleDataAdapter.RowUpdating ...
Score Connecting to Mainframe Server
dinoo - 7 Sep 2006 3:55 PM - 2 messages
Hi, I need help here. I am converting an vb application to c#. The existing application connects to the mainframe server using FTP and downloads a file (dataset). Is it possible in .NET to avoid FTP and use any providers to connect to the ...
Score Dates
JosephByrns - 7 Sep 2006 3:49 PM - 6 messages
How do people cope with dates in multiple countries? I have an Access database accessed by a VB.NET application, I construct SELECT strings based on user inputs to get data from the Access database, when entering a date value into the select string I use ...
Score Update a data to a bounded datagrid view
sweetpotatop - 7 Sep 2006 1:19 PM - 2 messages
Hi, I have a datagridview which bounded to a  datatable. When I tried the to update the grid: adapter.update(table) I got the following error: "Update requires a valid InsertCommand when passed DataRow collection with new rows" Is it supposed to grab all the info from the grid without explicitly ...
Score DDE command with sqlComman object
Sebho - 7 Sep 2006 10:18 AM - 3 messages
Hi, i try to execute a DDE command with an SQlClientSQLCommen object and i obtain  "syntax error near "Then"  ": dim sql as string sql = "CREATE TRIGGER myTrigger " & _ "ON MyTable " & _ "AFTER(UPDATE) " & _ "AS " & _ ...
Score VS2005 and SQL Express: Internal .Net Framework Data Provider erro
den 2005 - 7 Sep 2006 3:10 AM - 4 messages
Hi everybody,   Is there anybody can tell me what this error meant? Where is source of error? There is a class library DLL created by another person. I used C# (VS 2005 Professional Edition) and SQL Server 2005 Express Edition and also used ...
Score Selecting with SqlDataSource and default value of empty string
jw56578 - 6 Sep 2006 8:57 PM - 2 messages
If I have a parameter with a default value of empty string, the sqldatasource won't even execute the command on sql server. Im using a "like" clause so i want to include an empty string to retrieve all records if desired. ...
Score ANN: SQLite ADO.NET vNext Provider Released
Robert Simpson - 6 Sep 2006 8:05 PM - 1 message
This is a preview of the SQLite vNext provider with support for the ADO.NET Entity Framework (LINQ, eSQL, etc). Version 2.0.35 Alpha - September 6, 2006 Compiled from the SQLite 1.0.35.0 codebase Requires the LINQ August CTP ...
Score The .Net Data OLE DB Provider(System.Data.OleDb) requires Microsoft Data Access Components(MDAC) ver
sanjay prasad - 6 Sep 2006 7:41 PM - 2 messages
This really helped. I was frustrated going in circles. Hope this helps anybody who needs this. We recently had a problem with a push install of MDAC 2.8 SP1 (latest available version) to Windows 2000 Pro workstations, varying SP levels. ...
Score error reading excel using OleDb
Abel - 6 Sep 2006 7:00 PM - 8 messages
Hi I try to execute an sample how to read and write excel sheets using OleDb When opens the connection, the  objConn.Open gave me this error: "Request for the permission of type 'System.Data.OleDb.OleDbPermission, System.Data, Version=2.0.0.0, Culture=neutral, ...
Score List of forms in another project
Roman - 6 Sep 2006 3:22 PM - 3 messages
Is there a way to get a list of all forms contained in another solution/project? Thanks in advance, Roman ...
Score Stored Procedures that return different results to any TableAdapto
Simon - 6 Sep 2006 5:56 AM - 3 messages
I have just recently had an opportunity to start working with VS2005. I have managed to reproduce an existing ASP.Net 1.1 page almost entirely using drag n drop designers and object data sources except for one thing. I need to bind a DataList to the result of a stored procedure that filters, ...
Score How to start/stop SQLServer Express
ad - 6 Sep 2006 2:39 AM - 2 messages
How can I start the SQLServer Express on my machine with codes? ...
Score Close Reader or not?
tshad - 5 Sep 2006 11:48 PM - 11 messages
I have a situation where I could Try     Open a Connection     ExecuteReader     Close Reader Catch     may not happen - Possible if this a Timer in a Windows Service End Try ...
Score Updating 2 tables that are joined
Dave - 5 Sep 2006 8:30 PM - 2 messages
I have a dataset that is 2 tables connected with a SQL JOIN. VB.Net 2005 takes away all INSERT, UPDATE and DELETE functions when creating the DataAdapter. SQL Server 2005 has no problem updating 2 tables in a single SQL statement. ...
Score Calling Oracle function with .net 2003
manika02 - 5 Sep 2006 7:44 PM - 6 messages
Hi, I am trying to call an oracle function using Visual Studio .Net 2003. The function runs fine Stand Alone. Only when I call it using my C# Code I get the following error: "ORA-06550: wrong number or types of arguments in call ...
Score Persist DataTable Primary key
PB - 5 Sep 2006 4:38 PM - 2 messages
Isn't the primary key setting on a DataTable get persisted when I write it to disk (using DataSet.WriteXml(...))? If not, is there a work-around for this or do I set it everytime I load data back into memory from the persisted XML file? ...
Score Forgot but.. how to get the last added record ID?
Edwin Knoppert - 5 Sep 2006 3:06 PM - 5 messages
Something with @Identity field or so... forgot. Someone having copy of a SQL statement doing this? ...
Score Unicode Comparison.
Max - 5 Sep 2006 6:13 AM - 5 messages
hi i want to compare a unicode string "અમદાવાદ" with a string fetched from database, example code is given below. str contain value fetched from database and ...
Score How to determinate if ExecuteNonQuery sucessful
ad - 4 Sep 2006 10:28 PM - 8 messages
I use the codes below;      SqlCommand myCommand = new SqlCommand(sSql, cnn);         cnn.Open();       myCommand.ExecuteNonQuery(); How to determinate if ExecuteNonQuery sucessful? ...
Score Need suggestion: importing data into SQL Express
VB Programmer - 4 Sep 2006 5:53 PM - 4 messages
I have an ASP.NET 2.0 website with a SQL Express database.  I also have an excel spreadsheet with alot of data on it.  (If need be I can save it as a CSV, XML, or whatever...) ...
Score Another Parameter Question
Stephen Lynch - 4 Sep 2006 1:53 PM - 3 messages
I am running a stored procedure via code but need help with the sytax for the output parameter: When I run this it works in SQL: USE DataInput GO DECLARE @MyIdent int EXEC a_spAppendNewContributionID @CompanyId=1000, @PayPeriod="8/12/2006", ...
Score Parameter Help
Stephen Lynch - 4 Sep 2006 1:41 PM - 5 messages
I have a dropdown box called EmployeeUID.  How do I reference it for the parameter value? Here are my lines, The problem is parameterEmployeeUID.Value = this.EmployeeUID.Text; Do I convert it to text, if so how? OleDbParameter parameterEmployeeUID = new OleDbParameter("@EmployeeUID", ...
Score Microsoft SQL Server Management Studio Express
Adrian - 4 Sep 2006 1:01 PM - 2 messages
In Microsoft SQL Server Management Studio Express If one clicks on "Databases" One can select "New Database" There "Database Name" and "Logical Name" has to be entered. Could you please tell me what the difference between these two terms is? ...
Score use of XML with ADO.Net
Mithun Bhangar - 4 Sep 2006 8:25 AM - 2 messages
Hi I need answer to the problem below. Ques: I have a table in SQL. For this table I generate a XML file. This XML file I use to fill in the            Datatset and then bind it to say, DataGrid. Now if I do editing ...
Score Developer Toolz.com
your - 4 Sep 2006 8:16 AM - 1 message
You guys might find this website useful, there is a lot of different utilities/add-in's that make a programmers life easier. You can also share your own tools or tools that you use. The tools are freeware so that should make it easier on some of us who ...
Score Developer Toolz.Com
zoinky - 4 Sep 2006 7:24 AM - 1 message
You guyst might find this website useful, there is a lot of different utilities/add-in's that make a programmers life easier. You can also share your own tools or tools that you use. The tools are freeware so that should make it easier on some of us who ...
Score dynamic html?
Agnes - 4 Sep 2006 5:19 AM - 1 message
I got a grid list the record, column1 is "number" When the user press colunn 1 , i want to show out the pdf file whose filename is same as column1's contents How can I do that ?? thanks a lot ...
Score oledbcommand + vfp
Agnes - 4 Sep 2006 2:48 AM - 1 message
i got two server, (data server) + application server. the asp.net will be stored in application server  and map the vfp database by using network drive. When the database and program located in the same server, everything works fine. ...
Score Need starting advice...
Kurt Hill - 4 Sep 2006 12:12 AM - 9 messages
I am writing a database application for use in disconnected situations.   The application will be installed on laptops.  The intention is for the users to connect to the central SQL Server 2000 database, get the data, then go into the field and use it.  They may be disconnected for ...
Score Problem installing vs 2003 sp1
John - 3 Sep 2006 10:26 PM - 4 messages
Hi I have downloaded the VS7.1sp1-KB918007-X86.exe file but when I try to install it, it runs for a while and asks for license confirmation etc. but then comes up with a dialog asking for the location of vs_setup.exe file. I ...
Score How to determinate if SqlServer 2005 install in my machine
ad - 3 Sep 2006 9:22 PM - 2 messages
Hi, How can i determinate if  SqlServer 2005 install in my machine with program? ...
Score database name and logical name
Adrian - 3 Sep 2006 2:46 PM - 11 messages
What is the difference between Database Name and Logical Name? Thanks, Adrian ...
Score Concurreny with Datasets
Ant - 3 Sep 2006 12:45 PM - 6 messages
Hi, Is there a way to check if a records in the underlying database have been updated by another client? ds.HasChanges() method only tells you that the DataSet has changed from the initial underlying data, but how do you know if another client has changed ...
Score Running application faster with ADO.net Connection
myra_el_khoury - 3 Sep 2006 9:36 AM - 3 messages
hi, I'm using ADO.NET (in VB.net) in a windows service application to perform a process on SQL Server 2000. This process runs quickly if the database is locally installed, but takes 30seconds when connecting to the server through ...
Score SqlDataSource and actual sql text going to db
probashi - 3 Sep 2006 5:54 AM - 4 messages
Hi, I have a SqlDataSource and there are 3 select parameters. I am using this data source for a Grid View Control. For my debugging purpose I would like to see the actual sql  text going to database (after evaluating all select parameters). I added a text ...
Next »