ASP.NET

Imran Khan Pathan wrote:

Can any guide me how to filter more than one tables using sql query if data tables are created dynamically?

Imran Khan Pathan wrote:

Now I want to filter all tables and want to get match records with the ServiceMethod.

N a v a n e e t h wrote:

You can use Select() method in the DataTable instance to select rows matching to the specified criteria.

private int MergeCount = 0;
    private void DistributeServices(DataSet dsServiceRates)
    {
        DataTable dtFinal = new DataTable();
        int CountTables = dsServiceRates.Tables.Count;
        if (CountTables > 1)
        {
            for (int i = 0; i < CountTables; i++)
            {
                if (MergeCount == 0)
                {
                    dtFinal = MergeService(dsServiceRates.Tables[i], dsServiceRates.Tables[i + 1]);
                    i++;
                }
                else
                {
                    dtFinal = MergeService(dsServiceRates.Tables[i], dtFinal);
                }
            }
            if (dtFinal.Rows.Count != 0)
            {
                //Bind DropDownList with dtFinal Table
            }
            else
            {
                //No Bind Method
            }
            
        }
        else if (CountTables != 0)
        {
            //Bind DrowDownList here with Tables 0
        }
        else
        {
           //No Bind Method
        }
    }
    
    private DataTable MergeService(DataTable dTable1, DataTable dTable2)
    {
        DataTable dtNew = new DataTable();
        dtNew.Columns.Add("Method",System.Type.GetType("System.String"));
        dtNew.Columns.Add("Rate", System.Type.GetType("System.String"));
        
        foreach (DataRow dRow1 in dTable1.Rows)
        {
            foreach (DataRow dRow2 in dTable2.Rows)
            {
                if (dRow1["Method"].ToString() == dRow2["Method"].ToString())
                {
                    MergeCount = 1;
                    AddRows(dtNew, dRow1["Method"].ToString(), decimal.Parse(dRow1["Rate"].ToString()) + decimal.Parse(dRow2["Rate"].ToString()));
                     // Add Rows Method used to add Rows
                    
                }
            }
        }
        return dtNew;
     }

Dot Net rookie wrote:

Hi, I have a website build in ASP.Net 2.0. I also have a ftp site to test the website.