Protected void Page_Load (object sender, EventArgs e)
{
}
Protected void textboxintelligentinclufocus (object sender, wzh. myWebControlsLib. TextBoxIntelligent. FocusEventArgs e)
{
String arg = e. tbText;
If (Cache ["dep"] = null)
{
Cache ["dep"] = arg;
}
Else if (string) Cache ["dep"]! = Arg)
{
Cache ["dep"] = arg;
}
String [] dependencyKey = new String [1];
DependencyKey [0] = "dep ";
CacheDependency dependency = new CacheDependency (null, dependencyKey );
If (Cache ["Data"] = null)
{
Cache. Insert ("Data", getData (arg), dependency );
}
TextBoxIntelligent1.DataTable = (DataTable) Cache ["Data"];
}
Public DataTable getData (string arg)
{
SqlConnection con = new SqlConnection (ConfigurationManager. etettings ["sqlConn"]);
Con. Open ();
SqlDataAdapter ad = new SqlDataAdapter ("select [name] from tb_name where [name] like '" + arg + "%'", con );
DataSet ds = new DataSet ();
Ad. Fill (ds, "city ");
DataTable dt = ds. Tables ["city"];
Con. Close ();
Ad. Dispose ();
Return dt;
}