Posts by Pgmer

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.

What is the problem with above code?

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

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

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

Then please mark this thread as solved.

this should give you hint.Click Here

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

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.

Check before cmd.executeNonQuery on

ds.Tables(0).Rows(iRows).Item(5) & "," &                                     
ds.Tables(0).Rows(iRows).Item(6) & "

What ur getting at these items...

U need to add the item to ur dt before setting the data and value member. or Edit ur Query to select All region as first item

Try somethong like this

   Dim cmd As New SqlCommand
        Dim ds As New DataSet
        Dim da As New SqlDataAdapter
        Dim conn As New SqlConnection("Ur connection")


        With cmd
            .Connection = conn
            .CommandTimeout = 3000
            .CommandType = CommandType.text
            .CommandText = "SQL code"

        End With

        da = New SqlDataAdapter
        da.SelectCommand = cmd

        ds = New DataSet
        da.Fill(ds)

Before starting the loop Can you just check DS is having tables and Rows?
And I am not sure about this line "For iX = 0 To dtRows - 1" your looping through dtrows and accessing values from dataset. Will dtRows have same number of rows as table of DS?

Try Declare ds as new in public declaration or instantiate again in the sub where ur using the DS. If you instantiate it will be a new dataset you will loose the data in it.

You selected the project type as ClassLibrary? What did not work for you?

Yes.. I agree. It might take some time to rewrite but its worth. You can identify which piece of code you dont need module wise and start writing in better way. No tool can simply converts vb6 to vb.net.

You can call the web page in webbrowser control by passing the URL.. See more about webbrowser control in net.

Are you using any database? If yes Then have a unique column in DB and get the values from DB anad attach to grid view column.

And also please Mark the thread as solved.

think you cant do it programatically.

Can you post ur updated code? Have u tried to take the insert statement from values variable and running it in SQL server?

Ur calling the another application within ur application?

Just try something like below.

 Private Sub test()
            Dim cntest As SqlConnection
            Dim strCnn As String = "ur Connection string"
            cntest = New SqlConnection(strCnn)
            cntest.Open()
            Try
                Dim cmdInsert As New SqlCommand
                cmdInsert.Connection = cntest
                Dim strCommandText As String = String.Empty
                Dim values As String = String.Empty
                strCommandText = "INSERT INTO TableName(COL1,COL2,COL3)VALUES("
                For Each row As DataGridViewRow In BOQSectionPartsDataGrid1.Rows

                    values = strCommandText & txtPTNO.Text & "," & row.Cells(0).Value.ToString & "," & row.Cells(1).Value.ToString & "'" & ")"
                    cmdInsert.CommandText = values
                    cmdInsert.ExecuteNonQuery()
                    values = ""
                Next
            Catch ex As Exception

            End Try
        End Sub

please post ur code. so that we can see where the problem is

U need to looptrhough each row of grid to get the values and prepare the insert statement and pass these values and execute the command.

U have asked same kind of question in one of your other thread. Dont you follow the answer?

What you mean by linked to?

show your code..

before rep.SetDataSource(d) have only those rows for which value is not 0. If your using any database you can do it in query or else you can remove the rows using dataview.rowfilter option.

Have application config file and mention your connection string. I hope your database is hosted on server and you know the server name and your application can ping to DB.

add 0 to FixSumPer if null using
IIf(IsDBNull(DataGridView1.Rows(i).Cells(9).Value), 0, DataGridView1.Rows(i).Cells(9).Value))

Then use the search condition in dataview using dataview.rowfilter method and bind the dataview back to grid.

You need to install framework in client system in which you developed ur application. You can even change the target framework in project proerty

On the server you tried to create virtual directory? What are your steps in deployement? See this link Click Here

You need to deploy that webservice into server

U need to set the activecell proerty or active row property to set the cursor

Using the rowindex. or get the number of rows in grid and select the last row

Listbox.items.removeat(Passtheindex) And writeback all the remaining lines to textfile again..

Using IO read the file in memory.. And add the line to text file using IO.File.Write and save the file..

Why you want to open in textbox? Try reading in moemory and add the site..

Please mark thread as solved.. :)

Making the form independent of resolution is difficult. That is why MS has brought in WPF. You can try using Layouts in form design.. Let us know if you get any sollution :)

This should work for you..

Private Sub TextBox1_KeyDown(ByVal sender As System.Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles TextBox1.KeyDown
        If e.KeyCode = Keys.F3 Then
            TextBox1.Text = Now().Date.ToShortDateString()
        End If

    End Sub

Cant you prepare the Select statement with Joins and UNION at database side? And just get the result set what u need...

In keydown event my code works good for me... Why cant you try that code in keydown? Instead of messagebox you can write ur code what you want to do after user pressing F3 key...

Try
'All ur code goes here
Catch ex As Exception
' Cathc the error if any and show the user or log
End Try