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

Rajagopalan R V

Hi ......,

I Had Created Application Without Database . Using Grid View I Can Insert,Update 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

16 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jayakumar Balasubramaniam12y ago
Accepted 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 ???

0
Rajagopalan R V12y ago
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
0
Rajagopalan R V12y ago
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
0
Jayakumar Balasubramaniam12y ago
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++;
}
0
Jayakumar Balasubramaniam12y ago
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 :)

0
Jayakumar Balasubramaniam12y ago
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
0
Rajagopalan R V12y ago
Hi Jaya......,

xml version="1.0" standalone="yes"?>
<EmployeeDetails>
<Employee>
<name>RAJAGOPALANname>
<age>24age>
<gender>Malegender>
<qualification>B.Techqualification>
<Dept>ITDept>
<designation>Developerdesignation>
Employee>
<Employee>
<name>SAIname>
<age>23age>
<gender>Malegender>
<qualification>B.Techqualification>
<Dept>ITDept>
<designation>Developerdesignation>
Employee>
<Employee>
<name>MANOJname>
<age>26age>
<gender>Malegender>
<qualification>M.Techqualification>
<Dept>IN&SDept>
<designation>Sr.Developerdesignation>
Employee>
<Employee>
<name>RAJAname>
<age>27age>
<gender>Malegender>
<qualification>M.Techqualification>
<Dept>SEDept>
<designation>ProjectLeaddesignation>
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
0
Jayakumar Balasubramaniam12y ago
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.
0
Rajagopalan R V12y ago
Hi Jaya......,

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 Name,Age Salary in Xml Tag"
This is the Source Used By Me in My Project
0
Jayakumar Balasubramaniam12y ago
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.

0
Rajagopalan R V12y ago
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
0
Jayakumar Balasubramaniam12y ago
And make sure that in the Select expression your column name is correct as like in DataTable.
0
Jayakumar Balasubramaniam12y ago
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.
0
Rajagopalan R V12y ago
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
0
Jayakumar Balasubramaniam12y ago
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:)

0
rahul ahuja12y ago
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.
0