// insertds.cs using System; using System.Data; using System.Data.SqlClient; public class InsertFromDataSet { public static void Main() { string connStr = "Server=(local)\\NetSDK;" + "Trusted_Connection=yes;" + "database=pubs"; string selectStr = "SELECT pub_id, pub_name FROM publishers"; // 接続用オブジェクトの作成 SqlConnection conn = new SqlConnection(); conn.ConnectionString = connStr; // select用コマンド・オブジェクトの作成 SqlCommand selectCmd = new SqlCommand(); selectCmd.Connection = conn; selectCmd.CommandText = selectStr; // データアダプタの作成 SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = selectCmd; // データセットへの読み込み DataSet ds = new DataSet(); da.Fill(ds, "publishers"); DataTable dt = ds.Tables["publishers"]; // 行の追加 DataRow newRow = dt.NewRow(); newRow["pub_id"] = "9990"; newRow["pub_name"] = "@IT Insider.NET"; dt.Rows.Add(newRow); // insert用コマンド・オブジェクトの作成 string insertStr = "INSERT INTO publishers(pub_id, pub_name)" + " VALUES (@PubId, @PubName)"; SqlCommand insertCmd = new SqlCommand(); insertCmd.Connection = conn; insertCmd.CommandText = insertStr; SqlParameter p1 = new SqlParameter(); p1.ParameterName = "@PubId"; p1.SourceColumn = "pub_id"; insertCmd.Parameters.Add(p1); SqlParameter p2 = new SqlParameter(); p2.ParameterName = "@PubName"; p2.SourceColumn = "pub_name"; insertCmd.Parameters.Add(p2); da.InsertCommand = insertCmd; // データベースの更新 da.Update(ds, "publishers"); } } // コンパイル方法:csc insertds.cs