|
Hawkmoth wrote:
My problem is that I get Syntax error (missing operator) when I attempt to
update a record set after deleting a row.
What does your SQL statement look like when you run the update statement? Have you tried to run the update statement within Query Analyzer?
|
|
|
|
|
Hi Nick
Thanks for your help.
The select statment below is from the adaptor right before the updating.
The Delete command is generated from the CommandBuilder.
I will take a look at the analyser. (Not something I've ever used before!!).
SELECT Spex.* FROM Spex
DELETE FROM Spex WHERE ( (spex_id = ?) AND ((? = 1 AND Std_Name IS NULL) OR (Std_Name = ?)) AND ((? = 1 AND ID IS NULL) OR (ID = ?)) AND ((? = 1 AND 400nm IS NULL) OR (400nm = ?)) AND ((? = 1 AND 410nm IS NULL) OR (410nm = ?)) AND ((? = 1 AND 420nm IS NULL) OR (420nm = ?)) AND ((? = 1 AND 430nm IS NULL) OR (430nm = ?)) AND ((? = 1 AND 440nm IS NULL) OR (440nm = ?)) AND ((? = 1 AND 450nm IS NULL) OR (450nm = ?)) AND ((? = 1 AND 460nm IS NULL) OR (460nm = ?)) AND ((? = 1 AND 470nm IS NULL) OR (470nm = ?)) AND ((? = 1 AND 480nm IS NULL) OR (480nm = ?)) AND ((? = 1 AND 490nm IS NULL) OR (490nm = ?)) AND ((? = 1 AND 500nm IS NULL) OR (500nm = ?)) AND ((? = 1 AND 510nm IS NULL) OR (510nm = ?)) AND ((? = 1 AND 520nm IS NULL) OR (520nm = ?)) AND ((? = 1 AND 530nm IS NULL) OR (530nm = ?)) AND ((? = 1 AND 540nm IS NULL) OR (540nm = ?)) AND ((? = 1 AND 550nm IS NULL) OR (550nm = ?)) AND ((? = 1 AND 560nm IS NULL) OR (560nm = ?)) AND ((? = 1 AND 570nm IS NULL) OR (570nm = ?)) AND ((? = 1 AND 580nm IS NULL) OR (580nm = ?)) AND ((? = 1 AND 590nm IS NULL) OR (590nm = ?)) AND ((? = 1 AND 600nm IS NULL) OR (600nm = ?)) AND ((? = 1 AND 610nm IS NULL) OR (610nm = ?)) AND ((? = 1 AND 620nm IS NULL) OR (620nm = ?)) AND ((? = 1 AND 630nm IS NULL) OR (630nm = ?)) AND ((? = 1 AND 640nm IS NULL) OR (640nm = ?)) AND ((? = 1 AND 650nm IS NULL) OR (650nm = ?)) AND ((? = 1 AND 660nm IS NULL) OR (660nm = ?)) AND ((? = 1 AND 670nm IS NULL) OR (670nm = ?)) AND ((? = 1 AND 680nm IS NULL) OR (680nm = ?)) AND ((? = 1 AND 690nm IS NULL) OR (690nm = ?)) AND ((? = 1 AND 700nm IS NULL) OR (700nm = ?)) )
All the best
Hawkmoth
|
|
|
|
|
I've been looking all over for a code sample of a nonvisual control, and searched through MSDN with no luck so far. Does anyone have some sample code or a link to a good article on how to implement a nonvisual control(I think they previously were called invisible-at-runtime.) For those who don't know what I'm talking about, I need the same design time behavoir as the OpenFileDialog where when you drag it onto a form, it gets placed below the form in the designer, and is never seen by the user. Thanks in advance for the help.
|
|
|
|
|
You can simply derive your class from Component. That way you get designer support but don't have a control shown at runtime.
Regards,
mav
|
|
|
|
|
How can i Create a Custom Browser with Internet Browsing facility.it must also have the options for Blocking some websites.
for the above requirement which type of application(a windows application or an ASP.net application)must i use.
i want to do the whole thing in C#.net
|
|
|
|
|
arun_appu wrote:
windows application
|
|
|
|
|
Hello Friends,
I want to create a "Temp" folder at my IIS web server with proper rights, so that any user can upload some files to that folder.
But I don't want to do this manually, I want a pieace of code so that this activity can be done. I tried for :
System.DirectoryServices namespace
but still facing proble for specifing path name in :
De.Path = @"IIS://localhost/W3SVC1/1/ROOT/WebDashboard/temp";
will anybody help me out for this issue?
Thanks in advance.
|
|
|
|
|
Hi Friends I am Fecing Problem for getting Sum of group field.
Explaination:
I have Group field, and in which i am getting recod by using some formula.Like this
------------------------------------------------------------------------------------------------
Room name |Jan05|Feb05|Mar05|...........upto |Dec05| Room name is group field
------------------------------------------------------------------------------------------------
Room1 |12.09|23.09|45.98|.................
------>these values calculated by formula
Room2 |34.00|34.00|90.00|.................
------------------------------------------------------------------------------------------------
Average | ? | ? | ? |
------------------------------------------------------------------------------------------------
When i am going for avg of Jan 05. i would not find these fields for grand total or summary
because its told that it would be calculate at run time.
then i have used this one
WhilePrintingRecords;
NumberVar GrandInvTotal;
numberVar array Input={@RoomOccupancyForMonth1}; --->(RoomOccupancyForMonth1) this field is related to calculate value by using formula
but it only print last record
so please any one find solution help me.
vikram
|
|
|
|
|
I want to help myself improving the code writing process. So I write an application like Visual Assist.
At first, my target is a small module that support suggesting the local variable in a method: when I type "local." all local variable declared for that method appear, so I can select one.
But I don't know how to get reference to the code pade *.cs to get all local variables and catch the event when I typing on that page.
Can anyone help me?
thanks!
|
|
|
|
|
hallo.. i need fast help please iam computer eng student
i design antivirus porgram as graduted project but the problem that i face i need database or small database about each virus includeing ..his signature ... his location ...and any help information that help me to clean the virus
thaaaaaaaaaaaaaaaaaaaaaaaaank you
|
|
|
|
|
I need to know if there is a way to grab the color of a specific pixel on the screen in C#, if there is, how?
|
|
|
|
|
I need to run a cleanup routine before system shutdown. How can I catch the system shutdown event in my C# application?
Martin
|
|
|
|
|
Look at the SystemEvents class.
|
|
|
|
|
I found another way to do it.
protected override void WndProc(ref System.Windows.Forms.Message m)
{
// defined in winuser.h
const int WM_QUERYENDSESSION = 0x0011;
switch(m.Msg)
{
case WM_QUERYENDSESSION:
//////////////////
// cleanup section
//
//////////////////
base.WndProc(ref m);
break;
default:
base.WndProc(ref m);
break;
}
}
Thank you "the last free name" for your suggestion!
|
|
|
|
|
Hi all,
For a while I want to do something with MS Outlook (2003). I have this 'great' idea of adding data from objects which are connected to the email. An example;
If I was writing a email message to John Doe and I wanted to display his working location. Normally I would have to go into his contact details and look it up. This whole process could be done faster. By making a system like the code insight in MS Visual Studio ( you know; when you press 'sys' and a dropdownbox already displays system). People would type something like [recpient].worklocation and when the email is send, my tool replaces the [recpient].workLocation with John Doe's real work location.
Now for my problem. Since I'm new to Office programming I just started reading almost everything on it. I know about the six Outlook API's and the Office addin system. But still I cant get to the email typing part. I know a 'dirty' way with hooks but that’s my last resort. I want to design this clean. So how do I make a Office Add-in which monitors the typed text in MS outlook? And how can I modify the emailed text before sending?
Well that’s it, I hope someone can help me. I would really like to know more about Office development so any hints/tips/urls are welcome.
|
|
|
|
|
I have a checkedlistbox control which i am pupulating from a table.I am saving the value as a string in which all the values selected are concatenated and stored into sa sting feild in database. Saving is no problem. But i want that stored values should be automatically selected on form load but it is'nt doing this.No Error nothing but the values previously seleted are not selected now.
I am posting my both functions
public static string SetValueFromListBoxes(CheckedListBox lst)
{
string strCheckedValues;
strCheckedValues="";
string strStringCheckedValues="";
for(int i=0;i
|
|
|
|
|
Have you check the value of checked list box in the database? I think, you can easily find the solution if you debug it. Good luck
<italic>Work hard, Work effectively.
|
|
|
|
|
i Could'nt get u. say i have four values a,b,c,d in the table which i am populating in the list. Now if a,b is checked i am saving that as a string containing a,b. now when i need to retrive i am looping through the listbox entries and if that is matching the value from the database i am setting that value in listbox at that index to be checked. but its not checking the value and also giving no error.
thanks
|
|
|
|
|
I know the situation. You can find out the solution by your self first by debugging. Tracing each variables, eventually you will find the problem. You know how to debug, right? Let me know if you haven't figured it out.
<italic>Work hard, Work effectively.
|
|
|
|
|
There is np porpblem at all from tha database side . all the values are perfectly matching and all values selected are selected.I ahve figured out the problem .its sonething with the load event of form the value does not appear selected but if i load the form first and then load the value from database everything is fine.its many be something with the repaint of listbox. i donot know
|
|
|
|
|
Hello
I am trying to open an assembly file by using fileopenDialogBox and unable to do so... Can anyone help me in this regard... Infact I am trying to open Dll's from GAC probably that is the problem... Plz help me...
Thanx
|
|
|
|
|
Hi man,
try this:
Assembly exeAssembly = Assembly.LoadFile(OpenFileDialog1.FileName);
Hope that Helps.
GanDad
|
|
|
|
|
I have a class I declared as static.
It works fine. It simply inserts a record into the database.
Firts I specify the catabase type(Access or SQL) from an enumeration and populates a coonection string.
But I would the form or web page to automatically populate the connection string.
The text for the connectionstring is in a web.config or appname.exe.config file and always has the same name "connectionstring".
Any ideas?
Nick
I'm not an expert yet, but I play one at work. Yeah and here too.
|
|
|
|
|
How about adding a type constructor and populating the connection string there? Something like
class MyForm : Form
{
static MyForm()
{
}
}
Regards
Senthil
_____________________________
My Blog | My Articles | WinMacro
|
|
|
|
|
i'm trying a treefolder and i've got some probleme retrieving from which drive comes a treenode.fullpath.
lets say i've got a node like this
-my computer - drive C - folder 1a - folder2
- folder 1b
- drive D - folder 4c - folder 3
when i get a fullpath i've got
my computer\drive C\folder 1a\folder2
so i get only the "\folder 1a\folder2" part
then i dont know how to determine that drive C is "C:\"
i thought of getting the index of drive C and map it in the getlogicaldrive list
but how do i get the drive C index when i'm in folder2 node ?!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
