hi all,
I have a database with a field configured to accept date/time. I am more interested in the time part of the entry.
the problem that i am facing is that I always get 12:00AM
can't figure it out!!
I created a subroutine to filter a dataview and i want to pass the colum to be filtered through a declared string variable
ex. lets say I want to filter the date column
x="date"
then i call the routine and send x
in the routine i have a dataview.rowfilter that looks like this
Private Sub...
i am trying to store a numeric value in a textbox in a msaccess field.
the field is numeric simple real type
code:
Dim dr As System.Data.DataRow = Ds1.Table(0).NewRow
dr("number") = cdbl(txtnum.text)
Ds1.Tables(0).Rows.Add(dr)
OleDbDataAdapter1.Update(Ds1)...
my application was working perfectly well before i tried to refine it. I have an mdi form and 3 other forms. Before the problem, for every form i had a new connection to my database with the required adapters.
To make my application more effecient I thought of making one connection and connect...
Hi everyone,
I am new to programming and would need some help, I have an access database connected to my vb.net program. The user in my program inputs the txtdate, txtAmount, cboCategory,cboStore,txtReceipt, and txtMemo.
example of ideal case:
date.txt 06/12/05
Amount.txt 300$...
I get an error everytimes i try to update my dataset to msaccess.
here is the code:
Dim dRow As DataRow
row = DsSpendings1.Tables(0).Rows.Count()
dRow = DsSpendings1.Tables(0).NewRow
dRow("Date") = CDate(txtDate.Text)
dRow("Transaction") = row...
is there a code line to "group by" or "sort by" a Dataset that has been imported from a access database. I don't want to group the data while importing. I just want to perform sorting and grouping within a dataset after having imported the raw data
My second question is can we use one adapter...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.