Click here to Skip to main content
15,845,785 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionAdding nodes to a treeview control Pin
Raistlin21_459-May-06 8:25
Raistlin21_459-May-06 8:25 
AnswerRe: Adding nodes to a treeview control Pin
digicd19-May-06 17:22
digicd19-May-06 17:22 
GeneralRe: Adding nodes to a treeview control Pin
Raistlin21_4510-May-06 7:01
Raistlin21_4510-May-06 7:01 
AnswerRe: Adding nodes to a treeview control Pin
Hacknight949-May-06 21:37
Hacknight949-May-06 21:37 
GeneralRe: Adding nodes to a treeview control Pin
Raistlin21_4510-May-06 7:05
Raistlin21_4510-May-06 7:05 
GeneralRe: Adding nodes to a treeview control Pin
Hacknight9410-May-06 15:15
Hacknight9410-May-06 15:15 
GeneralRe: Adding nodes to a treeview control Pin
Hacknight9410-May-06 15:21
Hacknight9410-May-06 15:21 
Questionfrom ADO to ADO.NET 2.0 Pin
Gulfraz Khan9-May-06 7:11
Gulfraz Khan9-May-06 7:11 
Hi!


The following code selects a row from a table. If the row exists then it is updated otherwise a new row is added to the table.

How can I write this code using ADO.NET 2.0?

Dim rsRequest As New ADODB.Recordset<br />
rsRequest.Open "Select Form_No, User_ID, Status, Request_Date from tbl_ReExport_Info Where Form_No = '" & txtFormNo.Text & "' And User_ID = '" & txtUserID.Text & "'", cnnADO, adOpenDynamic, adLockOptimistic<br />
With rsRequest<br />
    If .EOF = True Then .AddNew<br />
    !Form_No = txtFormNo.Text<br />
    !User_ID = txtUserID.Text<br />
    !Status = 0<br />
    !Request_Date = Now<br />
    .Update<br />
End With<br />


Thank You

Gulfraz Khan
QuestionHandling Complex Numbers Pin
crtwrght_mrk9-May-06 7:09
crtwrght_mrk9-May-06 7:09 
AnswerRe: Handling Complex Numbers Pin
darkelv9-May-06 7:25
darkelv9-May-06 7:25 
QuestionRe: Handling Complex Numbers Pin
crtwrght_mrk9-May-06 10:34
crtwrght_mrk9-May-06 10:34 
Question&quot;load report failed&quot; error Pin
sarah_chandran9-May-06 6:05
sarah_chandran9-May-06 6:05 
AnswerRe: &amp;quot;load report failed&amp;quot; error Pin
penguin500011-May-06 21:05
penguin500011-May-06 21:05 
Questionhow to export crystal report from vb in pdf format Pin
virendra_sw9-May-06 4:48
virendra_sw9-May-06 4:48 
AnswerRe: how to export crystal report from vb in pdf format Pin
albCode9-May-06 5:07
albCode9-May-06 5:07 
GeneralRe: how to export crystal report from vb in pdf format Pin
virendra_sw9-May-06 20:33
virendra_sw9-May-06 20:33 
Questionneed help on programing methods Pin
Eleazer9-May-06 3:46
Eleazer9-May-06 3:46 
AnswerRe: need help on programing methods Pin
J4amieC9-May-06 4:36
J4amieC9-May-06 4:36 
Questiona simple question ? (how to use Raiseevent ?) Pin
cmpeng349-May-06 2:38
cmpeng349-May-06 2:38 
AnswerRe: a simple question ? (how to use Raiseevent ?) Pin
Daniel Grunwald9-May-06 9:26
Daniel Grunwald9-May-06 9:26 
QuestionWindow Service Pin
nitin_ion9-May-06 2:04
nitin_ion9-May-06 2:04 
AnswerRe: Window Service Pin
Rizwan Bashir9-May-06 2:37
Rizwan Bashir9-May-06 2:37 
GeneralRe: Window Service Pin
nitin_ion9-May-06 19:50
nitin_ion9-May-06 19:50 
GeneralRe: Window Service Pin
Rizwan Bashir9-May-06 22:43
Rizwan Bashir9-May-06 22:43 
Questionregarding Common Dialog Control Pin
Vijaya Krishnamoorthy9-May-06 0:37
Vijaya Krishnamoorthy9-May-06 0:37 

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.