i am desire need of google search engine like search in a list of strings. I got list of around 1000 different text i need to basically catch type-o mistakes and give a good suggested search result.
In example is in db "apple on tree" and person searches "aplle"
or "city of los angeles" person searches "city of Angles" and results would be "city of angeles" not "city of somewhere else"sql like or difference just wont work on cases like this. Any suggestion how to do get around spelling mistakes and give reduced list of options. Not sure sql can handle this. but i am willing to go .net code methods as well.
I want to create 2 columns and 5 rows and want to give heading to those 2 columns and would like to manually enter the values in the rows, how ? (I don't want to connect this gridview with the database)
I have a gridview which uses an EditItemTemplate and an ItemTemplate for an 'Effect' column. The ItemTemplate simply displays the bound data using a label control. The EditItemTemplate defines a databound DropDownlist control which contains all the possible selections.
The gridview also contains a bound 'State' column which gives the State of each row. I have already been able to access this field in the gridview_RowDataBound event, so far using the value to decide whether to re-colour a row or not. What I would like to do is use this value to determine whether to use the ItemTemplate or the EditItemTemplate for each row.
Effectively I want to be able to decide whether to display just the data (For an Approved row) or display the DropDownList and allow the user to make updates (For an In Work row). I have searched for information on this issue online but have not found a lot, so I presume that my approach is not possible.
I have created a GridView, but the DataSet is created manually.Do I loose the built-in sort functionality of a Gridview? ....because I'm getting an unhandled exception when I try and click on the header now to sort. So I assume the answer is YES.
I go this code that can so a manual sorting on grid view. The code works fine for "ASC", when I wanted to sort the field to DESC, it never works. Second, it also failed when I switch to another page. Case 1: By default, the column is sorted DESC, then I switch to ASC, works fine, then I switch to DESC, it failed (remain at ASC).Case 2: By default, the column is sorted DESC, then I switch to ASC, works fine, then I switch to other page, it failed (remain at DESC on new page).
I've been trying to marry up the listview and the Data pager with my own, Database class that pulls the information from the database.
I can display the information ok no problem, fortunately this time I know what the problem is, but I cannot figure out a way around the problem.
In my Page_Load event I fill out the listview accordingly:
[Code]....
The problem lies in the postback, I need to figure out a way get the information as to what state the DataPager is in so I could update the Query accordingly.
I know there is a StartRowIndex avaialbe but this does not get updated in the Page_Load event.
I have GridView that is bound to an ObjectDataSource and within that GridView I have CheckBox, DropDownList, TextBox and Label controls. All the controls except the CheckBoxs are working like a champ or normal display and Delete (Insert is handled outside the GridView, it works also). The CheckBox values are passed into the update method for the ObjectDataSource as type byte. Without doing any custom coding the CheckBoxs were always unchecked (regardless of the data being 1 or 0) and when I edit a row in the GridView and saved the values the CheckBox controls would always be 0 even if the check boxes where checked. After searching web I found a suggestion to change the binding on the CheckBox controls from, Bind("Monday") to this, CheckUncheck(DataBinder.Eval(Container.DataItem, "Monday")) with CheckUncheck being a method to make 0 or null = false and 1 = true. This seemed to the do the trick and it set the CheckBoxs correctly in the DataGrid, I was giving myself high-fives, until I tried to update a row.
When doing the update, as with my first attempt, it would always set the CheckBox values to 0, thus ignoring the checked property of the CheckBox. So I search the web again and found a suggestion to handle the update manually, due to the binding being one way. So I created a myUnhappyGrid_RowUpdating event handler and changed all the columns in the GridView to template so I could do the old school .FindControl on them and grab the values. Once I was able to grab the values from the row to be updated I added them to the ObjectDataSource .UpdateParameters and called ObjectDataSource.Update() and it worked, kind of. Now came the next trial, it did the update into the database just fine and I was happy, until. I finished stepping though the code. As I stepped through the code the update on the ObjectDataSource got called two more times, thus undoing what I had just spent hours fixing. First, is the road traveled the right way to do it? Second, if I am on the correct road how can I suppress the additional two updates that follow my manual .update call on the ObjectDataSource?
I implement a manual sorting codes. It works only for ASC sorting. If you try to sorting gridview again by the same field it does not work. I mean how to solve for the sorting function for DESC
Sub PFTFormView_ItemUpdating(ByVal sender As Object, ByVal e As FormViewUpdateEventArgs) Dim PFTObj As New PFT Dim PFTDST As New Data.DataSet Dim newPFTLastName As String = DirectCast(PFTFormView.FindControl("txtPFTLastName"), TextBox).Text Dim newPFTFirstName As String = DirectCast(PFTFormView.FindControl("txtPFTFirstName"), TextBox).Text PFTObj.PFTLastName = newPFTLastName PFTObj.PFTFirstName = newPFTFirstName PFTObj.PFTHome = DirectCast(PFTFormView.FindControl("txtPFTHome"), TextBox).Text If PFTObj.UpdatePFT(Session("PFTId")) Then Me.lblErrorMessage.Text = "PFT Update Successfully" Else ' Me.lblErrorMessage.Text = "PFT Update UnSuccessfully" End If PFTDST = Nothing PFTObj = Nothing end sub
My database is not allowing me to execute store procedure as perssion is denied by administrator. But I have to run a store procedure in my application, described below.
Can I replace this store procedure with "select query " on .net coding page i.e I want to make a function which will only select data from database and give the result same as this store procedure . store procedure-
iam creating a mini ERP project.. in that i am creating menu type as tree structure... i am using the below coding to expand the tree structure while page loading...
[code]......
the tree structures(nodes and sub nodes) calls from the database and it expand to the screen using above coding...
i have problem in it., each time when the page loads. the above coding runs about 170 time to expand the treeview to display in the screen.. i want to reduce this running cycle of this code.
i have taken a button in itemtemplate in gridview hte grid view have a column name votes i want when i click th button the value of votes increases by one of that particular row please provide the code in c# asp.net
I am building a class in which a GridView is created programmatically.I understand the need to fire the GridView_PageIndexChanging sub (no problems when coding the GridView declaratively).But when I build the GridView programmatically, I get the error:The GridView '' fired event PageIndexChanging which wasn't handled.How do I programmatically handle the PageIndexChanging event (code snippets in VB please)?
I've got a label in the item template tag of the datalist control. The label is bound to an integer column in the data source.
What I want to achieve is to retrieve the number from that label and change its text according to what number is retrieved.
i.e. if number retrieved = 1 then
lbl.text = "SomeText"
My problem is that I don't know how to code that label as it is found in the <ItemTemplate> of the datalist and intellisense cannot identify the label.
Is it possible for me to code that label using code behind? or is there any other way to do this?
I currently have a gridview which I have populated using the following method:
[Code]....
What I am looking for is advice on how to handle coding a proper DeleteMethod to assign to my ObjectDataSource (via my class file). I have been searching through several forums, websites and other media and have been left a little confused. Everyone seems to have their own method, none of which I have been able to successfully adapt to my own needs. Here is some of the functionality that I am looking for:
1.) Delete item using Gridview's delete button
2.) Delete the record from both the datatable (and Gridview Row) and the database that the table was generated from.
3.) Upon deletion, refresh gridview
This may sound simple to many of you, but I need a little advice as to where to start. Any applicable threads, tutorials etc.