Add/remove stored procedures in .NET project

[Fir5tSight]

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

[Dave Sexton]

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

[Fir5tSight]

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