Thanks friends. It works when deselecting and selecting the column again, but unfourtonately the row is added at very end of the table in the Dataset. I think there is no way around it, to go to the Dataset designer and search for specific code to change the coloumn order.
Thats strange. I have literally tried everything over the years, when working with DataSet and Tableadapters but i can´t find a proper way to update the tables on my Dataset designer, to fit the sql tables. Only by removing the table from the DataSource and running the Update wizzard it works...
Yes i am doing the update in the Date Source window but nothing happens. I have to delete the table and run the update again then everything is updated. It seems like Microsoft does not care much about the Dataset designer, nothing changed for a few years now.
Yeah that is what i was using earlier. The coloumn type was datetime2 and all worked good. I have changed it back to datetime2 from nvarchar. Thanks to everyone
One more question dear friends. When updating my table in the sql, how can i update it in the dataset designer without having to delete the table and add it again, because all my queries get removed too and i have to recreate them all again. It is a lot of work when i have bigger tables with...
"You should NEVER store data that is not text in a text column. ALWAYS use a data type appropriate to the data. "
I ment the sql coloumn sir, not the bindingsource or somethign else. Is is better to make my sql coloumn of tiype datetime2 or nvarcvhar. Also how would i make the bindingsource...
myBindingSource.Filter = $" StartTime not like 'now' AND (OrderTime >= #{DateTime.Now:MM/dd/yyyy}# AND OrderTime < #{DateTime.Now.AddDays(1):MM/dd/yyyy}#)";
I had this code and it worked good but then i decided to change OrderTime coloumn type in sql to nvarchar , it used to be datetime2...
Should i just use another method and download the file and then read the file? Because actually it works very good. This is what i got:
using (WebClient webcl = new WebClient())
{
webcl.DownloadFileAsync(new Uri("http://file.txt/"), datei)...
Dear friends,
i have got this code where the Streamreader sometimes reads the file fine and sometimes skips a few lines and i have absoloutely no idea why it is doing this.
FtpWebRequest request = (FtpWebRequest)WebRequest.Create("ftp://myfile.txt");
request.Method =...
Hello dear friends,
I have 2 Tables which are related to each, i made the relationship in the dataset xsd window. When selecting a row in the parent table all child rows are shown and it works perfect. However when i filter the bindingsource only the current selected parent rows child rows are...
Thank you sir. It is just that the dataset.xsd doesn´t show the database correctly. new columns or new tables in the database are detected and added to the table in the dataset.xsd correctly, but not when i change the datatype of a column or for eaxmple when i change the nvchar(10) to...
Dear friends,
when i change things in my sql database, for example i add a new column, delete one, change datatype of a column and stuff like that and then update my dataset with the wizard the changes are not shown correctly. Some things are updated correctly some not and only if i delete the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.