Click here to Skip to main content
15,927,921 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Trying to get the enter key to not make noise Pin
Dave Kreskowiak1-Nov-04 6:02
mveDave Kreskowiak1-Nov-04 6:02 
GeneralRe: Trying to get the enter key to not make noise Pin
tuningd1-Nov-04 8:20
tuningd1-Nov-04 8:20 
GeneralRe: Trying to get the enter key to not make noise Pin
MohammadAmiry1-Nov-04 17:54
MohammadAmiry1-Nov-04 17:54 
GeneralRe: Trying to get the enter key to not make noise Pin
tuningd2-Nov-04 2:17
tuningd2-Nov-04 2:17 
GeneralVB - SQL HELP Pin
moon9931-Oct-04 23:51
moon9931-Oct-04 23:51 
GeneralRe: VB - SQL HELP Pin
Mekong River1-Nov-04 13:48
Mekong River1-Nov-04 13:48 
GeneralRe: VB - SQL HELP Pin
moon997-Nov-04 4:08
moon997-Nov-04 4:08 
GeneralUPDATE and DELETE in VB.NET Pin
lis858631-Oct-04 23:04
lis858631-Oct-04 23:04 
Cry | :((
HI All,

I have a simple program where I insert values into a Sql Database.
The following is my INSERT code:
Public SqlConn As New SqlConnection()<br />
    Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click<br />
<br />
        SqlConn = New SqlConnection("Data Source=SOORAJ;Initial Catalog=TrackEmp;User Id=sa; Password=; ")<br />
        Dim cmdText As String = "INSERT into EmpMaster(Name, Age, Gender, Address, TelephoneNo, MaritalStatus, Salary, Post,Department) Values ('" & txtName.Text & "','" & txtAge.Text & "','" & gSex & "', '" & txtAddress.Text & "', '" & txtPhone.Text & "','" & mStatus & "', '" & txtSalary.Text & "','" & txtDesignation.Text & "', '" & txtDept.Text & "')"<br />
        SqlConn.Open()<br />
        Dim cm As New SqlCommand(cmdText, SqlConn)<br />
        cm.ExecuteNonQuery()<br />
        SqlConn.Close()<br />
        MsgBox(" The Employee has been Added")<br />
        txtName.Text = ""<br />
        txtAge.Text = ""<br />
        txtAddress.Text = ""<br />
        txtPhone.Text = ""<br />
        txtSalary.Text = ""<br />
        txtDesignation.Text = ""<br />
        txtDept.Text = ""<br />
    End Sub,

I have 3 tables in my Database.

Can someone tell me how to go about with the UPDATE And DELETE.

Thanks and Regards,
lis

Thinking is like loving and dying.
Each of us must do it for himself.
GeneralRe: UPDATE and DELETE in VB.NET Pin
MohammadAmiry1-Nov-04 18:36
MohammadAmiry1-Nov-04 18:36 
GeneralRe: UPDATE and DELETE in VB.NET Pin
lis85861-Nov-04 19:46
lis85861-Nov-04 19:46 
Generalicons in win32 Pin
huutri7931-Oct-04 22:57
huutri7931-Oct-04 22:57 
GeneralRe: icons in win32 Pin
Chris Quick2-Nov-04 7:33
Chris Quick2-Nov-04 7:33 
GeneralStart Excel on remote PC Pin
TooStupidForTech31-Oct-04 22:42
sussTooStupidForTech31-Oct-04 22:42 
GeneralRe: Start Excel on remote PC Pin
Dave Kreskowiak1-Nov-04 0:50
mveDave Kreskowiak1-Nov-04 0:50 
GeneralColoum headers in listview Pin
Member 125367931-Oct-04 20:26
Member 125367931-Oct-04 20:26 
GeneralRe: Coloum headers in listview Pin
Dave Kreskowiak1-Nov-04 5:57
mveDave Kreskowiak1-Nov-04 5:57 
GeneralRe: Coloum headers in listview Pin
Member 12536792-Nov-04 19:01
Member 12536792-Nov-04 19:01 
GeneralUpdating Rows in Dataset Pin
nitin_ion31-Oct-04 18:26
nitin_ion31-Oct-04 18:26 
QuestionHow do i compare strings from different files? Pin
dex_ter1131-Oct-04 16:02
dex_ter1131-Oct-04 16:02 
AnswerRe: How do i compare strings from different files? Pin
Dave Kreskowiak1-Nov-04 3:12
mveDave Kreskowiak1-Nov-04 3:12 
GeneralVb.Net &amp; Yahoo Pin
Meysam.Khayatan31-Oct-04 8:46
Meysam.Khayatan31-Oct-04 8:46 
GeneralRe: Vb.Net &amp; Yahoo Pin
Dave Kreskowiak1-Nov-04 2:58
mveDave Kreskowiak1-Nov-04 2:58 
GeneralUse shell context menu in my application Pin
Vrby .Net31-Oct-04 4:09
Vrby .Net31-Oct-04 4:09 
GeneralRe: Use shell context menu in my application Pin
Dave Kreskowiak1-Nov-04 2:57
mveDave Kreskowiak1-Nov-04 2:57 
GeneralRe: Use shell context menu in my application Pin
Anonymous1-Nov-04 3:11
Anonymous1-Nov-04 3:11 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.