I currently have a sql select statement that selects several things from 3 different tables at the moment, here is that code:
SELECT
group_concat(w.event) as events, group_concat(w.date) as dates,
group_concat(a.time) as times, group_concat(DISTINCT w.tmc) as tmcs,
group_concat(a.weather) as weathers, group_concat(a.surface_temperature) as
[code].....
I need to connect to a web page, extract a string between <span class="uniq_name_one"> and </span> tags and display it in my program, wait 30-120 seconds and do it again....
View 1 Replieshighlight listview item from mysql search statement then get the index?
View 6 RepliesI'm trying to assign an image which is stored in mySQL database to PictureBox item.
Here is my
...
Dim rs As ADODB.Recordset
rs = New ADODB.Recordset
Dim mystream As ADODB.Stream
[code]....
Expression not producing a value [code]...
View 7 RepliesHow would I go about using certain frequency tones in my program? I need to be able to generate various tones at frequencies from about 90hz to about 2khz or more (audio frequencies). For instance, how would I play a 120hz tone for 10 seconds?
[Code]...
Regarding my college project. i'm working on a sales system . i have a form which consist of all the following information( item code , item name , item price , quantity of item ) which is display using a data grid . data input by user using text box and all this information will be stored in a database(sales database) i'm using ms access 2007. the grand total will be displayed in a text box . and amount paid will be input in a text box too , my major problem now is how to i create a reciept that will have all this information of the purcase. i have a reciept button . what the next step ? i dont have any idea how to get the reciept done.
Imports System.Data.OleDb
Public Class Form5
Dim con As New OleDbConnection
[CODE].......................
I'm wondering is there a way to check wither a dateTime is selected within particular period.Let me give a e.g:
suppose I've
date1 = "07/18/2010 08:00"
date2 = "07/18/2010 10:30"
[code].....
so im using two split containers to show four different panels at the users request using two buttons. Split container 1 works fine and will only show the panel requested by the user but split container 2 when i hit the button does not hide panel one and only show panel 2 it shows both panels at the same time yet the code for the buttons are exactly the same
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnShow.Click
[code].....
I have a directory of images that reside outside the context of my web application that I need to serve to the user. Currently I'm using an IHttpHandler to serve the images and using some javascript to navigate through a set of images (the navigation is primitive for now). I followed examples for using IHttpHandler to serve images closely but when I view the images in firefox the browser hangs and when I view in IE I get a "Stack overflow at line: 0".
Code for the IHttpHandler
Public Class ShowImage : Implements IHttpHandler
Public Sub ProcessRequest(ByVal context As HttpContext) _
Implements IHttpHandler.ProcessRequest
[code]....
I need to create an array, then iterate through a string, adding the string value to the array only is it does not already exist, to produce an array of unique values. The issue I am having is with the array.length operation - on a array that is nothing I am unable to retrieve the array length (0), as such I am unable to redimensionalise the array to be array length (must be array length as arrays are indexed from 0), providing me the ability to add the new value to the array and then continue the loop until all values have been checked to see if they exist within the array (using contains) and the value contain only unique values..
View 2 Repliesbeen working on a large scale project and Iow looking into the document print engine for the application. been a while since Ie built an app that retrieves data from the database and outputs to Word. I generally always used the mail merge feature of Word but after reading the link above this seems far easier.
View 2 Repliesi would like to know how i would extract text from a website especially out of the (span class= ) area
View 3 RepliesDim abc = WebBrowser1.Document.GetElementById("old_sl")
Dim theElementCollection As HtmlElementCollection = abc.GetElementsByTagName("option")
For Each curElement As HtmlElement In theElementCollection
Dim controlName As String = curElement.GetAttribute("value").ToString
If controlName = shortLang2("a") Then
curElement.SetAttribute("selected", "true") ' pass username from TextBox1
End If
Next
Above is the code I am using and I get null reference was unhandled error. What I want to do is to find first the element with id old_sl which is a <span> then I want to get all the elements into that span with tag <option>.
What would I need to add to my if statement to grab the inner text of that span id and place it into a Label?
vb
Dim WhatsMyIP As HtmlElementCollection = WebBrowser1.Document.GetElementsByTagName("span")
[Code]....
[code]...
Lets say you pay $900.00 for the first invoice in this list. How do I zero out that balance, AND carry the remaining $30.00 to the next invoice ($730.00) and subtract from it.
[code]...
I'm currently using this code to get the time span between the two hours.[code]
View 4 RepliesI have the following xml:
<Root>
<Result img="1.png" name="a">
<Programs>
[Code].....
What is wrong with linq query. Why does a 1 work but a 2 does not? I would also like xml structure preserved after filtering.
I am getting a strong naming violation for the dll file and really new to signing applications. How would I proceed in resolving this so that I can build the application I will be supporting? Also, as the FreeImage reference gets updated will I need to re-sign it?
View 9 RepliesI have a datatable which has been dynamically generated from FoxPro tables using a UNION Select statement. e.g.SELECT * FROM x UNION SELECT * FROM y UNION SELECT * FROM Z ORDER By v_alue1This produces a datatable with about 100 rows, each containing many fields, one of which is c_olor. From this datatable, I would like to select the distinct colors and then output in a dropdown.I have a public class Color which just has one property which I can then use as the DataTextField and DataValueField for the dropdownlist
Public Class Color
Private _c_olor As String
Public Property c_olor() As String
[code].....
I'm trying to make a simple tool to format SQL code so that I can use it in VB.When I put in the following:
USE master
CREATE DATABASE netGuest
GO
I get...
"USE master" & vbCrLf & _"
CREATE DATABASE netGuest" & vbCrLf & _"
GO" & vbCrLf & _"
So it almost works. Really the only thing not working is that the lines are ending with the " rather than starting with them.Here's my code:
Protected Sub btnConvert_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnConvert.Click
If txtVB.Text IsNot Nothing Then : txtVB.Text = "" : End If
Dim input() As String = txtSQL.Text.Split(vbCrLf)
[code]....
I need to parse a log file from some information provided via an external command line application. The problem is that the command line app doesn't produce its on logs. So, I was wondering how I might be able to obtain the information form the command line. The only thing I could think of was to redirect the output to a TextBox, write it to a text file and then parse the data. Does anyone know of any other to do this?
View 3 RepliesI have a listbox which I use to load file names into from a selected folder. once added to the listbox, I select the first number in the desired span then the last number of the span from this listbox. I need to append that full span (meaning first, last and all in between) of file names into a text box, all in one row. How would I do that?
I have Windows XP3 and VisualBasic2008.
how to display the calculation of time span in text box? i have this coding and dont know how to get the value between two time.. what type of format of time span that i can use.
Dim date1 As New System.DateTime(1996, 6, 3, 22, 15, 0)
Dim date2 As New System.DateTime(1996, 12, 6, 13, 2, 0)
Dim date3 As New System.DateTime(1996, 10, 12, 8, 42, 0)
[Code].....
I found this but to no avail:[URL]..I have generic fields and labels that I put inside already predefined table layouts. Some fields need to span rows/columns and I can't figure out how to do it within code (aka not in the designer).
View 1 RepliesHere is my
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=BHgardeners11.mdb;")
cn.Open()
Try
str = "UPDATE Products SET ProductCode = ?, ProductManufacturerCode = ?, ProductsTitle = ?,
[Code] .....
If there is only one item in the database, then this code works. If there is more than one record then the error is produced that it is trying to produce duplicate values. This is down to the Primary key in my database which is the only thing that cannot have duplicate values. However, when I remove the primary key it has the predictable problem that it goes crazy and does weird things.
1. How do I exclude a string that is matched?
I have something like this:
You answered question 1 correctly. You have been awarded
<a href="url"> 1 point</a> .
You answered question 2 correctly. You have been awarded
<a href="url"> 1 point</a> .
You answered question 3 correctly. You have been awarded
<a href="url"> 1 point</a> .
You answered all 3 questions correctly! You have been awarded a total of
<a href="url"> 3 points</a> .
So basically I want to filter out all those in bold, it should look like this when printed to a textbox:
You answered question 1 correctly. You have been awarded 1 point.
You answered question 2 correctly. You have been awarded 1 point .
You answered question 3 correctly. You have been awarded 1 point.
You answered all 3 questions correctly! You have been awarded a total of 3 points.
2. How do I get a value of HTML span element? (I'm not sure how to phrase this but I think you will get it if I show a example..)
It goes something like this...
<span class="quiz1">Question 1:</span>
<span id="q1">Question Here </span>
I want text in bold to be displayed in a label. Do I use getAttributeByID here? How do I use it in VB.net?
When I select text with a mouse in dense text like an XML file the selection automatically extends to what it thinks is a white space (or?). How do I turn off this "word selection" and just select the characters the cursor passes over?VS2010 Beta, VB.Net
View 7 RepliesIs there a way to make a DGV cell span 2 or more columns?
View 4 Replieswhats wrong with my code?if i change the item from the combo box..the textbox not change or has an error?
conn = New MySqlConnection()
conn.ConnectionString = "server=localhost; user id=root; password=12345; database=gigzta; allow zero datetime=no"
strsql = "SELECT accNo FROM accinfo WHERE (completename LIKE '%" & ComboBox2.Text & "%')"[code].....