rational unified process
چهارشنبه 27 آذر 1392, 04:19 صبح
سلام دوستان
من یه برنامه برای تکمیل خودکار auto complete تکست باکس نوشتم .برنامه ام هیچ خطای سینتکسی نداره ولی کار نمیکنه.کی میدونه مشکلش چیه؟ عکسهای همشونو گذاشتم. در ضمن تکست باکسمو (Textbox1) هم توی وب سرویس ( صفحه asmx ) نمیشناخت ، عکس اخر.
114085
-----------------------------------
114092
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
</asp:ToolkitScriptManager>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<asp:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server"
TargetControlID="TextBox1" ServiceMethod="GetCompletionList"
UseContextKey="True" MinimumPrefixLength="1" CompletionInterval="100" ServicePath="~/WebService.asmx">
</asp:AutoCompleteExtender>
</div>
</form>
</body>
</html>
----------------------------------
114087
using System;
using System.Collections;
using System.Configuration;
using System.Data;
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;
public partial class Default2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
}
-----------------------------
114088
<%@ WebService Language="C#" CodeBehind="~/App_Code/AutoComplete.cs" Class="AutoComplete" %>
-----------------------------
114089http://barnamenevis.org/images/misc/pencil.png
using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.Configuration;
/// <summary>
/// this WebService is designed for autocomplete with ajaxControlToolkit and ADO.Net
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
[System.Web.Script.Services.ScriptService]
public class AutoComplete : System.Web.Services.WebService {
public AutoComplete()
{
//Uncomment the following line if using designed components
//InitializeComponent();
}
[WebMethod]
public string[] GetCompletionList(string prefixText, int count)
{
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrin gs["cn"].ConnectionString);
string query = "select * from tbl_users where username like @username";
SqlCommand cm = new SqlCommand(query,cn);
cm.Parameters.AddWithValue("username","N%"+prefixText+"%");
cn.Open();
SqlDataReader dr = cm.ExecuteReader();
List<string> Textbox1 = new List<string>();
String dbValues;
while (dr.Read())
{
//String From DataBase(dbValues)
dbValues = dr["username"].ToString().ToLower();
Textbox1.Add(dbValues);
}
return Textbox1.ToArray();
cn.Close();
}
}
من یه برنامه برای تکمیل خودکار auto complete تکست باکس نوشتم .برنامه ام هیچ خطای سینتکسی نداره ولی کار نمیکنه.کی میدونه مشکلش چیه؟ عکسهای همشونو گذاشتم. در ضمن تکست باکسمو (Textbox1) هم توی وب سرویس ( صفحه asmx ) نمیشناخت ، عکس اخر.
114085
-----------------------------------
114092
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
</asp:ToolkitScriptManager>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<asp:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server"
TargetControlID="TextBox1" ServiceMethod="GetCompletionList"
UseContextKey="True" MinimumPrefixLength="1" CompletionInterval="100" ServicePath="~/WebService.asmx">
</asp:AutoCompleteExtender>
</div>
</form>
</body>
</html>
----------------------------------
114087
using System;
using System.Collections;
using System.Configuration;
using System.Data;
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;
public partial class Default2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
}
-----------------------------
114088
<%@ WebService Language="C#" CodeBehind="~/App_Code/AutoComplete.cs" Class="AutoComplete" %>
-----------------------------
114089http://barnamenevis.org/images/misc/pencil.png
using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.Configuration;
/// <summary>
/// this WebService is designed for autocomplete with ajaxControlToolkit and ADO.Net
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
[System.Web.Script.Services.ScriptService]
public class AutoComplete : System.Web.Services.WebService {
public AutoComplete()
{
//Uncomment the following line if using designed components
//InitializeComponent();
}
[WebMethod]
public string[] GetCompletionList(string prefixText, int count)
{
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrin gs["cn"].ConnectionString);
string query = "select * from tbl_users where username like @username";
SqlCommand cm = new SqlCommand(query,cn);
cm.Parameters.AddWithValue("username","N%"+prefixText+"%");
cn.Open();
SqlDataReader dr = cm.ExecuteReader();
List<string> Textbox1 = new List<string>();
String dbValues;
while (dr.Read())
{
//String From DataBase(dbValues)
dbValues = dr["username"].ToString().ToLower();
Textbox1.Add(dbValues);
}
return Textbox1.ToArray();
cn.Close();
}
}