日期:2014-05-17 浏览次数:20846 次
select @rownum:=@rownum+1 AS rownum,m.* from (select @rownum:=0) r,teeker_manu_labels m where m.status=1 and m.batch_id=627
public static DataTable getData(string sql)
{
MySqlConnection conn = getConnection();
conn.Open();
MySqlDataAdapter da = new MySqlDataAdapter(sql, conn);
DataTable dt = new DataTable();
da.Fill(dt);
conn.Close();
return dt;
}