private void toolStripButton1_Click(object sender, EventArgs e) { Form2 form2 = new Form2(); form2.StartPosition = FormStartPosition.CenterScreen; if (form2.ShowDialog() != DialogResult.OK) { return; } conStr = form2.ConStr; LoadDb(); }
public static string GetSql(DbConStrInfo conStr, int type, string table_name = "") { if (type == 1) { if (conStr.ProviderType == ProviderType.MySql) { return(string.Format("select * from information_schema.tables where table_schema='{0}'", conStr.Database)); } if (conStr.ProviderType == ProviderType.SqlServer) { return(string.Format("select name as table_name from sys.objects where type='U' order by name")); } if (conStr.ProviderType == ProviderType.Oracle) { return("select table_name from user_tables"); } } if (type == 2) { if (conStr.ProviderType == ProviderType.MySql) { return(string.Format("select * from information_schema.views where table_schema='{0}'", conStr.Database)); } if (conStr.ProviderType == ProviderType.SqlServer) { return(string.Format("select name as table_name from sys.objects where type='V' order by name")); } if (conStr.ProviderType == ProviderType.Oracle) { return("select * from user_views"); } } if (type == 3) { if (conStr.ProviderType == ProviderType.MySql) { return(string.Format("select * from information_schema.columns where table_schema='{0}' and table_name='{1}'", conStr.Database, table_name)); } if (conStr.ProviderType == ProviderType.SqlServer) { return(string.Format("SELECT * FROM sys.columns WHERE OBJECT_ID = (SELECT id FROM sys.sysobjects WHERE type IN ('U','V') AND name='{0}')", table_name)); } if (conStr.ProviderType == ProviderType.Oracle) { return(string.Format("select * from USER_TAB_COLUMNS where table_name='{0}'", table_name)); } } return(""); }
public static int ExecuteNonQuery(DbConStrInfo conStr, string sql) { if (conStr.ProviderType == ProviderType.MySql) { return(MySqlConnector.ExecuteNonQuery(conStr.ConStr, sql)); } else if (conStr.ProviderType == ProviderType.Oracle) { return(OracleConnector.ExecuteNonQuery(conStr.ConStr, sql)); } else { return(SqlConnector.ExecuteNonQuery(conStr.ConStr, sql)); } }
public static DataTable GetData(DbConStrInfo conStr, string sql) { if (conStr.ProviderType == ProviderType.MySql) { return(MySqlConnector.GetData(conStr.ConStr, sql)); } else if (conStr.ProviderType == ProviderType.Oracle) { return(OracleConnector.GetData(conStr.ConStr, sql)); } else { return(SqlConnector.GetData(conStr.ConStr, sql)); } }
public static bool TestConnect(DbConStrInfo conStr) { if (conStr.ProviderType == ProviderType.MySql) { return(MySqlConnector.TestConnect(conStr.ConStr)); } else if (conStr.ProviderType == ProviderType.Oracle) { return(OracleConnector.TestConnect(conStr.ConStr)); } else { return(SqlConnector.TestConnect(conStr.ConStr)); } }
private void button3_Click(object sender, EventArgs e) { ConStr = new DbConStrInfo { Server = tb_server.Text, Port = tb_port.Text, LogId = tb_logid.Text, LogPass = tb_logpass.Text, Database = cbb_db.Text, Provider = cbb_provider.Text }; if (AppFunc.TestConnect(ConStr)) { MessageBox.Show("连接数据库成功!", "提示信息"); } ConStr = null; }
private void button1_Click(object sender, EventArgs e) { ConStr = new DbConStrInfo { Server = tb_server.Text, Port = tb_port.Text, LogId = tb_logid.Text, LogPass = tb_logpass.Text, Database = cbb_db.Text, Provider = cbb_provider.Text }; if (!AppFunc.TestConnect(ConStr)) { ConStr = null; return; } SaveXml("db_config.xml"); this.DialogResult = DialogResult.OK; }
private void button2_Click(object sender, EventArgs e) { ConStr = null; this.DialogResult = DialogResult.Cancel; }
public Form3(string table, DbConStrInfo conStr) { InitializeComponent(); this.table = table; this.conStr = conStr; }