PDA

View Full Version : سوال: مشکل در حدس خودکار text box



shadow.pro
سه شنبه 20 اسفند 1398, 10:48 صبح
سلام
بنده چند ماهه مشکل در حدس خودکار text box دارم ولی مشکلم اینه که از تمام جدول نمیخونه ستون اول میخونه ممنون میشم راهنمایی کنید کد زیر استفاده شده.. دز appconfig تتظیمات قرار دادم





<connectionStrings>
<add name="constring" connectionString="Data Source=LAPTOP;Initial Catalog=LAPTOP2;Integrated Security=true"/>
</connectionStrings>



و در فرم لود





Con.ConnectionString = ConfigurationManager.ConnectionStrings["constring"].ToString();
Con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select RFtext from [TblCom]";
cmd.CommandText = "Select NFtext from [TblCom]";
cmd.CommandText = "Select RGtext from [TblCom]";
cmd.CommandText = "Select NGtext from [TblCom]";
cmd.CommandText = "Select Ttext from [TblCom]";
cmd.Connection = Con;
SqlDataReader Reader = cmd.ExecuteReader();
AutoCompleteStringCollection autocomp = new AutoCompleteStringCollection();
while (Reader.Read())
{
autocomp.Add(Reader.GetString(0));
}
RFtextBox.AutoCompleteSource = AutoCompleteSource.CustomSource;
RFtextBox.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
RFtextBox.AutoCompleteCustomSource = autocomp;
NFtextBox.AutoCompleteSource = AutoCompleteSource.CustomSource;
NFtextBox.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
NFtextBox.AutoCompleteCustomSource = autocomp;
RGtextBox.AutoCompleteSource = AutoCompleteSource.CustomSource;
RGtextBox.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
RGtextBox.AutoCompleteCustomSource = autocomp;
NGtextBox.AutoCompleteSource = AutoCompleteSource.CustomSource;
NGtextBox.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
NGtextBox.AutoCompleteCustomSource = autocomp;
NGtextBox.AutoCompleteSource = AutoCompleteSource.CustomSource;
NGtextBox.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
NGtextBox.AutoCompleteCustomSource = autocomp;
TtextBox.AutoCompleteSource = AutoCompleteSource.CustomSource;
TtextBox.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
TtextBox.AutoCompleteCustomSource = autocomp;








لطفا همین کد تست کنید و مشکل من در اینجا چیه ممنون از توجهتون