Visual Basic

29-Apr-08 9:41

hello

I have just started learning sql 2005 and i have create small table student with 3 columns studentID,firstname and lastname it's works fine i can insert,delete without any problem but when i delete any entry it dosent refresh the page i mean it delete record from sql database but it shows deleted entry in text boxes but if i close application and restart it then it dosent show deleted entry any help this is the code for delete

Private Sub Button5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button5.Click<br />
Dim SQL As String = Nothing<br />
SQL = "DELETE FROM Student WHERE StudentID = " & TextBox3.Text<br />
If MessageBox.Show("Are you sure you want to delete", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) = MsgBoxResult.Yes Then<br />
conStudent = New Data.SqlClient.SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Projects\SQL DataApplication\SQL DataApplication\Student.mdf;Integrated Security=True;User Instance=True")<br />
conStudent.Open()<br />
Try<br />
commStudent = New SqlClient.SqlCommand(SQL, conStudent)<br />
commStudent.ExecuteNonQuery()<br />
<br />
MsgBox("Item deleted", MsgBoxStyle.Information)<br />
Catch ex As Exception<br />
MsgBox(ex.Message)<br />
End Try<br />
conStudent.Close()<br />
conStudent.Dispose()<br />
Else<br />
Exit Sub<br />
End If<br />
End Sub

any help

waiting for your kind rep.
have a nice time

thanks

modified on Tuesday, April 29, 2008 4:00 PM

Ray Cassick29-Apr-08 11:54

29-Apr-08 11:54

Just deleting the data form the database doe snot cause your display page to refresh. Depending on how you are displaying the data you need to handle that yourself after the delete is done.

Your query just removes the data form the DB. You have to either requery to display the data without that record now or at least refresh your page and clear out the data that is displayed.

FFRF[^]

bapu288930-Apr-08 8:03

30-Apr-08 8:03

Hello sir

first of all thanks for your rep.

sir i am new in sql and this is my first attempt to do some thing with sql server so can you please tell me more how get on with it i dont want code and copy past code does not solve the problem i want to understant it
and still i am trying Confused | :confused:

waiting for your kind rep.

have a nice day

thanks again

Ray Cassick30-Apr-08 8:37

30-Apr-08 8:37

My suggesting is that once you do the query to delete the record you need to manually refresh the interface to show this.

It depends on bit on how you are filling your interface also. My guess is that if you are doing data binding then you may just be able to refresh the binding-manager to do this. If you are manually reading a record and placing data form the fields into the text properties of your UI then you have to at very least go back through the UI and clear out those text properties to show that the record has been deleted.

If you have a client side record-set that you have used to populate your UI from that is not really going to reflect the changes made int eh DB though until you have redone that read query so your record-set on the client may need to be flushed and refilled to show the change also.

There are so many different ways to do all of this, I can;t really cover them ALL here. I might suggest that you concentrate on searching how to do this keeping in mind the method you are using to read the data and display it in the first place.

FFRF[^]

bapu28891-May-08 8:32

1-May-08 8:32

hello sir

thanks for your rep.

i have tried few things but still i am no way near

this is what i have done

 Private Sub Button5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button5.Click<br />
        Dim SQL As String = Nothing<br />
        SQL = "DELETE FROM Student WHERE StudentID = " & TextBox3.Text<br />
        If MessageBox.Show("Are you sure you want to delete", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) = MsgBoxResult.Yes Then<br />
            conStudent = New Data.SqlClient.SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Documents and Settings\bablu\My Documents\Visual Studio 2005\Projects\SQL DataApplication\SQL DataApplication\Student.mdf;Integrated Security=True;User Instance=True")<br />
<br />
            conStudent.Open()<br />
            Try<br />
                commStudent = New SqlClient.SqlCommand(SQL, conStudent)<br />
                commStudent.ExecuteNonQuery()<br />
                dsStudent.Clear()   :confused:<br />
<br />
                daStudent.Fill(dsStudent)    :confused:<br />
<br />
                MsgBox("Itemdeleted successfully", MsgBoxStyle.Information)<br />
            Catch ex As Exception<br />
                MsgBox(ex.Message)<br />
            End Try<br />
            conStudent.Close()<br />
        Else<br />
            Exit Sub<br />
        End If<br />
    End Sub

and i have also read tool tip when i select from IDE but now i dont know what to do

waiting for your kind help

have a good day sir

thanks

Ray Cassick1-May-08 11:02

1-May-08 11:02

I think your problem here is that the dsStudent that you are using still has the data form when that record existed. You need to repopulate that data-set like you did originally once the database is changed. You are not removing data form the data-set, you are removing it by running a query against the database itself. Once you aer done with the delete clear your data-set and repopulate it from the database.

FFRF[^]

bapu28892-May-08 9:29

2-May-08 9:29

Hello sir

thank you very much for you help and finally job done Smile | :)

this is the final code and it's working fine

 Private Sub Button5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button5.Click<br />
        Dim SQL As String = Nothing<br />
        conStudent = New Data.SqlClient.SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=C:\SQL DataApplication\SQL DataApplication\Student.mdf;Integrated Security=True;User Instance=True")<br />
        SQL = "DELETE FROM Student WHERE StudentID = " & TextBox3.Text<br />
        If MessageBox.Show("Are you sure you want to delete", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) = MsgBoxResult.Yes Then<br />
            conStudent.Open()<br />
            Try<br />
                commStudent = New SqlClient.SqlCommand(SQL, conStudent)<br />
                commStudent.ExecuteNonQuery()<br />
                MsgBox("Itemdeleted successfully", MsgBoxStyle.Information)<br />
            Catch ex As Exception<br />
                MsgBox(ex.Message)<br />
            End Try<br />
            conStudent.Close()<br />
        Else<br />
            Exit Sub<br />
        End If<br />
        dsStudent.Clear()<br />
        Call LoadData()<br />
<br />
    End Sub<br />
<br />
<br />
<br />
  Private Sub LoadData()<br />
        conStudent = New Data.SqlClient.SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=C:\SQL DataApplication\SQL DataApplication\Student.mdf;Integrated Security=True;User Instance=True")<br />
<br />
        If conStudent.State = ConnectionState.Open Then<br />
            conStudent.Close()<br />
        End If<br />
     <br />
        Try<br />
            conStudent.Open()<br />
            daStudent.Fill(dsStudent, "Student")<br />
            Label1.Text = Me.StudentBindingSource.Position<br />
        Catch ex As Exception<br />
            MsgBox(ex.Message)<br />
        End Try<br />
        conStudent.Close()<br />
        conStudent.Dispose()<br />
       <br />
    End Sub

i am going to make few changes like connection here i am using connecting string more then one time so i can make sub for it and call it when ever it's needed

but the method i am using is this the one of the right method ? I just want to know your views as an expert and still

thanks again sir for your help

have a nice week end

take care Rose | [Rose]

Ray Cassick2-May-08 9:37

Sending text to the printer

2-May-08 9:37

Without seeing the entire solution its hard to tell if this is the BEST way Smile | :)

But I say that if it gets your job done then it is a step in the right direction.

My rules are make it work then make it pretty. You now have the 'works' part, now it is up to you to see if the way it works fits well with your overall design and if not, make it pretty Smile | :)

I would assume that you are using the LoadData() sub already to load your data in the first place. If not then you might want to consider some refactoring in that area there.

Good luck, glad I could help a bit.

FFRF[^]

MikeMarq29-Apr-08 8:40

MikeMarq

29-Apr-08 8:40

I'm trying to have my program display the PrintDialog and then print out some text. I assumed it would work similar to the open and save dialogs but when I try to double click on the printdialog it refuses to produce an event for when the person clicks the print button.

Can someone explain what is going wrong and how I can print a string of text. thanks

Mike

Smithers-Jones29-Apr-08 8:53

Smithers-Jones

29-Apr-08 8:53

You need a printdialog and a printdocument. When printdialog's dialogresult=okay use printdocument.print to call the printdocument.printpage-event. There you have to use graphics.drawstring-method to print your string.

"I love deadlines. I like the whooshing sound they make as they fly by." (DNA)

MikeMarq29-Apr-08 15:40

MikeMarq

29-Apr-08 15:40

Thank you for your help. But I have a follow up question, when I double click on the printdocument I dragged and dropped into the program it creates a subroutine. However, when I run the program and click the print button of the printdialog it doesn't trigger the event. What is the event that the print button triggers?

thanks again,

Mike

Smithers-Jones29-Apr-08 21:33

Smithers-Jones

29-Apr-08 21:33

printdialog1.document = printdocument1<br />
if printdialog1.showdialog = dialogresult.ok then printdocument1.printpage

"I love deadlines. I like the whooshing sound they make as they fly by." (DNA)

MikeMarq30-Apr-08 2:10

MikeMarq

30-Apr-08 2:10

Thank you again for your help. But I still don't know what event this code goes into because the printdocument1.printpage event isn't triggered and printdialogs don't appear to allow events.

thanks,

Mike