如何从datatable绑定文本框 [英] how to bind textboxes from datatable
问题描述
我有一个组合框,其中包含不同的征税计划选项(包括不同的税)。现在我想将税收计划的税收显示在文本框中。我怎么做这个我试过这段代码
i have a combo box which include different taxing schemed option (different taxes included). now i want to show that taxing scheme's tax into textboxes. How can i do this i have tried this code
if (cbTaxingScheme.SelectedValue != null)
objTaxingSchemeDetails.TaxSchemeId = Convert.ToInt32(cbTaxingScheme.SelectedValue);
DataTable dt = new DataTable();
dt = objTaxingSchemeDetails.TaxWithRatebyTaxingSchId();
int toalTaxes = dt.Rows.Count;
现在dt将包含征税方案列[ taxtpe和taxrate列]我想将两个列绑定到文本框我该怎么办?
如果你有任何其他好的建议那么请分享
now dt will include taxing scheme columns [taxtpe and taxrate column] i want to bind both columns to textboxes how can i do this??
if you have any other good suggestion then please share
if(@Mode='TaxingSchemeViewbyTSID')
Begin
SELECT
--COUNT(tblTaxingSchemeDetails.TaxSchemeDetailsId) as h,
TotalRecords = COUNT(*) OVER(),
tblTaxingSchemeDetails.TaxSchemeDetailsId,
tblTaxingScheme.TaxSchemeId,
tblTaxingScheme.TaxSchemeName,
tblTaxingSchemeDetails.TaxType,
TaxName,
tblTaxingSchemeDetails.TaxRate
From tblTaxingScheme INNER JOIN tblTaxingSchemeDetails
On tblTaxingScheme.TaxSchemeId = tblTaxingSchemeDetails.TaxSchemeId
INNER JOIN tblTaxType
on tblTaxingSchemeDetails.TaxType = tblTaxType.TaxTypeID
where tblTaxingScheme.TaxSchemeId =@TaxSchemeId
End
推荐答案
直接传递数据来自数据库..
例如我们有表数据库{people}的记录:ID,NAME,AGE和表{gender}:男性,女性。
和我们的表单textBox1中有3个文本框,它们是我们的ID,textBox2和textBox3
我们有一个comboBox,它有2个项目:男性,女性
pass data directly from the database..
for example we have table database{people} with records : ID , NAME ,AGE and table{gender} with : male , female.
and we have 3 textboxes in our form textBox1 that will be our ID , textBox2 and textBox3
and we have a comboBox that will have 2 items : male,female
oleDbConnection1.Open();
string query = "select * from gender";
OleDbCommand cmd = new OleDbCommand(query, oleDbConnection1);
OleDbDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
comboBox1.Items.Add(rd.GetValue(1).ToString());
}
rd.Close();
oleDbConnection1.Close();
和文本框......:
and for the textboxes... :
oleDbConnection1.Open();
string query = "select * from people";
OleDbCommand cmd = new OleDbCommand(query, oleDbConnection1);
OleDbDataReader rd = cmd.ExecuteReader();
rd.Read();
textBox1.text = rd.Getvalue(1).ToString();
textBox2.text = rd.Getvalue(2).ToString();
textBox3.text = rd.Getvalue(3).ToString();
lexo1.Close();
oleDbConnection1.Close();
所以我们直接从数据库获取数据文本框或带有OleDbDataReader()的Combobox;
so we are getting data directly from database to textboxes or to Combobox with OleDbDataReader();
这篇关于如何从datatable绑定文本框的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!