根据数据库存储的值自动完成文本框 [英] Autocomplete a textbox from Database stored value

问题描述

先生，

我有一个文本框，我要...如果用户输入名称，那么如果该名称存储在sql server(数据库)中，则该名称应该是自动完成的.

谢谢！！

我在基于Web的项目中使用这种方式，这将显示一条错误消息，如...找不到命名空间名称.........

sir,

I have a textbox, i want...if user enter name then it should be auto complete if that name stored in sql server(database).

Thanking you!!

i am using this way in web based project this show an error message like......namespace name not found.........

protected void txt_name_TextChanged(object sender, EventArgs e)
    {
        string autoC = "select vendername from tbl_vendermaster";
        SqlDataAdapter dtAuto = new SqlDataAdapter(autoC, con).Fill(dtAuto);
        GetAutoSourceCollectionFromTable(dtAuto);

    }
    private AutoCompleteStringCollection GetAutoSourceCollectionFromTable(DataTable table)
    {
        AutoCompleteStringCollection autoSourceCollection = new AutoCompleteStringCollection();

        foreach (DataRow row in table.Rows)
        {
            autoSourceCollection.Add(row[0]); //assuming required data is in first column
        }

        return autoSourceCollection;
    }

推荐答案

阅读此

http://stackoverflow.com/questions/3349374/is-it-possible-to-make-a-datatable-as-a-autocompletesource-in-a-textbox-c [

read this

http://stackoverflow.com/questions/3349374/is-it-possible-to-make-a-datatable-as-a-autocompletesource-in-a-textbox-c[^]

Hope this helps if yes then accept and vote the answer
--Rahul D.

我可以使用此功能来解决


公共无效ExtractArchive(字符串zipFilename，字符串ExtractDir)
{
int重做= 1;
ZipInputStream MyZipInputStream =默认值(ZipInputStream);
FileStream MyFileStream =默认值(FileStream);
MyZipInputStream =新的ZipInputStream(新的FileStream(zipFilename，FileMode.Open，FileAccess.Read));
ZipEntry MyZipEntry = MyZipInputStream.GetNextEntry();
Directory.CreateDirectory(ExtractDir);
while(((MyZipEntry！= null))
{
如果((MyZipEntry.IsDirectory))
{
Directory.CreateDirectory(ExtractDir +"\\" + MyZipEntry.Name);
}
其他
{
如果(！Directory.Exists(ExtractDir +"\\" + Path.GetDirectoryName(MyZipEntry.Name)))
{
Directory.CreateDirectory(ExtractDir +"\\" + Path.GetDirectoryName(MyZipEntry.Name));
}
MyFileStream =新的FileStream(ExtractDir +"\\" + MyZipEntry.Name，FileMode.OpenOrCreate，FileAccess.Write);
int count = 0;
byte []缓冲区=新的byte [4097];
count = MyZipInputStream.Read(buffer，0，4096);
一会儿(count> 0)
{
MyFileStream.Write(buffer，0，count);
count = MyZipInputStream.Read(buffer，0，4096);
}
MyFileStream.Close();
}
试试
{
MyZipEntry = MyZipInputStream.GetNextEntry();
}
catch(ex ex例外)
{
MyZipEntry = null;
}
}
如果((MyZipInputStream！= null))
MyZipInputStream.Close();
如果((MyFileStream！= null))
MyFileStream.Close();
}

I could solve with this function


public void ExtractArchive(string zipFilename, string ExtractDir)
{
int Redo = 1;
ZipInputStream MyZipInputStream = default(ZipInputStream);
FileStream MyFileStream = default(FileStream);
MyZipInputStream = new ZipInputStream(new FileStream(zipFilename, FileMode.Open, FileAccess.Read));
ZipEntry MyZipEntry = MyZipInputStream.GetNextEntry();
Directory.CreateDirectory(ExtractDir);
while ((MyZipEntry != null))
{
if ((MyZipEntry.IsDirectory))
{
Directory.CreateDirectory(ExtractDir + "\\" + MyZipEntry.Name);
}
else
{
if (!Directory.Exists(ExtractDir + "\\" + Path.GetDirectoryName(MyZipEntry.Name)))
{
Directory.CreateDirectory(ExtractDir + "\\" + Path.GetDirectoryName(MyZipEntry.Name));
}
MyFileStream = new FileStream(ExtractDir + "\\" + MyZipEntry.Name, FileMode.OpenOrCreate, FileAccess.Write);
int count = 0;
byte[] buffer = new byte[4097];
count = MyZipInputStream.Read(buffer, 0, 4096);
while (count > 0)
{
MyFileStream.Write(buffer, 0, count);
count = MyZipInputStream.Read(buffer, 0, 4096);
}
MyFileStream.Close();
}
try
{
MyZipEntry = MyZipInputStream.GetNextEntry();
}
catch (Exception ex)
{
MyZipEntry = null;
}
}
if ((MyZipInputStream != null))
MyZipInputStream.Close();
if ((MyFileStream != null))
MyFileStream.Close();
}

为此使用javascript和ajax，并调用js函数onkeyup事件.

Hi, use javascript and ajax for this, and call js function onkeyup event.

这篇关于根据数据库存储的值自动完成文本框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！