I am trying to list the tables in a SQL Server database on an ASP.net page but can't seem to find out how to do it. The old ADOX did it for Access data bases and I presume SQL Server but this seems like taking a step backward. I am using VS.Net 2003. Any Help would be appreciated. Allison ...more >>

Can anyone provide suggestions/recommendations of using either the sqltransaction class for ado.net or a sql server stored procedure. we need to using begin and end transactions to update mulitple tables? asp.net app with sql server 2000 database...more >>

I have one SQL account that is used by 100 simultaneous users at my website. Let's say one user starts a long running query. I get another sql request before the first sql statement finishes. Does that mean I have to open or use another connection? Does this mean that the web server needs mult...more >>

Hi, i read in newsgroups and hints, that everthing wich has a dispose() method should be disposed. Is this true for tables and columns both have a dispose() method. Thanks for reply wansch...more >>

I think it is a very simple question, but i don't know the answer. I am developing a web site in C# and ASP.NET . If an entry like "Here is Sam's Pub" is entered into a Textbox exception occurs. Since " ' " character causes problem. Are there any escape character? Or how can i solve this probl...more >>

I am having difficulty getting an Update (MS Access) to work correctly using a OleDbDataAdapter, DataSet, and parameters. I add the parameters, and must have a default value for the values I want to SET in the update (I use the current time, so I can see any changes). I then attempt to cha...more >>

I am using sql server, Visual Studio .NET and C#. My application uses windows forms. The form that I am having a problem with has some text boxes and a data grid. There are two sql tables (i.e task and task-details) each table has the same primary key (service-order-number). The problem is I g...more >>

Hi, we have a client-server-application. On the client we add, delete things to/from a dataset then we save it via webservice; after that the dataset on the client must be updated. We do this with - DataSet.Merge (to get new Ids for example) - DataSet.AcceptChanges (to remove deleted rows...more >>

I have a situation where I need to join numerous tables in order to display data to the user. The user will be allowed to update the information. I am creating my data adapter and dataset in Visual Studio. However, Visual Studio will not create insert, update, or delete commands for this datase...more >>

Hello... Im cross posting this ...sorry but I'm stuck... Im trying to update a access table called xUpdate with another table called temp. Both table live in the same database. I want to update the field xUpdate.status with a field in temp called temp.newStatus. I thought the following woul...more >>

I have a MS Access table with the fields, ID, ATime, and ADate and I want to select records between a certain date and time. Will someone show me the proper syntax for the SQL statement. I need to construct the sql statement in VB.NET 2005. I can write one that pulls records between a set of da...more >>

Sql Server connection string, Persist Security Info = True\False Per the docs I find: "When set to false or no (strongly recommended), security-sensitive information, such as the password, is not returned as part of the connection if the connection is open or has ever been in an open state....more >>

We have a Winforms app running on XP against a local installation of MSDE. The machine is connected to a network. When we pull the network cable out we get General Network Error from SQL Server even though we are connected to the SQL Server on the local machine. We pull the network cable o...more >>

I have a typed dataset that is display in a form with parent data in text boxes and the child table in a componentone flexgrid. To add a row to the child table I open a form with text boxes and then return each piece of information to the main form. In the main for I create a new row in the ...more >>

What are the main differences between a dataTable and dataView? Does one perform better than the other?...more >>

Hello sirs! Suppose I have these objects (and their attributes): Car - string carName - Wheel aWheel Truck - string truckName - Wheel aWheel Wheel - string wheelColor - bool hasAHonk (as I lack imagination for a better example, let's assume that the car and the ...more >>

Hi guys, have a little weird scenario here. I have a windows Service that's serving requets using multiple threads created by the .Net threadpool. Within each thread they will create their own Connection object and go off and do their thing, an insert, a Select and the connection is closed....more >>

Hello, I can save my DataSet into Xml using ds.WriteXml(strXmlPath). Now I would like to filter it like I can do using DataView.RowFilter into another Xml file, but I don't know how to do it, because It always contains the original DataSet, not the filtered one, any solution ? Thanks. ---------...more >>

Platform: W2K IIS 5.0 ..NET 1.1 ADO.NET managed DB2 provider for iSeries I wrote a web service which allows me to post records to the as/400 Occasionally there seem to be errors such as "Communication Problem". I believe these are related to the connection pool. We reboot our as/...more >>

We are using a rowfilter on our dataview and are not getting the expected results. Our filter is as follows: "CLIENT_ID='T1000' AND NOT (RES_RATE=0 AND BP_SIT_SYS=0 AND BP_SIT_DIA=0 AND PULSE_API=0 AND TEMPERATUR=0 AND WEIGHT_NUT=0)" The results we expect are records that have a Clie...more >>

(Platform: 2003 or XP, IIS) From a Web Service, I have a sqlConnection with a correct (tested) connection string. When I try to myConn.Open(); it fails with NTAUTHORITY\NET SERVICE not authorized... meaning it seems to be looking for that in the SQL users list. However, I can't find s...more >>

can ADO.NET be used in classic ASP? that is to say: is it made available through COM Interop, or would i have to wrap ADO.NET objects in a COM Interop class library myself? if ADO.NET objects are available in COM already, what is the namespace used to instantiate them? thanks for any help, ...more >>

I'm trying to create a form to maintain 2 MS Access RELATED tables 'Parent' and 'Child'. I use 2 datagrids that are binded to 2 datatables. I've created 2 dataadapters and filled the datasets. I try to modify in the datagrid a NON key field of the 'Parent' tale and call the update method. An ...more >>

Hello folks, You should be here if you know something about typed DataSet or wants to know something about typed DataSet. If you know something about typed DataSet then please express your views. I have started this topic to discuss the use of typed dataset. I wish you express your view reg...more >>

Hi, I am upgrading a vb6 app to .net. My app works this way: on the form_load event I populate a dataset with all existing products (over 25,000) and their quantities on the database. Having in mind that many people (many computers) are placing orders at the same time, there is a great ...more >>

I have a parent with a DataSet and a child form that have few tables, after I change the data in the tables and then "Merge" the tables into the parent DataSet. I found that all values in the DataAdapter were null when update to sqlserver. But I found the parent dataset have values by using wr...more >>

Hi, I have the following code: using (SqlConnection connection = DBConnector.GetConnection()) { SqlCommand cm = new SqlCommand(); SqlDataReader dr = new SqlDataReader (cm.ExecuteReader()); while (dr.Read()) { ... } } Ther...more >>

For some reason, if I create a temporary table in a SqlCommand which has parameters, it doesn't get created properly, although no exception is thrown and ExecuteNonQuery returns the correct number of rows. So cmd.CommandText = "create table #temp (col int); insert into #temp values (1)"...more >>

I am using sql server, and in my database there two tables. One of the tables is the primary (tasks) and the other is secondary (Detail). The primary keys in both tables is "services-order-number". The 'Detail table' also has aother key "taskid". They look fine in the sql database, but when ...more >>

hey guys quick question. all of a sudden my intellisense feature in Visual Studio seemed to stop functioning. could there have possibly been something i inadvertantly Clicked to Stop this? i mean i can type Dim foo as st....................and usually the list comes up with the choices. but, n...more >>

I have wrote this code: ----------------------------------------------------------------------------- Dim cnsql As New SqlClient.SqlConnection cnsql.ConnectionString = "Data Source=ced2; User ID=sa; Password=;Initial Catalog=NGN;Persist Security Info=True;" Dim cmdsql1 As New SqlClient.SqlC...more >>

Aside from MS site, which is the best site for ADO on the web? Actually, which is considered th ebest (biggest) for dot net in general? ...more >>

Hello: This has been driving me nuts. Everything I do gives the same error. The bigger issue here is that it doesn't give me a clue where the error is rising. The debugger is blank. Thanks Bob ...more >>

I need to use OLEDB Provider to access Sybase. I am having problems with the ASE provider and prefer OLEDB. Question: What do I need to implement that? Any clients to install? A working example would be appreciated....more >>

We are writing an application for a specific culture(Arabic or Farsi). This application involves using DataAdapter, OLEDB Connection and the DataSet. We didn't use the .NET data binding, just field TextBoxes with the data retrieved from the DataSet but whole system seems to be unable to update t...more >>

I'm developing in vs 2005 beta2 now. I've been using a table adapter to populate comboboxes. That's fine, because these are mostly lookup tables with 10 to 30 rows. But then I came to Authors. I have hundreds of authors. I started a thread in the vs 2005 forums looking for a more economic...more >>

Hello from FRANCE I use VS 2005 beta 2 and Sql server 2005. How Can I retreive all the SQL server on my LAN ? Thanks Olivier ...more >>

I have a field of varchar(20), the content of it may be "Dog,Lion,Phoenix" When it the field display in a cell of DataGrid, it will display in a line, I want to break line at each comma, so I change the content of the filed to "Dog<br>Lion<br>,Phoenix" , But it still display in a line. How can...more >>

Ok, I'm very new to ADO.NET and databases in general. There are a couple of things I'm not clear on. First, I'm not sure exactly what an SQL Server is. By that I mean what's the difference between an SQL server and an Access database? Does the server only serve SQL to the Access datasource ...more >>

I have a program that loads a CSV file in UTF-8 in to an ADO recordset (if I open the CSV file in Notepad it shows that it's UTF-8 encoded). It works fine when the file contains Latin characters but works incorrectly when the CSV file contains Japanese characters. How can I get the Japanese ...more >>

I wanted to know the easy/right way to accomplish the task of creating a union of 2 datasets. I have 2 dataset of the same type and I want to merge them to create an union of both. I want to create a dataset that contains the union of both. I have tried searching for this but with no much suc...more >>

I know this issue has been beaten heavily here a few times, but i was looking for advice on a solution that i saw posted as it goes into some areas that i'm frankly not familliar with (yet), mostly the whole VFP COM components part. over on http://www.kamalpatel.net/Default.htm (where i go ...more >>

I'm experiencing an odd behavior in SQL Server 2000. I'm pretty sure this qualifies as a bug. I have a transactioon that contains several different record types, all of them using an identity element as their primary key. If there's a problem with a transaction, a rollback is issued to remove ...more >>

Hi, I'm writing in C# and using the OleDbConnection class to connect to a Microsoft Access database. The provider used in the connection string is "Provider=Microsoft.Jet.OLEDB.4.0". I have two objects (A and B). The first object (Object A) uses an OleDbConnection object to make a connect...more >>

Hi, I have a master proc that calls a different 'child' proc for a set of records. When a Raiserror occurs in the child proc, I 'handle' it in the master proc and update a status field in the record to 'Error' and set the returned error message. When all records have been processed, I ret...more >>

Hi All, i have an asp.net application which has got sql server 2000 behind the scenes. Very simple application, all it does is extract the data from the databse and display it in the grid. But randomly when i access my website in productin ,i get this error mentioned below but when it ...more >>

Has anyone run across the following exception and have any idea what the issue is? System.Data.OleDb.OleDbException: [NCR][Teradata RDBMS] A character string failed conversion to a numeric value. at System.Data.OleDb.OleDbCommand.ProcessResults(Int32 hr) at System.Data.OleDb.OleDbC...more >>

Hi, I'm currently creating an application with a lot of select statements in it. For security reasons I always use parameters. The problem with parameters is that when you want to review your select statement with selectCommand.CommandText, you see the name of the parameters in case of t...more >>

When trying to submit data to an Access database using ASP.NET I recieve the following error: [OleDbException (0x80040e14): Syntax error in INSERT INTO statement.] System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) +41 System.Data.OleDb.OleDbCommand.ExecuteComman...more >>

Hello: I'm working on an app that has many child tables. Like 26 child tables in a MS Access Database. I created the form, adapters, DS and relations in designer. I also added the parameters in designer to find records when a user types into a textbox. My problem is I can't figure ou...more >>

Hi can anyone help me?! :confused: I've got a web service that uses OleDb to connect to an Oracle 7 d running on AIX. All works well but after running for a while my AI server runs out of connections :( When I look there are LOADS o connections from the web server. I've checked the c...more >>