Contents

Posts in microsoft.public.dotnet.datatools

 

dataGridView and return key  Replies (1) 5 January 2006
Hi, i use a datagridview control to display data from a DataTable object (VS2005 .NET 2.0). Data ediditing is not needed. If a row is selected and the user hits the return key, the next row in da...

 

Database project useful?  Replies (1) 5 January 2006
I'm experimenting with a Database Project in Visual Studio 2003. It looks like SQL Enterprise Manager, more or less. Does VS add anything that I can't do in Enterprise Manager (version control o...

 

Problem adding records with SQLDataadapter to SQL ...  Replies (1) 4 January 2006
Hi, I'm building an application, to edit data on a SQL Server database. Database has a table Jobs with primary key (JobID) with identity seed = 1 and identity increment = 1 I'm using SQLConne...

 

Writing to Access Database Problem  Replies (1) 3 January 2006
Hi, I am updating an Access Database (4.0 all service packs up to date) with a vb.net web application. The data adapter and update commands are all formed with the wizard. When I update a field...

 

DataGrid  Replies (1) 29 December 2005
Question: I am attempting to display database information in a datagrid control. When I use the datagrid control in the Windows Forms area, the "data source" and data member properties are not na...

 

Writing data back to a database  Replies (2) 24 December 2005
I have some data in a DataSet and want to write it back to the underlying SQL Server database. Is there any simple "one-liner" way to write a dataset back to its database or do I have to go throug...

 

Data Retrieval  Replies (1) 21 December 2005
I am creating a system, which will be central to our network administration. I have a table called persons, stored on a sql server. I am using the following select statement "SELECT * From Persons...

 

Bug? Setting failover partnet in VS2005  Replies (1) 20 December 2005
Hi I go into my Data Connection, then choose Modify Connection, Advanced. If I set a failover partner in here it hangs VS. I am not actually connecting to a SQL 2005 server or a real failover...

 

Reader alreay associated with command error  Replies (1) 19 December 2005
Hello, I've searched and seen this question posted many times, but all the answers are about the same and none work for me. I have 2 SQL commands, and 2 data readers. Here is the code block: ...

 

Is a dbtransaction "open"?  Replies (1) 17 December 2005
Is there a way to determine whether a transaction is still "open"; i.e., it hasn't yet been either committed or rolled back? I'm guessing that the transaction's connection object will be null if i...

 

pubs sample database  Replies (1) 16 December 2005
At the begining of a walkthrough it says I need to have access to a server for the pubs sample database. But searching through the documentation and the knowledge base here I can not tell if this...

 

Cannot create a stored procedure in VS.NET  Replies (1) 15 December 2005
I have just tried to create a stored procedure for my database but when I right clicked on the Stored Procedure node, I only got the options to Refresh or view the properties. There is no option ...

 

Changing a Datasource's ConnectionString in VS 200 ...  Replies (1) 14 December 2005
What's the easiest way of changing the connection string associated with a 'datasouce' in VS 2005? I would assume that I can delete the .xsd file and start over, but that certainly seems like a s...

 

Deployment project, diff betwn .msi and .exe  Replies (1) 8 December 2005
Hi, What is the difference between the .msi file and setup.exe file that is generated by a deployment project?. rgards Jesper...

 

Where is Query Designer?  Replies (1) 7 December 2005
I was at a demo where someone showed me the "Query and View Designer". I am back at the office, but can not find (searched help) how to start it up. I do not see the "Quey Designer" icons. I wou...

 

How to Read Hyphenated values from CSV File?  Replies (1) 7 December 2005
Hi, I'm using the OleDB namespace to open a CSV File. I can read the file sucessfully except for hyphenated values. My CSV File contains phone numbers and sometimes these come separated with hy...

 

How to Read Hyphenated values from CSV File?  Replies (1) 7 December 2005
Hi, I'm using the OleDB namespace to open a CSV File. I can read the file sucessfully except for hyphenated values. My CSV File contains phone numbers and sometimes these come separated with hy...