/// <summary>
/// 返回数据库连接字符串
/// </summary>
/// <returns></returns>
public static string getSqlConStr()
{
return "Data Source=local,User ID=sa,Password=sa,Initial Catalog=DatabaseName;Pooling=true;";
} /// <summary>
/// 返回一个数据库链接
/// </summary>
/// <returns></returns>
public static SqlConnection getConn()
{
SqlConnection conn = new SqlConnection(getSqlConStr());
return conn;
}
请问,上面的代码是一个类文件,我怎么调用上面的代码绑定到datagrid, 谢谢!
/// 返回数据库连接字符串
/// </summary>
/// <returns></returns>
public static string getSqlConStr()
{
return "Data Source=local,User ID=sa,Password=sa,Initial Catalog=DatabaseName;Pooling=true;";
} /// <summary>
/// 返回一个数据库链接
/// </summary>
/// <returns></returns>
public static SqlConnection getConn()
{
SqlConnection conn = new SqlConnection(getSqlConStr());
return conn;
}
请问,上面的代码是一个类文件,我怎么调用上面的代码绑定到datagrid, 谢谢!
解决方案 »
- 关于 flash 的播放等等
- [功能模块]WEB上传文件(支持断点续传)(ftp)
- SqlDataReader中如何用字符串变量来表示字段名,进而读取相应的值!
- |M| 关于数据绑定时RowDataBound问题
- 错误信息是未将对象设置到引用实例,相同的操作为什么有的机器可以成功有些就不行??
- vs2005 里WEB GridView 问题,急在线等
- 有对.net的部署打包程序熟的同仁请进!
- 对DataGrid做分页时,报错:Control 'dgrdProducts__ctl7__ctl1' of type 'DataGridLinkButton' must be placed inside a form tag with
- 谁能解决,50分就是你的^_^
- 被include的aspx页面不能使用<%@ Page…………%>,已经被include的页面也没办法包含代码隐藏文件,大家有什么比较好的解决方法吗?
- 如何自动逐行打页DataGrid显示的内容
- 注册用户生成特定的账号
那将数据库操作返回datatable 或dataset 直接绑定它的 GridView1.DataSource不就可以了吗.
假设你这个类叫class1,
参看下面代码:SqlDataAdapter da = new SqlDataAdapter("你的select语句",class1.getConn());
DataTable dt = new DataTable();
da.Fill(dt);
DataGrid1.DataSource=dt;
DataGrid1.DataBind();
SqlDataAdapter da = new SqlDataAdapter("你的select语句",class1.getConn());
DataTable dt = new DataTable();
da.Fill(dt);
DataGrid1.DataSource=dt;
DataGrid1.DataBind();SQL Server 不存在或访问被拒绝。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.SqlClient.SqlException: SQL Server 不存在或访问被拒绝。
改成下面的试试
public static string getSqlConStr()
{
return "Data Source=.,User ID=sa,Password=sa,Initial Catalog=DatabaseName;Pooling=true;";
}
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Threading;/// <summary>
/// DB 的摘要说明
/// </summary>
public class DB
{
public DB()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
public string MassageBox(string TxtMassage)
{ string str;
str = "<script language=javascript>alert('" + TxtMassage + "')</script>";
return str;
}
public Boolean Exect(string sQueryString)
{ SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["conStr"]);
conn.Open();
SqlCommand cmd = new SqlCommand(sQueryString, conn);
try
{ cmd.ExecuteNonQuery();
conn.Close();
}
catch (System.Exception e)
{ conn.Close();
return false;
}
return true;
}
public System.Data.DataSet GetDataSet(string sQueryString, string TableName)
{ SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["conStr"]);
conn.Open();
SqlDataAdapter dbAdapter = new SqlDataAdapter(sQueryString, conn);
DataSet ds = new DataSet();
dbAdapter.Fill(ds, TableName);
conn.Close();
return ds;
}
}
去这下载一个吧.本想发上来.可以提示"回复内容过长",呵呵
然后设置
datagrid.DataSource = 你返回的DataTable对象;
然后datagrid.DataBind();
即可!
好吧.我写一个简单的.你等等.
你先下个sqlhelper研究一下吧
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server">
</asp:GridView>
</div>
</form>
</body>
</html>
aspx.cs页:using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;public partial class Default9 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataTable dt = DataAccess.GetData(DataAccess.CreateCommand("select * from authors", "Data Source=.;Initial Catalog=pubs;User ID=sa;Password="));
this.GridView1.DataSource = dt;
this.GridView1.DataBind();
}
}
}
DataAccess类://这个类我写的很简单.你自己下载sqlhelper用那个吧.道理是一样的
using System;
using System.Data;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;/// <summary>
/// DataAccess
/// </summary>
public class DataAccess
{
public static DataTable GetData(SqlCommand cmd)
{
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
return dt;
} public static SqlCommand CreateCommand(string sql, string connString)
{
SqlConnection conn = new SqlConnection(connString);
SqlCommand cmd = new SqlCommand(sql,conn);
return cmd;
}
}
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server">
</asp:GridView>
</div>
</form>
</body>
</html>
aspx.cs页:using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;public partial class Default9 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataTable dt = DataAccess.GetData(DataAccess.CreateCommand("select * from authors", "Data Source=.;Initial Catalog=pubs;User ID=sa;Password="));
this.GridView1.DataSource = dt;
this.GridView1.DataBind();
}
}
}
DataAccess类://我这个类写的很简单,你自己去下载sqlhelper.cs,用那个就行了.我发这个你简单的看看吧.意思都是一样的,反正就是ado.net里边那几个类
using System;
using System.Data;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;/// <summary>
/// DataAccess
/// </summary>
public class DataAccess
{
public static DataTable GetData(SqlCommand cmd)
{
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
return dt;
} public static SqlCommand CreateCommand(string sql, string connString)
{
SqlConnection conn = new SqlConnection(connString);
SqlCommand cmd = new SqlCommand(sql,conn);
return cmd;
}
}