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.
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.
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.
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.
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?
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.
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?
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.
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.
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?
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.
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.
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
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.
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.
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.
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.
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?
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?
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?
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?
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".
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..)
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?
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.
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?
