DB/Reporting :: Creating A SQL Server DB Through VB Code
Jul 1, 2008
I'm trying to write code to create a new database and then create tables within the database.
I'm running into a strange problem right now, which is the fact that I was able to create a new database ok on either the regular SQL Server instance, or the SQLEXPRESS instance. However, when I attempted to create a table, I got an error message saying that there is already a table of the same name.
When I tried to connect to the new database via SQL Server Management Studio, I could see the database. However, there are no tables in it! So, theoretically, I'm creating a brand new blank DB, so there should not be anything in this DB, right? and I should be able to create any tables I want in it!
Here is the code that I have so far:
[code...]
I just have one simple form with a button on it. The click event on this button calls the CreateAllDBs() routine.
View 6 Replies
ADVERTISEMENT
Feb 16, 2012
I was hoping to save some coding by using views to access my forms in VBInstead of using a very long query I was hoping to use
Code:
Select * FROM my_view
[code].....
View 5 Replies
Jul 5, 2008
I'm looking for some simple code that lets me create a Microsoft Access table via code.Currently all I do in Access is write and retrieve data from specific tables but now I want to be able to create them at runtime. Here is an example of the code I use to load some data just so you can get a feel of what I'm currently doing. Hopefully there is an easy way using the same rough way that I'm currently dealing with databases.
Code:
Public Sub LoadCareer()
Public rs As New ADO
[code]....
View 2 Replies
Feb 9, 2012
I have to create a project management application in VB.Net Framework 4 which should create a client folder in a public folder in Exchange server.
I think the only way to create a public folder is through the management console. Is there a way to connect to the Exchange server and execute the creation command file from the code but I do not know how.
View 1 Replies
May 2, 2008
I am starting to design in Visual Studio 2008 and I am designing a web application that connects to a SQL database. In VB6 I could create a record set and read its contents as follows.
SQLCommand = "SELECT * FROM Tablename WHERE field = '" & data & "'"
Recordset.Open SQLCommand, Database, adOpenDynamic
If Recordset.EOF = True Then
MsgBox "Record does not exist!", , "Record does not exist"
End If
Then I would Bind the fields data to, say a text box like this
Textbox.Text=Recordset("Field1")
I am finding dificult to do this in Visual Studio 2008. Does anybody know how to create a recordset in Visual Basic 2008 as described above.I have been reading a lot, watching traing videos, and researching on the Internet and I have not found any source which will explain how to do it.
View 2 Replies
Jan 8, 2009
I am writing an application in VB.Net, the application stores a number of images within the database and therefore the SQL database size gets quite large. At the moment I use a single database, however what I want to do is create a new database for each project within my application. I need some advise on the best way to proceed with this and also the best way to be able to create a new database for each project. Below is the approach that I was planning to adopt:
1. When the application is installed it automatically has a common database that comes with the application and this database is attached to the SQL Server, lets call this application "AppA" and common database "AppADB" Within the AppADB there would be a table called projectsTbl and in this projectsTbl it has a 2 columns called "projectDesc" and "projectDB". projectDesc would hold the description of a project and then the projectDB would hold the SQL database name for that project.
2. The user would login to my application and in the admin side of the application have a create project form. In this form he would enter the project description and also a 3 character code for the project. When the user OK's the form it would take the project descrption from the form and put this in the "projectDesc' field in the AppADB and then take the 3 character code from the form add this as a prefix to "AppADB" and put this within the "projectDB" field within the AppADB e.g. if the 3 character code was "SIM" then the projectDB name would be "SIMAppADB"
3. What I obviously now need to do is create a new database called "SIMAppADB" now what I was thinking was I could create a SQL database backup of a database that has the standard database structure that is required and then I can restore this .bak file (which would be in my application installed directory) to this new name, using the following code:
Code:
RESTORE DATABASE SIMAppDB
FROM DISK = 'C:Program FilesAppA Installed DirectoryDB.Bak'
WITH REPLACE, MOVE SIMAppDB_Data' TO 'C:MSSQLDATASIMAppDB_Data.MDF',
MOVE 'SIMAppDB_Log' TO 'C:MSSQLDATASIMAppDB_Log.LDF'
4. Then when the user logins to my application again, on the login screen he will see a list of projects from the "projectsTbl" table in the "AppADB" database. The user can then select the project they wish to login to and from this the application and extract the database name from the "projectDB" table in the "AppADB" database. I then can store this database name in my application and when the application needs to connect to the database it modifies the connection string to connect to the respective database.
View 1 Replies
Aug 2, 2009
I'm trying to create a database driven application using VS 2008. I want my database to be generic, i.e it shouldn't rely on the existence of MS Access or similar application. So how do I create such a database, add tables , values..etc?
View 7 Replies
Aug 4, 2008
I have looked around google and downloaded several program with no luck. I have a Microsoft Access 2000 DB which my web app connects to and now published the website with a MS SQL Server DB 5.0. I need to create the tables on it but its not deeming easy. The closest thing I got the creating SQLfor creating the tables was:
[Code]...
View 2 Replies
Dec 20, 2011
I am trying to load a crystal report from two tables but it seems that is not working.Here is the code to load the crystal report:
Code:
Private Sub InvoiceLoad(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[code]......
View 1 Replies
Jun 2, 2008
An order can have many OrderDetails, and a Product can be on many different orders. The OrderDetail table just has the OrderID and productID, so there is essentially a many-to-many between order and product).I have a form for the user to enter a new order. I want to have an unbound box that contains the names of all the products, and to be able to drag these names into a box under the order, to add a new OrderDetail record using the productID of the dragged order along with our orderID.
View 1 Replies
Mar 2, 2010
I am using VS 2008 standard edition to develop my first windows form application and it does not come with crystal components. I nedd to design few reports but I can't find any help on the net. In my vba application I create one form which accepts all parameters and based on parameter I build SQL statement and pass it to report data source. I would like to similar in vb.net, but all I see is cryatal. Can I create reports without Crystal?
View 1 Replies
Jul 25, 2010
will SQL statements that work in Compact SQL Server also work in the Express Edition of SQL Server?
View 2 Replies
Nov 25, 2009
I am creating a small admin reporting tool that gathers certain information on some PCs. Unfortuantly the user that is running the tool doesnt have access and I cant give access to those particular machines. What I have done is created a user on these machines that can get this information.I would like to then have the reporting tool run certain parts of the code as this user so the information can be obtained, without any intervention from the user running the tool. Can I hardcode this user into the code so that it runs the code as the user?
View 4 Replies
Feb 8, 2009
use the following code to create a database in ms access
Code:
'reference: Microsoft ActiveX Data Objects 2.8 Library
'reference: Microsoft ADO Ext. 2.8 for DDL and Security
[code].....
View 1 Replies
Mar 31, 2011
I am creating a reporting app that pulls information off of a Sql database and populates the data in a datagridview control (DVG). I am using tab pages (Tabcontrol), and I have about 10 tabs with within the control. What I have done is created a dynamic control that will populate in each tab page once the tab is selected. I am using a split container and in my split container.panel 1 is where all my buttons and search functionality will be. In my split container.panel2 to is where the main DGV control will be. I have got this to function properly, however now I am unable to add anything to my split container.panel1. I would like to add diffrent labels and buttons in the panel1 one without putting another panel on top of the split container.panel1, and also if i do this when I resize my container the panel will just sit there. I am using the selected index changed event to get my split container to show in each of the diffrent tabs
Private Sub searchTab_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles searchTab.SelectedIndexChanged
searchTab.TabPages(searchTab.TabPages.IndexOf(searchTab.SelectedTab)).Controls.Add(splitContainer1)
[code]...
View 4 Replies
May 5, 2010
I am using .rdlc Microsoft Reporting reports. I have a form with one reportviewer on it. What I want to use is a combo box where they select the report and then click generate, and it shows a specific report. I have this code so far that changes the report:
[Code]...
View 2 Replies
May 27, 2010
I have a vb.net program using the MS SQL 2005 Database.I use the SqlClient.SQLdataAdaptor to insert the records in DB.Whenever i load the program and then use the SqlClient.SQLdataAdaptor to insert record into DB for the 1st time, it will take longer time to load. But if I use the same SqlClient. SQLdataAdaptor to insert record into DB again immidately, it will take shorter time to load. However, if I wait for 5-10mins, then use the same SqlClient.SQLdataAdaptor to insert record into DB again, it will take longer time to load again.Can anyone tell me this loading is due to the SQL Server itself / the VB.net?Can anyone suggest me a way to check the reason of this loading? [code]
View 1 Replies
Sep 9, 2011
I'm new to VB, trying to learn how to connect to sql server. When running the code below I got this message from visual studio: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
[Code]...
View 3 Replies
Feb 14, 2008
I have a website that currently uses a MS Access database, but I have been asked to change it to an SQL Server DB. I used the upsizing wizard and have changed the association in the web site from c3.mdb to c3.adp but I get the error "unrecognized database format. I tried using the .mdf file
Code:
Sub Application_Start(ByVal sender As Object, ByVal e As EventArgs)
' Fires when the application is started
[code].....
View 8 Replies
Oct 28, 2009
I started coding my first "real" stand-alone desktop application in VB 2008 Express. I was led into believing that using SQL Express Compact Edition was the thing to use for my database since it would reside on each PC (laptops) that I installed the program on. I created all my tables and about 6 forms and all was going well until I came to the point where I need to display a grid showing data from multiple tables using what i think is supposed to be a view. Now the problem is that CE doesnt allow views. Here are my questions:
1. Can I convert my CE database file into an SQL Server Express file?
2. Do I have to re-write all my forms that are using the database? I am planning on creating my SQL Server Express database with the same table names and the same field names, data types, etc.
View 1 Replies
Oct 18, 2009
I use Ms VB 2008 express edition with SQL server express. I want to know what is the reference to be added to make a connection the SQL express database?
View 1 Replies
May 27, 2009
I have been having trouble finding a good way to do this. Basically what I need to do is take a query from a SQL Server Database and place it into a DataTable (or an array) for manipulation. I've got the connection and everything working, but none of the methods I've tried so far seem to work very well.I need it to compare data with an uploaded CSV file and post on a website.
View 1 Replies
Jun 30, 2008
I'm a newbie on the above title. I have read some documentations out there on the net but I feel I could learn more through a working sample.where I could set as a reference on developing or implementing sql server notification services in vb.net?
View 2 Replies
Mar 6, 2009
show me the connectionString of Vb.net 2008 to Microsoft Sql server 2005?
View 1 Replies
Apr 14, 2009
I'm at an absolute loss here, I've read so many different things.I just want to add new records to a database I created using SQL Server 2008 with SQL statements in Visual Basic Express 2008. But I can't even connect/get it to recognise the database I created.The database name is 'database.mdf' and is situated in the MSSQL/DATA folder. So far I've read I need to use this code;
Code:
Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=database.mdf"
Conn.Open()
[code]....
View 3 Replies
Oct 3, 2009
Connection between program and an remote SQL server. most of the hits were on VB6 and as you might see in the title I use VB.NET 2008, so let's begin:
[Code]...
View 6 Replies
Oct 17, 2008
I'm confusing between SQL Server and MYSql and Sql Quries Is the SQL Server database like access and Sql Quries is the language Sql like Select * From Table1?
View 1 Replies
Dec 8, 2009
I have developed a Windows Forms application using VB.NET and MS SQL Server 2005 Express Edition. My database name is 'AC'. I do not want ANY user, SQL Server or Windows authenticated, to access, read, write to, update, drop or take backups of this database, except this login 'Adel'. So my connection string looks very similar to:[code]What configurations should I make in the MS SQL Server Management Studio 2005 Express Edition to 'Adel' login, 'AC' database, and all other logins to accomplish this?Given the following:I do not own the server; my client owns the server. They have a domain set up (LAN network).They have ASP.NET applications running using other databases on the same server. However, these applications have nothing to do with my database 'AC' or login 'Adel'.Some of their applications do not specify 'User Id' in the connection string; they use 'Integrated Security=True'.
View 2 Replies
Jul 21, 2008
using VB 2008 Experess and SQL Compact Server. I find my connection string saved in my application configuration file, but when I refer to it by name I get this error message: Error 1 Reference to a non-shared member requires an object reference.
[Code]...
View 3 Replies
Dec 18, 2008
I have just installed VB.NET 2003 and I am trying to manage some databases using SQL Server 2005 Express.When I try accessing the database via the data connection tab, I get the following message.
Quote: You have connected to a version of SQL Server later than SQL Server 2000. The version of Visual Studio or Access that you are using was released before the version of SQL Server to which you are connected. For this reason, you might encounter problems.
Please check with Microsoft to see if there is a service pack that you should apply to Visual Studio or Office in order to get support for the version of SQL Server to which you are connected.You can continue but any new object types might not be enumerated, and it will not be possible to save any objects or database diagrams that you create using the Visual Database Tools.I can not add tables or manage data fields. Does anyone know how to get the patch referred to in the message above? I can not find it via google or this forum.
View 1 Replies
