Application Along With Database Created In SQL Management Studio
May 24, 2010Please how can i publish an application created in vb.net along with a database which i created in SQL Management Studio?
View 4 Replies
ADVERTISEMENT
Deployed And Installed Application / Want To Attach Database Within SQL Server Management Studio
Mar 9, 2009I've developed an application in VB2008 express and have installed it to another PC. The installation has put the mdf file in c:documents and settingsuserappsdata.I want to attach this with SQL Server Management studio but when I try to browse to the file in order to attach it, I find I can't browse further then C:documents and settingsuser.
View 3 RepliesGet The Stored Procedure Have Created At SQL Server Management Studio Using Code Behind The Files?
Aug 3, 2011How can I get the output data of sql procedure from SQL Server to my asp.net[vb.net] page dropdown list?<asp:DropDownList ID="DdLocation"></asp:DropDownList>
View 1 RepliesAsp.1.1 - Publishing - Put Database Up From SQL Management Studio
Nov 5, 2009Using Vb.net 2003 Asp.net 1.1 Sql Server2005 Express Vs.Net 7.1. I have Vb.Net Standard and there is no Web Set Up with this version. I have FTP things along time ago but not asp just basic stuff. I have read about xcopy,copy project, I have XP and IE that I can FTP from. I also have to put a database up from SQL Managment Studio. I need to know HOW WHAT WHEN WHERE on how to do this right. This is an interactive site that I made, very similar to a Forum like this site. Do I just upload the dll.
I don't want my source code available for everyone to see, do I have to obfucate it if I am using [url] as a host. The site can't really be down all the time, I have read that I could work on thesite while it is up but I believe I will have to have all the source files up and open.
Creating A Database Management Software Using VB IN VISUAL STUDIO 2008 As Front End And ORACLE 10g As Backend?
Jul 6, 2010I am an absolute newbie in both oracle and visual basic. I have covered some basics as tutorials and want to develop a database using Visual basic as front end and Oracle as back end. I have Visual Studio 2008 installed and I will use Visual Basic from that. I also have Oracle 10g express edition installed on my system.
View 6 RepliesVisual Studio Causes Error In SQL Management Studio
Apr 17, 2011This is my first try of Visual Basic 2010 Express, though I have 10 yrs+ experience in VBA. I'm running Windows XP SP2 on a desktop pc with following installed: Visual Basic 2010 Express... just installed! SQL Server 205 Express ... been running on pc for 12 months I've created a new DB in SQL for my test application, but have not added any users or permissions to it as I'm using Windows authentication.
I've created a new Windows Forms Solution in VB2010EXP and tried adding a new Data Source for my new SQL DB, but it keeps giving error message about not having rights ot the db. 2 days of searching on the web has confirmed many others with similar issues, but no obvious solution. Eventually I find a few threads about permissions and moving the mdf into the root of the HDD, so try moving my mdf file up closer to the root of the Hard Drive msf was in C:Documents and Settings\_SharedDataApplication_DataMSSQL2005Data now in C:SQL2005Data
[Code].....
View The Code From A .exe Application File That Was Created Using Visual Studio?
Feb 23, 2011How do you view the code from a .exe application file that was created using Visual Studio?There are several applications of which codes I want to see to understand how the application was created to increase my understanding of VB.
View 4 RepliesCode Library Management - Created A Custom Class
Oct 15, 2008I've created a custom class that I've grown rather dependent on in my coding. I've encapsulated it as it's own "Solution" and use a reference to the class module within the solution on most of my new projects, and that all works fine. It seems slightly clunky to me that my encapsulated class module is packaged with solution-related directories and so forth. For me, this seems to make management and maintenance of these little class modules difficult (renaming them for instance). So now, a few questions:
When you recognize you have a useful class embedded within a solution:
1) What's your method for encapsulation? (is there a template you like?)
2) How do you organize/arrange your code libraries?
3) When, if ever, might you consider using that "Code Snippets Manager" thing in the IDE?
I'm struggling a bit trying to understanding how Visual Studio wraps-up everything in what appears to be a "Solution" umbrella. There doesn't seem to be a lot of write-ups on how to go about organizing your code libraries to work well within this Solution/Project Visual Studio framework.
Sql Management Studio For Vs2010?
Jul 13, 2010which version of sql management studio express should i download for visual studio 2010
View 1 RepliesSQL - When I Open Up The Table In The Management Studio The Record Is Not There?
Jul 7, 2010I am writing a program to record patient info for a local ambulance company. My problem is when a patient is added it does not write to the SQL server. When I open up the table in the Management Studio the record is not there. Here is the other thing that is weird to me. I open the program, add the patients info, clear the search box, type in their info and the record shows up. When I close and reopen the program I search the same record and nothing comes up. I tried redoing the string command, then thought maybe I needed to use parameters but that didn't work either.
View 11 RepliesVisual Studio 2008 Collaboration & Management
Mar 11, 2010I write as a systems administrator and own VS Team 2008 Team Suite. I would want to learn about the features within the package that allow developers to collaborate with other developers either real-time or otherwise.Additionally, I would want to learn about the features that would allow me to assign and monitor the progress of projects.
View 3 RepliesInstall SQL SQL Server Management Studio Express Silently?
Sep 28, 2009where that i find the commands for make an silent install of SQL Server Management Studio Express.The same thing i did with sql express 2005:
infoSQLExpress.FileName = DirectoryGet + "appsSQLEX05.EXE"
infoSQLExpress.Arguments = "/qb INSTANCENAME=" + txtInstanzname.Text _
+ " ADDLOCAL=SQL_Engine,SQL_Data_Files,Client_Components,Connectivity" _[code]......
Data From Excel 2007 To Microsoft SQL Server Management Studio Express?
Jun 22, 2009How do I transfer data from Excel 2007 into Microsoft SQL Server Management Studio Express as shown below? I try copy and list of data in excel as shown in the screenshot.. But when I paste in Microsoft SQL Server Management Studio Express.. Only the first result is past inside..
View 2 RepliesStart Writing A Store Produce And Function In SQL Management Studio Express
Oct 23, 2009i grow familiar with statements queries of SQL. Now, i have to start writting a store produce and function in SQL Management studio express.
View 1 RepliesUpdating A Data User 2008 And Sql Server Management Studio Express
Apr 19, 2011I'm trying to update a data user using vb.net2008 and sql server management studio express for my backend. the error says "must declare the scalar variable "@username"
Here's the code .
Private Sub btnupdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)Handles btnupdate.Click
Dim connstring = New SqlClient.SqlConnection("Data Source=MISD-
[CODE]...
Perform An Action On Clicking A Custom Context Menu Created In Excel Using Excel Add-In Created With Visual Studio 2010?
Apr 14, 2012I am creating an Excel Add-In using Visual Studio 2010. My intention was to add a context menu to a cell and perform some action on the selected cell or cells. Here is the code I have got as of now
[Code]...
Database Format For Visual Studio Application?
Jan 13, 2009I am very confused about the database type to be used in my vb.net application. I have been using SSCE database, but for that user has to download and install SSCE, which many of my users do not want. If I use Access, the security issue is very very serious.
View 1 RepliesIDE :: Database Application Using SQL And VB 2005 From Visual Studio?
Sep 26, 2007I have a very strange problem with the application I wrote.
It is a database application using SQL and Visual Basic 2005 from visual Studio.
I get an error Value cannot be null. Parameter name: context.When I get this error which accumulate 3 or 4 times in design mode, on an open form. some of the properties disappears for the textboxes like dock, buinding and so on. Does anyone knows what this error means.
Possible To Use Ms-Excel As A Backend Database In Visual Studio 2008 Application?
Oct 28, 2009how can i use Ms-Excel as a backend database in visual studio 2008 applications, if is it possible
View 2 RepliesSuggestion Request ::: Database Format For Visual Studio Application?
Dec 14, 2011I am very confused about the database type to be used in my vb.net application. I have been using SSCE database, but for that user has to download and install SSCE, which many of my users do not want. If I use Access, the security issue is very very serious.I have downloaded a few database apps from the internet, which donot require any such thing to be installed and also I see no known database format in the application folder. I wonder what kind of techniques they are using.
View 12 RepliesCredential Management In VB Application?
Jul 9, 2009I've been trying to develop a VB application which retrieves a lot of information from an XML file on our secure intranet. So far I've been using...
Dim request As WebRequest = WebRequest.Create(xmlUrl)
request.Credentials = New NetworkCredential(username, password)
Dim response As WebResponse = request.GetResponse()
Dim str As Stream = response.GetResponseStream()
Where username and password are predefined. What I need is a way of utilising the Windows credential manager to handle this. Ideally, I like it to pop up a credential prompt at application start, and then store the credentials for later use. So far so easy, but I want to be able to use the tick box to save the credentials back to the store, so taht next time the application is used, they are already filled in.
So far I've been investigating the CredentialsDemo from MSDN, but have been unable to adapt the routines to a web request from the given example of a SQL request. In fact I've not even been able to get the demo working adapting it to my own SQL server!It utilises the CredUIPromptForCredentials function. Is this the right way to go? Or am I barking up the wrong tree?
Data Management Application For Work
Jun 1, 2009I am trying to construct a data management application for work. I had this working fairly well then moved over to VS 2008. When I am submitting my data via the button it is giving me a null exception error on the call sub.. Here is the code.[code....]
View 10 RepliesCreate Database Management System?
Feb 14, 2010create database management system in vb 2008
View 2 RepliesVS 2010 Database Management Program?
Jan 28, 2011A year or so back I made a database management program in vb.net and now its out dated and i want to start from scratch, since I wasn't very good at vb.net at that time most of it is hacked together in one single file.Now i want some tips in making these kind of programs.I've heard of something called a data access layer. What is it and Should I use It ? Is it a Class or interface (I don't know what interfaces do yet but they should be to hard)?
[Code]...
Asp.net Mvc - Expose Built-in Security And User Management To A MVC Application?
Jul 23, 2009I have built a MVC website on IIS6. I used the built-in ASP.NET Security without Membership, just the way it was implemented in the template solution. It is easy to secure a contoller or action, but now I need to expose the user management to an admin logged into the site. I understand that the builtin ASP controls for doing this are not "best practice" and are a dog to get working. So what is the best practice for offering user management through a ASP.NET MVC application?
I considered using the Entity Framework and wireing it up to the myriad of stored procs. but that seems awkward. I see options for AccountMembershipService and FormsAuthenticationService. That is what the existing project account controller uses. But, I am not fimilliar with either.I can't help but think that this should have already been there from the project template. This is a fundamental part of any website and you were given 15%, why not the rest?
Memory Management - Reducing The Commit Size Of Application
Oct 15, 2009I have an application which I've developed which queries Active Directory information and stores about 15 properties into a Datatable which is kept in memory. I need to decrease the amount of "Commit" memory it is setting aside. The application stays active in the system tray and allows for quick searching of information along with pictures for users. I have a class, which is able keep memory usage down pretty low. It runs on a timer every 10 seconds and listed below:
[Code]...
Sensors, Information Management Database And Hardware
Oct 19, 2011I just wanted to know if visual basic 6.0 or Visual Basic 2010 can be programmed to create a system that uses both smart card reader and sensors (photoelectric sensors) and be recorded their information into a information management database for date and time log.
Example:
1. A personnel will have to tag their smart card to the smart card reader. It will then be checked from the database and approved if their record is available in the database.
2. He will then have the access to enter and take a particular stuff from a rack (which has the sensor) guarding on each item on the rack. If the personnel take the item. It will then be logged into the database for the 1. personnel I.D, 2. item position on the rack, 3. time and date when the item is collected.
Question:
1. What hardware are needed to incorporate all this (smart card reader and sensors to database)? a controller perhaps? terminal for all the sensors?
2. What software to create the information management database so an authorized personnel may check the event history? also software to incorporate with the sensors? will it have to be on separate software or all can be done in the package given in VB6 or VB2010 or an additional software to be used?
3. Does MSComm Control have any relevance on this subject? All i know is what it does (vaguely) and no idea how to implement it.
Small Personal Database Management Program And Am At The Stage?
Oct 28, 2009I am working on a small personal database management program and am at the stage where I am trying to search the MS Access database given a user input.I need to look up lets say the "customer" ID and the update other records associated with that customer. Here is what I have so far.
[Code]...
Created A .Net Program In Visual Studio 2010?
Nov 20, 2011I created a VB.Net program in Visual Studio 2010 Pro. Everything runs fine in debug mode on my developement machine. I'm using setup builder installation and cryptolicensing for the license.dll. I have checked the setup program and all the files are installed on the test pc as required. The program was developed on the 4.0 client Framework. The problem is when I install the program on the test computer it will not open or run. No indication of why no messages, nothing. Can anyone steer me where to begin to find out why this is happening.
View 3 RepliesHow To Perform Onkey Event In An Excel Add-In Created With Visual Studio 2010
Apr 17, 2012I am creating an Excel Add-In using Visual Studio 2010. I would like to run some code when users clicks a combination of keys.Here is the code I have got
Public Class CC
Private Sub ThisAddIn_Startup() Handles Me.Startup
EnableShortCut()
End Sub
Sub A1()
[Code]...
The Add-In when installed shows an error on clicking the short cuts. It says the specific macro cannot be found.The code under the Sub EnableShortCut() works well when it is in an excel vba module. The same won't work when it is added to an Excel Add-In created with Visual Studio.