C# Discussion Boards - CodeProject

Re: Cell click coordinates

Chazzysb16-Jul-09 1:04

Chazzysb

16-Jul-09 1:04

Found the answer:

it was the CellMouseClick event e.X and e.Y...

Erase a windows event log

Md. Marufuzzaman16-Jul-09 0:15

Md. Marufuzzaman

16-Jul-09 0:15

Hi,
How to erase a windows event log file programmatically.
Any idea..
Thanks

Md. Marufuzzaman

Re: Erase a windows event log

Pete O'Hanlon16-Jul-09 0:28

Pete O'Hanlon

16-Jul-09 0:28

Assuming you have the relevant permisions, you can use EventLog.Delete to delete a particular log. Here's how I figured it out (who knows, this thought process may help you):

First of all, I thought to myself - this is an operation on the EventLog. Now, I know that there is an EventLog class, but if I hadn't known this the name would have seemed a logical place to start.
Then I thought - perhaps it has a DeleteLog entry.
I typed EventLog.DeleteLog into Google, and it suggested that it should actually be EventLog.Delete.
From there, I hopped over to the docs just to check that it was the item I thought it was - job done.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

Re: Erase a windows event log

Luc Pattyn16-Jul-09 1:27

Luc Pattyn

16-Jul-09 1:27

You should buy a lottery ticket today Laugh | :laugh:

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

sorting problem in outlook

john563216-Jul-09 0:11

john5632

16-Jul-09 0:11

Hi,
Whenever I tried to sort the mail item, it does not effect.

Microsoft.Office.Interop.Outlook.MAPIFolder mItem = TraverseTee(outlook.Session.Folders, "myfolder");

			if(mItem!=null)
			{
				mItem.Items.Sort("Received", false);
				int i=0;
				foreach(Microsoft.Office.Interop.Outlook.MailItem item in mItem.Items)
				{
					listBox1.Items.Insert(i,item.Subject);
					i++;
				}
			}

C# How to HttpWebRequest through chain/cascade of proxy servers

lermi15-Jul-09 23:55

lermi

15-Jul-09 23:55

Hello,

I can't seem to find a solution that would allow me to connect through a chain of proxies using HttpWebRequest object. HttpWebRequest class does have a Proxy property but it only allows you to assign a single Proxy hop and this works as expected. What I need though is to create a connection throgh 3 proxy servers and I would like to know if this is possible with HttpWebRequest. If not I would like to know if there is any other way of doing this in .NET 3.5, maybe an open source library, or an example, anything that would help. If even this does not exist I would like to know if there are any open source 3rd party tools that would allow me to do this.

Thank you for your answers in advance

Yours sincerely,
Andrea

how to drag and drop values from one datagrid to another datagrid?

swetha_insoft15-Jul-09 23:41

swetha_insoft

15-Jul-09 23:41

My application having two datagrids-->datagrid1 and datagrid2
datagrid1 is having ID,FileName,Comments columns
datagrid2 is having FileName column.
i wantt to drag and drop value from datagrid1 to datagrid2.
can anyone help me

Re: how to drag and drop values from one datagrid to another datagrid?

swetha_insoft16-Jul-09 0:14

swetha_insoft

16-Jul-09 0:14

private void datagrid2_DragEnter(object sender, DragEventArgs e)
{

if (e.Data.GetDataPresent(typeof(DataGridViewRow)))
{
e.Effect = DragDropEffects.Copy;
}
}
private void datagrid2_DragDrop(object sender, DragEventArgs e)
{
DataGridViewRow row = e.Data.GetData(typeof(DataGridViewRow)) as DataGridViewRow;
if (row != null)
{
DataGridViewRow newrow = row.Clone() as DataGridViewRow;
//for (int i = 0; i < newrow.Cells.Count; i++)
//{
newrow.Cells[0].Value = row.Cells[1].Value;
//}
//this.datagrid2.Rows.Add(newrow);
datagrid2.Rows.Add(newrow);
}
}
private void datagrid1_MouseMove(object sender, MouseEventArgs e)
{
if (e.Button == MouseButtons.Left)
{

this.gvDocuments.datagrid1(this.gvDocuments.CurrentRow,
DragDropEffects.All);
}

}

compression of webcam images [modified]

shekhar25839515-Jul-09 23:08

shekhar258395

15-Jul-09 23:08

i having a smartcard of 4kb but i have only 800 bytes
hw can i compress webcam image into less then 1 kb
nd store it to smart card
becoze this card having some fields like name address etc. nd the fingure prints
but we need to store a image to webcam nd store it in smart card anyone can help me?????????
i must hav to store it i have only 800 byte free in smart card

modified on Thursday, July 16, 2009 5:25 AM

Re: compression of webcam images

Manas Bhardwaj15-Jul-09 23:16

Manas Bhardwaj

15-Jul-09 23:16

shekhar258395 wrote:
hw can i compress webcam image into less then 1 kb

Dont you think, 1 KB for a any image file is too ambitious. D'Oh! | :doh:

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Re: compression of webcam images

Christian Graus16-Jul-09 1:30

Christian Graus

16-Jul-09 1:30

You've asked this before. The answer is, make the image REALLY small, and store it in a compressed format. greyscale jpeg is probably a good choice.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

ServicePointManager.ServerCertificateValidationCallback

himuskanhere15-Jul-09 21:36

himuskanhere

15-Jul-09 21:36

Dear Friends,

I stuck at a point, to download a file from HTTPS site.

I have a secured web site https/www.mySite.com/.
I havent any idea which Certificate that server is using.
I just want to down load a file from that site.

For that I have written the code:

    private static bool ValidateRemoteCertificate(<br />
         object sender,<br />
         X509Certificate certificate,<br />
         X509Chain chain,<br />
         SslPolicyErrors policyErrors<br />
     )<br />
        {<br />
                   <br />
            if (policyErrors == SslPolicyErrors.None)<br />
               return true;<br />
            else<br />
               return false;<br />
<br />
<br />
));<br />
<br />
     //       // Do not allow this client to communicate with unauthenticated servers.<br />
     //       return false;<br />
     //   }<br />

but it always shows the error "System.Net.Security.SslPolicyErrors.RemoteCertificateNameMismatch"

and if i forcefully return true it works fine...
what is proper solution??????

thnaks in advance

Re: ServicePointManager.ServerCertificateValidationCallback

jo H20-Jul-09 4:47

jo H

20-Jul-09 4:47

If you are happy to disable the checking of the certificate (not recommended) then use something like

                    ServicePointManager.ServerCertificateValidationCallback = new RemoteCertificateValidationCallback(
delegate
 {
   return true;
 });

If you are using a WebClient for instance, it should go just before you do the call that will connect (i.e. client.UploadFile(), client.UploadValues(), etc)

Record Not Insert

mjawadkhatri15-Jul-09 21:31

mjawadkhatri

15-Jul-09 21:31

Hi please check my coding and guide me why record not insert
my coding is

OdbcConnection cn;
OdbcCommand cmd;
OdbcDataReader odr;
string MyString;

MyString = "Select empid , sysdte from timemgmt";

if (radioin.Checked == true)
{

cn = new OdbcConnection("Driver={Microsoft ODBC for Oracle};Server=orcl8i;UID=itehad;PWD=creative;");

cmd = new OdbcCommand(MyString, cn);
cn.Open();
cmd.CommandText = "Select empid , sysdte from timemgmt where empid = '"+textBox1.Text+"' and sysdte ='"+label19.Text+"'";
//MessageBox.Show("Connected");
//cmd.CommandText = "select empid,sysdteinsert into timemgmt values('" + textBox1.Text + "','" + label19.Text + "','" + label18.Text + "','" + label18.Text + "')";//,'" + label18.Text + "','" + label18.Text + "')";
//MessageBox.Show(cmd.CommandText);
//cmd.ExecuteNonQuery();
odr = cmd.ExecuteReader();
while (odr.Read())
{
if (textBox1.Text == (odr["empid"].ToString()) && label19.Text == (odr["sysdte"]).ToString())
{
MessageBox.Show("You Already IN this ID Today");
}
else
{
cmd.CommandText = "insert into timemgmt values('" + textBox1.Text + "','" + label19.Text + "','" + label18.Text + "','" + label18.Text + "')";
}
}

cn.Close();

Re: Record Not Insert

Mycroft Holmes15-Jul-09 22:06

Mycroft Holmes

15-Jul-09 22:06

It would be helpful if you posted the error generated!

This assumes there are only 4 field in the table.

cmd.CommandText = "insert into timemgmt values('" + textBox1.Text + "','" + label19.Text + "','" + label18.Text + "','" + label18.Text + "')";

If there are more you need

cmd.CommandText = "insert into timemgmt (field1, field2, field3, field4) values('" + textBox1.Text + "','" + label19.Text + "','" + label18.Text + "','" + label18.Text + "')";

Never underestimate the power of human stupidity
RAH

Re: Record Not Insert

mjawadkhatri15-Jul-09 22:21

mjawadkhatri

15-Jul-09 22:21

I give feild name like this

cmd.CommandText = "insert into timemgmt values(empid,sysdte,intime,outtime)('" + textBox1.Text + "','" + label19.Text + "','" + label18.Text + "','" + label18.Text + "')";

no record Insert Frown | :(

And no error show
please guyz help me

Re: Record Not Insert

K030615-Jul-09 23:01

K0306

15-Jul-09 23:01

There is a error in insert statement

try this

cmd.CommandText = "insert into timemgmt(empid,sysdte,intime,outtime) values ('" + textBox1.Text + "','" + label19.Text + "','" + label18.Text + "','" + label18.Text + "')";

Regards,
Karthik K...

Re: Record Not Insert

mjawadkhatri15-Jul-09 23:21

mjawadkhatri

15-Jul-09 23:21

No my problem is not solve Frown | :(

ok tell me how i search record in oracle database if record find record not save else save record

i code this for search record

cmd.CommandText = "Select empid , sysdte from timemgmt where empid = '"+textBox1.Text+"' and sysdte ='"+label19.Text+"'";

then i create condition like this

while (odr.Read())
{
if (textBox1.Text == (odr["empid"].ToString()) && label19.Text == (odr["sysdte"]).ToString())
{
MessageBox.Show("You Already IN this ID Today");
}
else
{
cmd.CommandText = "insert into timemgmt values(empid, sysdte, intime, outtime)('" + textBox1.Text + "','" + label19.Text + "','" + label18.Text + "','" + label18.Text + "')";
cmd.ExecuteNonQuery();
}

Re: Record Not Insert

K030615-Jul-09 23:33

K0306

15-Jul-09 23:33

mjawadkhatri wrote:
cmd.CommandText = "Select empid ,sysdte from timemgmt where empid = '" + textBox1.Text + "' and sysdte ='" + label19.Text + "'";

your search query is ok.

After that use like this way,

if(odr.read())
{
 MessageBox.Show("You Already IN this ID Today");
}
else
{
 cmd.CommandText = "insert into timemgmt empid, sysdte, intime, outtime) values('" + textBox1.Text + "','" + label19.Text + "','" + label18.Text + "','" + label18.Text + "')";
cmd.ExecuteNonQuery();
}

Try the above code.Use the Breakpoints and try to rectify where the error comes.

Regards,
Karthik K...

Re: Record Not Insert

Tom Deketelaere15-Jul-09 23:22

Tom Deketelaere

15-Jul-09 23:22

I already told you to use the 'code block' tags when posting code

(see here[^] )

I also already told you to use parameters (to prevent sql-injunctions). Not only are they safer they will also prevent a lot of errors.

Re: Record Not Insert

Pete O'Hanlon15-Jul-09 23:30

Pete O'Hanlon

15-Jul-09 23:30

Where to start?

Give your variables meaningful names. At a glance, what does textBox1 do?
Your code is wide open to a SQL Injection attack. You need to look into using parameterised queries here.
Your insert statement does nothing. You create the command text and then close the connection - you need to execute the command using cmd.ExecuteNonQuery();
You have no exception handling. What happens if you can't connect the database, for instance?

If you had bothered to debug your code, you would have found the problem out in an instant. Learning to debug is one of the most valuable lessons you can master as a developer, and you should learn how to do it before too much longer.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

Accessing Serial Port Remotely

Liya Kebede15-Jul-09 21:16

Liya Kebede

15-Jul-09 21:16

Hello Everyone,

I wrote an application which send and receive data from a pinpad(device with RS-232 which use serial port) and i start testing the application, when i finised testing the application on my computer, I upload it to the server machine to do another test but when I run the application from client computers it does not recognize the pin pad, but when I run the application from my computer it works properly. My question is that is there any way I can access the pin pad remotely?

Thanks

Re: Accessing Serial Port Remotely

Garth J Lancaster16-Jul-09 0:38

Garth J Lancaster

16-Jul-09 0:38

Liya Kebede wrote:
is there any way I can access the pin pad remotely?

I dont think so : I think you need to implement a tcp/ip network layer to sit between the serial port and the network and send it commands from your application.

We do this with eftpos devices - they are sent instructions from a centralised gateway via tcp/ip, and the client on the pc interfaces to the com port (via an activex control supplied by the eftpos company) .. (ok, so there's an activex control there, but it doesnt really matter that much)

There are commercial companies out there that offer pre-made toolkits to do this - just a quick search gives :-

http://www.serial-port-communication.com/serial-over-tcpip/[^]

http://www.fabulatech.com/network-serial-port-kit.html[^]

oh .. a thought comes to mind, maybe citrix can do it, but thats a different paradigm

'g'

Re: Accessing Serial Port Remotely

monstale16-Jul-09 0:52

monstale

16-Jul-09 0:52

Hi,

when you start the application on your computer, it doesn't matter where the exe-file is located, the code runs on your computer with it's local hardware!
When you need to communicate with a remote serial port, you need to run on the remote computer an application, e.g. windows service, and communication with that application (e.g. Sockets)

Kind regards

Re: Accessing Serial Port Remotely

Liya Kebede16-Jul-09 2:07

Liya Kebede

16-Jul-09 2:07

Hi,

Does it help if i use socket programming?

Thanks Again

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