I have recently installed SQL SERVER 2008 Express edition for learning purpose. but I am unable to find SQL Enterprise Manager in the START Menu. It wont come with Express Edition?then, how can i create/manage databases. I am a starter in .Net. Anybody please help me.for your info, i have installed SQLEXPRADV_x86_ENU.exe - sql express with advanced services?
View 2 Replies
My sql statement adds details of a new employee returns a @employeeID. I need to retrieve this @employeeID to display the details of the newly added employee in my viewprofile.asp.vb. How do i go about coding the VB to retrieve the @employeeID from the SQL and include the @employeeID variable in my VB code so that it displays my newly added information?
View 3 RepliesI am using vb.net in vs2010.I can't find the Microsoft.SQLServer.ManagedDTS.dll. How do I add that dll to the reference?
Imports
Microsoft.SqlServer.Dts.Runtime
I am trying to connect to SQL SERVER 2008 from vb.net but failed with Error 40. If I try to connecton to serversqlexpress, error 26 is raised.
View 1 RepliesI have a function that will allow me to edit the manager property of a user here:
Public Shared Sub SetManagerProperty(ByVal de As DirectoryEntry, ByVal pName As String, ByVal pValue As String)
'First make sure the property value isnt "nothing"
[Code]....
But what if the manager is not in the Company OU? How can I edit this to search for him in the entire domain?
I am going to start project in VB.net using MSV.Studio-2008. In that I want to use sql server that is provided with MS visual studio. How can I use it and how can I create database in that server. I dont have any separate sql server installed in my PC except provided my visual studio-2008. Is it possible to use it? how to start with and how to make connection in such case?
View 1 RepliesSqlserver Table1 has following data
CODE:
I want to get following result
CODE:
That is grouping on date.
What command should I write to get above result
I just made an application using MySQL for the database. I use WAMP.Can I combine WAMP and my application installation into one packet installation ?
View 2 Repliescurrently i am doing a billing system project using vs2010 and sqlserver 2008. i got 2 form, one for invoice & one for delivery order, and a button to submit the invoice details to DO form.
would like to ask a few question,
1) once i add new transaction, the invoice number will be auto increment and save all details into database table.
2) the invoice number cannot use again even after the transaction being canceled.
3) how to make the DO number and invoice number the same as per transaction done / undone.
How can i call sqlserver 2008 user define function in vb.net?
View 1 RepliesI currently have a sofware with 80 customers.All share the same database structure, when data are differents.We got 5 database for each customer.Today, we have named instances, so the program is accessing to Bdd with something like :
Connect to 127.0.0.1/CUSTOMER1
select * from base1..table1
Now, we need to change, we got many instances.The idea is to have unique SQLSERVER instance, obviously i want to avoid changing the code (VB.NET).Just tried to play with schemas and users, seems to be an option, but since the schema is under the database, in can't make it works :
Connect to 127.0.0.1/GLOBAL_INSTANCE as specific user (customer1)
select * from base1..table1 -> error @ this point
When THIS works :
Connect to 127.0.0.1/GLOBAL_INSTANCE as specific user (customer1)
Use Base1
select * from base1..table1 / or select * from table1
I can easily script some user or schema creation, and change connection strings for all customers, but i can't really change All requests: huge number.
I seem to have a major problem. when I add a typed dataset to my project and go back to my sql server and click on the databse I use it doesn't open. the tables and stuff just vanish. using the wizard, it creates this connectionstring:
<add name="Schenectady.My.MySettings.SISQL2ConnectionString"
connectionString="Data Source=.SQLEXPRESS;AttachDbFilename="C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataSISQL3.mdf";Integrated Security=True;Connect Timeout=30;User Instance=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
It connects fine. but after I try opening it in sql server i get an error. It doesnt let me restore or anything. i tried restarting my pc incase the db was locked but it is still gone. now my app cant connect. Just for clarity, is user instance supposed to be set to true. and what is the purpose of it. also when the wizard asks to make a copy of the file that will be copied accross each time I run my project I select No.
I am working in a project where i have to add employees in a company. I have a form with text fields(for example name,surname,age,...). What i want is to insert this txt values into a database. My project is connected with an sql database. How can i add the values into a data table on button click("submit")?
View 9 RepliesI am new to SQLSever, Visual Studio and Visual Basic. I have read through Microsoft Visual Basic 2008 by Michael Halvorson and Microsoft Visual Studio 2008 by Lars Powers and Mike Snell. These books mention the ability to use SQLServer as the DB but I am not clear on the process. I am not knew to programming an have had training in OO programming but have never done any OO programing professionally. So, you can assume I am new to OO programing.
I have created an SQL DB using the Server Explorer in VS, and created a Windows form with Labels, TextBoxes, and ComboBoxes for the application's user to add the demographic information about a new employee. I created a new query with the Query builder that is in the Employee table of the DB which contains all the field for the record for inserting. I have a few questions to understand the process for inserting into the DB.
The DB fields are defined as numeric(6, 0), nurmeric(5, 2), and char(30) for some examples.
The maxlength on the form windows are in sync with the maxlength of the DB for the various fields.
1. What is the process to update the DB with the fields from the form?
2. Do I need to declare and set the results from the form first? If so, how do I call the function (query) that I created in the Employee table.
3. The emp_num I would like to be a dynamically incrementing number starting from 1000. How do I make this a dynamic? The emp_num is also the key on the Employee table.
4. I have a decimal field on the Employee table to hold emp_rate (pay rate). Does the user enter the decimal on the Form or is this resolved by SQL to take the 7 numbers and insert the decimal beause of the table's field definition?
This is my first client server application using vs2008(vb) + sqlserver 2008. how can i hide my database schema,tables from application users through management studio..?
View 5 RepliesI have updated a VB 2008 Winform program and published it on a shared folder. The customer can no longer use it because, at launch time, it claimed for SQLServer.Diagnostic.STrace v 10.0.0.0, what it did not before. The only thing I can think at is that I have also recently installed VS 2010 on my PC. Does it change the way VS 2008 work ? How can I solve this issue on the customer PC ?
View 2 RepliesWhere in Visual Basic 2008 Express Edition Software program do you specify a specific installation directory for a program?
c:Program Filesfinished program
I want to publish my program to try it out on another system and I want to ensure its installed in the directory structure I want.
im currently in the process of making a program that im going to release here. But i need a way to open Task Manager in VB 2008. Does anyone know a way to do it?
View 7 RepliesOnce again, I come on my knees to ask for your guidance :P Well, actually I was hoping to see if anyone could someone make up a code similar to this idea xP. [code] Anyone knows how to do this? Basically just list every device connected. Doesn't have to be in the specific paths, just the names of every device
View 6 Replieshow can made download manager application in vb.net 2008?
View 1 RepliesoXLBook.Save()
oXLBook.Close(False, txtExcelPath.Text)
oXLApp.Quit()
oXLSheet = Nothing
oXLBook = Nothing
oXLApp = Nothing
Even though I issue the commands, the EXCEL.exe still appear in the TASK MANAGER -> PROCESS after the Excel application is quit, closed and terminated.
I have make a web browser and a download manager. web browser is working fine, and on the other hand download manager downloads file from given URL. When ever I click on a download link on my browser it opens in "Internet Explorer" Download Manager I want to disable this one and want to embed my download manager with this.
View 10 RepliesWhen i close my program its still running in the task manager, how do i close it completly ?
View 16 RepliesI have VB6 and i want to install VB.NET 2008 without uninstall VB6. Is possilbe? Can i works correctly both?
View 1 RepliesI want to write a kiosk program, but the procedures and practices, or procedures appear to be a help if you would be happy to unload the program
View 11 RepliesAlright, my program requires a folder to put the save files in, and it works fine to create it when I know where the program was installed to. I want to assume that everyone will install to C:/Program Files... however, one cannot assume. Is there a way for me to find out where the program was installed to ie. D:/WorkPrograms/ProgramHere, instead of the Program files? Specifically, is there some sort of code that I can run at startup to find where the program file is, so I can keep all the save files in there?
View 3 RepliesI have created a setup project that after the installation, starts the app that is being installed. To do that I have added an Installer class to the app I want to get started and I am using it's commited event to start the app (Process.Start("...myapp.exe").
While this works fine on XP, on Windows Vista the application gets started as a "System" user which makes some parts of the app missbehave i.e. retreiving special folders of the user etc...
This is the question: way to start myapp as the logged in user? Mind you I will not have the credentials of the users.
How to use this code on security installation?
Public Function GetHDSerial() As String
Dim disk As New ManagementObject(_
"Win32_LogicalDisk.DeviceID=""C:""")
[CODE]...
I have developed a windows application in VB 2008. Now I want to make an Installation Package (setup) of my Project. But I don't want to create only the Setup. I want to include the .Net Framework 3.5 and Crystal Reports and all the files that are necessary to run my Application. so that when I run that setup (installation package of my application) all the necessary files installed automatically.
View 1 RepliesWhy am I getting a request to configure DAO when I start a program I am developing in VS 2008? After I execute several cancels, the program runs fine.
View 1 Replies
