Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Exporting data from a DataTable in format other than XML
michael - 25 Feb 2006 9:43 PM - 5 messages
Is there a simple way to export the data from a DataTable (or even better a DataView) in a format other than XML? In particular, how about a simple way to export and save data directly to a new .xls file. I guess that if I needed ...
Score Consuming RSS Feeds
Francis - 25 Feb 2006 8:42 PM - 3 messages
Hello,     I recently decided to try and consume an rss feed and put it into a datagrid, just to try it out. I used the following code: DataSet dsXml = new DataSet();          XmlReader xmlTr = new ...
Score character sets in .net
Dror - 25 Feb 2006 3:22 PM - 2 messages
Hello, I'm developing a winforms applciation which retrive data using ado.net. My Database has an  WE8ISO8859P1 character set and the data is in hebrew. My Problem is when I'm trying to retrive the data I get "??????". ...
Score bug: increasing ADO.NET 2.0 timeouts ?
herbert - 25 Feb 2006 3:04 PM - 3 messages
Reading the MP3 header of hundreds of MP3 files in many subdirectories results in an exception (Vs.2005, VB.NET): "The CLR has been unable to transition from COM context 0x1a1c68 to COM context 0x1a1dd8 for 60 seconds. The thread that owns the destination ...
Score Dynamic SQL generation - How do I set the key column information manually?
Rune B - 25 Feb 2006 12:14 PM - 3 messages
I use in my datalayer the following methods to fill and update data, and it works like a charm. But recently I had to add a dimension to the SqlServer table, - a new field that allowed more than one instance of the same customer (same customerID) ...
Score Problem with System.Data.SqlConnection (Application Verifier: Hand
Karthik - 25 Feb 2006 5:41 AM - 1 message
Hi All,    I have faced a problem while connecting to the SQL SERVER 2000 instance using ADO.NET (in .NET Framework v2.0.50727). The error reported was Invalid Handle Exception in Application Verifier 3.0 under Handles. The stack trace of the exception is given below. ...
Score Need help with CDONTS or other object to receive mail in a specific way
Vanessa Lee - 24 Feb 2006 10:21 PM - 2 messages
Hello, Is it possible to write a script using CONDTS object to read all emails from the SMTP IIS "Drop" folder without changing the username and email address in LogonSMTP? or is there completely another way to do it. Here is what I ...
Score How to get the record lock status in .net
Joy - 24 Feb 2006 9:08 PM - 2 messages
Hello: After one transaction be started, but before the transaction be commited, if another transaction query the same records, how to get the locked status of the records. Thanks. ...
Score How to get the record locked status in .net
Joy - 24 Feb 2006 9:04 PM - 3 messages
Hello: After I start a transaction with  "REPEATABLE READ", before I commit, if I begin another transaction to the same records, how can I get the locked status of these records? Thanks. ...
Score Problems with Custom Databinding
Vivek M - 24 Feb 2006 8:23 PM - 3 messages
Hello there, i am running into a databind issues. I am trying to bind a dataview to collection of user control which are all child of another user control. The problem is i get the same first row data in all the childrens. Here is my ...
Score newbie: DataSet update question
deko - 24 Feb 2006 7:59 PM - 3 messages
I can get my DataSet to update with code in the constructor of the class that creates the DataSet, but not using a method in that same class. Why is this? private DataSet projectData; //this is the constructor of class AsaDataAccess ...
Score Help Please ADO .Net 2.0 Query at RunTime HELP
spooke - 24 Feb 2006 7:52 PM - 3 messages
HI all     now are two days, 20 hours of work that i'm on this problem without a solution!!! I think i'll become mad!!! Here is the problem: I Use C# 2.0 (VS .Net 2005) with thyped dataset ...
Score Connection Pooling holding onto errors?
jazzMan007 - 24 Feb 2006 6:10 PM - 1 message
Hey All - I've been running into a problem, think I have a solution, and would like some input on it. I'm using ado.net 2.0 and sql server 2005. I'm writing a layer to create and maintain the database of our product. The ...
Score SqlCommand slow on INSERT
John Bailo - 24 Feb 2006 5:43 PM - 21 messages
I have a c# program that loops through a table on a DB2 database. On each iteration it assigns data to values in the SqlParameter collection.   The command text is an INSERT statement to a Sql Server database, run with an .ExecuteQuery   I enclosed the loop in a ...
Score Databound dropdownlist
Sean - 24 Feb 2006 3:39 PM - 1 message
binding to a column in my table   = fine no problem. Having my dropdownlist only produce DISTINCT values without giving it its very own SQLDataSource control  = problem I have 8 pulldowns for a test page I would like to populate those 8 pulldown ...
Score MissingSchemaAction.AddWithKey fails with DISTINCT
Howell Page - 24 Feb 2006 12:43 PM - 2 messages
I'm using a SqlDataAdapter to fill a DataSet with MissingSchemaAction set to AddWithKey. Normally it discovers the table's primary key successfully, but when I added DISTINCT to the query, it failed to set the PK. Is this a known issue, and is there are workaround? ...
Score Bind Variables Using ODP.NET
vm.shinde - 24 Feb 2006 12:37 PM - 1 message
Dear All,    I am Trying to use Bind Variables using ODP.NET and calculate the performance The Scenario at my end is: 1. Win Form application that creates Sql statements to be executed. 2. Oracle database 10g. 3. Using ODP for Data Access ...
Score creating database and database tables programmatically(SQL-Server2
herbert - 24 Feb 2006 12:19 PM - 2 messages
1) I assume there is a better way than good ol' ADOX or inline SQL in .NET 2.0 and SQL Server 2005 to create/delete databases and database tables and get metadata about tables from .NET 2.0 code. ...
Score SQL Server Express Attach
elziko - 24 Feb 2006 10:09 AM - 5 messages
I am trying to create a conneciton to an SQL Server Express database from ..NET. Here is my connection string: 'Data Source=.\SQLEXPRESS;AttachDbFilename="c:\database.mdf";Integrated Security=True;Connect Timeout=30;User Instance=True' However, I get the following error: ...
Score format problem using msacess database
rt - 24 Feb 2006 10:06 AM - 2 messages
hi iam using vs.net 2003, vb.net,Ado.net msacess, a field is date/time and format dd-mmm-yy hh:nn:ss when i try to use this   dr("insp_datetime") = Format(Convert.ToDateTime(D), "dd-MMM-yy HH:mm:ss") ...
Score Q: Whitespaces in WHERE
G .Net - 24 Feb 2006 9:47 AM - 15 messages
Hi I'm hoping that somebody can help me with the following: Is there a way to perform a WHERE search where white spaces are ignored? For example, suppose I have a field called [CompanyCode] which has entries likes "aaa 65", "bb 5 44" etc. ...
Score TableAdapter and ROW_NUMBER problem
rpuertas - 24 Feb 2006 8:55 AM - 2 messages
Hello, Visual Web Developer 2005 Express Edition and SQL Server 2005 Express: I want to run a paged query within a TableAdapter. In the TableAdapter Query Configuration Wizard" I write the next query: SELECT  usu_id, usu_name, usu_password FROM     (SELECT TOP (@StartRowIndex + @NumRows - 1) ROW_NUMBER() OVER ...
Score NullReference Exception on DataTable.Rows.Add
Raistlin - 24 Feb 2006 8:24 AM - 4 messages
Hi, I would just like to advice on how to fix a problem I'm having in adding a new row to a DataTable. Anyway, my problem is that this code always gives me the dreaded "object reference not set to an instance" exception: ...
Score Trouble removing cookies
Nathan Sokalski - 24 Feb 2006 4:26 AM - 4 messages
I am having trouble removing cookies that I created with my site. Here is the code I am using to try and remove them: If Not Request.Cookies("username") Is Nothing Then Response.Cookies.Remove("username") If Not Request.Cookies("password") Is Nothing Then ...
Score ADO.NET error
David R - 24 Feb 2006 2:04 AM - 4 messages
Maybe someone can see what I am missing.  I have a class making a call to a stored procedure: cmd.CommandText = "spSubjectCodesUpdate"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@subjectcode", SqlDbType.VarChar, 4, subjectCode); cmd.Parameters["@subjectcode"].Direction = ParameterDirection.Input; ...
Score Mispost "Web Application Architecture Question" should be in ASPNET
arthernan - 24 Feb 2006 2:01 AM - 1 message
I must be falling asleep. but the previous post belongs on the aspnet group ...
Score Web Application Architecture Question
arthernan - 24 Feb 2006 1:45 AM - 1 message
A client of mine wants me to build a custom web application. For security reasons he does not want to install a database client/api on his DMZ zone. He wants to have an application running in their LAN that ...
Score RowFilter Failing
Spence - 23 Feb 2006 11:46 PM - 6 messages
I hope someone royally owns me using my own stupidity but follow this thought process if you will. vs.net 2003 .net 1.1, MSDE I have a table with three fields: PatientsDisplayImageTypes PatientsDisplayImageTypeID (GUID), PatientID (Guid), ImageTypeID (Guid)                       PK FK FK ...
Score Help! Out of Memory Exception - using dataset as datasource for re
Debi - 23 Feb 2006 6:10 PM - 1 message
Hi,     I'm using a dataset close to 11 MB as the datasource for my crystal reports. I've 15 subreports in my report, of which all uses this dataset as the datasource but some have Selection Formula applied to the report document to ...
Score Connections in pool not being reused
David Kirkman - 23 Feb 2006 4:29 PM - 8 messages
I have a C# Windows Forms app. (Framework 1.1 VS 2003) using a SQL Server 2K database. It appears that despite closing and disposing all connections immediately after use and always using the same connection string the connections in the connection pool are not being reused. ...
Score Weird Duplicate Change Event Error from XSD.exe
Mark Olbert - 23 Feb 2006 4:17 PM - 2 messages
Can someone explain to me why the following simple dataset: <?xml version="1.0" encoding="utf-8"?> <xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">     <xs:element name="meter_params"> ...
Score ODBC Microsoft Access Driver
somersbar - 23 Feb 2006 4:13 PM - 3 messages
hello all, im trying to connect to a microsoft access database from an ASP.NET web form. i keep getting the following error though: ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use. ERROR [IM006] [Microsoft][ODBC Driver ...
Score Table adapter query at runtime
spooke - 23 Feb 2006 3:57 PM - 1 message
Hi all     for a partcular form i qhant to make a query for a table adapter at runtime but i don't know how. Someone can help me? regards gian paolo ...
Score Cascading Deletes in ADO.NET (Please Help!!!)
rguarnieri - 23 Feb 2006 3:47 PM - 8 messages
Hi !! I'm trying to delete a record in a parent/child relation, so, when I want to delete a parent record, the childs will be deleted automatically. Does anyone have an clear example of how to use cascading deletes using ado.net in visual basic 2005? I didn't find any ...
Score Followup to Memory leak in SQLDataReader()
Ken Varn - 23 Feb 2006 3:08 PM - 1 message
This is a follow up to the post that I made concerning a possible memory leak in SQLDataReader(). I have finally narrowed down the cause.  The managed C++ thread that was using the DataReader had made a call to CoInitialize() because it formally ...
Score CommandTimeout
Carl Howarth - 23 Feb 2006 10:01 AM - 2 messages
Hello all, Just a quick Q.... If my query reaches the command timeout limit I set, will ADO.NET automatically kill the process on SQL Server? Thanks ...
Score Book recommendations
Toby Groves - 22 Feb 2006 11:19 PM - 3 messages
Just a quick question, not strictly on-topic for this group but I'm hoping the assembled wisdom in here can help me out :) Can anyone recommend any good books that deal with multi-layer software design, of the presentation/business logic/data access type structure? ...
Score Could not find stored procedure...
googler - 22 Feb 2006 10:28 PM - 1 message
I was working with the .NET and SQL server stored procedures. I got the error Could not find the stored procedure error. I checked all the news group but every one was saying that I was pointing to the wrong DB and permissions. I just wanted to add one ...
Score Forcing DataView to sort/filter without calling Control.DataBind?
ejstembler - 22 Feb 2006 9:58 PM - 3 messages
I've noticed that applying a Sort and/or RowFilter property to a DataView does not take effect until you bind the DataView to a control and call the control's DataBind method.  I'm sure DataBind does some ...
Score Can UNC path be used as Data Source argument in OLE DB connection string?
GY2 - 22 Feb 2006 9:09 PM - 8 messages
I'm having some trouble getting this to work and can't find any reference to whether or not it's okay. It must be legal I'm betting. ...
Score Output SqlParameter + SqlTransaction
Nik - 22 Feb 2006 8:51 PM - 3 messages
Hello, I use an output parameter to update identity column in my table after inserting new row and it works fine - identity value is read from the database and written to approprate field in DataRow. However, if I do the inserting inside a transaction and call the Rollback method after ...
Score How retrive data in sqldatasource?
VB Programmer - 22 Feb 2006 7:39 PM - 4 messages
I have a sqldatasource on a webform.  How do I (in code) retrieve the value of a particular column in the first row?  Do I have to save the sqldatasource SELECT results into a datatable and look at it that way?  Code ...
Score Sql Parameter not found error
Jim H - 22 Feb 2006 4:21 PM - 5 messages
Learning ADO.NET is proving to be difficult.  The last statement below produces the error indicated right above it (Parameter not found) -- and I have no ideal as to why.  The Count Property for the Parameters Collection contains 1.  What am I overlooking? ...
Score how to retrieve ddl script from a db object..?
Jan - 22 Feb 2006 3:28 PM - 6 messages
Hi, How to get (plain text) ddl script for databese objects in a sql server db..? for example: CREATE TABLE [dbo].[T_BatchLog] (   [ndBatchLog] int IDENTITY(1, 1) NOT NULL,   [ndBatchRun] int NOT NULL,   [ddDate] datetime NOT NULL, ...
Score Wildcard, filter and dataview
Michael - 22 Feb 2006 12:58 PM - 1 message
Hello, I am using xml files as data tables, in one i have a field named "Cours" which represent multiple boolean field in one string field. I work with CSharp code on VS2005. Explanation : i have 9 elements which can take values Yes or No, so instead of making 9 ...
Score Suddenly ORA-12154: TNS:could not resolve service name
mablao - 22 Feb 2006 12:24 PM - 1 message
I´m using ODP.NET and after a long transaction with the database (Oracle 8.1.6) I get the error ORA-12154: TNS:could not resolve service name. I have do stop/start de IIS server to resoolve the problem. ...
Score xsd schema file always creates two tables at drag/drop, why?
Axel Dahmen - 22 Feb 2006 9:37 AM - 1 message
Hi, I'm a Newbie to xsd when it comes to the VStudio designer (VS 2k3). Now I have a problem I don't know how to deal with, perhaps one of you can help me with this: Two weeks ago I've created a test Web Application project and added a xsd ...
Score Problem updating dataset.
Nickl - 22 Feb 2006 7:16 AM - 1 message
I am having difficulty updating values in a dataset when they have comboboxes bound to them. The trouble is in the following code; Dim rowContract as datarow rowContract = DsSalesContractEdit.pSelectSalesContractBasic.Rows(0) ' the dataset only has one row   rowContract.BeginEdit() ...
Score Data Type mismatch in criteria expression!
idiot - 22 Feb 2006 5:50 AM - 1 message
Source code:     DataRow rzsfRow = dataTableRZFS().NewRow();     ...     rzsfRow["HZRZYF"] = DateTime.ParseExact("200602", "yyyyMM", null);     ...     string sql = "UPDATE RZSF SET HZ_RZYF=@HZ_RZYF ... WHERE ...";     ...     OleDbParameter param = this.command.CreateParameter(); ...
Score Access 97 Provider for ADO.NET 2.0
R. Ian Lee - 22 Feb 2006 4:45 AM - 5 messages
I'm building a .NET 2.0 app (C#) that needs to connect to an Access 97 database.  I'm planning to use the Enterprise Library 2.0 Data classes to make things easier.  I can't figure out the correct configuration to use to ...
Score Bulk inserts into SQL Server 2000 from Flat Files
Jason Allred - 21 Feb 2006 10:23 PM - 5 messages
This is my first post, so if this has been addressed before, please excuse my ignorance... I'm writing a Window's Service in VB.NET to take information from flat files that contain GPS information and subsequently save them to a SQL Server ...
Score Generated update obviously fails on readonly field
chaprot - 21 Feb 2006 8:37 PM - 4 messages
Hi, With VS 2005/NET 2.0, I add a datasource in my project, and the Dataset Designer creates automaticaly the SELECT, INSERT, UPDATE and DELETE functions/clauses. BUT the UPDATE include all the fields of the table, included some read-only ...
Score Self Referencing Result Not Clean
Marty Cruise - 21 Feb 2006 8:19 PM - 2 messages
I am trying to load a table with a self relation, but can't seem to figure out how to load only top-level parent rows at the top of the data hierarchy.  Instead, all rows are coming across to the top level of the hierarchy, as ...
Score Possible memory leak in SQLDataReader().
Ken Varn - 21 Feb 2006 7:31 PM - 5 messages
I have a managed C++ application that is exhibiting a memory leak.  I isolated the leak down to a section of code that basically uses a managed ADO.NET SQLDataReader object.  The leak seems to occur on the ...
Score Need Help with the Next Step
Bernie Hunt - 21 Feb 2006 6:29 PM - 3 messages
I'm working on the learning curve between ADO and ADO.net. I'm stuck at how to work with unbound data, vs data bound to a grid. All the start up references I've found show how to connect data to a grid. I need to process ...
Score column names in a strongly typed dataset
Sergey Zuyev - 21 Feb 2006 4:20 PM - 1 message
Is there a way to get the column  names in a strongly typed dataset. If I have a dataset and want to set RowError to the name of the column without hardcoding it. I want a compile time error if the name of the column does not ...
Score Column 'column' does not belong to table Table
Miro - 21 Feb 2006 3:15 PM - 1 message
I get this strange error: Column 'PNR ' does not belong to table Table It is strange because the columnname in the dataset is PNR. String SQL = "SELECT PERSONNR AS PNR, ... FROM theTABLE"; OleDataAdapter.Fill(ds); foreach (DataRow dr in ds.Tables[0].Rows) ...
Score comments column retrieval from SQL Server
Brian Henry - 21 Feb 2006 3:14 PM - 1 message
How would you go about retrieving a tables comments (description) in ADO.NET on a SQL Server 2005 server? ...
Score working with ascii character set in oracle
Dror - 21 Feb 2006 2:51 PM - 2 messages
Hello, I have an Oracle 9i Database that work with WE8MSWIN1252 charset. lately I'd migrate from VB6 to .NET and I Understood that the CLR is working in Unicode. Now I've got a situation when I retriving data (in hebrew)  of the database ...
Score How to use bind variables effectively for Sql performance?
Sunil Menon - 21 Feb 2006 2:25 PM - 7 messages
Dear All,    We are evaluating a few techniques to optimise our Sql statements being executed at the database. Scenario: 1. We have a WinForm application that creates Sql statements to be executed. 2. We have an Oracle database 10g. ...
Score Datatable Merge query
Campbell Wild - 21 Feb 2006 1:08 PM - 4 messages
Hi, I am trying a simple approach to updating a datatable. I have a set query that I run on the database.  This populates a datatable, 'dtMyData'. Every X seconds, I re-run the query and store in a separate datatable ...
Score Exposing Northwind on a Web Site
Oriane - 21 Feb 2006 9:30 AM - 3 messages
Hi, what would be the simplest way to expose a database like Northwind on a Web site ? I mean, give the Web user a way to display the provider of a region knowing the region code... This would be a read-only web site. I would like ...
Score Pivot can be use when creating TableAdapter
ad - 21 Feb 2006 8:46 AM - 2 messages
I use the new feature of TableAdapter of VS2005. I want to use PIVOT in ths SQL when I create a TableAdapter, but it fail. The system told me the PIVOT is not supported. How can I do? ...
Score HELP!! - Data type mismatch in criteria expression
Bantha - 21 Feb 2006 8:24 AM - 2 messages
Hi i keep getting a "Data type mismatch in criteria expression. " error with my asp page in thei sectionof code and i cant seem to find the cause? can any one help *******************************************CODE******************************************************** Sub Updatedatabase ()         Strinsert = "Insert into tblgallery (Gallery_title, Gallery_item, ...
Score HELP!! - Data type mismatch in criteria expression
Bantha - 21 Feb 2006 8:15 AM - 2 messages
Hi i keep getting a "Data type mismatch in criteria expression. " error with my asp page in thei sectionof code and i cant seem to find the cause? can any one help *******************************************CODE******************************************************** Sub Updatedatabase ()         Strinsert = "Insert into tblgallery (Gallery_title, Gallery_item, ...
Score HELP!! - Data type mismatch in criteria expression
Bantha - 21 Feb 2006 8:14 AM - 2 messages
Hi i keep getting a "Data type mismatch in criteria expression. " error with my asp page in thei sectionof code and i cant seem to find the cause? can any one help *******************************************CODE******************************************************** Sub Updatedatabase ()         Strinsert = "Insert into tblgallery (Gallery_title, Gallery_item, ...
Score InvalidCastException when fill dataset
infmpv00 - 21 Feb 2006 7:37 AM - 2 messages
Someone can help me to solve this problem in my code?¿ This is the code: private static DataSet executeQuery(string strConnectionString, string strQuery) { try     {     DataSet dsResult =  new DataSet();     OleDbConnection conn = new OleDbConnection(strConnectionString); ...
Score Regarding Connection object behaviour
Mrinal Kamboj - 21 Feb 2006 6:16 AM - 9 messages
Hi , I am using OracleConnection object from Oracle ODP.net provider and following is the behaviour which i am finding bit strange : To start with , my argument is based on following facts : 1. Connection object is a reference type object . ...
Score How to remove resource?
deko - 21 Feb 2006 4:47 AM - 2 messages
I'm getting a warning on build (VS05): The file 'Resources\myGif.gif' could not be added to the project.  A file with the same path already exists in the project. I've searched the entire project (including the Resources.Designer.cs) ...
Score TimeStamp field, help needed
Jim H - 21 Feb 2006 3:35 AM - 4 messages
I am attempting to update a Database Table thru a DataAdapter using a DataSet. I get this error: "Cannot insert a non-null value into a timestamp column.  Use INSERT with a column list or with a default of NULL for the timestamp column." ...
Score Parse, ToString, and "Null"
Chris - 21 Feb 2006 12:30 AM - 3 messages
I was thinking that these two methods should be inverses of each other, but that doesn't appear to be consistently the case in MS code.  Also, I kind of think that Parse should not be case sensitive; 1e10 == 1E10. ...
Score Losing Database Connectivity
Neal - 20 Feb 2006 11:35 PM - 2 messages
All, I have a windows service which polls the database every 10 seconds (10000 ms).  When I change the frequency to 100 ms.  After a few hours, the Windows Service does not even connect to the database anymore, nor ...
Score Newbie: Can I save objects in a DataTable?
deko - 20 Feb 2006 9:49 PM - 5 messages
Can I save Array objects in a DataTable?  If I can, I assume the Framework has methods to serialize this out to XML.  What I am trying to do is create an in-memory database when a form opens, and persist it out to XML when the ...
Score Saving DataTable as XML
Praveen - 20 Feb 2006 9:16 PM - 8 messages
Hi All, I was looking for a way to save the Different DataTables in a dataset as differnt XML files. The WriteXML function is for Dataset and it saves all the dataTables into one file. Is there any thing ready made. ...
Score SqlCacheDependency Strongly Typed Dataset
chris - 20 Feb 2006 8:52 PM - 2 messages
Hello all, Background: Using .NET 2.0, Sql Server 2005, SqlCacheDependency is utilized successfully against SqlCommand objects elsewhere in the code (in other words I have successful instances of using SqlCacheDependency).  ASP.NET website built in 3 separate tiers: ...
Score Generated Strongly Typed Dataset and AutoNumber
Remi@newsgroups.nospam - 20 Feb 2006 7:19 PM - 2 messages
Ive been struggling for hours on a very simple problem. How can I use the VS2005 Dataset Designer generated strongly type dataset to insert many rows into 2 two table linked together by a simple Parent/Child relationship? I am using SQL server 2000. ...
Score Issue with returning Identity Number
Charles - 20 Feb 2006 5:11 PM - 3 messages
I have a procedure in vb.net that needs to insert records into one table and use the new key value to is link with a transaction in another.  I have a stored procedure which inserts records in the first ...
Score Setting default Command Timeout
Olav - 20 Feb 2006 3:36 PM - 2 messages
Is there a way to set the the deault value of the command timeout instead of setting the SqlCommand.CommandTimeout for every call to the database? Either in my program or in SQL Server. ...
Score xsd definition to auto-generate a key field
timnels - 20 Feb 2006 3:34 PM - 1 message
Is there a way to create a xsd "key" field such that when I insert a record into the dataset the "key" field is auto-generated like some databases use rowid? Thanks. ...
Score OleDBProNet 1.5.0.1 released for managing large rowset of records
Yuancai (Charlie) Ye - 20 Feb 2006 3:00 PM - 3 messages
Hi, All:     OleDBProNet version 1.5.0.1 is released at [link]     OleDBProNet is integrated with DataGridView with OleDBProNet. Binding OleDBProNet with a DataGridView control becomes extremely easy. This is ...
Score MSDTC, Transaction, Context and Threads
Gian Paolo Clarici - 20 Feb 2006 2:32 PM - 2 messages
I've a problem using multithreading and MTS. I'm using framework 1.1 Basically I want, from the Main Thread , to start a (distributed) transaction. then I want to start 2 new threads to perform some Database operations, each ...
Score Fatal error 682 and SqlDependency
Efran Cobisi - 20 Feb 2006 9:59 AM - 4 messages
Hi, In the web application my company is developing, we are trying to use the SqlServer 2005 Notification Services feature to get notified about changes in recordsets we query. Since our application server is asp.net, we partially use its embedded support for that feature; in short, when our ...
Score ADO.NET 2.0 & MSDE & Win98
Mircea Pleteriu - 20 Feb 2006 9:08 AM - 7 messages
Hi all, I've implemented a .NET Windows Forms application with VS 2005 and .NET Framework 2.0 which must be deployed on Windows 98 platform. The MSDE will be installed on Win98 as the SQL Server to which the app will connect. ...
Score Inserting large number of records are too slow
Yin He - 20 Feb 2006 5:20 AM - 5 messages
I am developing a tool to upload huge log files into SQL Server 2005. The method I use is DbDataAdapter.Update() and I also set the UpdateBatchSize property to 5000. Wen I upload a 2M bytes log file, which contains about 30000+ records, to ...
Score Fill Dataset with Multiple Tables
Robert Bevington - 19 Feb 2006 10:14 PM - 2 messages
Is it possible to fill a predefined dataset with all the tables of a database without knowing what the table names are. The SQL string would be something like this: SELECT * FROM *. I want write this in code and not ...
Score DataSet as argument for Sql server stored procedure
henk gijsbert - 19 Feb 2006 4:08 PM - 4 messages
Can I use a dataset as an argument for a SQL server stored procedure that I want to call from ADO.NET? ...
Score Type 'ADODB.Connection' is not defined.
Joe Befumo - 19 Feb 2006 3:03 PM - 2 messages
I'm getting the following error in my application: Compiler Error Message: BC30002: Type 'ADODB.Connection' is not defined. Source Error: Line 112: if(Request.Form("HdnQuestionCount") = 0) thenLine 113:Line 114: Dim objDataConn as ADODB.ConnectionLine 115:        Dim objRSList as ...
Score How to get meta data info in ADO.NET
CECIDer - 19 Feb 2006 8:59 AM - 3 messages
Hi, We are developing a Windows Form application that try to retrieve the Database Schema from MS SQL Server and Oracle. The application is developing under Visual Studio .NET 2005 with the use of Schema API from ADO.NET 2.0. ...
Score Readonly Connection
Bojan Kuhar - 19 Feb 2006 8:54 AM - 7 messages
Can one open a read-only connection or have a read-only command? My application creates a SQL query depending on choice that user makes  on the form. I am afraid that somwhere down the line somebody will try some sort ...
Score Extract image dimensions (height, width) from Base64 String?
Neo Geshel - 19 Feb 2006 7:21 AM - 1 message
Greetings. I have managed to stitch together an awesome method of posting text along with an image to a database, in a way that allows an unlimited number of previews to ensure that text and image are perfect before submission. This involves converting any uploaded image to a Base64 ...
Next »