Accessing Data Which Resides A File Outside The Application?
Feb 11, 2010I am using dotnet frame work 3.5. I need to access a file and reads the file which resides in a common path outside the application.
View 1 RepliesI am using dotnet frame work 3.5. I need to access a file and reads the file which resides in a common path outside the application.
View 1 RepliesI want to import an excel file in .net. Excel file resides on server. when I try to imort the file using below code , i am getting error.
Protected
Function
ExcelConnection() As
[Code]....
If i import excel file from local drive its working fine. But when i try to import excel file from server(URL of file) then i am getting error.
I am getting error(Oledbexception Failure creating file.). how to import excel file that in resides on server(file is not on my local drive, i will access file through URL).
I developed a project in VB.NET In this project I want to use data from MySQL that is resides in my WEB Server.I can communicate with the MySQL server of my localhost but can not communicate with the WEB Server.
In my CPanel I added Host from the Remote Database Access But I can't communicate with WEB MySQL Server.
[Code]...
Does anyone out there have any experience programatically retreiving the lat/long from a GPS attached to a mobile PC?team I'm on is currently looking at hardware options--as the programmer who will eventually have to live with whatever is selected I was wondering if anyone out there has had experience writing .Net programs that interface with a GPS?
View 4 RepliesIt's all fine, accessing files and directories by using a dynamic link library (DLL), but is it possible to do online?Suppose I want to parse a file, which would normally be simple in visual basic; is it possible to call functions from a DLL using a server-side language, say PHP?
View 1 RepliesI developed a custom help system for my ACCESS 2007 application using Help Workshop. I wish to open this .chm file by a command button on a form but does anyone know how to do that?
View 9 RepliesI have a problem with accessing a data file from Access database. Data Source configuration Wizard comes back with a dialoge box saying "Error Message: Could not load type 'Microsoft Visual Studio.DataDesign.SynDesigner.SyncFacade.SyncManger' from assembly
'MicrosoftVisualStudio.DataDesign.SynDesigner.DslPackage,version = 9.0.0.0, Culture = netural,PublicKeyToken=b03f5f7f11d50a3a
My computer is a Vista and it have known to have lots of problem, but not sure if this is one of it.
I'd like to create a new file everyday for a logging application to minimize size when accessing. I'm after a couple of pointers with respect to when to create the file, and what checks to do etc.
View 2 Replieshow to find the form that a component resides on.
I googled this and found several articles stating to do it as follows:
vb
Public ReadOnly Property FindForm() As ContainerControl
Get
Return mc_FindForm
[Code]....
I would want it that upon pressing the Tab key in the last control of the TabPage then it will go to the next tabpage and focus on the first control there that has its TabStop set to true. I could trap the Tab key in my current implementation but is there be an easier way?
View 13 RepliesI have a software called Portal sold by Synapse Inc. It is basically software which interacts with microcontrollers.I need only some of the features of that software for my use. So i am thinking of developing a GUI which can emulate those feature and interact with the microcontroller. Am i going in the right direction in starting to develop the GUI?
View 2 RepliesThis application uses a Microsoft Access database named Books to keep track of the books in a store. The database has one table named tblBooks. The table has five fields. The BookNumber, Price, and QuantityInStock fields are numeric. The Title and Author fields contain text. This application should allow a user to enter an author's name ( or part of a name ) and then display only the titles of books written by the author. Displaying the information in a DataGridView control; however, don't allow the user to add, delete, modify, or save records. I need to allow the user to specify the records he or she wants to select while the application is running. Also, i need to Add a text box and a button to the BindingNavigator control. The user will use the text box to specify the records he wants to select. The user will use the button to tell the computer to display the selected records. I also want to display the total value of the books in the store. I am not getting the BindingNavigator control in the component tray in my program I've included. Also I am working on the code for the display button but I need some tips. I am trying to complete this program and only expect guidance.[code]
View 12 Repliesi have an application for which i have created help files which are html files. my pplication resides in a directory for which the system path comes out as c:Document and settingsvisual studio 2005crmscrmsindebugcrms.exeI have the help files put under the crms directory which has the bin as its sub directory.i.e. c:Document and settingsvisual studio 2005crmscrmshelpmain.htmlIn my application i would like to access this file and launch it in Internet Explorer. I dont want to hard code it as this will be deployed on a terminal server and therefore i would like to use a relative path. I searched on the net and could only find solutions that used Application.StartupPath or few others which point to the exe file.
I tried extracting the path before that and managed to get a substring which held contained c:Document and settingsvisual studio 2005crmscrmsTo this appended the helpmain.html, i tried launching the file as followsSystem.Diagnostics.Process.start("iexplore",s);where s, stores the appended string. This is the error i get, cannot open file at location:Document%and%settingsvisual%studio%2005crmsc rmshelpmain.htmlIts not liking the space in the path, is there anyway to resolve this.
I have developed a windows application for my company. It is a multi user software and we are using sql 2008 as the database. The sql 2008 is installed in our company server. Within our LAN, there is no problem in accessing the software and its working pretty fine.
Now the problem is, some of the managers need to go out frequently(for business tour and all) and they need access to this software. The software is already installed in their laptops.Is there any way to access the database that is in our company server ???
We have few static IPs with us, is there any way i can use that here (Using NAT in the firewall or something)?
i m preparing a project in vs 2008 i m unable to add new row to my database. i have created database in Microsoft SQL Server Compact 3.5 (.NET Framework Data Provider for Microsoft SQL Server Compact 3.5)my problem is the data is updated in dataset but database is not updated.please help me out as i have to submit my project on 20 of aug 2009.
View 6 RepliesI've an application that's uploading data to a server. Occasionally the server returns a 403 response from a call to HttpWebRequest.GetRequestStream(). The response contains more data than simply the response code, but I can't figure out how to access it. Is there a way to do this?
View 2 RepliesSo I'm a little rusty on my VB.NET skills, but I decided to take up a project to get me working in it again. Problem is I've hit a slight road block and I was hoping someone here might be able to point me in the right direction.I have a spreadsheet (or 3, but they could be combined if that makes it easier) that contain interest rates. I need my program to use user-input to select which interest rate it needs and then calculate and output the grand total, without the end user ever seeing or even being aware of the interest rate table.
View 1 RepliesI have placed a button on data repeater (called datarepeater1) so that it is repeated with other controls. When I click this button, How do I access/reference the text value of a textbox control called TxtAnimalID on the same row? (This would be something like the current row I am on).
View 2 RepliesPrivate Sub btnsave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnsave.Click
'If inc <> -1 Then
[Code]......
i got an error at the time of execution .
Is it possible to add, edit, view and delete records using a file only (instead of a database) and .Net 2005 (VB.Net/C#)? The concept is that a file that'll work more-or-less like a database. One can add, edit, view, delete and query data to and from the file. The file, either cannot be opened directly or data inside the file should be in some encrypted form so that even if the file is opened no one can comprehend it. Data inside the file can only be manipulated by a front end application i.e. .Net 2005.
View 1 RepliesI am using Ms-Access 2007 with vb.net. My problem is that I have a table with column name strval which has following values:
2, 3, 43, 5, 6 etc., in each row.
Now I want to search for that row which contains e.g 2 in column strval. I use
SELECT *
FROM tbl where tbl.strval IN( '2' )
but this doesn't work.
I'm using VB 2005 Express Edition.I'm trying to use VB to do a few things, the first of which is to display the data behind the registry key at;
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\SvcHost\netsvcs.
The data I want list should look something like:
6to4
AppMgmt
AudioSrv
Browser
[code]...
This shows no errors initially, but complains about not being able to convert "string()" to "string" once I run it. I'm assuming this is because the data I want is a line of string entries, but I can't find a solution.FYI, this is a project I'm working on to heal a Conficker attack at work. Our third party support has stopped the spread and healed the servers, but has now left me with the job of doing a 3 minute registry fix on each of our 400 computers, hence the attempt to automate it!
I'm populating a DataGridView from a file with the following
Dim fnum As Short = FreeFile()
Dim inputLine As String
Dim i As Short = 0
Dim strAuditDate As String
Dim strAuditTime As String
Dim msg As String
[Code]...
When I do this, the MessageBox.Show shows the contents of a row, which is tab delimited. How do I get the data that I read to display in columns of the Gridview?
I am having some trouble accessing the data in a listview. The data in my listview is popluated from the database which works fine. What I want is the user to be able to click on the entry in the listview and it show them a messagebox with all the data from the listview. I have 1 main item and 2 subitems in the listview.
View 5 RepliesI am calling an Oracle function PKGDummy.F_EMPDATA using vb.net.
View 1 RepliesNew to VB.net, and trying to re-factor an 'old-skool' ASP page where all the page logic is happening on the .aspx page itself, to code-behind. Basically, I have a button that has a state, either on or off. If on, I set a hidden field to 1, if off, I set it to 0 (the default when a user visits the page).The goal is to simply change the message I am sending to the user.[code]The above code produces the following effect: when I click the button, setting the state to 1 and the page reloads, in Page_Load, I am getting zero results from the If dlList.Items.Count > 0 Then check, and thus am showing the 'No results' message, but the actual asp:DataList on the MyPage.aspx page is returning results... and then if I click the button again, setting it back to 0, in Page_Load, the datalist is now returning results, so I set the text to 'Results', but again, the control on the MyPage.aspx page behaves correctly, and shows no results, as expected. Now keep in mind that the above works perfectly in terms of checking the number of results if I move the If dlList.Items.Count > 0 Then page logic out of Page_Load and back to the MyPage.aspx file, it all works fine (i.e. results when state = 1, none when state = 0)
View 2 RepliesI wrote the following code to create dynamic controls-textboxes and labels.
ctlRow += 1
ctlRowLocation += 25
Dim new_ForceLabel As New Label
[Code].....
How can I access the data entered into these textboxes.
I am trying to write an application that accesses the SMART data from a hard disk, so I can show all the values and whether anything is over the threshold or failing etc Have spent many hours trawling the web without any success.
View 15 RepliesI have a small databse program. Form1 uses the Private Sub OpenToolstripmenu to Openfiledialog box and creates a connection and adapters. I need a second form that will access the same connections and adpaters what is the best /correct way to do this? Also other sub functions on form1
View 8 RepliesMy problem is that i have a usb-to-serial device which creates a virtual serial port ( Com 4 for example )on the computer i need to connect to it and get the data stored on it I already have worked out how to use the System.io.ports to connect to the port ( baud rate, stop bits, parity ,ect) and it connects to the usb fine. But once the connection is open i don't know how to retrieve the data. Everything i have tried relies on events. But as the usb does not send data i don't know how to access the serials memory.
View 3 Replies