How to use DataView RowFilter Syntax [C#]

Question

0.00/5 (No votes)

See more:

How to use DataView RowFilter Syntax [C#]with space tag Ex: i want to filter using RowFilter Year="1427" but its showing me error (Error !Cannot find column Year ).
i discover why this message is showing because Year column has some space...

DataView dv = myDs.Tables[0].DefaultView;
dv.RowFilter = "Year=1427";
gv.DataSource = dv;
gv.DataBind();

Posted 9-Jan-13 23:27pm

Member 8194711

Add a Solution

Comments

Shanu2rick 10-Jan-13 5:31am

And Your Problem is...?

[no name] 10-Jan-13 5:32am

please check in your dataset what are the column names are available

Member 8194711 10-Jan-13 5:33am

I can't Find the Year column its show me Error how can i find column its has space how can i avoid that space

Shanu2rick 10-Jan-13 5:37am

Where is this space exactly in your Column 'Year'?

Member 8194711 10-Jan-13 5:56am

Sir i dont know actually so there is any way to avoid the space

[no name] 10-Jan-13 5:38am

in your dataset there is no column with the name "year" then how can you filter based on year.please be concentrate on dataset first ,and then filter .

Member 8194711 10-Jan-13 5:40am

i have column called year when i convert my dataset to xml my year column its show like this <year_x0020_> <year_x0020_>

[no name] 10-Jan-13 5:41am

show me your code once

Member 8194711 10-Jan-13 5:50am

System.Data.DataTable db = GetExcelData(path, oSheet.Name);

protected System.Data.DataTable GetExcelData(string ExcelFilePath, string sheetName)
{

string OledbConnectionString = string.Empty;
OleDbConnection objConn = null;
OledbConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + ExcelFilePath + ";Extended Properties=Excel 8.0;";
objConn = new OleDbConnection(OledbConnectionString);

if (objConn.State == ConnectionState.Closed)
{
objConn.Open();
}

OleDbCommand objCmdSelect = new OleDbCommand("Select * from [" + sheetName + "$]", objConn);
OleDbDataAdapter objAdapter = new OleDbDataAdapter();
objAdapter.SelectCommand = objCmdSelect;
DataSet objDataset = new DataSet();
objAdapter.Fill(objDataset, "ExcelDataTable");
objConn.Close();
return objDataset.Tables[0];
}

DataView dv = myDs.Tables[0].DefaultView;
foreach (DataColumn item in db.Columns)
{
string sss = db.Rows[0][item.ToString()].ToString();
columnNames.Add(item.ColumnName);
if (item.ColumnName.Trim() == "Year")
{

dv.RowFilter = "Year=1425";
gv.DataSource = dv;
gv.DataBind();
}
}

[no name] 10-Jan-13 6:03am

please put a break point in GetExcelData method and check the data properly in this code your doing you fetch information from excel sheet itself i think the problem is
1) there is no column like year
2) spaces
3) spell ...etc..
once put a break point and check in which line its showing error

Shanu2rick 10-Jan-13 5:42am

Yeah, Me too

Member 8194711 10-Jan-13 5:55am

System.Data.DataTable db = GetExcelData(path, oSheet.Name);

protected System.Data.DataTable GetExcelData(string ExcelFilePath, string sheetName)
{

string OledbConnectionString = string.Empty;
OleDbConnection objConn = null;
OledbConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + ExcelFilePath + ";Extended Properties=Excel 8.0;";
objConn = new OleDbConnection(OledbConnectionString);

if (objConn.State == ConnectionState.Closed)
{
objConn.Open();
}

OleDbCommand objCmdSelect = new OleDbCommand("Select * from [" + sheetName + "$]", objConn);
OleDbDataAdapter objAdapter = new OleDbDataAdapter();
objAdapter.SelectCommand = objCmdSelect;
DataSet objDataset = new DataSet();
objAdapter.Fill(objDataset, "ExcelDataTable");
objConn.Close();
return objDataset.Tables[0];
}

DataView dv = myDs.Tables[0].DefaultView;
foreach (DataColumn item in db.Columns)
{
string sss = db.Rows[0][item.ToString()].ToString();
columnNames.Add(item.ColumnName);
if (item.ColumnName.Trim() == "Year")
{

dv.RowFilter = "Year=1425";
gv.DataSource = dv;
gv.DataBind();
}
}

Shanu2rick 10-Jan-13 6:10am

Your Code looks fine.
Review your ExcelSheet, especially the column 'Year'.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

pranathis012 · Answer 1 · 2013-01-09T23:36:00

Solution 1

Hi,

please be check in your Dataset having the column name "year" or not.

Please be check it once. If the column name is avilable in your dataset then please be check the spell and caps letters also..

Posted 9-Jan-13 23:36pm

pranathis012

Updated 9-Jan-13 23:39pm

v2

Comments

Member 8194711 10-Jan-13 5:42am

yah i have column it called year but it has some space when i convert dataset to xml the year column its show like this <year_x0020_><year_x0020_>