Hi,
If i execute this code it shows some symbols and numericals.i want to display in the textbox numericals with percentage symbol(eg:2.5%).only.but it display some special symbols.please do the needful.
private void VATUpdate_Load(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("data source=mars-104;initial catalog=marsweb;integrated security=true");
conn.Open();
DataSet ds = new DataSet();
SqlDataAdapter da1 = new SqlDataAdapter("select * from tbl_vat", conn);
da1.Fill(ds);
foreach (DataRow row in ds.Tables[0].Rows)
{
for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
{
txt_VAT.Text += row[i].ToString() + Environment.NewLine;
txt_VAT.Text += Environment.NewLine;
}
}
Output:i am not able to display the special symbols here.but i will explain symbols those are squareshape boxes
1
2.2
Best,
Sudheep.