110,534
社区成员
发帖
与我相关
我的任务
分享
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
}
private void button1_Click(object sender, EventArgs e)
{
StringBuilder str = new StringBuilder();
int i = 0;
using (SqlConnection con = new SqlConnection("server=.;user id=sa;pwd=QQ7391420QQ;database=test"))
{
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
cmd.CommandText = "sp_helptext";
cmd.Parameters.Add(new SqlParameter("@objname", "p_select"));
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
if (i < 1)
{
str.Append(dr[0].ToString().Replace("create", "alter"));
}
else
{
str.Append(dr[0].ToString());
}
i++;
}
dr.Close();
}
textBox1.Text = str.ToString();
}
private void button2_Click(object sender, EventArgs e)
{
using (SqlConnection con = new SqlConnection("server=.;user id=sa;pwd=QQ7391420QQ;database=test"))
{
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
cmd.CommandText = textBox1.Text;
cmd.ExecuteNonQuery();
}
}
}