management studio creation in windows application

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 System.Data.SqlClient;


namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
SqlConnection con = new SqlConnection(@"Data Source=.\sqlexpress;Initial Catalog=Registration;Integrated Security=True");
SqlCommand cmd;
SqlDataReader dr;
DataTable dt = new DataTable();
private void btnexecute_Click(object sender, EventArgs e)
{



con.Open();
cmd = new SqlCommand(richTextBox1.Text, con);
dr = cmd.ExecuteReader();
dt.Load(dr);
dataGrid1.DataSource = dt;
cmd = new SqlCommand("sp_helpdb", con);
dr = cmd.ExecuteReader();
while (dr.Read())
{
treeView1.Nodes.Add(dr["name"].ToString());
}
dr.Close();
cmd = new SqlCommand("sp_helpdb", con);
dr = cmd.ExecuteReader();
while (dr.Read())
{
cboDb.Items.Add(dr["name"].ToString());
}
dr.Close();

}

private void newToolStripMenuItem_Click(object sender, EventArgs e)
{

}

private void openToolStripMenuItem_Click(object sender, EventArgs e)
{
openFileDialog1.Filter="Text File(*.txt)|*.txt";
string filename;
if(openFileDialog1.ShowDialog()==DialogResult.OK);
{
filename=openFileDialog1.FileName;
richTextBox1.LoadFile(openFileDialog1.FileName);

}

}

private void saveToolStripMenuItem_Click(object sender, EventArgs e)
{
saveFileDialog1.Filter = "Text File(*.txt)|*.txt";
saveFileDialog1.DefaultExt = "*.txt";
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
richTextBox1.SaveFile(saveFileDialog1.FileName);
richTextBox1.Clear();
}
}

private void richTextBox1_TextChanged(object sender, EventArgs e)
{

}

private void cboDb_SelectedIndexChanged(object sender, EventArgs e)
{
cmd = new SqlCommand("use"+cboDb.Text,con);
dr = cmd.ExecuteReader();
dr.Close();

}
}
}

Creating Management Studio using asp.net

add this value and key in web.config



some sql statements:
sp_helpdb
SELECT * FROM sysobjects and sp_help



Html Coding for this:











using System.Data.SqlClient;
public partial class Default2 : System.Web.UI.Page
{

SqlCommand cmd;
SqlDataAdapter da;
DataSet ds=new DataSet();
SqlConnection cnn;
SqlDataReader dr;
String strDB;
protected void Page_Load(object sender, EventArgs e)
{
cnn = new SqlConnection(ConfigurationManager.AppSettings.Get("Cnn"));
cnn.Open();
da = new SqlDataAdapter("sp_helpdb", cnn);
da.Fill(ds, "Cat");
if (!IsPostBack)
{
ddlDb.DataSource = ds.Tables["Cat"];
ddlDb.DataTextField = "name";
DataBind();
}

}
protected void Wizard1_FinishButtonClick(object sender, WizardNavigationEventArgs e)
{

}

protected void ddlDb_SelectedIndexChanged(object sender, EventArgs e)
{
strDB = ddlDb.SelectedItem.ToString();
cnn = new SqlConnection("Data Source=.\\sqlexpress;Initial Catalog='"+strDB+"';Integrated Security=True");
da = new SqlDataAdapter("SELECT * FROM sysobjects WHERE xtype = 'u'", cnn);
da.Fill(ds, "student");
ddlTable.DataSource = ds.Tables["student"];
ddlTable.DataTextField = "name";
DataBind();


}



protected void ddlTable_SelectedIndexChanged(object sender, EventArgs e)
{

strDB = ddlDb.SelectedItem.ToString();
cnn = new SqlConnection("Data Source=.\\sqlexpress;Initial Catalog='" + strDB + "';Integrated Security=True");
cnn.Open();
cmd = new SqlCommand("sp_help " + ddlTable.SelectedItem.ToString(), cnn);
dr = cmd.ExecuteReader();
dr.NextResult();
while (dr.Read())
lstFields.Items.Add(dr["column_name"].ToString());

}
protected void btnExecute_Click(object sender, EventArgs e)
{
strDB = ddlDb.SelectedItem.ToString();
cnn = new SqlConnection("Data Source=.\\sqlexpress;Initial Catalog='" + strDB + "';Integrated Security=True");
cnn.Open();
{
SqlCommand smd = new SqlCommand(TextBox1.Text, cnn);
dr = smd.ExecuteReader();
{
DataTable dt = new DataTable();
dt.Load(dr);
DataGrid1.DataSource = dt;
DataGrid1.DataBind();
}
}


}
}