﻿<?xml version='1.0' encoding='UTF-8'?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>A1VBCode Forums / Visual Basic .NET / .NET Programming </title><generator>InstantForum.NET v4.1.1</generator><description>A1VBCode Forums</description><link>http://www.a1vbcode.com/vbforums/</link><webMaster>forums@a1vbcode.com</webMaster><lastBuildDate>Thu, 29 Jul 2010 18:54:52 GMT</lastBuildDate><ttl>20</ttl><item><title>Read Txt file line by line to textbox</title><link>http://www.a1vbcode.com/vbforums/Topic29452-9-1.aspx</link><description>Hello,&lt;br&gt;&lt;br&gt;Im making a program that reads a txt file&lt;br&gt;what im trying to make is a button that displays the next line every time you click it&lt;br&gt; &lt;br&gt;&lt;br&gt;[code] Dim oRead As System.IO.StreamReader&lt;br&gt;        oRead = IO.File.OpenText("C:\Users\AMILOXI3650\Desktop\Keys.txt")&lt;br&gt;&lt;br&gt;        While oRead.Peek &lt;&gt; -1&lt;br&gt;            linein = oRead.ReadLine()&lt;br&gt;&lt;br&gt;        End While[/code]&lt;br&gt;&lt;br&gt;&lt;br&gt;for exmp. file contains&lt;br&gt;11111111111&lt;br&gt;22222222222&lt;br&gt;33333333333&lt;br&gt;44444444444&lt;br&gt;&lt;br&gt;User clicks first time on button &lt;br&gt;textbox displays &gt; 1111111111111&lt;br&gt;second time user clicks it will display&lt;br&gt;2222222222222&lt;br&gt;&lt;br&gt;Etc etc.&lt;br&gt;&lt;br&gt;Sounds really simple&lt;br&gt;but hard to make for me&lt;br&gt;any 1 has an idea how to make this?</description><pubDate>Tue, 20 Jul 2010 09:23:11 GMT</pubDate><dc:creator>1C3C0LD</dc:creator></item><item><title>Get HtmlElement From Stream</title><link>http://www.a1vbcode.com/vbforums/Topic29463-9-1.aspx</link><description>Hi,&lt;BR&gt;Can someone help me with this issue??&lt;BR&gt;I am trying to get html element from a stream&lt;/P&gt;&lt;P&gt;this is the stream:&lt;BR&gt;&lt;pre&gt;Dim request As WebRequest = HttpWebRequest.Create("&lt;A href="http://www.mysite.com/"&gt;http://www.mysite.com/&lt;/A&gt;")&lt;BR&gt;Dim response As WebResponse = request.GetResponse()&lt;BR&gt;Dim stream As Stream = response.GetResponseStream()&lt;/pre&gt;&lt;/P&gt;&lt;P&gt;How can I get the html elements from it?&lt;BR&gt;(I DO NOT WANT TO USE WEBBROWSER CONTROL)&lt;/P&gt;&lt;P&gt;Then I will do something like...&lt;BR&gt;&lt;pre&gt;For Each element As HtmlElement In XXXXXXXX&lt;BR&gt;       ListBox1.Items.Add(element.GetAttribute("href"))&lt;BR&gt;Next&lt;/pre&gt;&lt;/P&gt;&lt;P&gt;PLS HELP ME!&lt;BR&gt;THANKS!!!! &amp;amp&lt;img align="absmiddle" src="http://www.a1vbcode.com/vbforums/Skins/Classic/Images/EmotIcons/Wink.gif" border="0" title="Wink"&gt;</description><pubDate>Mon, 26 Jul 2010 07:04:55 GMT</pubDate><dc:creator>assafey</dc:creator></item><item><title>PictureBox Migration from VB6 to VB.NET 2010</title><link>http://www.a1vbcode.com/vbforums/Topic29456-9-1.aspx</link><description>Hi All,&lt;br&gt;&lt;br&gt;Please see the attached sample app in VB6.&lt;br&gt;Here is my case: The app prints/displays text on a PictureBox. Then you can draw a block around some text, and name it. Then when right-clicking on the block, you can view the block info.&lt;br&gt;&lt;br&gt;How can it be done in VB.NET 2010?&lt;br&gt;&lt;br&gt;Thanks so much in advance.&lt;br&gt;&lt;br&gt;Chu</description><pubDate>Wed, 21 Jul 2010 13:30:11 GMT</pubDate><dc:creator>zccary</dc:creator></item><item><title>Highlight text in a textbox</title><link>http://www.a1vbcode.com/vbforums/Topic29453-9-1.aspx</link><description>Hello.  I have a problem that is proving extremely difficult.  I hope someone has a clue.&lt;br&gt;&lt;br&gt;I am trying to highlight the text in a textbox when it gets the focus.  Here is the code:&lt;br&gt;&lt;br&gt;    Private Sub TextBox1_GotFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles TextBox1.Enter&lt;br&gt;        'TextBox1.SelectionStart = 0&lt;br&gt;        'TextBox1.SelectionLength = TextBox1.Text.Length&lt;br&gt;        TextBox1.SelectAll()&lt;br&gt;    End Sub&lt;br&gt;&lt;br&gt;I used the GotFocus and Enter events, neither work.  I used SelectionStart with SelectionLength; no luck.  Tried .SelectAll for zilch.  If I include a MsgBox in the event, it will work.  Adding DoEvents doesn't help.  I have the problem if I compile it also.  I am using a virtual machine, but running the exe on a real machine causes identical behavior.&lt;br&gt;&lt;br&gt;If this question is out of scope of this forum can someone please direct me somewhere that may help?</description><pubDate>Tue, 20 Jul 2010 09:52:43 GMT</pubDate><dc:creator>Mar</dc:creator></item><item><title>timer tick not working properly</title><link>http://www.a1vbcode.com/vbforums/Topic29444-9-1.aspx</link><description>i was trying to make a &lt;a href="http://devvicky.com/" target="_blank" class="SmlLinks"&gt;free microsoft word&lt;/a&gt; plugin in vb.net. It automatically fills a web form. The main problem with the plugin is that it uses web browser control and once it has filled a form it will need to navigate another form. The form can only be filled once it has completely been loaded.&lt;br&gt;&lt;br&gt;so my approach is&lt;br&gt;1. navigate to first site when form loads&lt;br&gt;&lt;br&gt;Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load&lt;br&gt;        WebBrowser1.Navigate("http://google.com")&lt;br&gt;    End Sub&lt;br&gt;&lt;br&gt;2. use an integer i and use if statements to check which form to fill :&lt;br&gt;&lt;br&gt;Private Sub WebBrowser1_DocumentCompleted(ByVal sender As System.Object, ByVal e As System.Windows.Forms.WebBrowserDocumentCompletedEventArgs) Handles WebBrowser1.DocumentCompleted&lt;br&gt;        If (i = 1) Then&lt;br&gt;            WebBrowser1.Document.GetElementById("username").SetAttribute("value", "elvin")&lt;br&gt;            WebBrowser1.Document.GetElementById("password").SetAttribute("value", "1111111")&lt;br&gt;            WebBrowser1.Document.GetElementById("wpt").InvokeMember("click")&lt;br&gt;            i = 2&lt;br&gt;        ElseIf (i = 2) Then&lt;br&gt;            WebBrowser1.Document.GetElementById("title").SetAttribute("value", "elvin")&lt;br&gt;            WebBrowser1.Document.GetElementById("content").SetAttribute("value", "111111")&lt;br&gt;            WebBrowser1.Document.GetElementById("tags").SetAttribute("value", "fgddferre")&lt;br&gt;            WebBrowser1.Document.GetElementById("publish").InvokeMember("click")&lt;br&gt;            i = 3&lt;br&gt;            Timer1.Start()&lt;br&gt;        ElseIf (i = 3) Then&lt;br&gt;            Timer1.Stop()&lt;br&gt;            WebBrowser1.Document.GetElementById("loginTextBlock_uname").SetAttribute("value", "elvin")&lt;br&gt;            WebBrowser1.Document.GetElementById("loginTextBlock").SetAttribute("value", "11111")&lt;br&gt;            WebBrowser1.Document.GetElementById("nowwhat").InvokeMember("click")&lt;br&gt;            i = 4&lt;br&gt;        ElseIf (i = 4) Then&lt;br&gt;            WebBrowser1.Document.GetElementById("title").SetAttribute("value", "elvin")&lt;br&gt;            WebBrowser1.Document.GetElementById("content").SetAttribute("value", "11111")&lt;br&gt;            WebBrowser1.Document.GetElementById("tags").SetAttribute("value", "fghfghfgh")&lt;br&gt;            WebBrowser1.Document.GetElementById("publish").InvokeMember("click")&lt;br&gt;            i = 5&lt;br&gt;            Timer1.Start()&lt;br&gt;        ElseIf (i = 5) Then&lt;br&gt;            WebBrowser1.Document.GetElementById("user").SetAttribute("value", "rfgjhfhj")&lt;br&gt;            WebBrowser1.Document.GetElementById("pass").SetAttribute("value", "566788989")&lt;br&gt;            WebBrowser1.Document.GetElementById("wpt").InvokeMember("click")&lt;br&gt;            i = 6&lt;br&gt;        End If&lt;br&gt;    End Sub&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;3. this is the main step. you see when main form loads, i=1 so browser goes to google.com (first form), when form is completely loaded, itchecks for value of i. Since i=1, it fills google. After filling and continuing i=2 and browser goes to my personal account page. This means browser again loads the &amp;#100;ocument. Now i=2, so it fills my personal detalis. Now the timer starts. Since i=3, browser navigates to second site and fills the details.&lt;br&gt;&lt;br&gt; Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick&lt;br&gt;        If (i = 3) Then&lt;br&gt;            WebBrowser1.Navigate("http://blogger.com")&lt;br&gt;        ElseIf (i = 5) Then&lt;br&gt;            WebBrowser1.Navigate("http://www.yahoo.com/")&lt;br&gt;        End If&lt;br&gt;    End Sub&lt;br&gt;&lt;br&gt;now the problem arises. The browser does not go to the third site. Once the timer has been stopped and started, the following code does not goto the elseif part (i.e. i=5) why is that so?</description><pubDate>Mon, 19 Jul 2010 10:10:31 GMT</pubDate><dc:creator>jamesvick</dc:creator></item><item><title>Add reports to deployed application</title><link>http://www.a1vbcode.com/vbforums/Topic29436-9-1.aspx</link><description>Hi All,&lt;br&gt;&lt;br&gt;I am wondering if anyone could help me i am trying to research about how a developer could add reports to a deployed applications by simply adding them to a folder set up in the application start up path. &lt;br&gt;&lt;br&gt;These reports would then add automaticly to the menustrip under reports.&lt;br&gt;&lt;br&gt;any help or point in the right direction would be greatly appriciated.&lt;br&gt;&lt;br&gt;Regards&lt;br&gt;&lt;br&gt;Aidan</description><pubDate>Sat, 17 Jul 2010 14:23:57 GMT</pubDate><dc:creator>Aidanb79</dc:creator></item><item><title>Issue Converting DataType</title><link>http://www.a1vbcode.com/vbforums/Topic29432-9-1.aspx</link><description>I am attempting to fill a DataTable with columns of numbers from a CSV to create lines on a third party chart control called Zedgraph. The problem is, the control keeps plotting one-to-one lines of point counts (in other words, if the column has 400 points, it plots a straight line from 0,0 to 400,400). I believe it is doing this because the data in my table is still being input as type String, which it shouldn't given the Cdbl(Var(x)) function I have written in. Why do you think my table values are still of type String?&lt;BR&gt;&lt;BR&gt;Imports ZedGraph&lt;BR&gt;&lt;BR&gt;Public Class Form1&lt;BR&gt;&lt;BR&gt;Private Sub CreateDataset(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click&lt;BR&gt;Dim DataSet As New DataSet&lt;BR&gt;If OpenFileDialog1.ShowDialog() = DialogResult.OK Then&lt;BR&gt;DataSet = getCsvToDataset(OpenFileDialog1.FileName)&lt;BR&gt;End If&lt;BR&gt;&lt;BR&gt;Call ChartFill(DataSet)&lt;BR&gt;&lt;BR&gt;End Sub&lt;BR&gt;&lt;BR&gt;Private Sub ChartFill(ByVal DS As DataSet)&lt;BR&gt;Dim ChartPane As GraphPane = ZG1.GraphPane&lt;BR&gt;Dim dspl As New DataSourcePointList&lt;BR&gt;With dspl&lt;BR&gt;.DataSource = DS.Tables(0)&lt;BR&gt;.XDataMember = "Time Slot"&lt;BR&gt;.YDataMember = "X1 1000 Air"&lt;BR&gt;End With&lt;BR&gt;&lt;BR&gt;Dim line1 As CurveItem&lt;BR&gt;line1 = ChartPane.AddCurve("X1 1000 Air", dspl, Color.Aquamarine)&lt;BR&gt;&lt;BR&gt;ChartPane.AxisChange()&lt;BR&gt;&lt;BR&gt;End Sub&lt;BR&gt;&lt;BR&gt;Private Shared Function getCsvToDataset(ByVal strPath As String) As DataSet&lt;BR&gt;Dim strLine As String&lt;BR&gt;Dim strArray As String()&lt;BR&gt;Dim charArray As Char() = New Char() {","c}&lt;BR&gt;Dim ds As New DataSet()&lt;BR&gt;Dim dt As DataTable = ds.Tables.Add("TheData")&lt;BR&gt;Dim aFile As New IO.FileStream(strPath, IO.FileMode.Open)&lt;BR&gt;Dim sr As New IO.StreamReader(aFile)&lt;BR&gt;&lt;BR&gt;strLine = sr.ReadLine()&lt;BR&gt;strArray = strLine.Split(charArray)&lt;BR&gt;&lt;BR&gt;For x As Integer = 0 To strArray.GetUpperBound(0)&lt;BR&gt;dt.Columns.Add(strArray(x).Trim())&lt;BR&gt;Next&lt;BR&gt;&lt;BR&gt;strLine = sr.ReadLine()&lt;BR&gt;While strLine IsNot Nothing&lt;BR&gt;strArray = strLine.Split(charArray)&lt;BR&gt;Dim dr As DataRow = dt.NewRow()&lt;BR&gt;For i As Integer = 0 To strArray.GetUpperBound(0)&lt;BR&gt;dr(i) = strArray(i).Trim()&lt;BR&gt;If dr(i) &amp;lt;&amp;gt; "" Then&lt;BR&gt;dr(i) = CDbl(Val(dr(i)))&lt;BR&gt;End If&lt;BR&gt;Next&lt;BR&gt;dt.Rows.Add(dr)&lt;BR&gt;strLine = sr.ReadLine()&lt;BR&gt;End While&lt;BR&gt;sr.Close()&lt;BR&gt;&lt;BR&gt;Dim ds2 As New DataSet&lt;BR&gt;Dim dt2 As DataTable = ds2.Tables.Add("MoreData")&lt;BR&gt;&lt;BR&gt;&lt;BR&gt;Return (ds)&lt;BR&gt;End Function&lt;BR&gt;&lt;BR&gt;End Class&lt;!-- google_ad_section_end --&gt;</description><pubDate>Fri, 16 Jul 2010 13:11:35 GMT</pubDate><dc:creator>pgm575</dc:creator></item><item><title>Datagrid Query</title><link>http://www.a1vbcode.com/vbforums/Topic29423-9-1.aspx</link><description>Hello friends. I am using vb.net. i ahve datagrid on my form. I want that when i enter datagrid and press insert key from keyboard, it should open a new form.&lt;/P&gt;&lt;P&gt;Plz help</description><pubDate>Wed, 14 Jul 2010 02:22:06 GMT</pubDate><dc:creator>smartshab</dc:creator></item><item><title>[HELP] Random Info Generation</title><link>http://www.a1vbcode.com/vbforums/Topic29421-9-1.aspx</link><description>hi&lt;br&gt;im new in vb.net&lt;br&gt;i need to make a form like this&lt;br&gt;&lt;img src="http://img138.imageshack.us/img138/8861/randome.png"&gt;&lt;br&gt;&lt;img src="http://img153.imageshack.us/img153/7952/random2o.png"&gt;&lt;br&gt;&lt;br&gt;For Firstname and Lastname: When you click to random Button it will auto pick random Firstname from Firstname.txt and random Lastname from Lastname.txt&lt;br&gt;&lt;br&gt;For Username: when you click to random Username Button it will auto generate Username&lt;br&gt;from firstname, lastname, string, number like this&lt;br&gt;&lt;br&gt;Username = firstname+number+lastname+string&lt;br&gt;&lt;br&gt;For Password:&lt;br&gt;&lt;br&gt;Password = random string + random number&lt;br&gt;&lt;br&gt;Sorry for my bad english. Please help</description><pubDate>Sun, 11 Jul 2010 06:05:00 GMT</pubDate><dc:creator>p3p3p3</dc:creator></item><item><title>Listbox Issue in 3 tier application</title><link>http://www.a1vbcode.com/vbforums/Topic29417-9-1.aspx</link><description>I created a program in 3 tier application but cannot populate the listbox. can any body give suggesstion please. I write the code below:&lt;br&gt;&lt;br&gt;&lt;br&gt;DATA ACCESS LAYER:&lt;br&gt;Public Function AllItems(ByVal cmdtext As String) As DataSet&lt;br&gt;            _dset = Nothing&lt;br&gt;            Try&lt;br&gt;                _olecon = New OleDb.OleDbConnection(_constr)&lt;br&gt;                _olecon.Open()&lt;br&gt;                _olecom = New OleDb.OleDbCommand()&lt;br&gt;                With _olecom&lt;br&gt;                    .Connection = _olecon&lt;br&gt;                    .CommandType = CommandType.Text&lt;br&gt;                    .CommandText = cmdtext&lt;br&gt;                End With&lt;br&gt;                _oledap = New OleDb.OleDbDataAdapter(_olecom)&lt;br&gt;                _dset = New DataSet()&lt;br&gt;                _oledap.Fill(_dset)&lt;br&gt;            Catch ex As Exception&lt;br&gt;                _dset = Nothing&lt;br&gt;                Throw ex&lt;br&gt;            Finally&lt;br&gt;                disposeAllObjects()&lt;br&gt;            End Try&lt;br&gt;            Return _dset&lt;br&gt;        End Function&lt;br&gt;&lt;br&gt;&lt;br&gt;BUSINESS ACCESS LAYER :&lt;br&gt;Public Sub ListItems()&lt;br&gt;            _dset = Nothing&lt;br&gt;            Try&lt;br&gt;                _obj = New DItems()&lt;br&gt;                _dset = _obj.AllItems(cmdtext)&lt;br&gt;                Dim objs As BItems = Nothing&lt;br&gt;                _lstitems = New List(Of BItems)&lt;br&gt;                For i As Integer = 0 To _dset.Tables(0).Rows.Count - 1&lt;br&gt;                    objs = New BItems()&lt;br&gt;                    objs.itemname = _dset.Tables(0).Rows(i)(0).ToString()&lt;br&gt;                    _lstitems.Add(objs)&lt;br&gt;                    objs = Nothing&lt;br&gt;                Next&lt;br&gt;            Catch ex As Exception&lt;br&gt;                Throw ex&lt;br&gt;            Finally&lt;br&gt;                _obj = Nothing&lt;br&gt;            End Try&lt;br&gt;        End Sub&lt;br&gt;&lt;br&gt;&lt;br&gt;IN THE FORM (TEXTBOX) EVENT:&lt;br&gt;Private Sub DisplayList()&lt;br&gt;        Me.Cursor = Cursors.WaitCursor&lt;br&gt;        Try&lt;br&gt;            _objs = New BItems()&lt;br&gt;            _objs.cmdtext = "SELECT Product FROM Products ORDER BY product "&lt;br&gt;            _objs.ListItems()&lt;br&gt;            ListBox1.Items.Clear()&lt;br&gt;            ListBox1.DataSource = _objs.Itemlist&lt;br&gt;            ListBox1.DisplayMember = _objs.product&lt;br&gt;            ListBox1.Focus()&lt;br&gt;        Catch ex As Exception&lt;br&gt;            MessageBox.Show(ex.Message, Me.Text, MessageBoxButtons.OK, MessageBoxIcon.Error)&lt;br&gt;            Me.Close()&lt;br&gt;        Finally&lt;br&gt;            _objs = Nothing&lt;br&gt;        End Try&lt;br&gt;        Me.Cursor = Cursors.Default&lt;br&gt;    End Sub&lt;br&gt;&lt;br&gt;LIST BOX DIDNT POPULATE THE RECORDS FROM THE TABLE&lt;br&gt;IF I USE FROM MSGBOX(_OBJS.ITEMLIST.COUNT) &lt;br&gt;THEN IT DISPLAY THE RECORD NUMBERS CORRECTLY&lt;br&gt;</description><pubDate>Wed, 07 Jul 2010 23:47:05 GMT</pubDate><dc:creator>firoz8871</dc:creator></item><item><title>open report in vb</title><link>http://www.a1vbcode.com/vbforums/Topic29416-9-1.aspx</link><description>&lt;DIV id=post_message_3838159&gt;Hi&lt;BR&gt;i have the following sub in my form:&lt;BR&gt;&lt;BR&gt;Private Sub report_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles report.Click&lt;BR&gt;Dim frm As New frmreport1&lt;BR&gt;gclass.sreport = "summary.rpt"&lt;BR&gt;frm.MdiParent = Me&lt;BR&gt;frm.BringToFront()&lt;BR&gt;frm.Show()&lt;BR&gt;End Sub&lt;BR&gt;&lt;BR&gt;ther problem is that "connect to database" dialog box pops up everytmie button is clicked. How so i automatically pass parameters to it?&lt;BR&gt;i am not a vb programmer but was asked to look at it &lt;BR&gt;You help is appreciated &lt;/DIV&gt;</description><pubDate>Wed, 07 Jul 2010 06:26:00 GMT</pubDate><dc:creator>kvebek</dc:creator></item><item><title>Need help with a part of a program</title><link>http://www.a1vbcode.com/vbforums/Topic29406-9-1.aspx</link><description>Please help&lt;br&gt;I really need some help in a project I've been working on. Its almost completed, but there is a place where i'm stuck on. I'm making a library project.there is a table with many records. Each record has a year, title, author, keywords and the loan numbers. loan numbers is the number of times the book has been borrowed. What i need to find is, the 10 most popular books and the 10 most popular searches for a particular year. the search is used by keywords. the keywords are predefined. eg: medicine, cardiology. the first section is completed, to find the 10 most popular books. all i need to know is how to find out the 10 most popular searches. the problem is that the user can use multiple words in one single search.&lt;br&gt;eg: if we need a book which describes postmortem, we can give the search as "medicine, postmortem". In this case there is two keyword in one particular search. What I need to find is 10 popular search keywords, not the whole search string as given in example. I was hoping to do in such a way that all the keywords are inserted in an array and a count is made whenever a search is done and increment the value if the same keyword is repeated again. But in this case i may need to cut the string if two or more keywords are used in a single search. I need help with that. Please someone wide the code for me for this section.&lt;br&gt;the coding is done in VB.NET &lt;br&gt;Any help is appreciated.&lt;br&gt;Thank you&lt;br&gt;Arunjith.</description><pubDate>Sun, 04 Jul 2010 16:08:01 GMT</pubDate><dc:creator>panthera</dc:creator></item><item><title>Spliting Words from text box</title><link>http://www.a1vbcode.com/vbforums/Topic29405-9-1.aspx</link><description>Dear Friends&lt;P&gt;I m new in vb 2005. i want that&lt;/P&gt;&lt;P&gt;1. i have to enter a sentence to a text field and when i press a button then my given sentence will split into words and replace these words from mysql database &lt;/P&gt;&lt;P&gt;example: i have entered "i am fine and ok"&lt;/P&gt;&lt;P&gt;then "i" will be converted to "eye"&lt;/P&gt;&lt;P&gt;"am" to "m"&lt;/P&gt;&lt;P&gt;"fine" to "f9"&lt;/P&gt;&lt;P&gt;"and" to "n"&lt;/P&gt;&lt;P&gt;"ok" to "okay" &lt;/P&gt;&lt;P&gt;and this show sentence again "eye m f9 n okay"&lt;/P&gt;&lt;P&gt;but these words and replacing words will be taken from mysql database&lt;/P&gt;&lt;P&gt;&lt;FONT size=4&gt;like in pic&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&lt;IMG src="http://www.a1vbcode.com/vbforums/Uploads/Images/9cf6be28-46b7-4fbb-81df-57f5.JPG"&gt;&lt;/P&gt;&lt;P&gt;&lt;FONT size=4&gt;Please help me sir .......&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;regards :::: it eagle </description><pubDate>Sat, 03 Jul 2010 09:47:39 GMT</pubDate><dc:creator>itsindh</dc:creator></item><item><title>How to combine a filter statement with an "AND"</title><link>http://www.a1vbcode.com/vbforums/Topic29402-9-1.aspx</link><description>Hello, I'm using the code below to search in XML files depending on the values entered in the text boxes, problem is I don't know how to combine the search statement with an "AND" when the users enter data in both textboxes. Can you please help me solve this problem? I am using VB.NET (VS 2008) &lt;br&gt;&lt;br&gt;Thanks, &lt;br&gt;&lt;br&gt;Victor &lt;br&gt;&lt;br&gt;Dim bs As New BindingSource() bs.DataSource = dt &lt;br&gt;C1TrueDBGrid1.DataSource = bs &lt;br&gt;Dim FilteredDT As DataTable&lt;br&gt;&lt;br&gt; If Not (TextBox1.Text = String.Empty) Then Dim DV As New DataView(dt, "Receiver like " &amp; "'" &amp; TextBox1.Text &amp; "'" &amp; "", Nothing, DataViewRowState.CurrentRows) &lt;br&gt;&lt;br&gt;FilteredDT = DV.ToTable &lt;br&gt;C1TrueDBGrid1.DataSource = FilteredDT &lt;br&gt;End If &lt;br&gt;&lt;br&gt;If Not (TextBox2.Text = String.Empty) Then &lt;br&gt;&lt;br&gt;Dim DV As New DataView(dt, "Donor like " &amp; "'" &amp; TextBox2.Text &amp; "'" &amp; "", Nothing, DataViewRowState.CurrentRows) FilteredDT = DV.ToTable &lt;br&gt;C1TrueDBGrid1.DataSource = FilteredDT &lt;br&gt;End If&lt;br&gt;&lt;br&gt;&lt;br&gt;---------------------------------- &lt;br&gt;</description><pubDate>Fri, 02 Jul 2010 23:07:08 GMT</pubDate><dc:creator>victor64</dc:creator></item><item><title>How to view a report which uses xml?</title><link>http://www.a1vbcode.com/vbforums/Topic29401-9-1.aspx</link><description>Hello,&lt;br&gt;&lt;br&gt;I'm using XML as a data source for my report, the report works ok by itself, however when attempting to run it using VB.Net, I receive  a prompt for login and password, problem is the xml files are not password protected, seems like it can't find the xml files, please help me fix this problem. I am using Crystal Repory XI Release 2 with VS 2008.&lt;br&gt;&lt;br&gt;Below is my code,  and example of the content of the xml files. I am selecing the receiver/Donor nations' ID from a grid and copying it to textbox2, the code was simplified to focus on the problem.&lt;br&gt;&lt;br&gt;1. Doner.xml&lt;br&gt;&lt;br&gt;&lt;?xml version="1.0" encoding="UTF-8" standalone="yes"?&gt;&lt;br&gt;&lt;Root xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"&gt;&lt;br&gt; &lt;Row&gt;&lt;br&gt;  &lt;Donor_ID&gt;1&lt;/Donor_ID&gt;&lt;br&gt;  &lt;Donor&gt;BEL&lt;/Donor&gt;&lt;br&gt; &lt;/Row&gt;&lt;br&gt; &lt;Row&gt;&lt;br&gt;  &lt;Donor_ID&gt;2&lt;/Donor_ID&gt;&lt;br&gt;  &lt;Donor&gt;CAN&lt;/Donor&gt;&lt;br&gt; &lt;/Row&gt;&lt;br&gt;&lt;/Root&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;2. Receiver.xml&lt;br&gt;&lt;br&gt;&lt;?xml version="1.0" encoding="UTF-8" standalone="yes"?&gt;&lt;br&gt;&lt;Root xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"&gt;&lt;br&gt; &lt;Row&gt;&lt;br&gt;  &lt;Receiver_ID&gt;1&lt;/Receiver_ID&gt;&lt;br&gt;  &lt;Receiver&gt;FRA&lt;/Receiver&gt;&lt;br&gt; &lt;/Row&gt;&lt;br&gt; &lt;Row&gt;&lt;br&gt;  &lt;Receiver_ID&gt;2&lt;/Receiver_ID&gt;&lt;br&gt;  &lt;Receiver&gt;GBR&lt;/Receiver&gt;&lt;br&gt; &lt;/Row&gt;&lt;br&gt; &lt;Row&gt;&lt;br&gt;  &lt;Receiver_ID&gt;3&lt;/Receiver_ID&gt;&lt;br&gt;  &lt;Receiver&gt;NLD&lt;/Receiver&gt;&lt;br&gt; &lt;/Row&gt;&lt;br&gt; &lt;Row&gt;&lt;br&gt;  &lt;Receiver_ID&gt;4&lt;/Receiver_ID&gt;&lt;br&gt;  &lt;Receiver&gt;DEU&lt;/Receiver&gt;&lt;br&gt; &lt;/Row&gt;&lt;br&gt; &lt;Row&gt;&lt;br&gt;  &lt;Receiver_ID&gt;5&lt;/Receiver_ID&gt;&lt;br&gt;  &lt;Receiver&gt;USA&lt;/Receiver&gt;&lt;br&gt; &lt;/Row&gt;&lt;br&gt;&lt;/Root&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;3. Link.xml&lt;br&gt;&lt;br&gt;&lt;?xml version="1.0" standalone="yes"?&gt;&lt;br&gt;&lt;DocumentElement&gt;&lt;br&gt;  &lt;Row&gt;&lt;br&gt;    &lt;Link_ID&gt;1&lt;/Link_ID&gt;&lt;br&gt;    &lt;Receiver_ID&gt;1&lt;/Receiver_ID&gt;&lt;br&gt;    &lt;Donor_ID&gt;1&lt;/Donor_ID&gt;&lt;br&gt;      &lt;/Row&gt;&lt;br&gt;  &lt;Row&gt;&lt;br&gt;    &lt;Link_ID&gt;2&lt;/Link_ID&gt;&lt;br&gt;    &lt;Receiver_ID&gt;2&lt;/Receiver_ID&gt;&lt;br&gt;    &lt;Donor_ID&gt;1&lt;/Donor_ID&gt;&lt;br&gt;  &lt;/Row&gt;&lt;br&gt;&lt;/DocumentElement&gt;&lt;br&gt;&lt;br&gt;Thanks,&lt;br&gt;&lt;br&gt;&lt;br&gt;4. Code&lt;br&gt;&lt;br&gt;Imports System.Xml.Linq&lt;br&gt;Imports System.Data.OleDb&lt;br&gt;Imports Microsoft.VisualBasic.ControlChars&lt;br&gt;Imports CrystalDecisions.Shared&lt;br&gt;Imports CrystalDecisions.CrystalReports.Engine&lt;br&gt;Public Class Form2&lt;br&gt;    &lt;br&gt; Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load&lt;br&gt;        Me.CenterToScreen()&lt;br&gt;    End Sub&lt;br&gt;    Private Sub Button6_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button6.Click&lt;br&gt;        Dim myviewer As New AOP29VIEWER&lt;br&gt;        Dim myreport As New AOP29_XML&lt;br&gt;        Dim SearchCriteria As String&lt;br&gt;        SearchCriteria = "{Link.Receiver_ID} in [" &amp; TextBox2.Text &amp; "] "&lt;br&gt;        myreport.RecordSelectionFormula = SearchCriteria&lt;br&gt;        MsgBox(myreport.RecordSelectionFormula)&lt;br&gt;        Me.Visible = False&lt;br&gt;        With myviewer&lt;br&gt;            .CrystalViewer1.ReportSource = myreport&lt;br&gt;            .ShowIcon = False&lt;br&gt;            .Show()&lt;br&gt;        End With&lt;br&gt;        Me.Cursor = Cursors.Default&lt;br&gt;        myreport = Nothing&lt;br&gt;    End Sub&lt;br&gt;&lt;br&gt;Thanks&lt;br&gt;&lt;br&gt;Victor&lt;br&gt;&lt;br&gt;</description><pubDate>Fri, 02 Jul 2010 23:03:49 GMT</pubDate><dc:creator>victor64</dc:creator></item><item><title>Push offset to one application</title><link>http://www.a1vbcode.com/vbforums/Topic29397-9-1.aspx</link><description>Hy all!&lt;br&gt;&lt;br&gt;Inspired by post that I send yesterday and I get fast answer, I would like to know if someone can know how push some offset to running application in VB.NET?&lt;br&gt;&lt;br&gt;For example this offset to one application:&lt;br&gt;&lt;br&gt;PUSH OFFSET 011E8FCC ;pointer to "popup"&lt;br&gt;PUSH OFFSET 0633A358&lt;br&gt;CALL 0051BA6F&lt;br&gt;&lt;br&gt;Thanks!&lt;br&gt;&lt;br&gt;Bizz</description><pubDate>Thu, 01 Jul 2010 09:46:27 GMT</pubDate><dc:creator>bizzpu</dc:creator></item><item><title>Reading file in VB.Net</title><link>http://www.a1vbcode.com/vbforums/Topic29388-9-1.aspx</link><description>Hy guys, I'm new here and I have one error...&lt;br&gt;&lt;br&gt;I wanna read from one *.ini file but not clasic read.&lt;br&gt;&lt;br&gt;Here is content of file confing.ini that I wanna read:&lt;br&gt;&lt;br&gt;[Config]&lt;br&gt;String0=some text1&lt;br&gt;String1=some text2&lt;br&gt;String2=some text3&lt;br&gt;....&lt;br&gt;&lt;br&gt;Read that I wanna get is value of String1 for example, in this case some text2.&lt;br&gt;&lt;br&gt;Is this possible and if it is how can I made that?&lt;br&gt;&lt;br&gt;Thanks,&lt;br&gt;Bizz</description><pubDate>Wed, 30 Jun 2010 13:14:27 GMT</pubDate><dc:creator>bizzpu</dc:creator></item><item><title>Adding Tags to image files</title><link>http://www.a1vbcode.com/vbforums/Topic28932-9-1.aspx</link><description>Hi! &lt;br&gt;&lt;br&gt;I am developing an &lt;b&gt;IMAGE TAGGER SYSTEM&lt;/b&gt; which can add &lt;b&gt;TAGS/KEYWORDS &lt;/b&gt;to  image files.&lt;br&gt;It's function is to save the  information in the file itself..&lt;br&gt;&lt;br&gt;For example, i have an image file named &lt;b&gt;WHITEHOUSE.jpg&lt;/b&gt; and using my system.. i added a tag/keyword &lt;b&gt;BUILDING&lt;/b&gt; and save the image file.. &lt;br&gt;&lt;br&gt;Once i search on my computer (the search engine in start menu).. all image files containing the TAG of &lt;b&gt;BUILDING&lt;/b&gt; will be displayed in search results.&lt;br&gt;&lt;br&gt;I know it is possible and i started in reading files properties/metadata and i'm done &lt;b&gt;READING&lt;/b&gt; those data..&lt;br&gt;&lt;br&gt;Now i am working with manipulating those data or metadatas.. I have this code and an error exist..&lt;br&gt;&lt;br&gt;&lt;b&gt;Is this code right?? &lt;/b&gt; will it save the keyword to image files?&lt;br&gt;&lt;br&gt;If not, then please Help me.. I am searching all articles and forums for this kind of project, and result is still ZERO 0.&lt;br&gt;&lt;br&gt;If Anyone of you guys know this stuff, please. I really need your Help..&lt;br&gt;&lt;br&gt;&lt;br&gt;Here are my codes for adding keywords: &lt;b&gt;Error exist in the Bold line of the code&lt;/b&gt;&lt;br&gt;&lt;br&gt;[code]Dim oSummProps As DSOFile.SummaryProperties&lt;br&gt;        Dim strTmp As String = String.Empty&lt;br&gt;        &lt;b&gt;Dim oDocument As New DSOFile.OleDocumentPropertiesClass()&lt;/b&gt;&lt;br&gt;        o&amp;#100;ocument.Open("c:\BSabellaRabano10151929.jpg", False, DSOFile.dsoFileOpenOptions.dsoOptionUseMBCStringsForNewSets)&lt;br&gt;&lt;br&gt;        o&amp;#100;ocument.SummaryProperties.Title = txtTitle.Text&lt;br&gt;        o&amp;#100;ocument.SummaryProperties.Comments = txtComments.Text()&lt;br&gt;        o&amp;#100;ocument.SummaryProperties.Keywords = txtKeywords.Text&lt;br&gt;        o&amp;#100;ocument.SummaryProperties.Subject = txtSubject.Text&lt;br&gt;        o&amp;#100;ocument.Save() [/code]&lt;br&gt;&lt;br&gt;by the way.. I already add the DSO File as reference..&lt;br&gt;&lt;br&gt;I am expecting replies from you Guys! Thank you very much in advance! &lt;img align="absmiddle" src="http://www.a1vbcode.com/vbforums/Skins/Classic/Images/EmotIcons/BigGrin.gif" border="0" title="BigGrin"&gt;&lt;br&gt;</description><pubDate>Fri, 26 Feb 2010 12:11:16 GMT</pubDate><dc:creator>emompong</dc:creator></item><item><title>parsing a csv file</title><link>http://www.a1vbcode.com/vbforums/Topic29385-9-1.aspx</link><description>hi &lt;br&gt;we are trying to use google to get exchange rate prices.&lt;br&gt;they use a csv file which we get the code to go out and get.&lt;br&gt;what im trying to do is pick the first line of the file and just use that. i have the following code but its not just picking the one line.&lt;br&gt;anyone any ideas&lt;br&gt;&lt;br&gt;[code]&lt;br&gt;Dim strURL As String&lt;br&gt;        'Creates the request URL for Yahoo&lt;br&gt;        strURL = "http://www.google.com/finance/historical?q="&lt;br&gt;        strURL &amp;= Me._symbol&lt;br&gt;       strURL &amp;= "&amp;output=csv"&lt;br&gt;&lt;br&gt;        Dim req As System.Net.WebRequest&lt;br&gt;        Dim resp As System.Net.WebResponse&lt;br&gt;&lt;br&gt;        req = System.Net.HttpWebRequest.Create(strURL)&lt;br&gt;        Try&lt;br&gt;            resp = req.GetResponse()&lt;br&gt;&lt;br&gt;            'Read the answer from the Web site and store it into a stream&lt;br&gt;            Me._reader = New IO.StreamReader(resp.GetResponseStream)&lt;br&gt;&lt;br&gt;           &lt;br&gt;&lt;br&gt;            Me._reader.ReadLine()&lt;br&gt;            ' reads the second line and splits it into a string array.   &lt;br&gt;            Dim firstLineOfData As String() = Me._reader.ReadLine().Split(New Char() {","c})&lt;br&gt;            MsgBox(firstLineOfData)&lt;br&gt;&lt;br&gt;&lt;br&gt;            ' first field in array   &lt;br&gt;            Dim theDate As Date = Date.Parse(firstLineOfData(0))&lt;br&gt;&lt;br&gt;            'Parse the header to create columns&lt;br&gt;            Me._history = New DataTable("YahooLastPrice")&lt;br&gt;&lt;br&gt;            'Parse the body of the downloaded data&lt;br&gt;            Me.header(Me._history)&lt;br&gt;&lt;br&gt;            Me.body(Me._history)&lt;br&gt;            resp.Close()&lt;br&gt;[/code]</description><pubDate>Wed, 30 Jun 2010 06:27:00 GMT</pubDate><dc:creator>rjhe22</dc:creator></item><item><title>New sub of function</title><link>http://www.a1vbcode.com/vbforums/Topic29383-9-1.aspx</link><description>Hi,&lt;P&gt;When I enter the sub or function line the sub/function is created empty (only the end sub/end function is generated. How can I extend this with my own default code block I use for every sub/function on creation of the sub/function ?&lt;/P&gt;&lt;P&gt;I use Visual Studio 2008.&lt;P&gt;Thx.</description><pubDate>Tue, 29 Jun 2010 16:56:18 GMT</pubDate><dc:creator>Hans</dc:creator></item><item><title>Problem with Saving image in SQL Server</title><link>http://www.a1vbcode.com/vbforums/Topic29382-9-1.aspx</link><description>I want to save image from Picture box to SQL Server DB. I am trying to do this using the following code but cannot able to do so. Please help.&lt;br&gt;&lt;br&gt;My Code Snippets are as following:  &lt;br&gt;&lt;br&gt;     Dim fs As FileStream = Nothing&lt;br&gt;        fs = New FileStream(picPhoto.ImageLocation, FileMode.Open)&lt;br&gt;        Dim fi As FileInfo = New FileInfo(picPhoto.ImageLocation)&lt;br&gt;        Dim temp As Long = fi.Length&lt;br&gt;        Dim lung As Integer = Convert.ToInt32(temp)&lt;br&gt;        Dim picture As Byte() = New Byte(lung - 1) {}&lt;br&gt;        fs.Read(picture, 0, lung)&lt;br&gt;        fs.Close()&lt;br&gt;&lt;br&gt;        Dim FileName_Renamed As Odbc.OdbcParameter = Nothing&lt;br&gt;        Dim pic As Odbc.OdbcParameter = Nothing&lt;br&gt;&lt;br&gt;        CN.OpenConnection()&lt;br&gt;        CMD = New Odbc.OdbcCommand("SavePhoto", CN.DBConnection)&lt;br&gt;        CMD.CommandType = CommandType.StoredProcedure&lt;br&gt;&lt;br&gt;        pic = New Odbc.OdbcParameter("@Picture", Odbc.OdbcType.Image)&lt;br&gt;        pic.Value = picture&lt;br&gt;        CMD.Parameters.Add(pic)&lt;br&gt;&lt;br&gt;        FileName_Renamed = New Odbc.OdbcParameter("@ID", Odbc.OdbcType.VarChar)&lt;br&gt;        FileName_Renamed.Value = txtID.Text&lt;br&gt;        CMD.Parameters.Add(FileName_Renamed)&lt;br&gt;&lt;br&gt;        CMD.ExecuteNonQuery()&lt;br&gt;        CN.closeconnection()&lt;br&gt;&lt;br&gt;&lt;br&gt;My Stored Procedure are as following:&lt;br&gt;&lt;br&gt;USE [EarthMovers]&lt;br&gt;GO&lt;br&gt;/****** Object:  StoredProcedure [dbo].[SavePhoto]    Script Date: 06/29/2010 13:22:35 ******/&lt;br&gt;SET ANSI_NULLS OFF&lt;br&gt;GO&lt;br&gt;SET QUOTED_IDENTIFIER OFF&lt;br&gt;GO&lt;br&gt;-- =============================================&lt;br&gt;-- Author:        Siddhartha Saha&lt;br&gt;-- Create date: 29/06/2010&lt;br&gt;-- Description:   &lt;br&gt;-- =============================================&lt;br&gt;ALTER PROCEDURE [dbo].[SavePhoto]&lt;br&gt;    -- Add the parameters for the stored procedure here&lt;br&gt;(&lt;br&gt;@Picture image,&lt;br&gt;@ID varchar(60)&lt;br&gt;)&lt;br&gt;AS&lt;br&gt;UPDATE ItemDimension SET itmdmnPhoto=@Picture WHERE itmdmnID=@ID</description><pubDate>Tue, 29 Jun 2010 04:08:50 GMT</pubDate><dc:creator>sidind123</dc:creator></item><item><title>integer error</title><link>http://www.a1vbcode.com/vbforums/Topic29378-9-1.aspx</link><description>hello fellows&lt;br&gt;&lt;br&gt;i'm using visual basic 2008 and i'm beginner developer and now i am doing working on a project expense budget tracking i have a problem that i am adding 6 textboxes in the form and a button which name is calculate and i am adding the following code under calculate button&lt;br&gt;&lt;br&gt;Dim txt1,txt2,txt3,txt4,txt5 as Integer&lt;br&gt;txt1=Textbox1.Text()&lt;br&gt;txt2=Textbox2.Text()&lt;br&gt;txt3=Textbox1.Text()&lt;br&gt;txt4=Textbox2.Text()&lt;br&gt;txt5=Textbox2.Text()&lt;br&gt;Textbox6.Text()=txt1+txt2+txt3+txt4+txt5&lt;br&gt;Now when i enter the numeric value in all of the above mentioned field and click the calculate button the result is true but when i missing to enter the numeric value in any textbox and click in calculate button there is showing an error please tell me why and send the right coding. thanks</description><pubDate>Sun, 27 Jun 2010 23:01:07 GMT</pubDate><dc:creator>haqayyum</dc:creator></item><item><title>stuck in loop HELP</title><link>http://www.a1vbcode.com/vbforums/Topic29321-9-1.aspx</link><description>&lt;P class=MsoNormal&gt;Hello I am have a problem getting out of a while loop, i am bringing in ascii code from ports on three diferent machines in to the serial port on a computer, two of the machines give form feed (12) at the end of the printout but one machine does not it only gives out line feed and carriage return (10)(13) is there another way of getting out of this loop, my be to do with the readbuffer being empty, please help&lt;/P&gt;&lt;P class=MsoNormal&gt;Andy.&lt;/P&gt;&lt;P class=MsoNormal&gt; &lt;/P&gt;&lt;P class=MsoNormal&gt;Input = serialport1.readchar&lt;?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/P&gt;&lt;P class=MsoNormal&gt;While input &amp;lt;&amp;gt;(12)&lt;/P&gt;&lt;P class=MsoNormal&gt;Dataline =””&lt;o:p&gt;&lt;/o:p&gt;&lt;/P&gt;&lt;P style="TEXT-INDENT: 36pt" class=MsoNormal&gt;While input&amp;lt;&amp;gt;(10)&lt;o:p&gt;&lt;/o:p&gt;&lt;/P&gt;&lt;P style="TEXT-INDENT: 36pt; MARGIN-LEFT: 36pt" class=MsoNormal&gt;If input&amp;lt;(32) then&lt;/P&gt;&lt;P style="TEXT-INDENT: 36pt; MARGIN-LEFT: 36pt" class=MsoNormal&gt;Else&lt;o:p&gt;&lt;/o:p&gt;&lt;/P&gt;&lt;P style="TEXT-INDENT: 36pt; MARGIN-LEFT: 36pt" class=MsoNormal&gt;Dataline = dataline &amp;amp; chr (input)&lt;/P&gt;&lt;P style="TEXT-INDENT: 36pt; MARGIN-LEFT: 36pt" class=MsoNormal&gt;End if&lt;o:p&gt;&lt;/o:p&gt;&lt;/P&gt;&lt;P class=MsoNormal&gt;&lt;o:p&gt;          &lt;/o:p&gt;Input = serialport1.readchar&lt;/P&gt;&lt;P style="MARGIN-LEFT: 36pt" class=MsoNormal&gt;End while&lt;/P&gt;&lt;P style="TEXT-INDENT: 36pt" class=MsoNormal&gt;Input = serialport1.readchar&lt;o:p&gt;&lt;/o:p&gt;&lt;/P&gt;&lt;P class=MsoNormal&gt;         w.writeline (dataline)&lt;o:p&gt;&lt;/o:p&gt;&lt;/P&gt;&lt;P class=MsoNormal&gt;&lt;o:p&gt; &lt;/o:p&gt;&lt;/P&gt;&lt;P class=MsoNormal&gt;End while&lt;o:p&gt;&lt;/o:p&gt;&lt;/P&gt;&lt;P class=MsoNormal&gt;Listbox1.items.add (“closing file”)&lt;o:p&gt;&lt;/o:p&gt;&lt;/P&gt;&lt;P class=MsoNormal&gt;w.flush()                                                                             ‘w is the stream writer&lt;o:p&gt;&lt;/o:p&gt;&lt;/P&gt;&lt;P class=MsoNormal&gt;w.close()&lt;o:p&gt;&lt;/o:p&gt;</description><pubDate>Wed, 26 May 2010 12:29:22 GMT</pubDate><dc:creator>afalbusa</dc:creator></item><item><title>open a text file from the vb form</title><link>http://www.a1vbcode.com/vbforums/Topic29306-9-1.aspx</link><description>hello I have a problem, I have some code that monitors the serial port on the computer, when data is recieved it creates a .txt file, I want to display the .txt file with the push of a button but i cant seem to get the .txt file to open any help would be gratefully recieved&lt;/P&gt;&lt;P&gt;Andy.</description><pubDate>Sun, 23 May 2010 11:44:23 GMT</pubDate><dc:creator>afalbusa</dc:creator></item><item><title>Accessing MS-Access Database in a Webserver</title><link>http://www.a1vbcode.com/vbforums/Topic29365-9-1.aspx</link><description>Friends,&lt;/P&gt;&lt;P&gt;I am writing a client / server program where the database will be stored in the web server (&lt;A href="http://www.yourdomain.com"&gt;www.yourdomain.com&lt;/A&gt;). The server is in my control and I have ftp access. Now I want to write a program to save the records in this server from the client side vb.net application&lt;/P&gt;&lt;P&gt;Kinldy give the solutions.&lt;/P&gt;&lt;P&gt;Regards&lt;/P&gt;&lt;P&gt;Ajay</description><pubDate>Wed, 23 Jun 2010 07:12:29 GMT</pubDate><dc:creator>ajayan1976</dc:creator></item><item><title>Http request</title><link>http://www.a1vbcode.com/vbforums/Topic29350-9-1.aspx</link><description>Dear,&lt;/P&gt;&lt;P&gt;When I tried to read the data of a http link using VB.net, an error occur. The error is:&lt;/P&gt;&lt;P&gt;The remote server returned an error: (406) Not Acceptable.&lt;/P&gt;&lt;P&gt;This error is only occur for some links.What is the reason?&lt;/P&gt;&lt;P&gt;Thank you&lt;/P&gt;&lt;P&gt;B.R.</description><pubDate>Thu, 17 Jun 2010 08:24:38 GMT</pubDate><dc:creator>nabilabdoun1</dc:creator></item><item><title>How To Add Each href To A ListBox If It Has A Specific Class</title><link>http://www.a1vbcode.com/vbforums/Topic29372-9-1.aspx</link><description>Hi All,&lt;br&gt;&lt;br&gt;I hope you can help me with this... Ive just started vb.net programming, and Im trying to make an application to collect twitter usernames and addresses - this is how all the links look:&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;pre&gt;&lt;a target="_blank" href="http://twitter.com/USERNAME" class="twtr-user"&gt;USERNAME&lt;/a&gt;&lt;/pre&gt;&lt;br&gt;&lt;br&gt;So in the tag of &lt;a&gt;, for each element, there is a class called "twtr-user"&lt;br&gt;&lt;br&gt;So basically, is there a way to go through the webpage and add each username and address to a listbox?&lt;br&gt;&lt;br&gt;This is what Ive come up with so far:&lt;br&gt;&lt;br&gt;&lt;br&gt;[code]For Each temp As HtmlElement In wb.Document.Links&lt;br&gt;            Dim str As String&lt;br&gt;            str = temp.GetAttribute("class")&lt;br&gt;            If str = "twtr-user" Then&lt;br&gt;                ListBox1.Items.Add(str)&lt;br&gt;            End If&lt;br&gt;            str = Nothing&lt;br&gt; Next[/code]&lt;br&gt;&lt;br&gt;&lt;br&gt;The problem is that (1) this doesnt work at all (2) Is there a way to add the href address and also the outer text?&lt;br&gt;&lt;br&gt;For the life of me I cant quite figure out how to do this - I keep coming back to GetAttribute("class") but this doesnt seem to work! &lt;img align="absmiddle" src="http://www.a1vbcode.com/vbforums/Skins/Classic/Images/EmotIcons/Crazy.gif" border="0" title="Crazy"&gt;&lt;br&gt;&lt;br&gt;Thanks for all your help</description><pubDate>Thu, 24 Jun 2010 15:43:25 GMT</pubDate><dc:creator>tradingjamie</dc:creator></item><item><title>Pulling time from online servers thru VB.NET</title><link>http://www.a1vbcode.com/vbforums/Topic29360-9-1.aspx</link><description>Hi,&lt;br&gt;&lt;br&gt;My requirement is to pull time from TIME SERVERS through .NET code to avoid time manipulation in my project which needs to record time for users when they start particular task and system clock can be changed to record wrong timings. I need to pull this time in IST.&lt;br&gt;&lt;br&gt;I was able to get some links but unable to write codeThe links are:&lt;br&gt;&lt;a href="http://www.nist.gov/physlab/div847/grp40/its.cfm" target="_blank" class="SmlLinks"&gt;NIST Internet time service&lt;/a&gt;&lt;br&gt;&lt;a href="ftp://time-a.nist.gov/pub/daytime/" target=_"blank" class="SmlLinks"&gt;ftp://time-a.nist.gov/pub/daytime/&lt;/a&gt;&lt;br&gt;&lt;a href="http://tf.nist.gov/tf-cgi/servers.cgi" target="_blank" class="SmlLinks"&gt;NIST Internet Time Service clock&lt;/a&gt;&lt;br&gt;&lt;a href="http://www.worldtimeserver.com/current_time_in_IN.aspx" target="_blank" class="SmlLinks"&gt;Current local time in India&lt;/a&gt;&lt;br&gt;&lt;br&gt;One of the above link has source code of windows utility in C# which I am not familiar with. We can just get the code from the utility that just queries the server and then use the time. We have to make the application to randomly choose a server from a list of servers if you have query lots of times as they deny requests if queried multiple times in a period.&lt;br&gt;&lt;br&gt;Please help me with sample code.&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;b&gt;CROSS POSTING: I have also posted this same question in this VBDOTNETFORUMS in "Windows Forms Discussion Thread" too.&lt;/b&gt;</description><pubDate>Tue, 22 Jun 2010 01:40:19 GMT</pubDate><dc:creator>vamshivemula</dc:creator></item><item><title>converting digit</title><link>http://www.a1vbcode.com/vbforums/Topic29346-9-1.aspx</link><description>hi all &lt;br&gt;Anyone know what to use to convert an 2 digit integer e.g. 93, to a 4-digit integer e.g. 0093?&lt;br&gt;&lt;br&gt;thanks&lt;img align="absmiddle" src="http://www.a1vbcode.com/vbforums/Skins/Classic/Images/EmotIcons/Ermm.gif" border="0" title="Ermm"&gt;</description><pubDate>Wed, 16 Jun 2010 03:20:35 GMT</pubDate><dc:creator>shahar786</dc:creator></item><item><title>Create Log in in Vb2008 by retieve username and password from sql server 2005</title><link>http://www.a1vbcode.com/vbforums/Topic29349-9-1.aspx</link><description>HI all,&lt;br&gt;&lt;br&gt; I want to create form log in in vb2008 and retrieve user name and password from sql server.&lt;br&gt; Could u pls help me to solve this.?&lt;br&gt;&lt;br&gt; Thanks</description><pubDate>Thu, 17 Jun 2010 02:15:24 GMT</pubDate><dc:creator>kda</dc:creator></item><item><title>How to calculate date time ?</title><link>http://www.a1vbcode.com/vbforums/Topic29333-9-1.aspx</link><description>Hi.I need help to write a code that can calculate the difference between the date time a article has been published and date time of now.like this example : &lt;br&gt;&lt;br&gt;this article has been published 4 minutes ago...&lt;br&gt;&lt;br&gt;this article has been published about 2 days ago...&lt;br&gt;&lt;br&gt;The code has to be in vb.net&lt;br&gt;Thanks in Advance.</description><pubDate>Thu, 10 Jun 2010 10:47:37 GMT</pubDate><dc:creator>minasaeedi</dc:creator></item><item><title>Inaccuracy in check for child nodes.</title><link>http://www.a1vbcode.com/vbforums/Topic29331-9-1.aspx</link><description>Hi , i have this function for the purpose of parsing an XML file&lt;br&gt;&lt;br&gt;&lt;br&gt;Public Function XMLParser(ByVal xPath As String, Optional ByVal Nodename As String = Nothing) As ArrayList&lt;br&gt;        Dim arylst As ArrayList = New ArrayList&lt;br&gt;        Dim xmldoc As XmlDocument&lt;br&gt;        Dim xmlnlist As XmlNodeList&lt;br&gt;        Dim xmln As XmlNode&lt;br&gt;        Dim cnt As Integer&lt;img align="absmiddle" src="http://www.a1vbcode.com/vbforums/Skins/Classic/Images/EmotIcons/Smile.gif" border="0" title="Smile"&gt;&lt;br&gt;&lt;img align="absmiddle" src="http://www.a1vbcode.com/vbforums/Skins/Classic/Images/EmotIcons/Smile.gif" border="0" title="Smile"&gt;&lt;br&gt;        Try&lt;br&gt;            xmldoc = New XmlDocument&lt;br&gt;            xmldoc.Load(xmlfilePath)&lt;br&gt;            xmln = xmldoc.SelectSingleNode(xPath)&lt;br&gt;            &lt;br&gt;&lt;br&gt;            If xmln.FirstChild.Name &lt;&gt; "#text" Then&lt;br&gt;                xmlnlist = xmldoc.SelectNodes(xPath)&lt;br&gt;&lt;br&gt;                For Each xmln In xmlnlist&lt;br&gt;&lt;br&gt;                    For cnt = 0 To (xmln.ChildNodes.Count - 1) Step 1&lt;br&gt;&lt;br&gt;                        If (Nodename = Nothing) Then&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;                            arylst.Add(xmln.ChildNodes.Item(cnt).Name)&lt;br&gt;                            arylst.Add(xmln.ChildNodes.Item(cnt).InnerText)&lt;br&gt;&lt;br&gt;&lt;br&gt;                        Else&lt;br&gt;&lt;br&gt;                            If xmln.ChildNodes.Item(cnt).Name = Nodename Then&lt;br&gt;                                arylst.Add(xmln.ChildNodes.Item(cnt).InnerText)&lt;br&gt;                            End If&lt;br&gt;&lt;br&gt;                        End If&lt;br&gt;&lt;br&gt;                    Next&lt;br&gt;&lt;br&gt;                Next&lt;br&gt;&lt;br&gt;            Else&lt;br&gt;&lt;br&gt;                If (Nodename = Nothing) Then&lt;br&gt;                    arylst.Add(xmln.Name)&lt;br&gt;                    arylst.Add(xmln.InnerText)&lt;br&gt;&lt;br&gt;                Else&lt;br&gt;                    If xmln.Name = Nodename Then&lt;br&gt;                        arylst.Add(xmln.InnerText)&lt;br&gt;                    Else&lt;br&gt;                        Throw New Exception(" Node with name '" &amp; Nodename &amp; "' Not found ")&lt;br&gt;                    End If&lt;br&gt;&lt;br&gt;                End If&lt;br&gt;&lt;br&gt;            End If&lt;br&gt;&lt;br&gt;            Return arylst&lt;br&gt;        Catch ex As Exception&lt;br&gt;&lt;br&gt;            Throw New Exception("Exception Thrown from Function :  XMLParser() " &amp; ControlChars.NewLine &amp; ex.Message)&lt;br&gt;        End Try&lt;br&gt;    End Function&lt;br&gt;&lt;br&gt;the behaviour of the function is as follows:&lt;br&gt;&lt;br&gt;1)   If no nodename (2nd parameter)specified the arraylist &lt;br&gt;     will bear both name of each child node followed by the value of the child node&lt;br&gt;2)   If however the call is made with the child node name provided then the arraylist                         &lt;br&gt;     will bear only the values of all childnodes with the specified name&lt;br&gt;3)   If there are no child nodes present then the name and value of the current node will &lt;br&gt;     returned if the 2nd 'Node Name' parameter is not provided , if the node name is provided&lt;br&gt;     then only the value of the node is returned. &lt;br&gt;&lt;br&gt;However there does not seem to be a reliable manner to check for the Presence/absence of child nodes hence the check &lt;br&gt;' &lt;b&gt;If xmln.FirstChild.Name &lt;&gt; "#text" Then &lt;/b&gt;' .&lt;br&gt;Other checks such as &lt;br&gt;xmln.HasChildNodes&lt;br&gt;xmln.ChildNodes.Count&lt;br&gt;fail when the final nodes being checked, has a value.&lt;br&gt;&lt;br&gt;i.e. assume the following xpath     /configuration/appSettings/irp/file/location/source&lt;br&gt;then if the source node has a value such as is the case here  &lt;br&gt;        &lt;source&gt;hibiscus&lt;/source&gt;&lt;br&gt;then both &lt;br&gt;xmln.HasChildNodes&lt;br&gt;xmln.ChildNodes.Count&lt;br&gt;&lt;br&gt;returns true which if feel is incorrect.&lt;br&gt;it should return true only in such a scenario.&lt;br&gt;         &lt;source&gt;&lt;br&gt;           &lt;location&gt;trunk&lt;/location&gt;&lt;br&gt;         &lt;/source&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;the only way i have got around this problem is this &lt;br&gt;' &lt;b&gt;If xmln.FirstChild.Name &lt;&gt; "#text" Then &lt;/b&gt;' , which i find a bit naif so i am looking for suggestion which will get the function to work properly and be able to detect the absence of the child nodes even if the node has values.&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;</description><pubDate>Thu, 10 Jun 2010 07:48:37 GMT</pubDate><dc:creator>xmlstarter</dc:creator></item><item><title>Need help about face recognition absence system...</title><link>http://www.a1vbcode.com/vbforums/Topic29325-9-1.aspx</link><description>Anyone can help me to make a face recognition absence system?</description><pubDate>Thu, 27 May 2010 03:50:53 GMT</pubDate><dc:creator>Alveen Scofield</dc:creator></item><item><title>How to convert Vb6 to VB.NET?</title><link>http://www.a1vbcode.com/vbforums/Topic29315-9-1.aspx</link><description>Does any body know how to convert vb6 project files to VB.NET 2008?&lt;br&gt;&lt;br&gt;I want to convert this program - &lt;br&gt;http://www.a1vbcode.com/app-3519.asp&lt;br&gt;&lt;br&gt;The default converter wizard does converts with errors.&lt;br&gt;&lt;br&gt;Can some body help me please?</description><pubDate>Tue, 25 May 2010 22:21:23 GMT</pubDate><dc:creator>coleman84joyner</dc:creator></item><item><title>VBNet2008 How to retrieve Data from Excel Spreadsheet</title><link>http://www.a1vbcode.com/vbforums/Topic29314-9-1.aspx</link><description>Hi Friends,  &lt;img align="absmiddle" src="http://www.a1vbcode.com/vbforums/Skins/Classic/Images/EmotIcons/Tongue.gif" border="0" title="Tongue"&gt;&lt;/P&gt;&lt;P&gt;&lt;FONT color=#1111ff&gt;I need your help. Please help me.&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;I have not written logic to retrieve data from Excel Spreadsheet and update SQL SERVER Table before using VBNet2008 in Window application.  The Excel Spreadsheet is attached here.  &lt;/P&gt;&lt;P&gt;Please share with me sample coding so that I can learn how to do it. &lt;FONT color=#ff1111&gt;I tried checking the Google and I couldn't find any.&lt;/FONT&gt;</description><pubDate>Tue, 25 May 2010 20:28:45 GMT</pubDate><dc:creator>Lennie</dc:creator></item><item><title>Vb.Net Ftp Control &amp; Class Library</title><link>http://www.a1vbcode.com/vbforums/Topic29271-9-1.aspx</link><description>hi,&lt;BR&gt;&lt;BR&gt;I just built a new ftp control and class library in &lt;ACRONYM title="Visual Basic"&gt;vb&lt;/ACRONYM&gt;.net 2008. It might be helpful for applications with ftp functionality. &lt;BR&gt;&lt;BR&gt;Link&lt;B&gt;:&lt;A href="http://www.zianole.info/" target=_blank&gt;&lt;FONT color=#22229c&gt;http://www.zianole.info&lt;/FONT&gt;&lt;/A&gt;&lt;/B&gt;&lt;BR&gt;Looking for your comments.&lt;BR&gt;&lt;BR&gt;Thanks.</description><pubDate>Sun, 09 May 2010 10:13:28 GMT</pubDate><dc:creator>mobiwiki</dc:creator></item><item><title>How to change the format of the entered value in a textbox?</title><link>http://www.a1vbcode.com/vbforums/Topic29229-9-1.aspx</link><description>Hi,&lt;BR&gt;&lt;BR&gt;I have three text boxes on my form as following:&lt;BR&gt;&lt;BR&gt;&lt;STRONG&gt;1) txtTelephone&lt;BR&gt;2) txtDate&lt;BR&gt;3) txtPrice&lt;/STRONG&gt;&lt;BR&gt;&lt;BR&gt;What actually I need to know is, how the text box automatically change the values to the below format:&lt;BR&gt;&lt;BR&gt;&lt;SPAN style="COLOR: red"&gt;txtTelephone : &lt;/SPAN&gt;If I enter &lt;SPAN style="FONT-WEIGHT: bold"&gt;0403507624&lt;/SPAN&gt; it should change automatically the entered values to this format &lt;SPAN style="FONT-WEIGHT: bold"&gt;040 350 7624 &lt;/SPAN&gt;&lt;BR&gt;&lt;BR&gt;&lt;SPAN style="COLOR: red"&gt;txtDate : &lt;/SPAN&gt;If I enter &lt;SPAN style="FONT-WEIGHT: bold"&gt;28042010&lt;/SPAN&gt; then it should be changed to &lt;SPAN style="FONT-WEIGHT: bold"&gt;28-APR-2010&lt;/SPAN&gt;&lt;BR&gt;&lt;BR&gt;&lt;SPAN style="COLOR: red"&gt;txtPrice : &lt;/SPAN&gt;If I enter &lt;SPAN style="FONT-WEIGHT: bold"&gt;513458&lt;/SPAN&gt; then it should be changed to &lt;SPAN style="FONT-WEIGHT: bold"&gt;513,458.00&lt;/SPAN&gt; automatically.&lt;BR&gt;&lt;BR&gt;So, what code should I write to achieve this problem?&lt;BR&gt;&lt;BR&gt;Thanks.</description><pubDate>Thu, 29 Apr 2010 01:35:38 GMT</pubDate><dc:creator>Learner7</dc:creator></item><item><title>Make a button change the background image of a menustrip?</title><link>http://www.a1vbcode.com/vbforums/Topic29245-9-1.aspx</link><description>i am making a webbrowser with a Theme Selector, i have the images all ready, they will be placed onto 3 menustrips (Tab Control is docked, so is the menustrips). i need help making it so that if i click the button, it changes the backgroundimage of the Menustrips to the image that is in the workspace (I Copy pasted it into workspace) i can see it there.</description><pubDate>Wed, 05 May 2010 15:21:27 GMT</pubDate><dc:creator>adilaa</dc:creator></item><item><title>Program users and authorities with phone book</title><link>http://www.a1vbcode.com/vbforums/Topic29296-9-1.aspx</link><description>Li with the first participants in your forum to offer you a great day program supported by the phone book using the passwords and accounts and you can add or delete any user of the program&lt;br&gt;&lt;br&gt;And an excuse for thinness in the English language&lt;br&gt;&lt;br&gt;With my greetings and best wishes&lt;br&gt;&lt;br&gt;&lt;br&gt;Avocato</description><pubDate>Mon, 17 May 2010 11:49:00 GMT</pubDate><dc:creator>avocato</dc:creator></item><item><title>The Microsoft Jet database engine could not find the object</title><link>http://www.a1vbcode.com/vbforums/Topic29281-9-1.aspx</link><description>[quote]Hi all&lt;br&gt;I'm trying to import data from an exel sheet to a data grid but I keep on getting the following error "The Microsoft Jet database engine could not find the object"&lt;br&gt;&lt;br&gt;Here is my code  &lt;br&gt;Thanks&lt;br&gt;&lt;br&gt;[/quote]&lt;br&gt;[quote]Imports System&lt;br&gt;Imports System.Data&lt;br&gt;Imports System.Data.OleDb&lt;br&gt;Public Class ExellFrm&lt;br&gt;&lt;br&gt;    Private Sub ExellFrm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load&lt;br&gt;        Dim MyConnection As System.Data.OleDb.OleDbConnection&lt;br&gt;        Dim myPath As String = "C:\Users\John\Desktop\book1.xls"&lt;br&gt;        Try&lt;br&gt;&lt;br&gt;            ' importing Data from Excel&lt;br&gt;            Dim DtSet As System.Data.DataSet&lt;br&gt;            Dim MyCommand As System.Data.OleDb.OleDbDataAdapter&lt;br&gt;            MyConnection = New System.Data.OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0; data source='" &amp; myPath &amp; " '; " &amp; "Extended Properties=Excel 8.0;")&lt;br&gt;            MyConnection.Open()&lt;br&gt;            ' Select the data from Sheet of the workbook.&lt;br&gt;            MyCommand = New System.Data.OleDb.OleDbDataAdapter("select * from [test$]", MyConnection)&lt;br&gt;            DtSet = New System.Data.DataSet&lt;br&gt;            MyCommand.Fill(DtSet)&lt;br&gt;            exellgrid.DataSource = DtSet&lt;br&gt;            MyConnection.Close()&lt;br&gt;        Catch ex As Exception&lt;br&gt;            MessageBox.Show("ERROR  " &amp; ex.Message)&lt;br&gt;        End Try&lt;br&gt;    End Sub&lt;br&gt;End Class[/quote]&lt;br&gt;&lt;br&gt;</description><pubDate>Thu, 13 May 2010 20:16:53 GMT</pubDate><dc:creator>viper5646</dc:creator></item></channel></rss>