|
Hello,
I was wondering if anyone is having this problem and knows the how and why of it. I have a Microsoft Access table, where one column is in the Date/Time format (format set to general). When I try to update this table (i.e. adding a new row) using C#, I get a datatype mismatch error. Is there anyway to directly pass this information to Access? I am using oledb.
I've found a work around by converting my date/time in c# to a string and storing it in my database as a string. But if possible, I'd like to keep it as a date/time format in my database.
Thanks in advance!
 over-worked, under-paid, glorified secretary 
|
|
|
|
|
It would help if you could post a sample of the code that is not working, along with a description of the table structure (is the field a date/time type, or a text datatype with display format set to general date?).
|
|
|
|
|
Hehe, oops, here is some of the trouble code:
userDS.UserSessionInfo.AddUserSessionInfoRow(CurrentUser,myDate,false,false,"",false,"");
when myDate is:
DateType myDate = DateTime.Now;
and the table structure for UserSessionInfo is:
UserSessionPkey --> int (autoincrement row, primary key)
UserPkey --> int (foreign key)
SessionDate --> dateType
ErrorsGen --> boolean
Training --> boolean
TrainingType --> string
Testing --> boolean
TestingType --> string
The above doesn't work and generates a datetype mismatch type error. But when I change it to the following, it works fine:
string myDate = DateTime.Now.ToString();
and the table structure for UserSessionInfo is:
UserSessionPkey --> int (autoincrement row, primary key)
UserPkey --> int (foreign key)
SessionDate --> string
ErrorsGen --> boolean
Training --> boolean
TrainingType --> string
Testing --> boolean
TestingType --> string
In my MS Access database, the column for SessionDate is of type Date/Time, with no formatting specified. When I change myDate to be a string, it works fine, even though I did not change the type in the Access database.
I know I've got a work around, by using strings, but I'm curious if anyone knows why this is happening.
TIA!
-- modified at 17:17 Sunday 19th November, 2006
~~~~~~~~~~~~
Over-worked, under-paid, glorified "secretary"
|
|
|
|
|
Okay...and now its doing the same thing with a boolean type. If I change my .xsd column from boolean to string, it works.
What's going on?? I found this website, and I thought I was doing what it lists...argh!
http://support.microsoft.com/default.aspx?scid=kb;en-us;320435
~~~~~~~~~~~~
Over-worked, under-paid, glorified "secretary"
|
|
|
|
|
I believe Access stores dates as real numbers representing the number of days since December 20, 1899 (or something close to that), so you probably need a conversion function. In VB, we could use CDate(X) to convert a date represented as a string to a value with date/time format. See if C# has a similar conversion function.
Scott
|
|
|
|
|
Ohhhh...now why don't they just say that instead of crazy errors? I don't suppose you have a resource (website, book, etc.) I can look into in case I run into this problem again for other types (i.e. stupid boolean type in another post). I will give this a try, it seems to make crazy enough sense to be right. Thanks so much! ![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
~~~~~~~~~~~~
Over-worked, under-paid, glorified "secretary"
|
|
|
|
|
I want to import a txt CSV file into a view in SQL 2000.
that can be done easily using VBA but the problem is that I want to check the validity of data e.g checking the serial no if its numeric , check the date if its in correct format...and I want to use a sql trigger for that so that each time theres an insert , before that it should chk the validity of data , etc . .
plz hlp.
imran
|
|
|
|
|
Dear all;
I have a datetime field that stores data like "15/11/2006 10:12:23 AM"
how can I extract the date part only without concatenating month and day and year inside the Sql statement as i have LOTs of data to be extracted. I tried to cast to char(10) and then convert to date but it was too slow.
Thanx
Scorpion
|
|
|
|
|
ThaScorpion wrote: how can I extract the date part only
Use the following in stored procedure,
convert(varchar,checkindate,101) as checkindate
This will extract only 15/11/2006 only.
For ur reference:
checkindate --> Field in the table.
Hope u will understand it.
Janani
|
|
|
|
|
I mean extracting as date not just a string !
As converting to varchar ordering as date will fail !!
If I will say "Order By convert(varchar,checkindate,101) as checkindate"
the sort order will not be correct.
Is there anything in SQL server that solves that problem ??
hope u understand it.
Thank u
Scorpion
|
|
|
|
|
use dateadd(day, datediff(day, 0, checkindate), 0) as checkindate to truncate the time value
|
|
|
|
|
Thank you indianet for your reply
but i think i will face the same problem of speed.
i didnt try it yet, but do u think it will not be slow ?
There is a function in Access that do the solution in one step like :
"Order by DateValue(CheckInDate)" and thats it !
there is nothing like that in Sql Server ?!
thanx
Scorpion
|
|
|
|
|
select convert(varchar,Reminder_date,101) as Reminder, Reminder_From, Reminder_Until, Reminder_AlarmTime, Create_dt, Update_dt from dbo.TBL_Reminder order by Reminder
It was possible to order by date.
Janani
|
|
|
|
|
Thanx alot till i Try it
ThaScorpion
|
|
|
|
|
Have U order it by date?
Janani
|
|
|
|
|
Is there a way to run a query where i delete all rows containing a row ID in a text file? ie. I have a table "Items" with a column "ItemID". Id like to delete every ItemID row contained in c:\test.txt
Any help would be appreciated.
|
|
|
|
|
Hello everybody,
How to build a regular expression to check that all the given words are present in a sentence in any order but all words should be present.
for example: Given words:- aaa bbb ccc
sentence:-1) rock aaa bed bbb sky ccc
2) rock bbb bed aaa sky ccc
3) rock aaa bed bbb
Matchs:- 1 and 2 should get matched in the sentence
3 is not a match
Mitesh... best of luck..
|
|
|
|
|
select sentence
from ( select sentence
from ( select sentence
from book
where sentence like '% aaa %'
)
where sentence like '% bbb %'
)
where sentence like '% ccc %'
;It's not a regular expression, but this is the SQL forum after all. 
Chris Meech
I am Canadian. [heard in a local bar]
I agree with you that my argument is useless. [Red Stateler]
Hey, I am part of a special bread, we are called smart people [Captain See Sharp]
The zen of the soapbox is hard to attain...[Jörgen Sigvardsson]
I wish I could remember what it was like to only have a short term memory.[David Kentley]
|
|
|
|
|
hello All,
i am a beginner in vb.net. am creating a small project in vb.net. using sqlserver 2000 as back end. i am creating the application and code . finally am creating package. all those things are working correcly in my system only. but the packages(setup1) installed n other system but not working well. whenever the database using page is open or button click action. it was so some error that 'System.Data.Sqlclient.Sqlconnection' threw an exception' and the button press action it was shown 'Object references not set to an instance of object,. Please help me it is very urgent.... so plz plz plz help me solve this problem.
attached code below
<br />
Imports System.Data.SqlClient<br />
Imports ADODB<br />
<br />
Public Class screen1<br />
Dim con As SqlConnection<br />
Dim cmd As SqlCommand<br />
Dim dr As SqlDataReader<br />
Dim str As String<br />
Dim c As New ADODB.Connection<br />
Dim rs As New ADODB.Recordset<br />
<br />
Private Sub screen1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load<br />
con = New SqlConnection("server=software;uid=sa;pwd=sa;database=payroll")<br />
c.Open("DSN=Emp", "sa", "sa")<br />
rs.Open("empl", c, CursorTypeEnum.adOpenDynamic, LockTypeEnum.adLockOptimistic)<br />
End Sub<br />
<br />
rrrriiizz
|
|
|
|
|
You are instantiating object con and then trying to open object c without instantiating it...
|
|
|
|
|
By using this code i am getting the whole database row i want only the first row of database table name is library..hoe can i do that??
Sub BindGrid()
Dim myConnection As New SqlConnection("server=(local);database=pubs;uid=sa;pwd=;")
Dim MyCommand1 As SqlDataAdapter = New SqlDataAdapter( _
"select * from Library ", myConnection)
Dim DS As DataSet = New DataSet
MyCommand1.Fill(DS, "Library")
MyDataGrid.DataSource = DS.Tables("Library").DefaultView
MyDataGrid.DataBind()
End Sub
GANESH
|
|
|
|
|
To do this you need to have a uniquely representing column(i.e a primary key column),and by makeing use of it u can select which ever the row u want..!(let us say primary column as id)
change your select statement to..."select * from Library where id=1"
|
|
|
|
|
u can use dataview to bind ur datagrid and can use dataview's Rowfilter property to filter the data according to condition specified by u.
rahul
|
|
|
|
|
use this
"select top 1 * from library"
|
|
|
|
|
I'm new to ASP.NET. Can anyone provide answer for my question below?
1. I have a database connection in Page 1; then after some process, it redirect to Page 2. Now my question is, if we don't close the connection (eg: MyDBConn.Close), after redirect to Page 2, will the resourse still grab in Page 1?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
