C# Developers' Journal (original) (raw)

2:27p

TableAdapters and mapping parameters Hello, guys. Experts-exchange couldn't help. Microsoft support couldn't help. Though, the problem seems easy to solve, just a technicality.

When you program for ASP.NET 2.0, you can use TableAdapters in Visual Studio 2005 to connect your program with the stored procedures on the SQL Server 2005. Like, you need a function for getting a client by his id. You go to DataSet designer, and add a new TableAdapter. You choose the pre-made stored procedure in the "SELECT" field, and everything is perfect. Here's the problem: when you try to create a TableAdapter for "INSERT" or "UPDATE", it asks you to map the parameters to columns in some datatable. But even if I add a new datatable to the DataSet designer, and create columns corresponding to parameters in my stored procedure, I still can't select them when wizard asks me to map them. These colums are simply not there. How can I map something in my program to those Stored Procedure parameters through TableAdapter? Please, help.

P.S. I realize this isn't an ASP or VS.NET community, but this subject is very popular within c# circles, so hope I'm not causing any inconvenience.

Current Mood: sleepy