Posts by Pgmer

John,
Sorry i did not get a chance to come back to this forum. Thanks for your effort. I have implemnted the sollution which simillar to ur approach. I had some specific things to capture.

You need to run the installer files to Install VS2008 and SQL 2005. You can install anyone first. They are independent.

Till now how far you wrote code for this? You want someone to write code for you?

May be your declaring again in ServerConnection() as Dim conn = New SqlConnection(con)
in top also there is a variable with scope public and here its local to that module.

Which database are you using? you need to write a wizrd kind of application which Attach the DB files DB.

What is the problem with above code?

you can bind dataset to gridview and you can play anything in dataset. Which eventually have datatable inside.

Sending internally? Chek if your Firewall letting to use the smtp.

at this below line your not passing the password
string connectionString = "server=localhost;User Id=root;database=customerInfo;Password=";

I did not know its web application. I think you can do this validation using javascript at client side rather than doing it in server side. I am not good to write code for you in asp.net. Just search in net how to validate checkboxes using javascript. U call that function in submitt button click in aspx code.

Can you put a break point and check what is happening when da.fill(dt)? Whats coming into dt? is it blank?

Your check box and radio buttons are in group box or in panel?

You need to use threadin concept here.. The creating panle should be in a thread and call the thread in form load. When give thread a sleep time so that the form is active and can be used by users. Please read about using thread or background worker on internet for more clear understanding.

In windows form also user has to enter the name, last name etc right? Then how this approch help you in making it fast?

I have question here.. What is the need to open a webpage through windows app?

I dont think you can call httpwebrequest on textbox. try using webbrowser control in your application. And pass all the variables through querystring to the calling webpage or find any other good methods to pass.

Are you calling the web page from your application?

Its better get the resluts from DB once into one datatable and bind it.

please put break point in Loadpeople method and see are you getting the connectionto DB? and are you getting any records in TABLE

John,
Thanks a lot for your effort. I will look into code today.

you need to write code which connects to DB. If you have created the procedure in Database send the parameted and get the records from DB and assign to variable. You need code or hint?

Private Sub LoadCommaDelimetedTextFileIntoListBox(ByVal filePath As String)

        ' Declare a variable named theTextFieldParser of type TextFieldParser.
        Dim theTextFieldParser As FileIO.TextFieldParser

        ' Call the My feature's OpenTextFieldParser method passing in a file path.
        ' Assign the resulting TxtFileParser object to theTextFieldParser variable.
        theTextFieldParser = My.Computer.FileSystem.OpenTextFieldParser(filePath)

        ' Set TextFieldParser object's TextFieldType property to Delimited.
        theTextFieldParser.TextFieldType = Microsoft.VisualBasic.FileIO.FieldType.Delimited

        ' Configure delimiters to handle a comma delimited text file:
        ' Set TextFieldParser object's Delimiter's property to a string array
        ' containing one element with the value ",".
        theTextFieldParser.Delimiters = New String() {"|"}

        ' Declare a variable named currentRow of type string array.
        Dim currentRow() As String

        ' While the end of file has not been reached....
        While Not theTextFieldParser.EndOfData
            Try
                ' Read the fields on the current line
                ' and assign them to the currentRow array variable.
                currentRow = theTextFieldParser.ReadFields()

                ' Declare a variable named currentField of type String.
                Dim currentField As String

                ' Use the currentField variable to loop
                ' through fields in the currentRow.
                For Each currentField In currentRow
                    ' Add the the currentField (a string)
                    ' to the demoLstBox items.
                    Me.ListBox2.Items.Add(currentField)
                Next
            Catch malFormLineEx As Microsoft.VisualBasic.FileIO.MalformedLineException
                MessageBox.Show("Line " & malFormLineEx.Message & "is not valid and will be skipped.", "Malformed Line Exception")
            Catch ex As Exception
                MessageBox.Show(ex.Message & " exception has occurred.", "Exception")
            Finally
                ' Do any clean up if needed
            End Try
        End While


    End Sub

I am adding the red lines to listbox. In currecnt row currentRow = theTextFieldParser.ReadFields() you will get the data in array so you need …

Get all the values you want to insert into aray or hastable or datatable.Write a procedure or inline statements to insert records into db. loop through the list you get and insert the records. And it is not good to discuss a thread in solved thread. :)

Good but still you can post the code.. it may help any who needs this.. And mark the thread as solved

please show us the code what you have sofar for reading the text file

you need to instantiate the class clsKYC like
Dim objclsKYC as new clsKYC
And then call the function objclsKYC.InfoCheking

You cant show the complte text file data in list box as columns if data is huge. I loaded simple text files whith above code and worked for me. I dont know what kind of data you have in your text files.

You should select the multicolumn to true.

this should help you

 Try
            Dim strlist As New List(Of String)
            Dim file As String
            Dim openFiles As New OpenFileDialog
            openFiles.Multiselect = True
            If openFiles.ShowDialog = DialogResult.OK Then
                For Each file In openFiles.FileNames
                    Dim sr As New IO.StreamReader(openFiles.FileName)
                    While (sr.Peek() > -1)
                        strlist.Add(sr.ReadToEnd)
                    End While

                Next
            End If
            For i As Int16 = 0 To 1
                ListBox1.Items.Add(strlist.Item(i) & vbTab & strlist.Item(i + 1))
            Next
        Catch ex As Exception
        End Try

Note: I am Assuming you have only two files to read

please show your code what you have so far.

Then please mark this thread as solved.

this should give you hint.Click Here

When you have only one field why you want to use like? just say = in Where condition like
Update VILLAGEMST set VCODE = " & Code & " where TADDRESS = 'VillageName'

I hope VILNAME is variable name. And i am asking you what you get into this variable when below line executes VILNAME = rs.Fields(1).Value
You are assiging rs.Fields(1).Value to VILNAME correct? So you should get something in it correct?

VILNAME at line 5 does get any value when you execute in debug mode? and MainCon.Execute(usql)?

John Thanks for the reply. I know how to write and consume web service in .Net application. My query is i need to capture usage stats record it in DB using webservice. Any help or directions in this would be great.

Then post your complete code. I never worked with access DB. I work with MS SQL i thought syntax will b same..

Try this.
Select TNAME,TADDRESS from VILLAGEMST where TADDRESS like &'(' & '[' VILNAME & ']'&')'
I could see some problem in your Qery in concatinating the brackets

please post your Query here

you want to Select the multiple files once and load into list box? using open FileDialog?

Hi Guys,
I need to track the application usage statistics using webservice. Basically i need to write a service which can be used in any application to record the usage of application which is calling this service. or Could be a DLL.
I need idea's for this.

Thanks,
pgmer..

Good code to understand the concept of delegates for those who never used in real time.

You need to get data from DB into dataset and assign that dataset to combobox as datasource and set the Displaymember and Value member of the combobox. Then in selected index changed event of the combobox get the value upon which you want to get the data from DB and write appropriate Query..

I wrote a function which splits the charecters which is sent as parameter to it. And used MIN and MAX function which gave me sollution..

Hi,
I have my data which looks like '0/1,0/2,0/3,0/4' or '0/1,0/2,0/6,0/3,0/4' I need to select min and max of the
numbers for example for first example my output should be 0/1-0/4 and for second it should be 0/1-0/6.. I am able to get like 0-1 or 0-6.. Any help would be great.. That data will be Varchar.

you mean you want the complete code? or just an idea?

put break point on line 28 and see data is there in mydata4? becuase ur assigning it to Mytable which is new table. so i suspect Mydata4 is blank.

please post your Query . I mean your final sqlstr.. And one thing i noticed is line number 13 is having 2 times SET key word

you need to write a program to read excel file using .net and use the same application to write back into another excel.

I am not sure what you are asking about. your exe is not able to read the file which you pass through vb code?