using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;namespace GetData { public class GetUserData
{
private string DatabaseConnection = ConfigurationSettings.AppSettings["7thDeSql"];
public DataSet GetDataMan(string ManagerTable)
{
SqlConnection myConnection = new SqlConnection(DatabaseConnection);
SqlDataAdapter myDataAdapter = new SqlDataAdapter("Select * From "+ ManagerTable +"",myConnection);
DataSet my7thDeDS = new DataSet();
myDataAdapter.Fill(my7thDeDS,ManagerTable); return my7thDeDS;
} }
}
using System.Data;
using System.Data.SqlClient;
using System.Configuration;namespace GetData { public class GetUserData
{
private string DatabaseConnection = ConfigurationSettings.AppSettings["7thDeSql"];
public DataSet GetDataMan(string ManagerTable)
{
SqlConnection myConnection = new SqlConnection(DatabaseConnection);
SqlDataAdapter myDataAdapter = new SqlDataAdapter("Select * From "+ ManagerTable +"",myConnection);
DataSet my7thDeDS = new DataSet();
myDataAdapter.Fill(my7thDeDS,ManagerTable); return my7thDeDS;
} }
}
解决方案 »
- ADO.NET的连接数据库的configure文件只能命名为app.config吗?
- 求 C#调用 FirebirdSql 存储过程实例
- rdlc报表的数据集字段的设置问题
- richtextbox如何显示.doc文件?
- 求重起IIS的code,C#,VB都行
- 请问在.NET 里面 怎么样调试出数据溢出测试啊??
- 真的没有分了求一个正则表达式
- "(^x\s*[0-9]{5}$)|(^(\([1-9][0-9]{2}\)\s)?[1-9][0-9]{2}-[0-9]{4}(\sx\s*[0-9]{5})?$)"
- 如何响应双击DataGrid事件
- 大家看看这几本书哪本比较好?
- 还是理论概念问题
- 再次求救
<%@ Import Namespace="System.Data.SqlClient" %><html>
<script language="C#" runat="server"> protected void Page_Load(Object sender, EventArgs e) {
SqlConnection myConnection = new SqlConnection("server=localhost;database=pubs;uid=sa;pwd=;");
SqlCommand myCommand = new SqlCommand("select * from Authors", myConnection); myConnection.Open(); SqlDataReader dr = myCommand.ExecuteReader(); MyDataGrid.DataSource = dr;
MyDataGrid.DataBind(); myConnection.Close();
}</script><body> <h3><font face="Verdana">Simple Select to a DataGrid Control</font></h3> <ASP:DataGrid id="MyDataGrid" runat="server"
Width="700"
BackColor="#ccccff"
BorderColor="black"
ShowFooter="false"
CellPadding=3
CellSpacing="0"
Font-Name="Verdana"
Font-Size="8pt"
HeaderStyle-BackColor="#aaaadd"
EnableViewState="false"
/></body>
</html>