troubleshooting Question

coding in VB.net visual studio 2019 question

Avatar of urjudo
urjudoFlag for United States of America asked on
DatabasesVisual Basic.NETMicrosoft Visual Studio
7 Comments2 Solutions51 ViewsLast Modified:
Hi Experts,
I'm having couple questions about the VB.Net in Visual Studio 2019. Currently I'm convert a database from Access to VB.net Visual Studio 2019, I have some problem that could figure it out (Im really new to the VB.Net visual studio 2019, never use this language before)
1).Having trouble to convert UpdateDate from Long Date to short date (in SQL Server is short date, but when I convert to VB.net, it shows Long date and I want to convert to short date)
   
      my code: UpdateDateDateTimePicker.Value = DateTime.Now.ToShortDateString
      this code shows today's date but still showing long date

2). I try to get the user name as first initial and last name, how do I do that?  (for example: from jane.doe to jdoe)
     my code: Me.UpdateByTextBox.Text = System.Windows.Forms.SystemInformation.UserName
     this code shows: jane.doe (our login as firstname.lastname)

3). I have couple check box, after get the data from SQL, those check box are show black, I have to check them to make them clear then I can check the check boxes.  

4). when I add a new record, the UpdateDate and UpdateBy are not saving in the table. where I can put the code for these two fields to?  currently I'm put the code for UpdateDate & UpdateBy inside the  "Add New" button.  

Any help will be great appreciated!
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 7 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros