Is there Any Way to Create Search in ASP.NET C# Without DB ?

Question

Hi ...... I Had Created Application Without Database . Using Grid View I Can InsertUpdate Delete those Details From The Table. The Given Data Will be Stored in C# Code itself in XML Format. In This Grid View I Had Saved The Data of Employee Details Like Name  Age  Qualification  Salary In This i Need to Create Search Name Text Box & Button. If I enter The Name in that and When i Click Search It Need to Show the Record of the Particular Employee. And (Mainly I Had Created Paging in Grid View) It Should Take And Come Records From All Pages If it Matches. Technology Used By Me Visual Studio 2010 ASP.NET 4.0 C# With Warm Regards..... R.V.Rajagopalan

Jayakumar · Answer

Hi Raja protected void btnSearch_Click(object sender EventArgs e) { DataTable dtSearchResult = new DataTable(); dtSample = new DataTable(); // here am again filling the datatable from Gridview DataSource so rows included in paging will also loaded in the table again dtSample = gvEmployeeDetails.DataSource as DataTable; //selecting the searched row from that datatable DataRow[] foundRow = dtSample.Select(name=' + txtSearch.Text + '); //adding coloumns to datatable same as like previous datatable. //mendatory that this new datatable column should be same as like in xml elements. dtSearchResult.Columns.Add(name typeof(string)); dtSearchResult.Columns.Add(age typeof(string)); dtSearchResult.Columns.Add(gender typeof(string)); dtSearchResult.Columns.Add(qualification typeof(string)); dtSearchResult.Columns.Add(Dept typeof(string)); dtSearchResult.Columns.Add(designation typeof(string)); //adding each row in the searched result to this new datatable foreach (DataRow row in foundRow) dtSearchResult.Rows.Add(row.ItemArray); //again binding new dataTable to gridview //now gridview will have only searched record. gvEmployeeDetails.DataSource = dtSearchResult; gvEmployeeDetails.DataBind(); } The above is the SearchButton Click event for you . usr this code surely you will get solution. here am binding the searched result again to the gridview so Gridview will display only the searched record. I think now your problem gets solved ???

Jayakumar · Answer

Hi am getting correct answer i checked in my system any way i will upload that code. after that also you dont get answer mean please call me @ 7736309822 because i may understand your problem wrongly

Rajagopalan R V · Answer

Hi Jaya Thank You Very Much  To Spend Time For Me For this Search Concept. its Retrieving the Data What am Entering into Search Field Its Working Fine......... With Warm Regards....... R.V.Rajagopalan

Rajagopalan R V · Answer

Hi Jaya Kumar Thanq Very Much For U R Reply First The Above Code is Retrieving the Particular Row Details from Data Table Correctly But its Not Binding or Filtering the Particular Row Details in the Grid View Please Let Me Know Solution For that With Regards..... R.V.Rajagopalan

Jayakumar · Answer

Hi Raja Please replace the foreach in the above reply with the foreach in this reply. foreach (DataRow row in foundRow) { age[incrementCount] = (string)row .ItemArray[1]; gender[incrementCount] = (string)row .ItemArray[2]; qualification[incrementCount] = (string) row .ItemArray[3]; Dept[incrementCount] = (string)row.ItemArray[4]; designation[incrementCount] = (string)row.ItemArray[5]; incrementCount++; }

Jayakumar · Answer

Hi Raja DataSet dsSample = new DataSet(); DataTable dtSample = new DataTable(); string[] age; string[] gender; string[] qualification; string[] Dept; string[] designation; string name = SAI; int incrementCount = 0; dsSample.ReadXml(Server.MapPath(XMLFile1.xml)); dtSample = dsSample.Tables[0]; dtSample.Select(name=' + name + '); DataRow[] foundRow = dtSample.Select(name=' + name + '); age = new string[foundRow.Length]; gender = new string[foundRow.Length]; qualification = new string[foundRow.Length]; Dept = new string[foundRow.Length]; designation = new string[foundRow.Length]; foreach (DataRow row in foundRow) { age[incrementCount] = (string)foundRow[0].ItemArray[1]; gender[incrementCount] = (string)foundRow[0].ItemArray[2]; qualification[incrementCount] = (string)foundRow[0].ItemArray[3]; Dept[incrementCount] = (string)foundRow[0].ItemArray[4]; designation[incrementCount] = (string)foundRow[0].ItemArray[5]; incrementCount++; } Its the sample code for your xml I have hard coded the search name as SAI as per your xml . its retrieving only that row from the datatable. Since that select statement will return collection of rows I used foreach to get values of retrieved records.. If you used ' name ' as primary field and you sure that there will be only one record with that 'name' there is no need of foreach. For further clarifications call me :)

Rajagopalan R V · Answer

Hi Jaya...... xml version =  1.0  standalone =  yes  ?> EmployeeDetails > Employee > name > RAJAGOPALAN name > age > 24 age > gender > Male gender > qualification > B.Tech qualification > Dept > IT Dept > designation > Developer designation > Employee > Employee > name > SAI name > age > 23 age > gender > Male gender > qualification > B.Tech qualification > Dept > IT Dept > designation > Developer designation > Employee > Employee > name > MANOJ name > age > 26 age > gender > Male gender > qualification > M.Tech qualification > Dept > IN&S Dept > designation > Sr.Developer designation > Employee > Employee > name > RAJA name > age > 27 age > gender > Male gender > qualification > M.Tech qualification > Dept > SE Dept > designation > ProjectLead designation > Employee > EmployeeDetails > The Above one is My Sample XML Data. Where This XML Data Will be Stored in EmployeeDetails.xml file I'm Retrieving these data in DataTable And Binding it into Gridview from this i need to search particular Row Based on Name XML Tag Names Are Declared as Column name in Datatable

Jayakumar · Answer

So you need to select the particular Row from the DataTable which is loaded from XML not from GridView ? Okay send me your sample XML with two or three records. I will Process it and give you solution.

Rajagopalan R V · Answer

Hi Jaya...... Normal 0 false false false MicrosoftInternetExplorer4 protected void btnNameSearch_Click( object sender EventArgs e) { BindGrid(); DataTable dt = new DataTable (); ds.ReadXml(Server.MapPath( EmployeeDetails.xml )); dt = ds.Tables[0]; dt.Select( name=' + tbxEmployeeSearch.Text + ' ); DataRow [] foundRow = dt.Select( name=' + tbxEmployeeSearch.Text + ' ); } Where name = Column Name for EmployeeName in DataTable tbxEmployeeSearch = Where in this Text Box only I Enter the Name to Search btnNameSearch = ID of the Button Search EmployeeDetails.xml = It Will Store the Details of Employees Like NameAge Salary in Xml Tag This is the Source Used By Me /* Style Definitions */ table.MsoNormalTable{mso-style-name:Table Normal;mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-parent:;mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin:0in;mso-para-margin-bottom:.0001pt;mso-pagination:widow-orphan;font-size:10.0pt;font-family:Times New Roman;mso-ansi-language:#0400;mso-fareast-language:#0400;mso-bidi-language:#0400;} in My Project

Jayakumar · Answer

public void CompareRecordsForMapping(int getUpdateID string getVID string openTypeCode string partnumber) { string expression = string.Empty; try { expression = vechileId=' + getVID + ' and openingTypeCode=' + openTypeCode + ' and NAGSPartNumber=' + partnumber + '; DataRow[] foundRow = dtAllRecords.Select(expression); if (foundRow.Length > 0) DeleteRecord(getUpdateID getVID openTypeCode partnumber); } catch (Exception ex) { throw ex; } } This functions works fine for me in the above code in dtALLRecords DataTable am handling one lakh record to search particular row. I cant get your point in your last post please explain it clearly. and if you can upload your source code.

Rajagopalan R V · Answer

Hi Jaya DataRow[] foundRow = dt.Select(name='+tbxNameSearch.Text+'); It Loading Full grid Like Page Load dt.Select dt is Taking Full Data table Not a Particular Data set...... With Regards..... R.V.Rajagopalan

Jayakumar · Answer

And make sure that in the Select expression your column name is correct as like in DataTable.

Jayakumar · Answer

Hi Raja I think mistake is u missing single quotes next to =. Corrected code is. dt.Select(name='+tbxNameSearch.Text+'); and it will return collection of DataRow like DB so u need to assign it to DataRow array like this. DataRow[] foundRow = dt.Select(name='+tbxNameSearch.Text+'); If any clarification u can contact me as well as if u got solution please let me know.

Rajagopalan R V · Answer

Hi Jaya ..... dt.Select(name= + tbxNameSearch.Text); Error : Cannot find column [xxxx]. is Occurring in the Above Area Please Let Me Know What Mistake I've Done on the Code Given Text Box Value =  xxxx  For Search The Code Placed By Me in Search Button Click Event BindGrid(); DataTable dt = new DataTable(); ds.ReadXml(Server.MapPath(EmployeeDetails.xml)); dt = ds.Tables[0]; dt.Select(name= + tbxNameSearch.Text); With Regards..... R.V.Rajagopalan

Jayakumar · Answer

Hi Raja Yeah there is a solution whenever you click the search button store the GridView DataSource in DataTable as DataTable dt= new DataTable(); dt= GridViewName.DataSource as DataTable; Now you got all values in Gridview included in all pages of gridview. You can query this DataTable based on the value entered in the textBox searchname as dt.Select(Name=+txtSearchName.Text); If you have any doubt in querying the DataTable refer these links. 1. http://msdn.microsoft.com/en-us/library/way3dy9w(v=vs.110).aspx 2. http://msdn.microsoft.com/en-us/library/det4aw50(v=vs.110).aspx 3. http://www.dotnetperls.com/datatable-select 4. http://stackoverflow.com/questions/1990946/datatable-select-with-multiple-conditions The above said method works for me:)

rahul ahuja · Answer

You can Create List of that class type and use LINQ for searching once you click on search button apply LINQ on the list and rebind list to the grid.