I am using the Print Document to create the impression in vb.net...Anything I set a certain number of records per page however see the other pages just like the first,some help to handle these records correctly in the leaves?
View 4 Repliesim looking for the method how can i copy from original sheet to my new sheet.
View 3 RepliesI'm creating a program that displays data from a Access database in DataGridView, and I'm able to "call" the database and display it in datagridview normally, but I need to be able to take the data from 3 separate columns and average them together, within VB.
My table basically displays 3 grades for a student, one column for the student's name and the other 3 columns for 3 separate grades, I need to be able to take the 3 grades from the same row and average them together, then display them in a separate column within DataGridView.
Here is my code so far, but this only displays all the records without the average:
Quote:
Public Class Form1
Sub UpdateGrid(ByVal sqlStr As String)
Dim dt As New DataTable()
[Code]....
I have developed an application using VB.NET, Visual Studio 2008 and the SQL Server database. Now I want to ignore the database (it has 1 table as customer (name,password,hour,minute)) as I don't want my client to install SQL Server separately or other overheads.I am planning to do the whole using file handling in VB.NET (manipulating the data in files itself, for example change username, password, etc.). As I am new I don't actually know the proper way and of course need assistance.
View 4 RepliesThe products file contains data such as prices and the product used such as TV. I want to be able to manipulate the data in the product and location file so i can set different products to different location types.
View 5 Replieslooking for simple code for adding, deleting, editing, and updating data using binding navigator in vb 10. first time using, been using vb6 and code is totally different.
View 1 Replies I'm trying to write a vb.net application that works with a 3rd party application called FuzzyTech. Unfortionalty FuzzyTech is quite old so the only way I can interact with it is buy using DDE. FuzzyTech acts as a DDE server. After a bit of research I found a library called NDde which enables me to use DDE. I understand that vb.net does not natively supprt it as it is an old technology.
Now fuzzyTech seems to only respond to the DDE connect and pokes when in debug mode. The only way I can find to get the program in to debug mode is from the menu bar (Debug > Interactive). So I have written an application that runs fuzzyTech, grabs the window and then accesses the menu to put it in to debug mode. My code can then use DDE. I have all of this working ok (although it does feel like a bit of a hack). The problem is I don't want users to be able to see this happening.
I want fuzzyTech to be hidden.After more research I found I could hide the window on startup by using fuzzypProcess.StartInfo.WindowStyle = ProcessWindowStyle.Hidden. However when I do this my code to grab the window and send the menu commands then fails. I think this is because the window title becomes blank when hidden.So I need to know a way of controlling the program after it is hidden or hiding it after it is in debug mode. This is where I am stuck. I'm very new to programming and this has got me completely stumped.
Here is some of the code I am using:
Private fuzzypProcess As Process = New Process()
Private Sub LoadFuzzyTech()
Try
fuzzypProcess.StartInfo.FileName = projectPath & projectTitle & ".ftl"
[code]....
I have a VB.Net application that populates an Oracle 11g global temporary table. I can see data in the temporary table by loading it into a grid and everything looks correct.However, when I call an Oracle stored procedure from VB.Net that would manipulate the data in this temporary table, the stored procedure reports that my temporary table is empty.I understood that data in an Oracle global temporary table should be visible to all sessions.
View 1 Repliesthis is not really a code issue, more of an events issue with objects. I want to be able to generate an output as the user inputs into each text box under the "further invoice details" section. For example, if the user inputs a value to amountrequired text box. Then a gross total is auto generated without the need to click a button.
[Code]...
I have an project which was written in VB6 and made use of the Spread3.0 component to display multiple large data from database in spreadsheet. My objective is to convert this project into a VB.NET current version which would not use the third party component but can possibly use a freeware that does similar if not all the functionality.
My question is, are there any freeware that is available in .NET for such spreadsheet-like manipulation of data programatically? I have come across dsoFramer but this only allows the display of the data in an IE frame. I would like to jus embed the content into my existing form.
Also this freeware must be able to handle formula and user-editing as well as multiple cell type such as combobox/checkbox etc.
I have an project which was written in VB6 and made use of the Spread3.0 component todisplay multiple large data from database in spreadsheet. My objective is to convert this project into a VB.NET current version which would not use the third party component but can possibly use a freeware that does similar if not all the functionality
View 1 RepliesODP.NET Query - Error manipulating data from Stored Procedure??
View 3 Replies[code] objExcelAppDataSheet is the excel application's object and strTemplatePath is the path of the excel file.This excel file is like a template that i am using in my application. In this file some cells are merged. After copying to the new sheet the formatting of the sheet does not remain same. Columns sizes are changing. Why this problems occurs? Is this MS office versions issue??
View 2 RepliesI am developingreports in thePrintDocument andI emergedasadoubtin the image belowinformation from the PorcentafemProprietário( Percentage /Ownerdoes) notappearCod'sonly33what Iwould like to happen
the limitof this informationwould be 100%.Anyone knowany waytodetract
fromthe informationthat the reportcorrectlyPercentageDisplay/Ownerin
accordancewith its Cod?[code].....
I'm programming a calculation program of an heat exchanger(HX) with the VB2008. I have finished the calculation part and now have some questions about creating its data sheet.In a HX, heat will transfer from a fluid to another, which is cooler than the 1st one. I have these fluids as objects and would like to create a data sheet, that looks like:[code]all parameter in the sheet are calculated and saved as properties in thier fluid's objects. The sheet should be able to see on the MainForm, to print (+ a company's logo) and to export in .xls (with out excel). My question is, which function will help me to do these? the Crystal Report?
View 1 RepliesI need a code to read a omr sheet without using a specific omr sheet reader. i want to use normal scanner for this.
View 2 RepliesAm devoloping a windows form application which need to retreive a particular column from Excel sheet and i want to display that data in a dropdown menu.
View 1 RepliesI want to get data from excel sheet using visual basic.
View 9 RepliesI attached an image in which u see the data in excell sheet. I want to define a array in vb.net what type of array i define which cover all the data like show in image.I mean how many dimensional array i use? line of code to define how?after defination is it possible to fill that arrays programetically or need to type of values?
View 1 RepliesI use VB 2008 express edition. how to import data from an excell sheet into VB but i couldn't find anything and therefore I decided to ask for help here. Firtly, let me explain you my "problem". Let's say we have an excell sheet with a number in the A2 cell and another number in the B3 cell. I want to make a program in VB that makes calculations with the values in the A2 and B3 cell of the sheet. Tis is just an example though. Of course I want to do more copmlicate things than doing calculations between those 2 numbers...
View 3 RepliesI've got a problem since I have one form with some text boxes getting data from an Excel sheet and other text boxes getting data from other sheets from the same Excel file. And when I choose a product no I would like that all the text boxes retrieve data referring to the same product no.
View 4 RepliesI retrieved data from access in vb10 between two dates and here is the code for dat:
Imports System.Data.OleDb
Public Class Form4
Dim con As OleDbConnection
[code].....
I have a VB.Net application and once the data in the Gridview is populated I require it to be exported to an Excel sheet. Access (.MDB) is the database used.
View 2 Repliesto setup daily import of data from excel file into SQL database - preferrably through Visual Studio project (Visual Basic 2008). The problem is that I wouldn't know the name of the excel sheet. The excel file is created daily from different software and depending on amount of data on certain day - could have the sheet named as "Rows 1 to 5000" or "Rows 1 to 15582" and so on - therefore can't use 'Sheet1'. What is the easiest way to import data into SQL table? I'm still learning SQL and Visu
View 1 RepliesI'm a beginner in VB.NET and I use VB 2008 express edition. I was searching in Google for a tutorial on how to import data from an excell sheet into VB but i couldn't find anything and therefore I decided to ask for help here. Firtly, let me explain you my "problem". Let's say we have an excell sheet with a number in the A2 cell and another number in the B3 cell. I want to make a program in VB that makes calculations with the values in the A2 and B3 cell of the sheet. This is just an example though. Of course I want to do more copmlicate things than doing calculations between those 2 numbers..
View 4 RepliesI have an excel sheet that contains 25000 phone numbers listed in one cell with no sorting order. I want to create a small windows application that can read the sheet and return the total number of the phone numbers and how many duplicate numbers as well as the number of times of repetitions. How I can resolve this issue? What is the best way to approach it? I'm using VS 2008 and VB.Net.
View 14 RepliesI am coding a School Management System.
I want to use Excel as its reporting tool.
How would i go about doing it?
The person will give custom variables to output the data.
eg. Year 2010 - Entire Students for class 5 with girls only etc
how to go about connecting to an Worksheet?
i need code to copy data from text file to excel sheet. please help me out. need copy function.
View 2 RepliesI'm retrieving data from an Excel sheet, using a simple SQL query using a textbox as input to my variable. It works great when I enter an integer to search for (such as 213 for example) but when I put in a mixture of numbers and letters (48A for example) I get the following error: Syntax error (missing operator) in query expression '[P&L]=48A'.
Private Sub MPLS3()
Dim BrNr As String
BrNr = TextBox1.Text
Dim stSQL As String = "SELECT [MPLS Date] FROM [Master Data$] WHERE [P&L]=" & BrNr & ";"
[code]....
i already know how to save in excel using openfiledialog. but what i want to happen is that when i save another file, i want it to be saved in my existing file but in a different sheet.[code]
View 1 Replies