Posts in microsoft.public.dotnet.framework.adonet

Array of db connections with string subscription  Replies (2) 8 January 2008
Hi Can I have an array of type OleDb.OleDbConnection that has strings as subscription values? The reason I need this is my app reads a configuration file with db names and their locations and i...

Sql string to gridview  Replies (1) 8 January 2008
Hi I have an sql string. What mechanism can I use to execute it and assign the result to a gridview? Thanks Regards...

Database connection issue using SQL schema user ac ...  Replies (1) 8 January 2008
I have an database connection issue that I cannot resolve. Here is the setup. I created a database in SQL 2005 Express. The database is owned by a dbo SQL user account, dboAdmin. I also create...

Help! Sudden Dot Net 2.0/FoxPro 6 project!  Replies (1) 8 January 2008
I've suddenly been requested to come up with a little ad-hoc VB.Net 2.0 project that is supposed to read and write to FoxPro 6 tables. As usual, I've never done anything like this. What would be...

A much more specific ASP.Net/FoxPro problem  Replies (1) 8 January 2008
I'm trying to set up an ASP.Net 2.0 web app that reads some FoxPro 6 tables that I've put in the APP_Data directory. I've put a gridview on the first page and bound it to a sqldatasource using ...

Index Questions  Replies (1) 8 January 2008
I have two tables with a one-to-many relationship to each other. In the table on the many side, I have a foreign key that contains the value of a primary key in the table on the one side. Ques...

Concurrency Question  Replies (1) 8 January 2008
I posted earlier about the best way to add to a field value, and preventing situations where the value could change between the time I read it and the time I write the modified value. Some suggest...

d  Replies (1) 7 January 2008
Try this site http://db2examples.googlepages.com...

Retrieve case sensitive tables  Replies (1) 7 January 2008
Hello, I'm trying to retrieve a list of tables from all_tables in a given Oracle db. I'm using System.Data.OracleClient and I always obtain the results in uppercase. The problem is that some tabl...

WriteXML => XDS  Replies (1) 7 January 2008
Hello, I want to bind a crystal report dynamically to a strong typed dataset. Therefore I have to define the dataset as xds in Visual Studio and then assign it as the reports dataconnection. So I c...

Deployment with database  Replies (1) 6 January 2008
All, What's the simplest way of a deployment of an application written in C# and using ADO.NET and MS SQL Server? I created a deployment project in the VS2005, aded it to the solution, configu...

Can't enter int value of 0?  Replies (2) 6 January 2008
Using Visual Studio Express 2008. I've built a program that uses an SQL/CE database (v.3.5), and constructed a strongly-typed dataset (.xsd) based on that database. One of the fields is an Int32 ...

\r\n problem  Replies (1) 6 January 2008
Hi there, I'm making a call to "DataSet.WriteXml(string fileName)" and the call is converting all occurrences of "\r\n" to "\n" in the resulting file (for string columns in each of my tables). ...

Design Question  Replies (3) 4 January 2008
Hi, Newbie to ADO.NET here. I have a VB.NET client program that will communicate with a SQL Server database. The database consists of one master (parent) table and 12 detail (chil...

Dataset to select/filter table rows  Replies (3) 4 January 2008
Hi, I have a dataset created from sql query. The sql query hsa sql function and join to another table. Now, I want to filter/select certain rows based on criteria and creating html string. When ...

Why doesn't ADO.Net reuse the connections in the c ...  Replies (1) 4 January 2008
I have an application that makes hundreds of database calls in the first few seconds it loads up. During this time, it opens 100+ connections. ALL of the connections use the exact same connectio...

avoiding data lockups  Replies (1) 4 January 2008
I wasn't sure which group was the correct one for this question. I am in the design phase of an application, and I'm not sure about a specific point about datasets and xml files. Is it true, t...

get MySQL database schema  Replies (1) 4 January 2008
I have create a connection via Visual Studio Server Explorer of a MySQL database. Now, I need to get an schema of that database (xsd file). I have added a new dataset typed file in my project but w...

mySqlBytes.buffer is getting converted to BigEndia ...  Replies (1) 4 January 2008
mySqlBytes.buffer is getting converted to BigEndian even though both SQL server 2005 and the CLR function are on the same machine which shows BitConverter.IsLittleEndian == true in tsql: select...

Security Questions  Replies (3) 4 January 2008
I have a couple of security questions. First, I just created the following stored procedure: ALTER PROCEDURE dbo.mc_Trainer_SetClientMessage @TrainerId uniqueidentifier, @Message text AS ...

Linq with INFORMATION_SCHEMA?  Replies (1) 3 January 2008
Does anyone have references for using linq with INFORMATION_SCHEMA? In other words, setting up a DataContext so that one can use linq to query against the INFORMATION_SCHEMA information? - Mark...

What is the Safest Way to Add to Field?  Replies (3) 3 January 2008
I have a numeric field. Users will modify it by adding a value to it. But I'm a little concerned about the unlikely event where two users are incrementing it at the same time. Unless there is som...

How to get database column alias from datatable  Replies (2) 3 January 2008
Does anyone know how I get can to the column alias in a datatable? here is an example of what I need to do. Query: select Column1 as [My Column 1], Column2 as [My Column 2] from dbo.tablename ...

M`I,5-Persecutio n . th eir method s an d tactic s  Replies (1) 2 January 2008
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -= MI5: methods and. tactics -= -=-=-=-=-=-=-=-=-=-=-=-=-=-=-= They deliberately set. out to harass in a way that would resemble the symptoms of schizophrenia, so....

M'I-5'P ersecution ' w hy th e sec urity services?  Replies (1) 2 January 2008
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -= why the security. services? -= -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= You may. ask, why do I think the "they" referred to are the security services? Is there. any e...

M-I,5-Pers ecution - ha rassment at w ork  Replies (1) 2 January 2008
-=-=-=-=-=-=-=-=-=-=-=-= -= harassment. at work -= -=-=-=-=-=-=-=-=-=-=-=-= Once I stopped. watching television and listening to the radio at the end of 1990, "they" had to find other ways of co...

SQL Update/Insert using SqlDataAdapter and Stored ...  Replies (1) 2 January 2008
I am having some problems updating and inserting some SQL tables using a SqlDataAdapter and Stored Procedure. The stored procedure works correctly (using Query Analyzer Debug), so it appears to be...

Databinding to DetailsView  Replies (2) 2 January 2008
Hi All, This is hopefully a stupid question. I have a page with a details view that is bound to an object datasource. The datasource pulls back a strong-typed datatable from my users database....

Filling a list box from a table  Replies (4) 31 December 2007
Hi VS2008. I have a table in an access database. How can I fill a list box with a column from the table? Thanks Regards...

M.I 5.Persecution . MI 5 a re Af raid to Admit T ...  Replies (1) 31 December 2007
MI5 are. Afraid to Admit They're Behind the Persecution MI5 have. issued a formal denial of any involvement in my life to the Security Service. Tribunal, as you might expect them to; but, more im...

M-I 5-Pers ecution . MI5 Insis t th at the se Fax ...  Replies (1) 31 December 2007
MI5. Persecution Update: Friday 31 March, 2000 22,544 Faxes Delivered in Three Years, and Still. No Breakthrough In the last three years I have. sent at least 22,544 faxes to recipients in the ...

Unhandled exception  Replies (2) 31 December 2007
When I run below sample code I get the error message "attempted to read write protected memory. This is often an indication that other memory is corrupt" if the records reteived from the DB exceed...

LIMIT in Queries  Replies (2) 31 December 2007
Does MS SQL support LIMIT? I'd like to implement paging at the query level. Examples of this in a book I have involve temporary tables and the like. Then I read something about LIMIT. Would ...

Questions About Relationships  Replies (2) 30 December 2007
I'm using the ASP.NET membership routines but had to create some of my own tables to store additional user information (profiles won't work for me). So far, so good. But it seems like I should re...

UDF in LINQ: "Stored Procedures cannot be used ins ...  Replies (4) 28 December 2007
Hi group, I've a question about calling stored procedures in LINQ queries. Here's my scenario: I have some CLR user-defined functions in a SQL Server 2005 database for custom string matching, e.g....

Best Practices for Data Access  Replies (6) 26 December 2007
Dear all, I need to design an smart client application that can run on mulitple and plugable backend like MS SQL, Oracle or MySQL. Also the smart client is accessing the database from the inte...

How to restrict any select to a subset?  Replies (8) 26 December 2007
Hi; We are designing a web application where multiple companies can use it. We want to give every company access to their data, and only their data. So if both Oracle and Microsoft are using th...

How to read XML in vb.net  Replies (2) 25 December 2007
Hi I have the below XML file. How can I read each tag and its attribute in vb.net? Many Thanks Regards ...

Events not firing in VS2008  Replies (1) 25 December 2007
I have used data binding in the past, but always with my own biz objects, not with a Data Adapter. I am now using the Microsoft SQL Embedded in this Mulch Order Entry program I am writing for my so...

How can I read the Binary data from DataBase  Replies (1) 24 December 2007
Hi EveryBody: I have probelm that I hung with for three weeks, My problem is I want to read Binary data from database. I will told you what I did : first I declear an array byte and I cast the...

Changing the Connection of a Query in a TypedDataS ...  Replies (1) 24 December 2007
I have a TypedDataSet. Within it there is a QueriesTableAdapter with a bunch of Queries(stored procedures that perform updates & deletes). I need to change the Connection of the Query at runtime. ...

Looking for Comments on Code  Replies (5) 23 December 2007
I would appreciate any comments on the following code--particularly criticism that is constructive. It is some of my first data-layer code. I felt these helper routines would be helpful in their ...

What DataColumn.DataType do each of the SQL types ...  Replies (2) 23 December 2007
When a DataTable is filled using something such as a DataAdapter, what values are assigned to each of the DataColumns' DataType property for the different SQL types? Thanks. -- Nathan Sokalski ...

DBF Import Crashes .NET APP and no error log whats ...  Replies (3) 22 December 2007
Hello, I have the following code to connect and query a dbf file. string cnn = @"Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=C:\DBF;exclusive=yes"; OdbcConnection odbcCnn = new Odb...

How to dynamically create DataRelations using GetS ...  Replies (1) 22 December 2007
I'm working on some code that is to generate a complete DataSet given a database connection (for now only Sql). I use GetSchema on the connection to retrieve table and column information. Now I'm lo...

A question on Objectdatasource???  Replies (1) 21 December 2007
Scenario : In a single webform, I have bill data(master data like billno,date,remarks.. ) and bill details(multiple entries in a grid like item details). While saving data to it should be stored ...

Dataset conversion 2.0 => 1.1  Replies (1) 20 December 2007
Hi, I have an server application written in .net 1.1 and I want to develop a client in .net 2.0, but when I am trying to pass a DataSet from the client to the server I get a deserialization excep...

Microsoft Access 2003 OleDb INSERT/UPDATE  Replies (1) 20 December 2007
I'm using OleDb to connect with an Access Database. I have anywhere from 10 to over 100 records that I need to either INSERT if the PK doesn't exist or UPDATE if the PK does exist, all in a single...

How to read MySQL data table from MS SQL?  Replies (1) 19 December 2007
How to read MySQL data table from MS SQL? http://www.alvas.net - Audio tools for C# and VB.Net developers + Christmas discount...

Implementing Dataphor Providers in Visual Studio - ...  Replies (5) 19 December 2007
At:- http://groups.google.co.uk/group/microsoft.public.sqlserver.programming/browse_thread/thread/296fcecdbdd5eabf/be1629eaa918d882?lnk=st&q=dataphor+ADO#be1629eaa918d882 Steve Dassin says:- ...