Re: second form - Visual Basic Discussion Boards

Re: hai

Marcus J. Smith15-Feb-07 4:25

Marcus J. Smith

15-Feb-07 4:25

Wow I didnt realize User Name was a reserved phrase, you learn something everyday!

Cleako

Re: hai

Colin Angus Mackay15-Feb-07 4:31

Colin Angus Mackay

15-Feb-07 4:31

cleako wrote:
I didnt realize User Name was a reserved phrase, you learn something everyday!

It isn't. But the parser will interpret it as two distinct tokens unless you put square brakets around it. It will then get confused about what the second token means.

Now, what are you going to do about your gaping security hole?

Upcoming events:
* Glasgow: Geek Dinner (5th March)
* Edinburgh: Web Security Conference Day for Windows Developers (12th April)

My: Website | Blog | Photos

Re: hai

Marcus J. Smith15-Feb-07 4:46

Marcus J. Smith

15-Feb-07 4:46

Colin already answered your question but Im going to have to agree with him on the straight SQL, I just didnt want to say anything. Since you are using an Access DB you are going to have to validate the input to make sure that nothing that can lead to a SQL Injection attack is entered. First rule of user interactive programming is:

"All user input is EVIL!!!!"

Cleako

String length problem

penguin500015-Feb-07 2:29

penguin5000

15-Feb-07 2:29

I'm using VB.NET 2005 Express, and I am reading in the contents of a text file.
I have declared:

Dim strLine as String

I'm using the StreamReader to read the contents of the text file, and I'm putting the contents into strLine.

Unfortunately, it only seems to read in the first 16381 lines from the text file, and processes those lines without any problems - but ignores lines beyond this. All my other test files (having far fewer lines than 16381) work fine.

On this occasion, the file that I need to read is 124415 lines long and so, as a novice, I've concluded that 'String' isn't up to the job.

Can anybody point me in the right direction?

Re: String length problem

Tamimi - Code15-Feb-07 3:49

Tamimi - Code

15-Feb-07 3:49

try to user System.Text.StringBuilder instead of string

When you get mad...THINK twice that the only advice
Tamimi - Code

Re: String length problem

penguin500015-Feb-07 23:25

penguin5000

15-Feb-07 23:25

Thanks for your reply.
I managed to solve the problem.
I had a Try ... Catch which was hiding the real problem - which was a problem with huge numbers I hadn't anticipated having to process. Simply changing the variables from Int to Long seems to have solved the problem.

second form

KOKEMO15-Feb-07 1:47

KOKEMO

15-Feb-07 1:47

Hi,
I have made a second form in VB.NET , now for some calculations i have to pass some parameters to the second form. How can i do this ?

//within the main form

Private Sub cmdDisplay_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdDisplay.Click
Dim results As frmDisplayExpenses
results = New frmDisplayExpenses

results.ShowDialog()

End Sub

what should i do if i want to pass the param [salary] to the second created form ? Sniff | :^)

Re: second form

Marcus J. Smith15-Feb-07 2:13

Marcus J. Smith

15-Feb-07 2:13

There are different ways of doing this

1. You could create a property on the new form and set the value before you show it and transfer control.

2. You could accept the values in the constructor, Public Sub New().

3. I believe there is a way for the child form to access the parent form, so you might be able to do that as long as the value is available to that child form.

Some web sites:

http://www.devcity.net/Articles/100/1/.aspx[^]
http://www.google.com/search?q=child+form+access+parent+form+values+vb.net&sourceid=ie7&rls=com.microsoft:en-US&ie=utf8&oe=utf8[^]

Cleako

Re: second form

jim_taylor16-Feb-07 10:21

jim_taylor

16-Feb-07 10:21

The best way is to use properties to pass stuff back and forth, but you don't have to restrict yourself to properties you define. For instance, if you want to collect a chunk of text in the second form, you can code something like this, assuming you have a text box on the second form:

    <br />
    Dim MyString as string<br />
    Dim dlg as new FormTwo<br />
    Dim result as DialogResult<br />
<br />
    dlg.TextBox1.text = "Default Value"<br />
    result = dlg.ShowDialog()<br />
    If result = DialogResult.OK Then<br />
        MyString = dlg.TextBox1.text<br />
    Else<br />
        ' Some kind of error handling code<br />
    End If<br />

JimT

Need Help while deployment ...Anyone please help me.

Member 371873315-Feb-07 0:32

Member 3718733

15-Feb-07 0:32

Hallo Friends,
Need Help
I hav deployed my vb.net(Winforms)2005 application on client m/c through setup of my application.
In application's setup i hav added merge module CrystalReports10_maps.msm.
but when i m opening my crystal report through my application on client side machine it is asking for login id & password. My database is in mysql. I m giving the userid & password tht using in my application , but it says-> Logon failed.
Application is showing other forms but asking login only for crystal report.
Please help me.

-Thanks for any help in advance.

Re: Need Help while deployment ...Anyone please help me.

nlindley715-Feb-07 6:04

nlindley7

15-Feb-07 6:04

Hey,

If you don't want to be prompted for database credentials when you open the crystal report you should change the database connection (in crystal, under Database > Database Expert) to use integrated security as opposed to typing in the username / password.

Later

Nathan Lindley

Validating characters

Mark0614-Feb-07 23:50

Mark06

14-Feb-07 23:50

Hi,
Im using .Net 2, creating a user entry form.
How do I prevent 1 or more characters from being entered into a textbox.
For example: one textbox, I dont want a user entering slashes or single quotes.
In another textbox, I dont want the user entering single quotes.

Have I got to write a whole validation thing, or is there some sort of formatting or regex I can use?

Any response gratefully appreciated.

Mark

Re: Validating characters

KeithF15-Feb-07 0:09

KeithF

15-Feb-07 0:09

Hi Mark

You can use regular expressions as far as i know to do what you want or you could use a masked textbox in .Net 2.0.

However to do what you want you need to you use the keypress event of a textbox and ignore character you dont want to allow by setting e.handled = true.

Private Sub txtText1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtText1.KeyPress

'If the key pressed is ' or " or any type of punctuation mark then do not allow
If e.KeyChar.IsPunctuation(e.KeyChar) Then
e.Handled = True
End If

End Sub

'This will ignore a backslash
If e.KeyChar = Microsoft.VisualBasic.Chr(Keys.OemBackslash) Then
e.Handled = True
End If

Hope this Helps

Keith

Dynamic compilation

JCSillero14-Feb-07 21:53

JCSillero

14-Feb-07 21:53

Hi everybody

I work with many projects (Visual basic 2005) that i use in many different solutions, but i have a problem with compiling the projects. I need to set the result dir of all my proyects with base on solution's dir. Ex:

Solution dir: C:\MySolution
Proyects:
project1 code dir: C:\Proyects\Proyect1
Proyect1 result dir: c:\Mysolution\bin
project2 code dir: C:\Proyects\Proyect2
Proyect2 result dir: c:\Mysolution\bin
.....

I won't to change manually all result dir when i change the solution so i hope anyone can help me (i've tried on generation event but doesn't work)

Thank you

.J2

Re: Dynamic compilation

Dave Kreskowiak15-Feb-07 13:00

Dave Kreskowiak

15-Feb-07 13:00

I suggest not changing the target folders for the build binaries. Instead, go into the Project Properties, Build Events button, and create a Post-Build event that launches a batch file to copy the resulting files to where you need them.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Re: Dynamic compilation

JCSillero15-Feb-07 18:56

JCSillero

15-Feb-07 18:56

Thank you very much for your help. This is the solution i need.

.J2

How 2 Fix the Form Size in Vb.Net?

Parameswar Mal14-Feb-07 21:38

Parameswar Mal

14-Feb-07 21:38

:(Actually I created a form, which is a MDI.
I then took a form(form 2),which is a child form.
Now when i run the application the child form (form 2)
comes within the MDI.
But now the problem is how i can fix the child form
inside the MDI.

I tried the following code

form2.minimize=false
form2.maximize=false
when i double click the status bar the form size changes
so it moves within the MDI.Now how can i fix it ?.

Re: How 2 Fix the Form Size in Vb.Net?

Ankur.Bakliwal14-Feb-07 23:48

Ankur.Bakliwal

14-Feb-07 23:48

Hello,

u need to change it's border style..
i think there is a fixed border style, selete it, u will get ur answer

Thanks,
Ankur Bakliwal

How to increase the Field Size in Access2003

somagunasekaran14-Feb-07 19:38

somagunasekaran

14-Feb-07 19:38

Hi,
I want to store the Documents in ACCESS But access is accepting only 255 characters.

is it Possible?????.....Pls tel me.... way....

thanking you
somasundaram G

Re: How to increase the Field Size in Access2003

KeithF14-Feb-07 22:44

KeithF

14-Feb-07 22:44

Access has a type of field called Memo this will probably work for short documents but i doubt it will be able to save large documents.

Regards
Keith

Problem while deployment of Application having Crystal Report

priya_p23314-Feb-07 19:12

priya_p233

14-Feb-07 19:12

Goodmorning friends,
I hav problem when i opened crystal report through my application on my client's machine.
i m using vb.net 2005 & mysql.
.net framework & connector required are already installed on my client machine, So application is runng all right.
but problem is only while opening crystal reports.
So i searched on net for help....Merge module shuld be included in project setup.
1)I have downloaded merge module "CrystalReportsRedist2005_x86.msm" & kept in my
"C:\Program Files\Common Files\Merge Modules" & have included it while building setup project.
2)it is necessary to include managed.msm file
& i m not getting this file
Anyone please help me.

priya

Add Checkbox to DataGridView at code behind.

cheeken2u14-Feb-07 19:01

cheeken2u

14-Feb-07 19:01

I have a datagridview to show data. My datagridview is using datasource to binding data. Now my question is , How can i add a new column as checkbox in front of each row? ( means if i have 3 row of record, each row will have one check box ) and store a value to it ? and how i check this checkbox is checked or unchecked ?
thanks.

Best regards,
Chee ken

Re: Add Checkbox to DataGridView at code behind.

Marcus J. Smith15-Feb-07 2:06

Marcus J. Smith

15-Feb-07 2:06

You should add the checkbox to the datagrid as a template column. Then you will basically step through the datagrid looking to see if the control exists based on the ID you gave it in the template column and then DirectCast(item, Checkbox) and see if it is .Checked = True or not.

I hope that helps.

Cleako

Re: Add Checkbox to DataGridView at code behind.

priya_p23315-Feb-07 18:24

priya_p233

15-Feb-07 18:24

hi,
i wnt to write code that shuld be executed when user clicks on checkbox that is present as datagrid columne.
where should i write the code.

priya

Re: Add Checkbox to DataGridView at code behind.

Marcus J. Smith19-Feb-07 2:43

Marcus J. Smith

19-Feb-07 2:43

Since you are changing the topic you should start your own thread.

BUT, you just need to set a function name to be called in the OnClick event of the template column's checkbox. That function should be Protected instead of Private.

Cleako

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