110,533
社区成员
发帖
与我相关
我的任务
分享
private void ChangeProcedure()//修改存储过程
{
//string text;
string sql = "use LightCtrDb exec sp_helptext AddRecord";
DataSet P_dr = new DataSet();
P_dr = G_SqlExecute.GetProcedure(sql);//将查询的内容绑定到数据集里
this.richTextBox1.Text = P_dr.GetXml();
richTextBox1.ScrollBars = RichTextBoxScrollBars.ForcedBoth;
}
string xml=ds.Tables[0].Select("TEXT")'
foreach(DataRow dr in xml)
{
richTextBox1.Text += dr[0].ToString() + "\n";;
}
private void ChangeProcedure()//修改存储过程
{
//string text;
string sql = "use LightCtrDb exec sp_helptext AddRecord";
DataSet P_dr = new DataSet();
P_dr = G_SqlExecute.GetProcedure(sql);//将查询的内容绑定到数据集里
foreach(DataRow dr in P_dr.Tables[0].Rows)
{
richTextBox1.Text += dr[0].ToString() + "\n";
}
richTextBox1.ScrollBars = RichTextBoxScrollBars.ForcedBoth;
}
XmlDocument doc = new XmlDocument();
string fileName= P_dr.GetXml();
doc.Load(fileName);
XmlElement root = doc.DocumentElement;
XmlNodeList elemList = root.GetElementsByTagName("Text");
this.richTextBox1.Text = System.Text.RegularExpressions.Regex.Replace(P_dr.GetXml(), "<\\w*>|</\\w*>", "");