我是否可以像dropdownlist那样绑定文本框,这意味着在dropdownlist中,我们可以设置datatextfield以显示文本,而datavaluefield可以将值插入数据库. 我必须使用文本框,我已经向文本框添加了自动完成ajax工具包扩展程序.我只显示学生姓名,但单击按钮后,我必须在数据库中插入学生的SID,而不是学生姓名.我在Google上搜索谷歌,他们告诉我使用自动填充扩展程序的OnClientItemSelected.
Can I bind textbox like dropdownlist means in dropdownlist we can set datatextfield to show text and datavaluefield to insert value into database. I have to do using textbox,I have added Autocomplete ajax toolkit extender to textbox. I am showing only Student Names but on click of button i have to insert SID of student not student name into the database.I search google they tell me use OnClientItemSelected of Autocomplete extender.How can i do any idea regarding this.
[System.Web.Services.WebMethodAttribute(), System.Web.Script.Services.ScriptMethodAttribute()] public static string[] Getdata(string prefixText, int count, string contextKey) { strSQL = "SELECT SID,Student_Name FROM Student_Master WHERE Student_Name Like '" + prefixText + "%'"; DataTable dataTablePatient_Master = null; dataTablePatient_Master = objSqlDbComm.ExecuteDatasetQuery(strSQL).Tables[0]; List<String> list = new List<String>(); foreach(DataRow dr in dataTablePatient_Master.Rows) { list.Add(dr["Student_Name"].ToString()); } return list.ToArray(); }
<asp:TextBox ID="txtStudentName" AutoCompleteType="Disabled" CssClass="csstextbox" runat="server"></asp:TextBox> <asp:AutoCompleteExtender ID="txtStudentName_AutoCompleteExtender" runat="server" ServiceMethod="Getdata" OnClientItemSelected="OnItemSelected" CompletionListCssClass="cssautocompletetextbox" MinimumPrefixLength="1" CompletionInterval="1000" EnableCaching="true" CompletionSetCount="1" TargetControlID="txtStudentName" UseContextKey="True"> </asp:AutoCompleteExtender>
推荐答案
www.dotnetfunda/codes/code2722-autocompleteextender-in-textbox-from-sql-table.aspx [ ^ ]
i找到了一些有关文本框绑定的好链接 www.daniweb/web-development/aspnet/threads/39519/how-to-databind-to-文本框 [ ^ ] stackoverflow/问题/4939849/bind-a-text-box-to-a-field-selected-by-sqldatasource-vb-net [ ^ ] i found some good link regarding Textbox binding www.daniweb/web-development/aspnet/threads/39519/how-to-databind-to-textboxes[^] stackoverflow/questions/4939849/bind-a-text-box-to-a-field-selected-by-sqldatasource-vb-net[^]
根据需要尝试运行的项目 使用AutoComplete扩展器自动执行回发 [ ^ ] 如果得到答案,请标记解决方案. 谢谢 ashish try the running project for your requirement Using the AutoComplete Extender to Automatically Perform a PostBack[^] mark solution if you get your answer. Thanks ashish
更多推荐
像下拉列表一样绑定文本框
发布评论