Posts by Pgmer

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.

Hi All,
Any one can help me how to use TAPI to control the IP phones?
How to get started with? What all i should install and configure? I searched in net before posting it here but its too confusing for me. As this is my attempt in this area.. Any help would be great.

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

What you mean by linked to?

Dear rponraj please open a new thread for your problem. do not post in some one else post.

Why you need webbrowser to select a file from local path? What is the actual need?
Web browser control is used to view any web page within the application not to open any file.

Then the above code should work fine for you.. give it a try.

show your code..

Try something like below. I am assuming you will be knowing the sheet name

 Dim objExcelworkbook As Microsoft.Office.Interop.Excel.Workbook
 Dim objExcelActiveSheet As Microsoft.Office.Interop.Excel.Worksheet
 objExcelActiveSheet = objExcelworkbook .Sheets("TestPage")
 objExcelActiveSheet.Activate()

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.

Sorry not understanding your question properly. What you want to do? Data created in database using website you want to show on vb form? or you want to open website from vb form.

Best way is to do it at the backend using Cursors. If you want to delete from front end only then you can give this approach
(Assuming you have primary key in your table to indentify unique row.)
Get all the keys into array, and loopthrough them and call the delete procedure or write inline code.

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.

What you mean by current values? You can loop though controls and clear the contents.
for example

   For Each cntrl As System.Windows.Forms.Control In Me.Controls
            If cntrl.GetType.ToString = "System.Windows.Forms.TextBox" Then
                cntrl.Text = String.Empty
            End If
        Next

I am clearing all the textbox content to blank in form. Likewise you need to do for all the controls you need.

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.

I dont think it will ask you to open in browser without opening it in iDE

your aspx can open in browser. Open project in IDE in which you developed in your professor system and right click on aspx you want to view, then you could see browser option.

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

Show your code.. You checked the DB when you close the application? Once saved in Db will not delete automatically Either your deleting in your code or you are not loading it back.

INSERT INTO Cust_Details(Cust_ID, CustName, Gender, Age, Phone, CustAddress) Values "(" & custid & ", " & custname & "," & gender & "," & age & "," & phno & "," & custadd & ")"
Try this.

Do you have two database?

Then add the blank row to dataset and bind again..

Which database are you using? What is the table you want to update? Be specific.

Which database are you using?

How are you binding the records to grid?

If this Question is regarding sessions in ASP.Net Then it should be moved to ASP.net forum where experts can help you.... I suggest you to read on Session veriables, cookies, and Querystring in asp.net

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

loop through the datagridview to check weahter checkbox is checked and have the inner loop for listview and make the listview cell empty.

You can also use Select count(*) from bookings instead of Select *

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..

Using split function with delimiter as vbSpace get the contenets into array load the first item of array into New array list or use wherever u want to..

This link may help you Click Here

Please mark thread as solved.. :)

It will take the resource as number of files increses everytime. You should find some mechanisim to freeup the resource like using the background worker or threading. What if the file count reaches lacks?.. Cant u take out the old files after comparing to backup folder?

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 :)

No one will write code for you... We can just help you..

Use group by... Somthing like this
Select distinct ItemName,BatchNo,UOM,Department
from URTABLENAME group by ItemName,BatchNo,UOM,Department.
Include all the column in select and gropu by

Select Distinct top 10 [Batch No], [Item Name],Decentralization, UOM, Balance from Decentralization order by Serial desc
Distinct should come first before top 10...

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