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 same thing. thanks a lot, PM...more >>

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'....more >>

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? ...more >>

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. Thank you, Maxim ...more >>

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(); commandString = "INSER...more >>

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 ...more >>

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 ...more >>

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...more >>

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 m...more >>

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 ). now i need to restore the table from memory. Is there a quick way of doing this apa...more >>

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) No primary keys defined. Stored Procedures: "q...more >>

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 'tblEquipmentInspections'...more >>

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 DataAdapter. the query run afterwards is: INSERT INTO ...more >>

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... Thanks, Daniel ...more >>

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 on Database 8.1.7. I am using Oracle 9i client fr...more >>

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 digits, and it automatically tags a time onto the field, so when t...more >>

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 create a DataRow collection, populate al...more >>

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 takes very long time to remove the rows. Running the code below on a Pe...more >>

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 dont see how this can be done. Thanks....more >>

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. This seems to be okay, because dataTable has three columns after executing the code. The...more >>

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 the Datalist in my case it is an array: System.Collections.ArrayList al = new ArrayList(); ...more >>

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 using windows server 2003 for the web front end, SQL server 2k for the backend, and a mixture ...more >>

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 update the database with the change(s) made...more >>

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....more >>

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 ...more >>

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 : \"" + ...more >>

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 a total of about 70 tables. However in addition there ar...more >>

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. Can anybody offer some explanation and solution? I am t...more >>

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 an "EndEdit" and it detects that I have not yet filled the required fie...more >>

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 ...more >>

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 compnents that generate...more >>

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 needs to be generic so I can use it to copy d...more >>

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 sample code or links would be helpful. Thanks! ...more >>

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? ...more >>

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 also has index. Option (a) gives me result in 30 seconds and opt...more >>

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 file and the new file. I h...more >>

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 identity column); so after I call the Update method of the DataAdapter fo...more >>

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 the data adapter with the dataset. should th...more >>

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 ..mcl . I am pretty new to the .NET programming environment, and ma...more >>

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? machine.config? web.config? ISS? Thanks ...more >>

Haiii!!!! Is it possible to create stored procedure dynamically in C#.NET. Because some of my requirements needs such a situation. -- Yours, Hazira B...more >>

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 -- Rgds, Sang...more >>

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 of code : Private Sub DataGrid1_UpdateCommand(ByVal source As Obj...more >>

GET YOUR TRIP TRIPS TO DESNEY TRIPS TO HAWAII http://travelexpert2004.us http://travelexpert2004.biz http://gotraveling85.us ...more >>

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. What you say? Permission problem or Rights issue? Please help !!.. .I...more >>

I'm sorry for my incessant questions but I am architecting a Sql Server 2005/ADO.NET 2.0 project, and I just wanna be double sure of any architecture decisions I make. I found the following very interesting code in DbProviderFactories.Initialize() -- DbProviderFactories._configTable = ...more >>

Hi, I should be able to use the following code to load data from a datatable via ado.net into sql server. I want to keep the code generic so I can run it against any table. The error I get relates to primary key not being set. But I know it is because when the row is first inserted I get error ms...more >>

is there some problem with using SQLDBType.Char for SQLParameter.Direction = ParameterDirection.Output parameters ? ...more >>

for ADO.NET SQLParameters with SQLParmaeter.Direction = ParmeterDirection.Output .... apparently , contrary to the documentation , you DO have to set the SQLParameter.Size property ... or you get errors like this : Message "Parameter 1: '@EntityTypeName' of type: String, the property Siz...more >>

Hi there, My asp.net application uses methods in classes to do database updates. So for example on any given page when a user clicks the submit button, my click event might call three different methods each of which opens a database connection, updates a table, and closes the connection. ...more >>