|
You need to add quotes around the user_name because it is a string:
dbcComm.CommandText = "SELECT studenti.user_name,studenti.Nume, " +
"studenti.Prenume, cursuri.denumire_curs, note.nota, note.data " +
"FROM studenti INNER JOIN (cursuri INNER JOIN [note] ON " +
"cursuri.id_curs = note.id_curs) ON (studenti.id_stud = note.id_stud)"+
"WHERE studenti.user_name= '"+user.ToString()+"'";
note:
It's much better to use parameterized query to avoid SQL injection.
|
|
|
|
|
Hi
You need to put quotes around your literal:
"WHERE studenti.user_name= '" + user.ToString() + "'";
You might consider actually using a parameter here - it's good practice 
----------------------------
Be excellent to each other
EasiReports[^] My free reporting component for WinForms.
|
|
|
|
|
is there any way to read and write COM PORT through c#
please help me if any one know it
thanks
raj
india
link
|
|
|
|
|
mohdmeraj wrote: very very urgent
mohdmeraj wrote: is there any way to read and write COM PORT through c#
Yes.
|
|
|
|
|
|
i use "Select * from tableName Where joinDate >= '02/05/2006' And joinDate <= '15/05/2006'".
it does not work but why, i use sql server.
plz help me.
|
|
|
|
|
what do you mean by its not work ??
Tamimi - Code
|
|
|
|
|
i mean, it does not return any row but the table contains those type of row which satisfied this condition( joinDate >= '02/05/2006' And joinDate <= '15/06/2006')
|
|
|
|
|
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
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
