其实要改的就这么几句:SqlCommand cmd = new SqlCommand("GetScheduleById", myConn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(ScheduleId);
SqlDataReader ScheduleReader = cmd.ExecuteReader();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(ScheduleId);
SqlDataReader ScheduleReader = cmd.ExecuteReader();
解决方案 »
- VS2008中,怎么测试哪个方法的性能高
- 用记事本存储信息的通讯录(菜鸟求助)
- C# 的结构定义中可不可以定义 链表
- 在TreeView中,如何让某一节点在没有子节点的情况下,也显示左边的+号
- 急!求c#客户端删除服务器图片
- WinForm里面窗口最小化的事件是什么啊?
- 急,在线等待,加载报表失败
- 自定义Dictionary
- ArrayList中的数组怎样取出来?
- 套打实现求救!
- 如何在cs里出字符串包括<%# DataBinder.Eval(Container, "DataItem.guid")%>绑定数据
- 在DataReader循环中做Update操作,总是能catch到错误,如果用DataSet就不会出错???
2、DataSet.WriteXml 方法
代码实例:
private void DemonstrateReadWriteXMLDocumentWithStreamReader()
{
// Create a DataSet with one table and two columns.
DataSet OriginalDataSet = new DataSet("dataSet");
OriginalDataSet.Namespace= "NetFrameWork";
DataTable table = new DataTable("table");
DataColumn idColumn = new DataColumn("id",
Type.GetType("System.Int32"));
idColumn.AutoIncrement= true; DataColumn itemColumn = new DataColumn("item");
table.Columns.Add(idColumn);
table.Columns.Add(itemColumn);
OriginalDataSet.Tables.Add(table); // Add ten rows.
DataRow newRow;
for(int i = 0; i < 10; i++)
{
newRow = table.NewRow();
newRow["item"]= "item " + i;
table.Rows.Add(newRow);
}
OriginalDataSet.AcceptChanges(); // Print out values of each table in the DataSet
// using the function defined below.
PrintValues(OriginalDataSet, "Original DataSet"); // Write the schema and data to an XML file.
string xmlFilename = "XmlDocument.xml"; // Use WriteXml to write the document.
OriginalDataSet.WriteXml(xmlFilename); // Dispose of the original DataSet.
OriginalDataSet.Dispose(); // Create a new DataSet.
DataSet newDataSet = new DataSet("New DataSet"); // Read the XML document into the DataSet.
newDataSet.ReadXml(xmlFilename); // Print out values of each table in the DataSet
// using the function defined below.
PrintValues(newDataSet,"New DataSet");
}
private void PrintValues(DataSet dataSet, string label)
{
Console.WriteLine("\n" + label);
foreach(DataTable table in dataSet.Tables)
{
Console.WriteLine("TableName: " + table.TableName);
foreach(DataRow row in table.Rows)
{
foreach(DataColumn column in table.Columns)
{
Console.Write("\table " + row[column] );
}
Console.WriteLine();
}
}
}