Visual Basic

datatable from datasource

2-Jul-09 6:55

It is very, very unlikely that the font used would make your printing slow. Unless you are trying to do everything in Italic or Bold for a font that doesn't include those styles, and AFAIK TimesNewRoman does include them, so that ain't the cause of your problem.

If you have a slow printer, then you have a slow printer. On the oter hand if it prints OK from Word or other apps, then there's only one possible cause - your code.

Unless you post the part of your code that deals with the printing, it is very unlikely that anybody can really help you. If you do decide to post it DO NOT POST ALL OF IT, just the printing part(s). Smile | :)

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

thesum1-Jul-09 23:39

thesum

1-Jul-09 23:39

Hello,

I would like to obtain a datatable from a datasource of a gridview :

Dim Table As DataTableCollection = DsGrid.Tables
                BindSource.DataSource = Table(0)
                BindSource.Filter = "Nom LIKE '" & SearchNom & "'
Me.DataGridViewVisiteur.DataSource = BindSource                
                Dim dt as datatable = CType(Me.DataGridViewVisiteur.DataSource, DataTable)

I am getting this message :

Unable to cast object of type 'System.Windows.Forms.BindingSource' to type 'System.Data.DataTable'.

How can i do this ?
Thanks

Henry Minute2-Jul-09 0:18

2-Jul-09 0:18

I assume it is the last line that is giving the error?

If you would give a description of what it is that you are trying to do, it might help. And I don't mean "i am trying to get a datatable from a gridview to use as a datasource for another gridview" I mean "I am trying to use two gridviews from the same datasource but apply a filter to only one of them".

thesum2-Jul-09 3:36

thesum

2-Jul-09 3:36

I would like to obtain the data that are stored in the datagridview.

Henry Minute2-Jul-09 3:58

2-Jul-09 3:58

There are two ways that occur to me:

1) you already have the data in Table so you could use Dim dt as datatable = Table(0)
2) alternatively you could use the DataRowCollection of either DsGrid or DataGridViewVisiteur

If these do not suit your needs then I hope that someone else is able to help you. Smile | :)

thesum2-Jul-09 5:06

thesum

2-Jul-09 5:06

The problem is : i give table(0) to my datagrid, and then i use filter on it.
I want to get back the filtered data remaining in my grid.
Table(0) -> contains all data
i apply a filter using a BindSource.Filter .
I want to get back the filtered data ( those on my datagrid view)
How can i do this ? is it possible ?

Henry Minute2-Jul-09 5:17

ListView doubleClick wont fire

2-Jul-09 5:17

The only way I know is to use the Rows property of the DataGridView that displays the filtered data. This is a collection of DataGridViewRow

Take a look at the documentation for any of those terms for examples of how to use them.

There may be other ways of doing what you want, but both of the BindingSources still access the unaltered data. The filtered one just outputs a filtered sub set to the DataGridView.

Chana Winkler1-Jul-09 22:48

Chana Winkler

1-Jul-09 22:48

Hi all, it's my first time in this forum, I hope you can help.
I have a listview that displays a list of PDF files. When the user clicks on a row (in the "selectedIndexChanged" event), I display the selected PDF underneath the Listview in a Webbrowser control

WebBrowser1.Navigate(sFile)

So far so good.
Additionally, when the user double clicks a row on the ListView (in the "DoubleClick" event), I use

Process.Start(sFile)

where sFile is the name of the PDF file, to open Adobe Acrobat Reader in a separate process.
Now here's the problem: This only works when the user double clicks the currently selected row. If however, the user double clicks on a row that is not selected in the list view, the application produces two "SelectedIndexChanged" events, and no double click event.
What I've discovered is that if I comment out the line

WebBrowser1.Navigate(sFile)

then my code works as expected. A single click produces a "selectedIndexChanged", a double click produces a "selectedIndexChanged" and a "DoubleClick".
So it seems as if calling WebBrowser1.Navigate(sFile) somehow interrupts the events from firing correctly.
Any ideas on how I could solve this issue?
Thank you.

Chana

Re: ListView doubleClick wont fire

Johan Hakkesteegt1-Jul-09 23:44

Johan Hakkesteegt

1-Jul-09 23:44

The first thing that comes to mind is, to make a comparison in the SelectedIndexChanged event. When, with the double click, the SelectedIndexChanged event is fired the second time, check to see if the selected index remains the same.

When the SelectedIndexChanged event is fired, and the selected index remains the same, you execute Process.Start(sFile) and otherwise WebBrowser1.Navigate(sFile).

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

Re: ListView doubleClick wont fire

Chana Winkler7-Jul-09 7:34

Chana Winkler

7-Jul-09 7:34

Thank you for your answer. I tried it out, it wasn't exactly what I needed because I would have had to put in a timer to see whether the two clicks came close together etc.
I did find a different workable solution though. ListView has an "activated" attribute, which, when set to "Two Clicks" activates the selected row on the listview in two clicks. This differs from "DoubleClick" because "Two Clicks" allows for some time to elapse between the two.
I put the Process.Start(sFile) into the ListView1_ItemActivate() event and voila! It works!

Prevent other app's I/O

The real $M@1-Jul-09 20:11

The real $M@

1-Jul-09 20:11

Hi
My program should prevent certain processes' IO operations, and only perform them if the user clicks Yes in a Yes/No dialog. Can this be done?

And anyway how can I check wether those processes are running?
Probably there is an API or sg for that, but I'm new to this part of programming.

Much thanks in advance Smile | :)

Re: Prevent other app's I/O

Eddy Vluggen2-Jul-09 0:24

Eddy Vluggen

2-Jul-09 0:24

The real $M@ wrote:
Can this be done?

Not that I'm aware of. You could try and modify the security-attributes of the file, taking away or granting the read/write rights. You'd have to know in advance what file is going to be edited.

The real $M@ wrote:
And anyway how can I check wether those processes are running?

Process.GetProcesses()

(Source[^])

I are troll Smile | :)

How to approach for reports in word.

nazimghori1-Jul-09 16:47

nazimghori

1-Jul-09 16:47

Hello,

I having one windows application to be developed in VB.Net 2005 the reports requirement is in MS word so please suggest how shall i approach for the same.
I am having my database in Ms Access 2003 in that there is memo field which has one image in it I want to load that image from database to word file.

So please suggest how shall i do it.

Thank You.

Smile | :)

Re: How to approach for reports in word.

Tom Deketelaere1-Jul-09 22:30

Tom Deketelaere

1-Jul-09 22:30

nazimghori wrote:
I having one windows application to be developed in VB.Net 2005

Why? use 2008 and target the .net 2.5 framework if you can't use the newer ones

nazimghori wrote:
the reports requirement is in MS word so please

so you just have to create word docs?

nazimghori wrote:
I am having my database in Ms Access 2003

Again why? there is a free sql server version, much more stable, faster,...
Unless you really have no other choice I wouldn't go for access (there are cases where its usefull but not many)

nazimghori wrote:
memo field which has one image

Memo ??? surly it should be OLE-object field.
+ Storing an image in db is very space consuming. Better would be to store the path to the image in the db and the image on the hard disk just as any normal file.

nazimghori wrote:
I want to load that image from database to word file.

Amazing isn't it what google can do for you[^]

how to use euresys library in vb 2008

zhiyuan161-Jul-09 15:30

zhiyuan16

1-Jul-09 15:30

dear all

i would like to use euresys library in vb 2008, but i dun know how to set it? any one can tell me how to set it and use it step by step. thanks a lot.

kindly sincerely

Re: how to use euresys library in vb 2008

EliottA1-Jul-09 16:31

EliottA

1-Jul-09 16:31

This library, it doesn't come with documentation? The creators don't have a website? Perhaps with examples or support forums??

Check out the CodeProject forum Guidelines[^]
The original soapbox 1.0 is back![^]

Re: how to use euresys library in vb 2008

Dave Kreskowiak1-Jul-09 19:16

Dave Kreskowiak

1-Jul-09 19:16

You're going to have to contact the makers of that library to get any information about it.

Maybe this[^] is what you're looking for...

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

VB.NET 2005 - Refresh Databinding and Reset of Checkboxes

Fry1001-Jul-09 4:35

Fry100

1-Jul-09 4:35

Hello,

I'm hoping that someone can help with two problems I currently have with databinding.

1. I have a couple of checkboxes bound to a form and if I clear my dataset before I change my application to point to another customer, any checkboxes with a checkedstate of checked are reset to unchecked and this is saved in SQL.

2. If I do not clear my dataset before I point to another customer in my application, the correct checkbox state is saved in SQL, however, my databound controls retain customer A's data rather than refreshing with customer B's.

I am connecting to SQL using:

Public Sub SetupDataConnections(ByVal strSQLSelectString As String, ByVal myDataSet As DataSet, ByVal myDataSetName As String, _
    Optional ByVal mySQLParameters As SqlParameter() = Nothing)

        Try

            mySQLConnection = New SqlConnection(_connectionString)
            mySQLConnection.Open()

            ' -- Check connection state
            If mySQLConnection.State = ConnectionState.Open Then

                myDataAdapter = New SqlDataAdapter(New SqlCommand(strSQLSelectString, mySQLConnection))

                ' -- If we have some parameters, add them to our command
                If Not mySQLParameters Is Nothing Then

                    myDataAdapter.SelectCommand.Parameters.AddRange(mySQLParameters)

                End If

                If Not myDataAdapter Is Nothing Then

                    Using myBindingSource

                        myDataAdapter.Fill(myDataSet, myDataSetName)
                        myBindingSource.DataSource = myDataSet
                        myBindingSource.ResetBindings(False)

                    End Using

                Else

                    CatchError("You must first create a SQL connection before calling this function")

                End If

            End If

        Catch ex As Exception

            CatchError(ex)

        End Try

    End Sub

Following this Sub, I proceed through:

Public Function SetupBindings(ByVal myDataSet As DataSet, ByVal myDataSetName As String, ByVal myForm As Control) As Dictionary(Of String, Date)

       myBindingSource.DataSource = myDataSet

        For Each myControl As Control In myForm.Controls

            Try

                myControl.DataBindings.Clear()

                If (TypeOf myControl Is TextBox OrElse TypeOf myControl Is ComboBox) AndAlso Not (myControl.Tag Is "" Or myControl.Tag Is Nothing) Then

                    myControl.DataBindings.Add("Text", myDataSet.Tables(myDataSetName), myDataSet.Tables(myDataSetName).Columns(GetColumnNameFromControlTag _
                    (myControl.Tag.ToString)).ToString, True, DataSourceUpdateMode.OnPropertyChanged)

                    '-- Bind data to associated textbox control
                ElseIf (TypeOf myControl Is DateTimePicker OrElse TypeOf myControl Is DateTimeControl) AndAlso Not (myControl.Tag Is "" Or myControl.Tag Is Nothing) Then

    '--  ... CONTINUE FOR EACH TYPE OF CONTROL BOUND TO THE FORM ...

                ElseIf myControl.HasChildren Then ' -- Recurse back in to function if there are children

                    SetupBindings(myDataSet, myDataSetName, myControl)

                End If

            Catch ex As Exception

                CatchError(ex)

            End Try

        Next

    End Function

And those two subs set up my data binding. Each control's tag contains the DATABASE.COLUMN mapping.

I would greatly appreciate any assistance.

Cheers,
James

Where to store additional files

Mithun.Shitole1-Jul-09 2:53

Mithun.Shitole

1-Jul-09 2:53

Hi,
I'm developing an application which uses some additional files ( like images,templates etc).
I have made folders in bin/debug/ dir so that i can access them relative to exe.
Is this a correct way?
As now i am switching to release configuration, I need to copy all these files with dlls which i refer to bin/release directory also.
What should be done ideally?

Mithun Shitole
"Free Your Mind"
http://www.technoyaari.com

Johan Hakkesteegt1-Jul-09 3:04

Johan Hakkesteegt

1-Jul-09 3:04

Ideally you add an installation / setup project to your solution. Such a project will allow you to add additional files, like drivers, images, etc., and it will allow you to determine where these files will be copied to, during installation.

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

Mithun.Shitole1-Jul-09 3:10

Mithun.Shitole

1-Jul-09 3:10

Thanks for this quicky,
I already have an installation project in solution. But if i add those files only in installation project, How can i access these files/folders while debugging my application?
As my code uses path of exe+path of folder to access those files, folders must be inside application folder.

Mithun Shitole
"Free Your Mind"
http://www.technoyaari.com

Tom Deketelaere1-Jul-09 3:44

Tom Deketelaere

1-Jul-09 3:44

Mithun.Shitole wrote:
I have made folders in bin/debug/ dir so that i can access them relative to exe.

As long as you only read these files that is acceptable.
From the moment you actually need to alter (write into)/ create these files it's not, and vista won't even allow you to (well it will but it will be in the virtual drive).

Mithun.Shitole wrote:
need to copy all these files with dlls which i refer to bin/release directory also.

As suggested you can do this in the setup project.
Just go to where you add the exe ('application folder' if I'm not mistaken), add the folder with the correct name, add the files need into the folder.
Watch out that you add at least one file to each folder created otherwise the setup sometimes doesn't create the folder, don't ask my why but its something I found out the hard way Poke tongue | ;-P

TheMrProgrammer1-Jul-09 5:43

TheMrProgrammer

1-Jul-09 5:43

Make a function: openfile(path as string)

if the bin directory is in the same parent
directory as the .exe file then do this

call openfile("bin\sample.jpg")

similarly call other files.

TheMrProgrammer

TheCalcMan: A no-mouse required Calculator supporting constant operator and visual effects

Try it once, its awesome!
Just 17.1 KB download.
No installation required. No dlls. Just unrar and go. And its a freeware.

http://www.hotlinkfiles.com/files/2642094_kjwr0/TheCalcMan.rar