Pgmer

you need to use dataview and filter the dataview with dataview.rowfilter method and bind the result back to the grid.

You should truncate the table to get the ID back to 1. If the Id column is set to increment seed.

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

check you have the proper sqlnet.ora and tnsnames.ora files. And make sure these file have the connection properties to your server. And for connection string you can refere the link [Click Here](http://www.connectionstrings.com/)

refer this link [Click Here](http://www.connectionstrings.com/)

Do you know in which row,column,cell you have the value? If not do it in a loop and compare.

I dont think we have dialog box with 12 buttons, So you need to write ur own Dialog box.

Use list or or Array to hold Dim sList as new list(of String) you must use the loop here something like below For i as integer=0 to DataGridView1.rows.count-1 sList.items.add(DataGridView1.rows(i).item("Column index or Name")) Next *Note:The above code is not exact code or syntax.. Just an idea to start with...*

Use datetime picker and set as you need to get only date or time. Show the selected time in text box. Is this what you were expecting?

What is the problem? Are you able to get into DB after connection.open()??

Why are you doing select * from if you only need Image from DB? and also check for the data after Dim dataTable As DataTable = dsImage.Tables(0).

Please check your userDetailsTable wheather it is having rows? And the column ur selecting is exists? if exists the column name is correct?

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 …

If many rows in ur Gridview then loop through the gridview rows and Get the items from respective cells by using rows(passindex).item(column) this will give u the items you want run the update statement on ur DB.

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

What is ur actual need? U want to keep checking for file exist or not all the time ur application is running?

I will try telling you one approch for this. When you load the combo 1 and after selection in combo 1, get all the data for combo2 in dataset and filter using dataview.rowfilter method and bind the selected record to ur combo..

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?

Get the number of textboxes wanted, And loop through the count from 0 to count-1 or 1-count, Then me.textbox.add give the names to the textboxes.

If you design your winform using XAML you can have resolution independent screens as everythnig goes into Grid and cells, And the application looks more pretty using WPF. If you need good loooking forms then go for WPF. :) its bit complicated to design in XAML though. And also you …

You mean to say if one user is using the form1 to input the data the other user should not be able to use the form1?

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.

Write a method or function which accepts the parameter of ur combotext, In the method or function write a code which connects to DB and fetches the records from DB based on the parameter. Call this method or function in selected index changed event of combo. Hope this gives you …

have clear thought what the software should do for you. And then have the design and then go with coding. Dont jump to code first.

I guess the problem is in `oSQLConn.ConnectionString = "server = localhost; user id = root; password = chris; database = retail;"` please check this.

what you mean by like excel here? you want to have filter like excel filter? or just filtering the records in grid?

Please explain in detail what you want to achieve..

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.

Easy way is to have text file inside the remote folder and keep writing the count every day and check for the count in each log in and after 30th day block the application. Need to take that text file should be encripted and should not be easily accessable to …

Try installing framework4 seperatly. and uncheck the option of framework when u installing the VS2010. you myt be having corrupt files.

If your loading the data from DB then you must call the function or method which you used to bind the records to grid.

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

Jim I agree with you as stuugie.. I liked the way you explained solution with explaination. Hope you give such technical explanation in your solution in the threads you reply.

And also please Mark the thread as solved.

Please post your code what you have so far so that people can see and help you on that.

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.

Ur calling the another application within ur application?

think you cant do it programatically.

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

What you mean by linked to?

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

How are you binding the records to grid?

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.

show your code..

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 …

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

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

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.

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.