How To Create A Database Based On SQL
Mar 30, 2011I have the following problem. I try to create a Database based on SQL. But i have problems to get the connection open! I have following code:[code...]
View 5 Replies
ADVERTISEMENT
Create A New Database Based On An Existing One?
Feb 1, 2011I am working on a database application for my Class Reunion in VB.et and VS 2008, My problem is when i build the program it will only work with 1 Database For my Class year, I would like the ability to be able to create a new database for a different classyear than the 1 i build and pre-Populate, so the person using it can do more than 1 year and keep the databases seperate.
View 3 RepliesCannot Create Visual Basic Service-based Database
Aug 13, 2011When ever I try to add Service-based Database in Visual Basic 2010 Express Edition it just prompts me a message.
And if it means anything this error started showing right after I installed
Visual Studio 201 Professional test.
IDE :: Create Classes And Forms Based On A Database Structure?
May 10, 2010I am creating an Add-In that I want to create classes and forms based on a database structure. I can't find any information anywhere on how to programatically add code to classes. I know I can write out the files and add them to a project, but that would limit what I can do in the future. I would like the possibility to update a function in the future which would be impossible writing out a file and loading the whole thing back in. It would destroy any modifications made to the class, and since this Add-In will only be creating a framework, there will usually be modifications.
I got this line from the macro recorder:DTE.ActiveDocument.Selection.text = strDACode
But I like to keep Option Strict on, and this is late bound according to the IDE. There seems to be very little help on the IDE and how to use it creating Add-Ins. If I overlooked something please point me there, but I can find nothing. I don't know if it can be done, but I was able to do it in an Add-In for VB6.I would also like to add controls to a form, so if anyone can point me somewhere where it explains
Create A Login Screen Based On A Table In An Access Database?
Jan 23, 2011I have made an Access database complete with a report/form UI, however I am now looking to take this further to Visual Basic. In my Access database I have a log-in form to access some secure reports. I am now trying to do the same thing in Visual Basic, with no luck. I have created the UI elements i.e. buttons and text boxes, but am now stuck at how to implement the code.What I want to do is make the login button check what's in the username/password boxes with a table in my Access database.
View 1 RepliesCreate A Jpeg File In C:imagesFolder Based On The Image Stored In The Database?
Nov 19, 2009I have pictures of each employee stored in SQL database with Image database.
Select pic from empimages where emp_ID=10
give the picture of that employee in binary format.
How do I create a physical jpeg in C:images folder based on the above query in vb.net.
Create Dynamic Buttons At Run Time Based On Database Records And Implement Events For Them
May 11, 2010I have to create buttons at rum time based on database records and implement their events.
View 5 RepliesDynamic Sql Menu - Create A Menu Based On Items In My MS SQL Database
Aug 23, 2011I am wanting to create a menu based on items in my MS SQL database i have 3 tables
FormTbl
FormID - Int Eg (1)
FormName - nvarchar(50) Eg (Form1)
[CODE]...................
I can get the form names to be populated in to the menu and can open it my question is how do i set where the menu items will be placed. Eg File with FormHierarch 0 will be the very first one. Exit with FormHierarch 0.1 will be the very first one under File
Private Sub Main_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim menu As New MenuStrip()
Dim dst As DataTable = User.MenuItems(Me.ToolStripStatusLabel1.Text)
[CODE].....................................
Way To Create Empty Data Table / Update Its Contents Based On Columns Not Add Data Based On Addition Of New Rows
Apr 6, 2011I am creating a project in VB.NET in which one of the reports require that the name of employees should be displayed as column names and whatever work they have done for a stated period should appear in rows below that particular column.Now as it is clear, the columns will have to be added at runtime. Am using an ODBC Data source to populate the grid. Also since a loop will have to be done to find out the work done by employees individually, so the number of rows under one column might be less or more than the rows in the next column.Is there a way to create an empty data table and then update its contents based on columns and not add data based on addition of new rows.
View 1 RepliesVS 2008 Local Database Versus Service-based Database?
Jul 5, 2009What is the difference between a local database and a Service-based database? I read the MSDN and searched the Inet.
View 4 RepliesDatabase (access Database) Should Be Stored On A Web Based Server?
Aug 10, 2010I have developed some software(vb.net) that records fees paid by the students. The purpose is that the database should be stored in a server, which can be accessed from any stations linked with it.This is working fine with a network of 10 computers. I need to publish it over the net so people could do this job logging in over internet. Database (access database) should be stored on a web based server.
View 1 RepliesDB/Reporting :: Using Service-based Database As Remote Database?
Sep 20, 2011Recently working in vb 2010 express. I'm using service-based database which is based on SQL Server. This database will be deployed at the server. Is it possible that multiple vb.net programs, which are installed in remote computers or client computers in the same network, connect to this database simultaneously? Does the service-based database support multiple connections?
View 1 RepliesCreate A Class Based On Text Box?
Jul 4, 2009it is possible to create a class based on text box, add some code to its events, say gotfocus event, and visually add this textbox to a form instead of adding it in code. Just like we drag and drop a textbox to a form from toolbox.
View 5 RepliesCreate A LINQ Query Based On SQL?
Sep 25, 2010i try to convert this kind of sql query into linq in visual basic, but i get stuck on how to make a percent.. I also don't know how to use linqpad for creating this linq
SELECT CASE RIGHT(PICName, 3)
WHEN '(P)' THEN 'Problem'
WHEN '(R)' THEN 'Request'
[Code].....
Create Folders Based On Filenames?
May 4, 2011The code below creates multiple folders based on different file names and moves those files into the new folders. For example, files ABC and XYZ are moved into a newly created folder named ABC and XYZ. I want to advance the code to allow slightly different file names to go into a common folder. Example, I want file ABC_rock, ABC_soil, and ABC_water to be put into a folder named ABC still, AND file XYZ_rock, XYZ_soil, and XYZ_water to be put into a folder named XYZ. I do not want a separate folder created for ABC_rock, ABC_soil, and ABC_water.[code]...
View 3 RepliesVS 2010 Create A XML File Based On An XSD?
Mar 10, 2010My requirement is to create a XML file based on an XSD. The source data for this file will be coming from a database. For the purposes of this test, I am trying to manually assign the values.
I followed these steps:
1) Used the XSD.exe to create a VB Class.
PHP
xsd /d /l:VB emprec.xsd /n:XSDSchema.EmpCollection
2) Added the VB Class in my project.
3) If I try to compile my code, I get an error.
Here's the code I wrote:
VB.NET
Private Sub cmdXML_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdXML.Click
Dim emp As New EMPLOYEE_COLLECTION
[Code].....
How do I resolve this? I am unable to add any code in the 'TODO section for this generated class.
Create A Tree Based On Path Of Object?
Sep 20, 2011I have a bunch of objects, they aren't in XML but the xml document would look like this[code]...
The tree is obviously very deep. Does anyone have an algorithm to create this into a jstree, series of "UL" and "LI". It would be christmas if you had the code in vb...but I will be satisfied with just the logic. My thought is to eventually make this into a jsonp web service so I can use jstree to build a tree, but for now im just trying to understand the logic necessary to parse this correctly.
Create A Tree Based On Path Of The Object?
Jul 14, 2010I have a bunch of objects, they aren't in XML but the xml document would look like this:
<object>
<path>root</path>
</object>
<object>
[code]....
The tree is obviously very deep. Does anyone have an algorithm to create this into a jstree, series of "UL" and "LI". It would be christmas if you had the code in vb...but I will be satisfied with just the logic. My thought is to eventually make this into a jsonp web service so I can use jstree to build a tree, but for now im just trying to understand the logic necessary to parse this correctly.
Create Controls On Runtime Based On Templates?
Nov 28, 2010I am looking to create several custom controls (PictureBox Derivatives) on during runtime. I've read that the best way is to create template controls that will be created, and duplicate them in the Controls array.
Well, that's all fine and dandy, but what's the best way to store the template? I considered a seperate form with all the templates laid out on it for easy access for my editing, and keeping them out of the user's sight. I also considdered doing a Struct for each template, and smply mirroring values onto the control being created from the Struct to the created control.
I'm looking for ease of development first and foremost, as I'm most likely going to have a vast number of these templates, and keeping the system as simple as possible will eliminate a lot of hair-pulling. After development ease, I'd go for optimisation.
Create Custom Commands Based On Text?
Feb 17, 2010How could I create custom commands based on text? Like, say I have a textbox, and in the textbox is this: "say Hi". When I press the "Execute" button, it will do this: "MsgBox("Hi")"... Kind of like a custom scripting language... I want my application to support scripting, but I want the syntax to be simple... How do I go about doing this?
View 5 RepliesCreate Folders Based On File Names
Jan 2, 2009I have a directory with about 200 files in it. Is there a way to create a folder for each file with the folder name being the same as the file name minus the extension and then put the file in the folder.For example: Folder "test" would be created from file "test.doc". Then the file "test.doc" would be moved into folder "test".I have some experience with visual basic, and my thought process for this was: make a loop that brought in each file name > store as a variable > create folder with the name in the variable > remove the last four characters from the folder name > move file into the folder > clear variable > repeat.
View 9 RepliesCreate Text Boxes Based On Row Count?
Jun 21, 2010I have a form that needs to create textboxes based off the count of rows in my dataset table. The amount of rows could vary from 10 to 20, so I need a loop to add the textboxes to add the textboxes on load. Right now I have the loop down and other things shown below.[code]...
View 7 RepliesCreate Treeview Node Based On Url Structure .net
Oct 28, 2011am trying to pupulate a treeview nodes base on directory structure like this
[Code]...
The above code works for add base/parent node say i have a urllike this [URL] in this case, it should create a child node dir2 in parent node dir1 am getting confused add child nodes to the existing nodes
Forms :: How To Create Window Based Application
Feb 25, 2009how to create window based application in vb.net
View 2 RepliesHow To Create Image Based On Graphics Object
Feb 26, 2012In VB.NET, I need to create an Image based on a Graphics object I have. However, there is no method such as Image.fromGraphics() etc. What should I do then?
View 2 RepliesHow To Create Spreadsheet Based On Filtered DataSet
Jul 6, 2010I am trying to create a spreadsheet based on a filtered Dataset. The problem is I cannot connect to XL. I get the following error:
Warning1Namespace or type specified in the Imports 'Microsoft.office.interop' doesn't contain any public member or cannot be found. Make sure the namespace or the type is defined and contains at least one public member. Make sure the imported element name doesn't use any aliases.
From these lines of
Imports Microsoft.office.interop
Imports Excel = Microsoft.office.interop.excel
Another issue is I only have XL 2000, and I won't be able to get 2003 anytime soon. 2003 is what the target computer is using. I would like to develop the app with 2000 and make the appropriate changes to 2003 when I get upgraded. I couldn't get any information on the 2000 PIA here: [URL]. After reading this: [URL] it almost seems like I don't need the 2000 PIA. Many of the techniques described in this document involve the use of IAs for the Office applications.
For Office 97 and Office 2000, you can autogenerate these IAs using TlbImp. Office XP includes pregenerated (and optimized) IAs that you should use instead of autogenerating IAs. An IA distributed by the owner of the original COM server is called a primary interop assembly (PIA). You should always use the specific version of the IA that matches the version of Office you're targeting. I just want to develop the app. Then I can download the 2003 PIA, right? I would use this: [URL].
Name Txt File When I Create It Based On A Text Box Entry?
Jan 28, 2009Is it possible to name the txt file when I create it based on a text box entry?
If for example the text box was called variable, could I take the information in that text box and name the file that.
C# - Create Controls Dynamically Based On Dropdown Values?
Jun 12, 2012I need to create a sample question types web form in VB.NET which allow user to the following:he user selects the control type from dropdown (TextBox, RadioButton, ListBox etc). Generate controls dynamically based on the control type on the webform.It will always show the TextBox (where user writes the question) and (generated control - TextBox, RadioButton, ListBox etc) and save those values to the database.
View 3 RepliesCreate A GUI For A Command-line Based Exe Called Psftp.exe?
Mar 20, 2009In VB2008 I would like to create a GUI for a command-line based exe called psftp.exe which can be downloaded here and basic usage here.I need to be able to carry out commands on the fly for example...
On Click of Button1- Connect to host
On Click of Button2- Prompt for username
On Click of Button3- Prompt for password
As these commands all relate to previous commands, they need to be carried out in the same instance of the command prompt.I have tried using the attached solution from an older post however it just doesnt work when trying to connect to a host (it works perfectly fine when using the standard command prompt).I'd also like to read any outputs from the command-line so I can create events on errors thrown for example...
On Click of Button1- Connect to host
On Click of Button2- Prompt for username
On Click of Button3- Prompt for password
If command-line throws "Access Denied"- MsgBox(The password you have provided is incorrect)My alternative to this is to buy a SFTP .NET component .
Create A Loop To Call Forms Based On A Value In ComboBox?
Dec 1, 2010I am writing a program in VB 2008 and i need to be able to select different pages. i have a ComboBox with 15 values in it, and based on what value the user selects, that is the Form i want it to go to. for example, if i run the program and select the Value "electrical", then it will take me to the form that corresponds with that selection. [code]...
View 1 Replies