|
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using Microsoft.SqlServer.Management.Common;
using Microsoft.SqlServer.Management.Smo;
using Microsoft.SqlServer.Management.Sdk.Sfc;
using System.Configuration;
using System.Data;
namespace DBCompare
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
string serverstr = "POSTA";
string user = "kanasz";
string password = "chaaron";
ServerConnection conn = new ServerConnection(serverstr, user, password);
try
{
Server server = new Server(conn);
/*
foreach(Table table in db.Tables)
{
Console.WriteLine(table.Name);
}*/
DataTable dt = new System.Data.DataTable();
dt.Columns.Add("Name");
List<SqlSmoObject> list = new List<SqlSmoObject>();
server.SetDefaultInitFields(typeof(StoredProcedure), "IsSystemObject");
Database db = server.Databases["Dynamic"];
foreach (StoredProcedure sp in db.StoredProcedures)
{
if (!sp.IsSystemObject)
{
//Console.WriteLine(sp.Name);
list.Add(sp);
//Console.WriteLine(sp.TextBody);
dt.Rows.Add(sp.Name);
}
}
dataGridView1.DataSource = dt;
}
catch (Exception err)
{
Console.WriteLine(err.Message);
}
}
}
}
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
My name is Robert Kanasz and I have been working with ASP.NET, WinForms and C# for several years.
MCSD - Web Applications
MCSE - Data Platform
MCPD - ASP.NET Developer 3.5
- Web Developer 4
MCITP - Database Administrator 2008
- Database Developer 2008
MCSA - SQL Server 2012
MCTS - .NET Framework 3.5, ASP.NET Applications
- SQL Server 2008, Database Development
- SQL Server 2008, Implementation and Maintenance
- .NET Framework 4, Data Access
- .NET Framework 4, Service Communication Applications
- .NET Framework 4, Web Applications
MS - Programming in HTML5 with JavaScript and CSS3 Specialist
Open source projects:
DBScripter - Library for scripting SQL Server database objects
Please, do not forget vote