iam working with asp.net application with csharp, i want to search data through ajax control (like google search) ,iam verynew to ajax, pls explain me step by step usage of ajax of this senario
I made a usercontrol consisting of an AJAX tab control, a textbox, and a gridview. The gridview is pulling data from a SQL database. When the gridview is outside of the tab control and I begin to enter text into the textbox, quicksearch begins to filter the information in the gridview. When i put the gridview and textbox inside an AJAX tab control quicksearch does not work. How do i need to structure the textbox and the gridview on an ajax update panel to get it to work?
i want make the search box for my website same like google have for it's site(ajax search box).i want as soon as i type something in my search box the realted link's of my site should be availble for the user.
I have a table called "publication" which contains records about Sharkspeare's plays, there are columns called "type", "nortonoxfordnumber", "nortonoxfordtext" and "character". What I like to achieve is to allow users to search the data using both dropdownlist and the textbox. i.e., the listitems of the dropdownlist are Othello, Tempest and twelfth night. Users should be able to type a keyword such as "music" to search within the particular play say "Othello" from the dropdownlist.
I would like to add button click function, and I know that I need to use the query with "and" and LIKE, but I am not sure how to do it as I keep getting the syntext error.
I managed to get some code done, however, I only managed to be able to search one column at the time, here is my code:
i have some text boxs in a page and in the same page there will be a table 'grid' like for holding the search result.When the user start editing and of the textbox above, the search must start by sending all textboxs values to the server 'ajax', and get back with the results to fill the below grid.
Notes:This grid should support paging, sorting by clicking on headers and it will contains some controls beside the results such as checkboxs for boolean values and links for opening details in another page.
I know many ways to do this some of them are:1- updatepanel around all of these controls and thats it "fast dirty solution"
2- send the search criteria using ajax request using JQuery post function for example and get back the JSON result, and using a template will draw the grid "clean but will take time to finish and will be harder to edit later".
3- ....My question is:What do you think will be the best choice to implement this scenario? because i face this scenario too much, and want to know which implementation will be better regarding performance, optimization, and time to finish.
For example : I have UserID and UserName. So I use DropDownList. UserName is DataTextField and UserID is DataValueField. So User can choose their name and I save UserID to my database. But If User is new and not registered. I want to allow to type in DropDownList and I save the name to database. So for registered people can choose and not registered people can key in.
Acutally i have added a GridView on my webform and two text box's with having asp:calender extensions, button as well. I have one table in my database with column name 'Time'(datetime) with having some dates.
I need any one can search in between the selected dates, but i am facing a problem, if i select the excat year what i have in my database table then only i get my result into the Gridview otherwise i am getting an error........
protected void btnAdminSearchDate_Click(object sender, EventArgs e) Line 838: { Line 839: DateTime dt1 = Convert.ToDateTime(FromDate.Text); Line 840:DateTime dt2 = Convert.ToDateTime(UptoDate.Text);
i know it seems like i have asked this question before in my previous post but does any one know how to find a control in a gridview but it must be done in the SelectedIndexChanged event ....the previous method i was given only seems to work in the onRowBound method...If possible is their a way you can determine which button was click since i have more then one button in my gridview
i just want to place a text box and if i enter any value in that, it must filter the exact match for that and must show the details in gridview. how can i do this. my control is firstname, i am going t ofilter using firstname
I've got a dropdownlist control that the user can select an an employee name and that should then fill in the detailsview control with specific information about that employee.
My dropdownlist control works fine and I do have AutoPostBack set to true. For some reason my detailsview doesn't work. There's no error message. The detailsview control just doesn't show up.
Here's my code:
This is the sqldatasource control for the dropdownlist control:
[Code]....
This is the sqldatasource control for the detailsview control:
I have this webform with few fieldsin the search criteria,I added a new dropdownlist named "Company",I populated it with the data from the database, now when I click search choosing this criteria it doent work.
public partial class List : PrintablePage { private string CNUM; private string CNAM; private string CEL; private string SD; private string SDE;........
1- ddlzone1 2- ddldistrict1 and one button (search)
At first I select item from ddlzone1 click on search button according to below SP it search on database and show result...
ALTER procedure [dbo].[GetCustomersPageWise] @PageIndex INT = 1 ,@PageSize INT = 5 ,@RecordCount INT OUTPUT ,@Region nvarchar(10) ,@District nvarchar(20)
[Code] ...
Now I want when users select item from ddlzone1 after that if they select item from ddldistict1 according to their selected item from ddlzone1 and ddldistrict1 it search in table and show result
Now how I can change my SP
I changed below code in SP but it didn't work
WHERE ([HOuse_info].Region = @Region or @Region='0') or ([House_Info] .District=@District or @District='0') SELECT @RecordCount = COUNT(*)
* Products table, it is consists of these columns :
ProductId int
ProductNO nvarchar
CatalogeId int
BrandId int
MainSpecification nvarchar
DetailsSpecification ntext
Image imageand I want to desgin form for products, and this form contain these ToolBox
* DropDownList for CatalogeId
* DropDownList for BrandId
* DataList Control for displaying the Result Search
* Button
When the user visit Product Page for Example (productpage.aspx), then he see the two DropDownList , then choose one of Cataloge Name (Laptop , Printer, ....) , and choose one of the Brand Name (Sony, Toshiba, ....) , then Click the Button, and get the Result Search in Paging DataList