csnd怎么发图片！发代码怎么让代码变色！[code=C#][/code]怎么用！
//欢迎加入.net mvc3交流群【198031493】
/*****************************/
public partial class _Default : System.Web.UI.Page
{
private string connStr =
"Data Source={0};Initial Catalog={1};Persist Security Info=True;User ID={2};Password={3};Pooling=False;charset=utf8;" +
"MAX Pool Size=2000;Min Pool Size=1;Connection Lifetime=30;";
private string conn = ConfigurationManager.ConnectionStrings["owa"].ConnectionString;
private readonly string gettables = "select table_name from information_schema.tables where table_schema='{0}'";
private readonly string getflieds =
"select column_name name,data_type type,COLUMN_TYPE,column_comment as info,extra as auto,CHARACTER_MAXIMUM_LENGTH as len " +
"from INFORMATION_SCHEMA.COLUMNS Where table_name ='{0}' and table_schema ='{1}'";
public int z = 0;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
txt_namespace.Text = "CiWong." + txt_db.Text + ".Entities";
// BindTables();
}
}
#region DB
public DataTable GetTable(string sql)
{
conn = string.Format(connStr, txt_server.Text, txt_db.Text, txt_uid.Text, txt_pwd.Text);
DataSet ds = MySqlHelper.ExecuteDataset(conn, sql);
return ds.Tables[0];
}
public void ExecuteSql(string sql)
{
MySqlHelper.ExecuteNonQuery(conn, sql);
}
#endregion
#region select
private void SelectAll(StringBuilder Sb, DataTable dt, int count, string tablename, string proname)
{
var cb3list = Request["cb3"];
if (string.IsNullOrEmpty(cb3list))
{
Page.RegisterStartupScript("alert", "<script>alert('请选择要查询的列！')</script>");
return;
}
string[] arraycb3 = new string[] { };
arraycb3 = cb3list.Split(',');
Sb.Append("CREATE OR REPLACE Procedure pro_" + proname + "_" + tablename);
Sb.Append("\n(\n");
//
for (int i = 0; i < count; i++)
{
var fliedname = dt.Rows[i]["column_name"].ToString();
var fliedtype = dt.Rows[i]["data_type"].ToString();
var fliedlength = 0; // dt.Rows[i]["data_length"].ToString();
//显示选中
#region
if (arraycb3 != null && arraycb3.Count() > 0)
{
for (int j = 0; j < arraycb3.Count(); j++)
{
if (fliedname == arraycb3[j].ToString())
{
Sb.Append(" _" + fliedname + " out " + fliedtype + "(" + fliedlength + ")");
if (j != arraycb3.Count() - 1)
{
Sb.Append(",\n");
}
}
}
}
#endregion
}
Sb.Append("\n)\n");
Sb.Append("AS\n");
Sb.Append("BEGIN\n");
Sb.Append(" SELECT ");
for (int i = 0; i < count; i++)
{
var fliedname = dt.Rows[i]["name"].ToString();
var fliedtype = dt.Rows[i]["type"].ToString();
var fliedlength = 0; // dt.Rows[i]["data_length"].ToString();
//显示选中
#region
if (arraycb3 != null && arraycb3.Count() > 0)
{
for (int j = 0; j < arraycb3.Count(); j++)
{
if (fliedname == arraycb3[j].ToString())
{
Sb.Append("[" + fliedname + "]");
if (j != arraycb3.Count() - 1)
{
Sb.Append(",");
}
}
}
}
#endregion
}
Sb.Append(" INTO ");
for (int i = 0; i < count; i++)
{
var fliedname = dt.Rows[i]["name"].ToString();
var fliedtype = dt.Rows[i]["type"].ToString();
var fliedlength = 0; // dt.Rows[i]["data_length"].ToString();
//显示选中
#region
if (arraycb3 != null && arraycb3.Count() > 0)
{
for (int j = 0; j < arraycb3.Count(); j++)
{
if (fliedname == arraycb3[j].ToString())
{
Sb.Append("_" + fliedname);
if (j != arraycb3.Count() - 1)
{
Sb.Append(",");
}
}
}
}
#endregion
}
Sb.Append(" FROM [" + tablename + "]");
}
#endregion
#region bind
public void BindTables()
{
string sql = string.Format(gettables, txt_db.Text);
lb_tables.DataSource = GetTable(sql);
lb_tables.DataTextField = "table_name";
lb_tables.DataValueField = "table_name";
lb_tables.DataBind();
}
public void BindFlieds(string tablename)
{
gv_fileds.DataSource = GetTable(string.Format(getflieds, tablename, txt_db.Text));
gv_fileds.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
BindTables();
}
protected void lb_tables_SelectedIndexChanged(object sender, EventArgs e)
{
BindFlieds(lb_tables.SelectedItem.Text);
}
#endregion
#region 添加
void Insert()
{
#region
StringBuilder Sb = new StringBuilder();
var tablename = lb_tables.SelectedItem.Text;
var dt = GetTable(string.Format(getflieds, tablename, txt_db.Text));
var count = dt.Rows.Count;
#endregion
Sb.Append("\r\rpublic bool Insert(" + tablename + " model)");
Sb.Append("\n{\n");
#region 修改的字段
string sql = "insert into " + tablename + "(";
string paras = "";
for (int i = 0; i < count; i++)
{
if (dt.Rows[i]["auto"].ToString() == "auto_increment")
{
continue;
}
var fliedname = dt.Rows[i]["name"].ToString();
sql += fliedname + ",";
paras += "@" + fliedname + ",";
}
sql = sql.TrimEnd(',') + ")";
paras = paras.TrimEnd(',');
sql += " values (" + paras + ")";
#endregion
Sb.Append("string sql=\"" + sql + "\";");
Sb.Append("\rMySqlParameter[] parameters = {");
#region 条件
int c = 0;
string conndetion = "";
for (int i = 0; i < count; i++)
{
if (dt.Rows[i]["auto"].ToString() == "auto_increment")
{
continue;
}
var fliedname = dt.Rows[i]["name"].ToString();
var fliedtype = dt.Rows[i]["type"].ToString();
var fliedlen = (dt.Rows[i]["len"] ?? "").ToString();
#region 参数
string len = "";
if (!string.IsNullOrWhiteSpace(fliedlen))
{
len += "," + fliedlen;
}
Sb.Append("\r\t new MySqlParameter(\"@" + fliedname + "\", " + GetSqlType(fliedtype) + len + ")");
Sb.Append(",");
conndetion += "\rparameters[" + c++ + "].Value = model." + fliedname + ";";
#endregion
}
string strSb = Sb.ToString().TrimEnd(',');
Sb = new StringBuilder(strSb);
#endregion
Sb.Append("\r\t\t\t\t};");
Sb.Append(conndetion);
Sb.Append("\rreturn MySqlHelper.ExecuteNonQuery(connectionString,sql,parameters)>0;");
Sb.Append("\n}\n");
txt_content.Text += Sb.ToString();
}
#endregion
#region GetModel
void GetModel()
{
#region
StringBuilder Sb = new StringBuilder();
var tablename = lb_tables.SelectedItem.Text;
var dt = GetTable(string.Format(getflieds, tablename, txt_db.Text));
var count = dt.Rows.Count;
//得到条件
var IndexID = Request["cb2"];
var SelectFlied = Request["cb3"];
if (string.IsNullOrEmpty(IndexID))
{
Page.RegisterStartupScript("alert", "<script>alert('请选择表条件!')</script>");
return;
}
if (string.IsNullOrEmpty(SelectFlied))
{
Page.RegisterStartupScript("alert", "<script>alert('请选择表查询字段!')</script>");
return;
}
#endregion
string[] arrayIndexID = new string[] { };
string[] arrayFlied = new string[] { };
arrayIndexID = IndexID.Split(',');//tiaojian
arrayFlied = SelectFlied.Split(',');
//Sb.Append("\n\n\n=============Select===============\n");
#region 条件
string conndetion = "";
for (int i = 0; i < count; i++)
{
var fliedname = dt.Rows[i]["name"].ToString();
var fliedtype = dt.Rows[i]["type"].ToString();
#region 参数
}
[code=C#][/code]
[解决办法]
点编辑器上的插入代码。。把你的代码包含进去就可以了
图片先保存到这个网站上来，然后再插入
