This is my overall view of the application
Now the below Diagram shows the overall View of My Database:-
Now the below Diagram shows the Design View of My web Page Default.aspx:-
Now the below Diagram shows the Source View of My web Page Default.aspx:-
You can Copy the Source code of My web Page Default.aspx here :-
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="ajaxtoolkit" %>
<!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>
<script type="text/javascript" language="javascript">
function GetCode(source, eventArgs) {
document.getElementById("hCode").value = eventArgs.get_value();
document.getElementById("hdnCompanyName").value = source;
}
function hCode_onclick() {
}
</script>
<style type="text/css">
.style1
{
width: 100%;
}
.style2
{
width: 133px;
}
.style3
{
color: #336600;
}
.style4
{
color: #800000;
}
.style5
{
width: 133px;
color: #000099;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server"> <Services><asp:ServiceReference Path="CompanyServiceForAutoSuggest.asmx" /> </Services></asp:ScriptManager>
<div> <h1><span class="style4">Om Namah Shivaya(</span><span class="style3">Auto Complete Textbox To Store Id While Displaying Name</span><span class="style4">)</span></h1>
<table class="style1"><tr> <td class="style5"><strong>Shibashish Name:</strong></td><td><asp:TextBox ID="txtManufacturer" runat="server"/>
<ajaxToolkit:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server" TargetControlID="txtManufacturer" ServicePath="CompanyServiceForAutoSuggest.asmx"
ServiceMethod="GetCountries" CompletionInterval="100" CompletionSetCount="20" MinimumPrefixLength="1" OnClientItemSelected="GetCode" /></td> </tr> <tr> <td class="style2">
</td><td> </td></tr> <tr> <td class="style2"> </td><td> </td> </tr><tr> <td class="style5"> <strong>Hidden stored ID:</strong></td>
<td><input type="text" id="hCode" runat="server" value="0" /></td> </tr> <tr> <td class="style2"> </td> <td> </td></tr></table> </div>
</form>
</body>
</html>
Now the below Diagram shows the code of Web.cofig:-
You can Copy the code of Web.cofig here and change it according to your connectionstring :-
<?xml version="1.0"?>
<configuration>
<connectionStrings>
<add name="TestConnectionString" connectionString="Data Source=SWASH-DBS\SWASHSQLINT;Initial Catalog=Test;Persist Security Info=True;User ID=ken;Password=kc@2011"
providerName="System.Data.SqlClient"/>
</connectionStrings>
<system.web>
<compilation debug="true" targetFramework="4.0"/>
</system.web>
<system.serviceModel>
<bindings/>
<client/>
</system.serviceModel>
</configuration>
Here is the web Service Code That I have used in My application
<%@ WebService Language="C#" Class="CompanyServiceForAutoSuggest" %>
using System;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;
[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 CompanyServiceForAutoSuggest : System.Web.Services.WebService {
[WebMethod]
public string HelloWorld() {
return "Hello World";
}
[WebMethod]
public List<string> GetCountries(string prefixText)
{
string constring = ConfigurationManager.ConnectionStrings["TestConnectionString"].ConnectionString;
SqlConnection con = new SqlConnection(constring);
if (con.State != ConnectionState.Open)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("select * from TextboxAutoImpliment where Name like @Name", con);
cmd.Parameters.AddWithValue("@Name",prefixText+'%');
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
List<string> Name = new List<string>();
if (dt.Rows.Count > 0){
for (int i = 0; i < dt.Rows.Count; i++)
{
Name.Add(AjaxControlToolkit.AutoCompleteExtender.CreateAutoCompleteItem(dt.Rows[i][1].ToString(), Convert.ToString(dt.Rows[i][0].ToString())));
}
}
return Name;
}
}
After running the application:-
Thanks
Shibashish Mohanty
No comments:
Post a Comment
Please don't spam, spam comments is not allowed here.