|
Hi so im following a tutorial http://www.asp.net/learn/data-access/tutorial-01-cs.aspx.
I'm trying to configure a TableAdapter Query in the configuration Wizard with a SELECT statement which has a WHERE clause at the end.
I am about half way down the tutorial and have followed it word for word.
I have entered:
SELECT ProductID, ProductName, SupplierID, CategoryID, QuantityPerUnit, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, Discontinued
FROM Products
WHERE CategoryID = @CategoryID
But i am getting an error message on the last page of the config wizard saying:
Generated SELECT statement.
Error in WHERE clause near ‘@’.
Unable to parse query text.
Can anyone hazard a guess at what i'm doing wrong???
|
|
|
|
|
If you replace "@CategoryID" with "?" (without the quotes), does it work?
Take care,
Tom
-----------------------------------------------
Check out my blog at http://tjoe.wordpress.com
|
|
|
|
|
Hi
Is there any way to implement a graph using C#.Net.
Well i wanna create a sine wave graph but i think i need to use any extra tool or something..
Pls let me know if anybody got any idea....or any example ?
ta 
James
|
|
|
|
|
You could graph the points yourself by using the drawing abilities of C#. If you want to do graphs on data you could use Crystal.
|
|
|
|
|
ZedGraph is a great, free library. I used it before and liked it pretty much.
regards
modified 12-Sep-18 21:01pm.
|
|
|
|
|
Override System.Windows.Forms.Control and then override the OnPaint and OnPaintBackground method. You can then use the graphic context to draw the control.
Need a C# Consultant? I'm available.
Happiness in intelligent people is the rarest thing I know. -- Ernest Hemingway
|
|
|
|
|
Hello every1
In one of my project I download exe files (these are self extracting) from the internet. I need to extract these files to get a bunch of emded files to do some processing.
Can some1 suggest any utility or .NET library which I can use to extract these exe file
I have looked CP and I only found codes to extract zip files....
o O º(`'·.,(`'·., ☆,.·''),.·'')º O o°
»·'"`»* *☆ t4ure4n ☆* *«·'"`«
°o O º(,.·''(,.·'' ☆`'·.,)`'·.,)º O o°
|
|
|
|
|
If it is a self-extracting exe, then just run it and it will extract embedded files automatically. Winrar can also do it.
|
|
|
|
|
I have to extract the files programatically...
I can have have WinRar and WinZip installed on the target machines... but what I wanted to do was using .NET features to accomplish this task..
o O º(`'·.,(`'·., ☆,.·''),.·'')º O o°
»·'"`»* *☆ t4ure4n ☆* *«·'"`«
°o O º(,.·''(,.·'' ☆`'·.,)`'·.,)º O o°
|
|
|
|
|
Hi,
There is the requirement like this:,
One Login page is there for User Name, Password. Here the LAN user can only Login. How we will validate for a LAN user using C#.
Thanks in Advance.
|
|
|
|
|
|
If you've got a Windows only application, then don't use a login form. Set the authentication mode to Windows for your website and make sure that the application doesn't allow Anonymous Users.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Hello,
Would anybody by any chances could point me to the right direction on how to deploy a kiosk mode on Windows XP Pro SP2?
I need it for my final project but so far i haven't found out any info anywhere.
Thanks in advance,
Luis
|
|
|
|
|
Would it not be a case of making an alternative windows shell to use? Then, of course, limiting that user account so that can it do nothing on the machine.
|
|
|
|
|
Check this[^] out.
Take care,
Tom
-----------------------------------------------
Check out my blog at http://tjoe.wordpress.com
|
|
|
|
|
Thanks it helped me a lot.
Luis E Tineo S
|
|
|
|
|
You need to run in full screen mode and use global keyboard hooks to keep the user from alt tabing, etc to get at the desktop.
--
If you view money as inherently evil, I view it as my duty to assist in making you more virtuous.
|
|
|
|
|
Hello,
Would you mind how to teach me how to do Global Keyboards hooks?
This would be funny but i am working on the project while learning the language. I am reading the Book Visual C# 2005 but i haven't gotten to the delegates part yet.
Any help would be appreciate it.
Thanks
Luis E Tineo S
|
|
|
|
|
I am having a ACTBaseControl class derived from System.Windows.Forms.Textbox.
ACTMyTextBox derives ACTBaseControl(MultiLevel Inheritance).Instance of ACTMyTextbox is created in designer. But problem is when i resize control using mouse it doesnt work. Overriden method of OnResize is not triggered. But when i enter values through property grid it triggers.What could be the cause of the event not raising.
Any help please....
|
|
|
|
|
Hi,
I made a program that launched a outlook email window and puts a attached file in it:
<br />
private Outlook.Application oApp = new Outlook.Application();<br />
<br />
Outlook.MAPIFolder outBoxfolder = oApp.GetNamespace("MAPI").GetDefaultFolder(Microsoft.Office.Interop.Outlook.OlDefaultFolders.olFolderOutbox);<br />
Outlook.MailItem mItem = (Outlook.MailItem)outBoxfolder.Items.Add(Outlook.OlItemType.olMailItem);<br />
<br />
mItem.Attachments.Add("D:\\test.jpg", Type.Missing, Type.Missing, Type.Missing);<br />
<br />
mItem.To = "";<br />
mItem.BCC = "";<br />
mItem.CC = "";<br />
mItem.Subject = "";<br />
mItem.BodyFormat = Outlook.OlBodyFormat.olFormatHTML;<br />
mItem.HTMLBody = "<img src='test.jpg'>";<br />
mItem.Display(new object());<br />
As you can see i want to display the attached file(image) in my mail, but, it doesn't work. The image is attached and you can see it in the attachments and dubbelclick it so it shows. But you cannot see it in de the body of the mail. The reason is because the imagelink "" in the HTMLBody isn't right, but what is right???
How do i make the link so it shows the image that is located in the attachment on my HTMLBody?
please help me???
greetz Willem
-- modified at 10:24 Wednesday 17th October, 2007
|
|
|
|
|
In the meantime, i found out that i have to supply my attachment with a EntryId(that wat its called in VBA) but in c# my attachment doesn't have this value(so mItem.Attachments[0].EntryId). How can i set my EntryId in C#?
|
|
|
|
|
Hi
I am developing 4 tier architecture in dotnet 2.0.
Presentation Layer is hosted on different machine. Business Layer is hosted on different machine and DAL is also hosted on different machine and database server is also different i.e. all applications parts are hosted on different machines. Now Presentation layer and Business layer communicate through Web Service. What is the suitable way of communication between DAL and BLL.
Business Layer and DAL machines have window XP Operation Systems.
1. Remoting
2. Web Service
3. Any other
Please suggests all the options.
Sarvesh Upadhyay
|
|
|
|
|
In this case I suggest remoting. Because will be more faster and then you only will have a bottleneck(WS). If you use WS it will be slower.
Visit my blog at http://dotnetforeveryone.blogspot.com/
|
|
|
|
|
Language is not english so i could not understand content of this articl http://dotnetforeveryone.blogspot.com/
Sarvesh Upadhyay
|
|
|
|
|
I want to realize the following:
During one loop, a status form window is displayed, it is closed when the loop is done. but I want to stop the loop before the loop finishes. I have one button on the status form to be clicked to stop. Then I use Application.DoEvents() inside the loop to realize above funciton (according to Martin's suggestion). but I found I have to click the form window first, or else the button on this form does not response. I have tried Activate() and Focus(), neither does work.
Anyone can give me one hint for that?
thanks!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
