Re: parsing user input to Create Filter SQL - Visual Basic Discussion Boards

Assaf821-Aug-07 3:15

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.

Error when display report in crystal report viewer

Mekong River31-Jul-07 22:56

Mekong River

31-Jul-07 22:56

Hi, I got a problem while trying to view a report in crystal application. When I try to open the report, it display this error message: Server has not yet been opened. My application is connect to sql server and when I try to add data or retrieve data from the database, it work fine. But when I try to view the report it display the above error message. Please let me know how to solve the problem.

C# code to vb.net

Ahmad Zaidi31-Jul-07 22:00

Ahmad Zaidi

31-Jul-07 22:00

Hi,

I was trying to take a screenshot of a web page through the web browser control using the drawtobitmap function and it was giving blank images for pages such as google.com . I finally found the reason as stated by someone here :
http://www.codeproject.com/useritems/Website_Thumbnails_in_C_.asp?df=100&forumid=359744&exp=0&select=2053785#xx2053785xx

I am now trying to convert the code given by the guy to vb.net, but am new to it and cant seem to implement the interface calls. Could anyone please help he port the code? Here it is (as given in the post):

"The only sure fire way round I found was to fall back to using the raw interfaces:

1) Add a reference to MSHTML.tlb

2) Create your own version of IHTMLElementRender which uses an IntPtr rather than _RemotableHandle:

[InterfaceType(1)]
[Guid("3050F669-98B5-11CF-BB82-00AA00BDCE0B")]
public interface IHTMLElementRender2
{
void DrawToDC(IntPtr hdc);
void SetDocumentPrinter(string bstrPrinterName, ref _RemotableHandle hdc);
}

2) Use this code to capture the initial web page image:

IHTMLDocument2 rawDoc = (IHTMLDocument2)hiddenWebBrowser.Document.DomDocument;
IHTMLElement rawBody = rawDoc.body;
IHTMLElementRender2 render = (IHTMLElementRender2)rawBody;

Bitmap screenCapture = new Bitmap(width, height);
Rectangle drawRectangle = new Rectangle(0, 0, width, height);
myWebBrowser.DrawToBitmap(screenCapture, drawRectangle);
Graphics graphics = Graphics.FromImage(screenCapture);

IntPtr graphicshdc = graphics.GetHdc();
render.DrawToDC(graphicshdc);
bmpg.ReleaseHdc();
bmpg.Dispose();"

Thanks!
Ahmad

Re: C# code to vb.net

Christian Graus31-Jul-07 22:02

Christian Graus

31-Jul-07 22:02

There are web sites that convert C# to VB, and some CP articles also. There are also commercial products, that probably do a better job.

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: C# code to vb.net

eyes200731-Jul-07 22:10

eyes2007

31-Jul-07 22:10

try this link

http://converter.telerik.com/

Re: C# code to vb.net

Ahmad Zaidi31-Jul-07 22:18

Ahmad Zaidi

31-Jul-07 22:18

Hi,

Thanks alot for the link and help guys! Its converting the code fine, but VB doesnt seem to recognise InterfaceType(1) in the follwing code snippet (I am pasting it as member of a form class):

<interfacetype(1)> _
<guid("3050f669-98b5-11cf-bb82-00aa00bdce0b")> _
Public Interface IHTMLElementRender2
Sub DrawToDC(ByVal hdc As IntPtr)
Sub SetDocumentPrinter(ByVal bstrPrinterName As String, ByRef hdc As _RemotableHandle)
End Interface

I have added the reference too. It says "Type 'InterfaceType' is not defined". Am i missing out on something?

Thanks!
Ahmad

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