Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Can we backup to Stream
ad - 26 Aug 2006 11:10 PM - 8 messages
When we use the SQL to backup a database, we use: backup database Health to disk='c:\Backup.bak' with init This will generate a physical file in disk. Can we backup file to a Stream? ...
Score ConnectionString for VisualStudio-style SQL Server Databases
Alex Maghen - 26 Aug 2006 2:50 PM - 5 messages
If I create a database or attach a database file in the version of SQLServer that comes built-in to Visual Studio, the ConnectionString that VisualStudio automatically creates for connection to this database is a "file-based" connection ("AttachDbFileName=..."). Is there a way to attach a database to this version of SQL Server that can ...
Score Adding a record using ADO.NEt 2.0
SK - 26 Aug 2006 12:06 PM - 3 messages
Hello, I have a Newbie question.  I am using .NET 2.0 and C#. I have a data entry screen which has about 25 fields. Excepting one field, none of the others fields require inputs. My question What is the best method to insert the records to a SQL db - calling the ...
Score How to determinate if an SqlServer Instance existed?
ad - 26 Aug 2006 7:12 AM - 2 messages
Hi, How to  determinate if an SqlServer instance existed in a Server? ...
Score were can I get a music sharring service
James - 26 Aug 2006 1:03 AM - 2 messages
were can I get a music sharring service ...
Score Columns in a Dataview
Mike - 25 Aug 2006 10:08 PM - 4 messages
I have a table that is composed of an ID and two foreign keys. This table is used to relate two other tables. I'm using a dataview to display the data. The data can be edited, including changed, deleted and added. ...
Score Manipulate Data in a data set
Chicagoboy27 - 25 Aug 2006 6:40 PM - 2 messages
Sorry if this is a basic question but I was wondering how to test the dataset information as it is being read. ex, I have a table that contains file extentions such as .xls, .doc, ..ppt. What I want to do is test the dataset as they are being written ...
Score "Thread was being stopped" while trying to connect to AS400 iSeries using .NET
Daniel Wilson - 25 Aug 2006 6:20 PM - 3 messages
My codes blowing up with the "Thread was being stopped" exception when I try to create a data connection. Here's the line of (MS VC++ .NET 2003) code blowing out: SourceConn = new IBM::Data::DB2::iSeries::iDB2Connection(S"DataSource=ANTIGUA1;DefaultCollect ...
Score Strong Typed Dataset best practices
Fernando Chilvarguer - 25 Aug 2006 5:05 PM - 3 messages
I'm new to ADO.NET 2.0 so I have some questions you may be able to help me with. 1. I decided to take advantage of Strong Typed datasets. Everything worked but I did not really like the way I had to deal with the TableAdapters. So, ...
Score Conn Pooling Monitor
Mike - 25 Aug 2006 3:57 PM - 2 messages
Hi, I would like to build a monitor application that monitors the connection pooling. I know that it is possible to use PerfMon for SQL Server, but I would like to build my own to deal with other providers. Does anyone have any link to articles or any other information that I could look at? ...
Score ExecuteScalar don't return the corrent Int value.
pedestrian - 25 Aug 2006 2:08 PM - 3 messages
I'm using VB ADO.NET with Northwind database Employees table. I create a WinForm with a ComboBox (cboEmployee) to let user to select or enter full name and store it in strNames string array. I then try to get the matching Employee ID based on the employee name entered. ...
Score Business Layer and Transactions in the Data Layer
joeblast - 25 Aug 2006 1:24 PM - 6 messages
I have a BO that must call 2 functions each function residing in 2 different DO. BO->DO1.Update1 BO->DO2.Update2 Let's say that each DO call point to the same SQL Server. Let's say that each BO is on my Appserver and the 2 DOs on the SQL Server. ...
Score Fastest way of accessing CSV files
Shiplu - 25 Aug 2006 1:02 PM - 6 messages
hi, I am handling CSV files as database. each CSV got 40,000 - 60,000 lines. I have to do the joining, subquery and other complex tasks here. the problem is, my query execution time too high, 2-3 mins. how can I ...
Score Converting date formats
Mika M - 25 Aug 2006 11:16 AM - 2 messages
Hi! I'm reading CSV-file using OleDB provider with SQL-select command and it's working fine. Anyway CSV-file contains "field" containing date values like 20060825, and I'd like to convert it into datetime format when reading it into DataTable like #8/25/2006#. How to do this? ...
Score Change SelectCommand Runtime with Typed DataSet
TigerMan - 25 Aug 2006 10:03 AM - 3 messages
I have a DataTable setup and want to be able to change the columns at runtime so I limit the number of rows returned. I know you can have have multiple queries within a DataTable but they return empty columns which I don't want (or is there a way to stop empty rows being ...
Score Saving a dataset to a different database
Darren Sim - 25 Aug 2006 8:28 AM - 3 messages
Hi there, I am fairly new to webservices and C#and currently have a problem with updating data to a remote sql database from data entered into a local MS access database. The dataset I am using comprises of several tables.  Once the ...
Score System.Data.OracleClient requires Oracle client software version 8.1.7 or greater (URGENT)
ozcankanbur - 25 Aug 2006 8:05 AM - 3 messages
When I try to connect Oracle 10g db from windows 2003 server I get error "System.Data.OracleClient requires Oracle client software version 8.1.7 or greater" On the Windows 2003 Server - .NET Framework 1.1 - Oracle 10g Client (I can connect with SqlPlus) ...
Score downloading from web mail
kamal - 25 Aug 2006 7:00 AM - 1 message
Hi,    I have one problem . we have implemented overriding of IDownloadManager of Internet explorer. it was working fine. If we give any files which have direct hyperlink i.e from geocities or like ... . But what's the problem i ...
Score Why ImportRow is causing NullReferenceException & Rows(0) <> NULL
John K - 24 Aug 2006 11:22 PM - 2 messages
Hello, I am receiving a System.NullReferenceException error when the ImportRow is executed.  However, as you can see there are rows in the table and I can see the data in Rows(0) in the dsetTempPlaceInfoFromPt.Tables("Places").Item.ItemArray of QuickWatch.  Thus ...
Score Provider Factories
sashko - 24 Aug 2006 6:00 PM - 2 messages
We are moving our software to the web using ASP.NET 2.0 and are researching ways to enable our software to connect to multiple databases, specifically Oracle, SQL Server, and ASA. We have used ODBC in a client-server environment ...
Score ORA-03113 exception thrown
Gene McCrory - 24 Aug 2006 3:41 PM - 2 messages
Background - VB.NET v1.1 SP-1.  Query Oracle database using Microsoft .NET provider for Oracle (System.Data.OracleClient).  Exception is thrown using both get data methods: 1.) OracleCommand.ExecuteReader() 2.) OracleDataAdapter.Fill() Problem - A certain query which happens to contain a Group By and Sum throws ...
Score .NET 2.0 COM Excel add-in stops responding when SqlConnection object is created
Johan Zietsman - 24 Aug 2006 3:35 PM - 1 message
Dear All I have encountered a problem when creating a System.Data.SqlClient.SqlConnection in my Excel add-in. I am using: - Visual Studio 2005 - Excel 2003 SP2 I created the add-in with the VS2005 Shared Add-in Wizard. I then included ...
Score Why does a DataTable serialize so large
Joe - 24 Aug 2006 3:08 PM - 5 messages
If I create a simple collection with say 20 columns and 5000 row and a DataTable with the same and serialize both, the DataTable file is at least 2 times the size as the simple collection. What is all the overhead with the ...
Score Nullable types in strongly typed DataSet
Nils Magnus - 24 Aug 2006 9:06 AM - 1 message
Hello, I have a nullable DATETIME column in my SQL Server table, and I have the nullable type DateTime? in my .NET 2.0 application - but how do I make the DateTime field in my strongly typed dataset nullable? When trying to manually enter System.DateTime? in the DataType property of ...
Score poor OracleClient performance?
alois - 24 Aug 2006 8:31 AM - 2 messages
Hi all, in the process of migrating from 1.1 to 2.0 i´m experiencing massive performance losses within the database access to a oracle database (same effect on 9 and 10) the following code is built in 1.1 and 2.0 (except the stopwatch of course). ...
Score GetOleDbSchemaTable throwing an unexpected OleDbException
Jos G - 24 Aug 2006 7:24 AM - 1 message
Hello, I have an app that uses this statement to retrieve the procedure name of an Access database: DataTable dbSPS = cnx.GetOleDbSchemaTable(OleDbSchemaGuid.Procedures, null); It's working nicely. However, in a specific database, the same code throws this exception: ...
Score Sql2005 Express in Win2000 pro
ad - 24 Aug 2006 5:27 AM - 2 messages
Hi, When I install Sql2005 Express in Win2000 pro, it failed with : This system did not have the correct version of MDAC installed. Which version is needed for Sql2005 Express when installed in Windows 2000 professional? ...
Score Connection Pooling With ASP.NET 1.1
Robert E. Flaherty - 24 Aug 2006 4:22 AM - 4 messages
Does ASP.NET with ADO connecting to MS SQL Server use connection pooling by default if the connection string is always the same?  If not, how does one go about evoking connection pooling ? ...
Score Can DataSet or DataTable be the "DataSource" of crystal report?
pedestrian via DotNetMonster.com - 24 Aug 2006 12:47 AM - 3 messages
I program using ADO.NET and plan to generate a crystal report. Can DataSet or DataTable be the "DataSource" for a crystal report (just like DataGridView) which simplify display of rows and columns? What make up the data source for crystal report? ...
Score Update joined TableAdapter
Magnus - 23 Aug 2006 10:43 PM - 1 message
Hi! (Read this with font courier new or equal) I have a table adapter which fills a datatable with data from two sql tables: Properties, and PropCompanyInfo: tbl1.PropertyID      pk identity(0,1) tbl1.PropertyName ...
Score Restore fail in Asp.Net
ad - 23 Aug 2006 10:27 PM - 2 messages
I use asp.net to restore a SqlServer database. I use the code: Restore database MyBase from disk = 'c:\xxx.bak' with Replace But after execute, it display an error message: Restore fail, the user did not have the previllage to RESTORE DATABASE ...
Score Accessing ODBC DSNs
Alex Maghen - 23 Aug 2006 10:06 PM - 2 messages
Way back in the old ASP days, it was possible to open a Database connection by providing only the name of the ODBC DSN that I'd created earlier. I didn't need to indicate which driver, whether the connection was to SqlServer or ...
Score DeriveParameters throws NummReferenceException
rockdale.green - 23 Aug 2006 6:52 PM - 2 messages
Hi, I am coding under .Net compact framework and using System.Data.SqlClient connect to MS SQL server through PDA USB cradle. I can execute stored procedures and sql select or updates statements. But I always get NullreferenceException when I try to use ...
Score Please tell me what is wri=ong
Adrian - 23 Aug 2006 5:05 PM - 3 messages
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; using System.Data.Common; namespace trial_a {     public partial class Form1 : Form ...
Score 1:1 Relation
Florian Lehner - 23 Aug 2006 4:35 PM - 5 messages
I have created a DataSet out of an SQL Server DB. In the server, there are several 1:1 relations, in the graphical representation of the DataSet in Visual Studio, it seems as if there were just 1:n relations. Why? Is it a bug ...
Score First connection to the database (Oracle) from a .Net console application takes 6 sec
Sunil Menon - 23 Aug 2006 4:31 PM - 4 messages
Dear All, I am using Oracle Client 8.1.7.0.0. My .Net (c#) console application makes a connection to Oracle database and has following code Console.WriteLine(DateTime.Now.ToString()); OracleConnection NDPConnection = new OracleConnection("User ID=<Username>;Data Source=O801;Password=<Password>;"); ...
Score subquery is not working for CSV files
Shiplu - 23 Aug 2006 3:52 PM - 3 messages
HI, this is my query, I am using C# , OleDB, ADO.NET and CSV files. SELECT [GATEWAY],[IPADD], SUM(MOBILE),SUM(NWD), TOTAL FROM [rawdata.csv]  where CVDate([START]) >= '7/29/2006' AND CVDate([END]) <= '8/23/2006' AND [GATEWAY] IN (SELECT [GATEWAY] FROM [gateways.csv] ...
Score Avoid hardcoding DataKeyField property of DataGrid...
Jeff Robichaud - 23 Aug 2006 12:51 PM - 3 messages
Hi, How can I avoid hardcoding the name of the DataKeyField property of a DataGrid ? Like: datagrid.DataSource = someSource; datagrid.DataKeyField = "employeeId"; The above works but it's not what I want, because whenever the name of the field changes, I'm screwed. Avoiding this is the purpose of strongly-typed ...
Score RE: System.OutOfMemoryException
RobbieG - 23 Aug 2006 9:55 AM - 2 messages
I also am encountering the same issue, have you managed to solve this From [link] Posted via DevelopmentNow.com Groups [link] ...
Score Can not find SQL Server Management Studio
Alfred Malleier - 23 Aug 2006 7:31 AM - 5 messages
Hello, today I installed the Microsoft SQL Server 2005 Standard Edition but after insatallation I can not find the SQL Server Management Studio (Enterprice manager) Need I to install it separately? Regards, Alfred M. ...
Score Problems with using ODP.NET provider
sjoshi - 22 Aug 2006 10:01 PM - 4 messages
Hello All I'm using this query Select Distinct(prj.Name) as PrjName, prj.oid as PrjOid From SITE61.PRJMGTProjectRoot prj, SITE61.CORERELATIONDEST ic, SITE61.PRJMGTDatabase pd Where prj.oid=ic.oidTarget And ic.oid=pd.oid And pd.oid= :plant_oid ...
Score Accessing Data Source of SSAS Project from within an SSAS Assembl
Bjoern Hennig - 22 Aug 2006 4:07 PM - 2 messages
Hi all, within an SQL Server Analysis Services project we are using an assembly to retrieve dimension permissions based on data stored in a adminstration database. Currently we store the connection string used to access in the administration database within the assembly: ...
Score DataTable Edit Rows
Philip - 22 Aug 2006 3:52 PM - 2 messages
I've searched and tried a few of the things I seen but nothing really helped me.  I am in visual studio 2003 and using visual c++.  I created a table by typing in the data inside the IDE.  Inside the load event for the form I ...
Score Writing a Memo field to an Access DB with OleDB
Alfred Malleier - 22 Aug 2006 1:46 PM - 6 messages
Hello, I have big problem on updating an Access Memo field with OleDb. While the InsertCommand works, then UpdateCommand raises an exception: Syntaxerror in UPDATE-Statement. I tryed various work arounds (the last 3 days) with and without the CommandBuilder with allways the same result. ...
Score Why Must I Have "SET DATEFORMAT dmy" in Stored Proc?
JebBushell - 22 Aug 2006 1:06 PM - 2 messages
I'm calling a stored proc from C# and the call includes a datetime.  The exe can run on machine A or B but the database is on machine C.  When I run on machine A I need SET DATEFORMAT dmy in the proc or I get an 'out-of-range ...
Score problem facing on Convert the code in to C#
kamal - 22 Aug 2006 10:20 AM - 2 messages
This is the code i have. By usin this code we can overload the DownloadManager of the Internet explorer. Te class ServiceProvider have the function query service is returning some pointer in vb.net. We have commented that total code and there we displayed our own form to download ...
Score saving datatable as new table in database
moshe.raab - 22 Aug 2006 9:34 AM - 2 messages
i am creating a Datatable in memory and would like to save the DataTable as a new table in the database when i am done. How can I do this? thanks m ...
Score dataset safety?
Ausclad - 22 Aug 2006 2:45 AM - 7 messages
Hi,   I am currently looking at re-writing a payroll/timesheet application that is currently in Access.  The users need to enter timesheet hours for numerous employees. Up till now I have been experimenting and using strongly typed datasets as ...
Score The Ultimate Bittorrent Cheat
RatioBoost - 22 Aug 2006 1:54 AM - 2 messages
Auto Bittorrent Cheat is a Bittorrent client with a difference, It works just like any other Bittorrent client and is really easy to use, But it fakes your upload amounts to the tracker site in real time getting you a massive upload ratio & fastest possible download speed. ...
Score OCI.DLL: The specified module could not be found + OCIEnvCreate fa
imhl58 - 21 Aug 2006 11:35 PM - 3 messages
In VS2005 (Version 8.0.50727.42), I'm trying to create a "Data Connection" in the "Server Explorer" window ... I right click on "Data Connections" ... and choose "Add Connection" ... In that window, I change the "Data Source" to "Oracle Database" ... ...
Score Oracle 10g Float and Double Database Datatypes are not supported
Valkyrie-MT - 21 Aug 2006 10:49 PM - 7 messages
Greetings, I have data values that are inherently of type Double.  Current we are using Oracle Column Datatype NUMBER.  When I create a TableAdapter in VS2005, the database table column information is read from Oracle and a new Table is ...
Score multi threaded database access with transactions
Smokey Grindle - 21 Aug 2006 7:54 PM - 2 messages
I have a program that runs on multiple threads working with database sproc calls... these need to be all ran in transactions.... how can I get something similar to parallel transactions or at least to the point where they dont cause each other to crash? They all work with the same database ...
Score MySQL database connection
rockdale.green - 21 Aug 2006 5:13 PM - 2 messages
Hi, All This is the first time that I code asp.net against mySQL database. I am confused that which connector should I use 'cause I do not want make the wrong choice and have some problems later on? one is from mySQL official website ...
Score Global Cancel
Joe - 21 Aug 2006 4:10 PM - 6 messages
I want to create a single Cancel method to cancel all changes made to any fields in a UserControl. I have a method that creates a Binding object, adds it to a collection and than adds the Binding to the control. ...
Score Retrieving database schema
Mark - 21 Aug 2006 3:56 PM - 3 messages
Hi Everyone: I’m new to the VB.NET development platform, and I’m trying to understand how to retrieve database schema information from either of these databases: Microsoft Access, Microsoft SQL Server 2000, or Oracle. I recently bought a reference book titled “Beginning VB.NET Databases” by ...
Score Count rows in dataset WHERE ...
Assimalyst - 21 Aug 2006 2:23 PM - 5 messages
Hi, I am attempting to do a number of count functions on a single table of data for presentation in an ASP webpage. The functions are number today, number this week, number this month etc. As the Database table is large it does not make sense to query it directly a number of times. ...
Score Oracle TransactionScope Rollback issue
malob - 21 Aug 2006 1:31 PM - 1 message
I am having problems re-openning closed Oracle connections (System.Data.OracleClient.OracleConnection) when using TransactionScope and using the Rollback feature (i.e. not calling Complete on TransactionScope).  I create a simple for loop with a TransactionScope statement inside.  All ...
Score Newbie needs help
clayton.curmi - 21 Aug 2006 9:36 AM - 2 messages
Hi everyone, I'd like to access a database using C#. I've installed the Visual Studio 2003 and mysql essential and mysql administrator. On Visual Studio I go on server view and right click on SQL Servers, then I click ...
Score dataset - Insert-query with stored procedure using wizard
Jon Haakon Ariansen - 21 Aug 2006 9:33 AM - 3 messages
Hi all, I don't know where to publish this question but hope this newsgroup is okey. I'm working in Visual Studio 2005 and are now creating a dataset file where I will do all the transactions with the database. ...
Score Keyword similar to App(VB6.0) in VB.NET
Jack - 21 Aug 2006 5:52 AM - 3 messages
Hello all, Can anyone here suggest me the keyword App similar to that in VB.NET? Iam developing a application which uses MS-Access as the database. In vb6.0  I use App to find the path and connect to the database ...
Score OleDb vs. Sql Interoperability
Alex Maghen - 20 Aug 2006 3:10 PM - 7 messages
I'm building a lot of ASPX pages and business objects that consume and interact with database data. Some of this is done with data-binding, some is done with programmatic calls to Stored Procedures, Views, etc. I've created a DB class that I use to simplify and make consistent my ...
Score Strange error message
cashdeskmac - 20 Aug 2006 1:24 PM - 2 messages
I am inserting a new record into a table which has 4 columns, the first being an identity column.  I am adding three strings to the other 3 columns using an ExecuteNonQuery.  I have set the values of the parameters for the ...
Score Insert Date into SQL c# - Correct Format
vividpetals@googlemail.com - 20 Aug 2006 11:09 AM - 2 messages
Hallo guys, I am getting bonkers (sorry). i have sql2005express/c#. I have calender and i get the dates right DateTime DeployDate = Convert.ToDateTime(Calendar1.SelectedDate); i tried putting the deployed date as a string and having Calendar1.SelectedDate.Convert.ToString as well ...
Score Databinding a check list box
John - 20 Aug 2006 1:35 AM - 4 messages
Hi I have a check box list box on a windows form. How can I data bind it to an access table. I don't need a multi-tier solution. Just a solution. Thanks Regards ...
Next »