本文整理汇总了C#中System.Data.SqlHelper.Query方法的典型用法代码示例。如果您正苦于以下问题:C# SqlHelper.Query方法的具体用法?C# SqlHelper.Query怎么用?C# SqlHelper.Query使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.SqlHelper
的用法示例。
在下文中一共展示了SqlHelper.Query方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
m_sqlHelper = new SqlHelper();
string P_id = Request.QueryString["P_id"];
//string P_id = "054321";
string commandText = "select distinct Paper.Introduction as 选题简介 " +
"from Paper " +
"where P_id = " + P_id;
DataTable dt = m_sqlHelper.Query(commandText);
m_introductionGridView.DataSource = dt;
m_introductionGridView.DataBind();
}
示例2: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
m_sqlHelper = new SqlHelper();
string id = Session["Id"].ToString();
string commandText = "select distinct Stu_Paper.S_id as 学号, Stu.Name as 姓名, Stu_Paper.P_id as 论文编号, Paper.Title as 论文题目, Teacher.Name as 指导老师, Stu_Paper.P_score as 论文成绩, Stu_Paper.RP_score as 答辩成绩, Stu_Paper.Total_score as 总成绩 " +
"from Stu_Paper, Stu, Teacher, Paper " +
"where Stu_Paper.S_id = " + id + " and Stu_Paper.S_id = Stu.S_id and Paper.P_id = Stu_Paper.P_id and Paper.T_id = Teacher.T_id";
DataTable dt = m_sqlHelper.Query(commandText);
if (dt.Rows.Count != 0)
{
m_Grade_StuIdLabel.Text = dt.Rows[0][0].ToString();
m_Grade_StuNameLabe1.Text = dt.Rows[0][1].ToString();
m_Grade_TitleIdLabel.Text = dt.Rows[0][2].ToString();
m_Grade_TitleNameLabel.Text = dt.Rows[0][3].ToString();
m_Grade_AdvisorLabel.Text = dt.Rows[0][4].ToString();
m_Grade_PaperGradeLabel.Text = dt.Rows[0][5].ToString();
m_Grade_DefenceGradeLabel.Text = dt.Rows[0][6].ToString();
m_Grade_TotalGradeLabel.Text = dt.Rows[0][7].ToString();
}
}