C# Discussion Boards - CodeProject

Re: Reflection ... Call Method. Parameter question

occcy13-Jun-05 4:07

13-Jun-05 4:07

<br />
System.Reflection.MethodInfo mi = this.oSender.GetType().GetMethod("btnGetInfo_Click", ???);<br />

the overload list for GetMethod provides several possible parameterlists.
if there is only one method btnGetInfo_Click inside your form, you can call GetMethod only with your methodname. otherwise you have to pass the types of your parameters:

<br />
System.Reflection.MethodInfo mi = this.oSender.GetType().GetMethod("btnGetInfo_Click");<br />

<br />
System.Reflection.MethodInfo mi = this.oSender.GetType().GetMethod("btnGetInfo_Click", new Type[]{typeof(object),typeof(EventArgs)});<br />

<br />
mi.Invoke(oSender, System.Reflection.BindingFlags.InvokeMethod, null, null???, null);<br />

the forth parameter needs an array of parameters for "sender" and "e".

<br />
mi.Invoke(oSender, System.Reflection.BindingFlags.InvokeMethod, null, new object[]{null,null}, null);<br />

Re: Reflection ... Call Method. Parameter question

Seraphin13-Jun-05 4:45

Seraphin

13-Jun-05 4:45

thx

Syntax error (missing operator) when deleting with commandbuilder

Hawkmoth13-Jun-05 2:28

Hawkmoth

13-Jun-05 2:28

Hi I hope someone can help

I am creating a C# project that stores data into an Access database.

I have created a dataset using an OleDbDataAdapter with a sql select statment
"SELECT table.* FROM table

This table has a long Interger autonumbering ID key field, 1 text field, 1
Long Interger field, and 31 Double fields.

I then use the Commandbuilder object to create the Insert, delete and update
commands.

The Insert command seems to work ok as I can create a new row and use the
OleDbDataAdapter.update( ); with now problems

My problem is that I get Syntax error (missing operator) when I attempt to
update a record set after deleting a row.

After this I introduced a dataGrid control and connected this to the dataset
and all the data seems to be ok.

I have other tables in my project that a treated in a similar mannor and
these seem to delete rows ok. The only thing is that these other tables have
less fields but thats the only differance that I can see.

Any ideas?
--
All the best
Hawkmoth

All the best
Hawkmoth

Re: Syntax error (missing operator) when deleting with commandbuilder

Nick Parker13-Jun-05 2:56

Nick Parker

13-Jun-05 2:56

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?

- Nick Parker
Microsoft MVP - Visual C#
My Blog | My Articles

Re: Syntax error (missing operator) when deleting with commandbuilder

Hawkmoth13-Jun-05 4:17

Hawkmoth

13-Jun-05 4:17

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

Implementing a nonvisual control

Jack Bond13-Jun-05 2:00

Jack Bond

13-Jun-05 2:00

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.

Re: Implementing a nonvisual control

mav.northwind13-Jun-05 2:29

mav.northwind

13-Jun-05 2:29

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

Custom Browser

arun_appu13-Jun-05 1:28

arun_appu

13-Jun-05 1:28

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

Re: Custom Browser

MoustafaS13-Jun-05 4:16

MoustafaS

13-Jun-05 4:16

arun_appu wrote:
windows application

Create folder and Add user with proper rights.

Anonymous12-Jun-05 23:51

Anonymous

12-Jun-05 23:51

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.

Anonymous12-Jun-05 23:15

Anonymous

12-Jun-05 23:15

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

A Visual Assist like program?

Khoa Bui12-Jun-05 23:11

Khoa Bui

12-Jun-05 23:11

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!

help...help..help

computer_eng12-Jun-05 22:00

computer_eng

12-Jun-05 22:00

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

Pixel Color Detector

Expert Coming12-Jun-05 21:17

Expert Coming

12-Jun-05 21:17

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?

C# shutdown event

mabad12-Jun-05 20:46

mabad

12-Jun-05 20:46

I need to run a cleanup routine before system shutdown. How can I catch the system shutdown event in my C# application?

Martin

Re: C# shutdown event

the last free name12-Jun-05 21:43

the last free name

12-Jun-05 21:43

Look at the SystemEvents class.

Re: C# shutdown event

mabad12-Jun-05 23:38

mabad

12-Jun-05 23:38

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! Smile | :)

MS Office development - Outlook

cazzz12-Jun-05 20:22

cazzz

12-Jun-05 20:22

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.

Problem with a checkedlistbox control

monica2k12-Jun-05 19:56

monica2k

12-Jun-05 19:56

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

Re: Problem with a checkedlistbox control

Yulianto.12-Jun-05 21:46

Yulianto.

12-Jun-05 21:46

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 Smile | :)

<italic>Work hard, Work effectively.

Re: Problem with a checkedlistbox control

monica2k13-Jun-05 12:34

monica2k

13-Jun-05 12:34

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

Re: Problem with a checkedlistbox control

Yulianto.13-Jun-05 16:18

Yulianto.

13-Jun-05 16:18

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. Smile | :)

<italic>Work hard, Work effectively.

Re: Problem with a checkedlistbox control

monica2k14-Jun-05 12:52

monica2k

14-Jun-05 12:52

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

Assembly Loading

Mr. Naveed Butt12-Jun-05 18:51

Mr. Naveed Butt

12-Jun-05 18:51

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

Re: Assembly Loading

NassosReyzidis14-Jun-05 1:19

NassosReyzidis

14-Jun-05 1:19

Hi man,
try this:
Assembly exeAssembly = Assembly.LoadFile(OpenFileDialog1.FileName);
Hope that Helps.

GanDad

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.