Re: DataGridView - Visual Basic Discussion Boards

Re: wanna write code the form's X button's click event

eyes20071-Aug-07 4:45

eyes2007

1-Aug-07 4:45

thnx but my rguments r little bit different

i m trying to change the parent of a toolstrip to form2 to form1 the code is

Private Sub toolstrip1move_FormClosing(ByVal sender As Object, ByVal e As System.Windows.Forms.FormClosingEventArgs) Handles Me.FormClosing
Me.TopMost = False
Dim tools1 As ToolStrip = CType(sender, ToolStrip)
tools1.Parent = Form1
tools1.Hide()
End Sub

but the tools1.parent = form1 causing the error

Re: wanna write code the form's X button's click event

Tom Deketelaere1-Aug-07 4:52

Tom Deketelaere

1-Aug-07 4:52

first of all:

eyes2007 wrote:
Dim tools1 As ToolStrip = CType(sender, ToolStrip)

will not work

sender is of the type Form

second: I'm not really shure what will happen if you just change the parent of a control
my sugestion would be that you call a function on form1 wich dynamicly recreates the tools1 that way you'r form2 can shut down whitout any problems (but like I said don't know if it is needed)

perhaps something like this would be better:

form1.controls.add(tools1.clone) (don't know if possible didn't test it)

Re: wanna write code the form's X button's click event

eyes20071-Aug-07 20:41

eyes2007

1-Aug-07 20:41

its not doing the work needed

the only option is that

i creat a button that exactly lools like the close botton on form place exactly on that close button and write the click event of that one

but i don't like to use this

Re: wanna write code the form's X button's click event

Tom Deketelaere1-Aug-07 20:46

Tom Deketelaere

1-Aug-07 20:46

what exactly do you want to do??

if you want to catch the 'X'button click event you need to use the formclosing/formclosed event of the form (best to use the formclosing that way everything is still on the form)

Ref:I got error when exporting asp to pdf

aswath0071-Aug-07 3:23

aswath007

1-Aug-07 3:23

Hi all,

Iam getting error when exporting asp.net webpage contents into pdf file.If u have any idea plz revert me.The error is "The file couldn't open because the file not supported/it was damaged.

Thanks,
Aswath

DataGridView

Assaf821-Aug-07 3:15

Assaf82

1-Aug-07 3:15

I try to fill a datagridview from a datareder,and assign each value in the reader to a column
but i don't know

can someone help me ?

Thank you

Assaf

Re: DataGridView

Rupesh Kumar Swami1-Aug-07 3:32

Rupesh Kumar Swami

1-Aug-07 3:32

hi assaf,
i think DataReader is a forward only stream, you should use a DataApdater and
a DataSet for you to be able to display the data in the DataGridView

Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)

Re: DataGridView

Assaf821-Aug-07 11:42

Assaf82

1-Aug-07 11:42

Thanks Rupesh
But i don't know how to let the DataGridView show the result in the DataSet
I use DataAdapter and A DataSet!

If Someone can help me ?

Thanks in advance

Assaf

Storing bengali data into a SQL server

halder_rajib1-Aug-07 2:14

halder_rajib

1-Aug-07 2:14

i want to store data in bengali into SQL server and when i would retrieve the data it will come to the text box in bengali.pls help .

I want know more about .net

Re: Storing bengali data into a SQL server

Colin Angus Mackay1-Aug-07 8:41

Colin Angus Mackay

1-Aug-07 8:41

Use nvarchar columns to store the data.

Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...

"I wouldn't say boo to a goose. I'm not a coward, I just realise that it would be largely pointless."

My website

Changing taskbar properties.

The ANZAC1-Aug-07 1:56

The ANZAC

1-Aug-07 1:56

On the taskbar, the buttons representing each open program resize themsleves between two boundaries, generally betwwen the quick launch bar and the notification area. Is it possible, and if so how, to change these boundaries so that taskbar item boundaries will reduce the space items occupy.

Please check out my articles:
The ANZAC's articles

parsing user input to Create Filter SQL

MartyK20071-Aug-07 1:55

MartyK2007

1-Aug-07 1:55

Hi,
I am using a datagrid view to display table data via dataset.

additionally I have a number of text and combo boxes where the user can enter filter information

so for example the data grid has 2 columns a product and a price.
The product filter is a combo box and the the price filter is a textbox.

acceptable filters would be
for the product:
a selected product ( phillips screwdriver)
a wildcard entered directely into the combo ( *screwdriver* )
for the price:
> 50 And < 300
<= 20

What I am looking for is an easy parsing technique that would convert the user entry into something an SQL where clause (or even a dataset select ) would understand
ie
Where [Product] = "phillips screwdriver" and [Price] > 50 and [Price] < 300

does anyone have an example algorythim for this kind of thing so that I can build code (or indeed any code to do this would be greatfully received - I can always build an algorythim from it)

Thanks
Martin

life is a bowl of cherries
go on take a byte

Re: parsing user input to Create Filter SQL

Craster1-Aug-07 2:44

Craster

1-Aug-07 2:44

This screams one thing, and screams it loud - SQL injection attacks.[^].

You do not want to take user input and directly construct an SQL query from it. What you want to do instead is create an SQL Stored Procedure on the server that will perform your select statement, and pass the user entered values to it.

Some info on calling SQL Stored Procedures from VB.NET.[^]

Re: parsing user input to Create Filter SQL

MartyK20071-Aug-07 3:02

MartyK2007

1-Aug-07 3:02

Actually what I want to do is pass a dataset to the GUI holding say

Select * from Customers.

then use the User input and build a Dataset/DataView Filter on the returned dataset

so no SQL injection
but its a good warning.
thanks

also in this app , some data will come from SQL DB and other data from Oracle DB

so I have written a middleware layer which will retrieve the data but I dont want to use stored procedures at the DB level when my middleware is currently generic enough to handle both DB's via "standard" SQL.

thanks
Martin

life is a bowl of cherries
go on take a byte

convert an array to a string

sixecho1-Aug-07 1:43

sixecho

1-Aug-07 1:43

i am writing a program to get processes from the task manager to a text box. i managed to get the processes to an variabel,but when i try to send the data to a string variable...... it does not work.
i want to know how to change data from an array to a string....

shiran

Re: convert an array to a string

_mubashir1-Aug-07 1:49

_mubashir

1-Aug-07 1:49

sixecho wrote:
i want to know how to change data from an array to a string.

Loop through your array contents and append them in a string.

Mubashir
Software Architect
Storan Technologies Inc, USA
Every job is a self portrait of the person who did it.

Re: convert an array to a string

Tom Deketelaere1-Aug-07 1:54

Tom Deketelaere

1-Aug-07 1:54

arrayname.tostring()

Re: convert an array to a string

Luc Pattyn1-Aug-07 2:54

Luc Pattyn

1-Aug-07 2:54

Have a look at String.Join() !

Luc Pattyn

try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] }
catch { [Google] }

Name of offending code

Johan Hakkesteegt31-Jul-07 23:34

Johan Hakkesteegt

31-Jul-07 23:34

Hi,

In an attempt to simplify the debugging process, I wrote a public sub EC (ErrorCatcher), that I can call from anywhere in my app, which writes all necessary information to a text file. Something like:

Public Sub EC(Byval err As Exception)<br />
dim line as string = Now & " - Error: " & Err.TargetSite.Name & " - " & Err.Message<br />
'write line to file, etc.<br />
End Sub<br />
<br />
Private Sub MyCode()<br />
Try<br />
'some error happens here<br />
Catch ex As Exception<br />
EC(ex)<br />
End Try<br />
End Sub

This Err.TargetSite.Name is just my latest attempt, but it does not tell me that the error took place in Private Sub MyCode.

Is there any way (other than passing it to the EC sub as a handwritten string) at all to find out in what part of the code the exception occurred, at runtime, and if yes then how?

Any help or suggestions appreciated.

Johan

My advice is free, and you may get what you paid for.

Re: Name of offending code

Christian Graus31-Jul-07 23:54

Christian Graus

31-Jul-07 23:54

Yes, you can get the stack trace from the exception object and print it, it will tell you what method threw the exception, and a call stack down from there.

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 )

Re: Name of offending code

Johan Hakkesteegt1-Aug-07 20:02

Johan Hakkesteegt

1-Aug-07 20:02

Thanks Christian, Steve also suggested this, and according to Luc I can get even more information out of an exception by simply using Exception.ToString().

Thank all you guys, this really helps.

My advice is free, and you may get what you paid for.

Re: Name of offending code

Steven J Jowett31-Jul-07 23:58

Steven J Jowett

31-Jul-07 23:58

I believe you need to check the StackTrace property.

err.StackTrace

Steve Jowett
-------------------------
Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'

Re: Name of offending code

Johan Hakkesteegt1-Aug-07 20:00

Johan Hakkesteegt

1-Aug-07 20:00

Thanks Steve, I will try this.

My advice is free, and you may get what you paid for.

Re: Name of offending code

Luc Pattyn1-Aug-07 0:27

Luc Pattyn

1-Aug-07 0:27

Hi,

rather than using Exception.Message and/or Exception.StackTrace
you really should use Exception.ToString()

it will show you at least the Message and the StackTrace
but also:
- additional information (e.g. the filepath on a File Not Found)
- information about "inner exceptions"

Smile | :)

Luc Pattyn

try { [Search CP Articles] [Search CP Forums] [Forum Guidelines] [My Articles] }
catch { [Google] }

Re: Name of offending code

Johan Hakkesteegt1-Aug-07 19:59

Johan Hakkesteegt

1-Aug-07 19:59

Thanks Luc, I'll definitely give this a try.

My advice is free, and you may get what you paid for.

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