C# Sql Textbox Select

by

You didn’t give any info about the problem you have so I assume the thing you forgot is adding the required 's around the from.Text and to.Text in your select command. Also, you should use Date validation to validate if the given text is a date.

            DateTime dtfrom;
            DateTime dtto;

            if(DateTime.TryParse(from.Text,out dtfrom) && DateTime.Parse(to.Text,out dtto);)
            {

                string from = dtfrom.ToShortDateString();
                string to = dtto.ToShortDateString();
            }
            else
            {
                //Parsing Error
            }

Your select command should be:

Select Nume,Score,Ora,LunaAn,UpdatedData FROM TEST3 where LunaAn between '" + from + "' and '" + to + "';"

More Related Contents:

  1. How to deploy application with sql server database on clients
  2. Failed to update .mdf database because the database is read-only (Windows application)
  3. Run multiple winform instance sequentially
  4. Passing Values Between Windows Forms c# [duplicate]
  5. Model-View-Presenter in WinForms
  6. What’s the difference between Application.Run() and Form.ShowDialog()?
  7. passing values between forms (winforms)
  8. Save Settings in a .NET Winforms Application [duplicate]
  9. How to connect to SQL server database from a Windows 10 UWP app
  10. Fill Panel with gradient in three colors
  11. How do I add my new User Control to the Toolbox or a new Winform?
  12. copying free hand drawing from panel in visual studio 2013
  13. Invalid column name sql error
  14. Controls in container form come over child form?
  15. Draw multiple freehand Polyline or Curve drawing – Adding Undo Feature
  16. DataGridView Using SortableBindingList
  17. Any trick to use opacity on a panel in Visual Studio Window Form?
  18. Show controls added programmatically in WinForms app in Design view?
  19. How do I create 5 buttons and assign individual click events dynamically? [closed]
  20. Why is EF generating SQL queries with unnecessary null-checks?
  21. Know when to retry or fail when calling SQL Server from C#?
  22. How to insert data into SQL Server
  23. display list of custom objects as a drop-down in the PropertiesGrid
  24. How to create a User Control with rounded corners?
  25. Passing Data Between Forms
  26. Passing data between two forms with properties [duplicate]
  27. DataGridView Image for Button Column
  28. Is it possible to switch rows and columns in a datagridview?
  29. Winform – determine if mouse has left user control
  30. How to set a text box for inputing password in winforms?

Leave a Comment