Reading Forum Input - Opening Database Connections And Calling VB Code
Jul 31, 2011
I am extremly new to this concept of aps.net and vb. all the tutorials I see are c# based or very basic for vb. What I have is a contact forum with some basic information. I got the whole "check if the user has input information correctly down pat how ever Its this whole, connecting to a database (sdf) if in another vb file ands calling that method into aspx file and proessing forum input to say "take this, insert into bla..." I come from java, JSP and J2ee bak ground where its not that diffrent and I dont have all week to read books and take baby steps. I have until tuseday morning to finsih this. Right now I am as far as forum validation....
[Code]...
View 1 Replies
ADVERTISEMENT
Nov 25, 2008
<edit on 10th March 2010.>
Changed thread type to QUESTION. I was then able to mark AS ANSWER the relevent post which now also immediately follows this post and so it is easier to find as suggested by forum user j2associates .
<edit> It is also my 3rd post in this thread, the 8th one up, of my posts, from the bottom ( for now ), as the forum format has changed yet again.I will leave the rest of this post( as is ) purely for historical reasons. I have been on these forums long enough to see 3 forum changes. <edit> 19th May, 2010> Link added to a video on the next line of text.
[code]....
View 1 Replies
Jun 12, 2009
it might help to change the forum name to Visual Basic .NET General Forum. or VB.NET General Forum maybe would help the vba and vb6 developers know this is not for them.
[Code]...
View 1 Replies
May 19, 2010
I have seen in the past that many aren't familiar with how to insert code so I put a little two-minute screencast (a video done in Flash with no audio),url...
View 15 Replies
Aug 8, 2009
So I'm trying out a concept tool of mine where I need to be able to read and write data from a database real easy. I've set up the form as I like and spread around different text boxes and dropdownboxes to read the data from the database. And I've got it all to work and all, but there's a small bug I don't fully understand why's there. Some textboxes don't update the text from the database.
But it seems as it only occurs if the data in the database is nothing. So the value from the last row is still hanging in the textbox and thus, clicking "Update" actually updates the value from the field from the last row, into the new row. Messing everything up.
[Code]...
View 2 Replies
Jan 16, 2009
One of my new year resolution was to make an automatic forum poster script , but till now i dnt have single clue of how to do that, kindly give me an direction to go with or source code of any such software.
View 3 Replies
Aug 14, 2009
This thread (Question) is a continuation of a question answered by JohnWein. the original question asked by me in this thread:http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/thread/4d9b44a0-91ed-4f64-a3a2-74afffce2256 an this is the answer:
[Code]...
The question is, in the case of four connections, how can I make sure that all points are connected with minimum number of connections using the same above code?
View 1 Replies
Oct 19, 2009
Im trying to make a program and i have everything done but i need to make a login bar that if the user logs in, it takes them to form10 but if they log in and they are in a special user group on the forum (VIP) they go to form11.
View 39 Replies
May 20, 2010
How to get the active connections like these examples does I just want to keep it simple but basicly i want to get some information about the network connections that are open like these examples does
View 3 Replies
Jul 19, 2011
Using VB.Net and SQL Server 2008 R2: I have recently had a database that using sp_who2 reflects a connection ".Net SqlClient Data Provider" is still active even though the .Net application has closed and disposed of all connections.
[Code]...
View 1 Replies
Jan 11, 2010
I'm trying to find where this code might be leaving old connections open, and I found this code that might be the cullprit. It is in a function. I'm wondering if this connection would close, if an exception occured from within the USING statement?
[Code]...
View 3 Replies
Jul 28, 2009
i've been previously using Visual Studios built in wizards for manipulating data access to and from an MSAccess Database, however just recently i coded my own classes and connections to the database, ive been able to select, update and delete records effectively however my problem comes with inserting records.
I have a 3 tiered table database:Tbl_PO, Tbl_Parts, Tbl_Shipments each po has multiple parts, each part has multiple shipments.when i insert a record into the tbl_PO, i need to retrieve the ID used on that insertion.
View 4 Replies
May 28, 2010
i need a way to open a offline registry and read the oem info from it. The registry will be from a a hdd from another pc atached to mine. What im trying to accomplish is open the offline registry and read the model/serial info on it. i am able to read the registry of the booted system but no a offline one.
View 3 Replies
Oct 23, 2010
I am making a windows application that should validate user input before opening up the next form page. I can get the error messages to show, but after correcting the error, they won't disappear and open up the form.
[Code]...
View 4 Replies
Aug 19, 2009
I'm doing an application which uses the Database Wizard to link the textboxes, labels, and combo boxes to the data base. (Visual Basic in Visual Studio 2008). (Visual Basic 2008 by Shelly Cashman-Chapter 10)There are two problems: One of the combo boxes has the unique key identifier. You are supposed to be able to use the combo box arrow to select one of the unique keys. Every time I click on one of the unique keys to see the records connected to it, VB acts like I'm trying to input a duplicate key. My teacher hasn't been able to figure this one either. If I was connecting the code, I could fix this but I have no clue since I have to use the Database Wizard on how to fix it.
View 4 Replies
Mar 8, 2011
I am on a general scenario of deploying my vb.net database application on my client's computer.
Thinking of future problem of changing the database connection setting, i am planning to store it in a normal xml file in the app directory so that where ever it is installed, in order to make database configuration i only need to make change to that file and my program runs smoothly.
So is this idea of storing database connection setting to xml config file in app directory or is there any other better idea?
I am planning it for vb.net winforms applications
View 1 Replies
Mar 16, 2012
This may have been answered but my search hasn't found what I was looking for. Basically, I am developing an application which allows the user to build a query at design time, i.e. for users with no prerequisite knowledge of SQL The application thus far allows the user to select which table(s) from the database they wish to start querying (I won't go into the details of the rest for now)
My confusion is this; I already have the connection to the database in a subroutine which obtains the schema information and filters it to display only the available tables within the database, which then compiles the data into a listbox, here is that sub:
[Code]...
View 1 Replies
Dec 21, 2010
Is there any other way to access a serial port using visual basic.net 2010? I followed the steps in this site, [URL] but I just got this output Open the serial port. Send the attention command to the modem. Wait for data to come back to the serial port... and stopped there. I can't get the Read the OK response data in the serial port. Close the serial port. And I was thinking, because it is very much easy to access serial port in vb6, so can I just use vb6 and then connect to visual basic.net? it is like a language inside a language.
View 3 Replies
Mar 25, 2010
I have an multi-database ODBC connection through a DSN. There is a primary database and two auxiliary catalogs. The Add Tables dialog in Microsoft Query only shows the tables in the primary database. If I pick one and continue on, the lists of columns in other parts of MS Query show all the columns in both the primary and auxiliary databases. If I pick a column, MS Query will look for that column in the primary database (great if it happens to be there, not so great if it doesn't). If I don't use any of the drop-down lists and just write a query in the freeform SQL editor, fully qualifying everything with the catalog names, the query runs fine.It looks as though MS Query is assuming only one database and one (default) catalog, and doesn't realize that it actually connected to several databases with separate catalogs.I get the same results with Office 2003 and Office 2007.Are multiple databases / multiple catalogs through a single DSN supported in Excel / Microsoft Query?
View 1 Replies
Apr 8, 2011
I'm running a program where I call a function which creates a database connection and then runs a stored procedure. I call this function four times from four separate threads. I get an error (Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection.
Exception Source:
.Net SqlClient Data Provider)
when I use multiple threads, but if I have the threads run one after another I have no
[code].....
View 1 Replies
Mar 14, 2011
I just want to know, What parameters or attributes should be taken in connection string so as to handle high traffic enterprise applications? Like in general we use server, initial catalog, userid, passwd. Some times we add timeout , and in some scenario pool etc. But i don't know what attributes should i take in as my common practice apart from above.
View 3 Replies
Nov 11, 2010
I have an application running with a access db. I have written some code to copy & zip the db file to another location (selected by the user) for the purpose of backup. (I am using sharpzipwrapper)Whenever I try to run the code for the copying & zipping it gives me an exception saying that the file cannot be zipped as it is use.Do I have to close all open connections in order to backup the .accdb file? If yes then how? else what do i have to do inorder to get 'access' to the file.Do I have to exit the application to close all connections? These connections are written in code for e.g. :
dim
cnStudent as
oledbconnection
[code].....
View 5 Replies
Dec 21, 2009
I am reading file with text contents on it.sample dictionary.txt contents:
aa
abaca
abroad
apple
Snippet A:
Dim path as String = Server.MapPath("dictionary.txt");
Dim dictionary() as String = {}
Try
[code]....
Basically, I want to make sure that I can handle/prevent this error.Does Snippet B, solves the problem, if not is there other way so that I can prevent this error.BTW, this a web application and I am expecting multiple users.
View 1 Replies
Nov 28, 2009
I am working on a project that needs to read a file, no prob I have that part but, how do I code it to read the file and get say the highest, lowest, average and sum of the numbers in the file? Everything I have tried didn't work and left me with a blank application.
View 8 Replies
Jun 11, 2009
I have an application which connects to a database, retrieves a username from a user's table and matches it against the username retrieved with System.Security.Principal.WindowsIdentity.GetCurrent.Name.On my localhost, everything works fine. The database exists on the development server but the application lies on my localhost. All of my authorization and authentication techniques are running smoothly.However, when I publish my application to the development server, I'm faced with the following error.Cannot open database requested in login 'databaseName'. Login fails.Login failed for user 'DevelopmentServerNameASPNET'.
[Code]...
View 4 Replies
Apr 26, 2009
I am a noob to VB and have tried messing with this code for hours now.[code]How do I get the line of the file to correspond with the number that is inputted in the text box? [code]
View 5 Replies
Jun 22, 2010
I am using VS2005 version of VB.Net programmer. I wanted to use the user input but most people tell me to use console...but I cannot use this function since my version is different, it will not show any results. I found that using mask textbox can use to read the user input but I don't know how the code can be written. I want user to input two number such as 1.345 and 2.355 and use this number for addition and give the answer. I not sure how I write the code for mask textbox to be read once user input the numbers.
View 1 Replies
Oct 19, 2009
I can call C code from Visual Basic by compiling that C code into DLL's.
1. Does it have to built in Microsoft Visual? Or is something built with MinGW okay?
2. How do I add it into my VB project?
3. How do I actually make the function call? (given that VB and C syntax obviously have some differences)
View 5 Replies
Sep 20, 2010
I have 19 .CSV files that hold engineering data in single and multiple Arrays.I would like to loop through the Directory that contains the files and open each file, fill the array and close the file and continue to the next in Alphabetical order.
This code tells me how many files I have now and will update if I add more.
Dim FolderPath As String = IO.Path.Combine(Application.StartupPath, "DATACSV Files")
Dim TestFolder As New IO.DirectoryInfo(FolderPath)
Dim FileCount As Integer = TestFolder.GetFiles().Count
FileCount give me my number of files but not sure how to continue. I have the code to open and read the file but not how to keep changing the file name for each new file name base on the number of files that exist.
View 23 Replies
Jan 26, 2010
I have a project that has some VB code in it that I'm not allowed to convert to C#. I work in C# and not very good at VB, but I am needing to modify that VB code to use some C# methods I created.
For example:
C#:
Code:
using MGCIS2.Reporting;
using CrystalDecisions.Shared;
[code]....
At this line in the VB code (Dim crv As New Tax.Reports.CrystalReportViewer(_rdbc)) it is giving me an error:Too many arguments to 'Public Sub New()'
View 1 Replies
