DB/Reporting :: Unable To Come Up With Any Relevant Documents
Apr 27, 2008
I have created a web application that is used within our company to track our inventory.What I would like to do is create a windows forms application that I can distribute to certain managerial staff with some additional functions.I have tried googling this, but am unable to come up with any relevant documents. What I need is some direction on how to implement login through my windows forms application that will validate login against the ASPNET_DB so that the same roles and logins can be used.
View 1 Replies
ADVERTISEMENT
Feb 2, 2010
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)?
View 5 Replies
Sep 3, 2008
When trying to create a new data source to a sql database (database up and running with no problems) I get the following error message when testing the database connection
Quote:
Unable to open the physical file "". Operating system error 32: "32(The process cannot access the file because it is being used by another process.)".
View 1 Replies
Oct 7, 2008
i am trying to create an sql parameter but i am having an error. it gives me an error like this: Unable to cast object of type 'System.Boolean' to type 'System.Data.SqlClient.SqlParameter'. on all of this line
Dim paramcollection As New List(Of SqlParameter) ' no error on this part but the lines below gives me an error:
paramcollection.Add(New SqlParameter("@CGLCode", SqlDbType.VarChar).Value =
[Code].....
View 4 Replies
May 17, 2011
[code]I want users to be able to click on the checkbox in field4 and add all of the data plus the word Holiday to my database when they click on the box in that field, but right now it's not allowing me to click on the checkbox, can someone please assist? Also, I did have this working for that field but it would only allow me to add the first line of data, what in my code would not allow for the additional lines to not add their data as well?
View 1 Replies
Aug 3, 2009
I have been using Access 200 as my database of choice with Visual Basic 2008 Express.I am trying to start usingSQL Server Express but having a difficult time with it. All of the instrctions I have tri9ed seem to be written for someone who already knows the answers. Here's my problem.I wrote a program using Access, with one table and five queries and it works fine. Using that program as a baseI created an SQL Server database within Visual basic. Naturally I changed my code to reflect SQL rather then OLEDB.When I try to run the program I get an error message telling me that the database is not registered. When I use the SQL Server Management Studio Expres, it shows my database by give a big message that the database is not registered.
View 3 Replies
May 22, 2008
I have an Access database that is updated directly in Access. I'm trying to write a program to 'monitor' the database, and have a DataGridView control showing the contents. When the program is first started, it shows the current data in the DB fine, however, I've been unable to get it to refresh with any updated data from the mdb file. I have a timer running on 5 second intervals, and if i clear the dataset, the DataGridView refreshes to empty.
[Code]...
View 10 Replies
Dec 20, 2011
I have a project that is used as management for a YouthFootball Team. Part of this is adding training fees and keeping track of who has, and has not paid.This part of the project is adding the fees to the relevant textfile.Textfile - Trainingfees.txt
Each line looks like - player name|number of sessions attended|amount paid I have a form with a DataGridView. Each row is populated with: Checkbox Column, Player name in textbox column, blank textbox coloumn The user then ticks who attended the training and how much money they paid in that session.
I then have this code to loop through the DataGridview and add call a separate function that adds the relevant information to textfiles.
[Code]...
View 6 Replies
Dec 14, 2011
The help in visual basic express 2010 directs me to the web,My searches often pick up info on C pgms and VB 6 etc.I have been adding VB 2010 to each of my searches.e.g. Format vb 2010.How do others search for relevant info in these web searches.
View 4 Replies
Feb 4, 2010
I'm a relative newcomer to VB.NET so please forgive any lack of knowledge.
I'm writing a web application that lists the contents of a directory in a listbox and then (in theory) opes the file that the user clicks on.
What I'd like to do is open the listed file in it's associated application (so if it's an excel file, open excel; if it's a notepad file, open notepad).[code]...
View 10 Replies
Jul 16, 2011
Im trying to start a report that will generate a new word document and fill it with all the relevant bits and pieces im trying to figure out the relevant reference to add to the project but nothing springs to mind when im browsing through the references folderiv seen this and tried it and unfortunatly it doesnt work it says doesnt contain any public members or cannot be found
View 1 Replies
Dec 23, 2010
After I ran a disk-cleanup (in my case AVG PC-TuneUp), the loading of my VB.net project gave error on a missing file.Changing the build-configuration (DEBUG->RELEASE->DEBUG) would recreate the file and all is OK. But I have basic configuration-info for the build, maybe in more complex cases some important details could be lost when the file gets deleted.I would think an information as critical as that, would be placed in the project folder, or be part of one of the many files that make up the project, but not in the temp-folder.
View 7 Replies
Mar 12, 2009
I'll start off with a brief explanation of my situation. I'm doing my A-Level coursework project at the moment and am having some difficulty trying to figure something out. My project is a VB.NET Program that connects to a Database to display/add/delete/update records. At the moment I am having trouble with one particular thing which must be solved before I can move on (and the deadline is fast approaching).
I have a combo box which contains a list of different item types (Which match up to the item types used in the database, but it is not filled from the database). When the user selects one of these options, the list box below must fill with all items of that type that are in the database.
Unfortunately I'm at home so I can't get access to my coding, but I can try to explain what I've tried. I've tried so many things after trawling though what seems like endless amounts of tutorials to find an answer.
One thing that is used in pretty much all of them is the SQL string to select the needed records;
"SELECT ItemName FROM Stock WHERE ItemType = Anime"
Now, this has been used many different ways. I think the way that I'm trying at the moment is to create a new data set that contains the records that are needed for the search. There is already a data set that contains the whole table that is needed for this particular form. I think my most recent attempt was trying to copy the relevant information from the original data set to the new one, but I can't get any coding that isn't incorrect.
View 12 Replies
Feb 10, 2010
I have a datatable which has rows of product names. I have a table in SQL Server which has product details, with ProductID.I need to retrieve the ProductID for each product name. I can do this using a for each loop but this is way to slow. Is there a way to retrieve the relevant ProductIDs for the products with one transaction rather then using the for each loop?
View 3 Replies
Jun 9, 2010
I can achieve in VB what the following C# snippet does but it seems very clunky since I perform a Linq query to obtain the events for the relevant user. Is there a neat way?
ctx.FetchEventsForWhichCurrentUserIsRegistered((op) =>
{
if (!op.HasError)[code]........
View 2 Replies
May 11, 2011
I'm really hoping I can describe this question in an understandable way. This is a puzzle that I have not been able to begin to solve even though I (mostly) understand it. I'm just not sure where to start, and I'm really hoping someone out there can get me headed in the right direction.
I have a LARGE table of data. It describes relationships between objects. Let's say the Y-axis has items numbered 1-1000, and the X-axis has items 1-1000 also. If item #234 on the Y-axis is related to item #791 on X, there will be a mark in the table where the row and column cross. In some industries this is referred to an a Truth Table. One can, at a glance, see how many items in a system relate to each other. The marks in the table can help to identify trends and patterns.Here's some other helpful stuff about the nature of the table:
The full range of the number of relationships (r) for each item on either axis can be 1 <= r <= axisTotal.The X and Y axis will share common items, but each axis will also have items that the other axis does not.Each item will only exist once per axis. It can be on X and Y, but it would only be on each one 1 time.The total number of items on each axis will most likely NOT be equal. Each axis could have from 50 to 1000's of items.
The end result is that this is going to be a report that needs to be printed. We have successfully printed a table that had about 100-150 items on each axis on an 11in X 17in piece of paper. Any more than that and it begins to be so small it's unreadable.
What I am trying to do is split the super large tables into smaller tables, but related points need to stay together. If I grab item 1-100 on X then I would need each item they relate to from Y.I've generated a number of these tables and, while the number of relationships CAN be arbitrary, I have never seen an item relate to all other items. So in real practice the range is more like 1 <= r <= (10% * axisTotal). If an item's relationships exceed this range, it can be split up into multiple tables, but that is not optimal at all.
At the end of the day I think we, and our clients, would be happy if a 1000x1000 item table was split into 8 to 10 printed pages of smaller, related tables.One other thing worth noting, there will be no empty rows or columns in the table. Every item on both the x and y axis will relate to at least 1 item on the opposite axis.
View 2 Replies
Aug 19, 2011
Hi, I need to program a simple Web Browser that can search for keywords and store relevant data in another file.I am facing a problem with authentication, mainly cookies and maintaining a session.So I read that Web Browser Control is based on I.E.? So may I know how are cookies and session handled?Do I have to implement them manually or are they stored and retrieved from the same folder as the one used in I.E? If so, if I delete the I.E.'s cache, am I also deleteing the cache of any Web Browser I make using Web Browser Control?
View 2 Replies
Jun 2, 2010
What I am trying tot achieve is the following:User inputs data in one form that saves to the dataset table no problems. On an edit screen I want the current data saved to appear in this page within all the relevant fields but when saving I want this data to add to the dataset table as an additional line of data so the transaction records are kept.I want to add a new datarow regardless of it saving one change or all 7 changes that are possble.
e.g. Line 1 - user inputs 7 cells of data Line 2 - user amends 2 cells of data Line 3 - user amends 1 cell of data an so on. Unfortunately the terminology for certain items above may not be correct as I am still new to this programming and still on a massive learning curve.At the moment I do not have the code for what I am trying to achieve as I really dont know where to start with it.I am currently able to save the data and have it appear in the "edit" panel however only the cells changed are saved an it overwirtes the initial input.
[code]...
View 2 Replies
Jan 9, 2009
I want to do something like this:
Code:
'create a dataset and a table
Dim ds As New DataSet
[code].....
View 5 Replies
Aug 5, 2010
Is it possible to load 2 documents in a printpreviewcontrol.
My program asks after a invoice was made if you want to print the invoice and/or the shippinglist.
Both are 2 different documents, so i was wondering if i can load them both.
View 2 Replies
Jul 7, 2010
Is There any control in dotnet in which we can view ms office documents (doc,excel .. etc
View 1 Replies
Jun 2, 2011
I have a slight problem. I have created an application where I am using linklabels to refer to a website, this works with no problem at all, however the problem that I do have is I cant work out the command to refer to a file or document.The code to refer to a file on my PC is simple enough and works fine:
View 4 Replies
Jun 30, 2009
Currenly im doin an project internet cafe management in vb.net2005 . On dat proj i need to retive no. of pages printed how to capture no. of documents printed in vb.net
View 2 Replies
Apr 17, 2011
Dim dir As DirectoryInfo = New DirectoryInfo(Environment.SpecialFolder.MyDocuments + "MyApp")
If dir.Exists Then
Else
dir.Create()
End If
I tried the above code and also this: Dim dir As DirectoryInfo = New
[Code]...
View 10 Replies
Aug 15, 2011
Is it possible to store a document in a database and then be able to load it into VB and populate specific areas with data from textBoxes? like address or name details..I suppose a bit like a mail merge ?
View 2 Replies
Feb 17, 2010
I would like my program to display a word document. I am using VB express 2005 I attached a "Microsoft word 12.0 Object Library" Below is the nonworking code I have so far.
Imports Microsoft.Office.Interop.Word
Imports Microsoft.Office.Core
Public Class Form1
Dim MSWord As New Word.Application
Dim WordDoc As New Word.Document
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click WordDoc = MSWord.Documents.Open("C:Demo.Doc")
[Code]...
View 2 Replies
Dec 21, 2010
How to get the users my documents path no matter what OS they have.
View 1 Replies
Feb 18, 2009
In my application users can highlight a collection of documents and click on a button to print preview. This causes the first document to be displayed and from there you can print. The problem is that if I choose 10 documents they have to go through this process 10 times. Is there any way I can load up all the documents into the PrintPreviewDialog at once?
View 1 Replies
Mar 5, 2011
I am creating a project that makes use of a folder, at the moment that folder is located in My documents, how would I change this to be default as in the bin debug folder.
Dim QCRoot As String = My.Computer.FileSystem.SpecialDirectories.MyDocuments + "Database Files"
View 2 Replies
Sep 28, 2011
when i click print button one word document will be displayed and name as Bill Of Lading1 but i didn't print, again i click print button i have to display one more word document name must be Bill Of Lading2 and so on if the user clicks on the button.. How to i loop for displaying Bill Of lading1, Bill of Lading2 and so on....
Code:
Private Sub ToolPrint_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ToolPrint.Click
Try
[Code]....
View 3 Replies
