命令已写好,只读取一条。但是在界面怎么调用这个写在类里的方法呢。。还有这个方法到底该怎么写?public static int GetID()
{
SqlConnection conn = getConnection.getConn();
using (conn)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "select top 1 O_ID from crm_order order by O_Updatedate desc";
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
}
}
}
{
SqlConnection conn = getConnection.getConn();
using (conn)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "select top 1 O_ID from crm_order order by O_Updatedate desc";
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
}
}
}
解决方案 »
- 未能加载文件或程序集“Microsoft.Web.Extensions, Version=1.0.61025.0, Culture=neutral..............
- 在asp.net中发送邮件
- 关于用ASP.NET开发社区网站
- 关于datalist绑定时候判断数据的问题,还有一个关于乱码的问题
- 关于房屋中介管理系统C# WindowForm !!!
- 正常安装VS.NET 2003需要多久?
- 新闻发布,怎样做到图片混排
- 请教datagrid中关于模板列复选框的问题?
- 存储过程的问题!
- 来看看这是不是微软的Bug.
- 在线等,请教UpdatePanel中嵌的GridView不能触发Updating事件
- 救命啊~~~!!!
{
SqlConnection conn = getConnection.getConn();
using (conn)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "select top 1 O_ID from crm_order order by O_Updatedate desc";
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
//比如:this.TextBox1.Text = dr["字段A"].ToString();
this.TextBox2.Text = dr["O_ID"].ToString();
}
dr.close();
conn.close(); }
}
{
SqlConnection conn = getConnection.getConn();
using (conn)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "select top 1 O_ID from crm_order order by O_Updatedate desc";
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
//比如:this.TextBox1.Text = dr["字段A"].ToString();
this.TextBox2.Text = dr["O_ID"].ToString();
}
dr.close();
conn.close();
}
}
public Class A{
public static string GetID()
{
SqlConnection conn = getConnection.getConn();
using (conn)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "select top 1 O_ID from crm_order order by O_Updatedate desc";
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
string oid = string.Empty;
//读取一行
if(dr.Read())
{
oid = dr.GetString(0);
}
return oid;
}
}
}
//界面调用
string oid = string.Empty;
A a = new A();
oid=a.GetID();
this.TextBox1.text = oid;
code=C#]public Class A{
public static string GetID()
{
SqlConnection conn = getConnection.getConn();
using (conn)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "select top 1 O_ID from crm_order order by O_Updatedate desc";
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
string oid = string.Empty;
//读取一行
if(dr.Read())
{
oid = dr.GetString(0);
}
return oid;
}
}
}
//界面调用
string oid = string.Empty;
oid=A.GetID();
this.TextBox1.text = oid;[/code]