Posts by Pgmer

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

Which version of VS ur using? go for datagridview.

Datagridview1.rows.add method to add the rows to grid..

You can save the content of file i am not sure the file itself can be saved in DB.

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

After running this code did you check there is table in dataset? And table has rows?

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

I just gave as example to show Which key is pressed for testing.. You need to take only what u need.

Why cant u try like this

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
            MessageBox.Show(e.KeyCode.ToString)
        Else
            MessageBox.Show(Keys.KeyCode.ToString)
        End If

    End Sub

Try application.doevents.. Or Try to use threading or background worker..

IsIdentity =true? And identity seed=1? Then if you have any records in table it will be not be -Ve

Then based on the Query result u need to set the selectedtext property of the combo..

disappear?? do u have other option
What you mean by disappear? Are you looping through? or static no of rows?

Try something like this
DataGridView1.Rows(1).Cells(1).Value = "Testing"
But you need to know in which row and which column you need to add value..

Is your query correct? What is the issue. please explain

Are you allready binding the combobox from database?

I know this thread is solved, Pooja can you explain the solution in detail plz..

Dear Iamateur Do you understand what the code is? What you mean by all the MDI form? application will have one MDI form. Not many... And the code above you wrote is for setting the child form to its parent as MDI form

preferably primary key should be integer only. It should not be varchar datatype.

are you getting anything in myreader? myreader.hasrows=true?

What you mean by making datagid as table? in UI or database table? please explain...

And also use the finally bloack to close ur connection to database or to dispose any objects...

listbox1.Items.Add("Item you want to add 1" & vbtab & "Item you want to add 2")

conflict in database? Explain in detail about your problem.

I am not able to reply to any thread... I am no longer member to daniweb?

Hi team,
I am not able to see all the post in which i contributed in new version... :(

@Poojavb why need to add textbox and assign book_id? Cant he bind the book_id to grid and make that coloumn visible false? and read that Id when user click on delete?

What you mean by cant publish? You can publish with any dll's. Make all the dll's Copy local property=true and or add them in Prerequisites of app and try to publish. in publish folder you should be able to see all the dll's

What is your problem?

Please post your code you have so far. So will come to know your approach to show records.

Dear darthswift00
Please open up your own thread dont post your problem in some one else post.

In property pages of the project Configuration should be active Debug,Build output path should be bin/Debug. Are you using the publish wizard of the visual studio?

Change ur configaration debug. And check your project property pages. from where it is taking the files when you building the app.

Are you copieng your MDB database file in client system? Users do have enough permission on the folder where your application is pointing?

you mean third party software to build the installers? And if copy local=true then when u build the app it should get copy to out put folder.check ur output folder its debug or release.

Read how to create xml elements using vb.net and saving it as xml document.

@waqasaslammmeo your correct... But not exactly like database. its just like a container..

If your loading the items into array list then sort the array to group the items.

Data set is just like a table, you can get the data from database and load it into dataset and this dataset you can use to bing to grid or whatever.. Read about dataset in internet..

Delete the dll's from debug folder and build ur application again, if copylocal=true then all the dll's should come in debug folder again, And what is your way of deployement?

Make copylocal=true in property window for that folder and make sure when u build the app this dll should get copied to ur bin/Debug folder.

your checking for IF dTable.Rows.Count = 0
if count is 0 means there is no data in datatable... how will you get the value?
I think it should be IF NOT dTable.Rows.Count = 0

Save the files in DB and read from your .Net app or windows service. U can create copy whatever you want, But will not be fast as FTP... This is my idea.. Experts in forum may give there idea's too... :)

Search in internet for FTP... u may get some idea.. U need to write broker service which will be running in ur server.

Post ur complete code... are u trying in datarow view? Cant you get the value to string variable and do indexof(.)?

You need to check which radio button is checked before saving and accordingly pass the values to DB

Try setting dataset=nothing or dataset=null. This should work

Post your code here or try something like below

Private Sub ListBox1_SelectedValueChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles ListBox1.SelectedValueChanged
        If ListBox1.SelectedItem.ToString.Length > 0 Then
            Process.Start("explorer.exe", ListBox1.SelectedItem.ToString)
        End If

You are loading the full path of files into list box right? Then in selected index changed event of list box read the file path and load the file using Process.Start("explorer.exe", Filepath)

I am able to open all kinds of files using above code, Provided you have the file readers installed in machine..