I have the following data in a datatable
HTML
PName - Wt
AA - 10
AA - 15
[Code]....
I am wondering if data can be extracted in following format to a datatable,
with Pname Counts:
Pname - Qty
AA- 5
BB- 4
CC- 5
(VS 2008)I'm using a C# library for my VB.NET project. And the method summary/notes or what they are called do not show in intellisense. Is this supposed to be like that? Or is there something I must do to fix it? And if not, will VS 2010 be able to do this?
EDIT: Still unresolved. Now building library dll + xml file, but how to import the xml file in my vb project?
See image: [URL]...
I was just wondering how to extract or parse any particual tags (whichever I specify) from webpages. I know how to extract text and links from webpages, but I tried to use the same method from the following code for div tags, title tags etcetera and it doesn't seem to work:
[Code]...
I am working on a project that takes an xml schema and xml data files and places them into a DataTable, the 2 files are generated from a working table that i have written to disk. I wish to load these 2 files into a DataTable. Here is What i have
vb.net
Friend Function CreateTable(ByVal tableName As String) As Boolean
Dim table As New DataTable(tableName)
table.ReadXmlSchema(tableName & ".xsd")
[code]....
this however produces the following error on line 3
Quote:
System.ArgumentException was unhandled Message=DataTable 'get_item_list' does not match to any DataTable in source.
get_item_list is the parameter passed into this function (tableName)
I have a datatable that has a resource in one field and hours used in another, it looks like this -
Resource Hours Used
Manager 1
Accountant 1
Field Staff 2
Accountant 3
Manager 4
Manager 1
Administrator 6
Field Staff 4
Manager 0.5
Administrator 1
What I want to do is be able to create a summary of the data table above that groups multiple occurrences of a resource and adds up the hours used for that resource, creating a summary that looks like this -
Resource Hours Used
Manager 6.5
Accountant 4
Field Staff 6
Administrator 7
Im using lockbits to get some img data and the img depth is 24 bit. This means that when i read the values from memory I get the following result. BLUE GREEN RED And I need them in the RED GREEN BLUE Format. I don't know if i can just reverse the bits (i don't know how) or if i need to extract the the values independently(I also don't know how to do this.
View 9 RepliesI have found a good amount of threads, but I don't know what my problem is. I cannot seem to get it. It should be simple but I cannot figure it out. Here is the HTML
[Code]....
I am using DotNetZip for use of extracting a .ZIP from the resources. When I run the standalone .EXE, errors appear about a missing DLL, so I added it into the resources via the properties panel, but I still get the same error. How do I use the embedded .DLL?
Another question, might be the wrong place to ask it but I am having problems extracting 'Conroy.zip' from my resources using DotNetZip. If anyone could show me the code or give advice,
I want to extract some information from a web site (Bloomberg). This side has a search textbox with a onKeyUp event that, as far as I can understand, uses AJAX to create a table. Is it possible to insert some text in the textbox and then get the table created with AJAX? Given the source code of the page with the tabled already AJAXed (If you understand what I want to say here), I can easily retrieve the table. I just need to get the source code with the table already on it.
View 7 RepliesI am having files in resources I want to copy to temp and then run it
Saying if the file is iphuc
Copying it
Then
Process.star(iphuc)
I am trying to create an application to make self-extracting Exe's in Visual Studio 2010 Express. I would like to have a box in which files can be dropped into, then when you click "Compile" it will compress all files dropped into the box along with 3 others I must have delivered to this self-extracting exe. When the newly created exe is run, it will launch "Install.exe". I know there are other items out there to build the self-extracting exe's. I would however like to make my own that always delivers these 3 specific files along with whatever is dropped into the application.
View 11 Replieslets say webpage has 2 strings named sampleObj="sample1" and sampleObj="sample2" Even though sampleObj remains the same the text inside, however, changes.How would you loop inside page and get sampleObj text each time? I tried Regular Expressions and GetElementsByTagName but no luck.
View 1 RepliesI recently started learning Visual Basic, so my knowledge base on it is very poor.What I am trying to do, is creating a simple form with three scroll bars for RGB colors (valued from 0 to 255) and according to the RGB values changing the backcolor property of a picturebox.
I ran into a dead end while trying to convert the scrollbar integer values into color values and I have no idea what to do. Any suggestions how I should perform these kind of operations?
Ok I got a variable named Accounts and stores the user accounts. They are seperated like this
Account|Pass|Admin&Account|Pass|Admin
As you can see after admin there is a symbol (the &) meaning that before the & its an account and after it its another. In other words its like this
Account|Pass|Admin
Account|Pass|Admin
so how can I make a loop to count how many & there is in the Variable named Accounts?
I have the follow row of sample data:
Quote:
RickiKitt10|NzMyMQOTkQ|173.234.120.242:62063:accessworld:bYRLngChRYc||RickiKi1037||
How can I extract the IP address? 173.234.120.242
I'm trying to extract the text between: <label for=field_1> and </label> I have captured the HTML into a string using the webbrowser control, and am using the following function to try and get the text within the tag:Public Function midReturn(ByVal first As String, ByVal last As String, ByVal total As String) As String
[Code]...
However, this code will not work, if I use <label for=field_1> as the first string and </label> as the second.
I had a richtextbox1 contains the following text:
<REPLY username =chicco1502
status = OK
user_id =3377436 >
<user_register.php: 2011-02-19 10:00:06
POST
username=edwardzhao
[Code] .....
So once I click button1 it should extract only Email plus Password into
Email: Password
edwardzh*2@hotmail.com:640716
gabriele.sc*hi@email.it:010585
So the email symbol is email= <email that should be extracted here>
and so the password sympol password= <password that should be extracted here>
Source code [URL]
I have following data in the arraylist..
HTML
ID Type Size
1 Car 1 1000
2 Car 2 1100
3 Car 3 1200
[Code]...
I have been working lately on a program who extracts URl Source codes!The program does work with most of URL but not for MEdiafire URL!When i check the source code from the web browser i can see there is some code missing;y tried diferrent types of Encoding.
Example:This is the final source code extracted from WEBBROWSER(Firefox,InternetExplorer,GoogleCrome)
--------------------------------------------------------------------------------------------
<div class="mf_lightbox_btns lb-footer" style="text-align: right;">
<a href="javascript:void(0);" class="secondary btn" onclick="$('body').removeClass('has-virus'); return false;">Dismiss Message</a>
<a href="http:www.bitdefender.com/mediafire/fix-it.html" target="_blank" class="alt btn">Get BitDefender</a>
[code]....
I have a text file I'm trying to pull specific data from to make a report in excel and am wanting to know if my code can be improved or if I have something wrong. If it's apparent to anyone that I should be doing something elThis code does work but, very slow. These reports take up to 20 minutes for about 100 files so I am wanting to decrease the time somehow. I have attached the whole sub in a text file, it's about 900 lines long so don't think I should post all of it. This is one part that seems to take the longest:Partial code that reads the text into a string, then each line is read to find whether it holds the data or not. Inside this while loop, I am checking numerous lines to see what they hold and extract specific items. First I verify it's a interface by checking for "line protocol".
Dim str As StreamReader = File.OpenText(filefound)
While (str.Peek <> -1)
If txtLine.Contains("line protocol") = True Then 'Found an interface,
[code].....
I'm trying to create a small program, which I think will be helpful to others(in here). My aim is to convert the English text shown in screen to Malayalam. English-to-Malayalam conversion is not a problem. But the problem is, how to extract the text from the screen. In most of the converter/translator, the text needs to be copied or written down in the translator tool. But my program will cut off that part. That is, simply move the program window (having a rectangle hollow portion) to the English word that needs to be converted. And upon pressing a button (or autodetect), the English word is converted to Malayalam.
So, my question is how to extract the English text(or words) from the screen (which is seen through the hollow portion of the window.
Here's a screenshot of what I'm trying to do.
How would I create a dir Inside %temp%? Then extract the file to it and Open a That folder. So far this is my code.
[Code]...
I try to view a datagrid with one empty row in it when the form loads. The datagrid has to be bound to a datatable all the time.I get a NullReferenceException with the following
Dim dt As DataTable
dt = CType(Me.grdDataGrid1.DataSource, DataTable)
Dim newrow As DataRow = dt.NewRow()
newrow(0) = 1100
dt.Rows.Add(newrow)
The error occurs on the line where dt.NewRow() is used.The problem occurs when the datatable (and the datagrid) is empty. If they have data, this works ok.What do I have to do to get this to work with empty datagrids?
I have a DataGrid that a user is sorting, problem is that the sorted results are not being updated in my DataTable (which makes another function fail later). I have tried calling AcceptChanges() after the sort is done, but that isn't updating the DataTable. dtMessage.AcceptChanges()How can I have the DataTable updated after the sort to diplay what is displayed in the DataGrid ?
View 2 RepliesWhen I dispay data sets in a Datetable control. It started with showing the focus on first cell ( i.e. cell(0,0)). How can I set the initial focus to other cell (say cel(3,4))?
View 2 RepliesI have a listbox connected to a datatable. When i click a button, the marked item should get deleted. How?
View 5 RepliesI have a DataTable that I need to get a subset of into another DataTable to bind to a control. Is there an easy way to do this?
View 4 RepliesI have an sql database with multiple tables. I have been adding new columns to one of the tables as I need them, but now suddenly it has stopped allowing me to add columns.Everything works as usual until I add the 150th column to the table. When I drag the table from the server explorer to the dataset designer i get the following error:"Some updating commands could not be generated automatically. The database returned the following error: Dynamic SQL generation is not supported against a SelectCommand that does not return any base table information.If I remove the 150th column, everything works great. I tried using the wizard to regenerate the select and update statements, but it fails with the same error.
View 5 RepliesI want to be able to turn a datatable or dataset or the results of my SQL queries into JSON - purpose is for a WCF service which will not do it.
View 2 RepliesI have picturebox that the user can import an image, and then save it to the datatable. I can save it with no problem, and the image, which is a logo, will populate onto my crystal reports pages.My issue, is that I want the logo to automatically load into the picturebox when the user opens my settings form. How can I do the opposite of the following:
'set the company datatable for sub
Dim borrowersrow As PlannerFilesDataSet.CompanytableRow
'use only the first row
[code]....