Posts by Pgmer

Then you need to ask the user to select image or file using the openfile something like below

Dim objFile As New OpenFileDialog
        objFile.ShowDialog()
        Dim filepath As String = ""
        If Windows.Forms.DialogResult.OK Then

            filepath = objFile.FileName
        End If

File path will have the path selected by user this you need to pass to your EXE.

If your reading the specific file or image from specific location then you could code it in C application which is EXE which your running when clicking button on vb form.

It should be txt_cash_acc.text="" or txt_cash_acc.text= string.empty

logic looks ok. Check dp.Color is exact method to give the color to chart. You can try giving color to one chart in form load or click of button for testing. if this works then above code should work

 Try
            Dim cn As SqlConnection
            Dim strCnn As String = "Your data base connection string"
            cn = New SqlConnection(strCnn)
            cn.Open()
            Dim comm As New SqlCommand("Your sp or Command text to get the data from DB", cn)
            '' If ur using Sp then Commandtype= CommandType.StoredProcedure if it is Text then comm.CommandType=CommandType.Text
            comm.CommandType = CommandType.StoredProcedure
            Dim da As New SqlDataAdapter(comm)
            Dim ds As New DataSet
            da.Fill(ds)

            Dim dv As New DataView
            dv = dsNew.Tables(0).DefaultView
            dv.RowFilter = "Name = '" & "John" & "'"

            ''Close your connections and commands.
        Catch ex As Exception
            ''Handle error if any
        End Try

try something like this code.
Note:Code above is not tested. You need to change the filter criteria to your need.

Where is the code for Dataview and rowfilter?

Show your code here..

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

refer this link Click Here

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

In ts you subtract 60 minutes if it is a timespan, before showing or assigning to the text box TotalHWtextbox.

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.

jhedonghae Are you using datetime pickker to select the date or time and filling the text boxes? If yes then CodeFive is in right way..

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?

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?

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

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.

Great... Happy i could help you. Some times small things wont strike in mind :)

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)

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

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.

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 can seperate the business logic and code behind like in web.

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.

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

Can you please define what is labour productivity?. And what all you have so far? I mean the database and its structure, etc...

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.

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.

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 some basic idea.. Happy coding in vb.net :)

Waqas you can keep the file encrypted and under some remote folder where user wont be able to reach and decrypt the file. Is that make sense?

Waqas HibaPro wont follow the posts i think.. Its not good to spend time :)

Simple way is to have encripted textfile for control in remote location and each time the app open check the count. if the count exceeds close the app.

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.

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

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 the user. For more ideas please share your application details like Is it offline tool? or connects to DB over network etc.

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

Please explain in detail what you want to achieve..

When user creates the records in DB save the user name, And while updating or deleting the data check which user if same who has created then let the operation or else stop the operation with appropriate message to the user.

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.

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?