/// <summary> /// Return false if login user is not DBO. /// </summary> /// <param name="tpf">a TracePropertiesForm object</param> /// <returns>False if login user is not DBO.</returns> bool permission(TracePropertiesForm tpf) { //System.Data.SqlClient.SqlConnection conn; //if (tpf.RawConn != null) // conn = new System.Data.SqlClient.SqlConnection(tpf.RawConn); //else //{ // string str_conn = string.Format("Data Source={0};Application Name={1};Database={2};", // tpf.ServerName, "sqlprofilerapp", "master"); // if (tpf.Username == string.Empty) // str_conn += string.Format("Integrated Security={0};", true); // else // str_conn += string.Format("User ID={0};Password={1};", tpf.Username, tpf.Password); // conn = new System.Data.SqlClient.SqlConnection(str_conn); //} //conn.Open(); //Microsoft.SqlServer.Management.Common.ServerConnection sconn; //sconn = new Microsoft.SqlServer.Management.Common.ServerConnection(conn); //Microsoft.SqlServer.Management.Smo.Server server; //server = new Microsoft.SqlServer.Management.Smo.Server(); //var a = server.Databases["master"]; //bool rc = server.Databases["master"].DboLogin; //conn.Close(); //return rc; return true; }
private void newToolStripMenuItem_Click(object sender, EventArgs e) { TracePropertiesForm tpf = new TracePropertiesForm(); tpf.StartPosition = FormStartPosition.CenterScreen; if(tpf.ShowDialog() == DialogResult.OK) { if (!permission(tpf)) System.Windows.Forms.MessageBox.Show(string.Format("'{0}' has no correct permission.", tpf.Username), "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); else { Trace trace = _traceManager.RunProfiler(tpf.ServerName, tpf.Username, tpf.Password, tpf.TraceName, tpf.RawConn, tpf.EventProperties, tpf.FilterProperties); TraceViewControl tvc = new TraceViewControl(); tvc.Name = "TraceViewControl"; tvc.Trace = trace; tvc.Dock = DockStyle.Fill; FATabStripItem item = new FATabStripItem(tvc); item.Title = tpf.TraceName; tabStrip.AddTab(item, true); tabStrip.Enabled = true; } } }