C# Discussion Boards - CodeProject

aquahawk3-Nov-04 11:36

3-Nov-04 11:36

what i want to do is read some information from a text file straight into an access database
but i cant find any examples can anyone help with
some code or a site with that information
thx

Re: file reading and access database

HahnTech3-Nov-04 12:09

HahnTech

3-Nov-04 12:09

I'm not sure but access should be able to use the ADO lib's. IF so its jsut a matter of using the ADO conection to insert a string into the Db.
this.SQLConn.ConnectionString = "data source=" + DS + "; initial catalog=Cat"; integrated security=true; persist security info=False; workstation id=" + WorkID + "; packet size=4096";
SQLConn.Open();
if(SQLConn.State == ConnectionState.Open)
{
//insert data
}

As far as reading a file use streamreader http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemiostreamreaderclassctortopic2.asp[^]

Ronald Hahn, CNT - Computer Engineering Technologist

New Technologies Analyst

HahnTech Affiliated With Code Constructors
Edmonton, Alberta, Canada
Email: rhahn82@telus.net

input string not in a correct format

webhay3-Nov-04 9:24

webhay

3-Nov-04 9:24

hi all,

i progarmming a forms that insert data from form to database table and i never do any require field in database or in code but i alwayes have exception "input string not in a correct format" untill i fill all the field required and not required

pleae help

haytham

Re: input string not in a correct format

Jordi Corominas3-Nov-04 10:54

Jordi Corominas

3-Nov-04 10:54

Ara you sure that your sql sentence is well created? It must be a problem in your code, once creating the sql string. I think is not a problem with the DB and the required fields.

Why don't you put a pice of your code (where you create the sql sentence), with this information will be difficult to help you (almost for me Smile | :)

).

Bye!

"Catalonia is not Spain"

Re: input string not in a correct format

Dave Kreskowiak3-Nov-04 11:48

Dave Kreskowiak

3-Nov-04 11:48

I'll bet money your using string concantenation to build your SQL statement, aren't you?

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: input string not in a correct format

webhay3-Nov-04 12:01

webhay

3-Nov-04 12:01

Hello

Thanks for your reply ...

i am not understand what you mean please make it simply and plz give me example

thanks

Re: input string not in a correct format

Dave Kreskowiak3-Nov-04 17:08

Dave Kreskowiak

3-Nov-04 17:08

It means you're adding strings together to build an SQL statement. Something like this:

string mySqlStatement = "SELECT * FROM someTable WHERE parm1=" + parm1.ToString() + " AND parm2='" + parm2TextBox.Text + "'"

Don't EVER do this. Use parameterized queries instead.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: input string not in a correct format

Jordi Corominas3-Nov-04 21:35

Jordi Corominas

3-Nov-04 21:35

I do always use like this and always works! D'Oh! | :doh:

Why you don't suggest him to do it?

Bye!

"Catalonia is not Spain"

Re: input string not in a correct format

Dave Kreskowiak4-Nov-04 0:57

Dave Kreskowiak

4-Nov-04 0:57

Sure it works, but it's SO vulnerable it's almost funny! Consider the following code:

// Put together the SQL Statement:
//  SELECT COUNT(*) FROM Users WHERE username=? AND userpass=?
//
string mySQLStatement = "select count(*) from users where userName='" + userName.Text + "' and userPass='" + userPassword.Text + "'"

Now, if the attack enters:

Username: ' OR 1=1 --
Password: anything

The SQL Statement becomes:

SELECT COUNT(*) FROM Users WHERE username='' OR 1=1 --' AND userpass='anything'

Well, in SQL syntax, two consecutive dashes in a row (--) is a comment, just like // is C++ or C# is a comment or ' in VB. So you real SQL statement now looks like:

SELECT COUNT(*) FROM Users WHERE username='' OR 1=1

The result form the SQL statement will always be the number of records in the table, never 0.

Search the web for "SQL Injection Attacks" to find out more and see lots of example of how to break cheap code like this.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: input string not in a correct format

Jordi Corominas4-Nov-04 1:16

Jordi Corominas

4-Nov-04 1:16

Very interesting... I didn't know anything about it. And wich is the correct solution?
I'm developing a Windows Forms applications (not ASP.NET application). The SQL Injection Attacks can be done to my application or is only a problem of webs?

Bye!

"Catalonia is not Spain"

registry key editing/creation

Pyro Joe3-Nov-04 9:11

Pyro Joe

3-Nov-04 9:11

I've looked 'round and haven't found much of anything helpful on the subject. how do I create a key in the registry with a certain value?
in my case,
key: GroupPolicyRefreshTime
value: 00000001
it will be located in: HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Group Policy Objects\LocalUser\Software\Policies\Microsoft\Windows\System

I'm sure it isn't hard, I just don't know how to code it exactly. Thank you so much for the help. Plus, I really don't have time to be reading an entire article.

Re: registry key editing/creation

Alex Korchemniy3-Nov-04 9:18

Alex Korchemniy

3-Nov-04 9:18

pyrojoe wrote: Plus, I really don't have time to be reading an entire article.

WTF | :WTF:

That is very very sad... I guess I'll just send you to a few articles Roll eyes | :rolleyes:

:

MSDN documentation[^]
http://www.thecodeproject.com/csharp/dotnet_registry.asp[^]

This posting is provided "AS IS" with no warranties, and confers no rights.

Alex Korchemniy

Re: registry key editing/creation

Salil Khedkar3-Nov-04 21:59

Salil Khedkar

3-Nov-04 21:59

Go here[^] And scroll down to Trick 6: Windows Registry and you

That's it. It will take 5 minutes to copy-paste and start working. Wink | ;)

Salil Khedkar [^]

Re: ListView KeyDown Event

cnet20083-Nov-04 16:09

cnet2008

3-Nov-04 16:09

you should judge the keycode

you are welcome to visit my blog

System.Drawing.Printing.PrinterSettings

Hugo Migneron3-Nov-04 6:31

Hugo Migneron

3-Nov-04 6:31

Hello,
I have a problem using the PrinterSettings property. I am trying to get what the user enters in the PrintDialog...

<br />
private void mnuPrint_Click(object sender, System.EventArgs e)<br />
{<br />
      System.Drawing.Printing.PrinterSettings settings = new PrinterSettings();      <br />
      printDoc.DefaultPageSettings = pgSettings;<br />
      dlgPrint.Document = printDoc;<br />
      if (dlgPrint.ShowDialog() == DialogResult.OK)<br />
      {<br />
            settings = dlgPrint.PrinterSettings;             <br />
            printDoc.Print();<br />
      }<br />
}<br />

Then, when i try to read the values in settings it don't get what the user entered. For example, if i put:
short a = settings.Copies;
a will equal 1, even if i entered 5 copies in the PrintDialog. If anyone can tell me how to get the PrinterSettings the user entered. It would be greatly appreciated.

Thanks

Re: System.Drawing.Printing.PrinterSettings

sreejith ss nair3-Nov-04 17:23

sreejith ss nair

3-Nov-04 17:23

System.Drawing.Printing.PrinterSettings pr=new System.Drawing.Printing.PrinterSettings();<br />
PrintDialog dia=new PrintDialog();<br />
dia.PrinterSettings=pr;<br />
short a=0;<br />
if(dia.ShowDialog()==DialogResult.OK)<br />
{<br />
	a=pr.Copies;<br />
}<br />
			MessageBox.Show(a.ToString());

Sreejith Nair
[ My Articles ]

Re: System.Drawing.Printing.PrinterSettings

Hugo Migneron4-Nov-04 3:32

Hugo Migneron

4-Nov-04 3:32

Hi there,
Thank you for your reply. Unfortunatly, it still doesn't work.
I found what the problem was, after spending a lot of time searching about this silly problem, i found this :
http://support.microsoft.com/kb/331134[^]

So, i guess that this is my problem (I am on Framework 1.0)

Anyways, thanks for your help! Smile | :)

Hugo

Flash Form Title Bar

Member 8730573-Nov-04 5:05

Member 873057

3-Nov-04 5:05

I created a form without title bar named frmNoTitle. I set up the form properties like:
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None;
this.ControlBox = false;
this.MaximizeBox = false;
this.MinimizeBox = false;

In the main MDI form, I have a menu to open thisfrmNoTitle form. I add following code in the menu's click event:
frmNoTitle frm=new frmNoTitle ();
frm.MdiParent=this;
frm.Show();

This works fine except that I noticed the frmNoTitle form's title bar(min,max,clos buttons) flashes for a very very short time, then diappear
I looks like that the program displayed the form title bar first, then make it invisible.
How I can get rid of it?

TIA

Flash GUI article???

eshipman3-Nov-04 4:46

eshipman

3-Nov-04 4:46

I seem to remember an article on creating a GUI with Flash and C#.
Anyone have the URL or author for that article as I can no longer find it.

Icons in Task bar

sommarafton3-Nov-04 4:29

sommarafton

3-Nov-04 4:29

Hello everybody,

I have developed a Windows Desktop application in Visual C# .Net using Window forms and I am using a context menue and a notify icon to launch the application in the task bar.

The application consists of different Window Forms, so that I am switching between different forms the whole time. Unfortunatly, each time when I close one of the windows (Window Forms), a new notify icon appears in the task bar, and they only disappear after I have closed the whole application. I am using the Close() method to close any forms.

Does anybody have an idea why that happens and how I can avoid it?

Thank you very much!

Re: Icons in Task bar

Alex Korchemniy3-Nov-04 8:14

Alex Korchemniy

3-Nov-04 8:14

When closing the Form you have to manually hide the icon. I've ran into this small bug before.

Anyways... I think it would be better to associate the icon with one form instead of destroying and recreating it every time. Just hide the form. Of course considerations for resource usage.

This posting is provided "AS IS" with no warranties, and confers no rights.

Alex Korchemniy

Detect "Minimize" and "Autostart"

Stefan Troschuetz3-Nov-04 3:25

Stefan Troschuetz

3-Nov-04 3:25

Hi CPs!

I'm currently writing my first application that uses a NotifyIcon and everything works fine except the following two things.

1. I want to hide the NotifyIcon as long as the main form of my application isn't minimized. But I'm not sure how to detect the "Minimize event" as their is no such event or I'm to stupid to find it. So I thought about catching the Resize event of my form and querying the WindowState property there. Would this work or is there a better way?

2. I want to hide the main form of my application and only display the NotifyIcon if my application was started by Windows Autostart, whereas the main form should by shown if the user "normally" starts the application. Is their any way to detect this?

THX in advance

www.troschuetz.de

Re: Detect "Minimize" and "Autostart"

Nick Parker3-Nov-04 4:40

Nick Parker

3-Nov-04 4:40

Stefan Troschütz wrote:
But I'm not sure how to detect the "Minimize event" as their is no such event or I'm to stupid to find it.

Here is a simple way to check to see if your application is being Minimized. What you are going to do is simply override the WndProc and check for a few message values:

int WM_SYSCOMMAND =  0x0112;
int SC_MINIMIZE = 0xF020;
protected override void WndProc(ref Message m)
{
    if(m.Msg == WM_SYSCOMMAND)
    {
        if(((int)m.WParam & 0xFFF0) == SC_MINIMIZE)
        {
            MessageBox.Show("I'm being minimized");

        }
    }
    base.WndProc(ref m);
}

- Nick Parker
My Blog | My Articles

Re: Detect "Minimize" and "Autostart"

Stefan Troschuetz3-Nov-04 4:49

Stefan Troschuetz

3-Nov-04 4:49

First problem solved; only one to go
THX Nick Smile | :)

www.troschuetz.de

Re: Detect "Minimize" and "Autostart"

Christian Pedersen3-Nov-04 5:04

Christian Pedersen

3-Nov-04 5:04

You could add a parameter to the autostart shortcut and check for it when the program starts.

Or check the TickCount. If it's really low, the system was just started Wink | ;)

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