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?
I've been asked to get the page counts for documents stored as tif files. What I have now is looping through our third party software to open them and then get the page count. I can't stop the image from flashing and it is very slow. Does anyone know of a way to loop through them quickly and can the page counts (one image can have many documents)?
I have saved documents into my SQL Server 2005 database and they have been converted to bytes. My web page is made with VB.NET in Visual Studio 2008 with ASP.NET. The following is exactly what I need to achieve;
1. Allow user select document with a button
2. Select the document from the SQL Server table
3. Allow the user to download this document.
The error I am getting is that Category is set as Byte and it can't be passed through GetDocument because filePath is a String. I think that I am pulling the file path from the database wrong
[Dim Category As Byte() = NothingDim fs As FileStreamDim br As BinaryReaderDim document As Byte()Dim documentFilePath As String Protected Sub ImageButton1_Click(ByVal sender As Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles ImageButton1.Click myConnection = New SqlConnection("server=ORLA-PCSQLEXPRESS;database=Edpac;
I am creating a program for my company. My goal is to create a database that manages all the documents that we have and the training progress of all the employees as well as to do some Computer Based Assessments that prints the results etc. I have watched allot of the videos posted on this website but was hoping that someone could help me with videos that explain how to play a sound when a button is pressed - How to open up a pdf form from a button or label - How to open a existing OFFICE documents like word and excel. this would help me allot - Also advice in doing a report that can be printed from the answers on the test.
import a documents path into a database and from a datagrid, when I double click on the relevant row it opens the relevant document.Also I need to be able to import the folder name as well?
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.
I have just started to learn how to use SMO in some cases. Below is some code I found from a site to list the servers and databases for each. What I would like to do is go a step further and list all of the databases and stored procedures in their own listboxes when I select a database. I would like to not include the system ones or at least have a checkbox to decide to include them or not. I searched and could not find how to do this.
Recently I have learned visual basic 2008 express edition and developed programs for data crunching and analysis. The VB 2008 express edition has microsoft visual studio 2008 v. 9.0.30729.1 SP and .NET Framework version 3.5 SP1. Now I want to create x-Y (date-Y value) graphs using the crunched data stored in an array list simulating a data base access. I download and installed the "Microsoft Chart Control for .NET Framework " and try to learn to use it within the VB 2008 express edition using the tutorial. It seems that the chart control did not get installed?
1. Do I need at VB 2008 professional to allow using the chart control? 2. Why after installing chart control, there is no change on the items under the NET components within the Toolbox>ChooseItem>. 3. How do I get to use the chart control under VB 2008 express edition. 4. Any code available to generate versatile graphics without using the chart control? Because the chart control has tons of classes already it seems the best is to just use the existing and downloadable chart control?
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.
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.
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?
