index > .NET Framework Data Access and Storage > Problem using SqlDataAdapter/Query builder

Problem using SqlDataAdapter/Query builder

I'm having problems accessing my tables' columns using the "Data adapter configuration wizard" in Visual Studio 2003. It is connected to an MS SQL 2005 database. When I add the table I want to use, I get the option to select the '* (all columns)' only, not the individual columns that exist in the table.

http://bildr.no/view/9088
http://bildr.no/view/9089
http://bildr.no/view/9090
http://bildr.no/view/9091

As you can see from the last picture, I can access the table and see all the columns through Server Explorer but somehow it doesn't work using the configuration wizard.

Can anybody please assist with this?

Thanks!

csharp.net

I found a solution:

Tried using Visual Studio 2005 instead, and found that this could actually "see" all the columns in the table - so I used it to generate the sproc's and then opened Visual Studio 2003 again, and told the configuration wizard to "Use existing stored procedures" that VS2005 generated.

csharp.net

reply 2

You can use google to search for other answers

More Articles

• analysis services 2005 tutorial

• Same Problems

• SQLExpress - SQLDataAdapter Conflict

• Determination of Business Logic location

• Deny access to all my .mdb in a directory

• import / parse DIF files (Data Interchange Format)

• DataView RowFilter not filtering on percent sign

• Reference to a field after record search

• How do I grab the return value from my stored procedure in 2.0?

• Dataset.Tables[0]?????

Welcome to Bokebb New Update

New Articles

• Which Method is Better for Transferring
• Problem using SqlDataAdapter/Query builder
• Can not detach database right after back
• How to get headers only from column name
• Imports cell from DataTable
• GridView in Web Application Not Deleting
• bool true, false values with SqlData
• How can i use SqlTransaction with TableA
• faster way of accessing CSV files
• Too many connections to database
• delete and update code at the same butto
• Update SQL database...Please help
• Get SAP data
• How to avoid re-occurring Err "ORA-
• How To Easily Change Connection To Acces

Hot Articles

• Repeating name in namespace + classname,
• database search engine class library
• Can a DataSet tell if tables in the SQL
• access sql server database with vb
• When to use ExecuteScalar???
• Populate DataSet from CSV
• Seek suggestion on .NET support options
• ConfigurationManager.AppSettings not rea
• Problem Importing Data From Excel
• OleDbCommand.Update method bug - paramet
• insert, delete, update in a datagrid and
• Err: Format of the initialization string
• c#.net: Unable to update records with sq
• Connection Pooling randomly throwing COM
• How to handle a "stored function&qu

Recommend Articles

• Insert fails due to nulls
• XML Schema Help with FIX 4.4
• ASP.NET/SQL Server/IIS - Not preserving
• Problem with Transactions C# and Sql Exp
• Help trying to Insert to Access DB with
• Adding a Primary Key column to a disconn
• Interesting behavior causing: "Ther
• Version problem
• Transactionscope
• Parameter within WITH-Clause in MDX
• When to use ExecuteScalar???
• DataGridView Detail Row Saving
• Excel Query: Can You Query Which Columns
• DataGridViewCellStyle Editor
• Application Blocks