I am using a stored procedure to fill a dataset with a large amount of data (47k rows and 8 columns). I am needing to fill two tables with the results of this stored proc.One table will have data representing 47k reps that currently have credit for a transaction. The other table will be a mirror copy of the 1st table with 47k reps that were supposed to get credit for a transaction. This application is going to take credit from one rep. and give the credit to the other rep record in the 2 mirrored datasets. It's taking 30 seconds for the data adapter fill method to return records to my application. I would like to reduce the amount of time it takes for this request to process.
Here's the contents of the stored proc:
Code:
ALTER PROCEDURE [spGetSalesCode]
@Period varchar(15)
[code]....
how I can better return a relatively large dataset to vb.net more quickly?
I am using a stored procedure to fill a dataset with a large amount of data (47k rows and 8 columns). I am needing to fill two tables with the results of this stored proc.One table will have data representing 47k reps that currently have credit for a transaction. The other table will be a mirror copy of the 1st table with 47k reps that were supposed to get credit for a transaction. This application is going to take credit from one rep. and give the credit to the other rep record in the 2 mirrored datasets. It's taking 30 seconds for the data adapter fill method to return records to my application. I would like to reduce the amount of time it takes for this request to process.
I was wondering which way would be the easiest in VS2005 to connect to and pull data from a MS SQL database. I have already setup the database connection by choosing the datasource for a DataGridView but I'm not able to retreive any information.
The steps I have taken so far:
1. Make new form
2. Drag and drop DataGridView onto the form
3. Setup the data source and respective username password
I have an Access table with a primary key. I want to add a row to the dataset and update. I get an 'Insert into' error.The fields in the Access database:
ID (primary key)
My code is as follows:
<code> Private Sub btnCommit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCommit.Click If inc <> -1 Then
I have an Access table that contains "Customer Number".
I have an ODBC dataset (iSeries IBM Client Access, or AS/400 data) with a customer table in it. I want to link the customer numbers in the access table to the ODBC table so I can show the customer number from the access table and the customer name, city, and state from the ODBC table.
I want to display this information in a grid. I also want to be able to add records to the grid (which adds them to the access table). What is the best way to get started doing this? I am using VB2005. I could use MS Access and have it done in about 2 minutes, but I want to take the plunge and learn VB2005.
But this VB2005 and .net thing seems like they re-wrote the book on programming and I cant seem to get a grasp on it. I have tried several projects like this in hopes of learning, but ended up abandoning them in frustration.
I want to write a program to do Markov chain, but my states are quite large. First of all I calculate all the transition probabilities and revenues for all states(1381860 total states), and store in a multidimensional array. Public RevArr(0 To 9, 0 To 750, 0 To 282) As Long
After that the iteration of markov chain should use these as inputs to calculate the steady-state probabilities. But when I try to run the main code I got this error.Exception of type 'System.OutOfMemoryException' was thrown.
The following is the declaration of second array I add just another dimension for storing all the iterations, but I get this error. Dim stateprob(IT + 1, 0 To 9, 0 To 750, 0 To 282) As single
Private Function currentv(ByVal version As String) As String Dim filePath As String filePath = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData) & ".minecraftin"
[Code]....
im trying to pull from the file located at: filepath & "rpgversion.txt"
and display it in the textbox2
as "0.5.3" for example
text which is located inside the .txt file rpgversion.txt
I also got as far as creating an XPath Query: (/main/SourceType/@ID) but for the life of me do not know what to do with it. Im trying to pull all source type ID's into an array of strings if it is possible!
I have a textbox where a user enters the time in minutes:seconds format. I want to take whatever number that is in front of the colon and store it in a variable called minutes, and whatever is after the colon and store it in a variable called seconds. I have everything declared and my code written, I just don't know how to take the text from a textbox and when the value is stored in my variable to only include up to the colon. I think it has to do something with the string remove method, and I can remove the colon, but I don't know how to get the characters after it. (and I can't use number of characters because I don't know how many the user will enter)
I've been having some trouble being able to pull the text from the monthly balance column and displaying in the textbox (remainbalancebox) beneath it, all I can make it do is display the text in the bottom left column, when all i really want displayed is the last text on the RIGHT column?
here's what I'm doing. I'm putting together a program that will allow employees that work under me to all submit shift reports in the same format instead of getting multiple different formatted text files.
I have a list box that they add "actions" they've performed throughout the day. It's populated by a combo box and some text boxes.I've got it all functioning minus one aspect...
[Code]...
Here's my problem... it's only outputting the FIRST set of items. The "Upgraded" accounts all list but the "Downgraded" and "Canceled" are not there.In a perfect world, I wouldn't ever need to worry about "Canceled" or "Downgraded" but... the world isn't perfect so,
I currently have an unlimited amount of columns and rows in a DataGrid. Pendinginformation from a user I would like to display every row from the datagrid into a checkedListBox but I only want to show specific columns depending on their column Names. Currently my code will display every row. My problem is getting only the selected columns depending on the name of their header.
The code that I have currently is: For Each row As DataGridViewRow In CSVInput.DataGrid1.Rows If Not row.IsNewRow Then
I'm trying to learn a little about pulling information from other applications and finding it pretty difficult to find what it is I need to do. Let me give you an example of what I'm trying to do and perhaps someone can point me in the direction I need to work in.
I want to read Ventrilo from my VB application, specifically I want to know when someone is talking in the channel I am in. That is my end goal. I can pull the handle using FindWindow
Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" _ (ByVal lpClassName As String, _ ByVal lpWindowName As String) As Long
I know this is pretty simple but Im a little stuck. I need to take items from a listbox and print however many items are in that listbox to a receipt. So far I have
For i = 0 To lstselectedtoppings.items.count - 1 lblreceipt.text = lstselectedtoppings.items(i) Next i
I know this is pretty close to what I need , what am I missing though?
Basically we're creating a multiform app for class with 3 different forms. its going to be a game. My startup form asks only for your name and your total units to play with. Then you're able to click a play button, which opens up a new form that will display your total units available (from the first form) and allow you to enter how much you wish to wager for that round.
I wish to know how to pull the info from my textbox (txtUnits) on the first form (frmWelcome) and have it show up in a label(lblCurrentGameStake) on my second form (frmMain).I thought about maybe putting the value in a string and then calling that on my second form but it doesn't work. Private Sub btnPlay_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnPlay.Click strStake = txtUnits.Text
I am pulling urls into excel, but excel formats the data. if a website displays 000.4500 excel formats it to .45.... i need everything exactly like displayed on the webpage, so excel should not do anything with it.
I tried formatting the worksheet to text (keep everything as entered exactly) and that did not solve the problem.
I can show code, but i'm not sure if this is a coding problem at all. I am just confused and can't seem to find any good information on this problem.
how to pull information from Access and display it on a form with many different txtBoxes. For example I have 2 Queires written as well as the "Fill,GetData" for the tableAdapter. I just can't figure out how to say txtBox1 you use Query1 and txtBox2 use Query2. I'm getting data in my text boxes just not that information I need to be there so I have it bound properly as well as pulling from the right column of the data base. I'm using VB.Net 2005 and a Access 2000 Database if that helps/matters
Im just pulling information from SQL and populating textboxes etc.My question is firstly i have an issue because i can figure out how to do it, and secondly is there an easier way of writing this.So my Issue, i wrote a function to connect to SQL and pull information back which is fine it fills DS(Dataset) and then i want to be able to assign the relevant information within the DS to the desired textboxes,
So what's happening is that I click the Edit button, type the updated values and hit Update. But the code-behind gets the original values not the updated values. I can't figure out why. It's always worked before.
Im trying to pull 2 bits of information form the access db.
My db sting is:
Shared Function GetLastPost(ByVal forum As String) As String Dim MyResult As String Dim con As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:Documents and SettingsperkinjMy DocumentsVisual Studio 2010WebSites
[code]....
but i want to get 4 bits of info from my db
Auther lasttime ID numrep
and im not sure how to display this within my page_load
How can I pull a word out of text and use it? I want to create a hyperlink and use the urls in the text. So for example if I have text that says: John clicked on the link and went to vbcity.com. How can I make the [URL] a url?
I need to build an application (vb.net or c# or a web application) that pulls financial stocks closing price
for that day.For example:
Input: DELL, IBM, INTC
Output will be a table with the closing prices (pps) of the stocks for that day.Im not sure where to start as far as to find a source that provides that information in a format so that I can extract and place it in Excel (or plain test file). Meaning where do I get the feed?
It's been about... er, how many years since vB5 came out? Since I wrote my most recent project, so I'm struggling to remember things and get used to the new VB2010 environment.
I am trying to figure out the best way to go about pulling information out of a table.
Top row: Mileage of a vehicle Left column: Year of a vehicle
The data it would then spit back out is the maximum term a bank will finance a vehicle based on year and mileage.
What would be the best way to pull that data? I'm thinking the easiest way to maintain the data is with an excel spreadsheet that is called by the VB app to pull the data, but I've never had to pull data in this format before.
