VS 2008 Language - Developing An Application That Uses A Sql Server Database
Apr 13, 2009
i 'm develloping an application that uses a sql server database, in my computer where i'm programming i installed the sql server in the same language of the OS, in the tests of the application everything worked fine. Biut after migrating the db to the main server, the values went crazy.. After some research and tests, i saw that the language of the sql server was in english and that was the problem.
My language settings says that the decimal separator is "," and the agrupment digit it's ".", and the sql server works in the other way "." is the decimal separator and the "," it's the agrupment digit. In my code i was using the CDEC to pass the values to the DB, to solve this i removed the cdec and send the parameter as a string (So if i send 2,33 to DB with CDEC i get 233 if i send the 2,33 string i get 2.33). This works for now, but i don't know if in the future i'll have problems...
View 1 Replies
ADVERTISEMENT
Feb 26, 2011
Iam developing a Windows application using Visual Basic 2008 with a SQL Server database. Throughout the program I give the user as many options as possible and have no problem with either the database or the windows forms. The program does not initially require a Login and I want toprovide the User with the opportunity to add a Login to the system. The default Login form is perfectly satisfactory.
The problem is that I can't figure out how to program the change sothat the Login from isopens the program rather then th form designated as the StartUp form. this forum I am able to prgrammatically change the form but I can't figure out how to make the requirement a permanent factor. I tried using a Constant, but if the User wants to change, you can't change the constant. Its an apparantly simple yes/no situation but if I set a varable to yes and then change it to no the next time the program runs, the change will be lost.
View 6 Replies
Jun 29, 2010
i've developed vb.net window application in english language.. its working fine but it has to support japanees language also.. Displaying text, input text every thing should be japanees... so user can select english or japanees, based on that label, input control language has to change..
View 1 Replies
Aug 24, 2010
how to develop unicode application in vb.net and sql server 2008 ?how to start develop and what are the things i have to consider to develop effective unicode application ?. this application should support japanees and english language based on user selection.i took steps but i don't know it is correct.
1. i created tables in sql server with fields, for strings - NVARCHAR, for integer INT, for datetime DATETIME,for numeric NUMERIC.
2. i created another setting-table to have all screens name,label names ( for labels and grid column headers ) and corresponding japanees display names and another column for english display text.
so i'm just going to fetch Japaness/english display names from setting-table on form load and change the labels.Are these correct ? or anyother way to do unicode application effectively ?
View 2 Replies
Apr 22, 2009
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]...
View 4 Replies
Jul 10, 2009
I'm building a multi language application, but in the application, there will be some data that will be retrieved from the db. In the db I have two tables (Access Groups, Teams) the two tables are related, there are some groups, that have teams, example (sellers can belong to team 1, team 2, team 3...). The data that will change it's the names for the access groups and the names for the teams. The only way that I can think to do this, is to have the different values for all the languages in the code, or some auxiliar file, and when loading the application I'll truncate the two tables and fill them with the current language values. By the way those values never change...
View 5 Replies
Mar 14, 2010
I am developing a software using vb.net and SQL server as database it takes the name of my system in connection string and when i try to load my software in other computers it search the same name.how can i define a connection string that takes the name of system on which software is loaded?
View 1 Replies
Jan 3, 2010
I work as an IT Administrator and manage a few Servers, Routers, VPN Connections over a number if locations. What I am wanting to do is create a vb.net app that will go out and ping say every 2-5mins each of the servers, routers, that are listed and then shows beside the Hostname a Green Circle which means online and if its a Red Circle its offline, and the screen refreshes if their is a problem or a device / service comes back online.
Then if its offline email a particular email address showing the hostname of either the server or router and which location saying its offline. If possible to make it easier to change the devices to show possible have a txt file or something like that with the Hostname, IP Address, Location.
View 2 Replies
Mar 4, 2012
I am developing a chat application using online connection to a mysql databbase. But i am facing a problem. After 10 minutes, MySQL closes all the chat connections because of the 600 seconds timeout (has been set by the host service i am using). I don't understand why is that happening cause every piece of my code which needs data from the database opens and closes the connection (i mean that it dosn't maintain the connection after the query's execution). If i .close() and .dispose() the connection, it still appears in mysql at sleep mode (it terminates only if i exit the program).
Dim MySQLCon as New MySQLConnection
Dim MySQLCom as New MySQLCom
Dim counter as Short
[code]....
View 2 Replies
Dec 7, 2010
I want to learn programming techniques so can make both windows and web applications more user-friendly, faster, safer, reliable and easier to deploy.
View 4 Replies
Feb 22, 2011
I am developing an multilingual application in vb.net 2008.I had given a combobox for language selection when user select any language like marathi or hindi then all labels are change in the selected language but i am facing problem with textbox if i select any language it takes input from user in english only.I want when user select any language and enter data in textbox then he is able to enter data in the selected language.
View 2 Replies
May 2, 2009
laterly I've been trying to think of smarter ways to use code my programs. My Uni class's latest assignment involves a Lawn Mowing Caculator. I've designed a form below, but now I'm stumped for where to start on my code for it.
View 4 Replies
Apr 10, 2012
I have recently developed a back end database in SQL server 2008 R2 and attached it to a application in VB express 2010.Everything works fine and when i publish the application, it works fine on my machine, but once i try to setup up the application on another machine i get the error message: A network related or instance specific error occurred while establishing a connection to SQL Server. Server was not found or not accessible please verify the instance name is correct or allow remote connections.I have read numerous forums on this saying about changing the connection string and instance name.but with being novice i dont understand what needs to be changed etc.The sql server allows remote connections, but i am unsure what else needs changing to allow the application to work with the database on another machine.
View 5 Replies
Oct 29, 2009
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 Replies
Mar 12, 2009
how to load a .bak file of database backup in sql server 2005 using vb.net 2008 windows application?
View 5 Replies
Feb 14, 2009
VS 2008 SP1. I cannot get my application to display in English, it always displays in French. I have an application that uses 2 languages. The default language is en-GB and the second language is French. For setting the text of the buttons and labels. I have set the localized property to true and changing the language to fr-FR on the form. So setting the default languages controls by choosing the default the language property, and then switching to French language to set the French controls. So I have the following files:
formMain.resx
formMain.fr-FR.resx
formMain.Designer.vb
formMain.vb
And for message boxes and other strings I have added these 2 resource files
formMain.Strings.resx
formMain.Strings.fr-FR.resx
So if I want to switch to different languages I have changed the cultureInfo as follows:
If My.Settings.Default.Language = "fr-FR" Then
Thread.CurrentThread.CurrentUICulture = New CultureInfo("fr-FR")
Else
Thread.CurrentThread.CurrentUICulture = New CultureInfo("en-GB")
End If
And for string I use the following: MessageBox.Show(formMain_Strings.SameStringName)
I also an address book form that is a child of the formMain. Which I have used the same method. However, the address book works as normal, but the formMain never changes to the language I want. Even though tested by explictly setting the language to en-GB in the form constuctor before the inializeComponent() it will always default to French. Not sure why the address book (child) work correctly, the parent form (formMain) will always display in French, no matter if I have set this to en-GB. I am 100% that my method is correct using what I have show you above. I was thinkng about deleting the formMain and creating a new one. But that would mean doing everything again and would take too long.
View 2 Replies
Feb 9, 2009
I am in the process of developing a messaging framework for a windows application that sends messages to a java application. To be precise when the win app wants to send a message it simply drops the message in a common database table which will be picked up by the java app. The windows application is deployed across 10 application servers (10 instances) over citrix for load balancing.Each instance of the application is capable of sending a message to the java application and each of these messages should have a unique id. From my end I need to make sure every message generated has to carry a unique id so that they can be identified when necessary. All the messages can be cleared every day or two.i am not quite sure about a best method of achieving this. Initially I wanted to create a static method that serves the next available id (incrementing the last id by 1). But this approach willn't guarantee unique number as the application starts only when at least one user is logged on. For e.g .On one server the app starts when a user logs in, he then sends a message and then the application stops when that user logs off. So when a next request for the app comes to that server a new instance will be started.
View 3 Replies
Oct 16, 2009
Below I have the create script for a table. It works great but for some reason it doesn't include the Keys, Constrains, Triggers or Indexes. I am having little luck finding documentation on how to do this. Most of the example I can find is in C# as well.
Imports Microsoft.SqlServer.Management.Smo
Imports Microsoft.SqlServer.Management.Common
Imports System.Collections.Specialized
[code]....
View 2 Replies
Feb 17, 2011
I'm a college student who has a basic-intermediate knowledge in VB.NET, C++, C# and Java. I'm planning to develop an application similar to Microsoft Windows (Windows and Sharing Center ).
The application will able to perform Wireless Detection: scanning the area for available wireless network and presenting them to the user of the software, and then user can decide to which network he/she wants to connect.
[Code]...
View 2 Replies
Feb 7, 2012
I am new to vb.net . I was developing application in c#. Now i am working in vb.net. i have a query in vb.net. How to write compund assignment in vb.net ?
ex :
In C# ,
int a,b,c;
a=10;
b=c=a;
if i did it in vb.net means the value of b is set to false. how do i solve this problem?
View 3 Replies
Oct 4, 2009
I am trying to develop a chat application using Visual Basic 2008. I have referred some articles on the internet like [URL]...rogramming.htm and got the concept of connecting and sending data. But when it comes to real world chat applications, there is user authentication and all that. So I was wondering if it is possible to make my own Windows Live Messenger or Yahoo Messenger!!. I searched web for such a sample or source code, but could not find any. Has anyone here created such an application??
View 2 Replies
Jul 12, 2009
i developed a very simple vb.net application and i need a way for every user to verify that they have paid for it. i would like the simplest method possible. it will be an off-line registration. I am actually looking for a way that I can program this easily myself, and am not interested in third part solutions.
View 2 Replies
Aug 11, 2010
i'm tying to send email in my application directly by the smtp server but the server doesn't allow me to do that.The application its used by everyone in the company, so i set the smtp client UseDefaultCredentials to True, but the server replies with this when i try to send an email:[code].....If i set the credentials by hand, the server sends the email. So my problem is how to make this work to everyone? I don't want to have one public/friend var all time in the application with the credentials of the current user?
View 9 Replies
Apr 6, 2012
Case : I'm creating an application (desktop application) with VB.NET (actually windows form), and using SQL Server Express 2008 for its database.
[Code]...
View 1 Replies
Apr 28, 2011
hi, i am developing a windows application in visual basic 2008. when i will install or setup my application to clients' computers, do i have to install the dot net framework 3.5 in every single pc or i can include dot net framework 3.5 in my application.
View 4 Replies
Jan 4, 2011
I am developing an application using VB.Net which is a simple executable which is to be run from a network drive of our company servers. Most users can access this executable without issue - others however can open the executable but have no connection to our database (even though when running the executable off a local drive such as C:, the database works no problem).
From some posts I have seen this might be a CAS issue - however our IT department suggest the issue might be down to different version of the .NET Framework being to blame. Firstly, is this the issue? Secondly, how can I develop my application to work with different versions of the .NET Framework? Surely this doesn't mean developing many different executables?
View 15 Replies
Jun 5, 2010
I have to develop a new application in windows. in which i have to develop following thing but i am not getting how to develop it.I have to develop following are the two points:1)To show the http addresses that are visit by other computers on the wireless network.
[Code]...
View 6 Replies
Oct 1, 2009
I'm not new in visual basic but I finished a book of visiual basic in 2005. Now I'm planing to be a2z software developer on windows platform. Do you think that visiual basic is strong language or complete tool for all kinds of software development ? Will C++ or C# come on my way for software development while i'm visiual basic.
View 3 Replies
Nov 2, 2011
I 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.
View 1 Replies
Dec 24, 2009
I am looking for a contol either listbox or listview to support my requirements. Basically how my application looks is:
[Code]....
Having said these things. I used to program in VC++6, VB6. But using those version now seems not realistic now as I lost touch. But if I have to use the latest 2008 versions, for which I do not have any experience seems scary. So, If you are reading this , and you have got some experience in these fields or using controls that support my requirement, can you please let me know which programming language or IDE and Control should I use to develop this application. PS: the image is made using mspaint and does not represent actual program.
View 1 Replies
