autosuggest search box in datagrid column itself.......

Question

Hi Everyone, I looking for code which one is autosuggest search box in datagrid itself from database itself.

prabu k · Answer

Your talking about web application.I am expecting windows application datagrid view.Now I am developing billing software to retail shops and super market.I am trouble in salse entry form.In this screen having one datagrid view that contains 6 columns like sl no,Item Name,Salse price,mrp rate,quantity and total amount.Matched item details (datagridview) displayed below the current cell while user type any characters in item name textbox of current cell and outfill Item Name,salse price and mrp price automatically from item details gridview and cursor should be focused in quantity cell.This is my requirement pls any one help me. Thanks

Manikavelu Velayutham · Answer

Yes, He can use the same autocomplete plugin inside the gridview. Surely it will work.

Suthish Nair · Answer

Mani, I think he is talking about datagridview.

prabu k · Answer

Please send me the application to prabu_it2004@yahoo.co.in .If you got solution. Your talking about web application.I am expecting windows application datagrid view.Now I am developing billing software to retail shops and super market.I am trouble in salse entry form.In this screen having one datagrid view that contains 6 columns like sl no,Item Name,Salse price,mrp rate,quantity and total amount.Matched item details (datagridview) displayed below the current cell while user type any characters in item name textbox of current cell and outfill Item Name,salse price and mrp price automatically from item details gridview and cursor should be focused in quantity cell.This is my requirement pls any one help me. Thanks

Manikavelu Velayutham · Answer

Hope you have heard about JQUERY. They provide a autosuggestbox plugin in their site. Its just a Javascript file, you just need to include that javascript. Documentation is provided in the site itself, It will help you to implement the same in your project. Very simple steps and fastly works. Everything is provided in the below link. Plugin, Documentation, Live Demo, Screenshots & also the compatiblity. http://plugins.jquery.com/project/simpleautocomplete Make this post as answered, if this post really helps you.

kavitha u · Answer

hi Ankit Rathore.. the given database.rar does not have any file i am unable to open that...plz i am doing billing project i need some help pls can u give the application in .net.. Thanks & Regards Kavitha

Ankit Rathore · Answer

Hi Everyone, Here I am going to make a simple application of billing of any kind of supermarket. By which User can simply put the code of any item in datagridviewTextBox column according to that other field like ItemName, Price, will fetch from the database itself then in another column User will give the Quantity after that total amount will also calculated automatically and give the total.

Sam Hobbs · Answer

Use a combobox.

Shaik Ali · Answer

Can u plz elaborate what u want to do? and wat's the requirement?

Ankit Rathore · Answer

Hi Guys, Please give the single clue for this question by which I can start it properly.