展会信息港展会大全

C#显示DataTable指定行的记录属性值
来源:互联网   发布日期:2016-03-01 13:18:35   浏览:2456次  

导读: C#显示指定行的记录属性值,用DataTable中的NewRow()方法生成新的DataRow, 对新的DataRow的DataColumn对象设置数值,将新的DataRow加进DataT...

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}

赞助本站

人工智能实验室

相关热词: 开发 编程 android

AiLab云推荐
展开

热门栏目HotCates

Copyright © 2010-2024 AiLab Team. 人工智能实验室 版权所有    关于我们 | 联系我们 | 广告服务 | 公司动态 | 免责声明 | 隐私条款 | 工作机会 | 展会港