Hi everybody, I need your help. I am using Visual C++ .NET How can I make Console::ReadLine accepts int? In other words. I know I can do this: string* i = Console::ReadLine(); Can anybody tell me how can I do this: int i = Console::Readline(); ...more >>

Hi, This is version 2 of my story (in a previous post): the first time, the record is inserted into the table of excel, but then all following records are not inserted (and no error message ..) What could that mean? Where to look for? This is the first version of the previuos post: i...more >>

In my ASPNETDB.MDF database I have a custom table, with a field called "InsertionDate", which tells the user when the record was created. How do I auto-populate this field whenever a record is created? Is this field necessary for this type of info? Thanks ...more >>

Hello I am trying to connect to a liked table. When I run this query a window pops up that wants a User Name and Password: No User Name and Password is Required - If I click ok (without credentials) the query runs fine. The problem is that I am trying to send the credentials in my connecti...more >>

I am using ADO to access data on a Sybase server. Everything works fine until I quit my application where I try to close Ado connection and my application hangs. I found that Connection.Close() method does not returns. Any idea why? Is it a bug with Sybase Ole db provider? Thanks. ...more >>

I have Management studio 2005 express. I can't find how to convert access database to sql server 2005 express. Please help. ...more >>

I have an app that generates a lot of data for multiple tables (on one database). This seems perfect for the SqlBulkCopy object which, according to the docs, can be used to handle this case as long as the properties on the object are changed prior to each call to WriteToServer (DestinationTab...more >>

Hi Is there any way to refresh a DataSet after inserting few records in a table (containing foreignKey column) using adapters' InsertCommand and ExecuteNonQuery(). I tried adapter's Fill(dataSet) but it does not add the new records inserted to the dataset's table. I am doing something like:...more >>

hi, i'm using the .net OleDBprovider to read the data from excel file... but sometimes the data from the few of the cells of excel gets truncated... i'm not getting the whole data..if the data length is greater than 255 characters... how can i solve this problem? ...more >>

Form1 has controls that are bound to columns in a table. "New" button on Form1 opens up Form2, which queries user for new record. After Form2 closes, how do you refresh the data displayed in the controls of Form1 to reflect the additional record? Thanks, Marty ...more >>

Hi This code does not update the copyTbl rows. I.e. when the copyTbl object is merged into the dataset actions on the rows of this table are not reflected in the copyTbl. I want the copyTbl to reflect changes made to the ds.Tables["Sets"].Rows. private void PopulateCopyTableFro...more >>

I have a combo box in which I want to display the distinct values in a field in a table. Depending on the table name and the field name entered by the user, I build an sql statement _Sql = "Select distinct " + _fieldName + " from " + _tableName and fill a dataset with the results How d...more >>

I have a simple Windows form bound to one SQL Server table using the BindingSource control. I would like to use the BindingNavigator control to navigate through records. One text box holds a required field. When I click the AddNew button on the BindingNavigator, a new record is added to the Data...more >>

I have this stored procedure on a SQL 2005 database that when invoked from query analyzer or SQL Server Management studio runs in 2 seconds. However, the following code times out on the executeScalar call: DbCommand cmd = cnn.CreateCommand(); cmd.CommandText = "spc_search_item...more >>

I am very new to C# with little experience with stored procedures (former Coldfusion developer). My problem is that I have two csv files (output from SAP) that I need to import into two tables (after deleting current data) on a reoccuring basis (about every 30 minutes). I have already figure...more >>

I would like to make a subclass of System.Data.DataTable with this method pseudocode: " for each DataColumn, change the ColumnMapping to MappingType.Attribute " However, I am not sure where I should put this kind of logic so it is only executed once. The DataTable may be populated...more >>

In VS 2003, used to be able to drag a stored proc (that had multiple selects) onto the designer and it would create a datatable for each select. In VS 2005 it only creates a datatable for the first select. I sometimes do multiple selects to save round trips to the db. Also, after going th...more >>

Dear all, I have to perform a programatic reconciliation of two sets of data which are based on the same schema. I thought a brilliant way to do this would be to use the dataset.getchanges() method, and then write the changes out as a diffgram using the dataset.writexml() method. The way I ...more >>

..NET 2.0 I've heard rumors that .NET 2.0 contains a functionality which automatically can convert a database table into a .NET class. This functionality is being used as part of the Data Access Layer... Is this true? what is it's name? I think the name is something like DOL - Data Object L...more >>

..NET 2.0 I wonder how a Data Access Layer should be created using best practice! So if you have a link to an article about this subject then please post it here I've heard Microsoft has a special pattern for this, but I have forgotten it's name, I think the name is something like Data ...more >>

I am trying to understand datasets. It says its disconnected blah blah..... Can some one explain me what happens exactly when... Say I have asp.net page in which Page_load is opening a dataset. So for every request will a separate dataset be opened...say 100 users are requesting so will the...more >>

Hi, Enviornment : Visual Studio .NET 2005 and SQL Server /Access I've spent 2 days searching for an answer to this problem which I am convinced is simple - if you know how. I can't get VS to create the TableAdapter classes for me to use in my .NET application. I run the TableAdapter Con...more >>

I want to develop a non-ASP C# application. My program will include a TreeView control that the user can add and remove items from, and I'm considering the possibility of using ADO to store my tree data. Can anyone tell me if it makes sense to use data binding between ADO and a TreeView ...more >>

Hi all, Though this question is probably more focussed on SQL, I thought I would post it on this forum in case someone here can help me with an answer. I have a single SQL table that has many columns and rows. What I want to do is to take one column in a table, (one that contains short str...more >>

I've discovered something odd (it seems) with using Typed Datasets to bind to an Infragistics WebGrid I have on my ASP.NET (2.0) webform. Essentially, if I set up a Typed Dataset (using Stored Procedures for all data access, including select, update, insert, and delete), and then create t...more >>

Hello. I'm developing an application where suddenly I get this rather generic error, it is an ApplicationException with the message: "Error in the application". The problem is that it originates deep inside the .NET Framework. Here is (part of) the stack trace: System.ApplicationException:...more >>

Hi, I have a tableadapter which is used to access Oracle database using OLEDB for Oracle. I have a query on this adapter which consumes a procedure, this procedure has output parameter as Char(1) or Int. From my business layer, I call the adapter query by passing parameter of out string. It...more >>

hi all, I trying to connect remote sql server from my machine. but it giving me some errors Here are few errors listed, =EF=82=A7An error has occurred while establishing a connection to the serve= r=2E When connecting to SQL Server 2005, this failure may be caused by the fact that under the...more >>

I have Error:Could Not Install ISAM.When i use System DSN. my code is in app.config <add key="dsn1" value="Provider=Microsoft.Jet.OLEDB. 4.0;DSN=EduLiteDSN"/> and i create system DSN =EduLiteDSN and database is Ms-Access 2000 ...more >>

hi to all; i want to save a picture in column image in a database for example,in the table "users" i want to save the user image as when i want to select the user data from the database to show it in my site, the image selected from the table "users" thanks you ...more >>

hi to all; i want to save a picture in column image in a database for example,in the table "users" i want to save the user image as when i want to select the user data from the database to show it in my site, the image selected from the table "users" thanks you ...more >>

Does committing a transaction close it's underlying connection ? Or must you explicitly close the connection ? Also, is there any reason to dispose a connection ? My goal is to force the underlying connection to return to the connection pool. Thanks. ...more >>

Hi, I am trying to discover which SQLException.ErrorCode SqlConnection.Open() can throw. I have until now discovered these: // 53 : {"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under...more >>

Hi, Using ADO.NET Table adapter in C# , am updating a record using VS2005 generated update command by passing dataset and the assocaited table like; this.CustomerDataSet.CustomerTable. while updating am getting "Concurrency violation: the UpdateCommand affected 0 of the expected 1 records...more >>

I have an application that reads through a delimited file, breaks the values into an array and then checks to see if the record already exists in the database. If it does, the record is updated. If not, the record is added. Both of these actions are based on the values of the associated array ...more >>

I am trying to connect dot net report viewer control to an Oracle database. When I try to run it, I get the following error message: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. I have installed Oracle Client 9.2 on that server and have tried the fix a...more >>

Hi NG! I have recognized a strange behavior of the DataGrid control. If I'm editing the value of a cell in the DataGrid and press the close button (of the ControlBox of the application 'X') then the application closes but the DataGrid does not loose the Focus. I would like to save the changes d...more >>

Hi, Could someone please tell me what I would need to install if anything on a client machine to access an SQL Server 2005 database from a .Net component? Is it sufficient just to have the database files (.mdf and .ldf) and access them via ADO.NET? I only have a development machine and ...more >>

I'm a Vb.net 2005 newbie, but an Older VB6 programmer. With a ADO I work very comfortably (many years!), with ADO Is possible to work DIRECTLY with all the records in a Table WITHOUT the need to write ANY sql command. I try to make the same with ADO.NET (.Net 2.0) using sqlserver express, but ...more >>

i use visual studio 2003 amd c#.net to make my web application my site is about e-learning in my site i want to set some setting in "create new lesson page" such as name, description , startdate, end date,... i used textboxes,dropdownlist, radiobutton in the design of this page the probl...more >>

i all, I have a class with properties returning int, string, date... and generic Lists of other classes. private static string zipcode; private static string city; private static double? x; private static double? y; private static List<Proprio> pro...more >>

I have two sql server stored procedures that use transactions. Both stored procedures have there own begin transaction , commit and rollback. Currently I have C# .Net code that executes both of these stored procedures consecutively. Everything works fine unless the second stored procedure ...more >>

Hi guys, I’m getting a really weird problem when accessing a SQL Server 2005 database from .NET 2.0 code. I was wondering if anyone could make any suggestions as to what is going wrong?! Here is the problem (names and real world equivalents have been altered!): I have a database that ...more >>

I have a SQL Server database. I am using a OleDB Provider. I am getting the following error An unhandled exception of type 'System.InvalidOperationException' occurred in System.Data.dll Additional information: Command parameter[2] '' is invalid. Command parameter[3] '' is invalid. He...more >>

Hi EveryBody: I made project by using Asp.Net 2.0 and the code behind is written by vb.net I want to delete the old password from the database tabel and insert the new password insted ? My queruy for retriveing information from the data base is : Dim cmd As SqlCommand Dim ...more >>

Does any body have sample code to create a dbf from ado.net recordset in C# From http://www.developmentnow.com/g/7_2004_3_0_1_0/dotnet-framework-adonet.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com...more >>

I apologize for any inappropriate cross-posting, but wasn't sure where whether this is a Pervasive or ADO.NET issue. I'm trying to migrate data from a propietary system that's based on btrieve into Pervasive SQL 9.5 using a .NET application written in C#. The main problem is that the existing...more >>

Hi all, I am workibng on an application that will interact with an Oracle database and this is the first time I am doin sthg with oracle. From what I read in other posts, I will have to install the oracle Client before I can use any of the providers (MS or Oracle) to interact with the database....more >>

Currently, I'm investigating various architecture designs which involve maintaining a DataTable object within a background thread. I have various grids which will feed from that DataTable via DataView objects. Thus the layout is: DataTable object (worker thread) -> DataView object (main t...more >>

I have a class - I Dim a SQLconnection, then, in Sub New, I instantiate it, so that it's available to me whenever I reference the class (correct?): Conn = New SqlConnection(msConn) Then, in my Subs/Functions, this section (inherited from previous author): If Conn.State = ConnectionState.Close...more >>