Train for your certification. Learn the latest DevOps tools. Grow your skillset to do better work.
At Linux Academy, we release new training modules every week so you'll always be up to date on the latest tech.
Course Of The Month
7 days, 16 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
VB.net Binding Controls to BindingSource with Formatting
Posted on 2014-02-06
Hi,
I am creating a database application and have bound my form controls to the binding source.
One of the form controls is a DateTimePicker and the DataBinding is:
How can I format the DataBinding so that when the value is sent back to the database it does not include the current timestamp or the current timestamp is set to 00:00:00.
I am using a DataAdapter to to insert/update the data.
Thanks, Greg
I am creating a database application and have bound my form controls to the binding source.
One of the form controls is a DateTimePicker and the DataBinding is:
dtpickerDate.DataBindings.Add("Value", bsReading, "Reading_Date", True, DataSourceUpdateMode.OnValidation, DateTime.Today)
How can I format the DataBinding so that when the value is sent back to the database it does not include the current timestamp or the current timestamp is set to 00:00:00.
I am using a DataAdapter to to insert/update the data.
Thanks, Greg
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
4
3
7 Comments
One option is to use either Validating or ValueChanged event of date time picker to remove the time part.
Also check following thread
http://social.msdn.microsoft.com/Forums/windows/en-US/6a07a64a-4286-4519-8ffb-372b0e9e4814/when-databinding-a-nullable-datetimepicker-it-needs-click-twice-in-either-the-dropdown-calendar-or?forum=winformsdatacontrols
Also check following thread
http://social.msdn.microsoft.com/Forums/windows/en-US/6a07a64a-4286-4519-8ffb-372b0e9e4814/when-databinding-a-nullable-datetimepicker-it-needs-click-twice-in-either-the-dropdown-calendar-or?forum=winformsdatacontrols
Hi,
Another formatting issue with a bound textbox, I would like to format the following as two decimal palces (rounded up).
How can I achieve this?
Another formatting issue with a bound textbox, I would like to format the following as two decimal palces (rounded up).
How can I achieve this?
txtUsage_TTM_CostDaily.DataBindings.Add("Text", bsUsage, "TTM_AvgDailyCost")
Hi,
I have tried the following code:
but I get an error, "Input string was not in a correct format."
I have tried the following code:
Private Sub txtUsage_InServ_CostDaily_TextChanged(sender As Object, e As System.EventArgs) Handles txtUsage_InServ_CostDaily.TextChanged
txtUsage_InServ_CostDaily.Text = Convert.ToInt32(txtUsage_InServ_CostDaily.Text)
End Sub
but I get an error, "Input string was not in a correct format."
What does the textbox contain when you this code runs?
Try
Try
Private Sub txtUsage_InServ_CostDaily_TextChanged(sender As Object, e As System.EventArgs) Handles txtUsage_InServ_CostDaily.TextChanged
If Not String.IsNullOrEmpty(txtUsage_InServ_CostDaily.Text) Then
txtUsage_InServ_CostDaily.Text = Convert.ToInt32(txtUsage_InServ_CostDaily.Text)
End If
End Sub
Featured Post
May was a big month for new releases from Linux Academy! Take a look at what our team built recently in our blog. You can access the newest releases from our blog.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
In my previous article (http://www.experts-exchange.com/Programming/Languages/.NET/.NET_Framework_3.x/A_4362-Serialization-in-NET-1.html) we saw the basics of serialization and how types/objects can be serialized to Binary format. In this blog we wi…
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex.
A simple solution to parsing a customized CSV fi…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have.
In this…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Suggested Courses
Course of the Month7 days, 16 hours left to enroll
728 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.