为什么老是提示已"在此范围定义了名为“sql”的局部变量。"
int id=Convert.ToInt32(ddl_bumen.SelectedValue.ToString());
//Response.Write(id);
//Response.End();
switch (id)
{
case 1:
string sql = "insert into news (u_name,title,home_phone,phone,email,conet,ip_addres) values (" + "'" + username + "','" + title + "','" + home_phone + "','" + phone + "','" + email + "','" + conet + "','" + ipddress + "')"; break;
case 2:
string sql = "insert into xinwen (u_name,title,home_phone,phone,email,conet,ip_addres) values (" + "'" + username + "','" + title + "','" + home_phone + "','" + phone + "','" + email + "','" + conet + "','" + ipddress + "')"; break;
}
string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;";
strConnection += @"Data Source=F:\news\App_Data\news.mdb";
//创建数据库连接对象
OleDbConnection myconn = new OleDbConnection(strConnection);
string sql = "insert into news (u_name,title,home_phone,phone,email,conet,ip_addres) values (" + "'" + username + "','" + title + "','" + home_phone + "','" + phone + "','" + email + "','" + conet + "','" + ipddress + "')";
//Response.Write(todydate);
//Response.End();
//打开数据库连接
myconn.Open();
//创建数据库命令
OleDbCommand mycmd = new OleDbCommand(sql, myconn);
mycmd.ExecuteNonQuery();
myconn.Close();
Response.Redirect("default.aspx");
ddl_bumen是dropdownlist控件
我是想。。如果选1使用第一个SQL联上NEW表插入数据,选2使用第二个SQL联xinwen表插入数据
请高手帮忙 --------------------编程问答-------------------- 在switch的上面写string sql = string.Empty;
然后把你case中的string sql都换成sql就可以了
基本语法问题 --------------------编程问答-------------------- 先string sql ="";
switch (id)
{
case 1:
sql = "insert into news (u_name,title,home_phone,phone,email,conet,ip_addres) values (" + " '" + username + " ', '" + title + " ', '" + home_phone + " ', '" + phone + " ', '" + email + " ', '" + conet + " ', '" + ipddress + " ')"; break;
case 2:
sql = "insert into xinwen (u_name,title,home_phone,phone,email,conet,ip_addres) values (" + " '" + username + " ', '" + title + " ', '" + home_phone + " ', '" + phone + " ', '" + email + " ', '" + conet + " ', '" + ipddress + " ')"; break;
}
这样不就可以了嘛
补充:.NET技术 , ASP.NET