C# Discussion Boards - CodeProject

Igor Sokolsky27-Aug-07 8:22

27-Aug-07 8:22

Hi All,

I have created a SQLBuilder class as a wrapper to the ADO2.0 SQLite implementation.
It uses refection for automatic database insert, update, delete and select.
Here is the link.

http://www.handymandy.ca/component/option,com_remository/Itemid,62/func,select/id,12/

Usage:
[dbTable("tblComputers",false)]
public class Computer2
{
private string m_Name;
private int m_Id;
private ProcessorType m_CpuType;
private int m_MemorySize;

public Computer2()
{
//connects to default database
SqlBuilder.Instance.connect();
}
[db(false,"Name","text","",false)]
private string Name
{
get { return m_Name; }
set { m_Name = value; }
}
[db(true, "Id", "int", "", false)]
private int Id
{
get { return m_Id; }
set { m_Id = value; }
}
[db(false, "Cpu", "int", "0", false)]
private ProcessorType Cpu
{
get { return m_CpuType; }
set { m_CpuType = value; }
}
[db(false, "MemorySize", "int", "0", false)]
private int MemorySize
{
get { return m_MemorySize; }
set { m_MemorySize = value; }
}

public void Insert()
{
try
{
SqlBuilder.Instance.verifyTableExists(this);
SqlBuilder.Instance.insert(this);
}
catch (ApplicationException e)
{
}
}
public void Update()
{
try
{
SqlBuilder.Instance.update(this);
}
catch (ApplicationException e)
{
}

}
public void Delete()
{
try
{
SqlBuilder.Instance.delete(this);
}
catch (ApplicationException e)
{
}
}
public void Select()
{
try
{
SqlBuilder.Instance.select(this);
}
catch (ApplicationException e)
{
}
}

}

Expose EventHandler to VBScript [modified]

patrickcbrown27-Aug-07 5:53

patrickcbrown

27-Aug-07 5:53

Hello

Does anyone have an example of how to expose a C# EventHandler so that VBScript can hook up to it? It must be VBScript. I can call methods on this very basic class, but can't get the event hooked up. This is a Class Library and is built with the "Register for COM Interop" switch set.

<br />
    public class Talker<br />
    {<br />
        public event EventHandler SomeNeatEvent;<br />
        private System.Timers.Timer EventTicker = new System.Timers.Timer();<br />
<br />
        public Talker()<br />
        {<br />
            EventTicker.Interval = 2000;<br />
            EventTicker.AutoReset = true;<br />
            EventTicker.Enabled = false;<br />
            EventTicker.Elapsed += new System.Timers.ElapsedEventHandler(EventTicker_Elapsed);<br />
        }<br />
<br />
        void EventTicker_Elapsed(object sender, System.Timers.ElapsedEventArgs e)<br />
        {<br />
            if (SomeNeatEvent != null)<br />
            {<br />
                SomeNeatEvent(this, new EventArgs());<br />
            }<br />
        }<br />
<br />
        public void ToggleTickerEnabled()<br />
        {<br />
            EventTicker.Enabled = !EventTicker.Enabled;<br />
        }<br />
    }<br />

Thank you for your time and ideas
Patrick

-- modified at 13:20 Monday 27th August, 2007

Newbie question about "%"

...---...27-Aug-07 5:34

...---...

27-Aug-07 5:34

Hello,
If I declare the following (or something like this....)

Graphics^ g = CreateGraphics();
Pen pen = new Pen(Color::Green)
g.DrawLine(%pen, 10, 10, 20, 20);

It won't work without the "%". Is this a "tracking reference"?

So my question is what is the "%" really doing?

thanks a lot

Re: Newbie question about "%"

Michael Potter27-Aug-07 5:47

Michael Potter

27-Aug-07 5:47

This is a C++ question and this is a C# forum.

trying to create a bitmap from 8bit greyscale using System.Drawing.Bitmap

aei_totten27-Aug-07 4:58

aei_totten

27-Aug-07 4:58

DisplayBitmap = new System.Drawing.Bitmap(camera.width, camera.height, stride, System.Drawing.Imaging.PixelFormat.Indexed, camera.MonocromeFrame);

This gives me an invalid argument (System.Drawing.Imaging.PixelFormat.Indexed)

DisplayBitmap = new System.Drawing.Bitmap(camera.width, camera.height, stride, System.Drawing.Imaging.PixelFormat.Format24bppRgb, camera.MonocromeFrame);

gives me the image but it is 3 times as wide and just repeats

Re: trying to create a bitmap from 8bit greyscale using System.Drawing.Bitmap

aei_totten27-Aug-07 5:14

aei_totten

27-Aug-07 5:14

tried

<br />
<br />
                Bitmap temp = new System.Drawing.Bitmap(camera.width, camera.height, stride, System.Drawing.Imaging.PixelFormat.Format24bppRgb, camera.MonocromeFrame);<br />
<br />
                  DisplayBitmap = new Bitmap(temp.Width,temp.Height);<br />
<br />
                  for(int y=0;y<DisplayBitmap.Height;y++)<br />
<br />
                  {<br />
<br />
                    for(int x=0;x<DisplayBitmap.Width;x++)<br />
<br />
                    {<br />
<br />
                      Color c=temp.GetPixel(x,y);<br />
<br />
                      int luma = (int)(c.R*0.3 + c.G*0.59+ c.B*0.11);<br />
<br />
                      DisplayBitmap.SetPixel(x,y,Color.FromArgb(luma,luma,luma));<br />
<br />
                    }<br />
<br />
                  }

and it lagged beyond compare because it is a huge image.

The board retarded my for loops
here is a link to the code No Paste version of the code [^]

how can i shut down my LAN? any idea

nayabsiddiqi27-Aug-07 4:27

nayabsiddiqi

27-Aug-07 4:27

Wondering how to disconnect my LAN through C#... though there is a way through WMI but any alternate and better solution would be appreciated Wink | ;)

thanks

Determination and faith are the only keys !

Re: how can i shut down my LAN? any idea

Le centriste27-Aug-07 5:01

Le centriste

27-Aug-07 5:01

There is no keyword in C# or class/method in the .NET framework to directly achieve this. You may have to build your own, probably by using the System.Management [^] namespace in the framework, since there is way through WMI.

-----

If atheism is a religion, then not collecting stamps is a hobby. -- Unknown

God is the only being who, to rule, does not need to exist. -- Charles Baudelaire

Re: how can i shut down my LAN? any idea

nayabsiddiqi27-Aug-07 5:35

nayabsiddiqi

27-Aug-07 5:35

thanks for taking interest Smile | :)

The problem is, through system.management, i can only get the status of whether the Network Card is enabled or Disabled. The solution is only if the DHCP gets unleased, but thats not the right way i guess. What I want to do is to achieve the Disabling Network Card as i use to do by going in Network connection and disabling it through right click and selecting the particular option "Disable"

Any idea how to do that ?

Determination and faith are the only keys !

Re: how can i shut down my LAN? any idea

Spacix One27-Aug-07 7:06

Spacix One

27-Aug-07 7:06

There are a few ways you can do this, below is the easiest method with a WMI script converted to C#;
http://channel9.msdn.com/ShowPost.aspx?PostID=158556[^]

If you download his application (the [Save] link at the bottom of the top post) he included the source code...

Re: how can i shut down my LAN? any idea

nayabsiddiqi2-Oct-07 6:46

nayabsiddiqi

2-Oct-07 6:46

thanks for the reference Smile | :)

Determination and faith are the only keys !

FieldBuilder question

ma7moud_7elmy27-Aug-07 4:12

ma7moud_7elmy

27-Aug-07 4:12

AssemblyName _tempname = new AssemblyName();
_tempname.Name = "MyTempAssembly";

AssemblyBuilder _Assmblybuilder = AppDomain.CurrentDomain.DefineDynamicAssembly(_tempname, AssemblyBuilderAccess.RunAndSave);

ModuleBuilder _modBldr = _Assmblybuilder.DefineDynamicModule("MainMod", "MyTempAssembly.dll");

string x = "System.Windows.Forms.Button";
TypeBuilder _typeBldr = _modBldr.DefineType(x);

I want to make object of the Type inside _typeBldr ... how?

Data Transfer from .Net to VB6 application

vs2428427-Aug-07 2:38

vs24284

27-Aug-07 2:38

Hi I am using a VB6 application which has embedded Excel sheet in one of its forms.
I am developing a new Web Application in C#/ASP.net 2.0 where the requirement is to save some data in a webpage and then to show the same data (just saved in Web App) in the Excel sheet of the VB6 application.
Problem is I dont know how to refer VB6 application from .Net
Please help me ASAP.

Vinay

Re: Data Transfer from .Net to VB6 application

Leyu27-Aug-07 4:31

Leyu

27-Aug-07 4:31

If the VB 6 app reads data stored in excel format then save the data from the web form with an excel format. Then the VB6 app can show the data given the file.
If I see ur problem correctly

Re: Data Transfer from .Net to VB6 application

vs2428427-Aug-07 23:16

vs24284

27-Aug-07 23:16

I am sorry for not being clear. I will explain it once again.
I have a VB6 application which has Excel embedded in its Form. Now there is an ASP.NEt application which has a web page with a Save button.
When the user enters data on the Web Page and hits on Save button, 2 Actions has to happen.
1) The data will be saved in Oracle DB
2) The same data needs to be loaded in the Excel present in the VB application.

Action (1) is easy with no problems
Action (2) is my problem as I am not getting the reference of the VB application from C# (2.0)

Please let me know if there is some way to do it.

Vinay

Re: Data Transfer from .Net to VB6 application

Justin Perez27-Aug-07 4:44

Justin Perez

27-Aug-07 4:44

I am unsure if I understand what you are trying to do. You have a VB6 application which holds the excel stuff. Are you trying to save the data from your ASP application, and then send a message to the VB6 app to read the file after it has been saved? Or are you just saving it, and then letting the user load the data whenever?

I get all the news I need from the weather report - Paul Simon (from "The Only Living Boy in New York")

Re: Data Transfer from .Net to VB6 application

vs2428427-Aug-07 23:16

vs24284

27-Aug-07 23:16

start external app, but in a sync way

blackjack215027-Aug-07 2:05

blackjack2150

27-Aug-07 2:05

Hi.

How do you start synchronously an external application?

My program must suspend execution and wait for the external app to close itself and only then resume execution.

Thanks.

Re: start external app, but in a sync way

Justin Perez27-Aug-07 2:13

Justin Perez

27-Aug-07 2:13

Take a look at the Process class.

I get all the news I need from the weather report - Paul Simon (from "The Only Living Boy in New York")

Re: start external app, but in a sync way

blackjack215027-Aug-07 2:19

blackjack2150

27-Aug-07 2:19

Yes, I know how to start it using the Process class.

But by default, that starts the external application asynchronously, which is not what I want.

Re: start external app, but in a sync way

Martin#27-Aug-07 2:32

Martin#

27-Aug-07 2:32

Hello,

Have you had a look at the "WaitForExit()" method of the process class?
Or do you mean something completely different?

All the best,

Martin

Re: start external app, but in a sync way

Justin Perez27-Aug-07 2:39

Justin Perez

27-Aug-07 2:39

blackjack2150 wrote:
But by default, that starts the external application asynchronously, which is not what I want.

As Martin# stated below, I was thinking you could WaitForExit() from the Process class. I didn't notice you wanted to run the process synchronously, despite being in bold Smile | :)

I am unsure if the process can be ran synchronously.

I get all the news I need from the weather report - Paul Simon (from "The Only Living Boy in New York")

Re: start external app, but in a sync way

Spacix One28-Aug-07 10:19

Spacix One

28-Aug-07 10:19

http://blogs.msdn.com/csharpfaq/archive/2004/06/01/146375.aspx[^]

Explains all you need with examples.

inserting data into a label

lourensG27-Aug-07 1:10

lourensG

27-Aug-07 1:10

this question is for C#. I dont know how to put a value into a label my select statement works because Ive tried it on a listbox heres the code

select sum() from table where id = id

then: label.text = ?;

I tried dataset.tables[0].rows

but Im not to shure about that please help me.

Re: inserting data into a label

Christian Graus27-Aug-07 1:34

Christian Graus

27-Aug-07 1:34

dataset.tables[0].rows[0], I reckon.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

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