Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Connection String Machine Independent.
Manny - 4 Dec 2004 11:08 PM - 2 messages
Hi there, I've been researching on the diferent newsgroups to find out how to do this, but no luck so far. I'm developing a client/server windows application with VB.NET, MSDE is my backend database. This is sample connection string to connect to my server: ...
Score ADO .NET and Excel ...
fahad - 4 Dec 2004 9:31 PM - 8 messages
Hi Frankly speaking, what ever one says, Microsoft technologies will always remain problem-matic.. specially with versions... they don have seamless integration. Deployment is always always an issue. But I still love .NET!! Anyway folks, my problem goes like this... ...
Score Getting SQL Error - "General network error"
Gary F - 4 Dec 2004 9:19 PM - 2 messages
I'm getting the following message trying to update a SQL Server table: "General network error.  Check your network documentation." I'm using stored procedures via a SQL data connection from within a .Net windows application. The application producing the error, reads a table from ...
Score create table based on existing tables in a dataset, how ?
jeff - 4 Dec 2004 5:17 PM - 2 messages
hi all i create a dataset with table a, b and c in it. Is it possible for me to generate extra table (e.g. d) into this dataset based on table a and table b (which already exist in this dataset) ? ...
Score Cannot open OracleConnection with Oracle 9.2 in ASP.NET
Dhananjay - 4 Dec 2004 5:17 PM - 4 messages
Hi I'm using System.Data.OracleClient with VisualStudio.NET 2003 and trying to connect to Oracle 9.2 database. Oracle client software for 9.2 has been installed and I can perfectly make a connection in a Windows Forms ...
Score ado.net exception from raiserror
John - 4 Dec 2004 8:35 AM - 2 messages
In a couple of stored procedures (SQL Server 2000) im doing: raiserror('aaa',16,1) return 1 My understanding was that this should throw an exception in my C# code. But sometimes it doesn't (I have to manually check the return value parameter). ...
Score Better way to build results? (Relative newbie)
Terp - 4 Dec 2004 7:07 AM - 4 messages
Hello, Undoubtedly this answer is in front of my nose, but I can't figure it out or find it anywhere. Using VB.NET, Access database. I have successfully built a series of nested queries that return results from three interrelated tables, reading the results into datareaders. I can ...
Score Error: ArgumentOutOfRangeException on stringbuilder
JenHu - 4 Dec 2004 5:55 AM - 2 messages
Hi experts,    I wrote a function to use stringbuilder for a fix length text delimited file for banking stuff. I received an error on strResult.Insert(141, "".PadLeft(21, " ")) Error: System.ArgumentOutOfRangeException        Message: "Index was out of range.  Must be non-negative and ...
Score Adding columns to SQL Server tables dynamically
Mark Rae - 4 Dec 2004 1:09 AM - 10 messages
Hi, I'm writing a routine which queries a table in a mySQL database and then adds records from it into a SQL Server 2000 database - pretty easy stuff. Problem is, that the mySQL table may have additional columns every time I ...
Score Dataset Error:IndexOutofRangeException
JenHu - 3 Dec 2004 10:56 PM - 2 messages
Hi experts, I have a dataadapter and datasets. I debugged it and gave me an error on LName = DS.Tables("AcctInfoTble").Rows(1)("LASTNAME") error: There is no row at position 1. WHAT DID I DO WRONG at the following code? ...
Score Incorrect in passing parameters
JenHu - 3 Dec 2004 8:56 PM - 2 messages
Hi all, I received an error: System.NullReferenceException: Object reference not set to an instance of an object at GenerateA(String& strEmpID, String& strClientAcct, String& strAcctStatus). When I run the debug, and in the command line I entered ?strEmpID, and ...
Score DataSet, Relation, IsNested and WebService
Corno - 3 Dec 2004 3:35 PM - 2 messages
Hi all, If I want to provide a typed dataset from a webservice and if that dataset has relations that are nested (isNested=True), then the relations(keyrefs) are not available in the XSD that is offered. If I set IsNested to false or ...
Score Can you package a oledb data provider?
Brian - 3 Dec 2004 3:15 PM - 2 messages
Hello,      Is it possible to package a oledb data provider?  I need to be able to access an iSeries machine, but the server that the program is being installed on does not have the ibmda400 provider.  The easy way would be to install ...
Score Value in output parameter not accessable
Alan Lambert - 3 Dec 2004 10:01 AM - 3 messages
I am using the Microsoft Data Application Block to access a database and am trying to execute the following stored procedure: CREATE PROCEDURE WhiteboardPostItem @Id int OUTPUT, @Subject varchar(255), @Message varchar(2000), @PostedBy varchar(100) AS INSERT INTO Whiteboard(Subject, Message, PostedBy, DatePosted) ...
Score Viewing large amounts of data
Thomas Due - 3 Dec 2004 9:24 AM - 11 messages
We have a data management application writen in Delphi. This app shows all tables in the database, and display all data in a given table in a datagrid. We are using an ODBC connection for this. This functionality is not unlike what is seen in e.g. Enterprise manager. ...
Score include rowstate in dataset.getxml
mak - 3 Dec 2004 6:03 AM - 3 messages
Hi Gurus, how can i include rowstate value in dataset.getxml string <datatable> <row1 state="Added"> <col1>v1</col1> </row1> <row2 state="Modified"> <col1>v2</col1> ...
Score deleting rows in one-to-many relationship
Patrick - 3 Dec 2004 3:33 AM - 4 messages
Dear Ng, I have a 1(master table) : n(first child table) : m(second child table) relationship in my sql server and strongly typed dataset. Now I locate the corresponding row in the master table. DataAccessControl.DocumentTemplateRow rowTemplate = tblTemplate.FindBydocumentTemplateId(templateId); ...
Score Create Stored procedure
Peter - 3 Dec 2004 1:48 AM - 7 messages
Hi, there I want to create a Stored procedure for my Access database using the code below.        ' Conn is an opened connection to my Access database         Dim cmd As OleDbCommand ...
Score DataSet and Stringbuilder?
JenHu - 3 Dec 2004 12:02 AM - 2 messages
Hi expert, I received a sample from bank for the header record in the output file (attached at the bottom). I want to use same method to have a stringbuilder to arrange the fix length positions, and the fields will be retrieved from database and ...
Score Moving solution to another machine, SQL Failure
Michael Jackson - 2 Dec 2004 10:49 PM - 3 messages
Hi all, I've developed a .NET 2003/SQL Server 2000 application. When the app fires up, it loads combo boxes (Using SQLDMO) with available servers, databases and tables. It works great. However, when I move the solution to another PC ...
Score GetChanges false positives, How to avoid?
entdevguy - 2 Dec 2004 10:19 PM - 2 messages
I was curious if anybody know of a way to avoid false positives while using the GetChanges method.  In most of my updateable aspx pages I have text/ddl/checkboxes that are populated from the existing data that the user can change, then hit the save/update button.  When the ...
Score SchemaTable
Tom - 2 Dec 2004 9:39 PM - 4 messages
I'm using the following code to obtain information about any table in a database. Now _schemaTable contains the info about the table and one of its fields is "IsKey" which as far as I know should identify the columns that are ...
Score Row-wise vs columnwise
John Dann - 2 Dec 2004 9:21 PM - 3 messages
If I need to iterate through all the field values in a dataset, is there any preference for organising the outer iterations by row or by column . ie should I do (in VB.Net): For i as integer = 1 to table(0).columns.count ...
Score How to effiently load many, many SQL records
William Patterson - 2 Dec 2004 8:30 PM - 3 messages
I have a need to effiently load millions of fairly small records into SQL Sever 2000.  I have some financial data with many, many observations (one set has 37 million records) and I need to get it into a  SQL server. ...
Score Connection Pool
ap - 2 Dec 2004 7:13 PM - 4 messages
Hello, Is it ado provider by default do the connection pooling? or it is depending on the database.  I know sqlclient provider does the connection pooling but can I use connection pooling with MYSQL? thanks ap ...
Score All data is text in ADO Update to Excel...
Vagabond Software - 2 Dec 2004 4:29 PM - 2 messages
I am updating several excel worksheets using ADO.NET (OLEDB objects).  Everything is working fine except all the data is inserted as text despite being typed in the DataTable object and when the Excel worksheet was actually created. If the user-specified Excel Workbook does not exist, one is created and worksheets are added using "CREATE TABLE" statements with type-specific data columns.  The data type for each column is specified in the DataTable object as well as the actual "CREATE TABLE" SQL statement. ...
Score Cascade without relation
Wei Wang - 2 Dec 2004 3:43 PM - 3 messages
I have two datatables,  dtTable1 has an INDENTITY column, dtTable2 has a integer column to have the value of table1 indentity column but it can be null. so I can't create the relation between tables (unless there is some ...
Score ADO.NET text driver not importing data as text
Buddy Ackerman - 2 Dec 2004 3:31 PM - 2 messages
I have the following comma delimited file to read:     Date,campaign code,count     12/1/2004,DM31,10     12/1/2004,DM32,15     12/1/2004,DM33,20 ...
Score DateTimePicker problem with .AddNew
Mika M - 2 Dec 2004 2:18 PM - 2 messages
Hi! My Windows Form contains DateTimePicker to show date-type data from DataTable. Because application need to be able to save "no date" ie. NULL into database table, I solved it like way... ("dtpRepaired" is DateTimePicker-control) dtpRepaired.Checked = Not IsDBNull(dt.Rows(cm.Position)("Repaired")) ...
Score Problem catching exception from a procedure
Ekempd - 2 Dec 2004 1:39 PM - 3 messages
Hi! I wrote a procedure in my sybase database this procedure is one line only, and attemp to insert a record in a table generating a constraint violation of a primary key and an exception. I do this only for test... ...
Score SqlDataAdapter aand transaction
Sharon_a - 2 Dec 2004 1:29 PM - 5 messages
Hello, I'm using SqlDataAdapter to insert data from one table into another with SqlCommand after I start a transaction. If I have convertion error for the insertion of the data, The transaction is no longer valid, I'ts rolled back. ...
Score DataSet, new row and default values ?
PL - 2 Dec 2004 1:25 PM - 8 messages
When I add a new row to a DataSet that was filled with info from a database the new row does not get the default values defined in SQL Server, how do I accomplish this seemingly simple task ? I don't want to have to fill in the default values in the row first, ...
Score Best aproach to update DataAdapters with XML-Data
Adrian - 2 Dec 2004 1:16 PM - 2 messages
Hi all What's the best aproach to import xml-based data into an oracle 9i database with ado.net DataAdapters, when the data is in an xml-file? The operations should insert new rows and update changed rows. Does ado.net provide some automatisms for this or do i have to do this ...
Score Updating table at a different database
Sharon_a - 2 Dec 2004 8:39 AM - 2 messages
Hello, I'm using SqlDataAdapter to get records from table at database different from my connection using the databasename at the select statment "Select * from otherdb..myTable" After updating the data I want to update the table, I'm using ...
Score Re: Help! Bug in SqlDataAdapter.Update()?
kpang8 - 2 Dec 2004 8:04 AM - 2 messages
Hi Darwin and gurus, I'm new to the forum. I've got the exactly same problem as Darwin's. I searched online for solutions and found this tread and a couple of others, but I still don't really get a clear answer. ...
Score Printing excel files
Darklight - 2 Dec 2004 6:22 AM - 3 messages
Hi. Can anybody help me on how to print excel files that has been read via ADO.NET. Or anyway, what I want to avoid is automation (instantiating an excel application object). Hopefully, there is way aroudn this.. Thanks in advance. ...
Score higher reads when using ADO.NET thatn when using Query Analyzer
Buddy Ackerman - 2 Dec 2004 3:23 AM - 3 messages
I was doing some testing and noticed that when I execute a stored procedure from my ADO.NET (using the Command class of the System.Data.SQLClient namespace) the number of reads on a relatively simple query were significantly higher.  As a ...
Score OleDbConnection problem with more than 1 connection
Sylvain Bissonnette - 2 Dec 2004 2:45 AM - 3 messages
Hi,     I had wrote 2 app in c#.net one Windows Form base and one Web Base and those 2 connect to a access database and some time I got this error in my web base application and I can't figure out what's wrong,  I just hit reload and ...
Score Command Builder in tables without primary key
Wichury - 2 Dec 2004 12:29 AM - 4 messages
Hi every one, i'm trying to use a sqlcommandbuilder in an application using a table without a primary key, when i call the DataAdapter.Update Method there comes an Error saying that "the selectcommand does not return information about the primary key" or some thing like that... ...
Score SqlHelper.UpdateDataSet with transaction
gwenda - 1 Dec 2004 11:03 PM - 4 messages
Hi, I'm trying to use the SqlHelper.UpdateDataSet method with transactions. The DAAB 2.0  documentaion only say: "SqlHelper.UpdateDataset does not include transaction support. If you need this, you can implement it yourself by a preceding call to the helper method SqlHelper.ExecuteScalar("begin ...
Score encapsulating SQL queries into OO framework
Zeno Lee - 1 Dec 2004 10:52 PM - 4 messages
Right now I'm putting my query strings into static functions in a DbQuery class that returns Datatables. Eg. public class DbQuery {      public static Datatable GetMyData()         {             Dataset ds; ...
Score How to update one table based on a match found in another
Martouff - 1 Dec 2004 8:49 PM - 2 messages
Hi I'm trying to figure out the best way to perform a simple but repetitive task in vb.net. Access DB with 2 tables: first table - a list of phone numbers not to call and a table holding contact information. ...
Score MSDN Webcast: Introducing ADO.NET 2.0 for SQL Server 2005
Pablo Castro [MS] - 1 Dec 2004 7:59 PM - 3 messages
We'll host a webcast on ADO.NET 2.0 & SQL Server 2005 next week. I thought you guys might be interested. For more information you can check out: [link] ...
Score DataObjects.NET OR mapping, any opinions ?
Gawel - 1 Dec 2004 7:15 PM - 2 messages
Hajo, I consider to use DataObjects.NET ([link]) and I need any opinions about this solution. 1. Is is mature enaugh to use it in commercial project? 2. Can it work seamlessly with Oracle data base? ...
Score Storing missing values
John Dann - 1 Dec 2004 6:35 PM - 7 messages
For a column in (eg an Access) database that's used to store numeric data, is there a specific way to designate a missing value for a given row (ie the value was simply never measured or assigned). Or must I ...
Score System.Data.OracleClient Version
sra1001 - 1 Dec 2004 6:19 PM - 4 messages
Recently I started a project  attempting to connect to an Oracle 9i database using the System.Data.OracleClient namespace with .Net 1.1.  The database's service name is longer than 16 characters & I have since found that their is ...
Score Passwords with Special Characters
Joel Maslak - 1 Dec 2004 5:05 PM - 3 messages
I'm trying to figure out a general algorithm to allow any valid MS SQL 2000 username/password combination to log into a Winform application.  I'm having trouble with special characters. I'm created a user named test ...
Score Stored procedure not returning a value in @RETURN_VALUE
Adam Ainger - 1 Dec 2004 4:35 PM - 4 messages
Hi everyon, I am experiencing a problem with a stored procedure not returning a value in the parameter @RETURN_VALUE when debugging in C#. The stored procedure looks something like this:     CREATE PROCEDURE dbo.ListSomething         @myParam int ...
Score Datagrid SortCommand does not work ???
Stuart - 1 Dec 2004 2:21 PM - 2 messages
Hi There I have a datagrid with a Select(LinkButton) Column followed by several Bound Columns. I have enabled the columns to sort and created the correct event handler (I think) - however the crux of my problem is that when I click on one of the ...
Score Error Message: Timeout expired.
Victor - 1 Dec 2004 11:54 AM - 3 messages
Hello there, I have about 50 users who use an asp.net application i made. For a while there were no problems but now i see a lot of timeout expired messages i diiferent forms of my application. See the stack trace ...
Score concurrency violation with bound control
Darklight - 1 Dec 2004 10:07 AM - 5 messages
Hi. I'm sorry if this is a repost. Please reply with existing links, if any. I have a list box with a datatable as data source. I edit an item from the list box (by changing the item in the datatable) and call the update method() of ...
Score DataTable.LoadDataRow - can you improve on this?
Jim Lawton - 1 Dec 2004 9:41 AM - 5 messages
DataTable is dt, filled already and with keys defined, uid, seq etc, suitable variables ...         object[] newRow = new object[5];         newRow[0] = uid;         newRow[1] = seq; ...
Score ado vs oledb
Maileen - 1 Dec 2004 7:31 AM - 9 messages
Hi, I use to program using VB + ADO with MS Access. however, i've read that oledb is faster and better then ADO to access to DB. could you tell me in which wqy is it faster ? what i've seen till now, it's that i need 3  times more code lines to do the ...
Score Using DSN in connection string with SqlConnection Object
Nirmalkumar - 1 Dec 2004 7:31 AM - 2 messages
I want to use DSN in Connection string. But for opening connection i am using 'SqlConnection' object. i.e using System.Data.SqlClient; So is it possible to use DSN in connection string with 'SqlConnection' object. OR i should go only for 'OdbcConnection'. ...
Score best way to retrieve thousands of records.
jaYPee - 1 Dec 2004 6:33 AM - 13 messages
I have currently using a dataset to access my data from sql server 2000. The dataset contains 3 tables that is related to each other. parent/child/grandchild relationship. My problem is it's very slow to retrieve records from sql server. ...
Score Is there any way to know if a connection is in a transaction?
loquak - 1 Dec 2004 4:03 AM - 5 messages
Greets. A very simple question in the topic, probably takes about 10 seconds for an expert to answer =) Thanks .. ...
Score RowState Question
mabster - 1 Dec 2004 12:22 AM - 3 messages
Hi folks, I'm reading through David Sceppa's excellent ADO.NET book, trying to teach myself ADO.NET, and have a question about the RowState property. If I add a new row to a DataTable, it has a RowState of 'Added'. ...
Score RE: Very simple whidbey VS2005 question
David Sceppa - 30 Nov 2004 10:22 PM - 3 messages
Sahil,      Your best bet would be to ask this question in one of the newsgroups dedicated to the C# or VB development environment, depending on the language you're using. Try: microsoft.public.dotnet.csharp.general ...
Score RowState Undelete?
localhost - 30 Nov 2004 9:43 PM - 4 messages
A row was deleted in a DataTable, and now I want to bring it back so I can remove it (so my dataadapter will not touch it later). How can I do that? Thanks. replaceExisting ...
Score OracleDataReader returning no rows or data even though data exists
MS - 30 Nov 2004 9:25 PM - 3 messages
Hi All, I am trying to get result from Oracle Function that returns a number. When I rum from SQL Plus I could see the result. When I call from my C# application I get no data. I am using System.data.OracleClient to access oracle function ...
Score How can I format date in databound combobox in windows app?
George P. - 30 Nov 2004 8:22 PM - 5 messages
Hi, I have a combobox bound to a smalldatetime column in a table. The ComboBox displays all available dates. However it displays them in long format and I want to display them in short format. Is this possible? ...
Score Displaying dates in dd/mm/yy format
Anonymouse - 30 Nov 2004 7:55 PM - 3 messages
I have two Date/Time fields in my Access 2003 database. The VB.NET app I'm developing (and making some real progress with) uses TextBoxes to input these as part of a record in a DataSet. Problem: Access always stores years as 4 ...
Score Very simple INSERT INTO with a DateTime parameter -> "Syntax Error in INSERT INTO statement"
loquak - 30 Nov 2004 7:20 PM - 4 messages
Hello. The following very simple code does not seem to accept the DateTime variable as a parameter - why? The table (MS Access db) here contains only a primary key and a column Date of type date/time. connection.Open(); transaction = connection.BeginTransaction(); ...
Score Read-only transaction in Oracle
Maxim Maslov - 30 Nov 2004 6:52 PM - 5 messages
Hello All; Does anybody know any way to start read-only Oracle transaction in .NET application? This mode can be set in PL/SQL by SET TRANSACTION READ ONLY statement, but Oracle provider for .NET does not support such isolation level. ...
Score Add Raw DataRow Collection?
localhost - 30 Nov 2004 4:52 PM - 2 messages
I have a remote DataTable and I want to add 5 DataRows to it.  My current code does a "remoteTable.Rows.Add( new object[] { .... } );". That results in 5 remote calls, which is bad. I already know the schema of the remote DataTable.  Is it possible to ...
Score mapping 2 datatable columns to one datagrid column
forceDev - 30 Nov 2004 4:43 PM - 3 messages
Is this possible?  I want to concatenate two columns in my table and display them in one datagrid column.  I have a TableStyle where I create DataGridColumnStyle's. I'd like to set the MappingName to two columns but I ...
Score Use of undocumented sp_MSforeachtable and MStablespace
Hans-Peter - 30 Nov 2004 4:07 PM - 3 messages
What is wrong with the following code? What I want to do is to store the results of MStablespace for every table in a DataTable. The result contains the number of rows and the data space and the index space. ...
Score question for the minds
ae - 30 Nov 2004 3:51 PM - 3 messages
This is what should be an easy question, but I can't get it through my head.  Can someone help me undestand the following? The way I see it, .DataSource is whatever you decide to refer back to thel ...
Score [BUG?] (2) Update database using stored procedure and OleDbDataAdapter.Update
joun - 30 Nov 2004 3:23 PM - 6 messages
As suggested by Cor Ligthert, i've created a simpler sample, with the same problem; this is the full source code, so everyone can try itself: Access database "dati.mdb": Tables: "myTable" Fields:   fNumber Numeric   fString VarChar(50) ...
Score newbie question.
Jensen Bredal - 30 Nov 2004 3:07 PM - 3 messages
Hello, I have  backed up a table from a database in an DataTable (dt ) object. The table has been wiped up (in sql server) after the backup  but i still have the copy in memory (in my DataTable object ). ...
Score XML Dataset
Séan Connolly - 30 Nov 2004 2:53 PM - 6 messages
I have a dataset that is based on an xml file, which contains the same structure as a sql server table and is exported from a dataset. When I do: sqlDataAdapter.Update(dataset, strTableName) I get the error: "Missing the DataColumn 'InspectionDate' in the DataTable ...
Score Annoying Bug with parent-child-grandchild relationships.
George P. - 30 Nov 2004 2:11 PM - 3 messages
Tables: Parent, Child, Toys Relationships: ParentToChildRel, ChildToToysRel. dataGridParent.Datamember="Parent"; dataGridChild.Datamember="Parent.ParentToChildRel"; dataGridToys.Datamember="Parent.ParentToChild.ChildToToysRel"; all grids pointing to same datasource. the flaw is that when a move to a parent, whose child has no toys but the ...
Score how to move record forward or backward
hui - 30 Nov 2004 1:19 PM - 5 messages
hi all I have got a datareader by sqlcommand, now I wanna move forward or backward, but I don't find first,last,prior and next methods. How can I do it? thanks for your suggestion. hui ...
Score ExecuteScalar intermittently returns "0"
Martin Schaech - 30 Nov 2004 12:47 PM - 2 messages
Hello all I have an interesting problem which is causing me to lose sleep.  I have a vb.net app in use by approximately 100 people on a daily basis.  This app is mission critical for the business.  I'm ...
Score Aborting a thread corrupts my SqlConnection (?)
Uri Dor - 30 Nov 2004 12:33 PM - 5 messages
Hi, I'm running a long query in a separate thread. If I abort that thread and then I try to use the same connection string again, I get an unexpected result. Details: the aborted thread runs a query that returns a resultset, using a ...
Score how to move
hui - 30 Nov 2004 12:23 PM - 2 messages
hi guys I have got a datareader, now I wanna get last record or locate any record by some integer step. How can I do it? thanks hui ...
Score alter table structure using FillSchema
Daniel - 30 Nov 2004 12:16 PM - 3 messages
Hi All, using FillSchema() method of an dataadapter can I alter a table on sql server? instead of using "alter table alter column..." strings I'll use getSchemaTable modify columns I need and then use FillSchema to submit changes to the server... ...
Score data adapter update using datatable that has MANY changes
Darklight - 30 Nov 2004 10:39 AM - 4 messages
Hi. I magine that I have a listbox that is bound to a data table. This means that there is the possiblity that the data table will have new rows, edited rows, and/or deleted rows. After everything is done, I would like, at the push of a button, to ...
Score Removing rows from a DataTable is VERY slow
Markus Hjärne - 30 Nov 2004 8:27 AM - 32 messages
I'm using a DataTable to hold a selection of rows (100,000+) from a large database table (1,000,000+ rows). At times I want to remove rows that aren't used anymore from the DataTable to save memory. But my tests shows that it ...
Score How to refresh Currencymanager that is pointing to deleted rows.
Debi - 30 Nov 2004 8:09 AM - 3 messages
Hi,    I get a RowNotInTableException while accesing a row that has been deleted and refetched from the database. How can I refresh the currencymanager to point to the correct row. Thanks, Debi. ...
Score SQLDataReader
Michael Jackson - 30 Nov 2004 5:29 AM - 9 messages
My application is using the SQLDataReader to retreive and itereate thru rows of data from SQL Server, then for each row of that SQLDataReader, selects related rows from another table via yet another SQLDataReader. When I finish with a row, I do a SQLDataReader.Close and set it to nothing, but my .NET ...
Score Specifying format of DateTime columns read from CSV files
Joel Gordon - 30 Nov 2004 3:54 AM - 7 messages
Hi,     I am reading a CSV file into a DataTable with the following code :    internal static DataTable ReadFromCSVFile( string csvFileName ) {       if ( !File.Exists( csvFileName ) ) {          throw new ApplicationException( " Cannot find CSV file : \"" + ...
Score DataSet Memory Usage
howard39@nospam.nospam - 30 Nov 2004 2:47 AM - 8 messages
I'm working with a large ADO.Net DataSet and my application uses quite a bit of memory. According to the memory profiler I am using, there are about 120,000 DataRows, and they take up about 5 Megabytes. These DataRows are contained in ...
Score date cell in Excel is null
Darklight - 30 Nov 2004 2:33 AM - 3 messages
Hi. I hope somebody can help me. I am trying to read an excel file via ADO.NET. I have tried using a datareader and filled datatable (by oledbadapter). My problem is that some cells with date format are being returned as null. ...
Score I can't fill a required field in a record Add (before EndEdit)
Larry Woods - 30 Nov 2004 12:33 AM - 3 messages
I have a required field in my db table.  I am filling a table with a NEW row via a form with bound textboxes.  I get a particular required field ( a foreign key) from another source.  When I get ready to update my table I do ...
Score Evaluating Reporting Tools for .NET
Mohammad S Khan - 29 Nov 2004 11:55 PM - 4 messages
I am currently doing some research on reporting features provided / compatible with dotnet features. Our current application has excel reprots that are emailed both with an without scheduling through a web front end that uses coldfusion as well as asp. There are custom vb ...
Score How to write a custom data adapter
Vinay - 29 Nov 2004 10:11 PM - 3 messages
Hi, How to write a custom data adapter to retrieve value from legacy database(image database on HP Mainframe). Any help on this will be appriciated.. Thank you Vinay ...
Score Problem copying datatable-long post
james - 29 Nov 2004 9:36 PM - 2 messages
Sorry for posting a long post, (the code) but, I am having a problem copying one data table to another new table in another Access database that has the same table schema.  You will notice that I do not list exact column names etc. because this routine ...
Score Storing passwords in database
VB Programmer - 29 Nov 2004 7:27 PM - 5 messages
I am using SQL Server as the database for my ASP.NET app. I have a users table with a password field.  What is the best way to encrypt it before it goes into the table, then decrypt it to read the value?  Any ...
Score Encrypting/Decrypting Connection String
VB Programmer - 29 Nov 2004 7:23 PM - 4 messages
I have my SQL Server connectionstring in my web.config file.  I'm scared that someone will open the file and get my username/password.  How do I encrypt, then decrypt the connection string in the web.config file? ...
Score populating dataset from excel range, error where no data.
Winshent - 29 Nov 2004 3:41 PM - 3 messages
My web app allows users to upload an excel file and then ado.net loads the data (if there is any) into sql server. I have a problem when if there is no data in the excel spread (completed on a weekly basis), then the code fails when i try to fill ...
Score Slow OleDbParameter
Tomislav Stilinoviæ - 29 Nov 2004 1:01 PM - 2 messages
Hi all, I have a question about performance of  OleDbCommand with command parameters. I try to get records from table with 1500000 records in two ways, with command parameters (a) and without them (b). Field type is char and it ...
Score Can't import .OCX assembly into Web Matrix Project.
Steve Gordon - 29 Nov 2004 10:28 AM - 4 messages
Hi, I am using Web Matrix Project as .NET programming environment. Can you show me detailed steps how to import the .ocx  library into the Web Matrix Project. I can't seem to be able to import other assembly than .dll, .exe or ...
Score Page Time out for huge database
Esref DURNA - 29 Nov 2004 9:59 AM - 4 messages
We have a huge database which can only turn the result in minimum 2 minutes. At out ASP.net Application we modify the ado object timeout secound but now we get the page time out from the System.Exeption what we should modify more? ...
Score create stored procedure dynamically
Hazira B - 29 Nov 2004 9:05 AM - 6 messages
Haiii!!!! Is it possible to create stored procedure dynamically in C#.NET. Because some of my requirements needs such a situation. ...
Score DataUpdate passing wrong values to SqlServer?!?
Jens Weiermann - 29 Nov 2004 9:03 AM - 2 messages
Hi! I have a rather simple DataSet with two tables in it (parent / child). I've set the UpdateRule property of the relation to "Cascade", because this value is changed when the parent row is written to the sql server (an ...
Score Migrate SQL Server 7 to 2000
Sangeetha Nagaraj - 29 Nov 2004 8:57 AM - 2 messages
Hi All, I have a database in SQL Server 7.0. I want to migrate my database to SQL Server 2000. How to go about it. It is a heavy weight database. Can anyone give me few suggestions ...
Score .NET/Oracle8i - Inserting Null.
RajSB - 29 Nov 2004 6:01 AM - 4 messages
I have a numeric column in Oracle which is populated using a .NET Datagrid. The problem is whenever i try to fill it with empty value when the user clears the value that is filled already, I get an error.  Iam pasting chunks ...
Score Repopulating a DataGrid with a different Dataset
wenz - 29 Nov 2004 1:00 AM - 5 messages
Hi, I have a small application that reads data from a text, access or excel file and displays it in a DataGrid. I have a problem when a second request to display a file is made in that the columns in the datagrid display both the column headings from the original ...
Score OleDB and Excel...
fahad - 28 Nov 2004 9:03 PM - 2 messages
Hi... I am trying to save data into an excel sheet. The application is working fine here on my local machine (FAT 32). But when I try to run the same application on server (I think NTFS), following error is generated. ...
Load table
(.NET 2.0) Adding your own DataProvider to the DbProviderFactory model.
SQLDBType.Char for OUTPUT parameters
must set .Size property for output SQLParameter
Next » 2 3 4 5 6 7 8 9