Click here to Skip to main content
15,915,094 members
Home / Discussions / Database
   

Database

 
Questionhow to connect to database Pin
Rmesh11-Dec-06 17:41
Rmesh11-Dec-06 17:41 
AnswerRe: how to connect to database Pin
Paul Conrad11-Dec-06 19:31
professionalPaul Conrad11-Dec-06 19:31 
GeneralRe: how to connect to database Pin
karam chandrabose12-Dec-06 0:48
karam chandrabose12-Dec-06 0:48 
QuestionMySQL -> InnoDB error code 1005 Pin
Tomy140211-Dec-06 17:09
Tomy140211-Dec-06 17:09 
AnswerRe: MySQL -> InnoDB error code 1005 Pin
Rob Graham11-Dec-06 17:42
Rob Graham11-Dec-06 17:42 
GeneralRe: MySQL -> InnoDB error code 1005 Pin
Tomy140211-Dec-06 17:49
Tomy140211-Dec-06 17:49 
GeneralRe: MySQL -> InnoDB error code 1005 Pin
Tomy140211-Dec-06 18:05
Tomy140211-Dec-06 18:05 
QuestionDeleting DataRows Pin
Karma3125111-Dec-06 10:48
Karma3125111-Dec-06 10:48 
I am trying to get this program im writing to simply delete a datarow out of the datatable. Here is my code and it doesnt give me any errors it acts like it does it but the data is still there.

Data Tier
Public Sub deleteData(ByVal dIndex As Integer)
Dim row As myDataSet.tblMyRow = Me.tableadapter1.GetData.Row(dIndex)
row.Delete()
Me.myDataSet.AcceptChanges()
End Sub

Business Tier
Public Sub bDeleteData(ByVal bIndex As Integer)
mydataTier.deleteData(bIndex)
End Sub

GUI Tier
Private Sub btnDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDelete.Click
Dim dIndex As Integer
Dim dCount As Integer
dCount = Me.dataGrid1.SelectedRows.Count
If dCount = 1 Then
dIndex = Me.datagrid1.Rows.GetFirstRow(DataGridViewElementStates.Selected)
myBusTier.bDeleteData(dIndex)
Me.DataSet1.AcceptChanges()
Me.TableAdapter.Fill(Me.DataSet1.myTable)
ElseIf dCount <= 1 Then
MsgBox("Please Select a Row to Delete")
Exit Sub
Else
MsgBox("Please Select One Row at a Time")
Exit Sub
End If
End Sub

Thanx for the ear
Peace
QuestionAbout CDaoDatabase used in .Net2003 Pin
Yaki_1511-Dec-06 1:58
Yaki_1511-Dec-06 1:58 
AnswerRe: About CDaoDatabase used in .Net2003 Pin
Colin Angus Mackay11-Dec-06 2:10
Colin Angus Mackay11-Dec-06 2:10 
GeneralRe: About CDaoDatabase used in .Net2003 Pin
Mike Dimmick11-Dec-06 3:14
Mike Dimmick11-Dec-06 3:14 
GeneralRe: About CDaoDatabase used in .Net2003 Pin
Colin Angus Mackay11-Dec-06 4:12
Colin Angus Mackay11-Dec-06 4:12 
GeneralRe: About CDaoDatabase used in .Net2003 Pin
Yaki_1511-Dec-06 22:52
Yaki_1511-Dec-06 22:52 
GeneralRe: About CDaoDatabase used in .Net2003 Pin
Colin Angus Mackay12-Dec-06 12:14
Colin Angus Mackay12-Dec-06 12:14 
Questioniterating through a datagridview and getting the value of an unbound datagridviewcomboboxcolumn Pin
Rocky#11-Dec-06 1:04
Rocky#11-Dec-06 1:04 
Questionproblem on sql server connection Pin
Rmesh10-Dec-06 22:07
Rmesh10-Dec-06 22:07 
AnswerRe: problem on sql server connection Pin
Colin Angus Mackay10-Dec-06 22:16
Colin Angus Mackay10-Dec-06 22:16 
GeneralRe: problem on sql server connection Pin
Rmesh10-Dec-06 23:41
Rmesh10-Dec-06 23:41 
GeneralRe: problem on sql server connection Pin
Colin Angus Mackay11-Dec-06 0:22
Colin Angus Mackay11-Dec-06 0:22 
GeneralRe: problem on sql server connection Pin
Rmesh11-Dec-06 1:17
Rmesh11-Dec-06 1:17 
GeneralRe: problem on sql server connection Pin
Colin Angus Mackay11-Dec-06 2:07
Colin Angus Mackay11-Dec-06 2:07 
GeneralRe: problem on sql server connection Pin
Rmesh11-Dec-06 18:16
Rmesh11-Dec-06 18:16 
GeneralRe: problem on sql server connection Pin
Colin Angus Mackay11-Dec-06 21:33
Colin Angus Mackay11-Dec-06 21:33 
Questionprolem with sql server 2005 connection Pin
Khawar Abbas110-Dec-06 21:34
Khawar Abbas110-Dec-06 21:34 
AnswerRe: prolem with sql server 2005 connection Pin
Colin Angus Mackay10-Dec-06 21:44
Colin Angus Mackay10-Dec-06 21:44 

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.