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

Advertise your Business Here

Refer this Site

Login | Sign Up


	To Refer this Site to Your Friends Click Here

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

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 ?

0 Yes

0 No

Amol

Question	Asked @	Answers
Other Visual Basic Interview Questions


Under which circumstance does a VB application ignore a Timer event?		1
What is Tabstrip control? What is the starting Index value? How to locate it?		1
To set the command button for ESC, Which property needs to be changed?		1
What is the difference between a property a method and an event? Give an example of each.		4
Different types of Passing Value?		1
What is the benefit of wrapping database calls into MTS transactions?		1
What is the purpose of the DoEvents command?		2
How to get free file location in memory?		1
What is Dll?		2
What is the different between Microsoft ODBC Driver and Oracle OBDC Driver?		1
How will you define a function to accept optional arguments?		1
How do you call a function in a DLL?		1
How does the following statements work? On Error Resume Next		1
What does Query_unload event do in VB? Why we need Form _unload event?		2
How many no of controls are there in form?	Satyam	1
What are properties available in Clip Board?		1
what is the Difference between listbox and combo box?		1
what is the Need of zorder method?		1
What are the types of Instancing property that can be set for a Class in a ActiveX DLL and ActiveX EXE?		1
How many system controls are available ?	HCL	1

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