While reader.Read()
If DropDownList2.SelectedValue = "A" Then
TextBox5.Text = reader.GetString(5)
End If Exit While
End While
這樣可以抓到值,可是可以寫多筆??我有寫兩個IF
可是有問題!!請問要怎樣寫成多筆
If DropDownList2.SelectedValue = "A" Then
TextBox5.Text = reader.GetString(5)
End If Exit While
End While
這樣可以抓到值,可是可以寫多筆??我有寫兩個IF
可是有問題!!請問要怎樣寫成多筆
TextBox5.Text ="";
While reader.Read()
If DropDownList2.SelectedValue = "A" Then
TextBox5.Text += reader[5].ToString()+",";
End If
Exit While
End While这样不知道成不?
If DropDownList2.SelectedValue = "A" Then
TextBox5.Text = reader.GetString(5)
End If //Exit While 找到值不exit 再写一个 如下:
If DropDownList2.SelectedValue = "B" Then
TextBox5_1.Text = reader.GetString(5_1)
End If
//这样如何呢
End While
這是C的寫法吧!!有VB的寫法???
TextBox5_1.Text = reader.GetString(5_1)
(5_1)這樣是不能,請問有VB的寫法??
或者
TextBox5.Text = reader[5].ToString() + "," + TextBox5.Text;
while(reader.Read())
{
if(DropDownList2.SelectedValue == "A")
{
sb.Append(reader.GetString(5));
}
}
TextBox5.Text =sb.ToString();