Click here to Skip to main content
16,009,185 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralHelp Needed Pin
Anonymous11-Apr-05 1:43
Anonymous11-Apr-05 1:43 
GeneralNeed Help Pin
Anonymous11-Apr-05 1:36
Anonymous11-Apr-05 1:36 
GeneralRe: Need Help Pin
Anonymous11-Apr-05 5:51
Anonymous11-Apr-05 5:51 
GeneralUsing buttons instead of linklabels Pin
kwttrev11-Apr-05 0:56
kwttrev11-Apr-05 0:56 
GeneralRe: Using buttons instead of linklabels Pin
Dave Kreskowiak11-Apr-05 3:51
mveDave Kreskowiak11-Apr-05 3:51 
GeneralRe: Using buttons instead of linklabels Pin
kwttrev11-Apr-05 19:48
kwttrev11-Apr-05 19:48 
GeneralParameterized query in Oledb by code Pin
Suman Singh10-Apr-05 23:39
professionalSuman Singh10-Apr-05 23:39 
GeneralRe: Parameterized query in Oledb by code Pin
Ritesh123411-Apr-05 2:15
Ritesh123411-Apr-05 2:15 
Hi,
If ur using SQL Database than rather than going for OLEDB object u should use SQLDB object.....Try this code

Imports System.Data.SqlClient
..............
................

    Dim ds1 As New DataSet()
    Dim adap As New SqlDataAdapter()
    Private Sub Button11_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim con1 As New SqlConnection("Data Source=(local); User ID=sa;Initial Catalog=pubs;password=;")
        Dim com As New SqlCommand("select name from student where roll = @Roll", con1)
        ds1.Clear()
        adap.SelectCommand.Parameters.Add("@Roll", TextBox1.Text.trim)
        adap.SelectCommand = com
        adap.Fill(ds1, "student")
        TextBox2.Text = ds1.Tables("student").Rows(0).Item("name")

    End Sub

........................
........................

I hope this will help u.............:->

Regards,
Ritesh
GeneralRe: Parameterized query in Oledb by code Pin
Suman Singh11-Apr-05 11:35
professionalSuman Singh11-Apr-05 11:35 
GeneralFind method is not working with untyped datatype Pin
Suman Singh10-Apr-05 23:23
professionalSuman Singh10-Apr-05 23:23 
GeneralRe: Find method is not working with untyped datatype Pin
Ritesh123411-Apr-05 2:01
Ritesh123411-Apr-05 2:01 
GeneralRe: Find method is not working with untyped datatype Pin
Suman Singh14-Apr-05 11:43
professionalSuman Singh14-Apr-05 11:43 
QuestionWhat is the main difference between Display member and Valuemember Pin
Suman Singh10-Apr-05 23:17
professionalSuman Singh10-Apr-05 23:17 
AnswerRe: What is the main difference between Display member and Valuemember Pin
Ritesh123411-Apr-05 1:57
Ritesh123411-Apr-05 1:57 
GeneralRe: What is the main difference between Display member and Valuemember Pin
AmbiguousName6-Feb-12 19:13
AmbiguousName6-Feb-12 19:13 
GeneralRe: What is the main difference between Display member and Valuemember Pin
lelouch_vi 215-Mar-20 1:59
lelouch_vi 215-Mar-20 1:59 
QuestionHow to validate dataview is NULL Pin
Suman Singh10-Apr-05 23:15
professionalSuman Singh10-Apr-05 23:15 
AnswerRe: How to validate dataview is NULL Pin
Ritesh123411-Apr-05 1:44
Ritesh123411-Apr-05 1:44 
QuestionHow to fetch rows from a dataview? Pin
Suman Singh10-Apr-05 23:14
professionalSuman Singh10-Apr-05 23:14 
AnswerRe: How to fetch rows from a dataview? Pin
Ritesh123411-Apr-05 1:40
Ritesh123411-Apr-05 1:40 
GeneralRe: How to fetch rows from a dataview? Pin
Suman Singh11-Apr-05 11:43
professionalSuman Singh11-Apr-05 11:43 
GeneralRe: How to fetch rows from a dataview? Pin
Anonymous11-Apr-05 22:38
Anonymous11-Apr-05 22:38 
GeneralRe: How to fetch rows from a dataview? Pin
Suman Singh14-Apr-05 11:49
professionalSuman Singh14-Apr-05 11:49 
Generalprinting using tcp/ip Pin
confirmnot10-Apr-05 22:34
confirmnot10-Apr-05 22:34 
GeneralChange line in text file Pin
johnjsm10-Apr-05 22:32
johnjsm10-Apr-05 22:32 

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.