62,046
社区成员
发帖
与我相关
我的任务
分享
USE [dbcoolsou]
GO
/****** 对象: Table [dbo].[tb_movie] 脚本日期: 06/12/2009 00:29:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tb_movie](
[id] [int] IDENTITY(1,1) NOT NULL,
[sname] [varchar](50) NOT NULL,
[srole] [varchar](100) NULL,
[stype] [varchar](50) NULL,
[sdetail] [varchar](1024) NULL,
[nclick] [int] NULL CONSTRAINT [DF_tb_movie_nclick] DEFAULT ((0)),
[ssitename] [varchar](20) NULL,
[ssitedomain] [varchar](250) NULL,
[ssiteurl] [varchar](250) NULL,
[nSize] [int] NULL,
[nJS] [int] NULL,
[UpdateTime] [datetime] NULL CONSTRAINT [DF_tb_movie_UpdateTime] DEFAULT (getdate()),
[sPath] [varchar](50) NOT NULL,
[sImage] [varchar](250) NULL,
[sUrlStr] [text] NULL,
CONSTRAINT [PK_tb_movie] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
using System;
using System.Data;
namespace testnet
{
public class MYDataTable: System.Data.DataTable
{
public MYDataTable()
{
Console.WriteLine("MYDataTable调用构造");
}
public void AcceptChanges()
{
base.AcceptChanges();
}
}
/// <summary>
/// Class4 的摘要说明。
/// </summary>
public class Class4
{
public Class4()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
static void Main(string[] args)
{
MYDataTable dt = GetTable();
DataRow[] drs = dt.Select(" WebName='新浪' ");
for (int i=0;i<dt.Rows.Count;i++)
{
for (int j=0;j<dt.Columns.Count;j++)
{
if (dt.Rows[i][j]=="新浪")
{
Console.Write(dt.Rows[i][j]+"\t");
dt.Rows[i][j] = "哈哈改了";
dt.AcceptChanges();
}
}
Console.WriteLine("-");
}
for (int i=0;i<drs.Length;i++)
{
Console.WriteLine(drs[i]["WebName"]);
}
Console.ReadLine();
}
static MYDataTable GetTable()
{
MYDataTable dt = new MYDataTable();
DataRow dr;
// 在表中增加字段
dt.Columns.Add("WebName", typeof(string));
dt.Columns.Add("WebUrl", typeof(string));
// 表中增加行
for (int i=0;i<10;i++)
{
dr = dt.NewRow();
dr["WebName"] = "新浪";
dr["WebUrl"] = "http://www.sina.com.cn";
dt.Rows.Add(dr);
}
for (int i=0;i<10;i++)
{
dr = dt.NewRow();
dr["WebName"] = "网易";
dr["WebUrl"] = "http://www.163.com";
dt.Rows.Add(dr);
}
for (int i=0;i<10;i++)
{
dr = dt.NewRow();
dr["WebName"] = "搜狐";
dr["WebUrl"] = "http://www.sohu.com";
dt.Rows.Add(dr);
}
return dt;
}
}
}