I want to select just the Year from that DOB and display that on a Listbox (or any appropriate interface on a page). We are not using SPs. So I will probably coding SQL directly from the page or using SQL datasource. Using LINQ is alright if that can be done in it
View 4 Replies
I'm trying to connect from VB 2008 Express Edition to a database in an instance of SQL Server 2008. Both, VB and SQL Server are running on the same machine. From a VB project, when I try to define a new Data Connection I find just three Data sources available: [Code] I selected the last one but when I browse for the mdf file I cannot select it because it tells me that the file is in USE. I have stopped all the services but still I'm not able to link the database file.
Two questions: 1. Is there a way to connect to the SQL Server Instance and from there to select the desired database? 2. How to connect using the Database file.
how do I deploy a SQL server database program to a machine thats I don't know the name of the machine. tried using "server (local)" but still.
View 6 RepliesMy application needs to be able to be pointed at different SQL Servers and different databases and I would like to provide the end user with a nice method of selecting both the server and database (the app is for use by other IT staff).Ideally, I was thinking of allowing them to browse to the server (with possibly entering credentials or even better, using their Windows credentials as the databases in question should be accessible to the relevant people via their AD account), and then listing the databases on that server allowing them to select one to use.
I would like them to then be able to easily change the server and database whenever necessary.I imagine I would then need to build the connection strings based on what they select but at the moment I have got rather stuck in just trying to create a form with some kind of Server Browser (I've not got as far as a database browser!).Failing some kind of server/database browser options, I would change to some simple text boxes where the user can enter the name of the server and database directly with some kind of connection verification button.
Finally, is it easy to connect to multiple databases on the same SQL Server at the same time? Is it just a case of creating and referencing multiple connection strings?I am using VB 2008 Professional and SQL Server 2005 Standard.
I am creating a very simple Voting System, that will be use on electing new set of officer in a teacher cooperative...
So I have to create two separate program, a Server Program that will manage all the information in the election and a Client Program where voters will vote their selected candidate...
The election officers wanted that the Server Program will display the Voting Results at real time... So when the Voter finished voting, The Voting Result displayed by the Server Program will also be updated every time the Client Program Insert the data to Database....
An action listener in Server Program that will execute if new data is inserted in a Table in the Database made by the Client Program...
before re-inventing the wheel, i want to ask you how i can do this best: I have a VB.Net application that uses a database connection to MS SQL Server 2005 (express version). There are users that input data with the application into the database lets say once to 2x an hour to once a minute. I want to do backups like this: Once a day or once a week (in the evening) a full backup, and whenever the program/user is idle for lets say 10 Minutes, i want to do an incremental backup (so that it does not take so long until he can work on after the backup).
There are no big security issues, just copying the backup data files to a network share / a different computer or server would be fine. i guess the average db size may be 300MB, but the daily increments about 1MB.
[Code]...
Multi-User Chat Program (Server & Client) with Main Server?
View 1 RepliesI have developed a VB.NET program using a strongly typed dataset. This dataset has its connection to a SQL Server 2008 R2. The software should now be additionally used offline. The database should be exported to a *.sdf database. If no connection to the SQL server is produced, the software have to try to connect to the *.sdf database.I would like to achieve:
1. Export the data in the SQL Server 2008 R2 database to a local *.sdf file.
2. This *.sdf file has to work as an alternate connection string in the strongly typed dataset.
I do have a program that uses MS SQL Server as database. The problem is that when the fire wall of the server is on, I can't connect on the server. But when i turn it off, it works! This is the connection string I'm using:
myCN.ConnectionString = "Integrated Security=SSPI; Persist Security Info=False; Initial Catalog=BIOMETRICS; Data Source=SERVER"
myCN is a SQLConnection...Please if can help me with regards on this problem.
Does anyone has a sample code that do like,Open and select excel file and select the exact excel sheet to import then connect to SQL server 2008 and append all the data from the certain sheet to the SQL table?
View 8 RepliesI'm trying to generate a query dynamically using textbox values from my Bookings form to update only those values that were entered by the user.[code]...
View 1 Repliesi need to select some records from table Tr_cashbook between two date. the date field is newdt in which i need to compare data and the records should be shown in crystal report named rptCash2. the newdt field has datetime property. here is the code on the command button
bdcon.Open()
Dim QueryString As String
QueryString = "Select * from Tr_Cashbook where (Cast(newdt as date)>= " &
[Code]...
but this is not working when i press the command button it gives error as operand type clash: date is incompatible with int.
I have a problem here... I'm using SQL Server as may database and developing that database in Visual Studio 2008.my problen is, when I use the STORED PROCEDURE from SQL SERVER it doesn't update/save new data on a the table. here's my coding; This is my stores procedure: when I execute this on on SQL SERVER it worked perfectly.
[Code]...
How can inserting picture to picture box from sql server database to vb.net2005 program at run time?
View 1 RepliesI am developing a vb.net application in SQL server 2005 ,now i would like to import MS access database tables from a network into sql server 2005 database, using stored procedure or vb.net code without using SQL server 2005 Wizard .
View 1 RepliesI'm developing a remote control program that uses a mysql database as the bound beetween the server and the client.The only problem is that cause of mysql being really varnuable to crashes i made it in a way that it checks for information every 10 seconds so things doesnt get messy. [code] For some reason after 10 seconds the connection is mysteriously aborted and the reader gives a fatal error.How can i extend the time limit to >10 seconds ?
View 3 RepliesI used the given below code to find the items of listview in my form[code]...
View 2 RepliesI posted a while ago about having issues with a database, and selecting a value from the database. I was told that there were things missing from my code, and I've not gone back and added the things I was advised to. Now, my code seems to be working more, but outputting the wrong value.
[Code]...
When I try to run a program I've written from a network drive on a windows server 2008 machine it always gives me: Open File - Security Warning The publisher could not be verified. Are you sure you want to run this software? Unknown Publisher This file does not have a valid digital signature that verifies it's publisher.... I need this message gone.
View 2 RepliesBack up my entire database using vb.net. I'm using SQL Server 2008 R2 for my DB.
View 39 Repliesis it possible to build "vnc enabled" programs using .net?The idea would be to allow several threads of some custom program to be controlled by different persons.
View 5 RepliesI'm following this example:
[URL]
I've basically converted the classes to VB.Net. Now when it says create an application to call the wrapper class called Program I get lost.
How do I call that class from my application that I want to embed sql server express with?
I am trying to connection to MS SQL SERVER 2008 database (students), i want to make sure:
1) If connection string that i made is OK
Dim connectionString As New SqlConnection("server=X86ONX64; database=students; Integrated Security=True")
2) How can i check if dataset is producing any results?
Code:
Public Class Form1
'Connection String + DataAdaptor + DataSet
'Declared Outside Any Subroutines/Functions
[Code].....
I created some database already in my SQL server 2008. And im planning to show all this data via graph using VB.net..Is there anyone here can give me LINK, thread or the best is tutorial so that I can begin doing it.Usually my data is based on date only. So once the date inputted then it will SQL and get the exaxt data in Graph format.
View 3 RepliesI am trying to run this seemingly simple piece of code which is repeated several times all over the net, but I am getting errors in the code:
Imports System.Data.SqlClient
Imports Microsoft.SqlServer.Management.Smo
Imports Microsoft.SqlServer.Management.Common
[code]....
I have an application that accesses a sql server 2008 database. The server and database is stored on my local harddrive and I would like to learn to scale this up to having multiple users in our office access the application which I will i deploy on a server. For now the database will stay on my pc until I am ready to put it on a dedicated server for myself but for now how do I allow the application still to access my database without allowing anyone direct access to my server or my pc drive. Here is my current connection string:
[Code]...
Imports System.Data.SqlClient
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
CreateDatabase()
End Sub
[Code]...
I was creating an enrollment system for my Thesis, and my adviser told me that I must have a Code in my program that Synchronize database from client and server so that if the terminal connection is "Up" the data will go to the server and if the connection is "Down" the data will go to the installed server on the the local machine. and every 20 mins or 30 mins will sync the database.
View 5 Repliesrow in datagridview not come all when query from database (sql server 2008)?
View 4 RepliesI am trying to store a .png image inside a database using SQL Server 2008. I have done this just fine using mySQL but for some reason it looks like this when placing it into ms SQL Server:
[Code]...
