MySqlConnection _conn = new MySqlConnection();
if (!MySql.ConnectToMySqlServer("PrimaryDatabase", ref _conn))
{
_conn.Dispose();
MessageBox.Show("Can not link to PrimaryDatabase!");
return;
}
DataSet ds_Point;
string strTab = "cfg_point_current";
string strSql = "SELECT point_number,tag_name,description FROM cfg_point_current where point_type_id=" + mPointType;
ds_Point = MySql.GetDataFromTable(strTab, strSql, ref _conn);
DataTable dt = ds_Point.Tables[0];
if (dt == null)
return;
listView_Edit.Items.Clear();
string[] str = new string[3];
foreach (DataRow row in dt.Rows)
{
str[0] = row["point_number"].ToString();
str[1] = row["tag_name"].ToString();
str[2] = row["description"].ToString();
ListViewItem item = new ListViewItem(str, 0);
listView_Edit.Items.Add(item);
}