Click here to Skip to main content
15,886,012 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionDifference between Scripting.Drive and DriveInfo: One works to detect external usb device, one doesn't Pin
babybass20-Jul-09 8:15
babybass20-Jul-09 8:15 
AnswerRe: Difference between Scripting.Drive and DriveInfo: One works to detect external usb device, one doesn't Pin
Alan N20-Jul-09 9:55
Alan N20-Jul-09 9:55 
GeneralRe: Difference between Scripting.Drive and DriveInfo: One works to detect external usb device, one doesn't Pin
babybass20-Jul-09 10:57
babybass20-Jul-09 10:57 
QuestionTriplesDES error Pin
TheMrProgrammer20-Jul-09 7:10
TheMrProgrammer20-Jul-09 7:10 
AnswerRe: TriplesDES error Pin
Luc Pattyn20-Jul-09 7:54
sitebuilderLuc Pattyn20-Jul-09 7:54 
GeneralRe: TriplesDES error Pin
TheMrProgrammer20-Jul-09 21:07
TheMrProgrammer20-Jul-09 21:07 
GeneralRe: TriplesDES error Pin
Luc Pattyn21-Jul-09 1:41
sitebuilderLuc Pattyn21-Jul-09 1:41 
Questionhow to return dataadapter and data set from the same function Pin
hemrk20-Jul-09 6:08
hemrk20-Jul-09 6:08 
have created function in class file.
Public Shared Function dsCntrctET() As DataSet
Dim sqlCntrct As String = "Select * from CNTRCT_ET where CNTRCT_ID=" & CISCNO
Dim cmdCISContract As New OracleCommand
Dim daCISCntrct As New OracleDataAdapter
Dim dsCISCntrct As New DataSet
Dim cmdCISBuilder As New OracleCommandBuilder
Try
With cmdCISContract
.Transaction = myTransCIS
.CommandText = sqlCntrct
.Connection = cnCIS
End With
daCISCntrct = New OracleDataAdapter(cmdCISContract)
daCISCntrct.FillSchema(dsCISCntrct, SchemaType.Source)
cmdCISBuilder = New OracleCommandBuilder(daCISCntrct)
With daCISCntrct
.TableMappings.Add("Table", "CNTRCT_ET")
.Fill(dsCISCntrct)
.SelectCommand = cmdCISContract
.InsertCommand = cmdCISBuilder.GetInsertCommand
.UpdateCommand = cmdCISBuilder.GetUpdateCommand
.DeleteCommand = cmdCISBuilder.GetDeleteCommand
End With

Catch ex As Exception
MessageBox.Show(ex.Message)
End Try
Return (dsCISCntrct)
End Function

it returns dataset that i can use for getting value from table.
but while saving data, i have to use dataadapter for da.update(ds,"table") and ds.acceptchanges.

this i have to use in multiple forms as this data comes from 3rd party so i dont want to write this in every form . so i thought how to return data adapter and dataset from the same function. as i wanted to use daCISCntrct and dsCISCntrct.
AnswerRe: how to return dataadapter and data set from the same function Pin
Christian Graus20-Jul-09 14:37
protectorChristian Graus20-Jul-09 14:37 
GeneralRe: how to return dataadapter and data set from the same function Pin
hemrk20-Jul-09 15:47
hemrk20-Jul-09 15:47 
Questionuseing .MovePrevious() etc Pin
StephenFinch20-Jul-09 2:31
StephenFinch20-Jul-09 2:31 
AnswerRe: useing .MovePrevious() etc Pin
Johan Hakkesteegt20-Jul-09 2:48
Johan Hakkesteegt20-Jul-09 2:48 
GeneralRe: useing .MovePrevious() etc Pin
StephenFinch20-Jul-09 3:02
StephenFinch20-Jul-09 3:02 
QuestionValidating a cell in DataGrid Pin
rhtbhegade20-Jul-09 0:51
rhtbhegade20-Jul-09 0:51 
AnswerRe: Validating a cell in DataGrid Pin
Jay Royall20-Jul-09 1:02
Jay Royall20-Jul-09 1:02 
GeneralRe: Validating a cell in DataGrid Pin
rhtbhegade20-Jul-09 2:11
rhtbhegade20-Jul-09 2:11 
GeneralRe: Validating a cell in DataGrid Pin
Jay Royall20-Jul-09 2:27
Jay Royall20-Jul-09 2:27 
GeneralRe: Validating a cell in DataGrid Pin
rhtbhegade20-Jul-09 2:37
rhtbhegade20-Jul-09 2:37 
GeneralRe: Validating a cell in DataGrid Pin
Jay Royall20-Jul-09 2:48
Jay Royall20-Jul-09 2:48 
AnswerRe: Validating a cell in DataGrid Pin
dan!sh 20-Jul-09 1:02
professional dan!sh 20-Jul-09 1:02 
QuestionNeed help to add a VB shortcut(hotkey) key to function Pin
kaartikavin19-Jul-09 23:48
kaartikavin19-Jul-09 23:48 
AnswerRe: Need help to add a VB shortcut(hotkey) key to function Pin
nlarson1120-Jul-09 2:29
nlarson1120-Jul-09 2:29 
GeneralRe: Need help to add a VB shortcut(hotkey) key to function Pin
Dave Kreskowiak20-Jul-09 4:18
mveDave Kreskowiak20-Jul-09 4:18 
AnswerRe: Need help to add a VB shortcut(hotkey) key to function Pin
Dave Kreskowiak20-Jul-09 4:19
mveDave Kreskowiak20-Jul-09 4:19 
Questionhow to check is SQLServer2005 is installed on my m/c Pin
koolprasad200319-Jul-09 21:06
professionalkoolprasad200319-Jul-09 21:06 

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.