Visual Basic

Re: Windows application compatible with Mac Operating system

22-Jan-09 1:34

Please download mono from URL : mono-downloads[^]

And compile your vb.net project using mono vb compiler then you can port compiles executable onto Mac as well other Linux flavors.

For more info :
mono project[^]

Thanks Smile | :)

Ashu

dnpro
"Very bad programmer"

Dave Kreskowiak22-Jan-09 7:18

Dave Kreskowiak

22-Jan-09 7:18

You cannot run the same .EXE file on a Mac and expect it to work.

There are two possibilities. You can run Windows inside a virtual machine on the Mac. You'll need virtual machine software and a licensed copy of Windows, then install the .NET Framework on it, and you'll then be able to run your app in the virtual machine.

The second method is what has already been proposed. Get Mono and compile your code using that framework. You'll, more than likely, have to rewrite parts of your app to get it to work completely, since Mono is NOT a 100% replacement for the .NET Framework.

A guide to posting questions on CodeProject[^]

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

Re: Windows application compatible with Mac Operating system

pavanip23-Jan-09 1:11

pavanip

23-Jan-09 1:11

thanks for your quick response.I downloaded mono software I got .dmg file.
can you please tell me how to open .dmg file.for that i followed some procedure but its not working.I downloaded dmg2iso.exe and followed the below command C:\>dmg2iso.exe filename.dmg filename.iso
I am getting this error
partition 0...ERROR: Inflation failed
Please help how to use .dmg file and how to proceed further.

Re: Windows application compatible with Mac Operating system

EliottA23-Jan-09 2:16

EliottA

23-Jan-09 2:16

the dmg file is for the mac OS, not for windows.

Re: Windows application compatible with Mac Operating system

Dave Kreskowiak23-Jan-09 2:27

Dave Kreskowiak

23-Jan-09 2:27

I have no idea. I don't use Mono and don't have a Mac either.

A guide to posting questions on CodeProject[^]

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

not able to disconnet the mapped drive with "NET USE" command in VB6

Ankur.Bakliwal22-Jan-09 0:42

Ankur.Bakliwal

22-Jan-09 0:42

Hi,

My VB6 program is using NET USE command to connect the remote folder to get some files. This program also disconnects after the processing of the files by using following command-
net use \\10.10.0.234\abc_folder /delete
At above command line, my program gets hanged

When i run the above command in DOS command prompt, its giving me following error -

There are open files and/or incomplete directory searches pending on the connection to \\10.10.0.234\abc_folder

Is it OK to continue disconnecting and force them closed? <Y/N> [N]:

Does anybody know about the error and solution... Sigh | :sigh:

Please help me by giving solution ASAP.....

Thanks In Advance--- Rose | [Rose]

Ankur Bakliwal
Mumbai, India

Thanks,
Ankur Bakliwal

Re: not able to disconnet the mapped drive with "NET USE" command in VB6

Ashutosh Phoujdar22-Jan-09 0:50

Re: not able to disconnet the mapped drive with "NET USE" command in VB6

22-Jan-09 0:50

Try this command while disconnecting :

net use \\10.10.0.234\abc_folder /delete /y

I hope this will resolve the issue Smile | :)

Thanks
Ashu

dnpro
"Very bad programmer"

Ankur.Bakliwal22-Jan-09 1:33

Ankur.Bakliwal

22-Jan-09 1:33

Thanks buddy............. Smile | :)

it works.......... Big Grin | :-D

you are gr8.... Wink | ;)

Thanks alot ............. Cool | :cool:

Thanks,
Ankur Bakliwal

Do not allowing user to order rows

RA|-|UL PATEL22-Jan-09 0:08

RA|-|UL PATEL

22-Jan-09 0:08

Hello friends...

I am facing one problem in datagridthat is when i click on the header of column rows are going to be ordered.

i dont want user to order rows in this way..

Posts are welcome

Thanks in advance...

Ashutosh Phoujdar22-Jan-09 0:20

22-Jan-09 0:20

Please try this :

set AllowUserToOrderColumns property of datagridview control to false as follows:

datagridView1.AllowUserToOrderColumns=False.

Alternatively if you are using visual studio designer, you set it via properties window.

Hope this will give a solution

Thanks
Ashu

dnpro
"Very bad programmer"

RA|-|UL PATEL22-Jan-09 1:30

RA|-|UL PATEL

22-Jan-09 1:30

Thakns ashu fouzdar.
I'm sure that GridName.Allowusertoordercolumns is already false
even Problem persist there.

When i click on the header row are going to order.

Please give solution...

Ashutosh Phoujdar22-Jan-09 1:46

22-Jan-09 1:46

Here is a solution, I hope this will work for you also

Private Sub Grid_DataSourceChanged(ByVal sender As Object, ByVal e As System.EventArgs) 
Handles Grid.DataSourceChanged

        Try
            For Each clmn As DataGridViewColumn In Grid.Columns
                clmn.SortMode = DataGridViewColumnSortMode.NotSortable
            Next
        Catch ex As Exception
           Logger.Error(ex.ToString())            
        End Try
End Sub

Here you have to catch the DataSourceChanged event of DataGridView, and to insert
the code for setting SortMode to NotSortable for columns you require to be not
sortable.

Please let me know for any queries.

dnpro
"Very bad programmer"

Export DataGridView to Excel And Word WithOut Ms Excel And Word

RA|-|UL PATEL22-Jan-09 17:14

RA|-|UL PATEL

22-Jan-09 17:14

thanks friend.
It is working Perfect
Thank you vaer much Again..
Smile | :)

mehrnoosh21-Jan-09 19:58

mehrnoosh

21-Jan-09 19:58

hi every body
how can we export a datagridview data to excel and word when Ms excel and ms word is not instal in system...
can you help me please?! D'Oh! | :doh:

M.Alizadeh

Re: Export DataGridView to Excel And Word WithOut Ms Excel And Word

Wendelius21-Jan-09 20:15

Wendelius

21-Jan-09 20:15

Whole lot of good articles found with simple search: http://www.codeproject.com/info/search.aspx?artkw=export++data+to+excel&sbo=kw[^]

The need to optimize rises from a bad design.My articles[^]

Re: Export DataGridView to Excel And Word WithOut Ms Excel And Word

Ashutosh Phoujdar22-Jan-09 0:15

Re: Export DataGridView to Excel And Word WithOut Ms Excel And Word

22-Jan-09 0:15

Hi,

You can use following library for exporting to Excel :
CarlosAg Excel Xml Writer Library[^]

And for exporting to word :

Gios WORD .NET Library (using RTF specification)[^]

For exporting to word/excel, you must have to iterate through Row of datagridview rows, using following code snippet

For Each currentRow As DataRow In DataGridView1.Rows
        'Use the values in current cell using following syntax.
        currentRow.Cells(0).Value
        currentRow.Cells(1).Value
        currentRow.Cells(3).Value
        'until all cells are covered.
Next

Alternatively if you are looking for only copying the data to excel/word, just select the data copy using (ctrl+c) and paste to word/excel (This will work with .NET framework version 2.0 and greater).

Hope I answered your query. Smile | :)

Thanks,
Ashu

dnpro
"Very bad programmer"

rohan_puranik22-Jan-09 20:07

rohan_puranik

22-Jan-09 20:07

You can do one thing. Write the data of your DGV to a CSV (comma separated value) file.
Whenever a user opens a CSV (on a machine having MS-Office) it will get open in MS-Excel by default.

Here's a raw code snippet

for each row in DGV
get value of cell and store it in string
append , (i.e. comma)
end for
trim last character of string //(because it would contain last appended comma)
write this string to file "file.csv"
save the file

Whenever user open this CSV it will get open in MS-Excel.
If a user does not have MS-Excel he/she may do one thing. Right click the file and open it in notepad.
Hope this help you out.

Scrollbar height and width

r.ps21-Jan-09 18:27

r.ps

21-Jan-09 18:27

Hi,
Forgive me if this is a silly question. I'm new to this.

How can one find out the height and width of the scrollbars of a treeview control?

I have a treeview which i'm trying to resize when the form is resized.
I'm doing this;

Me.TreeView1.Height = Me.ClientSize.Height - x

I need to figure out 'x' so that the scrollbar stays inside the form!

dan!sh 21-Jan-09 18:56

dan!sh

21-Jan-09 18:56

You should make sure the treeview stays inside the form. The scrollbar will follow automatically.

Appropriate anchoring and docking will do that for you.

The word "politics" describes the process so well: "Poli" in Latin meaning "many" and "tics" meaning "bloodsucking creatures."

जय हिंद

r.ps21-Jan-09 19:15

r.ps

21-Jan-09 19:15

d@nish wrote:
You should make sure the treeview stays inside the form

That is what i was trying to do with the piece of code i'd posted.
But unless i subtract a certain value (which i assume is the height of scrollbar), the treeview's scrollbar strays out of the form!

interestingly if i simply use the docking property (Fill), the resizing works fine but the scrollbar is never shown. hence my attempt to do it manually.

dan!sh 21-Jan-09 20:03

dan!sh

21-Jan-09 20:03

Assuming the treeview is in the left part of the form along the height, anchor it to top, left and bottom. Also make sure scrollable property is true.

The word "politics" describes the process so well: "Poli" in Latin meaning "many" and "tics" meaning "bloodsucking creatures."

जय हिंद