Visual Basic

Re: print color in a crystal report by using vb.net

12-Jul-07 1:43

It doesn't know what that number means. You'll have to save the string name of the color in the database too and add that column to your report if you want to do this.

A guide to posting questions on CodeProject[^]

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

zed8312-Jul-07 15:52

zed83

12-Jul-07 15:52

thank you very much for your reply Dave..
but i'm very sorry, i do not understand...
how can the report will be printed with color if i add string type of column?
won't the report will show a text rather than the color code or a color itself?

will u explain a little bit..please..
and if i am wrong please correct me..

thanks..

Re: print color in a crystal report by using vb.net

Dave Kreskowiak13-Jul-07 15:19

Create Windowsmediaplayer like taskbar item

13-Jul-07 15:19

zed83 wrote:
how can the report will be printed with color if i add string type of column?

No, you have to store the color value twice. Once as the value you currently have and once as the name of the color. Then you can add either or both of those columns to the report.

A guide to posting questions on CodeProject[^]

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

svh198511-Jul-07 12:06

svh1985

11-Jul-07 12:06

hello,

Is it possible to create an windows taskbar item with for example a button on it.

Or a way to inject a button in the start menu for example under the run button.

thanks!

Re: Create Windowsmediaplayer like taskbar item [modified]

Dave Kreskowiak11-Jul-07 14:32

Re: Create Windowsmediaplayer like taskbar item

11-Jul-07 14:32

Possibly, but this would probably require writing an Explorer Shell Extension to do it. This is not going to be easy, and help with something like this is going to be sparse to be sure.

Or, I've misunderstood what you're talking about. What do you mean by a "Windows Media Player taskbar item"???

-- modified at 20:48 Wednesday 11th July, 2007

A guide to posting questions on CodeProject[^]

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

The ANZAC11-Jul-07 18:06

The ANZAC

11-Jul-07 18:06

you need to look into something called a deskband, but almost all of the source code and help is in C#.

Posted by The ANZAC : "WWBD, What Would Buffy Do?" : "I don't know man, she's stronger than me"

DragDrop zip file onto DataGridView

penguin500011-Jul-07 11:30

penguin5000

11-Jul-07 11:30

Hi,
I've got some code that allows me to click a button to browse to a zip file, and populate a DataGridView with all of the file names contained within the zip.
What I now want to do is go a stage further, and allow the user to drag a zip file into the DataGridView, and perform the same routine.
For reference, the functionality to perform the unzip is provided via DotNetZipLib.zip

The code that I've been trying to get to work is:

Imports ionic.utils.zip<br />
<br />
    Private Sub DataGridView1_DragDrop(ByVal sender As Object, ByVal e As System.Windows.Forms.DragEventArgs) Handles DataGridView1.DragDrop<br />
<br />
        Dim strFilePathAndName As String<br />
<br />
        strFilePathAndName = DirectCast(e.Data.GetData(Windows.Forms.DataFormats.FileDrop), String)<br />
<br />
        Dim zip As ZipFile<br />
        zip = ZipFile.Read(strFilePathAndName)<br />
<br />
        Dim tblZipFilesTable As DataTable = New DataTable("CompressedFiles")<br />
        Dim ds As DataSet = New DataSet("ZipFile")<br />
<br />
        ds.Tables.Add(tblZipFilesTable)<br />
<br />
        tblZipFilesTable.Columns.Add("File name", GetType(String))<br />
        tblZipFilesTable.Columns.Add("Columns in table", GetType(Integer))<br />
<br />
        Dim tblRow As DataRow<br />
<br />
        For Each file As ZipEntry In zip<br />
<br />
            tblRow = tblZipFilesTable.NewRow<br />
<br />
            tblRow.Item("File name") = file.FileName.ToString<br />
<br />
            tblZipFilesTable.Rows.Add(tblRow)<br />
<br />
        Next<br />
<br />
        Me.DataGridView1.DataSource = ds<br />
        Me.DataGridView1.DataMember = "CompressedFiles"<br />
<br />
        With Me.DataGridView1<br />
<br />
            .Columns(0).Width = 210<br />
            .Columns(1).Width = 120<br />
<br />
        End With<br />
<br />
        Me.DataGridView1.Refresh()<br />
<br />
    End Sub<br />
<br />
    Private Sub DataGridView1_DragEnter(ByVal sender As Object, ByVal e As System.Windows.Forms.DragEventArgs) Handles DataGridView1.DragEnter<br />
<br />
        If e.Data.GetDataPresent(Windows.Forms.DataFormats.FileDrop) Then<br />
            e.Effect = DragDropEffects.Copy<br />
        Else<br />
            e.Effect = DragDropEffects.None<br />
        End If<br />
<br />
    End Sub

But it doesn't do anything. When I set a breakpoint within the first few lines of "Sub DataGridView1_DragDrop", I find that it doesn't even go in here.

Re: DragDrop zip file onto DataGridView

penguin500011-Jul-07 12:06

penguin5000

11-Jul-07 12:06

Resolved it ...

    Private Sub DataGridView1_DragDrop(ByVal sender As Object, ByVal e As System.Windows.Forms.DragEventArgs) Handles DataGridView1.DragDrop<br />
<br />
        Dim strFilePathAndName As String() = DirectCast(e.Data.GetData(DataFormats.FileDrop), String())<br />
<br />
        Dim zip As ZipFile<br />
        zip = ZipFile.Read(strFilePathAndName(0))

Textbox Problem

bbragan11-Jul-07 9:38

bbragan

11-Jul-07 9:38

When a user inputs data into the textbox
The textbox control provides a list of previous entered values
is there a way to disable this in vb.net web form .net 1.1

Dave Kreskowiak11-Jul-07 10:02

11-Jul-07 10:02

It's not the Textbox that's doing this. It's the users browser that's doing it, and no, you have no control over this from your ASP.NET code.

A guide to posting questions on CodeProject[^]

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

Tarakeshwar Reddy11-Jul-07 10:19

Tarakeshwar Reddy

11-Jul-07 10:19

You will have to set the autocomplete property for your textbox. The intellisense of Visual studio 2003 doesn't provide you with the option.

<br />
<br />
<asp:TextBox id="txtControl" runat="server" autocomplete="off"></asp:TextBox>

You can do it at the form level by setting <form id="Form1" method="post" runat="server" autocomplete="off">

Tarakeshwar Reddy
MCP, CCIE Q(R&S)

There are two kinds of people, those who do the work and those who take the credit. Try to be in the first group; there is less competition there. - Indira Gandhi

Dave Kreskowiak11-Jul-07 10:24

11-Jul-07 10:24

Hmmm...Shows you how much of an ASP.NET expert I am! Big Grin | :-D

A guide to posting questions on CodeProject[^]

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

Retrieving data in selected row of datagrid

Tarakeshwar Reddy11-Jul-07 10:40

Tarakeshwar Reddy

11-Jul-07 10:40

You can blame Microsoft Poke tongue | ;-P

, I have found many properties not showing up in the Intellisense or the properties window of the control D'Oh! | :doh:

. I guess we just need to learn from trial and error method and of course the experience.

For ex the intellisense of the DropDownList in visual studio 2005 doesn't show the SelectedValue property and I was trying to figure out a way to bind the DropDownList to the Gridview, just trying my luck, I typed in SelectedValue inside the tag and binded it to the gridview and it worked. I guess Microsoft needs to come out with a list of "Hey I have coded this but forgot to put it in the Intellisense list"

Tarakeshwar Reddy
MCP, CCIE Q(R&S)

There are two kinds of people, those who do the work and those who take the credit. Try to be in the first group; there is less competition there. - Indira Gandhi

Cory Kimble11-Jul-07 8:00

11-Jul-07 8:00

I want to select a row and get all data in every cell in all columns. I was able to get all cells by using VisibleColumnCount. But that only gives me 4 out of 8 of the cells. I have a conection to a database and putting it into a dataset and binding it to the datagrid. Is there a way to either get the total number of columns OR to get the whole row instead of cell by cell?

nlarson1111-Jul-07 9:35

nlarson11

11-Jul-07 9:35

For idx As Int16 = 0 To Me.DataGridView1.Columns.Count - 1
MsgBox(Me.DataGridView1.SelectedRows(0).Cells(idx).Value)
Next

Cory Kimble11-Jul-07 9:49

11-Jul-07 9:49

Is this available in 2003

nlarson1111-Jul-07 10:13

nlarson11

11-Jul-07 10:13

No...

Do this to get the column count....

Dim iColCount As Int16 = 0

If TypeOf (Me.DataGrid1.DataSource) Is DataSet Then
iColCount = CType(Me.DataGrid1.DataSource, DataSet).Tables(0).Columns.Count
ElseIf TypeOf (Me.DataGrid1.DataSource) Is DataTable Then
iColCount = CType(Me.DataGrid1.DataSource, DataTable).Columns.Count
End If

Cory Kimble16-Jul-07 7:10

16-Jul-07 7:10

How about getting count of columns on dataview as datasource?

nlarson1116-Jul-07 7:56

nlarson11

16-Jul-07 7:56

there is a table property...

dim iColCount as int16

iColCount = oView.Table.columns.count

Cory Kimble28-Aug-07 6:29