Exclereport by anil kumar aggarwal

using System;using System.Data;using System.Configuration;using System.Linq;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;///
/// <summary> Summary description for Exclereport/// </summary>public class Exclereport{

{
public Exclereport()//// TODO: Add constructor logic here//}

{





{

}

{


}


{



{

}

{


}

}

{


{

}

}


ds.Clear();


}

{





public void Excelreport(DataSet ds)HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment; filename=Report.xls");HttpContext.Current.Response.ContentType = "application/ms-excel";HttpContext.Current.Response.Write("<table border='1px'>");HttpContext.Current.Response.Write("<tr>");for (int i = 0; i < ds.Tables[0].Columns.Count; i++)HttpContext.Current.Response.Write("<td align='center' style='font-family: Calibri; font-size: 18px; font-weight: bold; color: #FFFFFF; background-color: #006699' >" + ds.Tables[0].Columns[i].ColumnName + "</td>");for (int i = 0; i < 100; i++)HttpContext.Current.Response.Write("<td></td>");HttpContext.Current.Response.Write("</tr>");for (int i = 0; i < ds.Tables[0].Rows.Count; i++)HttpContext.Current.Response.Write("<tr>");DataRow row = ds.Tables[0].Rows[i];for (int j = 0; j < ds.Tables[0].Columns.Count; j++)HttpContext.Current.Response.Write("<td align='left' >" + row[j] + "</td>");for (int k = 0; k < 100; k++)HttpContext.Current.Response.Write("<td></td>");HttpContext.Current.Response.Write("</tr>");for (int i = 0; i < 50; i++)HttpContext.Current.Response.Write("<tr>");for (int j = 0; j < 105; j++)HttpContext.Current.Response.Write("<td></td>");HttpContext.Current.Response.Write("</tr>");HttpContext.Current.Response.Write("</table>");HttpContext.Current.Response.End();public void ExcelreportHrTraining(DataSet ds)HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment; filename=Report.xls");HttpContext.Current.Response.ContentType = "application/ms-excel";HttpContext.Current.Response.Write("<table border='1px'>");HttpContext.Current.Response.Write("<tr>");//HttpContext.Current.Response.Write("<td align='center' colspan=" + ds.Tables[0].Columns.Count+1 + " style='font-family: Calibri; font-size: 18px; font-weight: bold; color: Black ;background-color: #808080; border: 0px none #808080' >For the Period : January '11 to December '11 <br/>CDP</td>");


{


}




HttpContext.Current.Response.Write("<td align='center' colspan='15' style='font-family: Calibri; font-size: 18px; font-weight: bold; color: Black ;background-color: #808080; border: 0px none #808080' >For the Period : January '11 to December '11 <br/>CDP</td>");for (int i = 0; i < 100; i++)HttpContext.Current.Response.Write("<td></td>");HttpContext.Current.Response.Write("</tr>");HttpContext.Current.Response.Write("<tr>");//for (int i = 0; i < ds.Tables[0].Columns.Count; i++)//{// HttpContext.Current.Response.Write("<td align='center' valign='top' style='font-family: Calibri; font-size: 11px; ; color: #FFFFFF; background-color: #003366' >" + ds.Tables[0].Columns[i].ColumnName + "</td>");





HttpContext.Current.Response.Write("<td align='center' valign='top' style='font-family: Calibri; font-size: 13px; width:80px;font-weight: bold; color: #FFFFFF; background-color: #003366' >Month</td>");HttpContext.Current.Response.Write("<td align='center' valign='top' style='font-family: Calibri; font-size: 13px; width:80px; font-weight: bold;color: #FFFFFF; background-color: #003366' >No of Trainings</td>");HttpContext.Current.Response.Write("<td align='center' valign='top' style='font-family: Calibri; font-size: 13px; width:80px;font-weight: bold; color: #FFFFFF; background-color: #003366' >Planned Participants</td>");HttpContext.Current.Response.Write("<td align='center' valign='top' style='font-family: Calibri; font-size: 13px; width:80px;font-weight: bold; color: #FFFFFF; background-color: #003366' >Actual Participants</td>");HttpContext.Current.Response.Write("<td align='center' valign='top' style='font-family: Calibri; font-size: 13px; width:80px;font-weight: bold; color: #FFFFFF; background-color: #003366' >Training Absenteeism</td>");HttpContext.Current.Response.Write("<td align='center' valign='top' style='font-family: Calibri; font-size: 13px; width:80px;font-weight: bold; color: #FFFFFF; background-color: #003366' >Total Training Person Days (B*C)</td>");//HttpContext.Current.Response.Write("<td align='center' valign='top' style='font-family: Calibri; font-size: 13px; width:80px;font-weight: bold; color: #FFFFFF; background-color: #003366' >Emp. Strength Month Beginning</td>");//HttpContext.Current.Response.Write("<td align='center' valign='top' style='font-family: Calibri; font-size: 13px; width:80px;font-weight: bold; color: #FFFFFF; background-color: #003366' >Emp. Strength Month End</td>");//HttpContext.Current.Response.Write("<td align='center' valign='top' style='font-family: Calibri; font-size: 13px; width:80px;font-weight: bold; color: #FFFFFF; background-color: #003366' >Avg Emp Strength</td>");//HttpContext.Current.Response.Write("<td align='center' valign='top' style='font-family: Calibri; font-size: 13px; width:80px;font-weight: bold; color: #FFFFFF; background-color: #003366' >Per Person Training Days</td>");
HttpContext.Current.Response.Write("<td align='center' valign='top' style='font-family: Calibri; font-size: 13px; width:80px;font-weight: bold; color: #FFFFFF; background-color: #003366' >Total Training Expenses</td>");//HttpContext.Current.Response.Write("<td align='center' valign='top' style='font-family: Calibri; font-size: 13px; width:80px;font-weight: bold; color: #FFFFFF; background-color: #003366' >Training Cost per Employee</td>");




HttpContext.Current.Response.Write("<td align='center' valign='top' style='font-family: Calibri; font-size: 13px; width:80px;font-weight: bold; color: #FFFFFF; background-color: #003366' >Training Program Score</td>");HttpContext.Current.Response.Write("<td align='center' valign='top' style='font-family: Calibri; font-size: 13px; width:80px;font-weight: bold; color: #FFFFFF; background-color: #003366' >Trainer Score</td>");HttpContext.Current.Response.Write("<td align='center' valign='top' style='font-family: Calibri; font-size: 13px; width:80px;font-weight: bold; color: #FFFFFF; background-color: #003366' >Overall Feedback Score</td>");//}
{


}


{





{


}

{


}

}

{


{

}

}


ds.Clear();


}

{
System.IO.
System.Web.UI.


dgGrid.DataSource = dsExport;
for (int i = 0; i < 100; i++)HttpContext.Current.Response.Write("<td></td>");HttpContext.Current.Response.Write("</tr>");for (int i = 0; i < ds.Tables[0].Rows.Count; i++)HttpContext.Current.Response.Write("<tr>");DataRow row = ds.Tables[0].Rows[i];for (int j = 0; j < ds.Tables[0].Columns.Count-1; j++)HttpContext.Current.Response.Write("<td align='left' >" + row[j+1] + "</td>");for (int k = 0; k < 100; k++)HttpContext.Current.Response.Write("<td></td>");HttpContext.Current.Response.Write("</tr>");for (int i = 0; i < 50; i++)HttpContext.Current.Response.Write("<tr>");for (int j = 0; j < 105; j++)HttpContext.Current.Response.Write("<td></td>");HttpContext.Current.Response.Write("</tr>");HttpContext.Current.Response.Write("</table>");HttpContext.Current.Response.End();public void exlRet(DataSet dsExport)StringWriter tw = new System.IO.StringWriter();HtmlTextWriter hw =new System.Web.UI.HtmlTextWriter(tw);DataGrid dgGrid = new DataGrid();//Report Header//hw.WriteLine("<b><u><font size='5'>" + // "Report for the Fiscal year: " + txtFY.Text + // "</font></u></b>");// hw.WriteLine("<br>&mp;nbsp;");// Get the HTML for the control.dgGrid.HeaderStyle.Font.Bold =
dgGrid.DataBind();
dgGrid.RenderControl(hw);
true;// Write the HTML back to the browser.

HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment; filename=Report.xls");HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";// this.EnableViewState = false;

}
}HttpContext.Current.Response.Write(tw.ToString());HttpContext.Current.Response.End();

.cs class for transaction sql by anil kumar aggarwal (soft. dov.)

using System;using System.Data;using System.Configuration;using System.Linq;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;using System.Data.SqlClient;using System.IO;using System.Net.Mail;using System.Diagnostics;using System.Net;///
/// <summary> Summary description for clsConnection/// </summary>public class clsConnection{

{
public clsConnection()//// TODO: Add constructor logic here//}






{
SqlConnection con = new SqlConnection();SqlCommand com = new SqlCommand();SqlDataAdapter da = new SqlDataAdapter();string constr = "Data Source=150.236.12.34;Initial Catalog=PMS; User Id=pms;Password=smp;";MailMessage mail;public static string connectget{

}
}

{


{
con.ConnectionString = constr;
con.Open();
}
com.CommandText = str;
com.Connection = con;
da.SelectCommand = com;
da.Fill(ds);
con.Close();

}







{


{
con.ConnectionString = constr;
con.Open();
}
com.CommandText = str;
com.Connection = con;
da.SelectCommand = com;
s1 =
con.Close();

}

{

{
con.ConnectionString = constr;
con.Open();
}
com.CommandText = str;
com.Connection = con;
da.SelectCommand = com;
com.ExecuteNonQuery();
con.Close();
}

{
return "Data Source=150.236.12.34;Initial Catalog=PMS; User Id=pms;Password=smp;";public DataSet selectds(string str)DataSet ds = new DataSet();if (con.State == ConnectionState.Closed)return ds;public string SelectScalar(string str)string s1;if (con.State == ConnectionState.Closed)Convert.ToString(com.ExecuteScalar());return s1;public void ExecuteQuery(string str)if (con.State == ConnectionState.Closed)public void fillRadioButtonList(String query, RadioButtonList objDDL, String colfield, String valField)try{

{
con.ConnectionString = constr;
con.Open();
}

objDDL.Items.Clear();
da =
da.Fill(ds);

objDDL.DataSource = ds.Tables[0];
objDDL.DataTextField = colfield;
objDDL.DataValueField = valField;
objDDL.DataBind();
}

}

{
if (con.State == ConnectionState.Closed)DataSet ds = new DataSet();new SqlDataAdapter(query, con);catch { }public void FillDropdownListwithvalue(String query, DropDownList objDDL, String colfield, String valField)try{

{ con.ConnectionString = constr; con.Open(); }

objDDL.Items.Clear();
da =
da.Fill(ds);


NewRow[colfield] =
newtbl = ds.Tables[0];
newtbl.Rows.InsertAt(NewRow, 0);
newtbl.AcceptChanges();
newtbl = newtbl.Copy();
objDDL.DataSource = ds.Tables[0];
objDDL.DataTextField = colfield;
objDDL.DataValueField = valField;
objDDL.DataBind();
}

}

{

{
con.ConnectionString = constr;
con.Open();
}



}
}if (con.State == ConnectionState.Closed)DataSet ds = new DataSet();new SqlDataAdapter(query, con);DataTable newtbl = new DataTable();DataRow NewRow = ds.Tables[0].NewRow();"-Please Select-";catch { }public int getmaxid(string str)if (con.State == ConnectionState.Closed)SqlCommand commm = new SqlCommand(str, con);int maxid = Convert.ToInt32(commm.ExecuteScalar()) + 1;return maxid;

create reminder in c# (anil kumar software doveloper alwar rajasthan)

File
>globle
<%@ Application Language="C#" %><script RunAt="server">
{
System.Timers.
void Application_Start(object sender, EventArgs e)Timer myTimer = new System.Timers.Timer();// Set the Interval to 5 seconds (5000 milliseconds).myTimer.Interval = 36000000;
myTimer.AutoReset =
myTimer.Elapsed +=
myTimer.Enabled =
}

{

bjcls.Reminder();
}true;new System.Timers.ElapsedEventHandler(myTimer_Elapsed);true;public void myTimer_Elapsed(object source, System.Timers.ElapsedEventArgs e)clsConnection objcls = new clsConnection();</
app code .cs
public
{


{



{
con.ConnectionString = constr;
con.Open();
}


com.CommandText = str;
com.Connection = con;
da.SelectCommand = com;
da.Fill(ds);
con.Close();


{



{
con.ConnectionString = constr;
con.Open();
}

com.CommandText = str2;
com.Connection = con;
da.SelectCommand = com;
s1 =
con.Close();
mailsend1(s1);

{
con.ConnectionString = constr;
con.Open();
}


com.CommandText = str22;
com.Connection = con;
da.SelectCommand = com;
da.Fill(ds2);
con.Close();

{


{ con.ConnectionString = constr; con.Open(); }

com.CommandText = str222;
com.Connection = con;
da.SelectCommand = com;
s12 =
con.Close();
mailsend1(s12);
}
}
}
}


{
mail =
mail.From =
mail.To.Add(
mail.Subject =
mail.Body =

smtpMail.Port = 25;
smtpMail.Host =
smtpMail.Send(mail);
} void Reminder()string d = System.DateTime.Now.Hour.ToString();if (d == "14")string s1;string s12;if (con.State == ConnectionState.Closed)DataSet ds = new DataSet();string str = "SELECT * FROM RAIL_ACTION_DETAIL where REMINDER_DATE='" + System.DateTime.Now.ToString("MM/dd/yyyy") + "'";int i;for (i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)String m = ds.Tables[0].Rows[i].ItemArray[0].ToString();String m1 = ds.Tables[0].Rows[i].ItemArray[3].ToString();if (con.State == ConnectionState.Closed)string str2 = "SELECT e.mail_id FROM RAIL_ACTION_MST as m left outer join hr_emp_mst as e on e.signm_id=m.ASSIGNER_SIGNUM where ACTION_ID='" + m + "'";Convert.ToString(com.ExecuteScalar());if (con.State == ConnectionState.Closed)DataSet ds2 = new DataSet();string str22 = "SELECT * FROM RAIL_SUPPORT_TEAM where ACTION_ID='" + m + "'";for (i = 0; i <= ds2.Tables[0].Rows.Count - 1; i++)String m12 = ds2.Tables[0].Rows[i].ItemArray[2].ToString();if (con.State == ConnectionState.Closed)string str222 = "SELECT mail_id from hr_emp_mst where signm_id='" + m12 + "'";Convert.ToString(com.ExecuteScalar());public void mailsend1(string tomailid)new MailMessage();new MailAddress("anil.j.kumar@ericsson.com ");new MailAddress(tomailid));" PEMINDER FOR ROAILING ACTION ITEM LIST";"Message";SmtpClient smtpMail = new SmtpClient();"hostname";script>

Advance Search using dynamic colume and dynamic parameters

.aspx page :
<asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
            </asp:ToolkitScriptManager>
            <fieldset>
                <legend>***Advance Search***</legend>
                <fieldset>
                    <legend>****Select field****</legend>
                    <asp:CheckBoxList ID="CheckBoxList1" runat="server"  ForeColor="Black"
                        BackColor="White" BorderColor="Orange" BorderWidth="2" BorderStyle="Double" RepeatColumns="3"
                        Width="900">
                        <asp:ListItem Value="Ticket_No" Text="TICKET NO."></asp:ListItem>
                        <asp:ListItem Value="USER_NAME" Text="USER_NAME"></asp:ListItem>
                        <asp:ListItem Value="ISSUE_LOG_DATE_TIME" Text="ISSUE RAISE DATE TIME"></asp:ListItem>
                        <asp:ListItem Value="Issue_Title" Text="ISSUE TITLE "></asp:ListItem>
                        <asp:ListItem Value="Issue_Detail" Text="ISSUE DETAIL"></asp:ListItem>
                        <asp:ListItem Value="Issue_Type" Text="ISSUE TYPE"></asp:ListItem>
                        <asp:ListItem Value="EXPRESS_REMARKS" Text="EXPRESS REMARKS"></asp:ListItem>
                        <asp:ListItem Value="Issue_Resource" Text="ISSUE RESOURCE"></asp:ListItem>
                        <asp:ListItem Value="ALLOCATION_DATE_TIME" Text="ALLOCATION DATE TIME "></asp:ListItem>
                        <asp:ListItem Value="APPLICATION_TYPE" Text="APPLICATION TYPE"></asp:ListItem>
                        <asp:ListItem Value="APPLICATION" Text="ALLPICATION"></asp:ListItem>
                        <asp:ListItem Value="RESOURCE_ACCEPT" Text="ACCEPT BY RESOURCE"></asp:ListItem>
                        <asp:ListItem Value="RESOURCE_ACCEPT_DATE_TIME" Text="RESOURCE ACCEPT DATETIME"></asp:ListItem>
                        <asp:ListItem Value="ACTION" Text="ACTION"></asp:ListItem>
                        <asp:ListItem Value="ACTION_DETAL" Text="ACTION DETAIL"></asp:ListItem>
                        <asp:ListItem Value="RESOURCE_CLOSE_ISSUE_DATETIME" Text="RESOURCE CLOSE DATE TIME"></asp:ListItem>
                        <asp:ListItem Value="RESOURCE_ALLOCATOR" Text="RESOURCE ALLOCATOR"></asp:ListItem>
                        <asp:ListItem Value="USER_CLOSE_ISSUE_DATE_TIEM" Text="ISSUE CLOSE BY USER DATE TIME "></asp:ListItem>
                        <asp:ListItem Value="STATUS" Text="STATUS"></asp:ListItem>
                    </asp:CheckBoxList>
                </fieldset>
                <fieldset>
                    <legend>***Select Perameters</legend>
                    <table width="100%">
                        <tr>
                            <td>
                                ISSUE RAISE BY USER
                            </td>
                            <td>
                                FROM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :&nbsp
                                <asp:TextBox ID="txtFromDate" runat="server"></asp:TextBox>
                                <asp:CalendarExtender ID="CalendarExtender1" runat="server" TargetControlID="txtFromDate">
                                </asp:CalendarExtender>
                                &nbsp&nbsp;&nbsp;&nbsp;&nbsp; TO&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                                &nbsp:&nbsp&nbsp;&nbsp;
                                <asp:TextBox ID="txtTodate" runat="server"></asp:TextBox>
                                <asp:CalendarExtender ID="CalendarExtender2" runat="server" TargetControlID="txtTodate">
                                </asp:CalendarExtender>
                            </td>
                        </tr>
                        <tr>
                            <td>
                                ISSUE CLOSE BY RESOURCE
                            </td>
                            <td>
                                FROM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :&nbsp
                                <asp:TextBox ID="txtICBRF" runat="server"></asp:TextBox>
                                <asp:CalendarExtender ID="CalendarExtender3" runat="server" TargetControlID="txtICBRF">
                                </asp:CalendarExtender>
                                &nbsp&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TO&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                                &nbsp:&nbsp&nbsp;&nbsp;
                                <asp:TextBox ID="txtICBRT" runat="server"></asp:TextBox>
                                <asp:CalendarExtender ID="CalendarExtender4" runat="server" TargetControlID="txtICBRT">
                                </asp:CalendarExtender>
                            </td>
                        </tr>
                        <tr>
                            <td>
                                ISSUE CLOSE BY USER
                            </td>
                            <td>
                                FROM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; :&nbsp
                                <asp:TextBox ID="txtICBUF" runat="server"></asp:TextBox>
                                <asp:CalendarExtender ID="CalendarExtender5" runat="server" TargetControlID="txtICBUF">
                                </asp:CalendarExtender>
                                &nbsp&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TO&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                                &nbsp: &nbsp&nbsp;
                                <asp:TextBox ID="txtICBUT" runat="server"></asp:TextBox>
                                <asp:CalendarExtender ID="CalendarExtender6" runat="server" TargetControlID="txtICBUT">
                                </asp:CalendarExtender>
                            </td>
                        </tr>
                        <tr>
                            <td>
                                <br />
                            </td>
                        </tr>
                        <tr>
                            <td>
                                APPLICATION TYPE WISE
                            </td>
                            <td>
                                &nbsp;<asp:DropDownList ID="DDLAPPTYPE2" runat="server" Width="168px" Height="35px">
                                </asp:DropDownList>
                                &nbsp;&nbsp;&nbsp; &nbsp;
                            </td>
                        </tr>
                        <tr>
                            <td>
                                APPLICATION WISE
                            </td>
                            <td>
                                <asp:DropDownList ID="ddlApp" runat="server" Width="169px" Height="35px">
                                </asp:DropDownList>
                            </td>
                        </tr>
                        <tr>
                            <td>
                                RESOURCE WISE
                            </td>
                            <td>
                                <asp:DropDownList ID="DDLRES" runat="server" Width="171px" Height="35px">
                                </asp:DropDownList>
                            </td>
                        </tr>
                    </table>
                    <br />
                    <center>
                        <asp:Button ID="btnShow" runat="server" Text="Show" OnClick="btnShow_Click" /></center>
                </fieldset>
            </fieldset>
        </div>

.cs page:



    protected void btnShow_Click(object sender, EventArgs e)
    {
        string name = "";
        string str = "select  ";

        foreach (ListItem li in CheckBoxList1.Items)
        {
            if (li.Selected == true)
            {
                name = li.Value.ToString();
                str = str + name + ",";
            }
        }

        str = str.Substring(0, str.Length - 1);
        str = str + "" + " from showissuelog  where ";

        string[] filld = new string[6];
        string[] oper = new string[6];
        string[] val = new string[6];
        int k = 0;


        if (txtFromDate.Text != "" && txtTodate.Text != "")
        {
            filld[k] = "ISSUE_LOG_DATE_TIME";
            oper[k] = " between "; ;
            val[k] = "'" + txtFromDate.Text + "' and '" + txtTodate.Text + "'";
            k++;
        }

        if (txtICBRF.Text != "" && txtICBRT.Text != "")
        {
            filld[k] = "RESOURCE_CLOSE_ISSUE_DATETIME";
            oper[k] = " between "; ;
            val[k] = "'" + txtICBRF.Text + "' and '" + txtICBRT.Text + "'";
            k++;
        }


        if (txtICBUF.Text != "" && txtICBUT.Text != "")
        {
            filld[k] = "USER_CLOSE_ISSUE_DATE_TIEM";
            oper[k] = " between "; ;
            val[k] = "'" + txtICBUF.Text + "' and '" + txtICBUT.Text + "'";
            k++;
        }

        if (DDLAPPTYPE2.SelectedIndex > 0)
        {
            filld[k] = "Application_Type_Id";
            oper[k] = " = "; ;
            val[k] = "'" + DDLAPPTYPE2.SelectedValue + "' ";
            k++;
        }
        if (ddlApp.SelectedIndex > 0)
        {
            filld[k] = "Application_id";
            oper[k] = " = "; ;
            val[k] = "'" + ddlApp.SelectedValue + "' ";
            k++;
        }

        if (DDLRES.SelectedIndex > 0)
        {
            filld[k] = "Issue_Resource";
            oper[k] = " = "; ;
            val[k] = "'" + DDLRES.SelectedValue + "' ";
            k++;
        }
        for (int i = 0; i < k; i++)
        {
            str = str + filld[i] + oper[i] + val[i] + " and ";
        }


        str = str.Substring(0, str.Length - 4);
        ds = new DataSet();
        ds = objcls.selectds(str);
        ER.exlRet(ds);
    }