Hi, I'm have a dataset with only few tables. But each table is fairly big ( due to design constraints). Now I have a flag which needs to be set based on some of the cell values (the dependent cells are determined at runtime). The problem I'm facing is - To update the flag I need to depe...more >>

Hello, How can I update a datarow in a typed dataset? It seems i can't make it to write the changes into the database. What am i doing wrong? Thanks in advance. Here's my code: Private Sub save_changes(ByVal _infraction_id As System.Guid) Dim o_adapter As New roswellDataSetTableAd...more >>

I am executing a stored procedure and returning a resultset. The stored procedure takes approx 40 secs to execute. I have set the connection and command timeout to 10000, but I am still getting the error, "Timeout expired. The timeout period elapsed prior to completion of the operation or the...more >>

Take the following xml file (test.xml): <SourceData> <Transaction> <ID>11</ID> <Transaction>Insurance Loan Addon</Transaction> <TransactionAmount>31.21</TransactionAmount> </Transaction> </SourceData> ....and then run the following code in a console application: Module...more >>

Hi, I am using the following to update some rows in a dataset, I wonder why the data is no updated in the SQL table. Am I missing anything? Please advice, your help would be greatly appreciated. commandTimeoutPeriod = 120; typeCommand = CommandType.Text; command.CommandText = commandExecut...more >>

I have a form with master/child tables. I Deleted a row in the child table with datarow.Delete and tried to save the change to the database. Because I have a Foreign Key constraint between the tables I must make updates in a certain order 1. Child Deletes 2. Master Updates/Deletes/Inserts 3...more >>

Hi, I want to read the data\content of my .accdt and .accfl files using the oledb provider of .net 2.0 i've used the below connection string...but it's throwing a unrecognized database format error... "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Microsoft Office\Templates...more >>

Hello, I want to use C# to select a random number from MS Access database table. <SELECT TOP 1 userID FROM users ORDER BY NEWID()> seem to work only with SQL Server. ...more >>

Hi, I have to load xml data via http for some function calls. Using different providers, this data must be represented in objects of the same type for my client (web) application to be used. I am using VS 2005. I thought about using typed datasets as data objects, so I would generate xsds ...more >>

Our team provide different types of services such as: - proffessional cracking of any kind of software (CAD,CAM,CAE,EDA,GIS,PCB,FEA,FEM,CNC,CFD,PDS,3D,Optics etc.) designed for any kind of operating systems(Windows 95/98/ME/2000/XP, Linux, FreeBSD, OS/2, MAC OS etc.) - producing key...more >>

Hello, Thank you for your help. When I browse the internet, I only find examples on how to restore an entire database. What I try to achieve is to replace only one or several tables in the database by updated tables from another database. I added the reference to Microsoft.SqlServer.Sm...more >>

Why using an IIF in a DataTable.Select(IIF("column1=zz", "column2","column3")); is in invalid context ? What is the way for using an IIF in a Datatable.Select(...) ? Thanks for help. sam ...more >>

I use this for selecting rows that match a specific case: DataRow[] foundRows = dSet.Tables["MY_TABLE"].Select(IIF("column1="+DBNull.Value, "column2", "column3")); Compiling error, because IIF is not valid in this context ? What is the correct syntax for using IIF in a select ? Sam ...more >>

Hi EveryBody: Whey when I use the following code trying to inser my data to database it did not work: Dim mydatasource As New SqlDataSource mydatasource.ConnectionString = ConfigurationManager.ConnectionStrings("LocalSqlServer").ToString mydatasource.InsertCommandType = SqlDataSourceCo...more >>

hello, i have a big datable of a bunch of stuff. i am interested in getting row counts that match certain criteria. currently i do this by creating a new DataView for each criteria, and getting its .RowCount. like so: dv = New DataView(dt, "Type = 2", "Type", DataViewRowState.CurrentRow...more >>

Hi; This is using the Microsoft Oracle ADO.NET classes. Two questions on this. The first is - is there a way to call a stored procedure, including passing paramaters, where the entire request is in a single string? I ask because our app lets users enter any select and so if we have to br...more >>

Hi, In our ASP.NET application We use strongly typed datasets and TableAdapters. Is it a good idea to use a static TableAdpater to share the static instance among all sessions? My business logic components are like this: [DataObject] public static class AccountBLL { private static ...more >>

I have an application that saves a bunch of data in XML files that come from typed datasets. So, I have something like this: MyTypedDs myds; //.... When the user wants to save the data myds.WriteXML(thefilename,XMLWriteMode.WriteSchema); Later on, when he wants to open a saved file...more >>

Hi all, we need to be able to connect to an Excel in a remote server via ADO.NET. We have a component that makes queries to that excel a retrieves the data requested, but when we are trying to get the data from the remote excel we can=B4t connect because we have an URL and not a physical path....more >>

Hi all, I am having table containing 2 columns and 3 rows. Col1 contains interger valye. I have records with record1 having 2 in col1, record2 having 5 in col1 and record3 having again 2 in col1. I am trying to sort this datatable. So what i did is table.defaultview.sort = 'col1 as'. here...more >>

Hi, Using VS2005, SQL Server 2005. The SqlError.Class property always seems to be 0 when retrieving informational messages via the SqlConnection.InfoMessage event. Sample code to reproduce : == private void button1_Click(object sender, EventArgs e) { strin...more >>

HI, I am trying to reading a .csv file from a remote desktop. the connection string that i am using is as follows: strConn = "Provider=MS Remote;"+"Remote Server=//<ComputerName>/ <FolederName>;" + " Remote Provider=Microsoft.Jet.OLEDB.4.0;"+"Data Source="+@"d:/trial/try1.csv"+";"+"Extended...more >>

Hi, I am using vs .net 2005, .net frameworks v3.0, vc++ 2005, on vista I am trying to write a c++ app to call a sql stored procedure. the following code genrates an error trap and I don't know why: String ^myConnectionString = "Initial Catalog=ncxSQL;Data Source=ENVISION-MOD;Integrated Se...more >>

Hello, I have a program, running in several places, using SQLEXPRESS as database. The different places are stand-alone, and not connected to a network. Regulary, I have to apply changes on certain tables of the database. In a previous program, written in VB6 with an Access database, I used J...more >>

Hi - i'm using an OleDBDataReader to get results from a stored procedure and it is hanging on the Close() call on the Data Reader. When I do a Sql trace I see a SQL_NO_DATA_FOUND error but i'm not sure what it means or how to debug it. I am using ADO.NET 1.1, Sql Server 2000, and driver versi...more >>

In a new system based on .Net 2.0 I have some tech goal like database independence and the use of typed datasets. So I'm looking for some material on web but I did not found anything interesting. My scenario: I had work with some OR solutions for the .Net platform but I need to work with...more >>