adabyron
چهارشنبه 30 خرداد 1386, 17:11 عصر
سلام . کد زیر هنگام اجرا هیچ خطایی نمیده ولی داده ها رو توی تکست باکسها نشون نمیده میشه بگین چرا ؟
strsql = "Select _Users.*,Credits.amount From _Users " +
" INNER JOIN Credits ON _Users.Username = Credits.username Where _Users.Username like '" + username + "'";
da = newSqlDataAdapter(strsql, conn);
ds.Clear();
da.Fill(ds, "_Users");
txtName.DataBindings.Add("Text", ds, "_Users.F_Name");
txtFamily.DataBindings.Add(newBinding("Text", ds, "_Users.L_Name"));
txtUsername.DataBindings.Add(newBinding("Text", ds, "_Users.username"));
txtPassword.DataBindings.Add(newBinding("Text", ds, "_Users.password"));
txtBirthday.DataBindings.Add(newBinding("Text", ds, "_Users.birthday"));
txtCompany.DataBindings.Add(newBinding("Text", ds, "_Users.cname"));
txtOcc.DataBindings.Add(newBinding("Text", ds, "_Users.occupation"));
txtTel.DataBindings.Add(newBinding("Text", ds, "_Users.tel"));
txtMobile.DataBindings.Add(newBinding("Text", ds, "_Users.mobile"));
txtFax.DataBindings.Add(newBinding("Text", ds, "_Users.fax"));
txtEmail.DataBindings.Add(newBinding("Text", ds, "_Users.email"));
txtYahoo.DataBindings.Add(newBinding("Text", ds, "_Users.yahoo"));
chkActive.DataBindings.Add(newBinding("Checked", ds, "_Users.active"));
txtRegDate.DataBindings.Add(newBinding("Text", ds, "_Users.reg_date"));
txtAddress.DataBindings.Add(newBinding("Text", ds, "_Users.address"));
cmbGender.DataBindings.Add(newBinding("SelectedIndex", ds, "_Users.gender"));
strsql = "Select _Users.*,Credits.amount From _Users " +
" INNER JOIN Credits ON _Users.Username = Credits.username Where _Users.Username like '" + username + "'";
da = newSqlDataAdapter(strsql, conn);
ds.Clear();
da.Fill(ds, "_Users");
txtName.DataBindings.Add("Text", ds, "_Users.F_Name");
txtFamily.DataBindings.Add(newBinding("Text", ds, "_Users.L_Name"));
txtUsername.DataBindings.Add(newBinding("Text", ds, "_Users.username"));
txtPassword.DataBindings.Add(newBinding("Text", ds, "_Users.password"));
txtBirthday.DataBindings.Add(newBinding("Text", ds, "_Users.birthday"));
txtCompany.DataBindings.Add(newBinding("Text", ds, "_Users.cname"));
txtOcc.DataBindings.Add(newBinding("Text", ds, "_Users.occupation"));
txtTel.DataBindings.Add(newBinding("Text", ds, "_Users.tel"));
txtMobile.DataBindings.Add(newBinding("Text", ds, "_Users.mobile"));
txtFax.DataBindings.Add(newBinding("Text", ds, "_Users.fax"));
txtEmail.DataBindings.Add(newBinding("Text", ds, "_Users.email"));
txtYahoo.DataBindings.Add(newBinding("Text", ds, "_Users.yahoo"));
chkActive.DataBindings.Add(newBinding("Checked", ds, "_Users.active"));
txtRegDate.DataBindings.Add(newBinding("Text", ds, "_Users.reg_date"));
txtAddress.DataBindings.Add(newBinding("Text", ds, "_Users.address"));
cmbGender.DataBindings.Add(newBinding("SelectedIndex", ds, "_Users.gender"));