ASP.NET后置代碼（C#）中操作SQL SERVER2008數據庫

2019-11-17 03:59:27

字體：大中小

來源：轉載

供稿：網友

首先引入必要命名空間using System.Data;using System.Data.SqlClient;

向指定數據庫表中插入一條數據：

//將公告信息插入到數據庫中
SqlConnection objConnection = null;

try

{
      string strConnection = "Data Source=192.168.0.10;Initial Catalog=e_comm;Persist Security Info=True;

UserID=sa;PassWord=symsunsymsun123";
      objConnection = new SqlConnection(strConnection);

      string strSql;
      strSql = "insert into [e_comm].[dbo].[newsHistory](NEWSTITLE,THENEWS,THEAUTHOR,THESTARTDATE,THELATERDATE,VIEWINDEX,THEHEADER) values('" + title + "','" + theNews + "','" + author + "','" + starttime + "','" + latertime + "'," + theIndex + "," + theHeader + ")";

      //更新數據庫時與插入數據庫語法基本相同，只是SQL語句不同
      objConnection.Open();

      SqlCommand objSqlCommand = new SqlCommand(strSql, objConnection);
      objSqlCommand.ExecuteNonQuery();

}
catch (SqlException ex)
{ }
finally {
      objConnection.Close();
}

查詢數據庫表信息，并遍歷DATASET:

        SqlConnection objConnection = null;
        try
        {
            string strConnection = "Data Source=192.168.0.10;Initial Catalog=e_comm;Persist Security Info=True;User ID=sa;Password=symsunsymsun123";
            objConnection = new SqlConnection(strConnection);

            string strSql;
            strSql = "select top 1 * from [e_comm].[dbo].[newsHistory] order by NEWSID DESC";   //查詢ID號最大的信息記錄
            objConnection.Open();

            //SqlCommand objSqlCommand = new SqlCommand(strSql, objConnection);
            //objSqlCommand.ExecuteNonQuery();

            SqlDataAdapter da = new SqlDataAdapter(strSql,objConnection);
            // 創建一個數據集對象并填充數據
            DataSet ds = new DataSet("myTable");
            da.Fill(ds, "myTable");

            //操作DATASET將公告標題信息提取出來
            if (ds.Tables["myTable"].Rows.Count > 0)
            {
                foreach (DataTable dt in ds.Tables)
                {
                    foreach (DataRow dr in dt.Rows)
                    {
                        theLastedItem = dr["NEWSTITLE"].ToString() + "  " + dr["THESTARTDATE"].ToString();
                        theLastedId = dr["NEWSID"].ToString();
                    }
                }
            }
        }
        catch (SqlException ex)
        { }
        finally
        {
            objConnection.Close();
        }

上一篇：C# 靜態構造函數

下一篇：Java Web開發，你一定會遇到的