C#显示指定行的记录属性值，用DataTable中的NewRow()方法生成新的DataRow， 对新的DataRow的DataColumn对象设置数值，将新的DataRow加进DataTable中，创建DataSet 并调用mySqlDataAdapter的fill方法，从myDataSet中获取Customers表，具体代码如下：

view sourceprint?01using System;

02using System.Data;

03using System.Data.SqlClient;

04namespace ModifyDatabase

05{

06 public class ModifyDatabase

07 {

08 // 显示指定行的记录属性值

09 public static void DisplayDataRow(

10 DataRow myDataRow,

11 DataTable myDataTable

12 )

13 {

14 Console.WriteLine("nIn DisplayDataRow()");

15 foreach (DataColumn myDataColumn in myDataTable.Columns)

16 {

17 Console.WriteLine(myDataColumn + " = " +

18 myDataRow[myDataColumn]);

19 }

20 }

21 public static void AddDataRow(

22 DataTable myDataTable,

23 SqlDataAdapter mySqlDataAdapter,

24 SqlConnection mySqlConnection

25 )

26 {

27 Console.WriteLine("nIn AddDataRow()");

28 // 用DataTable中的NewRow()方法生成新的DataRow

29 Console.WriteLine("Calling myDataTable.NewRow()");

30 DataRow myNewDataRow = myDataTable.NewRow();

31 Console.WriteLine("myNewDataRow.RowState = " +

32 myNewDataRow.RowState);

33 // 对新的DataRow的DataColumn对象设置数值

34 myNewDataRow["CustomerID"] = "JxCOM";

35 myNewDataRow["CompanyName"] = "Jx Company";

36 myNewDataRow["Address"] = "1 Main Street";

37 // 将新的DataRow加进DataTable中

38 Console.WriteLine("Calling myDataTable.Rows.Add()");

39 myDataTable.Rows.Add(myNewDataRow);

40 Console.WriteLine("myNewDataRow.RowState = " +

41 myNewDataRow.RowState);

42 // 将新行推进数据库中

43 Console.WriteLine("Calling mySqlDataAdapter.Update()");

44 mySqlConnection.Open();

45 int numOfRows = mySqlDataAdapter.Update(myDataTable);

46 mySqlConnection.Close();

47 Console.WriteLine("numOfRows = " + numOfRows);

48 Console.WriteLine("myNewDataRow.RowState = " +

49 myNewDataRow.RowState);

50 DisplayDataRow(myNewDataRow, myDataTable);

51 }

52 public static void Main()

53 {

54 SqlConnection mySqlConnection =

55 new SqlConnection(

56 "server=localhost;database=Northwind;uid=sa;pwd=sa"

57 );

58 // 创建SELECT语句得SqlCommand对象

59 SqlCommand mySelectCommand = mySqlConnection.CreateCommand();

60 mySelectCommand.CommandText =

61 "SELECT CustomerID, CompanyName, Address " +

62 "FROM Customers " +

63 "ORDER BY CustomerID";

64 // 创建INSERT语句得SqlCommand对象

65 SqlCommand myInsertCommand = mySqlConnection.CreateCommand();

66 myInsertCommand.CommandText =

67 "INSERT INTO Customers (" +

68 " CustomerID, CompanyName, Address" +

69 ") VALUES (" +

70 " @CustomerID, @CompanyName, @Address" +

71 ")";

72 myInsertCommand.Parameters.Add("@CustomerID", SqlDbType.NChar,

73 5, "CustomerID");

74 myInsertCommand.Parameters.Add("@CompanyName", SqlDbType.NVarChar,

75 40, "CompanyName");

76 myInsertCommand.Parameters.Add("@Address", SqlDbType.NVarChar,

77 60, "Address");

78 // 创建SqlDataAdapter并设置相应属性

79 SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter();

80 mySqlDataAdapter.SelectCommand = mySelectCommand;

81 mySqlDataAdapter.InsertCommand = myInsertCommand;

82 // 创建DataSet 并调用mySqlDataAdapter的fill方法

83 DataSet myDataSet = new DataSet();

84 Console.WriteLine("Calling mySqlDataAdapter.Fill()");

85 mySqlConnection.Open();

86 int numOfRows =

87 mySqlDataAdapter.Fill(myDataSet, "Customers");

88 mySqlConnection.Close();

89 Console.WriteLine("numOfRows = " + numOfRows);

90 // 从myDataSet中获取Customers表

91 DataTable customersDataTable = myDataSet.Tables["Customers"];

92 // 在Customers表中添加新行

93 AddDataRow(customersDataTable, mySqlDataAdapter,

94 mySqlConnection);

95 }

96 }

97}

更多信息请查看IT技术专栏