I need to retrieve a portion of xml into a datatable
<Product>
-<productID>123</productID>
-<productName>123</productName>[code]......
Now Under product tag there are ProductID, ProductName and ProductFeatures.Under ProductFeatures tag there are three "productfeaturetext" tags.I only need to extract "Features" tag into a datatable to loop it, how this can be done ?
how i see if my cache is empty all my syntax errors are coming when i am trying to see if the cache is null and if it is to run the stored procedure
If RadioButtonList1.SelectedIndex = 0 Then
If Cache["netcache"] = null Then
bcmd.CommandText = "yearlynetsales"
[Code].....
i have a datatable with about 10000 rows and few columns (4)I have noticed that the process of reading a big table its quite slow..is there a way to improve performance in reading a datatable?
View 15 RepliesMy program reads a 3rd party .txt file using OleDb and reads the file into a datatable. It's overall working fine except a user will occasionally have a problem reading a file. At this point.
Line that gets hung up
Try
Dim comm1 As New OleDbCommand("SELECT * FROM " & safeFileName & " Where " & Status & " = '" & StatusClosed & "'", con)
Dim dasold As New OleDbDataAdapter(comm1)
dasold.Fill(dtsold)
AddColsold()
[Code] .....
It can not retrieve a date for one of the fields, then gives error and does not get dates for each records after the one it gets hung up on but the date is in the file. If I open the file in excel and play with the column sizing, for instance just autoformat column width then it read the date and will work fine. I have looked at the file in notepad and cant see anything wrong in particular on the record it gets hung up on. I have no control over the .txt file since it comes form a 3rd party.
I have an untyped-Dataset with two related DataTables, and I have a grid bound to the parent DataTable. I used the WriteXMLSchema() method of the parent DataTable in order to save the schema in a xml file. Then I opened the file with the Notepad, deleted two columns from the schema file and saved it. After that, I used the ReadXMLSchema() of this DataTable but -contrary to what I would have thought- the DataTable's structure was unchanged. Using the debugger I noticed that after calling the method the number of columns was the same. Why? How can I make the DataTable's schema to be changed by using a file?
notice that I am using the DataTable's methods and not the Dataset's because I do not want to touch the child DataTable.
Dim ds As New DataSet
Dim xmlfile As XDocument = XDocument.Load("devices.xml")
Dim reader As XmlReader = xmlfile.CreateReader
[code].....
I want to import data from excel and move that to Datatable in VB.NET 2008. I wrote and working but its taking too long time.. for 1500 records its taking 4.40 min.
[Code]...
Heres the InnerException:{"Unable to read data from the transport connection: A blocking operation was interrupted by a call to WSACancelBlockingCall."}Stack Trace:
" at MyNetworkStream.HandleOrRethrowException(Exception e) at MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count) at MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count) at
[code].....
I've been searching but just can't seem to find an answer. I can't believe this should be hard but I just can't get it to work. I'm reading in some records from an Access DB into a DataTable. I list one of the columns in a listbox. The user selects an item, then I want a textbox to display what's in a different column for that row.
[Code]...
How can I only add the decimal part of a number to another one?
example: if a number is A = 10.25
Then X = 30
Y = X + 0.25 (Here it added 0.25 which the decimal only NOT 10.25)
Another example, If X = 16.35, A = 102.001
Y = 16.351
I was wondering what the easiest way is to get a portion of text from a string for example, you have:
"example1,example2,example3"
And i need to be able to get all three of the items separate:
"example1"
"example2"
"example3"
The length and number of items will change, I'm using a listview subitem
Lets say I have a variable: varEmail. It contains a variable equal to the user's email address, so it might contain a value likeNow, lets say I want to get just a portion of the email address, e.g. strip off the domain, like so:
View 5 RepliesI am trying to extract the first portion of a string up to the first SPACE or any non-numeric digit.I thought I could do it but the string may contain an alphabet in the front followed by varying digits of numerals, making it more complicated.Here are some examples of the string to be parsed and the expected results:
String[code].....
I would have to use a series of instr statements but the code would be much cleaner using RegEx.
I'm trying to look in the program files for a directory(the gimp directory). I could hard code it but they change the file name and the exe name with the versions. So I only know that the folder contains the word gimp. How do I search for it only knowing a portion of the file name.
My.Computer.FileSystem.FindInFiles(Environment.SpecialFolder.ProgramFilesX86, "gimp", True, FileIO.SearchOption.SearchTopLevelOnly)
This is the code that I've tried but it just doesn't work.
I have a drawing image, Dim DrawingImage as Image = My.Resources.Img, which will be drawn on my form. The DrawingImage is supposed to be 64x64, but the Img.png is 114x114. How can I get this DrawingImage to stretch so that there is no cut off portion?
P.S. Is there a way to BringToFront this DrawingImage?
What I would like to do is to be able to save a portion of the screen, from Start_X, Start_Y to End_X, End_Y, and then use it as a resource as follows:
DrawImage(SavedImage, New Rectangle(Start_X, Start_Y, End_X, End_Y))
I have a picturebox. I want to at certain points take a screenshot of whatever is in that picturebox and write it to a bitmap variable.The images in the box will be of varying sizes and i will be tracking the sizes using image.height and image.width. I would like to use those to define the area for my screenshot.
View 14 RepliesHow do i access another user's registry portion in win XP?how do i access another user's HKey_current_user on my machine, in vb2005 or if someone can recommend a software that can already do it.Im trying to make a quick registry repair tool to fix a damaged or corrupted user
View 2 RepliesI have a combobox which is filled with items from a table like this: [Code] What Im trying to do is to when I choose one name from the dropdown list the firstname shall go to one textbox1 and lastname go to textbox2. One way doing this may be to use the ID column wich is the the Primary Key. And do a new search in a button with that ID which fills the textboxes. But how can I get just a portion of the selected string in the combobox to a string so I can do a search on it.
View 5 RepliesI have a sql table with the following fields
ID = PrimaryKey (nvarchar(50))
Name Surname
sample value of ID = RHO-1 How do i automatically increment the numeric portion when adding a new record to the database eg: RHO-2, RHO-3 and so on.
I have a third party GIS tool that I'm using to view maps with. Occasionally we have to take a snapshot of a portion of the map and dump it to a bitmap. The third party tool has a function that will give me the upper left and lower right coordinates of the area selected on the map. These coordinates come out as system.drawing.point objects.
The two point objects are then used to generate a new system.drawing.size object that will give the height and width of the area selected. The height and width values are passed to the constructor for the system.drawing.bitmap.All this works fine most of the time. Sometimes, however, when the user selects a particularly large area, the bitmap constructor bombs with a 'parameter is not valid' error. There isn't any documentation on this error, but I'm assuming it means the height and width are too big.
So what I'm wondering is... is there some way to check my height and width values prior to creating the bitmap and make sure they are in acceptable bounds?
Assume I have a form that has say 5 text boxes and I need to pull some data from a database then set those 5 text boxes with that data.So assume I have 3 basic layers: the code behind for a default.aspx page a BLL class that contacts the DAL and a data access layer (DAL)But I've heard and read that the default.aspx page should not know about sqldatareader, in fact you probably dont want to add the sqlclient namesspace to the default.aspx code behind page. [code] Then the BLL would simply call the DAL to call a stored procedure in SQL Server and do a CommandObject.ExecuteReader, get the results pass it back to BLL and BLL would then send it to the code behind page of default.aspx.I can provide full source code if that doesn't make sense. My question is if its bad that default.aspx actually declares and knows about an SQL Data Reader then what is the better way to do this? What datatype should I be using to avoid having an sqldatareader in my interface code ?
View 2 RepliesI have a userform in 2008 vb express edition. A part number is created from user input via a concat string. I want to then check if a certain portion of the part number exists in the existing file names in a directory. Below is a more detailed explanation.[code]...
View 2 RepliesI need a Data ComboBox having GridView in it's List Portion to have multiple columns in it. Purpose is Consider a 'Products Combo Box' where i want following fields to display
1] Product Icon
2] Product Name/Description
3] Product Price
4] Product Stock In Hand
where i can Format the 'Price' field to say Currency Type, 'Stock In Hand' field set to Particular ForeColors (at Run Time) depends on wheather the current stock is Negative or below minimum range or adiquate stock and so on. Similar controls are already available with MS Access so Why Not In VB?
I know there's way to display portion of image from the original image size, however I still unable to do it successfully. Is there any good examples for me to refer?
View 3 RepliesI have a list box with information that needs to be displayed in a text box. Each of the lines in the list box has 2 types of information-Name and setup data. When I click on the line I need only the setup data to be displayed in a text box. This data on all lines begins at the 42 column. I can display the information using SelectedIndexChanged but the entire line is displayed. In other words I need to display only the data from the 42 column to the end of the selected line.
View 2 Replies[URL] how to enable highlighted portion in visual studio
View 8 RepliesWas trying to make a little project which will login to a site. The problem i am facing is with the captcha code display..
Was searching around to get the captcha to the form directly but didn't found anything useful.
So my question is how to display only the area of the captcha on the form instead of the complete form.
Like suppose I want to display only the portion where the logo of Visual Basic .NET Forums - The Exclusive VB.NET Community is located instead of complete webpage.
Application using : VS 2008
Answer expected for : VB 2008 or C#
If I were to draw a rectangle with e.Graphics.FillRectangle(), how would I make a circular portion of the rectangle transparent?
View 1 RepliesIn VB6.0, you could create a sub that took an array byref, and then call it with an argument that was an indexed element of the array, and it would treat that index as the starting point. This was very useful, for example, if you were trying to create a binary string to send over a communication port.The same thing doesn't work in VS 2008,Let us say for example I have the following Sub:
Public Sub HexToAddr(ByRef addr() As Byte, ByVal addrstr As String)
Dim i As Integer
For i = 0 To 7[code]....
Is there some tricky way to make this work, or do I really have to either (a) create a completely separate array of bytes, call the function, and then copy the data, or (b) create a completely separate version of HexToAddr which takes an "offset" argument for the destination array?
