table column change

[gs]

How do I quickly make a c# windows project adapt to sql table columns change
such as length quickly?

I am using datagridview and detailview. I am not dealing with asp.net

I have to manually clean the solution, edit the corresponding .xsd
maxlength, two times per columns, rebuild.that gets a bit tedious

[Nicholas Paldino [.NET/C# MVP]]

Well, can't you delete the data table and then re-add it from the data
explorer?

--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"gs" <[e-mail] in message
news:Oc**************@TK2MSFTNGP05.phx.gbl...

How do I quickly make a c# windows project adapt to sql table columns
change such as length quickly?

I am using datagridview and detailview. I am not dealing with asp.net

I have to manually clean the solution, edit the corresponding .xsd
maxlength, two times per columns, rebuild.that gets a bit tedious

[gs]

thank you for quick response.

if I do that, will it cause any loss of the customization in the controls in
the associated with the table?

If not, surely I will try that next time around
also what do you mean delete the table? do you mean that I go to
datasourcees while I have the project open, select the table and delete the
table?

I also just notice the right click menu for table has a choice of refresh.
I think I give that a try next time before taking the delete action

"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.comwrote in
message news:%2****************@TK2MSFTNGP02.phx.gbl...

Well, can't you delete the data table and then re-add it from the data
explorer?

--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"gs" <[e-mail] in message
news:Oc**************@TK2MSFTNGP05.phx.gbl...

>How do I quickly make a c# windows project adapt to sql table columns
change such as length quickly?

I am using datagridview and detailview. I am not dealing with asp.net

I have to manually clean the solution, edit the corresponding .xsd
maxlength, two times per columns, rebuild.that gets a bit tedious

[Nicholas Paldino [.NET/C# MVP]]

Well, if you customize controls that are bound to the table, deleting
the table from the data set designer shouldn't affect those controls.
Unless you customized the designer code, then you shouldn't have an issue.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"gs" <[e-mail] in message
news:%2****************@TK2MSFTNGP05.phx.gbl...

thank you for quick response.

if I do that, will it cause any loss of the customization in the controls
in the associated with the table?

If not, surely I will try that next time around
also what do you mean delete the table? do you mean that I go to
datasourcees while I have the project open, select the table and delete
the table?

I also just notice the right click menu for table has a choice of refresh.
I think I give that a try next time before taking the delete action

"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.comwrote
in message news:%2****************@TK2MSFTNGP02.phx.gbl...

> Well, can't you delete the data table and then re-add it from the data
explorer?

--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"gs" <[e-mail] in message
news:Oc**************@TK2MSFTNGP05.phx.gbl...

>>How do I quickly make a c# windows project adapt to sql table columns
change such as length quickly?

I am using datagridview and detailview. I am not dealing with asp.net

I have to manually clean the solution, edit the corresponding .xsd
maxlength, two times per columns, rebuild.that gets a bit tedious

[GS]

thank you very much.

"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.comwrote in
message news:eu**************@TK2MSFTNGP03.phx.gbl...

Well, if you customize controls that are bound to the table, deleting
the table from the data set designer shouldn't affect those controls.
Unless you customized the designer code, then you shouldn't have an issue.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"gs" <[e-mail] in message
news:%2****************@TK2MSFTNGP05.phx.gbl...

thank you for quick response.

if I do that, will it cause any loss of the customization in the

controls

in the associated with the table?

If not, surely I will try that next time around
also what do you mean delete the table? do you mean that I go to
datasourcees while I have the project open, select the table and delete
the table?

I also just notice the right click menu for table has a choice of

refresh.

I think I give that a try next time before taking the delete action

"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.comwrote
in message news:%2****************@TK2MSFTNGP02.phx.gbl...

Well, can't you delete the data table and then re-add it from the

data

explorer?

--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"gs" <[e-mail] in message
news:Oc**************@TK2MSFTNGP05.phx.gbl...
How do I quickly make a c# windows project adapt to sql table columns
change such as length quickly?

I am using datagridview and detailview. I am not dealing with

asp.net

>>
I have to manually clean the solution, edit the corresponding .xsd
maxlength, two times per columns, rebuild.that gets a bit tedious