））//检查行是否包含'_xlnm＃_FilterDatabase'或工作表名称（即工作表名称始终以

符号）结束< br />
if（（drSheet [TABLE_NAME]。ToString（））==（（RedBus

）||（ GreenBus

Hi,

I am using the following code to check table names from database using GetOleDbSchemaTable

 DataTable dtSheet = connection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);<br />
<br />
                foreach (DataRow drSheet in dtSheet.Rows)<br />
                {<br />
                    //if (drSheet["TABLE_NAME"].ToString().Contains("$"))//checks whether row contains '_xlnm#_FilterDatabase' or sheet name(i.e. sheet name always ends with $ sign)<br />
                    if ((drSheet["TABLE_NAME"].ToString())==(("RedBus$")||("GreenBus$")||("YellowBus$")))<br />
                    {<br />
                        listSheetNames.Add(drSheet["TABLE_NAME"].ToString());<br />
                    }<br />
                }

But I am getting error like I cannot use OR symbol("RedBus$")||("GreenBus$") in between strings.

Can anyone suggest me how can I solve this problem??+

Thanks
John

"))//checks whether row contains '_xlnm#_FilterDatabase' or sheet name(i.e. sheet name always ends with

sign)<br /> if ((drSheet["TABLE_NAME"].ToString())==(("RedBus

")||("GreenBus