|
Hello.
I am attempting to display the contents of a Date/Time column from an Access database table in my DataGrid Control in VB.NET
The DataGrid control (ReportGrid) is bound to a DataSet, which is filled using a DataAdapter with the data stored in a recordset (snippets are given below)
Public reportDA As New OleDb.OleDbDataAdapter
Public reportDS As New DataSet
Public GridReport As New ADODB.Recordset
GridReport.Open(SQLtxt, DBConnection, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockReadOnly)
reportDA.Fill(reportDS, GridReport, "Report")
ReportGrid.SetDataBinding(reportDS, "Report")
The "Report" table held within the DataSet contains several columns. I am able to display the 'Date' column within the DataGrid but the 'Time' column displays the information in a Date Format:
Original Database table displays: 10:16:51
DataGrid Control table displays: 30/12/1899 (For any time)
I have tried to directly copy the contents of the Access table using the coding below but with no success:
GridReport.MoveFirst()
For i = 0 To GridReport.RecordCount - 1
reportDS.Tables("Report").Rows(i).Item("Time") = GridReport.Fields("Time").Value
GridReport.MoveNext()
Next
Any help would be most appreciated.
-- modified at 8:21 Thursday 5th January, 2006
|
|
|
|
|
Your mixing your use of two different sets of database objects. You should NOT be using ADODB objects with the .NET OleDb classes. This is probably what's causing your date/time translation issue. You should be using OleDbConnection and OleDbCommand objects in stead of ADODB junk.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Thank you. I will give it a try. I only used ADODB because the documentation said it was also possible to use recordsets to fill the DataSet.
|
|
|
|
|
I see the code to convert a binary user SID to String, but it's in C++, can someone help me to do this in vb.net. I only need to convert the SID to string.
Thanks.
|
|
|
|
|
In what form do you have the SID in your VB.NET code? Without that starting point, it's pretty difficult to tell you, with any accuracy, how to convert it to a string. But, I would image that String.Format or .ToString would be used.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Finally I find it in this web: http://www.pinvoke.net/default.aspx/advapi32/ConvertSidToStringSid.html
Thanks
|
|
|
|
|
Hi,
I need a vb.net code for listing the Hardwares/softwares installed in PCs in a network.
Thanks
JV
jvtt
|
|
|
|
|
So write it. Noone here is going to do it for you.
You'll need code to scan your network, either by scanning an IP address reange, or by enumerating the machine in the domain.
You'll contact each of these machines using WMI (System.Management namespace), and run the appropriate WQL queries to return the Products installed and also enumerate the hardware on each machine.
You'll also have to create a database to hold all this information.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
hi,
my friends....
plz, how to use msflaxgrid control in vb6, each cell two diferen fonts
kamal...
-- modified at 2:07 Thursday 5th January, 2006
|
|
|
|
|
It's been years since I used it, but I don't think you can have multiple fonts in the FLEXGRID, not flax.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
hi dave
thanks your reply...
any idea... plz
kamal.
-- modified at 0:52 Saturday 7th January, 2006
|
|
|
|
|
I would advice you to use a List View Control for what ever you are doing. Its much easier and good to use. Cya. All the Best.
Devraj Raut!!!
|
|
|
|
|
thanks Devraj Raut for your reply.
hive me a List View's sample code program in vb6 or vb.net, pls help me
is there any way at all which will allow me to use 2 font within the same cell or advice
pls reply very soon.....
kamal.
Kamalatharsan
-- modified at 22:06 Saturday 7th January, 2006
|
|
|
|
|
|
The reason you should do it in C, is because C requires it. The reason not to do it otherwise is because it makes your code harder to read, and harder to debug. You should read 'Code Complete' to get more insight into good code style, it's an excellent book.
But as a starter - the code posted created a bunch of uninitialised variables, then proceeded to give them all values. How is that useful ? He could have done the same in half the lines, thus increasing readability, and making sure that no variables existed without being given the values you wanted them to start with.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
it wasn't my code 
I tend to declare and initialise all my variables at the top of my procedure\functions, so that I know where they all are. It really isn't a big issue because I try and keep my procedures pretty small, but I like having them at the top. I can't justify it which is why I found your statement that it shouldn't be done that way interesting
Thanks for the book recommendation. I will look into it
/jason
|
|
|
|
|
Sorry, I worked that out later 
Keeping your functions small is another recommendation from the book, actually. You'll probably find, as I did, that most things it recommends, you do, but it's worthwhile just to think about the reasons why.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
i want to convert a JPG image to BMP
i used this way:
dim BMPImage as new System.Drawing.Bitmap(JPGImageName)
BMPImage.Save(JPGImageName,System.Drawing.Imaging.ImageFormat.Bmp)
but an exception come up and say: "A generic error occured in GDI+"
so what is the problem?
and Should i work with XML to solve this problem?
Militiaware
Faris Madi
|
|
|
|
|
|
It's failing because you're trying to save the file using the same name that you loaded it from. Since the file is locked, the save won't work. Try changing the filename you want to save it to.
Dim srcImage As New Bitmap(JpgImageName)
srcImage.Save(someOtherFilename, ImageFormat.Bmp)
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
How did I miss that ?
What's happening in your neck of the woods, Dave ?
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Utter exhaustion!  Between the Holiday's, travel, work load stress, and screwed up travel expense reimbursment (Ouch!!), for both my fiancée and myself... Well, it hasn't been that fun.
She had to make three business trips in the first 3 weeks of December, all out of her pocket up-front. I had 2 trips during the same time. We didn't see each other for about 2/3rd's of the month!
Then we went to her parents in Chicago for Christmas. That was a nice little break, but WAY too short at 4 days!  Santa was good to us though. A couple of power toys for around the house, stuff for the XBox, and a couple books on Poker.
I'm buried up to my eye balls in dead Dell's because they used a Tiawanese motherboard manufacturer and the capacitors in 'em are puffing up and spewing crap all over the place! (known as Capacitor Plague) It's really cutting into my Dev time and putting me WAY behind on various projects. 
But, things are looking up! I'm running out of machines to replace MB's in, neither one us has any out-of-town business comming up until April, she's starting a new management position where she works, and since I have a Government job, some more holidays comming up!
Then, there's out wedding in May, and it's off to Vegas for 10 days! WooHoo!  Hopefully, we'll be on vacation for the rest of 2006 after that!
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Dave Kreskowiak wrote: Then, there's out wedding in May, and it's off to Vegas for 10 days!
Wow - 10 days in Vegas. I hated it for 10 hours. I guess everyone is different....
Sounds like you've been busy tho.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Vegas is fun for a while, but we're not spending all of our time there. We're taking the camera's out to the Grand Canyon and Lake Mead for bit, maybe do a little kayaking. Got some new filters to play with.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Dave Kreskowiak wrote: We're taking the camera's out to the Grand Canyon and Lake Mead for bit, maybe do a little kayaking.
Now, that's a different story. I'd spend a week in the Grand Canyon, no problems at all. It was the highlight of my trip.
Christian Graus - Microsoft MVP - C++
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
