Re: File Operations - C# Discussion Boards

v.k.s2-Dec-05 17:07

v.k.s

2-Dec-05 17:07

how to declare a connection string in web.config and use it from there in our Web form

-- modified at 23:11 Friday 2nd December, 2005

Re: connection string in web.config file

enjoycrack2-Dec-05 20:36

enjoycrack

2-Dec-05 20:36

Hi there,

The connection string depends on what kind of DB you are using.
the great site will give you all kind of Db Connection String

<< >>

Re: connection string in web.config file

MudkiSekhon3-Dec-05 1:36

MudkiSekhon

3-Dec-05 1:36

<configuration>

<appSettings>
<add key="ConnectionString" value="connectionstring(depends on database)"/>
</appSettings>

<system.web>

Then u can use it as:

string connectionstring = System.Configuration.ConfigurationSettings.AppSettigs["ConnectionString"];

Regards,
Sandeep
+919891027854

MenuStrip ShortcutKeys

khan20002-Dec-05 16:48

khan2000

2-Dec-05 16:48

Is there a way to set a single key as a MenuStrip item shortcut? When I try to set the ShortcutKeys value to 'P' (in the properties editor), I get an invalid property message.

-- K

SysListView32 Events

Click^ok2-Dec-05 15:19

Click^ok

2-Dec-05 15:19

Hello

I know not if I can post this here, because is C# + Interop, but I find not some sub forum about this.

I wish handle events of some SysListView32 object, But I know not if this is possible. I have the handle this object via FindWindowEx (like the spy++).

I have some samples using timers and checking the properties of the SysListView32, but I think timers a few odd, if we can use events and delegates.

I apreciate any help

Thanks

Debug ARX in Autocad2006

GazzaGarray2-Dec-05 12:45

GazzaGarray

2-Dec-05 12:45

When I press F5 for debugging the Autodesk logo flashes and then goes away - with no error messages. Autocad2006 will not load from within Visual Studio 2003. I can manually run Autocad2006, use netload run the code but I cannot debug.

I have set up a project using the
New AutoCAD Managed CS Project Application wizard and the text in Lab1. The properties debugging are as per instructions and agree with the wizard.

Does having both Autocad2006 and CivIl3D cause a problem?

Gazza

File Operations

dvsr2-Dec-05 11:50

dvsr

2-Dec-05 11:50

Hi I am having a code for 2 functions one is to Extract the file from a zip file. Another one is to read the Extracted file n parse it.

While Execution the application I am getting an exception The File(Extracted file) being used by some other application and its exiting by showing the line number "StreamReader sr = File.OpenText(FILE_NAME);".
But If I am debugging the application ..the results r perfectly fine.

Can Any one please explain this.

I am attaching the functions here

public static void ExtractZIPFile()
{

sbyte[] buf = new sbyte[1024];
int len;

java.io.FileInputStream fis = new java.io.FileInputStream(@"C:\TEMP\POWER_PRODUCTS.ZIP");
java.util.zip.ZipInputStream zis = new java.util.zip.ZipInputStream(fis);
java.util.zip.ZipEntry ze;
ze = zis.getNextEntry();

java.io.FileOutputStream fos = new java.io.FileOutputStream(FILE_NAME);
while ((len = zis.read(buf)) >= 0)
{
fos.write(buf, 0, len);
}
zis.close();
fis.close();
FileProcessing();
}

public static void FileProcessing()
{
if (!File.Exists(FILE_NAME))
{
Console.WriteLine("{0} does not exist.", FILE_NAME);
return;
}
CreatePPTable();
StreamReader sr = File.OpenText(FILE_NAME);

String input="";
while ((input= sr.ReadLine())!=null)
{
String []strs = input.Split(';');

#region Add a row
DataRow drNew = dsPProducts.Tables[0].NewRow
drNew["PASS2_AVAIL_CD"] = strs[1];
...
drNew["PASS2_AVAIL_CD"] = strs[122];
dsPProducts.Tables[0].Rows.Add(drNew);
#endregion end of adding a row
Console.WriteLine(input);
}
sr.Close();
File.Delete(FILE_NAME);
}

Re: File Operations

S. Senthil Kumar2-Dec-05 23:23

S. Senthil Kumar

2-Dec-05 23:23

Looks like you forgot to close fos in the following snippet.

dvsr wrote:
java.io.FileOutputStream fos = new java.io.FileOutputStream(FILE_NAME);
while ((len = zis.read(buf)) >= 0)
{
fos.write(buf, 0, len);
}

When debugging, the GC must have run and closed it for you. That would explain the debug/release behavior.

Regards
Senthil
_____________________________
My Blog | My Articles | WinMacro

Re: File Operations

dvsr5-Dec-05 3:46

dvsr

5-Dec-05 3:46

Hi Sinthil,
Thanks for ur Help....

Once again its proved How dumb i am..

Thank you once again.
Subbu

Associating values to a combo box

Caio19852-Dec-05 10:23

Caio1985

2-Dec-05 10:23

Hi everybody.

I'm developing a program which has a combobox with all client names but as client name is not the primary key, or better: unique, on the database, some itens on the combo box are repeated, so this way there is more than one person with the same name.
In order to solve that I'd like to know if it is possible to associate another value (preferable an unique ID which would be loaded from the database) for each item on the combo box, but in a way that the program user would see only the name on the combo, not this unique ID, which would be used by the program.

If my explanation was not clear:
- I'd like to have this user view on the combo box:

John Wallace
Marck Keen
Isaac May
John Wallace

The way it is right now (no associated values) I can't do a query that would retrieve me only one row, because using "select * from table where name = ' + combo.SelectedItem.toString() + "'"; it would retrieve me 2 rows if, for example, I select John Wallace which has 2 occurences on the same combo.

So, behind the scenes, I'd like to retrieve the unique id from the selected item. So the program would have that:

John Wallace 344072407
Marck Keen 40947047
Isaac May 483609
John Wallace 20648

Thus, I can make a different selection based on the name, like:
"select * from table where uniqueID = ' + combo.SelectedItem."somethingThatWouldRetrieveMeTheUniqueID" + "'";

Thank you !

Re: Associating values to a combo box

Robert Rohde2-Dec-05 12:11

Robert Rohde

2-Dec-05 12:11

You could create a class like:

public class ComboEntry {
public string Name;
public int Id;
public override string ToString() {
return Name;
}
}

and put instances of it into the ComboBox. The ComboBox will call the ToString method to determine what text should be shown and when you access the SelectedItem property you can just cast back to ComboEntry and get the Id.

Re: Associating values to a combo box

Caio19852-Dec-05 15:23

Caio1985

2-Dec-05 15:23

It worked the way I wished.

Thank you.

Re: Associating values to a combo box

Kallol Roy2-Dec-05 19:40

Kallol Roy

2-Dec-05 19:40

Set the DataSource of the Combo Box
and set display member as name
and set value member as id.

now u can get the id by --

int i=combobox.SelectedValue;

Question about TextBox control

Stanciu Vlad2-Dec-05 10:12

Stanciu Vlad

2-Dec-05 10:12

Is there possible to make a text box control skip interpreting certain keys without inheriting the class?

protected internal static readonly ... and I wish the list could continue ...

Re: Question about TextBox control

Jared Parsons2-Dec-05 11:36

Jared Parsons

2-Dec-05 11:36

Excluing native interop I don't think that there is a way.

Are you unable or just don't want to inherit from the TextBox? If you're unable, can you give us some more information on your situation?

Jared Parsons
jaredp@beanseed.org
http://spaces.msn.com/members/jaredp/

Re: Question about TextBox control

Stanciu Vlad3-Dec-05 2:28

Stanciu Vlad

3-Dec-05 2:28

The ideea is to make a class that recives\intercept key messages from a TextBox, process them and if necesary block the respective key from being processed by the TextBox.
The ideea of inheriting is not so great because this class should work with all kind of other control (richTextBox, comboBox, etc...)

Thank you!

protected internal static readonly ... and I wish the list could continue ...

Re: Question about TextBox control

Rob Philpott2-Dec-05 11:53

Rob Philpott

2-Dec-05 11:53

Yeah - subscribe to the KeyPress event. This event passes a KeyPressEventArgs which has a boolean Handled field. Setting this to true stops the message being passed on to the text box handler, so you can do your processing in this event.

Regards,
Rob Philpott.

Re: Question about TextBox control

Stanciu Vlad3-Dec-05 2:25

Stanciu Vlad

3-Dec-05 2:25

Thanks for your answer, but I allready know this. The problem is that in a TextBox if you press for exemple the VK_LEFT the cursor moves to left if is a character there.
I want to intercept this type of key before processing and decide if it mut be processed or not. (KeyPress event work's only for char key's if I am not mistaking)

protected internal static readonly ... and I wish the list could continue ...

Re: Question about TextBox control

Rob Philpott3-Dec-05 3:29

Rob Philpott

3-Dec-05 3:29

Ah, ok.

Well, you can intercept virtual keys using the KeyDown event which is fired prior to the KeyPress event.

eg. To disable the left cursor key:

<br />
private void textBox1_KeyDown(object sender, KeyEventArgs e)<br />
{<br />
    if (e.KeyCode == Keys.Left)<br />
    {<br />
        e.Handled = true;<br />
    }<br />
}<br />

You may still need to worry about mouse selection depending upon what you are doing...

Regards,
Rob Philpott.

Threading problem

mav.northwind2-Dec-05 9:50

mav.northwind

2-Dec-05 9:50

Hi all!

I got a Windows Forms application where an event is fired from a secondary thread. When this event is fired, I call

this.BeginInvoke(new MethodInvoker(someMenuItem.PerformClick));

to simulate a menu item click.
This works fine, but when the event handler for someMenuItem pops up a modal dialog, this dialog appears more than once if the event re-fires before the first dialog is closed. Frown | :(

So I tried encapsulating someMenuItem's event handler code inside a lock(this) {} and now only a single modal dialog is shown at most.
So far, so good.
But if the event re-fires now, all these events are suspended as long as the lock() statement is active and executed in row afterwards.
Is there a way to change the behaviour so that the events are discarded instead of being stored?

Thanks in advance for any ideas,
mav

Re: Threading problem

Jared Parsons2-Dec-05 11:37

Jared Parsons

2-Dec-05 11:37

BeginInvoke() is Asynchronous. You should switch to using Invoke() and that will solve your problem.

Jared Parsons
jaredp@beanseed.org
http://spaces.msn.com/members/jaredp/

Re: Threading problem

mav.northwind2-Dec-05 12:03

mav.northwind

2-Dec-05 12:03

Jared, thanks for your comment!
Of course, you're right. That way I can block the second thread until the first call to the event handler is finished.
The dialog can still pop up twice in a row (when I click the menu item in the main app and afterwards the other thread fires the event), but I think I'll use this approach nevertheless.

Or do you have any further suggestions on how to really discard every other call?

Thanks,
mav

Re: Threading problem

S. Senthil Kumar2-Dec-05 21:13

S. Senthil Kumar

2-Dec-05 21:13

The only way I can think of is having a volatile bool variable that is set before Invoke and is reset after it. That way, you can simply return if the flag is set.

class XYZ
{
   volatile bool isMessageBoxVisible = false;
void Func()
{
    lock(this)
    {
       if (isMessageBoxVisible) return;
       isMessageBoxVisible = true;
    }
    this.Invoke(...);
    lock(this) { isMessageBoxVisible = false; }
}

Regards
Senthil
_____________________________
My Blog | My Articles | WinMacro

Re: Threading problem

mav.northwind2-Dec-05 21:52

mav.northwind

2-Dec-05 21:52

Thanks!

That could be a way, but then it gets quite messy, because I allow the user to configure which menu item or toolbar button is pressed when a certain button on the external input device is clicked.
So I'd have to create a variable for each and every menu item/toolbar button... Sniff | :^)

I was looking for a behaviour like what you get when you use the mouse to click a menu item/tbb. A modal dialog can pop up, but then the UI of the main window is not accessable any more and thus the same menu item/tbb can't be pushed more than once. And the additional clicks aren't queued but discarded.
Something like

if (mainForm.IsIdle)
   this.Invoke(...

But just as I write this I got another idea:
I usually set the form's Cursor to Cursors.WaitCursor at the beginning of my menu/toolbar event handlers and reset it to Default in a finally block.
This information can be used to decide whether the main form is busy (executing an event handler) or not. I think I'll try it like this:

if (mainForm.Cursor == Cursors.Default)
  this.Invoke(...

Thank you all for your help!

mav

Crystal Report ParameterFields

Bedevian2-Dec-05 9:28

Bedevian

2-Dec-05 9:28

i wrote a sales report, which works fine with my application if i include start date and end date in the database, {gndsale.dob} in {date.startdate} to {date.enddate}.

but if i change the report to pass Parameter Fields, {gndsale.dob} in {?Start Date} to {?End Date}
when i load the report first time it's okay i can see the correct parameters on the Page header and in Details, but if i load report 2nd time with different parameters , the page header is updated but the details not, some how i need to refresh crystalReportViewer1 after i pass parameters. ???

check this code

ReportDocument1.Load(RptPath.ToString());
crystalReportViewer1.RefreshReport();
crystalReportViewer1.ReportSource = reportDocument1;
paramFields = new ParameterFields ();
ParameterField crParamFld = new ParameterField();
ParameterDiscreteValue CrparamValue = new ParameterDiscreteValue();
paramFields = crystalReportViewer1.ParameterFieldInfo;
crParamFld = paramFields[0];
CrparamValue.Value = PassDT_Start;
crParamFld.CurrentValues.Add(CrparamValue);
ParameterField crParamFld_2 = new ParameterField();
ParameterDiscreteValue CrparamValue_2 = new ParameterDiscreteValue();
crParamFld_2 = paramFields[1];
CrparamValue_2.Value = PassDT_End;
crParamFld_2.CurrentValues.Add(CrparamValue_2);
crystalReportViewer1.ParameterFieldInfo = paramFields;
crystalReportViewer1.ReportSource = reportDocument1;

Or this code

reportDocument1.SetParameterValue("Start Date",PassDT_Start );
reportDocument1.SetParameterValue("End Date",PassDT_End );
crystalReportViewer1.RefreshReport();
crystalReportViewer1.ReportSource = reportDocument1;

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