C# Discussion Boards - CodeProject

hi everybody,

thanks for your reply and suggestions, finally i got the solution to my problem...

my revised code:

private void button13_Click(object sender, EventArgs e)
{
try
{

for (int i = 0; i < dataGridView4.Rows.Count -1; i++)
{
DataGridViewRow row = dataGridView4.Rows[i];

long itemcode = 0;
string description = "";
int quantity = 0;
string unit = "";

itemcode = Convert.ToInt64(row.Cells[0].Value);

if (description != null)
{
description = row.Cells[1].Value.ToString() + "";
}

quantity = Convert.ToInt32(row.Cells[2].Value);
unit = row.Cells[3].Value.ToString();

String query = "INSERT INTO test(itemcode,description,quantity,unit) VALUES ("
+ " " + itemcode
+ " ,'" + description + "'"
+ " , " + quantity
+ " ,'" + unit + "'"
+ " )";

MySqlCommand command = new MySqlCommand(query, connection);
MessageBox.Show(command.ExecuteNonQuery().ToString());

}
}

thanks guys

regards Smile | :)

jing

1) Check if row.Cells[X].Value is null or DBnull before converting or ToString()ing them
2) Catch also (Exception ex) and System.Diagnostics.Debug.WriteLine("Error! Source: ", ex.Source + ", Message: " + ex.Message); to see what happened. You can also do this:

if(ex.InnerException != null)
System.Diagnostics.Debug.WriteLine(ex.InnerException.Source + ", " + ex.innerException.Message);

Hope this helps...

hi,

thanks, my program already worked out!!

regards Smile | :)

jing

Having searched through tons of Google results, I found no single code/library about how to extract RAR [^] archives inside .NET.

Anyone can give me some links?

Thanks
Uwe

--
• Zeta Producer Desktop CMS
Intuitive, completely easy-to-use CMS for Windows.

• Zeta Helpdesk
Open Source ticket software for Windows and web.

• Zeta Uploader
Easily send large files by e-mail. Windows and web client.

• Desargues
Innovative, lean and neat calculator for Windows.

Have you had a look at this link on rarlab.com/[^]

The unrar.dll is what your looking for.

Oh, great, found it! Thank you very much Smile | :)

!

Wow, great! Even comes with a C# example!

--
• Zeta Producer Desktop CMS
Intuitive, completely easy-to-use CMS for Windows.

• Zeta Helpdesk
Open Source ticket software for Windows and web.

• Zeta Uploader
Easily send large files by e-mail. Windows and web client.

• Desargues
Innovative, lean and neat calculator for Windows.

Just figured out that the FTP server of RARLabs (ftp://ftp.rarlabs.com/rar/ [^]) contains a C++ library (currently ftp://ftp.rarlabs.com/rar/unrarsrc-3.7.5.tar.gz [^] as of writing this) to extract RAR archives.

Probably one would go with wrapping this with C++/CLI as I did with Html Tidy[^].

Maybe anyone already did it? Smile | :)

--
• Zeta Producer Desktop CMS
Intuitive, completely easy-to-use CMS for Windows.

• Zeta Helpdesk
Open Source ticket software for Windows and web.

• Zeta Uploader
Easily send large files by e-mail. Windows and web client.

• Desargues
Innovative, lean and neat calculator for Windows.

I have 2 forms one startform & other form1
I have used timer 4 the dtrtform and It closes as the timer ticks
Now I want to show form1 as Startform is closed....
I have did dis in startform

private void timer1_Tick(object sender, EventArgs e)<br />
{<br />
timer1.Enabled = false;<br />
this.Close();<br />
<br />
}<br />
<br />
private void StrtForm_FormClosing(object sender, FormClosingEventArgs e)<br />
{<br />
Form1 F = new Form1();<br />
F.Show();<br />
}

Now as the Strtform closes Form1 is also closed.... ANy idea

The best way to do this is to create a hidden form to handle all this, so form1 and form2 are opened and closed by this hidden form.

About : Islam

About : Me

samreengr8 wrote:
this.Close();

U R disposing the current object through the Close method.
Thus all the memebers and memory occupied by this form will
be cleared when the Form completely gets displosed.

samreengr8 wrote:
Form1 F = new Form1();
F.Show();

Of course, this will create a new form.
As the object "F" is declared inside the closing object, it will also gets
closed.

The better way is U can have hidden form as the other poster said.

In that hidden form,
create 2 objects, F1=new Form1(),F2=new Form2();
Handle the opening and closing of Forms, from the hidden form.

Regards,
Arun Kumar.A

1) FormClosing event occures before FormClosed event.
2) You create the Second Form in your First Form's closing event where GarbageColelctor destroyes the Second Form after the First Form is closed.
3) You should do:

Form1 F = new Form1();
Application.Run(F);

Hope this helps...

Hi
I am displaying the 3 labels controls in a group box. like this

Previous Current Next
ATE-1 ATE-1 ATE-1

if the form has been resized or if the text ATE-1 is changed their alignment changed accordingly.

How can i maintain the alignment between these label controls even if the user maximiz the form or if the text changes

Hi All

I've 2 Table , table1 id_main[int], Id_detail
table2 Id_detail[int] , goods[nvarchar] and there is a relation between table1.Id_detail and table2.Id_detail
now in the form :
i use a textbox for id_main and a combobox for goods to show it

i want to use a button to move between records for e.g. next ,

in form1_load i wrote :

...<br />
SqlDataReader drSQL;<br />
string strID;<br />
string strID;<br />
 try<br />
  {<br />
    strSQL = "SELECT * FROM table1";<br />
    SqlCommand cmd = new SqlCommand(strSQL,myconnection);<br />
    myconnection.Open();<br />
    drSQL = cmSQL.ExecuteReader();<br />
     if (drSQL.Read())<br />
       {<br />
          txtIndex.Text = drSQL["id_main"].ToString();<br />
          strID = drSQL["Id_detail"].ToString();<br />
          //this is a function for getting name of goods<br />
          FindItemByID(cbxGoods, strID)<br />
       }<br />
...

in Next_click (...) event , How can navigate between record .

private void btNext_Click(object sender, EventArgs e)<br />
  {<br />
    ??<br />
  }

thanx a lot

s_mostafa_h

Use a BindingNavigator component, no need to reinvent the wheel Wink | ;)

hope this helps...

Hello everyone,

I've done a bit of searching to see what I can find, but not much is appearing. What I'm looking to do is create a small application that will remember icon positions for me (on my desktop). Yes, there are a hundred of these apps out there, but I want to go about it differently than any of the apps I've used.

So, can anyone give me any ideas or pointers to where icon position is stored, and how I can access/change it?

Thanks in advance!
-Sean

Hi,

this is a very complex matter, that involves many P/Invoke functions, and consists
of the following steps:

1. find the handle to the listview: in Windows XP the desktop is a listview; to get there,
you must descend the chain "Progman", "SHELLDLL_DefView", "SysListView32".

2. for each of the icons, send an LVM_GETITEMPOSITION or LVM_SETITEMPOSITION message.
Since the message goes to another process and requires a data pointer, that data pointer
must be valid in the other process, so you must first allocate memory in that process.
You will probably need the following prototypes:

[DllImport("kernel32.dll", CallingConvention=CallingConvention.StdCall)]
private static extern int OpenProcess(uint access, bool inheritHandle,
    uint procID);

[DllImport("kernel32.dll", CallingConvention=CallingConvention.StdCall)]
private static extern bool CloseHandle(int handle);

[DllImport("kernel32.dll", CallingConvention=CallingConvention.StdCall)]
private static extern IntPtr VirtualAllocEx(int hProcess, int address,
    int size, uint allocationType, uint protection);

[DllImport("kernel32.dll", CallingConvention=CallingConvention.StdCall)]
private static extern bool VirtualFreeEx(int hProcess, IntPtr address,
    int size, uint freeType);

[DllImport("kernel32.dll", CallingConvention=CallingConvention.StdCall)]
private static extern bool WriteProcessMemory(int hProcess,
    IntPtr otherAddress, IntPtr localAddress, int size,
    ref uint bytesWritten);

[DllImport("kernel32.dll", CallingConvention=CallingConvention.StdCall)]
private static extern bool ReadProcessMemory(int hProcess,
    IntPtr otherAddress, IntPtr localAddress, int size,
    ref uint bytesRead);

[DllImport("kernel32.dll", CallingConvention=CallingConvention.StdCall)]
private static extern bool ReadProcessMemory(int hProcess,
    IntPtr otherAddress, StringBuilder localAddress, int size,
    ref uint bytesRead);

Then there will appear one major problem: moving an icon to a position that is occupied
makes Explorer reshuffle a lot of icons; so dont expect to easily get the layout you hope.

If you succeed, please let me know !

Smile | :)

Luc Pattyn

[My Articles]

Heh, this is certainly going to be a tough one for me, but you've provided exactly what I needed, a good outline to get me started.

Thanks a bunch! I'll be sure to let you know if I succeed!

Right Click on the desktop, disable Auto Arrange under Arrange Icons by menu Wink | ;)

Hahah... yeah, I've never had auto-arrange on. Smile | :)

No, I'm looking for something a bit more dynamic than that. I'm [hopefully] building a system that will let me classify my desktop icons (whether its a shortcut, folder, or file) and group them dynamically.

But, I have a lot to learn first, so that first reply was a perfect roadmap for me. Smile | :)

My Form have a button.
When I click the button, a Toolbox is shown.
This Toolbox is always on top of My Form.

Do you know how to create ToolboxM

Thank You.

C# XP

1. A Connect internet

2. B router Connect internet and C is machine

B ip address is 58.6.3.6
C have a IP address is 192.168.1.3

A is machine direct connect internet
and B is router is connected a system.

I can send the file B to A
I could not nend the file A to B.
How can make lestion in B router.
Any body help me

Continue...

So what does this have to do with C#?

BTW, your explanation needs work. You might want to try using mmore than 58 words to describe the setup of your equipment and the problem you're having.

It took me quite a bit of reading to figure out "1. A Connect internet" meant. Is this a Windows PC? Which version? What's installed on it to do this internet sharing? What is "B"? How's it onfigured? You mentioned machine "C", but you didn't say anything about having any problems with this, so why even mention it?

Don't respond to this in the C# Forum. Use the Hardware Forum instead.

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

I think he's having trouble traversing NAT (Network Address Translation).

Computer A is directly connected to the internet
Computer B is connected through an NAT router

He wants to send a file from A to B, but can't get through the router.

This is a pretty well-explored problem, but the quick solutions are:

1) Use a reverse-connect protocol. Instead of A connecting to B to send the file, have B connect to A and request the file. As long as B creates the connection, you're golden.

2) Specifically configure the router to forward the packets (This is only viable for an in-house solution, as you can't expect random users to do this), and figure out B's external IP by looking at the incoming connection on A, instead of having B tell A its IP.

I'm assuming you're trying to PROGRAM something like this... If you're having trouble doing this in an application, then this is the wrong forum.

Dave Kreskowiak wrote:
So what does this have to do with C#?

Got me on that. I don't see anything to do with C# in the post Confused | :confused:

can someone give me a sample code on how I can execute a different application thru C#?