|
try to excute your query in the query analyzer and see what happen.
if its work take a look to your code.
Tamimi - Code
|
|
|
|
|
sql won't recognise 02/05/2006! this is just a string and not a date.. Maybe this works 1900-01-04 00:00:00.000 but the safest way is to use an explicit cast like this CAST('1900-01-04 08:00' AS datetime)
|
|
|
|
|
sometimes the sql server configure the date as mm/dd/yy so 15/05/2006
is not a valid date
Tamimi - Code
|
|
|
|
|
You better use the yyyyMMdd format with SQL server for dates:
This :
foysal mamun wrote: Select * from tableName Where joinDate >= '02/05/2006' And joinDate <= '15/05/2006'
should be written like:
Select * from tableName Where joinDate >= '20060502' And joinDate <= '20060515'
|
|
|
|
|
Does the exact query entered into SQL Server through Query Analyzer return any rows?
|
|
|
|
|
Hi all,
I have a tooltip on a Checkbox. As long as the users don't click on the Checkbox, it's tooltip will displpay. However, once the user has clicked on it, the tooltip won't appear anymore.
Is this fixable?
|
|
|
|
|
Do you want to do this ?
You may then :
private void myCheck_CheckChanged(object sender, eventargs args)
{
this.myCheck.ToolTip = null;
}
------------------------------ "The Soapbox has been so ..."
|
|
|
|
|
1 be sure that your code dose not reset the tooltip from the checkbox.
2 if you are sure delete the checkbox and drag drop it again
Tamimi - Code
|
|
|
|
|
i can't find anywhere an example...i know that in php when used a variable
in Sql Select statement you must put a sign before it like a $ or put between
'' so there must be something in C# too !
Thanks
TheBeginner
|
|
|
|
|
just treat the sql command as you would a String,
ie:if for example you want a variable to define what the select will return the code will be
MyCommand.CommandText = "SELECT " + MyVar.tostring() + " FROM MyDB";
i hope this answers your q
|
|
|
|
|
When you use a SQL parameter, designate the parameter with an "@" symbol. E.g. "Select FirstName, LastName from Contact where ContactID = @contactID"
This is SQL syntax and would apply to any queries against the SQL server database, C#, VB.NET, j#, etc. all would use the same syntax.
Jim Conigliaro
jconigliaro@ieee.org
|
|
|
|
|
This is definitely the preferred method. You'll get data type mismatch exceptions at runtime instead of SQL injection attacks.
|
|
|
|
|
TheBeginner77 wrote: used a variable
in Sql Select statement you must put a sign before it like a $
Read this article about SQL injection attacts.
SQL Injection Attacks and Some Tips on How to Prevent Them[^]
I'd love to help, but unfortunatley I have prior commitments monitoring the length of my grass. :Andrew Bleakley:
|
|
|
|
|
Im not sure if Insert is even the right word in SQL terms, but heres my problem:
I am trying to write files, binary files, into a database using a buffer. I want to add large files into the database in small pieces. I have the code underlying the problem of actually cutting it up. My problem starts when I try to insert it into the database, it just overwrites the previous data instead of appending it.
All help is greatly appriciated!
THANKS!
|
|
|
|
|
It would be very helpful to see the SQL statements you're using.
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook
www.troschuetz.de
|
|
|
|
|
Hi,
This is kind of a repost, but not completely.
I want to show a Pitch graph/curve of a wave file. I saw that good results can be made by using AutoCorrelation. I have the autocorrelation function and I also have the FFT function, but I don't know what I should put into the autocorrelation function in order to get a pitch line.
I have a wave file (spoken text), and also have the FFT results of the wave file, how can I extract from this data a nice Pitch curve. The purpose of the pitch line is to show the intonations of the text.
Thanks,
Gidon
|
|
|
|
|
I'm trying to build a simple backup program in C# and want direct disk/partition access to the raw data with longfile name support. I have been looking for documents or source to learn from but I cannot find any. I'm sure I'm just not searching for the right keywords. Can anyone point me in the right direction?
Thanks,
dcoerver
|
|
|
|
|
I'm not absolutly sure what you want because when you're talking about raw access to the disk or a partition you don't have file names.. There is just one big block of data which you have to parse yourself...
However if you just want to read raw data from a partition - it's pretty easy with CreateFile. You can specify this: "\\.\C:" instead of a filename to "open" a partition!
|
|
|
|
|
Can someone show me how to do this in c#?
|
|
|
|
|
hi
in the button_click i wrote these codes :
string src = @"E:\App_Lock\HDCopy.exe";
FileStream finput = new FileStream(src,FileMode.Open);
BinaryReader br = new BinaryReader(finput);
byte[] b = br.ReadBytes((int)finput.Length);
System.AppDomain dom = System.AppDomain.CreateDomain("newDomain");
Assembly assembly = dom.Load(b);//Get Error On this line
assembly.EntryPoint.Invoke(null, null);
but an error occured when i clicked button and show this error :
Additional information: Exception from HRESULT: 0x8013141D
How to solve My problem and run app from byte[]?
|
|
|
|
|
hdv212 wrote: Exception from HRESULT: 0x8013141D
is HD_Copy.exe a Managed C++ mixed-mode assembly? If so, you cant load it from byte[].
|
|
|
|
|
hi
HD_Copy.exe is a setup program and i don't know what is it ..
|
|
|
|
|
How can i make a file(or my code) as a ddl file so that no one can see my code.
Any help please??????????
aLi
|
|
|
|
|
If you mean calling the code, you may mark your code blocks as private or internal, otherwise you mean by diassimlying your code you may use Dotfuscator.
------------------------------ "The Soapbox has been so ..."
|
|
|
|
|
to convert you program to DLL :- from the main menu select
Project -> Properties on the properties dialog change the (output type)combobox to (Class Library) then press ok().
Tamimi - Code
|
|
|
|