/// <summary> /// Đưa giá trị từ bản vào form, tên cột trùng tên control tương ứng /// </summary> /// <param name="ctr">Vùng control cần đưa dữ liệu</param> /// <param name="table">Bảng cần dưa dữ liệu</param> public static void SetValueForm(Control ctr, DataTable table) { for (int i = 0; i < table.Columns.Count; i++) { Control _ctr = FindControl(ctr, table.Columns[i].ColumnName); if (_ctr != null) { if (_ctr is Lib.Controls.textBox) { Lib.Controls.textBox txt = (Lib.Controls.textBox)_ctr; txt.Text = LibConvert.ObjectToString(table.Rows[0][i]); } else if (_ctr is Lib.Controls.drop) { ((Lib.Controls.drop)_ctr).SelectedValue = LibConvert.ObjectToString(table.Rows[0][i]); } else if (_ctr is Lib.Controls.checkBox) { ((Lib.Controls.checkBox)_ctr).Checked = LibConvert.ObjectToBool(table.Rows[0][i]); } else if (_ctr is HiddenField) { ((HiddenField)_ctr).Value = LibConvert.ObjectToString(table.Rows[0][i]); } } } }
/// <summary> /// Tìm dòng có cột bằng với giá trị truyền /// </summary> /// <param name="table">Bảng cần tìm</param> /// <param name="name">Tên cột</param> /// <param name="val">Giá trị truyền</param> public static int FindIndexRow(DataTable table, string name, object val) { if (!isNullOrEmtyTable(table)) { string str = LibConvert.ObjectToString(val); for (int i = 0; i < table.Rows.Count; i++) { if (!(table.Rows[i][name] is DBNull) && (LibConvert.ObjectToString(table.Rows[i][name]) == str)) { return(i); } } } return(-1); }
public static DataRow FindUser(string userName) { DataRow row = null; DataTable table = (DataTable)HttpContext.Current.Application["connec"]; int num = LibTable.FindRowByColumn(table, "user", userName); if (num >= 0) { row = table.Rows[num]; } //lưu connecstring DataOra _ora = new DataOra(); _ora.connecString = LibConvert.ObjectToString(row["connec"]); return(row); }
public static void Initialization() { try { DataSet set = new DataSet(); set.ReadXml(HttpContext.Current.Server.MapPath("~/htdns/config.xml")); DataTable table = (DataTable)HttpContext.Current.Application["connec"]; table.AcceptChanges(); DataTable table2 = set.Tables["info"]; if (table2 != null) { int count = table2.Rows.Count; if (count != 0) { for (int i = 0; i < count; i++) { DataRow row2 = table2.Rows[i]; bool flag = true; for (int j = 0; j < i; j++) { DataRow row3 = table2.Rows[j]; if ((((row3["ip"].ToString() == row2["ip"].ToString()) && (row3["db"].ToString() == row2["db"].ToString())) && ((row3["loai"].ToString() == row2["loai"].ToString()) && (row3["dbo"].ToString() == row2["dbo"].ToString()))) && ((row3["ma_dvi"].ToString() == row2["ma_dvi"].ToString()) && (row3["nsd"].ToString() == row2["nsd"].ToString()))) { flag = false; break; } } if (flag) { DataRow row = table.NewRow(); row["loai"] = row2["loai"]; row["dbo"] = row2["dbo"]; row["user"] = row2["user"]; row["nsd"] = row2["nsd"]; if (row2["loai"].ToString() == "ORA") { row["connec"] = string.Concat(new object[] { "User ID=", row["nsd"], "; Password="******"pas"], ";" }); row["connec"] = row["connec"] + "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)"; row["connec"] = string.Concat(new object[] { row["connec"], "(HOST=", row2["ip"], ")(PORT=", row2["port"], "))" }); row["connec"] = string.Concat(new object[] { row["connec"], "(CONNECT_DATA=(SID=", row2["db"], ")))" }); } else if (LibConvert.ObjectToString(row2["loai"]) == "MSSQL") { row["connec"] = string.Concat(new object[] { "User ID =", row["nsd"], "; Data Source=", row2["ip"], "; Initial Catalog=", row2["db"], ";" }); if (LibConvert.ObjectToString(row2["pas"]) != "") { row["connec"] = string.Concat(new object[] { row["connec"], " Password="******"pas"], ";" }); } row["dbo"] = "dbo"; } table.Rows.Add(row); } } table.AcceptChanges(); } } } catch (Exception e) { throw new Exception("loi:Lỗi khởi tạo tham số kết nối " + e.Message + " :loi"); } }