Visual Basic

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."

जय हिंद