Including Excel Data In A New App During Build
Nov 26, 2010
I am working on a project for a local charity to build a library catalogue of their books/music. I have built the main form and database but I would like to include the data they have already collated in excel (over 1000 records) so that it doenst have to be manually input into the finished program.is there an easy way to do this, I tried a cut and paste from excel into the data table in my project but unless I'm doing something wrong it wont let me paste the data into the table.
View 3 Replies
ADVERTISEMENT
Nov 27, 2010
I am creating a Library Cataloging program for a local charity using Visual Basic.I have built the basic data table into the VB Project and I would like to populate it with the existing data that I have in the excel sheet containing the current catalogue. There are approximately 1000 records to import and I don't fancy inputing them by hand so I was wondering if anyone knows an easy way of porting the data across.
View 1 Replies
Mar 3, 2010
I'm trying to build an application to monitor a site to build statistics from the data being read. This HTML looks like this.
<div id="history">
<h4>HISTORY</h4>
<table border="0" cellspacing="0" cellpadding="0">
[code]...
Now I can read the html and put the text anywhere, I just don't how to read specific parts so I can separate the data out.
View 17 Replies
Mar 18, 2012
Is there a way to read excel file cells from vb.net including the font size, font color, etc
View 1 Replies
Jan 16, 2012
This is in ASP.net iwth VB.I have a quiz project that I've been assigned for work.This quiz project contains two main SQL Databases it pulls the info from. First is a Quiz table, which contains three columns: QuizID (Pri Key), Title, Description. This is where I declare the quizzes, indicated by the QuizID (1, 2, 3....etc)
The second table is the Questions table, containing the following columns: QuestionsID (Pri Key), Title, Answer1, Answer2, Answer3, Answer4, Answer5, CorrectAnswer, QuestionOrder, QuizID....The QuizID in the Quesitons table matches the QuizID in the Quiz table.Thus for QuizID = 1, it consists of all the questions with the matching QuizID in the Questions table. The CorrectAnswer I want to assign a simple value (1, 2, 3...etc).I need a way to take a set of questions (based on the QuizID) put them in some sort of table and randomize them (or rather shuffle them) so that each time this quiz is taken, it pulls all questions randomly, but not repeating any)...I then want the code to pull the question and coorepsonding answers to pick from in a radiobuttonlist. However, It only needs to pull the number of answers. Example, a True/False will only have Answer1 and Answer2. The other Answers will have the NULL value in it.
There needs to then be a way to go through each one of these questions that have been placed in the table (in that random order) using a "next" button. When a question and possible answwers are displayed, I alaready have code to keep the answers in the session to grade it at the end (using correctAnswer and selected answer.I have no specific way to bind the data to the Database. I have used SQLDataSource to make other connections before, but I don't know if this is the best way.
View 1 Replies
Dec 16, 2010
I am wanting to include data in my vb2008 deployment package.I have tried many different ways, but with no success.Even with the "click Once" method, also using the setup method.
View 5 Replies
Sep 13, 2010
In my app I present to the user an option to customize the name of the file that gets produced. The format string the program reads is something like "yyyyMMdd-%1-%2-%3-%4" which the user can customize to his liking. In this case the format of the date is yyyyMMdd and the %1 is the trip number like 1000P, %2 is the origin code like PTTTT, %3 is the destination code like PHYUD, and %4 is a secondary stop code like YYYY123. I'm having problems taking the actual data and formatting into the custom string. I believe its the date format that I'm getting stuck on.
So far I have
sOut = txtFormatPattern.Text
sOut = sOut.Replace("%1", "1000P")
sOut = sOut.Replace("%2", "PTTTT")
sOut = sOut.Replace("%3", "PHYUD")
sOut = sOut.Replace("%4", "YYYY123")
sOut = myDate.ToString(sOut) 'date is July 01, 2007
The output is "20070701-#1000P-PTTTTP12YUD (YYYY123)"
The problem obviously here is my last conversion. The string contains key characters that denote a part of the date specifically in PHYUD. So my question is how can I give my user the flexibility to format the output as they wish and then convert that properly?
View 2 Replies
May 14, 2010
I'm using the following to populate a listbox from a sql server:[code]Is Available returns true (It's a bit in sql) or false - Is it possible to replace this with something shorter, say a checkbox or tick image?Also, is it possible to only display actual data rather than the whole field including empty characters? I have a few nchar(30) fields, the above seems to include all 30 character spaces.
View 4 Replies
May 6, 2011
i am trying to build an application where a specified number of cells are spoken from an excel file. what i want is something similar to what happens in excel, once u click play one cell after the other is selected and spoken and it automatically moves forward to the next, speaks and so on... but if i use voicecombo/SAPI.spvoice the UI freezes! any ideas?
[Code]...
View 1 Replies
Jun 27, 2012
I'd like to give a homework assignment to a person learning VB.NET. I'd like it to use basic inheritance and a variety of data structures including queues, lists, arrays, or stacks in a windows forms application. I was thinking of a pizza-ordering application. This would allow them to utilize some basic inheritance and practice using .NET UI elements.
View 2 Replies
Nov 1, 2010
Im trying to construct a datarow from a dataset table rows collection and gets an error. [code]...
View 1 Replies
Apr 12, 2010
Im currently working on a major project for school that i can keep track of customers, giftcards, and primarily appointments. My current issue is how im going to build the weekly schedule page. I dont even know where to start with the ui let alone coding after that. Once i can figure out how im going to build i should be able to finish it from there.
Primarily its supposed to take info from the SQL database i have setup and from there populate the schedule on the screen. Its supposed to be like a weekly schedule with 15 minute blocks from 9 am to 9 pm for everyday of the week. The user will be able to choose the week to display from a datetimepicker control. The table holds each appointments date, time, length, cost, type, as well as an appt id for each appt and a user id to keep track of who the appt is for.
View 1 Replies
Aug 17, 2009
I am trying to build a boggle solver, and this is the way I want to do it.I have a list of 52000 words.I want to Put them into a list as follows.A b c d e f g h i j k l m n o ..... z..Then for each letter, If possible, put each letter.Eg. under m a e i o u y or for q [code]i will look at "a" and then "av" and "ae" and "at" and check if further down the line there is a possibility. If not then I will abandon that line.How will I be able to build this tree database?
View 14 Replies
Jan 16, 2010
Im currently trying to build a treeview from data like:
a.b.c.d
a.b.c.e
a.b.c.e.f
a.b.x
Which im trying to build into a tree like:
a
b
c
d
[code]....
(So splitting at the .)However, im havign trouble getting the tree to work properly..Ive tried like creating a root node, then splitting each line of the input at the dot, but i just cant get it to work right.
View 1 Replies
Jan 22, 2011
I am trying to retrieve the data from EXCEL 2003 spreadsheet from row 8 onwards because from Row 1 to Row 7 the row is merged columns from A1 to K1, A2 to K2, A3 to K3, A4 to K4, A5 to K5, A6 to K6, A7 to K7.
View 28 Replies
Oct 7, 2009
I am trying to read excel data (Excel 2007 SP1, on Windows XP SP3) with visual basic .net 2008 (VB 9.0 SP1). I have tried several attempts and whatever I do I am getting the following error message: System.Runtime.InteropServices.COMException was unhandled ErrorCode=-2147319784 Message="Altes Format oder ungültige Typbibliothek. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))" Source="Microsoft.Office.Interop.Excel" Message="Altes Format oder ungültige Typbibliothek." Translated: Old format or unknown type libraryI have added the reference "Microsoft Excel 12.0 Object Library" to my project. I am assuming that I might have to add a different or an additional reference, but I do not have any clue which one to use. List of things I have already done:- Searched other forums- Altered the language settings- Tried it on an other Computer (Win XP SP3, Excel 2007, Visual Basic 2008 Express)- Ran the diagnostics tool in Excel - Updated all updates etc...- Reinstalled Visual BasicI really do not have any clue why it should not work?
Imports excel = Microsoft.Office.Interop.Excel
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim xlsApp As excel.Application
[code]....
View 6 Replies
Aug 22, 2011
I created a VBA project in Excel. I would like to figure out how to transfer the data back in forth to make a more presentable and user-friendly program in VB Studio.Basically, I need my form in VB to input data to into an excel �workbook.data�, where the calculations are preformed. Then I need to copy the finished excel data cells �workbook.results� and paste them into an end result form in VB. I have tried looking at threads and cannot come up with a solution. There is no data saved each time the program runs, so I don't have a database.
View 14 Replies
Jan 6, 2010
I have put together an array for data from two text boxes to be stored in. This works fine at the moment. I am now looking to build some form of array that will have some stored data in it already, so that someone can select the information they require from a listbox.
View 7 Replies
Feb 15, 2012
I have a Form with a Media Player in it. Which plays a Song.
[Code]...
It's playing in the background since the Form is hidden. When I play itin Debug, everything works fine. When I run the app outside Debug, I get this error: [URL] The Music File is there, but strangely, there comes this weird error.
View 4 Replies
Jan 5, 2011
I have two tables in one to many relationship in an access 2003 database.I am using vb6 and visual studio 2008.I want a data entry form (in grid view) for child table. I want to display & add, Update, delete child records accordingly with parent.
i.e. What I require is One combo box displaying a parent field and corresponding child entries will be shown in grid view. Data entry form for parent table may be on separate form.Is there a full sample source code for above mentioned theme.
View 2 Replies
Nov 27, 2011
A particular VB.NET project is actually throwing 'Build Failed' But when I try rebuilding again it says 'Rebuild Succeeded'. It keeps alternating this behavior. Kind of random. Any vbc.exe issue of long locking the PDB or xml files?
View 9 Replies
Jul 30, 2011
I have a vb.net 2008 windows form application that I was just assigned to work on. how to maintain and test changes to both the pre build and the post build events? Can you tell me how to test these events? My postbuild event, I believe calls a project file in the solution file that wraps files together in a bundle in debug mode. Can you tell me how the posbuild event works and when it is called?
View 2 Replies
May 3, 2010
I am using 2008 Express Edition. I am trying to make a Release build instead of a Debug build.Under Tools->Options, Projects and Solutions->General - I checked Show advanced build configurations. The option to switch configurations does not show up in the IDE.
After this, I went to the Project Properties->Compile and switched the Configuration from Active(Debug) to Release.After building, I looked in my project directory, however only in the Debug sub-directory was the .exe and nothing in the Release sub-directory.I have used Visual C++ Express Edition, where I noticed that if you do not change to Release in the IDE than after changing to Release in properties, resets the project to the last configuration setting which is usually Debug.how to make the Debug/Release box available in the IDE, since Tools/Options does not make it show up?
View 3 Replies
Mar 7, 2009
I just created a simple application. I Builded that using build->build myapp. I got .exe of that application. i runned. all went fine. but when i closed that app, even after closing it is in memory. it is still running. how to deploy it properly?
View 12 Replies
Mar 10, 2010
I have a problem with importing an excel into a data grid.
Here is my code:
Try
Dim _Obj As New ExcelConnection.ExcelConnection
_Obj.ImportAttendence("c:Info_pc.xls", DataGrid1)
Catch ex As Exception
End Try
In the excel i have numers and text and "Service Pack", "Processor Speed" and "Numar procesoare(Number of processors)" and the values for these are numers. in the data grid when i import the excel those values doesn't appear, i receive the value "null".
View 7 Replies
Jun 22, 2012
I used to build data layer by using Classes, however someone suggest to use Strongly Typed DataSets because it's faster in development. The data layer that I'm going to build should support multi DBMS(Oracle,MSSQL, MySQL..)
View 3 Replies
Aug 17, 2009
I used to build data layer by using Classes, however someone suggest to use Strongly Typed DataSets because it's faster in development. The data layer that I'm going to build should support multi DBMS(Oracle,MSSQL, MySQL..).
how is better build it by using Strongly Typed DataSets or by using Classes?
View 3 Replies
Jun 15, 2010
does someone know if it is possible to build an application that store data in a folder locked by truecrypt where the application
1) create the encrypted folder
2) pass the password to read/write the data?
View 4 Replies
Aug 4, 2010
I have some very simple questions about making a release build exe in vb.net using MS VB 2010 Express.
I realize that my project's executable is built in the bin/debug folder. However, when I copy this to any other location on my computer or someone else's, this executable does not function. I have read that I need to create a release build but in MS VB 2010 Express, when I use the Project-Properties menu and change the Compile tab configuration to Release and the path to binRelease, I still get the exe in the binDebug folder and not the binRelease folder.
1) Is it normal that exe's from the debug folder do not function outside of the debug folder?
2) Most importantly, if the release build produces a faster exe, could someone please explain step by step how to do this with MS VB 2010 Express ? I do not see any button on the compile tab in the project properties that actually builds the release.
View 8 Replies
Aug 22, 2011
I wish to build and display a simple diagram that is built from data entered by the user. Because I can't post a picture of the types of diagrams here I'll use the following example. Image a picture of a house as a child might draw it a large square, with a triangle for a roof, a rectangle for a door, and two smaller squares for windows. Now I want to build an application that lets the user enter data and change that drawing according. For example, by entering the length and height of the house the size changes, change the number of windows, size of the door or height of the roof.
Now this may seem like a useless application but keep in mind the house is just an example the real purpose is different but should be as simply drawn. I'm looking for suggestions on make this work. Should I use a paint? or is something like this better done with a tie into the Visio references?
View 13 Replies
