I am working with Vb.net and have a form with a combo Box. On load the form is loaded with one of the following details depending on what is stored in the database; Cancelled, Processed and Failed. [code] Then I have an update button and when the user drops down the list he/she can select between Cancelled/Processed/Failed. I want to be able to grey out or disable Processed and Failed, so that when the user updates the field he/she can ONLY update with the Cancelled option ONLY.
I have developed some software(vb.net) that records fees paid by the students. The purpose is that the database should be stored in a server, which can be accessed from any stations linked with it.This is working fine with a network of 10 computers. I need to publish it over the net so people could do this job logging in over internet. Database (access database) should be stored on a web based server.
ive made changes to my data stored in the database for a login i.e. ive changed the password that is stored in the database however for my application to continue the previous password still has to be used does anybody know why and how to change this, this also is the case for new entry's in the database i.e. new users. I also had an update button that also no longer works i think this is because of the same problem. I think the problem is that its saving the data changes from the update to the data set and not the database its self can this be changed?
I am working on login and registration page in vb express 2010. I have connected access 2007 database with my project and when I register as a user, it stores information to the database successfully and I can log in with that id as well. But when I close that project and reopen it, the same exact id won't work and the information in the database disappears.
I am attempting to create a tier application. Im wondering which approach would be better to take on. Should i have stored procedures on the database and then call these from my Data Access Layer (this is when you right click your dataset and add a table adapter, select existing stored procedures or create the entire query in my Dataset under TableAdapter?
My reason for asking is because my Stored procedures are created to insert and update in one command (by using an If statement), but saw the other approach recently. Any reason for one over the other?
The Intranet was done with forms authentication and stored in a SQL database. how I go about (if possible) authenticating a login in a vb.net project that queries the user settings from the ASP.Net database that was created on the SQL server for the forms Authentication.
I have a requirement for a form where user can add a list of 'documents'. These could be word, excel, images etc... pretty much anything. They want a form where they use the openfiledialog to locate the document and then want the list of documents stored on a database.
However, when they view this form they want a preview of all of the listed documents and the ability to print them all. I was considering a datagrid view with image cells but how would I show a word document in there? Or, should I insist that they convert all documents to PDF's?
Is there a function or something that is built into VB.NET so that when I save a text field (of a user's input), malicious code isn't being executed in the process.
I am developing an application that runs on a network. It needs to contact to database (access database) very very often, which is stored in server. Around 30 Client computers contact the database almost every 2-3 seconds. I need to know could there be potential manifest problem in with the application? Could there will be a problem if database is being updated by one client, at the same time other client contacts it?
im trying to read a database that is online. My goal is to be able to store a database online, and be able to edit it through my application and the web (the web part is done). all that remains is the application.
We are trying to retrieve PDF files stored in a SQL Database. We want to display them on a web page. We are using VB and ASP Code within Visual Studio 2008. We have found snippets of code, but because we are new it does not make sense to us. We are looking for infomation on how to retrieve the PDF from the database and either display directly to a web page, or write the information to a Temporary PDF file we can delete later.
I am using visual basic express 2008 . and i am adding few rows to the database using some stored procedure. it is working fine. after adding the row i am displaying in a grid using dataset . fine.but when i close the program and reopen the program i can't see any rows in the database..
I don't know the problem.this is my code to create a procedure.
Code: ALTER PROCEDURE AddNewStaff @SName varchar(50), @DOJ date,
how to calculate numeric values in a sql table in vb.net. For example I am developing a system which returns the required fields in GridView, I then copied the "NetValue" field in a list box. Is ther a way of calculating (adding them together) all the Net values listed in the list box? or is there a better way around it?
I have got a MySQL database stored on a remote server. I can user PHPMyAdmin to access the database and make changes to the table, i can also use a third party piece of software to do the same however when i try and access the database through my program it says that "Access denied for user 'lukefrost'@'%' to database 'PHCAdminSystem'". However it will allow me with the same logon credentials the other ways explained above. Can anyone help me with what the problem might be?
'IMAGE HANDLING Dim bytes() As Byte = DS.Tables("Location").Rows(0).Item(4) Dim ProductImage As Image = Image.FromStream(New System.IO.MemoryStream(bytes)) pic_ProductImageDisplay.Image = ProductImage pic_ProductImageDisplay.Load()
The error occurs line 3 stating "ArgumentException was unhandled: Parameter is not valid."
I am using VB.NET 2008 and SQL Server 2008.My program runs the below query all the time for different values, but yesterday, this query was executed, and it set the other values correctly in myTbl, but it didn't set the "Status" column to 'C' as stated in the query.
update myTbl set [Floor] = 'a',FloorConf = 'C',Status = 'C' where [myUpdateCol] = 'a-1'
There is no error when executing the query.Why the "Status" column wasn't being set correctly, and what can cause this ?
m_cmdSQL = New SqlClient.SqlCommand
With m_cmdSQL
.Connection = adoCon .CommandText = "update myTbl set [Floor] = 'a',FloorConf = 'C',Status = 'C' where [myUpdateCol] = 'a-1'
i have 31 PAIRS of radio buttons Yes or No in a web form which will insert the value of radion buttons or text of radio buttons in a single table of 31 columns in SQL server. I grouped each pair of radio button (Y and N). How can I retrieve the selected radio button value of the group and insert it into MS sql server database table using one insert command in VB.Net?
I have developed a VB .net application which uses SQL CE as its database engine. It works great so far. I recently added a section to remove unwanted reports which are stored in the database. The app correctly pulls ReportIDs from the table, which the user can select. The program will then delete the records based on the ReportID from the database. I know this records because, for testing purposes, message boxes inform the user of how many records where collected.
Dim SQLDeleteData As String = "DELETE FROM ReportData WHERE (TableID = @ID)" Dim Con As New SqlCeConnection(DataBaseCon) Dim DeleteData As New SqlCeCommand(SQLDeleteData, Con) Dim ReportDelete As Integer = -1 DeleteData.Parameters.Add("@ID", SqlDbType.Int).Value = CInt(ListView1.SelectedItems(0).Text) noOfDeleted = DeleteData.ExecuteNonQuery MsgBox("Records Data Deleted " & noOfDeleted)
When the form refreshes to show the user the possible ReportID's, the list no longer contains the recently deleted ReportID. Now this is where I am getting confused. When I go through the server explorer and look at the database there, in the appropriate tables the data still exists. Through the server explorer new query builder, I can still create a select statement to allow me to view the data I just deleted. Does the server explorer create some type of local cache that replicates the database in someway? Are there really two copies of the database somewhere?
How to retrieve the particular column row to the text box?
I mean how to display it in textbox?
The column has got different rows.
The code I wrote in vb net is :
cmd = New SqlCommand("select ida from Issue where aname='" + TextBox3.Text + "'", con)
In the above line I compare the textbox3 data in the table.And if the data matches then it should display the ida that matches with aname row to textbox4.
1. Since the plate number will be stored directly into the database after being converted from the image. However, due to the conversion process of the image into text takes few seconds, it is not able to be stored into the database... May i know is there any code that can solve it? Maybe can delay the process of storing the plate number?
2. Why during running my VB, when i click on the listbox, sometimes it will immediately pop up a dialog box to ask for video source, but sometimes not? How can i solve it?
Actually I have datetime value stored in the database. What I am taking from the textbox is a time value. I want to extract those results from the database which are between the given time value....To be more concise, my application is a booking system for a sports club and provides an option to view alreaady made bookings.. Here i offer two options either to view all bookings for a specific game or to filter bookings. In filter bookings one option is to filter through date and time...Date option is running okay but problem lies in time part...I provide two times but unable to view bookings between them...
My code is:
Dim prmtimefrom As New SqlParameter("@booking_time", SqlDbType.DateTime) prmtimefrom.Value = TextBox3.Text Dim prmtimeto As New SqlParameter("@booking_tim", SqlDbType.DateTime)
I'm trying to make alterations to an existing Crystal Report form in a VB.net project I've inherited, and it's my first time using Crystal Reports. For clarity, I'm using Crystal Reports under Visual Studio 2010, not the standalone Crystal Reports.I've had a good go at looking through all the functions and variables listed in the CR Designer, and can't find what stored procedure is being used to call for data.
I have a datatable with some rows I need to insert that datatable in to database using a stored procedure.
For Each row As DataRow In dt.Rows cmd.Parameters.Add(New MySqlParameter("@DOWNLOAD_ID", dt.Rows(0)("DOWNLOAD_ID").ToString())) cmd.Parameters.Add(New MySqlParameter("@FINALY_FIELDCODE", dt.Rows(0)("FINALY_FIELDCODE").ToString().Replace("|", "").ToString()))[code]....
When i do this I got an exception {"Parameter '@DOWNLOAD_ID' has already been defined."} How to get rid of this exception and can we insert the datatable with out for loop.
I have an app that has been localized in the usual fashion (i.e., .resx files), which handles about 95% of the strings. However, I still need to localize some strings for category names that are stored in the database. I'd like to avoid adding 15 new columns named categoryname_ES, categoryname_FR, etc, and then pulling the right column dynamically. If there would be some way to pull the data, and then do a substitution in the code, I think that would be a little less messy. Maybe along the lines of:
go through gridview row by row if the language selected isn't English, look for this text value in a global resources file and replace it. Or is adding a lot of categoryname columns for each language just the way to go (ewww).
I have an app written in vb2005 that allows users to search a sql database for a store name. Once a store is selected, it then presents the user with 12 different tabs, each with a DataGridView showing various bits of info about the store. It's a large and convoluted database, so I'm using stored proceedures to pull the data for each tab. Here's a sample of one of the subs that populates the tabs.[code...]
Now, this works just fine to populate the grids on the tabs, and the same code is copied into each of the subs that fill the grids (changing the stored proc, parameter and grid names, of course). The problem I'm having is how to move changes made to the data in the grid back into the database.
I have stored procs that do this (and the procs do work), I just can't seem to figure out how to trigger the stored proc when the user makes a change.
If it matters, there is only a grid on each tab, I did not use a binding source as I am trying to keep an abstraction layer between the data and the app. I did create a dataset, which is how I gain access to the stored procs, but I left the grids unbound and (as seen in my code) bind them at run time.
VB.net seem to place my database file into/userprofile/local settings/apps/2.0/data/random/random/appname/data/ folder.Can I define easier location for my published app. I am also worried that when upgrading this database is ignored or something bad happens?
I have my requiremnt as follows. I have a database consisting of text, image columns. Now I would like to query the database and display the result on to a word document. I have that resultset in a dataset. Now I would like the result in paragraphs manner in word document.
I have a small application that (Adds, retrieves and deletes) info from/into access 2007 database file.I'm using Oledb (Online Mode) .I use this code to save new record to the database file[code]...
