|
hi,
i want to build a sql statement like following using DateTime field in where clause. but, it return invalid format.
strcmd = "select * from table_1 where datentime = '11/12/2003 17:45:34'";
// where type of 'datentime' is DateTime.
any method to convert a DateTime variable in C# into DateTime field in MSAccess?
thanks,
jim
|
|
|
|
|
AFAIK, you should be able to use the same standard date format as in SQL Server. What about this?
strcmd = "select * from table_1 where datentime = '2003-11-12 17:45:34'";
Thank you.
Jeff Varszegi
|
|
|
|
|
i did not try your format.
but, i have found a keyword to solve it.
take a look at below!
strcmd = "select * from table_1 where datentime = #12/31/2003 17:45:34#";
date format should be in this format, MM/DD/YYYY
thanks,
jim
|
|
|
|
|
Be careful, as Jeff suggested use the ISO date format of YYYY-MM-DD becuase if its run on a machine with different regional settings you may get caught out. If you use the ISO with the year leading in, Access recongnises this correctly. 11/12/03 can be interpeted as Nov 12 on a US machine, but on a UK machine its Dec 11.
Yes for dates you are supposed to use # instead of ' with Access. You can see the query builder add them in for you in Access.
"Je pense, donc je mange." - Rene Descartes 1689 - Just before his mother put his tea on the table.
Shameless Plug - Distributed Database Transactions in .NET using COM+
|
|
|
|
|
This is my conn string :-
server=Earth;database=Test;uid=Nish;pwd=nish123
Nish is a SQL server db user I added for the Test database using Enterprise Manager (today is the first I am seeign this weird app)
It says :- Login failed for use Nish; Reason: Not associated with a trusted sql server connection
Damnit that sucks. The sql server is running on this same machine (earth)
I am usiong System.Data.SqlClient.SqlConnection
Nish
Extending MFC Applications with the .NET Framework [NW] (coming soon...)
Summer Love and Some more Cricket [NW] (My first novel)
Shog's review of SLASMC [NW]
This post was made from Trivandrum city, India on a 0.0001 KB/s net connection
|
|
|
|
|
Does adding Integrated Security=false make a difference?
I only ever use Windows Authentication, but according to MSDN
Integrated Security
-or-
Trusted_Connection
'false' When false, User ID and Password are specified in the connection. When true, the current Windows account credentials are used for authentication.
Recognized values are true, false, yes, no, and sspi (strongly recommended), which is equivalent to true.
Michael
'Logic, my dear Zoe, merely enables one to be wrong with authority.' - The Doctor: The Wheel in Space
|
|
|
|
|
|
Have you tried this at the command prompt? This solved a similar connection problem on my computer.
osql -E -S (local)\DBNAME -Q "sp_grantlogin 'MACHINENAME\ACCOUNTNAME'"<br />
<br />
osql -E -S (local)\DBNAME -d Pubs -Q "sp_grantdbaccess 'MACHINENAME\ACCOUNTNAME'"<br />
osql -E -S (local)\DBNAME -d Pubs -Q "sp_addrolemember 'db_owner', 'MACHINENAME\ACCOUNTNAME'"
Substitute elements in UPPERCASE with the relevant informantion from your specific case.
Note: Contrary to you, I was using Windows Authentication instead of SQL Server Authentication.
|
|
|
|
|
Nish,
I apologize in advance if anything I say is stupid. I've never used SQL Server with Windows authentication at all.
In Enterprise Manager, go to your server, then Security - Logins. Right-click on the user in question and bring up the properties. Does it look like the user is set up to only use SQL Server authentication? Now, is the Test database set up so that it only accepts trusted Windows-authenticated user connections? Also, is it possible to add the user to the BUILTIN\Administrators group as a troubleshooting step?
Thank you.
Jeff Varszegi
|
|
|
|
|
Try this:
Data Source=Earth; Initial Catalog=Test; User ID=Nish; Password=nish123; Integrated Security=false
-----BEGIN GEEK CODE BLOCK-----
Version: 3.21
GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++
-----END GEEK CODE BLOCK-----
|
|
|
|
|
Dear all
in the help you can find the cachedbitmap documented but you could not use it in the code in c# if anybody how can i use it of if there are any way to accelerate the drawing on a control ???
regards
mhmoud
|
|
|
|
|
hi there:
i have a dataset called "Employees", that have two tables "employees"and "jobs",employees have a foreign key called "jobid" that refrence the primary key "jobid" in the "jobs" table and tied together,i have a datagrid that each record of it have columns from "employee" table and have one column called "jobDesc", i write the following function to get the "jobDesc" column from "jobs" table by the foreign "jobid"column in the "emplyee table...........I want to translate this function into method in c#
Public Function BindJob(ByVal o As Object) As String
Dim drv As DataRowView = o
Dim dr As Employees.employeeRow = drv.Row
'Dim dp As Employees.jobsRow = dr.GetParentRow("jobsemployee")
'Return dp.job_desc
' Alternatively, since this is strongly typed:
Return dr.jobsRow.job_desc
End Function
|
|
|
|
|
public String BindJob(Object o){ //forget about ByVal
DataRowView drv = (DataRowView)o;
Employees.employeeRow dr = drv.Row;
return dr.jobsRow.job_desc;
}
|
|
|
|
|
this casting is not working
DataRowView drv = (DataRowView)o;
error msg:
Exception Details: System.InvalidCastException: Specified cast is not valid.
|
|
|
|
|
No my fault 
If you don't pass a DataRowView, is can not be used as a DataRowView.
Try Console.WriteLine(o.GetType()); to find out, what is really is.
|
|
|
|
|
Does anyone know how to loop through all icons in an embedded folder and populate an imagelist. As seen below, I have an embedded folder Prud.Library.Icons.State which contains a set of icons. I would like to add all Icons in State to an ImageList regardless of their name.
Does anyone know how this can be done?
Thanks heaps. 
Note: string sIconName = "Prud.Library.Icons.State.Icon1.ico";
System.IO.Stream objStream = null;
System.Drawing.Icon[] objIcon;
try
{
/*
* Stream Icon and add to ImageList
*/
objStream = this.GetType().Assembly.GetManifestResourceStream(sIconName);
if (objStream != null)
{
objIcon = new System.Drawing.Icon[1];
objIcon[0] = new Icon(objStream);
}
}
catch (Exception err)
{
throw err;
}
finally
{
/*
* Dispose of Stream Object
*/
if (objStream != null)
{
objStream.Flush();
objStream = null;
}
}
return objIcon;
|
|
|
|
|
I know this is a tough one, but any help would be greatly appreciated.
Thanks in advance.
|
|
|
|
|
is there a way to have the microsoft agent character ask a user questions, and when they click yes/ok do one thing and no/cancel do another?
|
|
|
|
|
Hi,
Is there any way i can read remote machine registry in c#.
I will appreciate if some one give me code to read remote machine registry.
Regards,
Waqar.
|
|
|
|
|
You can read from a remote registry using the following static method:
Microsoft.Win32.RegistryKey.OpenRemoteBaseKey(...)
However, according to the MSDN documentation, the following must be ensured:
In order for a key to be opened remotely, both machines (the service, and client) must be running the remote registry service, and have remote administration enabled.
Cheers,
Miahrugger
|
|
|
|
|
You also only have access to the HKEY_LOCAL_MACHINE and HKEY_USERS keys
|
|
|
|
|
Hello,
are .NET form based desktop applications executable on other platforms with .NET framework installed? for example Linux
Thank you
|
|
|
|
|
|
How does this compare with Mono?
|
|
|
|
|
Tell me if you know. Thanx in advance. If not, which control can display both image and HTML code correctly?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
Nope I added it to the conn string - but I get the same error. 