protected int GetJunkerCount()
{
string SQLString;
PDPerson pp = new PDPerson();
SQLString = "select count(Obj_casetype) from [dbo].[C_Work_Object] where Obj_casetype='贩毒'";
int dt = Convert.ToInt32(pp.GetObjectBySql(SQLString).Rows[0][0]);
return dt;
}
小弟想将返回的值放进datatable中,怎么做啊???
{
string SQLString;
PDPerson pp = new PDPerson();
SQLString = "select count(Obj_casetype) from [dbo].[C_Work_Object] where Obj_casetype='贩毒'";
int dt = Convert.ToInt32(pp.GetObjectBySql(SQLString).Rows[0][0]);
return dt;
}
小弟想将返回的值放进datatable中,怎么做啊???
_Table.Columns.Add("Count");
_Table.Rows.Add(new int[]{dt});
{
return this.dbProcessor.SelectDataTable(SQLString);
}
{
get
{
if (ViewState["dt"] != null)
{
return (DataTable)ViewState["dt"];
}
else
{
return null;
}
}
set
{
ViewState["dt"] = value;
}
} protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataTable dt1 = new DataTable();
dt1.Columns.Add("count",typeof(int));
dt = dt1;
}
} protected void Button1_Click(object sender, EventArgs e)
{
DataRow dr = dt.NewRow(); dr["count"] = GetJunkerCount();
dt.Rows.Add(dr);
//省略其他……
//GridView1.DataSource = dt;
//GridView1.DataBind();
}
public DateTime SelTm(string sql)
{
DateTime tm = DateTime.Parse("2008-12-27"); DataSet ds = null;
try
{
SqlDataAdapter sda = new SqlDataAdapter(sql, Conn());
ds = new DataSet();
sda.Fill(ds);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
if (ds.Tables[0].Rows.Count > 0 && ds.Tables[0].Rows[0][0].ToString() != "")
{
tm =(DateTime) ds.Tables[0].Rows[0][0];
}
m_cnn.Close();
return tm; }