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?

 

[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

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

--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

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]
- (e-mail address removed)

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

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

--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

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.

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]
- (e-mail address removed)

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

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

--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

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