App_Code/test.cs代码:
public class test
{
public string id;
public string city;
public string cityNo;
public test()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
public static bool insertCity(test t)
{
try
{
SqlConnection con = mssql.createCon();
SqlCommand cmd = new SqlCommand("insert into Map values(@city,@cityNo);select @@identity as 'id'", con);
cmd.Parameters.Add("@city", SqlDbType.NVarChar, 20);
cmd.Parameters["@city"].Value = t.city;
cmd.Parameters.Add("@cityNo", SqlDbType.NVarChar, 20);
cmd.Parameters["@cityNo"].Value = t.cityNo;
int Cid = Convert.ToInt32(cmd.ExecuteScalar());
return true;
}
catch (Exception ex)
{
return false;
}
}
}
City.aspx.cs
protected void Button1_Click(object sender, EventArgs e)
{
test t = new test();
t.city = TextBox1.Text;
t.cityNo = Cid;//如何在这里获得test.cs里的Cid?
if (test.insertCity(t))
{
Response.Write("ok");
}
else
{
Response.Write("no");
}
public class test
{
public string id;
public string city;
public string cityNo;
public test()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
public static bool insertCity(test t)
{
try
{
SqlConnection con = mssql.createCon();
SqlCommand cmd = new SqlCommand("insert into Map values(@city,@cityNo);select @@identity as 'id'", con);
cmd.Parameters.Add("@city", SqlDbType.NVarChar, 20);
cmd.Parameters["@city"].Value = t.city;
cmd.Parameters.Add("@cityNo", SqlDbType.NVarChar, 20);
cmd.Parameters["@cityNo"].Value = t.cityNo;
int Cid = Convert.ToInt32(cmd.ExecuteScalar());
return true;
}
catch (Exception ex)
{
return false;
}
}
}
City.aspx.cs
protected void Button1_Click(object sender, EventArgs e)
{
test t = new test();
t.city = TextBox1.Text;
t.cityNo = Cid;//如何在这里获得test.cs里的Cid?
if (test.insertCity(t))
{
Response.Write("ok");
}
else
{
Response.Write("no");
}
解决方案 »
- C# 讀取excel
- FormView + AccessDataSource 怎样向数据库插入新记录
- DataSet DataReader 效率问题
- 动态生成控件的事件如何响应呢?VB的
- [挑战高手!] DataTable_A操作问题!
- repeater显示的问题
- 请问,为什么使用OleDbCommand.ExecuteNonQuery()插入一条记录,插入成功后,返回值还是为0?
- 菜鸟小弟单位任务到了最后关头,深夜编写代码受阻求助SQL查询字符串问题(VS2003,VB.NET)
- 未将对象引用设置到对象的实例 Session对象问题
- 完了,惨啊,在IE5上运行,造成,Explorer执行非法操作。IE6下没问题,微软专家来救我
- DropDownList AutoPostBack 时报 "缺少对象" 错?请高手解答.
- 网站多语言表现形式的实现办法
SqlCommand cmd = new SqlCommand("insert into Map values(@city,@cityNo);select @@identity as 'id'", con);
cmd.Parameters.Add("@city", SqlDbType.NVarChar, 20);
cmd.Parameters["@city"].Value = t.city;
cmd.Parameters.Add("@cityNo", SqlDbType.NVarChar, 20);
cmd.Parameters["@cityNo"].Value = t.cityNo;
t.id = Convert.ToInt32(cmd.ExecuteScalar()); if (test.insertCity(t))
{
string str=t.id; Response.Write("ok");
}
我需要得到这个ID生成一个自定义的编号.
这个自定义的编号也就是cityNo,需要在添加成功时就得到这个编号,并存入数据库.
com.Parameters.Add("@strNo", SqlDbType.NVarChar, 10);
com.Parameters["@strNo"].Value = t.id;
com.Parameters.Add("@strID", SqlDbType.Int);
com.Parameters["@strID"].Value = t.id;
com.ExecuteNonQuery();