Ado.Net can't create Adapter ?

[jiatiejun]

I create a table in SQL 2000 with 100 columns,

want to use SqlAdapter or OleDbAdapter access it,

but I can't create Insert,Delete,Update command,

why?

How to do it?

thanks!

----->


create table kjcg (
itemid numeric identity,
item_cglb nvarchar(1) not null,
item_32 nchar(1) not null,
item_140 nchar(1) not null,
item_110 nchar(1) not null,
item_64 nvarchar(3) not null,
item_304 nchar(1) not null,
item_47 nchar(2) not null,
item_305 nchar(1) not null,
item_46 nchar(2) not null,
uid int not null,
item_21 nchar(1) not null,
item_163 nchar(1) not null,
item_200 nvarchar(15) not null,
item_51 nchar(1) not null,
item_300 nchar(1) null,
item_125 nvarchar(15) null,
item_2 nchar(1) not null,
item_126 nvarchar(50) null,
item_62 nchar(1) not null,
item_15 nvarchar(10) not null,
stateid int not null,
item_9 nvarchar(140) null,
item_41_3 nchar(2) not null,
item_12 nvarchar(12) not null,
item_16 nchar(1) not null,
item_12_1 nvarchar(12) not null,
item_63 nvarchar(3) not null,
item_33 nchar(1) not null,
item_201 nchar(1) not null,
item_124_1 nvarchar(15) null,
item_123 nchar(1) not null,
item_15_1 nvarchar(10) not null,
item_210 nchar(1) not null,
item_1 nchar(1) not null,
item_dqdm nvarchar(3) not null,
item_4 nvarchar(10) not null,
item_share bit not null,
item_year int not null,
item_upload bit not null,
item_120 nvarchar(20) null,
item_121 datetime not null,
item_125_1 nvarchar(7) null,
item_127 nvarchar(30) null,
item_128 nvarchar(80) null,
item_13 text null,
item_13_1 text null,
item_13_2 text null,
item_13_3 text null,
item_130 nvarchar(80) null,
item_131 nvarchar(1) null,
item_133 text null,
item_32_1 nvarchar(10) null,
item_14 nvarchar(200) null,
item_141 money not null,
item_142 money not null,
item_142_1 money not null,
item_142_2 money not null,
item_142_3 money not null,
item_143 money not null,
item_144 money not null,
item_145 money not null,
item_148 money not null,
item_149 money not null,
item_150 money not null,
item_151 money not null,
item_152 money not null,
item_153 money not null,
item_154 money not null,
item_160 nvarchar(30) null,
item_161 nvarchar(10) null,
item_162 money not null,
item_22 nvarchar(30) null,
item_3 nvarchar(140) null,
item_301 nvarchar(80) null,
item_302 nvarchar(14) null,
item_303 text null,
item_306 nvarchar(14) null,
item_34 nvarchar(14) null,
item_37 nvarchar(100) null,
item_38 nvarchar(6) null,
item_39 nvarchar(30) null,
item_40 nvarchar(30) null,
item_41 nvarchar(20) null,
item_41_1 nvarchar(20) null,
item_41_2 nvarchar(30) null,
item_420 nvarchar(20) null,
item_45 int not null,
item_52 nvarchar(80) null,
item_53 nvarchar(12) null,
item_56 nvarchar(12) null,
item_60 nvarchar(100) null,
item_61 nvarchar(80) null,
item_8 nvarchar(22) null,
item_sjdc nvarchar(1) null,
item_sjdr nvarchar(1) null,
item_xh money not null,
item_243 money not null,
item_244 money not null,
item_51_1 nvarchar(1) null,
item_51_2 money not null,
item_51_3 money not null,
item_151_1 money not null,
item_152_1 money not null,
constraint PK_KJCG primary key (itemid)
)
go

 

[Miha Markic [MVP C#]]

Shees, good desciptive column names
Set primary key to int instead of numeric and it should work by drag & drop
from server explorer?