Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.
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
Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
It’s quite interesting for me as I worked with Excel using vb.net for some time.
Here are some topics which I know want to share with others whom this might help.
First of all if you are working with Excel then you need to Download the Following
…
For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"!
Step 1: Open a new google tab
Step 2: Go to the left hand upper corn…
Suggested Courses
Course of the Month13 days, 8 hours left to enroll
656 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.