菜鸟问题几个,帮帮忙

Question

Describe ur problem more clearly:)

Answer 1

动态数据库:不用控键adapter ,connection,dataset等等怎么用代码实现其连接和SQL查询?(最好有代码)

Answer 2

string Sqlstr="select * from FileCont where ID='"+id+"'";
 SqlConnection Conn=new SqlConnection("server=localhost;uid=sa;pwd=sa;database=filemange");
 SqlDataAdapter da=new SqlDataAdapter(Sqlstr,Conn);
DataSet Ds=new DataSet();
da.Fill(Ds,"tt");
建议去看看数据库方面的知识

Answer 3

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script Language="C#" runat="server">
void Page_Load()
{
string strConnection="Provider=Microsoft.Jet.OleDb.4.0;";
strConnection+=@"Data Source=D:\Microsoft Visual Studio\VB98\NWIND.MDB";
string strSQL="Select LastName,City,Country from employees;";
OleDbConnection objConnection=new OleDbConnection(strConnection);
OleDbCommand objCommand=new OleDbCommand(strSQL,objConnection);
objConnection.Open();
dgEmps.DataSource=objCommand.ExecuteReader(CommandBehavior.CloseConnection);
dgEmps.DataBind();
}
</script>
上面将数据读出填进DataGrid<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script Language="C#" runat="server">
void Page_Load()
{
string strConnection="Provider=Microsoft.Jet.OleDb.4.0;";
strConnection+=@"Data Source=D:\Microsoft Visual Studio\VB98\NWIND.MDB";
data_src.Text=strConnection;
string strSQL="SELECT FirstName,LastName FROM Employees";
string strResultsHolder="";
OleDbConnection objConnection=new OleDbConnection(strConnection);
OleDbCommand objCommand=new OleDbCommand(strSQL,objConnection);
OleDbDataReader objDataReader=null;
try
{
objConnection.Open();
con_open.Text="Connection opened successfully.<br/>";
objDataReader=objCommand.ExecuteReader();
while(objDataReader.Read()==true)
{
strResultsHolder+=objDataReader["FirstName"];
strResultsHolder+="&nbsp;";
strResultsHolder+=objDataReader["LastName"];
strResultsHolder+="<br/>";
}
objDataReader.Close();
objConnection.Close();
con_close.Text="<br/>Connection closed.<br/>";
divListEmployees.InnerHtml=strResultsHolder;
}
catch(Exception e)
{
con_open.Text="Connection faild to open successfully.<br/>";
con_close.Text=e.ToString();
}
}
</script>
上面代码是DataReader%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script Language="c#" runat="server">void Page_Load()
{
string strConnection="Provider=Microsoft.Jet.OleDb.4.0;";
strConnection+=@"Data Source=F:\Study\ASP.NET\TestDataBase\test.mdb";
data_src.Text=strConnection;
OleDbConnection objConnection=new OleDbConnection(strConnection);
try
{
objConnection.Open();
con_open.Text="Connection opened successfully.<br/>";
con_close.Text="Connection closed.<br/>";
}
catch(Exception e)
{
con_open.Text="Connection failed to open.<br/>";
con_close.Text=e.ToString();
}
}</script>
上面的代码就是不用控件代码连接数据了．你好好看看吧．希望有所启发．．：）
关于你说的C＃的资料嘛，就到以下的FTP站点下吧．
ftp://qydn.vicp.net/ftp://211.140.160.74

Answer 4

补一点．．上面代码是WebForm的．．．WinForm大同小异啦．．

Answer 5

有一本叫<C#编程思想与实践>的
我正在研究，挺不错的哈
对了关于ADO.net
string myconnstring="server=Ip;database=NorthWind;uid=sa;pwd=sa";
SqlConnection myconn=new SqlConnection(myconnstring);
SqlDataAdapter myCommand=new SqlDataAdapter("select * from Employees",myconn);
DataSet myset=new DataSet();
mycommand.fill(myset,"table");
这样就给Sql建立关联了哈！
还有于Odbc的，只要改一下就好了！
都差不多！！！！！！！！！！！