471,092 Members | 1,148 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,092 software developers and data experts.

Add/remove stored procedures in .NET project

Hi,

I'll need to replace an existing stored procedure (let's call it
old_SP), with a new one (let's call it new_SP) in a Visual Studio .NET
project.

Here's what I did:

1) Open "Dataset.xsd" to display the tables with their columns for the
stored procedures;

2) Manully add a new table for the new_SP with its columns;

3) Delete old_SP;

4) Save "Dataset.xsd";

5) Since "Dataset.Desginer.cs" is automatically generated from
"Dataset.xsd", so I emptied "Dataset.xsd" and hoped that it would be
correctly generated when I rebuilt the project.

However, when I select "Rebuild", I get all sorts of compiling errors
such as "type name 'blah-blah' does not exist in the type 'Dataset'".
So should I have kept some definitions of type names in
"Dataset.Designer.cs"? What are the correct steps for me to add/remove
stored procedures in a Visual Studio project without hassle?

Many thanks!

-Emily

Dec 19 '06 #1
2 1507
Hi,

I suspect that your code references a typed DataTable that no longer exists.
Either remove the references from your code or update them to point to a
different, existing DataTable.

--
Dave Sexton

"Fir5tSight" <fi********@yahoo.comwrote in message
news:11**********************@48g2000cwx.googlegro ups.com...
Hi,

I'll need to replace an existing stored procedure (let's call it
old_SP), with a new one (let's call it new_SP) in a Visual Studio .NET
project.

Here's what I did:

1) Open "Dataset.xsd" to display the tables with their columns for the
stored procedures;

2) Manully add a new table for the new_SP with its columns;

3) Delete old_SP;

4) Save "Dataset.xsd";

5) Since "Dataset.Desginer.cs" is automatically generated from
"Dataset.xsd", so I emptied "Dataset.xsd" and hoped that it would be
correctly generated when I rebuilt the project.

However, when I select "Rebuild", I get all sorts of compiling errors
such as "type name 'blah-blah' does not exist in the type 'Dataset'".
So should I have kept some definitions of type names in
"Dataset.Designer.cs"? What are the correct steps for me to add/remove
stored procedures in a Visual Studio project without hassle?

Many thanks!

-Emily

Dec 20 '06 #2
Hi Dave,

What you said makes a lot of sense to me. I'll work on cleaning the
code so that it doesn't reference any typed DataTable that don''t
exist.

Thanks!

-Emily

Dave Sexton wrote:
Hi,

I suspect that your code references a typed DataTable that no longer exists.
Either remove the references from your code or update them to point to a
different, existing DataTable.

--
Dave Sexton

"Fir5tSight" <fi********@yahoo.comwrote in message
news:11**********************@48g2000cwx.googlegro ups.com...
Hi,

I'll need to replace an existing stored procedure (let's call it
old_SP), with a new one (let's call it new_SP) in a Visual Studio .NET
project.

Here's what I did:

1) Open "Dataset.xsd" to display the tables with their columns for the
stored procedures;

2) Manully add a new table for the new_SP with its columns;

3) Delete old_SP;

4) Save "Dataset.xsd";

5) Since "Dataset.Desginer.cs" is automatically generated from
"Dataset.xsd", so I emptied "Dataset.xsd" and hoped that it would be
correctly generated when I rebuilt the project.

However, when I select "Rebuild", I get all sorts of compiling errors
such as "type name 'blah-blah' does not exist in the type 'Dataset'".
So should I have kept some definitions of type names in
"Dataset.Designer.cs"? What are the correct steps for me to add/remove
stored procedures in a Visual Studio project without hassle?

Many thanks!

-Emily
Dec 21 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Douglas Buchanan | last post: by
reply views Thread by Tim Bolla | last post: by
45 posts views Thread by John | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.