sadegh24
سه شنبه 27 بهمن 1394, 05:28 صبح
من یه صفحه سرچ دارم بر اساس چند تا پارامتر اگه ممکنه کمک کنید کجاش ایراد داره
using (SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationMa nager.
ConnectionStrings["ZagmaDBConnectionString2"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
string sql = "select CName نام, mobile موبایل,state وضعیت,CEmail ایمیل from TBLCustomers WHERE (CName LIKE '%' + @CName + '%') AND (mobile LIKE @mobile + '%') AND (State LIKE @State + '%') AND(CID BETWEEN @C1 AND @C2) ";
conn.Open();
cmd.CommandText = sql;
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@CName", txtName.Text);
cmd.Parameters.AddWithValue("@mobile", txtmobile.Text);
cmd.Parameters.AddWithValue("@State ", chstate.SelectedValue);
cmd.Parameters.AddWithValue("@C1 ", i1);
cmd.Parameters.AddWithValue("@C2 ", i2);
using (SqlDataReader sdr = cmd.ExecuteReader())
{
while (sdr.Read())
{
DataTable dt = new DataTable();
dt.Load(sdr);
repaeter.DataSource = dt;
repaeter.DataBind();
repaeter.Visible = true;
}
}
<asp:Repeater ID="cdcatalog" runat="server">
<HeaderTemplate>
<table style="width: 100%" dir="rtl">
<tr style="width: 100%; background-color: lightgrey;">
<%--<td style="width: 3%; height: 30px; vertical-align: central" align="center">
<asp:CheckBox ID="CheckBox2" runat="server" />
</td>--%>
<td style="width: 15%;" align="center">
<label>نام مشتری </label>
</td>
<td style="width: 20%; vertical-align: middle;" align="center">
<label>موبایل</label>
</td>
<td style="width: 10%;" align="center">
<label>ایمیل </label>
</td>
<td style="width: 10%;" align="center">
<label>وضعیت </label>
</td>
</tr>
</table>
</HeaderTemplate>
<ItemTemplate>
<table style="width: 100%" dir="rtl">
<tr style="width: 100%">
<%--<td style="width: 3%; height: 100px; vertical-align: central" align="center">
<asp:CheckBox ID="CheckBox1" runat="server" />
</td>--%>
<td style="width: 15%;" align="center">
<%# DataBinder.Eval(Container.DataItem, "CName") %>
</td>
<td style="width: 20%; vertical-align: middle;" align="center">
<%# DataBinder.Eval(Container.DataItem, "mobile") %>
</td>
<td style="width: 10%;" align="center">
<%# DataBinder.Eval(Container.DataItem, "cemail") %>
</td>
<td style="width: 10%;" align="center">
<%# DataBinder.Eval(Container.DataItem, "state") %>
</td>
</tr>
</table>
</ItemTemplate>
<AlternatingItemTemplate>
<table style="width: 100%" dir="rtl">
<tr style="width: 100%; background-color: powderblue">
<%--<td style="width: 3%; height: 100px; vertical-align: central" align="center">
<asp:CheckBox ID="CheckBox1" runat="server" />
</td>--%>
<td style="width: 15%;" align="center">
<%# DataBinder.Eval(Container.DataItem, "cName") %>
</td>
<td style="width: 20%; vertical-align: middle;" align="center">
<%# DataBinder.Eval(Container.DataItem, "mobile") %>
</td>
<td style="width: 10%;" align="center">
<%# DataBinder.Eval(Container.DataItem, "cemail") %>
</td>
<td style="width: 10%;" align="center">
<%# DataBinder.Eval(Container.DataItem, "state") %>
</td>
</tr>
</table>
</AlternatingItemTemplate>
</asp:Repeater>
using (SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationMa nager.
ConnectionStrings["ZagmaDBConnectionString2"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
string sql = "select CName نام, mobile موبایل,state وضعیت,CEmail ایمیل from TBLCustomers WHERE (CName LIKE '%' + @CName + '%') AND (mobile LIKE @mobile + '%') AND (State LIKE @State + '%') AND(CID BETWEEN @C1 AND @C2) ";
conn.Open();
cmd.CommandText = sql;
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@CName", txtName.Text);
cmd.Parameters.AddWithValue("@mobile", txtmobile.Text);
cmd.Parameters.AddWithValue("@State ", chstate.SelectedValue);
cmd.Parameters.AddWithValue("@C1 ", i1);
cmd.Parameters.AddWithValue("@C2 ", i2);
using (SqlDataReader sdr = cmd.ExecuteReader())
{
while (sdr.Read())
{
DataTable dt = new DataTable();
dt.Load(sdr);
repaeter.DataSource = dt;
repaeter.DataBind();
repaeter.Visible = true;
}
}
<asp:Repeater ID="cdcatalog" runat="server">
<HeaderTemplate>
<table style="width: 100%" dir="rtl">
<tr style="width: 100%; background-color: lightgrey;">
<%--<td style="width: 3%; height: 30px; vertical-align: central" align="center">
<asp:CheckBox ID="CheckBox2" runat="server" />
</td>--%>
<td style="width: 15%;" align="center">
<label>نام مشتری </label>
</td>
<td style="width: 20%; vertical-align: middle;" align="center">
<label>موبایل</label>
</td>
<td style="width: 10%;" align="center">
<label>ایمیل </label>
</td>
<td style="width: 10%;" align="center">
<label>وضعیت </label>
</td>
</tr>
</table>
</HeaderTemplate>
<ItemTemplate>
<table style="width: 100%" dir="rtl">
<tr style="width: 100%">
<%--<td style="width: 3%; height: 100px; vertical-align: central" align="center">
<asp:CheckBox ID="CheckBox1" runat="server" />
</td>--%>
<td style="width: 15%;" align="center">
<%# DataBinder.Eval(Container.DataItem, "CName") %>
</td>
<td style="width: 20%; vertical-align: middle;" align="center">
<%# DataBinder.Eval(Container.DataItem, "mobile") %>
</td>
<td style="width: 10%;" align="center">
<%# DataBinder.Eval(Container.DataItem, "cemail") %>
</td>
<td style="width: 10%;" align="center">
<%# DataBinder.Eval(Container.DataItem, "state") %>
</td>
</tr>
</table>
</ItemTemplate>
<AlternatingItemTemplate>
<table style="width: 100%" dir="rtl">
<tr style="width: 100%; background-color: powderblue">
<%--<td style="width: 3%; height: 100px; vertical-align: central" align="center">
<asp:CheckBox ID="CheckBox1" runat="server" />
</td>--%>
<td style="width: 15%;" align="center">
<%# DataBinder.Eval(Container.DataItem, "cName") %>
</td>
<td style="width: 20%; vertical-align: middle;" align="center">
<%# DataBinder.Eval(Container.DataItem, "mobile") %>
</td>
<td style="width: 10%;" align="center">
<%# DataBinder.Eval(Container.DataItem, "cemail") %>
</td>
<td style="width: 10%;" align="center">
<%# DataBinder.Eval(Container.DataItem, "state") %>
</td>
</tr>
</table>
</AlternatingItemTemplate>
</asp:Repeater>