I want to connect data from any folder in my computer.After user click browse button it appear any location for access database folder.After that user click connect button and but i have facing connection problem.
Under Browser Button
Using ofd As New OpenFileDialog
ofd.Filter = "mdb files |*.mdb"
[Code]....
I am trying to add a data source from a connected database but it doesnt seem to be working well.Initailly the table name was mispelled and there where fields missing. The table was modified to include the new fields and it was also renamed.The changes are reflected in the dbml file within the project, and the solution has been built with a sucessfull result.The problem is, when I try to add a new data object into my solution, the changes that were made to the database arnt reflected in this new data object.
View 3 RepliesI'm trying to "convert" an Access DB to a stand alone application. I have under estimated the differences between VBA and VB. Although I have many questions, I'll focus on this topic first.
The Access DB collects and maintains SNMP traps from a radio station. I import CSV files from a remote Unix server via FTP, parse the text line-by-line, and add to a table as a new record. So far, I can parse the text and add to a dataset but I want to write directly to the data source. I also need error handling that will trap errors for duplicate records. There is a Reconcile function that ensures that all lines in the CSV files are added to the table before the files are permanently deleted. Here's what I have so far:
Public Class clsRnm
Private msTrapTable As String
Private moTrap As clsRnmTrap
[Code].....
I used the ODBC Data Sources admin panel to create a "data source" for an ".mdb" file. This was very easy. I can access the mdb (database) file via an ODBC driver, locally. However I need to access this data source over the network. Can anyone please help me learn how to make this same database available on the host's network interface? Perhaps there is a tutorial, video, or some other documentation that explains how to modify a data source to make it available on the network. I am using Windows XP. I hope this does not require a special Windows server distribution.
View 11 RepliesAfter I published my application and then installed it to the same computer i used to develop the application, there was an error during the installation, the data source file was not found in the new location set by VBE 2010. How to make sure data source file will be installed at the pre-defined location? so that there will be no installation error.
View 9 RepliesI refreshed my data sources to include additional items from the SQL Server databases and it appears that my entire data source from my VB.NET project disappeared.I am using Entity Framework. I may have clicked on something wrong, not quite sure. Unfortunately I can't recreate the Data Source without creating a new Entity and Data Model.I can delete the entry in the App.Config file and recreated it, however things aren't quite right.Is there a way that I can recreate my Data Source from the entry that is in my App.Config file...since that appears to have remained intact.BTW, I can go to my Data Model and successfully refresh from there, however my project isn't connecting to the database so I have quite a number of errors until I can get reconnected.
View 4 RepliesI have an Access database and I want to view on a datagridview specific rows. For that I used the following :
CasesBindingSource.Filter =
"OfferDate Between #1/1/1997# And #12/31/1997#"
Cases is the table, OfferDate a field of the table wich is DateTime type.
When I use Between operator I get the following error :The expression contains unsupported operator 'Between'.
I'm trying to make a client and a server connected in vb 2010. how to make a client and server connected? There is only vb2008 in the codebank and if my vb2010 tries to convert it to vb 2010 it will error.
View 1 RepliesI want to write a program that if ping www.microsoft.com is success,than caption title it's "ok,connected Internet",if ping it's failed,the program "caption" title is "sorry,not connected",but I don't know how to write those code
View 10 RepliesOn my program I am trying to make a ToolStripStatusLabel's text change to "connected" if connected to a network and if not connected to a network change the text to " Not Connected" then I don't know how to display a image if connected to a network or not connected. So if the computer is connected to a network I have a image that I would like to be displayed next to the ToolStripStatusLabel. And if not connected to a network, can the program display a different image? I tried this:
My.Computer.Network.IsAvailable=True(ToolStripStatusLabel2.Text "Connected")
My.Computer.Network.IsAvailable=False(ToolStripStatusLabel2.Text "Not Connected")
I am trying to find out if the connection of my sockets (TCPClient) is connected or not connected. I am using the following code:
[Code]...
I have to write a program/application (which I already started in VB.NET 2010) that connects through Panasonic KX-TEM824 PBX machine via RS232 port (cable already connected : COM15/16 depending on USB I connect) and while it's connected to parse(receive) the data from the PBX itself, data that has caller ID, time of call started and ended, duration of the call and etc. I have found some already application on the Internet that does the work but they are free to try after awhile requires to buy or restart the app again. But I assume there's not much to implement on the code side.
Imports System
Imports System.ComponentModel
Imports System.Threading
Imports System.IO.Ports
[Code].....
I have problem to read XML source to datagrid.I can't put data subject and subsec to column and click at row show data all_topic in textbox .I try code but not show.I want result show Principles of Programming Languages 800 and when click Principles of Programming Languages show
Topic : Make Class
Detail : Student's Principle of Programing lang make class in 30/12/2011
Date : 2011-12-18 20:36:09
Adviser : Corets, Eva
[code]....
Using Table control: how to display data from connected MSSQL?
View 2 RepliesI would like to read the (Any)webpage source(Not using StreamReader) even if the webpage loads inside iFrame.
View 1 RepliesHow can I show a website source code without the use of web browser. I only need the source code, i don't want to see the images or any other things.
More Info:Just like when you go to a website and if you are using Firefox you click CTRL+U and it will show you the page source code.
I want to read specific information from a website, but i don't want to the website to take longer on loading. (Because of Images)
I am trying to read product caracteristics from the source code of my supplier web page and store in my database. The code i created is just to show me the characteristics in a messagebox then i will store them in my DB. But i get an error in the If atrname.Count <> atrvalue.Count Then since values did not match titles count.[code]...
View 3 RepliesI'm trying to read the source code of a remote .xml web page.
View 2 Repliesthis is a code that read the source code and then show the source code on the txt box ...
i wold like to search in the soure code about a word ( ex. keyword , table , window ..) and after finding the word .. it show the word in the txt box
Dim http As New Chilkat.Http()
Dim success As Boolean
success = http.UnlockComponent("Anything for 30-day trial")
If (success <> true) Then
[Code]......
I am trying to get the webpage source code using HttpWebRequest instead of using ebbrowser. So i can use it as a string and use regular expression on that string.I have googled "HttpWebRequest" but all i found was this code which isnt working or i dont know how to use it.
VB
1. Public Shared Function GetPageAsString(ByVal address As Uri) As String
Dim request As HttpWebRequest
[code]....
I'm new to Visual Basic, VS2005.I've added a Table to the WebForm. At Default.aspx this code was added automatically:
[Code]...
i try to read the source code of a web page but i have problem.When i use View Source from IE or FireFox i see all the code of the page.I try to take the code into a txt file with .NET 2005 Visual Basic because i have to read 900 pages.
the code i use
Dim myPageInfoPageURL As String
Dim myPageInfoPageResult As String
Dim myPageInfoPageHTTPWRQ As HttpWebRequest
[code]....
I need to get some parts of the source code (mainly product characteristics) from the web site and insert in my database:I need to get some parts of the source code in my db, which are the product characteristics and the it contains its value
Example of what i need is :
</div>
<div class="clear"></div>
[code].....
I have three tables: BOOKS(BookID, Title, Author) CLASSES(ClassID, Title, MajorID,BookID) and MAJORS(MajorID, Description). I added these three tables to a LINQ to SQL class (UBooks.dbml) and then connected to the data sources. Then declared DataContext.
Using LINQ, my goal is to display all books in a grid which I have done with:
Dim allBooks = From Books In db.Books _
Order By Books.BookID _
Select Books
Me.BookBindingSource.DataSource = allBooks
Next I need to display all majors in a listbox. I would like the description to be shown however I am only getting the majorID to display with the code
lstMajors.DataSource = db.Majors
I have tried db.Majors.Description, however I am told then that Description is not a member of the LINQ table. and my final goal is to display all the books for whichever Major is selected in another data grid. This is what I am primarily concerned with right now. When using the SQLClient classes, I was able to create a string joining the tables (also had the description properly showing in the listbox, but that is of little importance right now to me). In the video tutorials I was able to watch whenever the tables were dragged from the database into the OR designer of the LINQtoSQL.dbml class file all of the associations were already there and the narrator only really had to do some drag and drop. Not only is drag and drop not working without these associations, but I'd much rather learn the code behind it.
I want to read a specific line from an html source code. Im storing the source into a string file and i want to read the line X.So im using this method that i found on net
Public Shared Function ReadSpecifiedLine(file As String, lineNum As Integer) As String
Dim contents As String = String.Empty
Try
Using stream As New StreamReader(file)
[code]....
I am trying to edit (in Visual Basic Express 2008) the source code of MapWindow's CSV to Shapefile plugin url... to read directly from a datagrid view. My datagridview is successfully created with the following code in frmMain:[code]With the help of BackWoodsCoder I was able to add the datagridview column names to the X and Y combo boxes but that's where I get stuck again. The original source code appears to re-read the delimited text file instead of using existing object code.I did try the MapWindow Forum first but have had no response thus far.
View 1 RepliesI'm trying to save the source of a site and then read certain lines, this works once. The second time I get this error: "IOException was unhandled"
Public Function GetNumberOfLines(ByVal File_Path As String) As Integer
Dim SR As New StreamReader(File_Path)
Dim NumberOfLines As Integer
[Code]....
I am writing a small app that is retrieving data from a device connected to a virtual com-port. I connect without problems to the device using the settings 9600-8-N-1.
I need to send the command <esc>MS , the device then sends back the data to a computer. I have tried this using Hyperterminal with success. I also did this with Excel and VBA. I used the MSComm32 Active X control:
MSComm1.Output = Chr$(27) + "M" + "S" + Chr$(13)
Msgbox(MSComm1.Input)
This made the data from the device pop up in a messagebox. I am writing a winforms app in vb.net, using VS2005. I have a form, on which I have a Placed a SerialPort control, named sp. My sample code is as follows:
Private Sub Form1_Load(ByVal
sender As System.Object,
ByVal e
[CODE]...
This returns the error message "Error: expecting a command". I have done som tests in HyperTerminal, and have concluded with:
-If I dont send <esc>, I get error "Expecting a command"
-If I send wrong command (ie MD instead of MS) i get error "Bad command"
Based on this, I suspect that I don't pass the escape character correctly to my device. So I wonder how to do this?
I need to be able to click a link from a vb6 program and call a number via a connected mobile phone.(Assumption: the mobile phone is already connected to the PC via bluetooth on com3)
View 1 RepliesModifying data with the ListView's EditItemTemplate by programmatically settings its DataSource property and calling its DataBind method. I don't have option to use data source control for ListView. All ListViews are bound with data from code-behind. So, I have to handle the Edit/Update mode of ListView manually. [Code]
View 2 Replies