Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Using OleDb with Enterprise Library 1.1 or 2.0
Stefano Del Furia - 1 Apr 2006 6:53 PM - 1 message
Hi all, i know that the EL can be used with SQL, Oracle or DB2 database and i know  a MySql connectot for this great pattern. But i would like to use it even with OleDb provider. Could someone tell me if is there an Helper for OleDb and Enterprise  ...
Score Convert Dataset with Tables with Relations to Flat view
Joe - 1 Apr 2006 3:50 PM - 5 messages
Hi I have a dataset with 2 tables and Relations What is the best way to flatten the 2 files to a new table or xml or file I can loop thru table1 and get the childrows or I can do an Xpath on the xml but not sure how to get relation from xsd ...
Score Sorting a Dataset table
Jeronimo Bertran - 1 Apr 2006 6:27 AM - 9 messages
Hi, I need to export the contents of a DataTable in a Dataset to a text file in a particual row order.  I guess I need to use the DefaultDavaView but I think I am doing something wrong since traversing the rows in the table ...
Score Navigation using ODP.net
Nau - 1 Apr 2006 6:21 AM - 4 messages
Dear All,     i have establish a connection to Oracle 10g using ODP.net , i could populate data in a listbox/combo box, but i need to display these data in one by one , i mean navigation using ...
Score ASC-DESC
gurvar - 1 Apr 2006 3:25 AM - 3 messages
Hi, The Asc or Desc functions work well on the sql server, but when I try to use the parameters collection through ASP.NEt . The SQL statements doesn't execute the same way. Ex: I'm trying to sort months say as 1-Jan,2-Feb etc. ...
Score DBNULL
DK - 1 Apr 2006 2:31 AM - 3 messages
In the UI, there are some optional field but in the DB I want tto store NULL instead of empty string. Do I check for empty string for these values in the business layer when I am going thru each row in the datatable for Data ...
Score eMoovie - a new company - we need sponsors
eMoovie - 1 Apr 2006 1:30 AM - 1 message
Hello ! We are eMoovie, a young swiss start-up based in Geneva. We developed SICMovie, a novel technology for VOD security. This technology is not a DRM but a DRT (Digital Rights Tatoo). The goal of DRT is not to control the customer's use of the downloaded movie ...
Score Help connecting to Access DB from web service
Jeff Richardson - 1 Apr 2006 1:13 AM - 5 messages
I am creating a web service that returns data from an Access 2000 database using VS2005.  The Access database is located on a different server than where the web service is running.  The Access database is also opened by a ...
Score ODBC DataSet to Update Ole Access Table
rickn - 31 Mar 2006 11:01 PM - 1 message
I have a dataset that shows data from an ODBC connection and want to insert that data into an access data base. I'm able to create the record lock on the access table, but am unable to get any data inserted ...
Score Large Upload to SQL - Async?
Patrick - 31 Mar 2006 9:48 PM - 5 messages
Is there any possible way to upload a file into an image field in SQL Server asynchronously? Our users upload a lot of large files into a SQL Server, and we have no way of showing them progress.  ADO had an "AppendChunk" method, but it ...
Score How can I determinate if the Database exist before detach it?
ad - 31 Mar 2006 8:32 PM - 5 messages
I use the code below to detach a Database, but if the database does not exist, it will thow exception. How can I determinate if the Database exist before detach it? ***********************************************************************             string sConnection = "Data Source=......"; ...
Score How to set in XSD Shema, column not to allows DBNulls?
MilanB - 31 Mar 2006 8:05 PM - 1 message
Column has property AllowDbNull to set is it allowed or not to add DbNull. How to set this property in XSD Schema in design time? My object is to make an int field required... Thanks ...
Score deleted rows
Rick - 31 Mar 2006 7:37 PM - 1 message
I have a strongly typed dataset 'A' with a Customer datatable and data. I create a new instance of the same dataset ('B') and import rows into the 'B' Customer datatable from dataset 'A' Customer datatable. I delete a row in dataset 'B' Customer datatable and now want to mark ...
Score Is it possible to add DataRelation on Individual tables?
MilanB - 31 Mar 2006 5:30 PM - 2 messages
Hello I have two tables that do not belong to DataSet. They are individual. Is it posible to create DataRelation Or ForeignKey in this situation? I tried but on: childTable.ParentRelation.Add(dataRelation) got Null Exception. Thanks Milan ...
Score Delete using GetChanges
sjoshi - 31 Mar 2006 4:05 PM - 1 message
I'm using DataSet that fills data from a filestore (filenames, size, a DelMe bool coln, etc). Now I want to delete rows which have DelMe set to true. Since I'm using a DataAdapter here, which would be the best ...
Score IndexOutOfRangeException - Index was outside the bounds of the array.
Doug McCormick - 31 Mar 2006 2:59 PM - 8 messages
We are encountering an extremely odd issue. We process incoming files for customers and output text files to produce printed material. Then an XML file containing the fields of the original file along with all fields necessary to produce the output text files are saved as an XML file. If an individual's ...
Score OLEDB: UpdateCommand fails
Coen - 31 Mar 2006 2:58 PM - 4 messages
Hi, can anyone help me with the following. MS Access 2002 database, Northwind, Customer table. In VB.NET using a datagrid and a dataset to fill the datagrid. I'm trying to insert, update and delete records in the datagrid. ...
Score Data components design question
baba - 31 Mar 2006 2:48 PM - 2 messages
Hi all,   I'm new to .NET but have quite a long experience as OO developer. I've been reading lots of documentation in order to get started with the SDK. First I started with on-line documentation about ADO.NET and now I am ...
Score AllowDBNull in DataTables
elziko - 31 Mar 2006 2:19 PM - 2 messages
I use a data adapter to fill a DataTable (that contains no row or columns) with data from a table in my SQL Server Express database. The columns that the DataAdapter creates in my DataTable all have the correct datatype but each is created so that AllowDBNull = True. However, ...
Score SqlDataReader Function From a VB6 refugee
Paul Ilacqua - 31 Mar 2006 1:18 PM - 9 messages
All,      I'm trying to create a DataReader Function to call from within my class to open a simple datareader. I have thoroughly read the Data Access Patterns and practices and do not believe in using canned code right off the bat. I want to rebuild the canned ...
Score ODP .net
Nau - 31 Mar 2006 11:45 AM - 2 messages
Dear All,     i have establish a connection to Oracle 10g using ODP.net , i could populate data in a listbox/combo box, but i need to display these data in one by one , i mean navigation using ...
Score Problem in creating sql database in visual web developer 2005 express
gudiya - 31 Mar 2006 10:04 AM - 3 messages
Hi, When I go to Add New item->Sql database-> click ADD i get the following error.I also get the same error when i open the security page on web site admininstration tool. "There is a problem with your selected data store. This can be caused ...
Score ObjectDataSource field binding to DataSet does not work
Jamie Oglethorpe - 31 Mar 2006 7:34 AM - 2 messages
I built a dataset with 11 tables and their relationships using the data set builder. I removed all the table adapters: the intention is to use the Enterprise Library to load the data, and to do the updates. That side of ...
Score How to synchronise, grid and dataset update ???
serge calderara - 31 Mar 2006 7:26 AM - 2 messages
Dear all, I have a strange behaviour when updating a grid. I will try to explain clearly: I have a CustDataSet object fill with customer information like Name, Firstname, Country, adress That Custdataset  contains all my customer information. Then I have a web ...
Score Illegal Immigration, the Non-Issue of the Week??????????????
Expert Humor - 31 Mar 2006 4:16 AM - 1 message
The way our politicians rushed to talk about illegal immigration this week, maybe they thought it came with a free lunch. They won't do anything about it, but it will get them some money. The Expert provides the details at: ...
Score can't connect to sql server using ip number
AC - 31 Mar 2006 2:06 AM - 5 messages
My code: Dim IP As String         IP = "192.168.0.169"                SqlConnection1.ConnectionString = "workstation id=xxxxx;integrated security=SSPI;Data Source=" & IP & ";persist security info=False;initial ...
Score changing key field in Data Form Wizard form
Marty - 31 Mar 2006 1:00 AM - 1 message
I created a form using the Data From Wizard.  It lets me change and update all the fields except the primary key.  When I modify the pk textbox, it throws this exception: "Failed to enable constraints. One or more rows contain values ...
Score IndexOutOfRangeException - Index was outside the bounds of the arr
Doug McCormick - 30 Mar 2006 11:43 PM - 1 message
We are encountering an extremely odd issue. We process incoming files for customers and output text files to produce printed material. Then an XML file containing the fields of the original file along with all fields necessary to produce the output text files are saved as an XML file. If an individual's ...
Score Concurrency violation trying to update a table in SQL Server
Boris Zakharin - 30 Mar 2006 10:22 PM - 6 messages
I have an intermittent error where I get the following exception: "Error: Concurrency violation: the UpdateCommand affected 0 records." Here are the steps I follow: Create SQLConnection Set connection string of the connection. Open connection Create SQL Data Adapter with the connection and a simple select statement ...
Score XML string to SqlDataReader for SQL Server 2005 CLR Stored Procedure
ehausig - 30 Mar 2006 9:33 PM - 1 message
I need some help getting an xml string into a SqlDataReader and I am stuck.  (I admit I'm no guru at this stuff.)  I can easily get it into a DataSet object, but the SqlContext.Pipe.Send() method needs a ...
Score How to loop through rows of strongly typed dataset table
moondaddy - 30 Mar 2006 9:32 PM - 2 messages
In vb.net 1.1 I could do this: Dim ds As dsEquip = GetDataset() Dim dr As dsEquip.tbEquipRow For Each dr In ds.tbEquip.Rows     'Do something Next now in c# 2.0 I'm trying to do the same thing like this: ...
Score How could you explain this?
s_alexander04 - 30 Mar 2006 7:03 PM - 2 messages
Hello I've experienced a very low speed filling DataSet in program running on PocketPC and connected to SQL Server via Wireles Lan. I used SqlDataAdapter. Table basically consists of text fields of type nvarchar and has about 6000 rows. It takes about 5 minutes to fill ...
Score Trouble entering empty date into Access table from ASP.NET app using ADO.NET
josh - 30 Mar 2006 6:12 PM - 2 messages
Hi, I have an ASP.NET app that uses ADO.NET for data access.  I have a form that allows a user to enter a date.  This date field is not required however.  If they don't enter it, I shove a variable declared of type ...
Score Why won't Dataset reflect changes?
Coty - 30 Mar 2006 6:00 PM - 1 message
I have a single page application that uses Web Service to fill a dataset decending.  When I add a new record to the database and re-fill dataset it won't reflect the first record added until after I've added a second one.  ...
Score Nesting ambient transactions.. doable?
eacsub - 30 Mar 2006 3:46 PM - 3 messages
im trying to put a transaction around my NUnit tests fixtures and a seperate transaction around each test and I'm trying to do that in my base class so that all my test can benefit from them. The problem is that I can't find a way to do both transactions. it's either ...
Score How can i write an object to db?
basulasz - 30 Mar 2006 2:25 PM - 8 messages
I get an e-mail in C# I want to store this e-mail item in SQL Server 2005. I don't have any hardcopy of this mail item. I only have a programmatic C# object, and i wish to insert it into a varbinary field. How can i convert ...
Score Join two Datatables
Sreppohcdoow - 30 Mar 2006 1:33 PM - 3 messages
I have two datatables in a dataset with a relation defined. How do I generate a JOINed view of this data? Thanks, MS ...
Score Empty Parameter
milan.letic - 30 Mar 2006 12:24 PM - 10 messages
Hello, I have sql command like: "Select... Where myColumn = @myParameter" Now, I can simply add parameter to the collection and filter data. What if I want to return not filtered data, I mean to skip, avoid executing this "myColumn = @myParameter"?! ...
Score Update Database records ??
serge calderara - 30 Mar 2006 11:26 AM - 2 messages
Dear all, I have a dataset object which as been filled from an SQL server table I have then a dataview from that dataset,which is bind to a datagrid object. My user can edit, update, delete entry directly from that datagrid through ...
Score Is there a way i can debug through the Sql script in my SqlDataSource ....
jens Jensen - 30 Mar 2006 7:47 AM - 3 messages
Hello, I'm very excited about the new SqlDataSource in asp.net 2.0. I have written a wuite long sql script on my SqlDatasource UpdateCommand. I want to see wheater it actually does what it was meant to do. ...
Score Connecting to SQL 2005 Express over a network share
Phil Williams - 30 Mar 2006 3:42 AM - 3 messages
Hello, To my amazement I cannot connect to a SQL 2005 Express over a network share. Now reading through the newsgroups I can understand why this can be a problem BUT... HOW does one go about having two PCs read/write data to a centralized SQL ...
Score Threads and Transaction Problems....
pjondevelopment - 29 Mar 2006 8:37 PM - 2 messages
After four long hours of googling on the subject and finding almost nothing, I'm forced to post this one. I'm doing a small project that reads several IIS and stores in a database the domains hosted there. This application runs quite fine. But I'd like to add some transaction ...
Score Create XLS file from Query? (VB, OLEDB, ADO.NET 2.0)
Confused Newbie - 29 Mar 2006 8:30 PM - 3 messages
I need to create new Excel 2003 XLS files containing a single worksheet that has the results of a database query (a combination of text, integer, and date columns).  Can someone please point me to an example of how to do this ...
Score Datarelation query
Adi Kulkarni - 29 Mar 2006 6:01 PM - 1 message
If i need to relate two tables using datarelation on a column "col1" out of which,table1 i want to make as parent table contains duplicate entries in "col1" and i want to retrieve all the rows present in table2 ...
Score How do i perform intersection in 2 datsets??
Adi Kulkarni - 29 Mar 2006 6:01 PM - 3 messages
How do i perform intersection in 2 datasets having a same col. *** Sent via Developersdex [link] *** ...
Score Re: DbProviderFactory, Oracle and a ref cursor
Paul Lockwood - 29 Mar 2006 5:07 PM - 1 message
Sujith, Thanks for trying to help, but I think OracleDbType.RefCursor is from the v1.1 of the ODP provider. We are trying to read an oracle sproc via the new Microsoft ADO.Net 2.0 generic provider interface. ...
Score Data Access Layer design question
Guy Noir - 29 Mar 2006 5:06 PM - 4 messages
Hi. I have a quick question. I am trying to create a quick data access layer for command CRUD tasks using stored procedures. My question is more of a design point of view. In each of my methods Create, Read, Update, and Delete, it seems I am ...
Score how to INSERT records to an OLEDB target ??
pamelafluente - 29 Mar 2006 4:58 PM - 1 message
Hi I have a datatable with several field and, particularly, a binary field (byte[])  (taken from some database) using the OleDB connection. Now I want to INSERT all the record of this table into a newly CREATEd table of another database (say mysql or access or sybase or whatever: ...
Score TableAdapter vs DataAdapter performance
JRD <> - 29 Mar 2006 2:57 PM - 4 messages
Hi, Thinking of the best way to develop a data acces layer for a new program I have been doing some performance test. My lab pilot is as follows: SqlServer 2000 + VS2005 TS in the same machine. Storage procedure returning 100.000 records from a table ...
Score Databinding Problem
Chris - 29 Mar 2006 1:51 PM - 1 message
Hi, I am working on a small windows app that pulls data from a SQL Server table and binds the data to the controls for the windows form.  One field in the SQL Server table has a data type of bit.  I do allow Nulls on the field.  ...
Score Q311522
olrt - 29 Mar 2006 1:46 PM - 1 message
Is this issue fixed in VS.NET 2005 release ?? I have VS.NET Beta2 and still have problems with Columns in DataSets (designed with the designer) containing expressions involving relations (child/parent). Indeed when I call ds.GetChanges() it launches an exception ...
Score Oracle Lob (blob) Read / Write woes
_BigDawg_ - 29 Mar 2006 1:13 PM - 4 messages
VS 2005, VB, .Net Frameword 2.0, Oracle 9i Database, System.Data.OracleClient I am trying to insert documents (word, pdf, images) into a BLOB data column in an Oracle 9i database using the System.Data.OracleClient. I have permissions on the database and the connection works to retrieve records. ...
Score Binding of textboxes to a empty table
nieurig - 29 Mar 2006 12:02 PM - 2 messages
Hi folks, I am looking for a solution of an "simple" problem, but I dont found it. I have a dataset with to tabels on it. On a Form i have a lot of TextBoxes to display the data from two database ...
Score Exception message using EnterpriseLibrary.Data
wapsiii - 29 Mar 2006 11:57 AM - 2 messages
I'm getting an exception message using EnterpriseLibrary.Data block. In the profiler I can see that the sql i fired in the sql database. Imports Microsoft.Practices.EnterpriseLibrary.Data Dim db As Database = DatabaseFactory.CreateDatabase Dim cmd As DBCommandWrapper = db.GetSqlStringCommandWrapper(sql) ...
Score DataReader
Zhou Peng - 29 Mar 2006 11:45 AM - 1 message
Can anybody tell me how SqlDataReader and OracleDataReader process the  encoding of contents from database when it's GetString(or  GetSqlString,GetOracleString) method is called? I have been annoyed on this issue for several days and searched many  ...
Score Encoding about GetString method of DataReader
Zhou Peng - 29 Mar 2006 11:15 AM - 2 messages
Can anybody tell me how SqlDataReader and OracleDataReader process the  encoding of contents from database when it's GetString(or  GetSqlString,GetOracleString) method is called? I have been annoyed on this issue for several days and searched many  ...
Score CONNECTING TO EXTERNAL DATABASE
Ángel Rubio - 29 Mar 2006 9:32 AM - 2 messages
Hi, I'm trying to make a new connection to a external database, it's not local, so what is the direction I must write to connect to it? It is the www... or I must write the IP of the server where it is stored? ...
Score Simple DataRelation question ???
serge calderara - 29 Mar 2006 9:26 AM - 2 messages
Dear all, Does the way of creating a datarelation between a parent and a child based on more that one column , is going to create a FK first ?? thnaks regards serge ...
Score Re: Using DateTime with SQL
Herby - 29 Mar 2006 8:47 AM - 3 messages
Help me ????? ...
Score Store procedure vs Direct statement ???
serge calderara - 29 Mar 2006 7:14 AM - 37 messages
Dear all, Is there any restriction or rules when you must you Store procedure call within application code compare to direct SQL statement. For sure the first reason is data security as all querry are executed on the server. But is there some cases where store procedure should be avoid ? ...
Score Re: Dataset changed but won't update.
Hendrik - 29 Mar 2006 6:15 AM - 1 message
try putting  ds.AcceptChanges()  after the update. ...
Score Columns from two tables in one datagridview row
Paul Craig - 29 Mar 2006 6:04 AM - 3 messages
Hi, Im using Visual Studio 2005 and playing around with all the new ADO .Net 2.0 features, I am hoping that what I am chasing is now available. I am wanting to display an updatable row (don't need insert or delete) which displays ...
Score UniqueIdentifier Sql Data and Parameters
den 2005 - 29 Mar 2006 1:52 AM - 8 messages
Hi everybody,   I have a column in one of tables in one of the sql server that has a data type of UniqueIdentifier. Now, I am supplying a value to used this column as filter to get specific record. ...
Score ExecuteNonQuery returning -1
Winista - 29 Mar 2006 1:03 AM - 2 messages
I have a stored procedure that adds a new record in the database and have another SP that updates a record. I used to call ExecuteNonQuery method on command object and it used to return 1 if method executed sucessfully. This ...
Score Storing wave files in database
nicolasr - 29 Mar 2006 12:16 AM - 6 messages
Hi, in my current project I need to record audio data analyse them and store everything in some sort of database. I have not much experience with databases except for some small tests with ADO and MS Access, MySql and Paradox. ...
Score Very Strange: field value is not updated if you try to set it to its default value
mszanto - 28 Mar 2006 11:33 PM - 2 messages
This is completely baffling me and I'm hoping someone can help me understand why this doesn't work. I'm updating existing rows in a MS SQL table by reading them into a datatable, modifying the values then updating the database using the ...
Score Error when trying to create new SQL Server login via ado.Net
holysmokes99 - 28 Mar 2006 11:26 PM - 4 messages
I get an error when I try to execute the following code using ADO.Net in VB.Net: conn.open sqlString="CREATE LOGIN test WITH PASSWORD = '1qaz2wsx'" command=new SqlCommand(sqlString) command.connection = conn command.ExecuteNonQuery() The error occurs when executing the ExecuteNonQuery line and is: ...
Score How next button in search works - Design problem
Arsalan Ahmad - 28 Mar 2006 10:36 PM - 4 messages
Hi, May be I am a newbie, or may be i dont have that much insight in following systems ..i.e. why i have some confusions as below: In many websites, when search is performed on some keywords (not only ...
Score Perform a LIKE filter on DataView Integer column?
Chris Botha - 28 Mar 2006 6:02 PM - 5 messages
Don't know if this can be done, but if I have a DataTable/DataView that has an integer column. Is there a way to do a "LIKE '123%'" kind of a filter on the column, which obviously works for text a text column. ...
Score Dataset, SqlDataAdapter, memory and you in .net 2
the_chad - 28 Mar 2006 5:41 PM - 29 messages
hey doods and doodettes. I am having severe memory issues when opening Datasets in .net 2.0.  A web-based app will cause the worker process to recycle on a heavy-duty server after just a few client connections, and a windows app will bring the machine ...
Score Optimistic Concurrency
Larry Charlton - 28 Mar 2006 5:28 PM - 3 messages
It could be me, but the check box for optimistic concurrency looks like it should be called pessimistic concurrency and seems completely broken.  To me optimistic concurrency say's I'm never going to have a concurrency problem, last save wins (which is the default).  When you check the box, it say's I'm ...
Score Saving Dataset- Order of operations
Vayse - 28 Mar 2006 4:12 PM - 6 messages
Hi If you save a Dataset, which order must you do the operations in? I think its 1) Update 2) Delete 3) Add Or does the order matter? Vayse ...
Score GetOpenConnection state exceptions
PIEBALD - 28 Mar 2006 3:38 PM - 1 message
Using Windows Server 2003, SQL Server 2005, and .net 2.0 (C#) I'm intermittently getting exceptions like the following: System.Data.SqlClient.SqlConnection(GetOpenConnection)ExecuteNonQuery requires an open and available Connection. The connection's current state is connecting. System.Data.SqlClient.SqlConnection(GetOpenConnection)ExecuteNonQuery ...
Score Trouble with DbConnection.GetSchema()
Sneil - 28 Mar 2006 3:11 PM - 1 message
Hello, I trying to get some schema info with help of string of code: _conn.GetSchema("Tables", sa) where _conn is type of DbConnection. So - sa must be string[] type. If I define sa like this:             string[] sa = new string[3]; ...
Score output param in SP, tableadapter
David R - 28 Mar 2006 3:09 PM - 1 message
I have a stored procedure with a number of input parameters, and one output parameter (integer type).  I call the stored procedure from a table adapter in a typed dataset.  The table adapter's method used (I'll call it ...
Score Inserting a record to access via asp.net
kalib - 28 Mar 2006 2:43 PM - 3 messages
I am trying to add a record in the access97  database to a table that is linked to another. Is there an example of such ? ...
Score hosted web server to access db servre on our network
steven scaife - 28 Mar 2006 11:28 AM - 1 message
We have a hosted server and i have developed an ASP.net applciation that uses this backend i have tested it and its ready for deployment on the hosted server.  However i cannot get it to see the server. ...
Score How to export DataTable or DataSet to Excel file?
ABC - 28 Mar 2006 10:28 AM - 5 messages
How to export DataTable or DataSet to Excel file? ...
Score Unexpected end-of-file (EOF) encountered in data file.
marcus.skillern - 28 Mar 2006 8:04 AM - 4 messages
I am letting the end-user select the file to be imported into the SQL via the intranet. I am getting this error displayed. Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]Bulk Insert: Unexpected ...
Score ADO.NET Excel Connections & DataType INT32
Phil Williams - 28 Mar 2006 6:12 AM - 3 messages
Hello, Can anybody tell me if it is possible to create a Table with an INT32 field with a ADO.NET Excel type connection? I have done this sucessfully with VARCHAR types but when I create an INT32 field and populate it it becomes a string value. ie In Excel it has looks ...
Score The Jet 4.0 Exchange/Outlook IISAM from ADO.NET
Boris Zakharin - 28 Mar 2006 2:19 AM - 1 message
I am experimenting with using Visual Studio 2005 and .NET 2.0  for the first time (though I have plenty of 1.1 experience and it's not that important in this case). I have written a VC++ Win32 API-only application that acts as an ...
Score how to insert a null value to sqlparameter
joe - 28 Mar 2006 1:45 AM - 3 messages
how to insert a null value to sqlparameter ...
Score Exception of type System.StackOverflowException was thrown.
Esref DURNA - 27 Mar 2006 11:19 PM - 2 messages
I Exception of type System.StackOverflowException was thrown. I m having this error sometimes and dont know why it comes. it happends only at one table its a biggest one which have 500 records but dot thinking that it was a big number for overflowing the stack. ...
Score Performance of OleDB Vs. ADO.NET
Arsalan Ahmad - 27 Mar 2006 6:55 PM - 3 messages
Hi, I am developing an ASP.NET website using MySQL as a backend database. Database access consists of simple update, select and insert queries however its likely that there will be a number of users simultaneously accessing the database. I can access database using either ADO.NET or using OleDB(OleDB ...
Score Oracle 10g access from 1.1
Dan Munk - 27 Mar 2006 6:00 PM - 2 messages
Hi, Is it possible to use the MS Oracle Client for connectivity to 10g from the 1.1 platform or must I use the ODP driver?  Is recommended? Thanks, Dan ...
Score Passing Parameter Collections
Vayse - 27 Mar 2006 5:05 PM - 7 messages
Two questions 1) Can a Parameter Collection be created without a Command? I've tried Dim paramsCustomer As OleDbParameterCollection paramsCustomer.Add(New OleDbParameter("CustomerBalance", OleDbType.Single, 8, "CustomerBalance")) paramsCustomer.Add(New OleDbParameter("CustomerId", OleDbType.SmallInt, 8, "CustomerId")) But it won't work. I get "Object reference not set to an instance of an ...
Score Paradox Database
SK - 27 Mar 2006 5:04 PM - 2 messages
Hello, I've a paradox database file named master.db. What is the best way to access this using asp.net (VB)? I want to put the data in a gridview. - Thanks ...
Score Connecting to FoxPro database via OleDB in Reporting Services
MikeD - 27 Mar 2006 3:49 PM - 3 messages
Hi, I'm accessing a FoxPro database via ole db and this works fine on my local report server. However, when I deploy the report to the live report server I'm getting the error 'Invalid path or file name' ...
Score Appropriate Query ?
glenn - 27 Mar 2006 12:34 PM - 3 messages
Hi folks, I have a SQL Select statement as follows SELECT ID FROM USERS WHERE NAME=? This was done because I have a dropdownlist control that is populated with names from the database which I need to get the repective id for each name ...
Score Real time system
George Varelas - 27 Mar 2006 9:45 AM - 2 messages
Hi, I have the following subject. I have a database (interbase) and I connect to it through odbc. I use Visual Stidio 2005 as development tool and C# as programming language. What I need is that: I have a table in the database. I want each time a record is created in that ...
Score Regarding reports
supriya - 27 Mar 2006 6:51 AM - 2 messages
i created one report in sql server 2005 . i want to use that report in visual studio 2005.how can access that report in visual studio2005. Please give some directions. thx. ...
Score Is this a bug?
Ant - 27 Mar 2006 6:16 AM - 1 message
Hi, I'm using VS2003 Sometimes when I try to use the DateSet.DataTableRow object to create a typed row, the intellisense doesn't bring it up. Is this a bug? You can manually type it in & it works ok but it's annoying as sometimes it ...
Score GridView w/ ObjectDataSource change null integer into zeros
Rachel - 27 Mar 2006 5:12 AM - 2 messages
Hi, I currently have a custom GridView control bound to a ObjectDataSource (business objects) When calling the "ObjectDataSourceView.insert(...)" and "ObjectDataSourceView.update(...)", EMPTY grid fields corresponding to INTEGERS are saved as 0 (ZERO) instead of nothing! for instance, I have a business object "StandardDetail" with a ...
Score Using Binding object on another form
Ant - 27 Mar 2006 3:16 AM - 2 messages
Hi, I need to use the find method of a Dataview from a form being used as a dialog box, to set the position of a Binding object on another form. I think this is a pretty standard thing. How do I reference the Binding Context object though as it is on another form? ...
Score SQL Syntax ?
glenn - 27 Mar 2006 2:11 AM - 7 messages
Hi folks, In a webform I have a dropdownlist control using ASP.NET.  I have bound data to the control and have populated it with names. SELECT * FROM USERS WHERE ID=? .... USERS is the table, ID is the primary key and NAME is a text string. ...
Score How to Insert records from dataset to another data connection
Phil Williams - 27 Mar 2006 12:20 AM - 5 messages
Hello, I have a SQL Express dataset with 1000 records and I want to export these to an Excel file. The way I thought to do this was to create a connection to the Excel file and then insert the records by executing a ExecuteNonQuery Command. ...
Score Bulk insert?
RichardH - 26 Mar 2006 10:53 PM - 3 messages
I've read that ado.net 2.0 have som build in feature to performe multiple inserts on a table? Does anyone know of a tutorial/example? Is it best practice to use? Thanks ...
Score optimization question
Howard - 26 Mar 2006 10:14 PM - 4 messages
I have a table with a large amount of rows > 100 000 with ID|NAME|HITScolumns ID is the primary key NAME is nvarchar HITS is int I run this query, it takes less than a second select top 40 * from table 1 order by id desc ...
Score Could we refer connection string from the other application.
ad - 26 Mar 2006 9:27 PM - 2 messages
I am desgining a class library, this class library is make of many TableAdapters. TableAdapter wizard usually store the connection string in ahe app.config of this class libaray. But my class library will be used by other web application, I want the ...
Score DataList FindControl
Joao Batista - 26 Mar 2006 9:24 PM - 1 message
Hi all, I have a datalist on my page and I an trying to access the Label (lbCodArt) in the ItemTemplate of the datalist on a button inside the datalist. Note: The ImageButton is not associated with any of the Datslist bound ...
Delete Rows in DataTable
How to use xxxDataSource control with customised select SQL
Bound Combobox Updating
Next »