Re: Progammatically pressing underscore,$,% etc keys - C# Discussion Boards

Pass Dataset table to a stored procedure as a parameter

Litani3-Oct-08 8:46

3-Oct-08 8:46

I have a program that allows the user to multi-select categories. The control is bound to a dataset table. When the user clicks the get data button, I have to pass the selected categories to a SQL Server stored procedure and limit products to the select categories.

The data is in a table in memory. I know I can loop through the rows of the data table and create some sort of a list and pass it as a varchar(max) parameter to the Store Procedure and parse it. Is there a more efficient method? A method that does not involve looping.

Re: Pass Dataset table to a stored procedure as a parameter

nelsonpaixao3-Oct-08 14:20

nelsonpaixao

3-Oct-08 14:20

you are doing a your way thing i don´t imagine what it is.

i think you are using 1 varchar(max) column instead of 8 whatever columns.
you put all string in that varchar(max) and use "," to separate strings, isn´t thats right?!? so you need to loop to get them after.

i don´t use that, i add more columns and leave some empty if required, but you can do that don´t know if runs faster!

i heard of that in sql forum keep that way it´s ok to me. D'Oh! | :doh:

nelsonpaixao@yahoo.com.br

trying to help & get help

Progammatically pressing underscore,$,% etc keys

Sandeep Kalra3-Oct-08 7:43

Sandeep Kalra

3-Oct-08 7:43

************Programming Challenge**********************

Hi All

Again I have spent more than five hours but still fighting.

I just want to type underscore in my windows textbox.I am able to type characters, Hit enter key etc etc but do not yet found how to print underscore and other special characters like @,$,%,^

I have tried following code .Discovered new things but still trying to find the solution

SendKeys.SendWait(Keys.Decimal.ToString());
SendKeys.SendWait(Keys.S.ToString());
SendKeys.SendWait(Keys.A.ToString());
SendKeys.SendWait(Keys.N.ToString());
SendKeys.SendWait(Keys.D.ToString());
SendKeys.SendWait(Keys.E.ToString());
SendKeys.SendWait(Keys.Oem1.ToString());
SendKeys.SendWait(Keys.Oem102.ToString());
SendKeys.SendWait(Keys.Oem2.ToString());
SendKeys.SendWait(Keys.Oem3.ToString());
SendKeys.SendWait(Keys.Oem4.ToString());
SendKeys.SendWait(Keys.Oem5.ToString());
SendKeys.SendWait(Keys.Oem6.ToString()); // with this type of code getting Oem6 in
// textbox but i wanted 6.
SendKeys.SendWait(Keys.Oem7.ToString());
SendKeys.SendWait(Keys.Oem8.ToString());
SendKeys.SendWait(Keys.OemClear.ToString());
SendKeys.SendWait(Keys.OemBackslash.ToString());
SendKeys.SendWait(Keys.OemCloseBrackets.ToString());
SendKeys.SendWait(Keys.Oemcomma.ToString());
SendKeys.SendWait(Keys.OemMinus.ToString());
SendKeys.SendWait(Keys.OemOpenBrackets.ToString());
//with this code getting OemOpenBrackets in textbox but desired was (.

SendKeys.SendWait(Keys.OemPeriod.ToString());
SendKeys.SendWait(Keys.OemPipe.ToString());
SendKeys.SendWait(Keys.Oemplus.ToString());
SendKeys.SendWait(Keys.OemQuestion.ToString());
SendKeys.SendWait(Keys.OemQuotes.ToString());
SendKeys.SendWait(Keys.OemSemicolon.ToString());
SendKeys.SendWait(Keys.Oemtilde.ToString());

SendKeys.SendWait("{OemSemicolon}"); //givin error
SendKeys.SendWait(Keys.KeyCode== 106); //giving error

SendKeys.SendWait(Keys.E.ToString());
SendKeys.SendWait(Keys.P.ToString());
SendKeys.SendWait(Keys.U.ToString());
SendKeys.SendWait(Keys.K.ToString());
SendKeys.SendWait(Keys.A.ToString()); //working fine
SendKeys.SendWait(Keys.L.ToString());
SendKeys.SendWait(Keys.R.ToString());
SendKeys.SendWait(Keys.A.ToString());
SendKeys.SendWait(Keys.NumPad5.ToString()); //
//with this type of code getting NumPad5 in textbox desired was 5

SendKeys.SendWait(Keys.NumPad4.ToString());
SendKeys.SendWait("{Enter}"); //working fine

Any studymaterial ,sample application or anything related to this will help.I am also trying to find .

Thanks in advance

THE SK
I am the ONE

Re: Progammatically pressing underscore,$,% etc keys

Sandeep Kalra3-Oct-08 8:08

Sandeep Kalra

3-Oct-08 8:08

Hi All

Finally got it on below link

http://msdn.microsoft.com/en-us/library/8c6yea83(VS.85).aspx

The correct way is

SendKeys.SendWait("{+}"); //for typing plus
SendKeys.SendWait("{_}"); //for typing underscore

For this spent more than five hours ... great

THE SK
I am the ONE

Re: Progammatically pressing underscore,$,% etc keys

led mike3-Oct-08 8:49

led mike

3-Oct-08 8:49

Sandeep Kalra wrote:
I just want to type underscore in my windows textbox.

Try using Fire_Fox. See it works I just_did_it. Oh wow, I did it again _ and again! Only took me like 5_seconds!

led mike

Re: Progammatically pressing underscore,$,% etc keys

Sandeep Kalra3-Oct-08 9:01

Sandeep Kalra

3-Oct-08 9:01

Hey led mike

U have used Fire_Fox.I think u should use Fire_Lion now.It will take 50 years to you Laugh | :laugh:

Re: Progammatically pressing underscore,$,% etc keys

Jason Lepack (LeppyR64)3-Oct-08 9:02

Jason Lepack (LeppyR64)

3-Oct-08 9:02

Programattically... Using C#...

Re: Progammatically pressing underscore,$,% etc keys

PIEBALDconsult3-Oct-08 10:32

PIEBALDconsult

3-Oct-08 10:32

You can't just append the character to the text? Confused | :confused:

The process cannot access the file because it is being used by another process

Alan Balkany3-Oct-08 6:51

Alan Balkany

3-Oct-08 6:51

Hi all,

I'm testing an application by writing bitmaps to a temporary file. I thought it would be neat to have an application that monitors this file and updates its picture whenever the file changes.

I use FileInfo to get the last write time, and if it's changed, I make a new Bitmap with the file's contents and display it. The file is never opened. Sounds simple.

The problem is the system thinks the file is in use, and won't let me overwrite it. It says: "The process cannot access the file because it is being used by another process." But I never open the file, and just use it temporarily to get the last write time and make a bitmap.

How can I make Windows realize the file isn't being used in between samples?

Here's the relevant code:

public void monitorFile()
 {
     while (!Form1.done)
     {
         fi = new FileInfo(fname);
         DateTime dt = fi.LastWriteTime;

         if (lastWrite < dt)
         {
             lastWrite = dt;
             parent.showBitmap (new Bitmap(fname));
         }

         fi = null;
         Thread.Sleep(3000);
     }
 }

Thanks!
Alan

Re: The process cannot access the file because it is being used by another process

Pedram Behroozi3-Oct-08 6:59

Pedram Behroozi

3-Oct-08 6:59

Alan Balkany wrote:
The process cannot access the file because it is being used by another process.

Maybe this "another process" is you! Always make sure you closed all opened files in your project.

While (true) { Human.isLearnable = true; }

Re: The process cannot access the file because it is being used by another process

Alan Balkany3-Oct-08 7:01

Alan Balkany

3-Oct-08 7:01

But the file is never explicitly opened. It's hard to close a file that was never opened.

Re: The process cannot access the file because it is being used by another process

Pedram Behroozi3-Oct-08 7:13

Pedram Behroozi

3-Oct-08 7:13

Maybe you have some problem with Vs and/or Windows or even vise versa!

While (true) { Human.isLearnable = true; }

Re: The process cannot access the file because it is being used by another process

Pedram Behroozi3-Oct-08 7:22

Pedram Behroozi

3-Oct-08 7:22

Hey, you didn't close your file!

<blockquote class="FQ"><div class="FQA">Alan Balkany wrote:</div>public void monitorFile()
{
   while (!Form1.done)
   {
      fi = new FileInfo(fname);
      DateTime dt = fi.LastWriteTime;

      if (lastWrite < dt)
      {
         lastWrite = dt;
         parent.showBitmap (new Bitmap(fname));
      }
      fi = null;
      Thread.Sleep(3000);
   }   
}</blockquote>

Add fi.Close(); before fi = null;

While (true) { Human.isLearnable = true; }

Re: The process cannot access the file because it is being used by another process

Mark Salsbery3-Oct-08 7:36

Mark Salsbery

3-Oct-08 7:36

Your Bitmap object keeps the file open.

Try disposing the Bitmap object after you're done working with it.

Mark

Mark Salsbery
Microsoft MVP - Visual C++
Java | [Coffee]

Re: The process cannot access the file because it is being used by another process

Alan Balkany3-Oct-08 7:52

Alan Balkany

3-Oct-08 7:52

Yes! You solved it! I just copied the bitmap to a new one and disposed the old one, and it worked! Thanks Mark!

Re: The process cannot access the file because it is being used by another process

Pedram Behroozi3-Oct-08 9:27

Pedram Behroozi

3-Oct-08 9:27

Oh, you're right. My mistake! Thanks Mark Smile | :)

While (true) { Human.isLearnable = true; }

Add Project References at runtime

AngusOAP3-Oct-08 5:16

AngusOAP

3-Oct-08 5:16

I have a C# application which creates Excel Workbooks. To date I have added reference to the Excel version installed on my machine. I now need to do something which will read the Excel version installed on a user's machine and call the appropriate library.

Does anybody know how to do this? Many thanks

Angus

Re: Add Project References at runtime

dan!sh 3-Oct-08 5:26

dan!sh

3-Oct-08 5:26

Use Type.GetTypeFromProgID and Activator.CreateInstance to instantiate the object. Then you can use Reflection for further operations.

"If you had to identify, in one word, the reason why the human race has not achieved, and never will achieve, its full potential, that word would be 'meetings'." - Dave Barry

Re: Add Project References at runtime

led mike3-Oct-08 5:46

led mike

3-Oct-08 5:46

AngusOAP wrote:
I now need to do something which will read the Excel version installed on a user's machine and call the appropriate library.

Loading an assembly at runtime is not the same thing as adding a reference to a project.

If you are using the Primary Interop Assembly there is no guarantee that the users machine has it installed. You might be needing to study the Microsoft information[^] about using the Primary Interop Assemblies.

led mike

Re: Add Project References at runtime

AngusOAP4-Oct-08 2:13

AngusOAP

4-Oct-08 2:13

Thanks, but having read the Microsoft information I fear I may be debarred - it says that I have to have Microsoft Visual Studio .NET for developers, whereas all I have is the miserablt C# Express Edition (2005 version plus Service Pack 1, at that). Do you know if it is it worth trying with that?

Thanks again.

Angus

Re: Add Project References at runtime

led mike6-Oct-08 4:48

led mike

6-Oct-08 4:48

AngusOAP wrote:
Do you know if it is it worth trying with that?

I've never used Express Edition. However the PIA's are just assemblies so I would guess there should be no problem.

led mike

Re: Add Project References at runtime

Paul Conrad3-Oct-08 6:35

Paul Conrad

3-Oct-08 6:35

Like led mike said, read up from Microsoft on how to work with the PIA.

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham

Communicating with user controls

KabirPatel3-Oct-08 4:38

KabirPatel

3-Oct-08 4:38

Hi,

I have a windows form that contains 2 buttons - a "Next" button and a "Prev" button.

When the form loads, a user control is loaded into the form. After the user presses the "Next" button, the user control is replaced by another user control. If the user presses the "Prev" button they move back to the prevous control. The process continues like this until 5 different user controls are loaded. i.e. I have implemented Wizard like functionaility.

This all works fine.

My problem is that the "Next" and "Prev" buttons are always enabled. I would only like the "Next" button to be enabled if the user has completed working on the User Control that they are currently on.

In other words, once a user has completed the minimum requirements of the control they are in, the "Next" button should become enabled.

An example of this would be a user control with a first name field. When the user fills in this field the "Next" button should be enabled.

Is it possible for the user control to bubble up this information back to its parent form, so that the button is enabled at the proper time?

Thanks,
Kabir

Re: Communicating with user controls

Pedram Behroozi3-Oct-08 5:00

Pedram Behroozi

3-Oct-08 5:00

Hi Kabir
You can use a public bool variable (true/false) in your UC. When user fills a valid text, your flag goes true, else false. And your form can use your flag to complete your task.

While (true) { Human.isLearnable = true; }

Re: Communicating with user controls

nelsonpaixao3-Oct-08 13:13

nelsonpaixao

3-Oct-08 13:13

if you are using delegates i don´t see how you didn´t achieve that after what you already coded?! D'Oh! | :doh:

parent form? you meen main_form and only form right? because you load usercontrols in main_form? i don´t see where is the change Dead | X|

nelsonpaixao@yahoo.com.br

trying to help & get help

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