Setting a datasource for a report - Visual Basic Discussion Boards

judge_1036-Dec-06 14:59

6-Dec-06 14:59

i alerady downloaded the code, tried to build it and run it, but the only build error this one, and i searched the whole code trying to find this class but i couldnt.
With msdn, there is something called WebFile object in the Microsoft VBA reference (here) , but its not clear because its not mentionned to which class or reference it belongs.

Re: error: Type not defined

Dave Kreskowiak7-Dec-06 14:46

Dave Kreskowiak

7-Dec-06 14:46

The class you're loking for is in ExternalFile.vb in the demo project.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Re: error: Type not defined

judge_1037-Dec-06 16:01

judge_103

7-Dec-06 16:01

Thanks alot, in the version i downloaded this file was missing.. i searched the web and i found a complete version... i'll try it now..
thanks again

Re: error: Type not defined

judge_1037-Dec-06 16:16

judge_103

7-Dec-06 16:16

Works Perfectly, thanks again Smile | :)

Running total per column in datagrid

Silver-Grey6-Dec-06 10:49

Silver-Grey

6-Dec-06 10:49

I would like to total one of the datagrid row columns cells based on a code in another column cell in the same row.

Can anybody help ???

silver-gray

Re: Running total per column in datagrid

momooomooomomo7-Dec-06 22:40

momooomooomomo

7-Dec-06 22:40

grid.rowcount()

nothing is impossible.....

Re: Running total per column in datagrid

Silver-Grey8-Dec-06 5:40

Silver-Grey

8-Dec-06 5:40

I could be wrong, but I think that your answer will only count the number of rows in a datagrid. By running total, I mean total the value of a cell based on a value of another cell(column) in the row.

silver-gray

Setting a datasource for a report

dptalt6-Dec-06 10:23

dptalt

6-Dec-06 10:23

How can you set the datasource for a vb report in code?

Diplaying data on a report

dptalt6-Dec-06 10:13

dptalt

6-Dec-06 10:13

How can you use textbox values on a form to populate a vb report? The textbox values are not bound to a database.

Re: Diplaying data on a report

Leah_Garrett6-Dec-06 18:11

Leah_Garrett

6-Dec-06 18:11

dptalt wrote:
How can you use textbox values on a form to populate a vb report?

Do you mean a Reporting Services report? You can pass values from text boxes as paramters to an RS report.

Re: Diplaying data on a report

dptalt7-Dec-06 2:31

dptalt

7-Dec-06 2:31

I mean the report that has 'rdlc' as the file extension.

Re: Diplaying data on a report

Leah_Garrett7-Dec-06 11:46

Leah_Garrett

7-Dec-06 11:46

A simple way to do this would be to make these textbox values parameters to your report and report viewer will display texboxes for the user to provide values.

There are heaps of examples using report viewer at:
http://www.gotreportviewer.com/[^]

If you don't want to do it this way I would suggest you look up some help on using parameters with reports. There are some decent examples for using rdlc on MSDN.

Re: Diplaying data on a report

dptalt8-Dec-06 3:31

dptalt

8-Dec-06 3:31

Thanks for the info, that website is a good one.
For the solution to my problem: I found code on how to set the datasource of a rdlc report in code. In my application I'm using an SDK to query quickbooks for information that is return in a datatable. I can set the report datasource in code to this datatable and the report prints.

Thanks for your help!

listview scroll?

dianadcx6-Dec-06 6:05

dianadcx

6-Dec-06 6:05

Hello I was wondering if someone can please help me. I've written a vb.net program and have text displayed in a listview. The text is longer than my listview control but I don't want to drag out the box to make it bigger (I hope you all know what I'm trying to say). So my question: is there a way to scroll left to right in a listview to view the contents that may otherwise be longer than the size I have made my listview control? I've looked in the properties and could not find anything, for example for a listbox there is a property you can set it to scroll. Any help would be greatly appreciated. Thanks in advance. Sorry for the long question!!

Re: listview scroll?

dhbaer6-Dec-06 9:12

dhbaer

6-Dec-06 9:12

There should be a listview property called 'Scrollable' that you can set to True.

David

Re: listview scroll?

dianadcx6-Dec-06 9:23

dianadcx

6-Dec-06 9:23

Hello David, thanks for your advice. Unfortunately though, I've got that (the scrollable property) set to true and it still doesn't work. Thanks for responding though!

Re: listview scroll?

dhbaer6-Dec-06 9:31

dhbaer

6-Dec-06 9:31

I have a listview that I'm using on a form and so far I've only needed to scroll left/right as my test database only have a few records in it. I ran a test and turned that property off and the scroll bar disappears..so that has to be at least part of it. What does your listview look like? If you'd like, post your listview properties and I can try to compare them to the one I'm using.

David

I am trying to determine the index number in a combobox . . .

Shawn Owens6-Dec-06 5:45

Shawn Owens

6-Dec-06 5:45

Hello-
I am trying to determine the index number of an item being hovered over in a combobox. So, as the
mouse moves over each item in the combobox, I determine that items index. Does anyone have a way of accomplishing this ?
I appreciate your help

Shawn

Re: I am trying to determine the index number in a combobox . . .

dhbaer6-Dec-06 9:15

dhbaer

6-Dec-06 9:15

Could you use the 'mouseover' event or the 'selectedindexchanged' event and then just make a variable = to the combobox.selectedindex?

David

GridView data retrieval question

downfall216-Dec-06 5:43

downfall21

6-Dec-06 5:43

I have a webpage that grabs records associated with a user id. It places the records into a GridView field. I am trying to figure out how to add two calendars to allow the user to only retrieve records between the two dates they select.

NOTE:

For some reason all of my code is not showing up in this message.
If you view the source of this message it shows up in browser

Here is my code:

<br />
<form runat="server" action=""><br />
     <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" DataSourceID="SqlDataSource2" CellPadding="4" ForeColor="#333333" GridLines="None" Width="634px"><br />
        <Columns><br />
            <asp:HyperLinkField DataNavigateUrlFields="Ticket_ID" DataNavigateUrlFormatString="viewtickets.aspx?ticket={0}" Text="View" /><br />
            <asp:BoundField DataField="Date" HeaderText="Date" SortExpression="Date" /><br />
            <asp:BoundField DataField="Ticket_ID" HeaderText="Ticket_ID" SortExpression="Ticket_ID" /><br />
            <asp:BoundField DataField="Dig_Street" HeaderText="Dig_Street" SortExpression="Dig_Street" /><br />
            <asp:BoundField DataField="State" HeaderText="State" SortExpression="State" /><br />
        </Columns><br />
        <AlternatingRowStyle BackColor="Gainsboro" ForeColor="#284775" /><br />
        <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" /><br />
        <RowStyle BackColor="#F7F6F3" ForeColor="#333333" /><br />
        <EditRowStyle BackColor="#999999" /><br />
        <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" /><br />
        <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" /><br />
        <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" /><br />
    </asp:GridView><br />
     <br />
    <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:TicketsConnectionString %>" SelectCommand="SELECT [Date], [Ticket_ID], [Dig_Street], [State] FROM [EMAIL_Tickets] WHERE ([UserID] = @UserID) ORDER BY [Date] DESC"><br />
        <SelectParameters><br />
            <asp:QueryStringParameter Name="UserID" QueryStringField="usr" Type="String" /><br />
        </SelectParameters><br />
    </asp:SqlDataSource><br />
    </form><br />

Binding a CheckBoxList

Dayekh6-Dec-06 5:21

Dayekh

6-Dec-06 5:21

Hi,

I have a CheckBoxList in a DataGrid. It doesnt let me input something like:

Me.chkList.DataSource OR Me.DataGrid.chkList.DataSource

Any Ideas?

Thanks.

Threading Priority?

Yona Low6-Dec-06 4:07

Yona Low

6-Dec-06 4:07

I’m creating a network application which consists of a server and client-both windows applications, for each client that connects to the server the server will create a thread to handle that clients requests. One of the features will need to have very accurate and fast transfers between the client and server, which means that the server will need to run very efficiently, since I don’t want to restrict the server to run on dedicated hardware I was thinking of making the priority higher, which brings me to my question:

Should I set each thread that handles a client to a higher priority, or should I set the process from the server application to a higher priority. And will I achieve better performance if I set both to a higher priority or setting one to high is the same as setting both (in other words, does windows have 5 levels of priority or 25 (5x5) levels of priority? )

Answers to any part of this post will be greatly appreciated.

Re: Threading Priority?

nlarson116-Dec-06 4:19

nlarson11

6-Dec-06 4:19

I think it would depend on what else is going happening on the server. if you don't have a lot of activity i would leave the priority where it is. i built an application that handles threads like you have for developers to "bounce" IIS when there is a vb6 dll that has to be replaced. I also through in IM and Chat for some extra features. I have never noticed any slowness no matter how much activity my server piece is getting and each response is close to immediate.

Problem in making setup in VB.Net

pathak786-Dec-06 2:13

pathak78

6-Dec-06 2:13

Hi,

I have a very large database and some rtf files near about 600MB all total.
Now I want to make setup in VB.Net. Setup completed successfully but it will take so much time at the time of installation at different positions like.
1. Preparing to Install ....... It takes a lot of time
2. After clicking Next Button .......... It takes a lot of time

If any one some idea or any third party tool, please reply me soon.

Thanks,

Re: Problem in making setup in VB.Net

MatrixCoder6-Dec-06 12:55

MatrixCoder

6-Dec-06 12:55

The setup files made with Visual Studio are always really slow. I would suggest using a stand alone install creator, like: Install Creator (simple) or NSIS (advanced). These are always faster and more customizable.

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