How to compare inserted text in (textbox1.text) with existing database va

Advertise your Business Here

Refer this Site

Login | Sign Up


	Do you have a collection of Interview Questions and interested to share with us!! Please send that collection to along with your userid / name. ThanQ

Categories >> Software >> Microsoft Related >> Visual Basic

Visual Basic Interview Questions

C Sharp Interview Questions

ASP.NET Interview Questions

VB.NET Interview Questions

COM+ Interview Questions

ADO.NET Interview Questions

IIS Interview Questions

MTS Interview Questions

Crystal Reports Interview Questions

BizTalk Interview Questions

Dot Net Interview Questions

Exchange Server Interview Questions

SharePoint Interview Questions

Question

How to compare inserted text in (textbox1.text) with 
existing database value in (Sqldatasource1) in visual 
studio 2005 ?

Question Submitted By :: Saifxk2

I also faced this Question!!

Rank

Answer Posted By

Re: How to compare inserted text in (textbox1.text) with existing database value in (Sqldatasource1) in visual studio 2005 ?

Answer
# 1

Dim strValue As String
        strValue = txtValue1.Text

        Dim rstData As ADODB.Recordset
        rstData = New ADODB.Recordset

        rstData.Fields.Append("A",
ADODB.DataTypeEnum.adInteger, 0,
ADODB.FieldAttributeEnum.adFldKeyColumn)
        rstData.Fields.Append("B",
ADODB.DataTypeEnum.adVarChar, 10,
ADODB.FieldAttributeEnum.adFldIsNullable)
        'rstData.Fields.Append("C",
ADODB.DataTypeEnum.adVarChar, 0)

        rstData.Open()
        rstData.AddNew()
        rstData.Fields("A").Value = "1"
        rstData.Fields("B").Value = "Amol"
        rstData.Update()
        rstData.MoveFirst()
        If UCase(Trim(rstData.Fields("B").Value)) =
UCase(Trim(strValue)) Then
            MsgBox("True")
        Else
            MsgBox("False")
        End If

Is This Answer Correct ?

2 Yes

0 No

Amol

Question	Asked @	Answers
Other Visual Basic Interview Questions


WHAT IS DIFFERENCE BETWEEN PROCEDURAL PROG. LANGUAGE & EVENT DRIVEN PROG. LANGUAGE?		3
Describe Database Connection pooling relative to MTS ?		1
How can we find out that a recordset is blank (without using recordcount property)?		4
What are the types of validations available in Visual Basic?	Infosys	2
How many max. number of controls can place in one form (especially visual basic form)?	Satyam	6
What are the Sequence of events when a form is loaded in Visual Basic?		5
What is MAPI ?		2
What is the difference Between ADO and other data access objects?	HCL	2
List out controls which does not have events ?		1
What is the difference between a Sub and a Function?		2
Dim x, y as integer. What is x and y data type?		7
What is the maximum no. of forms can include in one project (vb project)?	Satyam	3
How to trap Data Base Error?		1
how many no of controls in form?	Airex-Logistics	15
To connect the Data Control with Back end What are all the properties to be set?		1
what is the Need of zorder method?		1
What are different types of cursors in ADODB?		4
What is RdExecDirect?		1
What are the tools available for Debug in VB?		2
What is the difference between a property a method and an event? Give an example of each.		6

For more Visual Basic Interview Questions Click Here


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us \|

Copyright © 2007 ALLInterview.com. All Rights Reserved.

ALLInterview.com :: Forum9.com :: KalAajKal.com