asp.net中如何判断sql执行成功?
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient; namespace test8_vote
{
/// <summary>
/// vote 的摘要说明。
/// </summary>
public class vote : System.Web.UI.Page
{
protected System.Web.UI.HtmlControls.HtmlTableCell TD1;
protected System.Web.UI.WebControls.Label lbltitle;
protected System.Web.UI.WebControls.RadioButtonList rbtnItems;
protected System.Web.UI.WebControls.Button btnVote;
protected System.Web.UI.WebControls.Button btnShowResult;
protected System.Web.UI.HtmlControls.HtmlGenericControl FONT1;
private string voteID="1";
private void Page_Load(object sender, System.EventArgs e)
{
//if(!this.IsPostBack)
//{
// 显示标题
//Response.Write("abc");
SqlConnection con=DB.createConnection();
con.Open();
//if (con.State==ConnectionState.Open)
//{
// Response.Write("连接成功!");
//}
SqlCommand cmd =new SqlCommand("select voteTitle from voteMaster where voteID="+this.voteID,con);
string title=Convert.ToString(cmd.ExecuteScalar());
this.lbltitle.Text=title; SqlCommand cmdItem=new SqlCommand("select voteDetailsID,voteItem from voteDetails where voteID="+this.voteID,con);
SqlDataReader sdr=cmdItem.ExecuteReader();
this.rbtnItems.DataSource=sdr;
this.rbtnItems.DataTextField="voteItem";
this.rbtnItems.DataValueField="voteDetailsID";
this.rbtnItems.DataBind();
sdr.Close();
con.Close();
// }
} 执行了以上vote.aspx程序,没能完成数据库连接。我想测试判断sql语句是否执行成功?
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient; namespace test8_vote
{
/// <summary>
/// vote 的摘要说明。
/// </summary>
public class vote : System.Web.UI.Page
{
protected System.Web.UI.HtmlControls.HtmlTableCell TD1;
protected System.Web.UI.WebControls.Label lbltitle;
protected System.Web.UI.WebControls.RadioButtonList rbtnItems;
protected System.Web.UI.WebControls.Button btnVote;
protected System.Web.UI.WebControls.Button btnShowResult;
protected System.Web.UI.HtmlControls.HtmlGenericControl FONT1;
private string voteID="1";
private void Page_Load(object sender, System.EventArgs e)
{
//if(!this.IsPostBack)
//{
// 显示标题
//Response.Write("abc");
SqlConnection con=DB.createConnection();
con.Open();
//if (con.State==ConnectionState.Open)
//{
// Response.Write("连接成功!");
//}
SqlCommand cmd =new SqlCommand("select voteTitle from voteMaster where voteID="+this.voteID,con);
string title=Convert.ToString(cmd.ExecuteScalar());
this.lbltitle.Text=title; SqlCommand cmdItem=new SqlCommand("select voteDetailsID,voteItem from voteDetails where voteID="+this.voteID,con);
SqlDataReader sdr=cmdItem.ExecuteReader();
this.rbtnItems.DataSource=sdr;
this.rbtnItems.DataTextField="voteItem";
this.rbtnItems.DataValueField="voteDetailsID";
this.rbtnItems.DataBind();
sdr.Close();
con.Close();
// }
} 执行了以上vote.aspx程序,没能完成数据库连接。我想测试判断sql语句是否执行成功?
解决方案 »
- 求一简单的SQL语句
- 关于session过期,父页面跳转到登录页的问题
- MVC中使用Iframe
- 急急急!!!一个数据库查询的问题?
- 在asp.net项目中引用自己编写的DLL怎么做?
- 求助啊~~用 response.write 导出word时 不弹出下载文件对话框 为什么呢??
- big 问题啊 !!!!
- 请问:在一个站程序中!要单独写一个类?是什么意思?
- 急急!!asp.net程序打开oracle数据库的连接出错的怪问题???
- 一定要在该行(箭头)写明onclick="bu_click"才会执行bu_click这个过程吗?li
- asp.net中如何隐藏整个datagrid?
- 请教FileUpload的问题,请大家来看看,帮帮忙!
using System;
using System.Data.SqlClient;namespace test8_vote
{
/// <summary>
/// DB 的摘要说明。
/// </summary>
public class DB
{
public DB()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
public static SqlConnection createConnection()
{ SqlConnection con=new SqlConnection("server=.;database=vote;uid=sa;pwd=;");
return con;
}
}
}