自动插入数据库 [英] insert automatically in the database

问题描述

在数据库记录中如下

In database records as follows

Course   roomno  Dateofcrs
 REO      11     6/7/2013
 MFA      12     6/7/2013
 ERA      13     6/7/2013
 RM       14     6/7/2013
 EFA      21     6/7/2013
 PST      22     6/7/2013
 CL2      23     6/7/2013

i想要根据Roomno在数据库中自动插入如下;



输出如下;

i want to insert automatically Floor according to Roomno in the database as follows;

Output as follows;

Roomno     Floor
 11         1stFloor
 12         1stFloor
 13         lstFloor
 14         1stFloor
 21         2ndFloor
 22         2ndFloor
 23         2ndFloor

我怎么能用c＃。



请帮帮我。



Rgds，

Narasiman P.

for that how can i do using c#.

please help me.

Rgds,
Narasiman P.

推荐答案

像这样创建一个名为TBL_ROOM的表

Create a table named TBL_ROOM like this

TBL_ROOM
(
  ROOM_ID INT,
  ROOM_NO INT,
  FLOOR_NO INT,
  FLOOR_DISPLAY_NAME VARCHAR(20)
);

将此房间信息存储在此表格中

Store your room information in this table like this

1 11 1 1stFloor
2 12 1 1stFloor

现在只需在ROOM_NO上加入此表，即你的问题应该得到解决。



谢谢

now simply get a join to this table on ROOM_NO, your porblem shoul get resolved.

Thanks

我看到房间和楼层数量之间的依赖关系;）

I see the dependence between number of room and floor level ;)

SELECT Course, roomno, Dateofcrs, CASE
	WHEN roomno <20 THEN 'firstfloor'
	WHEN roomno >=20 THEN 'secondfloor'
	ELSE 'where am i?'
	END AS [Floor]
FROM TableName

right way : (try process data in database)
0. use SELECT :
       <pre lang="SQL">SELECT roomno , CONCAT(SUBSTRING ( roomno ,1, 1),'st floor') ... </pre>
1. use Foreign kay for 2 tables
2. use upatede statment in inset-triggers (automaticaly insert)


C# way :
0. expression field c# (dataset)
1. procedure in dataset to process rows [[foreach(row r in tbl )]]
3. use procedure application layer

这篇关于自动插入数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！