Database Connection In .NET Windows Forms?
Oct 7, 2010
I have a problem with connecting to a server which is another machine. When I try connecting to my machine with the following code, it works fine:
'connString = "Data Source = .sqlexpress;" & _
'"Initial Catalog = one;" & _
'"Integrated Security = SSPI"
[code]....
View 2 Replies
ADVERTISEMENT
Mar 2, 2010
I'm testing database programming in vb.NET 2008 at the moment and try to find a way to use a database connection in different forms, so e.g. I put the the database-connection-component into one of the forms. I know, I could access it by e.g. form1.databaseconnection.xxx, but is this the best way or can I "put" the connection into something more abstract which all forms know about?
View 2 Replies
Mar 16, 2010
I have written a simple VB.NET program that connects to a MS Access Database. This program runs in Windows 7 XP Mode, but does not run properly in straight Windows 7. Somehow, the Windows 7 does not connect properly or read the MS Access database data properly with the DataAdapter.Fill method. I have dual monitors, so I can run the identical program side by side (one in Windows 7 and the other in XP Mode) - one works and the other doesn't (it doesn't crash, it just get "nothing" from the database when accessing - acts like it's not connected). Has anyone else run into this, or similar, problem with VB.NET and MS Access connectivity?
View 14 Replies
May 8, 2010
I am trying to follow an example in the VB 2010 book and the author has set up the local server using a named instance of SQLEXPRESS and uses mixed mode authentication with a sa login and wrox as the password the code is then
[code]...
I am using the Express server initially set up for windows authentication (pubs is one of 6 databases on it) but no matter what I seem to try I can not connect
[code]...
View 1 Replies
May 21, 2009
I am trying to build a user control that will do exactly what the SQL 2005 Connect to Server interface do, eventually create a connection string and store in a app.config file. It should allow user to select server type, server name, authentication, user name and password. It should also automatically load available servers and domain login by default.
View 11 Replies
Mar 21, 2012
I am having trouble in browse & then save an image to SQL Server.ALso I want to retrieve that image.This is the code to browse image & show it in PictureBox1 Control
Public Sub SelectImage()
With OpenFileDialog1
'.InitialDirectory = "C:"
[code]....
But don't know how to pass it to image parameter .Also is there any way that I can save image on Local drive & just save the url /location/name in database?
View 2 Replies
Feb 5, 2010
Is there a way to display the connection properties dialog for connection string browsing(for database) in run time?
As I want the user to be able to connect to various database using the GUI.
View 6 Replies
Aug 19, 2010
After running the following sub (VS debugger), I try to detach the database in SSMS, but it shows the connection open still and won't let me detach. If I close program in debugger, the database shows no connections. I check the dataadapter's connection in the finally block and is shows closed. What gives
Private Function ClientMasterDBFiles(ByVal MasterClientDBConnection As String, ByVal DBName As String) As DataTable
[Code]...
View 1 Replies
Feb 12, 2011
bind to a database column and show the value in a separate linklabel1 or Listbox control in windows forms.
View 4 Replies
Oct 29, 2011
I am trying to use values from form1 in my project, in form2, but Im not sure how to do it. I've tried
txtboxTotal = (Form1.vsbLength * Form1.vsbWidth) * Pattern
But I get: operator '*' is not defined for types 'System.Windows.Forms.VscrollBar' and 'Systems.Windows.Forms.VscrollBar.'
View 14 Replies
Nov 7, 2010
i am using access database for my program. now i have connected to the database in MDI form of main exe, and ir also works, user can log in, it gets verified etc etc etc. now here is the problem, when i load a form from dll and try to use any sql query on that form, i get message, "database connection is not opened". so what i did was, i added the connect() (a function i designed to connect to database) in the load part of the dll's form, it made the trick, query's started to run, everything went fine, and when i reload the form i.e after closing the form, i load it again from MDI form, i get error, connection already open..
[Code]....
View 3 Replies
Sep 8, 2010
I have the code which checks if there is a selected tab
Private Function GetBrowser() As WebBrowser
If TabControl1.SelectedTab IsNot Nothing Then
For Each c As Control In TabControl1.SelectedTab.Controls
If TypeOf (c) Is WebBrowser Then
Return c
[Code]...
View 2 Replies
Apr 28, 2009
I have a panel with some controls in it (several textboxes, a slider, 2 buttons, and a small groupbox).. When I click a button, I want all of the textboxes within the panel to be readonly... So I have this code: [code] When I run it though, I get the following error:Unable to cast object of type 'System.Windows.Forms.Button' to type 'System.Windows.Forms.TextBox'.If I remove a button, it moves on to give me the same error but for a label..
View 4 Replies
Jan 2, 2010
I'm using a OleDB connection to a access database. I'm entering a row into the database to set some user preferences. What i need to get is get back the row ID of the row I just entered. I'm more familiar with PHP and with PHP I use use this entry
[Code]...
View 4 Replies
Jul 9, 2010
I have a basic three form application. It doesn't seem to close after navigating through forms. If I were to open the application, and the main form is displayed. If I press the X button, the application closes fine(Goes from processes) If I were to open the application, and then navigate from the main form to another form using me.hide & form1.show, and press the red X on Form1, the application again, closes fine.
[Code]...
View 6 Replies
Jun 4, 2011
.NET developing and have a simple question, i've been stuck on this for a while and searched many forums first with no solution so i'm posting myself. In VB for excel i've used Screenupdating=false to disable the screen updating however now i'm creating a visual studio 2010 windows forms application and its not showing up as a property. Here's the code i've tried.
[Code]...
View 4 Replies
Apr 9, 2010
I have the requirement to create an application that has multiple front ends developed using Windows Forms, WPF, ASP and Compact Framework Mobile Forms.I would like to be able to create a series of obejct representing the business logic and have this logic accessible from the various front ends available. My first thought was to use remoting as I'd like to be able to pass the business objects back and forth between client and server but the compact framework doesn't support remoting and also transferring a full framework business object to a compact framework business object doesn't seem possible.My next thought was to use web services but again the passing of business objects seems to be very hard to accomplish. Without doing this I would have to create individual web methods for each business operation.
Finally my next option is to use sockets and write the whole client/server logic within some classes and expose them to the UI/Business layer. My only problem with this is it is not scaleable should the number of clients increase dramatically whereas using remoting or web services I can host the solution via ASP.Net.Does anybody have an ideas on the best way forward for this or even have any input on how they would write an application that required a windows form, wpf, asp website and mobile device GUI all of which want to use the same business logic?
View 3 Replies
Aug 26, 2010
I would like to know if its possible to start up a second windows forms inside the parent form. Ex: A button is pressed and a new form is showed. I would like to keep that new form inside the parent form, and have it not be able to go outside the parent form.
View 2 Replies
Mar 31, 2010
I am writing a program for my A-level coursework But for some reason I got this build error this has never occurred to me before, I have no idea why I can't use string for the name of my form.
View 8 Replies
Jan 9, 2012
a program and i need to have a button put a file into a folder, i know how the button works i already have it doing some other stuff. i just don't know the code to copy and past it to a folder.
View 1 Replies
Mar 5, 2012
When I add a new, empty form to my VB.NET VS9 project, the linenherits System.Windows.Forms.Formis missing.What am I doing wrong here?I thought it would be added automatically.I experienced that some thing get weird if this line is not there (Form_Load is not firing, I think).
View 3 Replies
Jul 24, 2011
I've successfully saved video files into SQL server as varbinary. Now, my problem is, how can I play those videos in Windows Media Player (embedded in my Windows Forms).
View 1 Replies
Jan 19, 2010
I'm porting code that I wrote for use in a Windows Forms application to a Windows Service, but for some reason, the code that worked in the Windows Forms application is now throwing errors in the Service
View 7 Replies
Sep 24, 2010
I am making a System Tray Application when i minimize my form its hide itself in the tray but whenever i click on the tray icon my form shows now when my form shows up i would like to disable my Background desktop same as CardSpace when its shows up.
View 1 Replies
Apr 10, 2012
I have a problem with scroll in a treeview in a Windows forms application (Framework version 3.5).
The strange thing about the problem is that on Windows XP, Windows 7 and Windows 2008 the scroll works as excepted, but in Windows Server 2003 SP2 the scrolling doesn't work. Enable/disable Visual Styles doesn't seem to make a difference on Server 2003.
Steps to reproduce the error:
1. Add a treeview to a form and add x nr of root items (and 1 sub item to each item).
2. Expand a number of nodes. The non-standard thing here is that we are changing the node integral height because we display a usercontrol with the treenode (See example of the code below).
3. When you scroll afterwards, you cannot scroll to the bottom node. The scrollbar is all the way down, but we are not seeing the last node.
Public Shared Sub SetNModeHeight(ByVal Node As TreeNode, ByVal IntegralHeight As Integer)
'Create instance of tvitemex structure.
[Code]....
View 2 Replies
Aug 2, 2010
I was playing a game recently and saw that they could use args in the shortcut, and I decided to try to impliment this into my application...so far, I got: (runs this sub on load)
Sub startup_args()
If Environment.GetCommandLineArgs.Contains("+game") Then
Dim path As Array = Environment.GetCommandLineArgs
[code]....
just to see what it returns, but the application crashes. I also tried path.tostring(), but that didn't work. When I did:
If Evnironment.GetCommandLineArgs.Contains("+game") Then
Dim path as string = Environment.GetCommandLineArgs.tostring
MsgBox(path)
[code]....
but that returned the value "SString.Array[]"...
View 7 Replies
Sep 13, 2010
What is the vb.net equivalent to accomplishing this?
static void Main()
{
frmCalcView view = new frmCalcView();
[code].....
View 5 Replies
Feb 4, 2010
My question is, am I able to share a business logic layer seemlessly between the two presentation layers or is there anything I need to watch out for. I'd really like to not have any duplication of business logic, so any advice would be more than welcome.
View 3 Replies
May 6, 2010
I noticed that adding a MenuStrip (from the Toolbox) to my form design doesn't yield a menu bar like many native Windows applications. Instead I get a menu bar like Visual Studio's own. None of the style settings for MenuStrip appear to mimic the much more common native menu bar.Is there a way to add a menu bar to my Windows Forms application that looks the same as the one you see in Notepad, Task Manager and others? (Preferably with the designer, but I wouldn't mind adding it programmatically either.)
View 3 Replies
Jun 21, 2011
will a VB 2010 (Windows Forms Project) run on the Windows 8 platform?
View 3 Replies