Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: ASP.NET
hi am new to asp.net , I have one doubt in asp.net. How to compare the textbox value with the database field and to retrieve the matched rows in gridview . please any one give an idea.
Posted 27-Dec-11 19:28pm
Comments
thatraja at 28-Dec-11 0:30am
   
Where is your code?
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Hi,
 
Write a stored procedure or query which accepts some text(in your case it is textbox text) and pull the data using query like following
 
select (your fileds) from yourtable where (yourdatabase field to be compared) like '%'+your textbox value+'%'
 
Hope this helps
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

Write a sp and send text box value in one parameter using sql command object.
Query will be
select * from TableName where TableField = @TextBoxValue
 
Now, using run cmd.ExecuteNonQuery() and using dataadapter fill data to dataset. and bind this dataset to gridview.
  Permalink  
v2
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

Try This Store procedure for comparing txt from txtbox and value from DB.
first give the value to storeprocedure it will compaire from db value
 

@supname char(7)
As
Begin
Select
supid_name as [Supplier Name]
From Supplier
where
(supid_name=@supname)
End
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 609
1 OriginalGriff 587
2 Maciej Los 325
3 Mathew Soji 195
4 BillWoodruff 190
0 OriginalGriff 7,356
1 Sergey Alexandrovich Kryukov 6,712
2 DamithSL 5,461
3 Manas Bhardwaj 4,916
4 Maciej Los 4,475


Advertise | Privacy | Mobile
Web01 | 2.8.1411023.1 | Last Updated 28 Dec 2011
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100