Create A New Dataconnection To Point At Test Database?
Feb 17, 2011
I have been left to maintain some vb.net applications - all of which utilize SQL server 2000 as the backend db. I need to change a report in one of the apps to include some newly added fields fromt eh database. I added the new fields to the specific table in the "testing" SQL server database which is on a completely different server. I am creating a new data source and have selected the database icon and then selected a connection string that clearly points to the test database on the test machine. I then selected the table containing the two new fields but for some strange reason, the two new fields I added are still not showing up in the list there! I have checked and double checked and it's as if it's still pointing to the live database on the live server where these fields do not even exist yet.
View 3 Replies
ADVERTISEMENT
Aug 22, 2010
Only my local dataset updates when adding, deleting or editing records.The Source Database is supposed to update on issuing DataAdapter. Update(dataset )However, when I check my source database after running the operations it remains the same as the original.
View 6 Replies
Sep 22, 2011
I have created a simple database table in SQL Express.Now, I would like the data in the table to appear in a VB datagrid.But, I cannot brows the connections in VB2008 express(data on local PC why ??
View 3 Replies
Jun 4, 2009
I hve been working with points a lot recently, and I have been wondering if there is a way to set a point without setting point.x and point.y separately. For example for (3, 5): Point1 = (3, 5) But that isn't right
View 4 Replies
May 22, 2009
I created an application using the Ping control. So far, when "Button1" is pressed, it performs a ping test to [url]... How do I create it so that it will display a message in RichTextBox1, depending on whether or not it was successful?
View 1 Replies
Oct 24, 2011
What is the best way to easily switch from a test database to a production database in vb.net and MySql, when all MySql connection strings are currently hard coded?
View 3 Replies
Jun 21, 2010
i do my final project IDE for HTML.In that i decided to create a environment which is in power point.that is if i code HTML in rich text box i save it in a file and i have a web browser in the same page in bottom which shows the design of web-page simultaneously.in that i need to create a webbrowser in side which shows the thumnanil of the webpage.if i click a button of next for designing next page i need a another webbrowser in side like powerpoint
View 1 Replies
Nov 26, 2007
Does anyone have any code for creating a system restore point in windows xp?
View 3 Replies
Jun 21, 2009
How would I manually create a reparse point in a file and do all that stuff. I read up on how but it didn't make enough sence for me to comprehend on how would I visually show where to create the reparse point. I understood that it had to do with storing part of the file in memory for fast access and giving it a name to access it faster.[URL]..
View 8 Replies
Jun 14, 2009
I'm writing a tool that will have -at some point- to create a torrent. Now the tool is big and 'creating the torrent' is only a small part of it so I thought I can use a command-line utility that creates torrents but sadly it seems that there are no such tools available for windows ( found some for linux ). What are my options here? Should I just write a tool that creates torrents out of directories (I don't even know how a torrent file should be structured)? Or is there a way to control a GUI-Based application using my VB.NET program? ( Guess only C can do that, right? )
View 6 Replies
Sep 18, 2011
I want to test if a file exist and create it if necessary.Former I did it by testing folder and file then creating it.I want now to play with "try catch" exception handling, but it seems more heavy.I had to test the file twice..... Is there a cleaner way ?
Sub CheckLogFile()
Dim tempFolder$
'check MY_LOGFILE exist if not create it
[code]....
View 6 Replies
Jun 28, 2011
in order to create fancy custom end caps on the ends of a line, a structure like the following can be used:
Dim pts() As Point = {
New Point(-2, -2),
New Point(0, 0),
[Code]....
be used to create the same point array. I can see splitting these values into an integer array but how would these in turn be placed in a point array of whatever size is defined by the text values so they can be converted to end points of a line that is developed as values are changed in the text box.
View 3 Replies
Apr 11, 2011
How can create a unit test for the the Page_Load function in ASP.net?
I am using build in Visual Studio Unit test frame work. I want to create a unit test that check the Elements of the web page and their values.
I know about selenium and its abilities in unit testing.
This is the web Page to test WebPageControl.ascx.vb:
Public Class WebPageControl
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
[Code].....
View 3 Replies
Mar 12, 2012
I'd like to create a simple application to determine the writing speed. In this application I want to view a line of text (may be more than one line) to the user to write it. And I want to select (higlight) the character the user pressed in my line and to move like a cursor to the next character (or to put underline under the current charater). How can I do that? and what is the object or component i must use to insert the text. Finally, if I want to make it multiple lines how to determine the enter key pressed by the user and how to move the cursor to the next line?
View 2 Replies
Sep 16, 2011
I need to create code to send an e-mail within a coded ui test and cannot get anything to work. I seem to be having trouble getting the correct Import. We use Outlook.
View 3 Replies
Apr 22, 2010
How can I write a unit test to test the actualWidth property to a userControl in Silverligh 4? I hoped that this method would pass, but it fails. I am using the Silverlight ToolKit april 2010, and VS 2010.
<TestMethod()> _
Public Sub TestAcrtualWidth()
Me.MyUserControl.Width = 100
Me.MyUserControl.UpdateLayout()
Assert.IsTrue(Me.MyUserControl.ActualWidth > 0)
End Sub
View 1 Replies
May 13, 2012
I'm currently starting a new job in which I will be working on some coding in the future and need some advice on some good places to start so I can learn this correctly. Essentially we need to bring VB4 code over to the new VB.net language and I will be tasked with this. The project consists of a large battery of tests for psychiatric patients consisting of mostly multiple choice questions presented one at a time - since VB4 isn't very compatible, I think I will create a new battery from scratch while using the old code as a reference point.
I started creating the code this weekend for fun and am really enjoying it. However, a huge problem has been the abandonment of control arrays in the new language... by the time I got to creating my first questionnaire I'm stumped and can't follow the old code. Clearly I'm not ready to tackle such a large project with no experience and need to start from scratch; who would have thought .
The reason why I'm here is not to ask you to help me with my work. What I'm wondering is if any of you have any cool advice of great places to start learning the language (books, websites, etc). The amount of literature is very overwhelming so I thought I would ask some people with experience for tips. If any of you have stumbled across learning material with emphasis on coding that would be useful in the design of questionnaires or multiple choice exams, it would be particularly useful.
So far my starting place is Visual Basic 2010 Step by Step with Michael Halvorson, it seems good at a glance in the sense that it couples theory with practice but I'm already sure I'll need a little more.
View 12 Replies
Sep 17, 2010
I'm having a bit of a problem with a loop I made. So the setup is as following:We can create a routing somewhere in the world, from point A to B...and the program draws it on a worldmap.then I open a file with 300 zones in all over that country and he also draws these zones (it can go from polygons to circles. Some of these polygons are really small...when I click on a button I only want to see the zones which are connected to that routing...
So I use following script:
[code]...
this works fine, but not for the very small zones...I think when he uses GetRegionScans from those small intersections...the RectangleF is so small that he thinks it's empty.
View 1 Replies
Feb 28, 2010
I have a table with 2 rows named timeStamp and value. I know I can iterate through the rows and create points and add them to a list (new point(timeStamp,value), but is there a way to do it without iteration?
View 11 Replies
Feb 14, 2011
I have a Diagonal line drawn on a picture box on my forum and i need to know if the user has clicked the line I have the Start point and End Point of the Line and the mouse x,y location So i basically need to find out if the x,y of the mouse is on the line.
View 2 Replies
Mar 18, 2011
when using the ExecuteReader() command with an SQL database, with an example as follows:
DUReader01 = DUCommand01.ExecuteReader()
DUReader01.Read()
DUCounter01 = DUReader01.Item("Counter")
I am looking for a simple code example that will test to determine if the database first is empty before attempting the Item()
command.With the above example, the Item() line produces the error "Conversion from type 'DBNull' to type 'Integer' is not valid." for an empty database.
View 4 Replies
Sep 30, 2009
I am a new user to VB and I am having difficulty with one of my assignments. The assignment states that to create an application that allows a user to enter three test scores each for three students. The application should calculate each student's average test score and assign a letter grade. The application should prompt the user for each student's name and three test scores.
[Code]...
View 3 Replies
Oct 15, 2011
I am new to vb.net database programming yet i want to create a point of sale software using it. So far I have created a local database, POSSdatabase.sdf , and I have 2 tables, Inventory and Transactions.
My problem is how do I relate these 2 tables? I have primary key Item Code in both tables. I want to make Inventory table as main maybe, and transaction will reference any data from it. Edit]Another problem is how do I calculate value Quantity and Price column in Transaction to a new column Total in the same table.
View 1 Replies
Aug 21, 2009
I have a simple .NET 3.5 app for changing some database fields using an ODBCDataSet. Now the Feature Creep is asking if I can hide or show tabs and other controls based on the user's database permissions. Ideally, I would like to control the permissions only on the SQL Server using Windows user groups, and the app would not have any built-in authentication or permission system--it simply uses the logged-in user's Windows account for the database connection. So thus it would have to "test" the permissions to determine whether or not to show the tabs for the user. For example, if they have "write" permissions to a certain table, then the tab for editing it would be visible; if not, the tab never loads for them. How can I list or test the user's permissions to the ODBCDataSet?
View 2 Replies
May 6, 2008
I am new to Visual basic and am using visual basic 2008 to write programs in, I have setup a database connection and the connection string is currently stored in the settings section of the project.I would like to have a menu item where when the user selects "test database connection" it will run the sub for testing if the database is established.
View 2 Replies
Jun 4, 2010
I have a text box which I'm saving to a database. Before doing a addnew which add a line to the database with a Id number and a blank item, I wish to test the textbox for actualentry before. Here's code I'm tryin
If
Me.TextBox1.TextLength > 0
Then
[code].....
View 1 Replies
Jun 3, 2009
I am having a problem with a unit test I have created. First time doing this so I am not sure why I am getting this error [code]Test method ETDS_Unit_Tests.LoginTest.ValidateUserNameTest threw exception: System.Data.SqlClient.SqlException: 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).This is the same connection that my software is using, and the software runs fine, only the unit test is failing. What I am doing wrong? It Seems to fail one time for each datarow in the table.Also, I am using a Linq Query in the method that I being tested. I believe that this may be what is causing my error.
View 2 Replies
Jun 3, 2011
I use Visual studio 2008 I use MYSQL 5.1 I want only to backup database Test to to a specific directory.I use the application settings to determine which directory(see attachment).Green shaded code works perfect.
Red shaded code works not!! This is with My.settings.I can not see the error code, it goes too fast, I can not capture this with:
[Code]...
View 5 Replies
Jul 2, 2009
I am accessing an sqlite database file from my VB.NET application.Currently, I use Try... Catch when opening the connection to the database, however if the database is locked by another application, it will take 5-10 seconds to throw the exception which says that the database is locked.
So I want to know if there is a way to test if the database is locked before I try to open the connection... because the long 5-10 second pause is annoying.
View 1 Replies
Dec 31, 2010
I'm trying to extract a piece of text from within the string, defining both a starting point and an ending point. For instance, say I want to search for the text found between "That is a " and " car" in the string "That is a red car", so it would return "red".I know you can use .SelectionStart and SelectionLength, but the length of the word can change, so the selection length can vary. What I want is to establish a specific starting point and a specific ending point from which to extract the text from the string.
View 5 Replies
