I'm following some Microsoft tutorials and am having an issue quite early on. The video says to open 'Database Explorer' and then right click and 'Create New SQL Server Database'. The problem I am having is that, while the option to 'Create...' is there, it is greyed out and so I can't click it.
View 22 RepliesI generated SQL Server 2008 Database scripts. There are total 80 objects. The script executes successfully from sql server query. But not from .NET. That is I want to create the objects (tables and stored procedures) from there.If the database don't exist already in sql server, it fails. I have included the line
IF NOT EXIST (DATABASE)...
CREATE DATABASE DBNAME
But it simply don't work and the process fails while the code perfectly works directly in SQL Server.
Any work around this? Can I run CREATE DATABASE somehow?
I would like to creat database by access 2010 in design view i am using data type is Attachment. Then i want to connect this access with vb 2010 .. now how can effect attachment file Which code i can use?
View 7 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've been into programming, I've landed a job with a local company, the entire project the gentleman is paying me to do is incredibly easy, with one hitch, the original project I'm converting is built using access databases, for efficiency, and easier online transfer, I'm wanting to switch to using an SQL database, I've got plenty of experience inserting, modifying, and controlling an access database, but where should I start to learn how to essentially set up, create tables, and modify data within an SQL database?
View 5 RepliesIm Trying to create a NotifyIcon Program. I want this to basically be like a service that every second looks at a database to see if anything has changed this is the module thus far
Imports System.Data.OleDb
Module ModNtifi
Public conn As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\MyserverMyDatabase.accdb ;Persist Security Info=False")
[CODE]...
The Problem i am getting is that after the start procedure has finished the program closes. i want it to start the the timer and then keep it going till the user exits the program manually.
how to create a program that can access information held in an excel database and show it in a simple form.
View 2 Repliescreate admin form to register, Remove, Edit user accounts in the system connected to Microsoft SQL Server R2 2008 or access database ? any toturial videos or instructuions step by step ?
View 3 Repliesdoes VBasic allow a MS Access Database DataSet create a Stored Procedure or will it only allow SQL Database DataSet create SP...
View 4 RepliesI have produced an application which works with datasets but I now wish to provide the user the ability to add and admend records within the database.But i wish to do this in a seperate form.My current dataset instanciates classes onLoad.Should i try passing the Dataset to the new form class? although I have the problem where by when i pass the dataset to the form class using code below i get this problem:[code]Should i just create a create a new connection to the database and produce a new dataset for this form? or is there a better way to do this?
View 2 RepliesWhen 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 Want to develop a software like Yed.i just don know where to start.how we can create a workspace where i can drag and drop icons and create connection etc etc.
View 6 RepliesI have a project to do for one of my classes that i need help on. Its and extra credit so im left on my own. Project Create a program to allow a student to create there own schedule. what i am trying to do is create a checkedlistbox for the student to check classes they are taking, and need something else to pop up or to show in another box or listbox the classes they can take for the next quarter. I know it has to do with if then statements but i dont know how to write basically:"if (class is checked in checkedlistbox) then ( these are the classes you can take)".
View 2 RepliesMy 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 RepliesI create my database with SQL server management 2005 Express and i must connect my application elaborated with VB.NET2008 express when i go Tools-connect to database a window appeeas;it demands to set database name But the problem is: i create my database with windows authentification and i don't know the path of the database
View 1 RepliesIf I create a DLL using VB 2010 express can it be used by previous versions of of .Net (3.5, 2.0)? Will the DLL use .Net 4.0 components, which is what I want. I don't see a way to force that to be the case.
View 1 RepliesDont be afraid to spam the thread with things you can create.The more the better!
View 2 RepliesI created a SQL database using the migration tool.I am converting my access forms to VB.net (VS2008).I am wondering if I create a single dataset in studio to the database or do I create a dataset for each form (query)? I am trying to determine what the best solution is. Many of my forms have drop downs that are populated using queries from tables.
View 3 RepliesWith VB.net, I'm coding a simple application to get more used to the new .Net format.
I'd like to save all the information to a 'new' database file. how to create a database on the fly, once that is done i'll be able to connect to it no problem, but actually creating the file is proving difficult to work/find out.
Also, with vb.net and the newly created custom file, how can it be made to automatically open that information with the program?
Is there a method in installation to associate the file type with the new program? How can i check when the program loads if a database file has been 'double-clicked' (rather than just running from the .exe of the program) and proceed to load the data?
EDIT1 - Extra InfoThe windows application has many different fields and content etc, then i need to save that to a file that could later be loaded by 'double clicking'. I assumed the easiest way would be to create a mini-database for each unique file
With a Windows form that I would like to be a DDE server. I know that DDE is not natively supported in VS 2010/11 so I'm using the NDde.dll to add DDE functionality to this program.
Objective: Create a windows form to act as a Pop-up notification that has a textbox field. This textbox field must be selectable in order for users to copy a text string to the clipboard and paste into another program that does not support DDE.
Overview: A phone system has an on-screen agent program that triggers a pop-up form, the DDE Server, when an incomming call is presented. When the agent accepts the call the agent program, acting as a DDE Client, registers a DDE session, Application=phnserver and Topic=callerid. Then communicates an "OnExecute" command to the DDE Server followed by a number string. This string should be presented on the pop-up form in a text box. Once the call is completed the agent application will issue a command to close the pop-up form.
Below is my current code.
CODE:
I'm trying to use LINQ to SQL in Visual Basic 2010 Express.
It allows me to create the .dbml file, but in order to drag items from the Database Explorer window to the design surface, I first have to get my database listed in the Database Explorer!(this is a remote SQL Server database - not a local .mdf)
I already have a good, working connection string to the remote SQL Server database, but that doesn't help me when I'm trying to generate the DBML at design time.
Can anyone tell me how to get my remote SQL Server database identified in the Database Explorere window? When I try the "Add Connection", I am limited to Access, SQL Server Compact, or SQL Server Database File. If I try to enter the IP address & port of my DB Host I get a 'database file does not exist' message. Doesn't seem to want to let me point to a remote DB server...
it's just for a program registration. i would store all of the registration codes in the access database, then export it to XML, then upload it to my web host. I would then somehow connect it to my Visual Basics login form (Which I have already made). If this can't be done, having them register through the form and having all the allowed codes on the internet (So i can easily edit them)!
View 5 RepliesI have made a database application that uploads a database via FTP here is the code:
Code:
note this line:
Code:
ContactDB.mdf is the database in my application what would i have to insert for it to upload the database i have tried it as it is and its failing i could locate its full path on my machine that works but what happens when i want the application to go on someone elses pc?
I programmed an app with an Access 2010 database, I installed the app and the database on a computer with office 2007. The app can't open the database. Do I need to copy some extra file on the user's PC?
View 15 Replieshow to create a database programmatically in VBtajinder
View 3 Repliescreate a SQL database from .net?
View 11 RepliesI have an FTP website that I created using Visual Web Developer 2008 Standard and I'm just now needing to store some data on it that would be accessed and modified by my winforms app. I added an SQL database to the website but found that an addon is necessary from the hosting service that I use that costs $ 10 a month. I was considering creating my own non SQL database.
For those of you that know about this subject do you think that it wouldn't at all be worth it to try. Should I just pay the extra $ 10 a month and use my SQL database or should I attempt to create my own non SQL database. If I did create my own non SQL database what are your suggestions. Could I make it secure and what would be the best way to communicate between my winforms app and my website database. The data I would be storing wouldn't be that much: User email addresses, some 12 character codes and a few other things perhaps.
I have been reading all about filling controls with information from the database but I can't find anything that really covers the simple question.I want to create a database with 4 different table names. Each table will be holding information from information the end user submits on my form.All I need in the database is tablenames so I can have the corresponding datatable control column on my form display data that is populated through my application.
View 1 RepliesI'm new to this VBexpress and programming but I would like to learn it.I have tried to follow avideo from Beth Massi on how to create database
at some point she right kliks and choos relationship.I dont have that at all...I cant even rightklik nad have something to choose..I can se that in the video there is an older version of VB and SQL.
How to create a database for medical shop database. m also getting the error unable to fit in memory.
View 3 Replies