Using Visual Studio .NET 2008 or 2005, is there a way to automatically generate properties for each column in an SQL Server database table? I am assuming other code-generation software exists that will do this. I know with Visio I can connect to my database and it will generate diagrams by table, this would be similar to that.
View 6 Replies
When I am developing an application and I use the 'Data Source' tab to create a database, will that database be automatically created when I use the software on another machine?
View 1 RepliesI'm bulding a program that willl work with a database the database is made with mysql.I would like to know if there is a way to install the DB automatically with the application without requiring the user to create a mysql server...the db have more than 5 million records.
View 3 RepliesMy project is about recipes. I want to automatically create table inside in mysql database when I hit the add button on my project through codes. First is when I input recipe name in the textbox1 then my input will be saved in the recipes table under recipe name column and also create a new table through codes on what i input in the textbox1
Example of my database in sql
texbox1 input will be save here
recipes - id, recipename
And then it will also automatically create a new table in mysql database, create newtable, with id, quantity ,unit, ingredients
Private Sub iadd()
Dim command As New MySqlCommand("insert into recipes (recipename) values ('" & TextBox1.Text & "')", connection)
Try
connection.Close()
connection.Open()
command.ExecuteNonQuery()
[Code] .....
I want to create a class (I think) that has properties that correspond to column names in a database table, such that they come up in Intellisense when I type the dot after the class name. Is this possible to do?
View 5 Replieshow to implement UI, BL and DAL in a project the way that I see it as a requirement for some projects. The way I am able to do a project now is from a form create an object of a class in which there are properties and functions that do database selects, updates and deletes. Looks to me that doing a project like that is separating the UI from the DAL. In an update button click event I may call Obj. Delete (txtCustID.txt) for example. I don't understand the part of further breaking it down to include a Business layer; in which a vb solution is made up of three solutions.What goes in the BL?Does the BL call the DAL?
View 2 RepliesI'm actually more comfortable in Java language for developing apps. But since my requirement now is getting tighter, I need to jump forward into VB.NET
well yeah... seems need to adapt some a bit. Anyway, I typed a lot for making this setter and getter properties inside visual studio;
[Code]...
My question is does Visual Basic 2008 Express Edition provide a way for you to create a SQL Server 2008 Database using the Database Explorer ?
View 2 RepliesWithin my project I have created an Entity Data Model, complete with relationship links between the various tables. I notice when I do so, Visual Studio automatically creates a property named after this link.
I have then generated a Domain Service Class based on this data model, and once again within this a property is generated representing the link, ie within my ChemicalApplication class there is a Chemical property of type Chemical.
The trouble is, within the silverlight client, I can access the ChemicalApplication data object no bother, and can see the ChemicalApplication.Chemical property, but as soon as I try to access it, I recieve an error that the property is not initialised.
Do these auto-generated child properties not automatically initialise? If not, how do i manually assign a value to them within the RIA Domain Service?
Migrating an old ASP site to .NET, and there's a load of VBScript we're porting to VB.NET.
Getting into trouble with the old property syntax, does anyone know of a tool (or other such magic) that could do this automatically?[code]....
create an SQL Server (express) database (.mdf).
most of the example in the walkthrough make use of the pre made northwind database(.mdf)
i will use the database that i will make to get connected from my application. the connection would client-server and what i have noticed, that this is possible if your database is an SQL version with extension filename of .mdf.
Or if its possible to create this database just using the Visual Studio 2008 Pro(90-day trial)
I've got a groupbox on my form. I changed its font and fore color. The problem is that when I add a button or any other controls like a label, checkbox etc to the groupbox, the controls are automatically changing their fore color and font to that of the groupbox. How to prevent this?
View 5 RepliesI have Visual Basic 2010 Express and SQL Server 2008 R2 (not Express) installed on my Windows 7 machine. In Visual Studio, I am attempting to create a Data Connection to a database in SQL server. Server Mgmt Studio is not running. When I attempt to add a connection in Database Explorer, to the AdventureWorks _Data database, I get the message "This file is in use. Enter an new name or close the file that's open in another program." There are no programs running except VB, except maybe for the SQL Server engine running the background.Please note that I can open and access tables within a database in code
within Visual Studio, I just can't add a connection in Database Explorer.Am I doing something wrong? I've been very frustrated on this issue for a long time
I was just wondering if it's possible to create an app that interacts with a database hosted on a web server... or is it only possible using VB.NET? Also if it is possible, is there any good documentation or tutorials I could reference?
View 2 RepliesI have a problem with attaching sql server database to an installer file.
View 1 RepliesWe would like to create a client-server architecture application that the server can control all client computers connected to it (e.g shutdown) and we would like to put a security login and a desktop lockeron the clients. The process of the system is that when the clients starts, the desktop is locked and ofcourse the user can't access the desktop unless he/she logged-in. And when the scheduled time (e.g 1 hour) is done, the client computers where automatically shutdown like the Time Logger Softwares
View 2 RepliesI've just downloaded SQL server express and have created a database in there. Now back in my VB.NET application from Visual Studio how do i find/connect to it?
View 16 RepliesI am trying to build a user control that will do exactly what the SQL 2005 Connect to Server interface do, eventually create a connection string and store in a app.config file. It should allow user to select server type, server name, authentication, user name and password. It should also automatically load available servers and domain login by default.
View 11 RepliesI am having problem with the date time. I am getting the time from the server in xml, when i try to assign the date which i get from the server to date variable it automatically converts to local time. Is there any way to prevent this conversion.
[Code]...
The company has a Visual Studio 2010 Ultimate project that is written in Visual Basic. The project has several strings in the resources file (Resources.resx). One of those strings (VersionSuffix) contains "" when we are distributing a normal version of our product and "BETA" when we are distributing a beta version of our product. Most of the time we distribute a normal version of our product. Therefore, most of the time the resource string VersionSuffix contains "".
Recently, we attempted to distribute a beta version of our product. Therefore, we changed resource string VersionSuffix from "" to "BETA". However, it quickly became apparent that the resource string VersionSuffix was being used as the default value for several control properties in the form designer. For example, if I draw a rich textbox on a form then file FORMNAME.Designer.vb will contain the following.
Me.RichTextBox1.Location = New System.Drawing.Point(286, 306)
Me.RichTextBox1.Name = "RichTextBox1"
Me.RichTextBox1.Size = New System.Drawing.Size(134, 33)
Me.RichTextBox1.TabIndex = 32
Me.RichTextBox1.Text = Global.PROJECTNAME.My.Resources.Resources.VersionSuffix
We are unable to find anything anywhere that indicates that this resource string should be used as the default value for control properties. Therefore, we have no idea why this resource string is being used for this purpose. We would like to change the control property assignments in the designer from Me.RichTextBox1.Text = Global.PROJECTNAME.My.Resources.Resources.VersionSuffix
Me.RichTextBox1.Text = "" However, we don't know why these strange assignments are being made. Therefore, as soon as someone adds another control the problem will most likely return. Does anyone know why this is happening and how to prevent it from happening again?
I'm trying to install an app on a windows server that is always on, but I'm running into problems. I've heard that I shouldn't make it a windows service (and would personally rather have a dialog app so I can see progress, etc) so I'm trying to use task scheduler. However, task scheduler keeps trying to close my app prematurely when it should only open it and leave it open.how I could have a dialog app run on startup (and stay running) on my server?
View 1 RepliesHow do I create a Login Verification routine (Login Form) in vb.net . i have an windows application with login form contain user name , password , ok button and cancel button .
as this one:
Imports System.Data.OleDb
Public Class LoginForm1
' OK button
[Code].....
but i want to run my application from desktop and will get confirmation if the user name and password correct by checking them in MS Access Database in the server.
so the the application in the desktop and the tabel of user name and password in the server.
how to work with distributed application in vb.net that automatically stored data into server? How to configure to ensure the consistency of data being stored.
View 6 RepliesI developed a chat application with an attendant chat server. Everything is working fine. The issue now is the fact that whenever the chat server goes down (for instance, the server system shuts down as a result of power failure or some other problem), by the time the server system come back on, the chat server would have to be restarted manually.
I believe (and I know) it is more appropriate for the chat server application to restart itself when the computer comes back on (and of course regardless of who is logged in and of course, even before anyone logs in). I have a batch file that executes the chat server. My attempt was to create a windows service that start automatically and runs this batch file using a Network Service account on the server system. Although, I'm having a hard time with this (temporarily), I would love to ask if there are any alternatives to using a windows service.
Is there a code for automatically creating an ellipsis at the end of the text of a group box's text property when there is a certain number of characters on one line?Bgeo99
View 2 Repliescreate a button that upload a file to a website -that website contain a browse button- but i want my vb button to upload a file to that site automatically
View 7 RepliesI have a few class with public function and I want to know if someone know a program that can create automatically Interface solution from the class?
View 2 RepliesIs it possible to create a web browser which auto use the https:// instead of the http://. For example: I open a facebook and the web is auto using the http://,, is it possible that the browser forced every action in the browser auto add the https://
View 1 Replies[code]..
How would you skip the process so the file is automatically created??
i have created a program to view images in a picturebox, i have created two list box's one for folder names/image areas to group certaint images and the second listbox to list the number of pages contained in the image folder/area. when the user creates a new image area, he or she can name it whatever they want, when they do that i would like to create a folder in the c drive for instance with the same name as the image area, and i would want it to create a .txt file aswell to keep memory of what they have done, so when they come back to it the next day they can just carry on from where they left off.
View 14 Replies
