I am facing prblm in selecting compbobox...I have a 2 combobox...cboxSelunits and cboxseldept
In selected index change of Cbxunit i am filling CbxDept.and in selected index change of cboxseldept i need to populate the treeview
[Code]...
I am using .net 2008. I have placed a ComboBox on the form and I do not have an additem.
[Code]...
I'm designing a login screen which MUST allow the user to ONLY select a login via a combobox. A user has THREE login attempts only, the problem Im experiencing is resetting the count if they hilight the combobox, move the selection around but ultimately click on the original name.I can use either SelectedIndexChanged or SelectionChangeCommitted but they are both activated even if the same login is selected.So you can select a login enter the password twice and then click on the combobox move the selection around before finally clicking the original name and the login count is reset to 0.Is their a way to do this without using variables to store the previous value (perhaps using validating/validation methods)?
View 4 RepliesI am developing a Windows Form Application against a SQL Server relational database. An example of the database schema is:
TableA
------------------
PK A_ID uniqueidentifier
A_NAME varchar(254)
[code]....
In the form I have a ComboBox (cboA_ID) to select the TableA record (DataSource = TableA, DisplayMember = A_NAME, ValueMember = A_ID) and a TabControl where controls on each tab are bound to fields in either TableB or TableC.My question is, is it possible to bind cboA_ID to TableB.A_ID and TableC.A_ID?This is my first database application so if there is a better way to do this I'm all ears. I have set everything up using the wizards in Visual Studio 2010, so I'm still not 100% familiar with what all the various TableAdapters and DataSets do.
Class Structures
Public Class SBO_Collection
Private p_sample As SBO_Sample
[Code].....
How would I enable/disable a button if listbox become populated?
View 1 RepliesI get an error when updating a related table, the main table can be updated but the related gives me a concurrency error but I don't know why. Btw I'm the only one using the program and it's connecting to sql server 2005 express.Inserting works like a charm.My piece of code, I hope you get it. The concurrency error is given on Me._objtblOrderinformatieA.Update(Me.objdtsOrders.orderInformatie)
If MessageBox.Show("Bent u zeker dat u deze record wilt wijzigen?", "Orderbeheer", MessageBoxButtons.YesNo) = 6 Then
update_dataset()
Me._objtblOrdersA.Update(Me.objdtsOrders.orders)
[code]....
Below error is thrown in a already opened program which connects to different database
A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
Program details: code done using vb.net with SQL Server 2008 as back-end
Two instance of same exe where running simultaneously in same PC but error was thrown only by one instance
Program uses both SqlConnection (ADO.NET) and ADODB connection (upgraded from VB6) and the error is thrown by both types of connection If the error is due to network problem with the server then why few programs work fine? I am not able to trace the reason for this behavior of the program
Can I know why this error occurs and why only in few programs of same instance
New Introduction to Programming Vb.NET I did. Says the problem that I have been living in the code example below. Code Example:
[Code]...
The problem is not changed it to a text column in the database MNO. But I had to use as a MNO Numeric Column
trying to get my hands wet on vs 2010 and i downloaded samples from ms site but when i tried to run some of the DB samples i received this sql error: 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) any ideas how to get around on this?
View 5 RepliesI've got a problem with Linq in VB.NET.I've created a .dbml file from my db, and everything looks good - relation "arrows" between tables are visible, etc.But when I want to use simple query (taken from 101 Linq Samples by MS):
Dim q = From h In dc.Hours, w In h.WorkType
I receive an error:
[code].....
i am facing a problem that is frustrating i have a VB.NET application that i need to connect to an sql 2005 server .its giving this error when i publish the application "a network related or instance-specific error occured while stablishing a connection to sql server . the server was not found or was not accessible .verify that the instance name is correct and that the sql server is configured to allow remote connections" the pc has windows xp on it i configured my sql to allow remote connections its working on one mashine but not the other ??
View 5 RepliesI got an error message saying "Network-related or instance specific error occured while establishing a connection to SQL server............" when opening a connection in form_load event.Tried restarting computer it worked few a times,but still would get the same message again after sometime.How can i fix this error?.
View 3 RepliesI've developed a small HR program that connects to the SQL database which is on the local PC. I've created an ODBC connection to connect to this server and the program works fine. I've used VB 2008 Express edition to develop.
My concern is now I want to install this EXE on a server. ON the server, I've created the same databses and successfully created an ODBC connection on the server as well. Also created one shared folder. I copied all my EXEs and DLLS on to this folder. On the server I was able to execute the program without any problem.
From a remote client, I opened this shared folder and try to execute and it was giving me an ODBC related error, basically it was not able to detect the SQL connection.What I want to achieve is to have one EXE. The program did not throw any other errors.
Using a datagrid, binding to one table, and related to one combobos, I cant update records, cause gives me a violation error. I'm not changing the primary key, so, I dont undersatnd cause this happen. I prepair a example of this error, and it was attached to this message.
View 5 RepliesI made a program a month ago and i gave it to the customers.recently they report some bugs and i fixed them. when i send the new version installer to them, they have some problems running it.i used vs 2008 to write it, but i removed vs 2008 and installed vs 2010 last week. when i opened my project to start fixing program bugs it asked for convert wizard so i did it.i made changes and build it. i use installshield and i add framework 3.5 Sp1 as prerequisites.
note : i was using inno setup first time. so i changed the installer too.so i tried installing the program on my machine.i just noticed that i have only .net framework 4 installed my own system. so i have no idea how the program runs without any problems on my own system. i have even tried installing it on another machine who had framework 3.5. it it work on that too.the error shown on customers machines is related to framework version. everytime i send them a new version they have some problem installing/running it.
I am working on a project using VS2010 SQL2008 and I saw an ODD behaviour , First let me tell you that the app runs without any problem in my developing pc (Windows Xp sp3 32bit)But when I was trying the application in another pc (Windows 7 32bit)I got this exception: A network-related or instance-specific error occured while establishing a connection to SQL server.The server was not found or was not accessible.Verfiy that the instance name is correct and that SQl server is configured to allow remote connections.
Now what is weird in this exception; Is when the application reaches the DataAdpater.Fill(dataset) line I got this exception but when the app reaches the DataAdpter.Insert(....) It runs without any problem .
And what is more weird is that I noticed that the dataset that is used in the previous insert procedure can later be filled with dataAdapter.Fill(...) procedure which it was giving me an exception before .
I tried these things as a solution:
1)Checked SQlBrowser running..
2)No aliases to Sql server at all to remove...
3)remote area connection--OK
4)TCP and UDP port 1433,1434 exception in firewall
5)Unistalled my only antivirus Norton
6)Added Tcp/IP ports in Sql protocols
7)My connection String is : onnectionString="Data Source=ALISQLEXPRESS;Initial Catalog=PALMSDATABASE;Integrated Security=True"
8)Also tried using Sql Server authentication (user Id and password)
what is the difference between fill and insert? My app. runs smoothly on the original pc ,What should I do?
I HOST MY ASP.NET WEBSITE ON WEBSERVER ..But after upload when i try to access my site ...
[URL]
Then following error occurs ....
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)
i have changed my connectionstring in web.config file and all webpages to :
<connectionStrings>
<remove name="ConnectionString"/>
<add name="ConnectionString" connectionString="Data Source=69.16.253.19,1433; Network Library=DBMSSOCN; Initial Catalog=database;
[code]....
...before publishing and uploading my website to webserver ...I m confused the problem is from my local computer or the webserver ....and how to fix this error ?
i downloaded samples of vb 2010, i tried to run Create DB (Data Samples) but i'm receiving this error. I have MS SQL Server 2008 installed.a network-related or instance-specific error occurred while establishing to sql server. the server was not found or was not accessible.Verify that the instances name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error:40 - Could not open a connection to SQL Server)
View 3 RepliesError message receiving 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) The project is written in VB.Net 2008. Production server uses SQL 2008, Dev Server uses SQL 2000. The application has been built and published.
Prod Connection String: strCN = "server=SGMAGNCPQ03.;Initial Catalog=APO_Tax;Integrated Security=True"
Dev Connection String: strCN = "server=S04423711940995.;Initial Catalog=APO_Tax;Integrated Security=True"
The Problem: When I change the connect string from dev back to prod and try to run my app, I get the above error message. If I reboot everything works fine but if I switch the connect string from prod to dev and try to go back to prod, I'm back to the same problem.
I am creatting an windows application software in which many controls like Buttons, textBox, combobox are remain same in 12 different form. In this 12 diff form the activity of those controls will remain same.The scenareo id
1. I have 12 forms.
2. Each form containing 3 labels (Country, State, City). These labels indicates 3 combobox from which we can select location.
3. Now I need to use these 3 controls in all 12 forms with same activity.
4. When I change forms to another, these buttons shud remain same.
i have 2 forms, in form1 i have 10 textboxes and in form2 i have a combobox. I need that when i press a button, the text in each textbox (in form 1)appears as a choice in combobox in form 2). How can i do this?
i suppose i have to set form 1 as public..
I used error provider tool to display the error when the textbox is empty. when the error message is displayed immediately it is inserting the record into the database.I want to clear the error and then insert. how to take the control to textbox?
[Code]...
I used error provider tool to display the error when the textbox is empty. when the error message is displayed immediately it is inserting the record into the database.I want to clear the error and then insert. how to take the control to textbox?..Imports System.Data.OleDb
Public Class Form1
Dim myConnection As OleDbConnection
Dim myCommand As OleDbCommand
[code].....
System.InvalidOperationException was unhandled.
An Error occurred creating the Form. The error is: The Parameter is incorrect
I need to pull the name of some forms in my project and add them to a combobox. How would this be achieved?
Here is a image of the directory layout.
[URL]
I need window1.xaml through window6.xaml to appear in the combobox on my admin form.
Here's my scenario...I have 2 datagridviews in my Windows Application.When I click on a row in the parentgrid, a child grid shows up with data regarding to which I have clicked.both grids are from the Database (SQL2005) only. In the child grid am using a combobox and that is my headache...this part is working fine and the problem is in the child grid.
When I try to add a new data (at the sametime into the Parent and Child) its working fine and am able to insert data into the tables...
But when I want to edit a data in the child grid, the combobox is making problem.I selected a value from the combobox and go to the next cell OMG the combobox value changed to the corresponding ID of that instead of showing the text.But I neglected this as I was getting the correct value tat has to be inserted into the DB.
Now while editing the main data am tryn to add a new child data ( assume that there are few child data already and am adding a new one).When I click save the values in the combobox are retreived as string and am not able to update the database.This happens to the rows that were already there.the reason is because of the strange behaviour of Combobox in the grid..
Am after this for 2 days and still after this..
Also am populating the combobox from the DB only.
Find the code below, how I did the combobox population
CODE:
I have a combobox, I set its "drop down style" property to "drop down list"Then I wanted when th user clicks on the form the combobox becomes unselected so i wrote this
PHP
Dim String
ComboBox1.Text
[code].....
I have a combo box having multiple items and I want by typing the item should select automatically and combo box style should be "DropdownList" type.Let�s say I am typing "I" then country like "India", "Indonesia�,� Italy" should sort automatically. It is happening by default in VB.NET for one character.But I want If I type "India" this should select "India" instead of "a...." because my last character is a. in VB.Net it is selecting country like starts with "a�. But I want the full typing option should be present for the combo box.
View 1 RepliesThis seems to be the toughest thing I've had to search for. It seems there's not a good thread that clearly explains how to add items to a combo box that's bound to a SQL Server table (of course, I'm a newbie so I'd like a step-by-step on how to get it done).
View 5 Replies