hello ,
I am working with autocompleate search data to display data in table the user data work but the picture not show
namelocation nvarchar(MAX)
filelocation image
<asp:Panel ID="Panel4" runat="server" Visible="False">
<table style="padding: inherit; border: medium solid #000000; color: #000000; background-color: #99CCFF; font-family: Arial, Helvetica, sans-serif; font-size: medium;">
<tr class="auto-style155">
<td style="border-style: solid; border-color: #000000; background-color: #FFC080;" class="auto-style190" colspan="5"><strong>مهمة رسمية</strong></td>
</tr>
<tr>
<td style="border-style: solid; border-color: #000000; " class="auto-style159" colspan="2">
<asp:TextBox ID="TextBox17" runat="server"></asp:TextBox>
</td>
<td style="border-style: solid; border-color: #000000; " class="auto-style159" colspan="2">
<asp:TextBox ID="TextBox18" runat="server"></asp:TextBox>
</td>
<td class="auto-style159" style="border-style: solid; border-color: #000000; ">
<asp:TextBox ID="TextBox19" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td style="border-style: solid; border-color: #000000; " class="auto-style161">
Location</td>
<td style="border-style: solid; border-color: #000000; " class="auto-style158">
<asp:Image ID="im1" runat="server" Height="52px" Width="64px" />
</td>
<td class="auto-style158" colspan="3" style="border-style: solid; border-color: #000000; ">
<div>
<asp:TextBox ID="txtSearch2" runat="server" Width="84%"></asp:TextBox>
<br />
<asp:Button ID="b2" runat="server" Text="Search" />
</div>
</td>
</tr>
<tr class="auto-style157">
<td class="auto-style159" style="border-style: solid; border-color: #000000; " colspan="5">
<asp:RadioButtonList ID="RadioButtonList2" runat="server" AutoPostBack="true" BorderColor="#333333" BorderStyle="Solid" CssClass="auto-style186" ForeColor="Black" RepeatDirection="Horizontal" style="font-size: large" TextAlign="Left" Width="100%">
<asp:ListItem Selected="True" Value="M">يداية</asp:ListItem>
<asp:ListItem Value="F">نهاية</asp:ListItem>
</asp:RadioButtonList>
</td>
</tr>
<tr>
<td class="auto-style159" style="border-style: solid; border-color: #000000; " colspan="3">
<asp:TextBox ID="rsmonth0" runat="server" BackColor="#FFC080" Font-Bold="True" Font-Size="12pt" style="text-align: center" Width="55px">12</asp:TextBox>
<asp:Button ID="Button44" runat="server" BackColor="#FF6600" Font-Bold="True" Font-Size="Large" Text="-" Width="30px" />
</td>
<td class="auto-style159" colspan="2" style="border-style: solid; border-color: #000000; ">
<asp:TextBox ID="rsmtotal0" runat="server" BackColor="#FFC080" Font-Bold="True" Font-Size="12pt" style="text-align: center" Width="55px">0</asp:TextBox>
<asp:Button ID="Button46" runat="server" BackColor="#FF6600" Font-Bold="True" Font-Size="Large" Text="+" Width="30px" />
</td>
</tr>
<tr>
<td class="auto-style159" colspan="5" style="border-style: solid; border-color: #000000; ">
<asp:RadioButtonList ID="RadioButtonList5" runat="server" AutoPostBack="true" BorderColor="#333333" BorderStyle="Solid" CssClass="auto-style186" ForeColor="Black" OnSelectedIndexChanged="RadioButtonList3_SelectedIndexChanged" RepeatDirection="Horizontal" style="font-size: large" TextAlign="Left" Width="100%">
<asp:ListItem Selected="True" Value="reportUserSP">موظف</asp:ListItem>
<asp:ListItem Value="ReportBoss">مدير الادارة</asp:ListItem>
</asp:RadioButtonList>
</td>
</tr>
<tr>
<td colspan="5" style="border-style: solid; border-color: #000000; " class="auto-style159">
<asp:Button ID="Buttonrm0" runat="server" BackColor="#FFC080" Font-Bold="True" Font-Names="Arial" Font-Size="Large" ForeColor="Black" Height="35px" Text="Print" Width="150px" />
</td>
</tr>
</table>
</asp:Panel>
<link href="css/jquery.autocomplete.css" rel="stylesheet" type="text/css" />
<script src="scripts/jquery-1.4.1.min.js" type="text/javascript"></script>
<script src="scripts/jquery.autocomplete.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function () {
$("#<%=txtSearch2.ClientID%>").autocomplete({
source: '<%=ResolveUrl("~/Admin/Search_location.ashx" ) %>',
minLength: 4
});
});
</script>
protected void Searchdata()
{
try
{
String constring = ConfigurationManager.ConnectionStrings["kankonConnectionString"].ConnectionString;
SqlConnection sqlcon = new SqlConnection(constring);
String pname = "Insert_Userupdate"; ;
sqlcon.Open();
SqlCommand com = new SqlCommand(pname, sqlcon);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("namelocation", txtSearch2.Text);
SqlDataReader rdr;
rdr = com.ExecuteReader();
if (rdr.Read())
{
txtSearch2.Text = rdr["namelocation"].ToString();
}
else
{
txtUsername.Text = "";
civilid.Text = "";
ClientScript.RegisterClientScriptBlock(GetType(), "alert", "alert('" + "no data\\n " + txtSearch2.Text.ToString() + "');", true);
}
sqlcon.Close();
}
catch (Exception)
{
}
}