|
If you encounter a "syntax error", then the command cannot be interpreted because it looks different then the expected form. It also gives a hint about the location of the error.
WHERE (Environmnets.DateT = (SELECT MAX(DateT) FROM Environmnets)
AND TMushroomHouse.Name=@MuschroomHouseName; It's also not a C#-question, but a question on SQL; it would fit better in the database forum.
Concatenating a string into a SQL-statement is asking to be hacked; you'd want to turn that into a parameterized query.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
tqvm on ur reply 
|
|
|
|
|
Member 10724507 wrote: FROM Environmnets AS Environmnets_1), TMushroomHouse.Name='"+ DropDownList1.Text + "'";
should be:
FROM Environmnets AS Environmnets_1) WHERE TMushroomHouse.Name='"+ DropDownList1.Text + "'";
The difficult we do right away...
...the impossible takes slightly longer.
modified 15-Apr-14 16:47pm.
|
|
|
|
|
Tqvm on ur reply i try to change it but it still cannot work 
|
|
|
|
|
Member 10724507 wrote: SELECT Environmnets.id, Environmnets.TempIn, Environmnets.tempOut, Environmnets.humidity, Environmnets.DateT, Environmnets.Deviceid, Environmnets.House
FROM Environmnets INNER JOIN TDevice ON Environmnets.Deviceid = TDevice.id INNER JOIN TMushroomHouse ON TDevice.MushroomHouseId = TMushroomHouse.id
WHERE (Environmnets.DateT = (SELECT MAX(DateT) AS Expr1
FROM Environmnets AS Environmnets_1), TMushroomHouse.Name='"+ DropDownList1.Text + "'";
The issue is with the , before TMushroomHouse.Name. Is this meant to be an AND statement by any chance? By the way, you should really avoid concatenating things in like DropDownList1.Text to prevent opening your app up to SQL Injection Attacks.
|
|
|
|
|
yup..i try to make it like this (Environmnets.DateT =(SELECT MAX(DateT) AS Expr1 FROM Environmnets AS Environmnets_1)) AND TMushroomHouse.Name='"+ DropDownList1.Text + "'";
It doesn't show the error but when i select from dropdownlist, it will not show the output in my textbox
|
|
|
|
|
How to send a message to mobile phone from PC/Laptop By using AT Commands..and also stored the message sending details in sql database.
|
|
|
|
|
Please do not post twice, just edit the first.
Where are you stuck?
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
And when you have finished not posting twice, just go and see Mr Google - he has lots, and lots of examples of code that does that. In future, please try to do at least basic research yourself, and not waste your time or ours.
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
How to send a message to mobile phone from PC/Laptop By using AT Commands..
|
|
|
|
|
how to create multiple events in c#
v.Anilkumar
|
|
|
|
|
for what? you need to explain what you are trying to do.
Every day, thousands of innocent plants are killed by vegetarians.
Help end the violence EAT BACON
|
|
|
|
|
You create them in the same way you create a single event - just more of them. Until you tell us what effect you are after, this is as close to an answer as we can get I'm afraid.
|
|
|
|
|
I have created sms sending using c#.net with at commands through my mobie phone. The msg send to the receiver after unplug the phone from my laptop. Please provide any idea to me. Urgent ........
|
|
|
|
|
Member 10750212 wrote: Please provide any idea to me.
Idea about what?
Member 10750212 wrote: Urgent
Sorry, not to anyone here.
|
|
|
|
|
message receive to the receiver after unplug the device from my lap/pc. how send a msg to anyone without unplug my device/phone from lap/pc..please send a code to me
|
|
|
|
|
Member 10750212 wrote: send a code to me
This is not a write an application to order service. If you want this functionality then you need to at least attempt to write it yourself. No one here is going to write the whole thing for you.
|
|
|
|
|
Hi ,
I need to change culture mainly between two languages ; italian and English using the Combobox in WPF MVVM.
I tried to databind the ViewModel with my Mainview but I didn't succeed.
I will be so thankful if someone could help.
Here is my Combobox declaration in xaml :
<ComboBox IsEditable="True" Text="Language" HorizontalAlignment="Right" VerticalAlignment="Top" Width="95" Margin="34,21,34,0" ItemsSource="{Binding Languages}" SelectedItem="{Binding SelectedLanguage, Mode=TwoWay, UpdateSourceTrigger=PropertyChanged}" Foreground="#FF434C64" removed="Green" Height="24.96" />
Here is View Model definition :
public void ChangeLanguage()
{
if (SelectedLanguage == "en")
{
Thread.CurrentThread.CurrentUICulture = new System.Globalization.CultureInfo("en");
}
else
if (SelectedLanguage == "it-IT")
{
Thread.CurrentThread.CurrentUICulture = new System.Globalization.CultureInfo("it-IT");
}
}
Here the declaration within the construcor of my View Model
public ViewModel()
{
LoadData();
ChangeLanguage();
Login = new DelegateCommand(this.Logging, delegate()
{
return (!String.IsNullOrEmpty(Username) && !String.IsNullOrEmpty(Password) && !String.IsNullOrEmpty(Email));
});
Register = new DelegateCommand(this.Registering, delegate()
{
return (!String.IsNullOrEmpty(Username) && !String.IsNullOrEmpty(Password) && !String.IsNullOrEmpty(Email));
});
|
|
|
|
|
You have already posted this question[^] in the WPF forum, and again in QA[^].
DO NOT post the same question in multiple places across the site.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
How can I show particular user information in a page from database using c# AND SQL sErvr 2005 in vs 2008
|
|
|
|
|
A lot of that is going to depend on how you handle membership, and identify users.
But, the most basic way to do this is to use the Session to store the user info - his username perhaps.
Store teh username when he logs in:
Session["UserName"] = myUserName;
Then, you can display the username just by including it in your HTML:
Welcome <%=Session["UserName"]%>
Or, you can set it into a label in your C#:
Label1.Text = string.Format("Welcome {0}!", Session["UserName"]);
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
|
|
That is a typical homework question! Whose job is it to do your homework? How will you actually learn if you never write a line of code? And: your teacher might find out that you cheated...
|
|
|
|
|
Hi,
I have the simple code:
// calibrate 4 mA
double delta = 4.0 - multimeterValue; // double multimeterValue
delta = delta / 0.005; // output 5 uA x step
ushort outValue_4mA += (ushort)delta;
But using double (or floating) numbers, how can I get the results:
delta = 4.0 - 4.02 = -0.02 ? I get delta = 0.01999998 !
delta /= 0005 = 4.0 ? I get delta = -3.99999619 !!
outValue_4mA += delta; if outValue = 2000, here I get 1997 instead of 1996 !!!
My old pocket calculator is better: 4.0 - 4.02 = -0.02 and -0.02 / 0.005 = 4.0 and outValue_4mA = 2000 - 4 = 1996.
What can I do to get the correct results?
thanks
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
