故事网问题
我这我的数据表别的几张都一样
这是数据中判断要插入那个表
use Story
if exists(select * from sysobjects where name='AddData')
drop proc AddData
go
create proc AddData
@ArctiType int, --传入参数,判断要插进那个数据库
@Title varchar(50),---标题
@Author varchar(10),---作者
@Source varchar(20),--来源
@Content text ----内容
as
if (@ArctiType =1) ----人生故事数据库
insert into StoryLife(Life_Title,Life_Author,Life_Source,Life_Text) values(@Title,@Author,@Source,@Content)
if(@ArctiType =2) ----爱情故事数据库
insert into StoryLove(Love_Title,Love_Author,Love_Source,Love_Text) values(@Title,@Author,@Source,@Content)
if(@ArctiType =3) ----幽默事数据库
insert into StoryHumor(Humor_Title,Humor_Author,Humor_Source,Humor_Text) values(@Title,@Author,@Source,@Content)
if(@ArctiType =4) ----哲理故事数据库
insert into StoryPhilosophy(Philosophy_Title,Philosophy_Author,Philosophy_Source,Philosophy_Text) values(@Title,@Author,@Source,@Content)
if(@ArctiType =5) ----求职故事数据库
insert into StoryJob(Job_Title,Job_Author,Job_Source,Job_Text) values(@Title,@Author,@Source,@Content)
if(@ArctiType =6) ----成败故事数据库
insert into StorySuccess(Success_Title,Success_Author,Success_Source,Success_Text) values(@Title,@Author,@Source,@Content)
if(@ArctiType =7) ----百姓故事数据库
insert into StoryPeople(People_Title,People_Author,People_Source,People_Text) values(@Title,@Author,@Source,@Content)
if(@ArctiType =8) ----传奇故事数据库
insert into StoryLegend(Legend_Title,Legend_Author,Legend_Source,Legend_Text) values(@Title,@Author,@Source,@Content)
if(@ArctiType =9)----鬼怪故事数据库
insert into StoryGhosts(Ghosts_Title,Ghosts_Author,Ghosts_Source,Ghosts_Text) values(@Title,@Author,@Source,@Content)
if(@ArctiType =10)----民间故事数据库
insert into StoryCivil(Civil_Title,Civil_Author,Civil_Source,Civil_Text) values(@Title,@Author,@Source,@Content)
go
求教在网页中要怎么实现选择类型插入不同的表啊
这个我自己写的
public void AddReleased(string Title,string Author,string Source,string Content )
{
SqlConnection con = constr.createcon();
con.Open();
SqlCommand com = new SqlCommand("insert into AddData values(@Tile,@Author,@Source,@Content)", con);
SqlParameter para = new SqlParameter("@Tile", SqlDbType.VarChar, 50);
para.Value =Title;
com.Parameters.Add(para);
para = new SqlParameter("@Author", SqlDbType.VarChar, 10);
para.Value =Author;
com.Parameters.Add(para);
para = new SqlParameter("@Source", SqlDbType.VarChar, 20);
para.Value = Source;
com.Parameters.Add(para);
para = new SqlParameter("@Content", SqlDbType.Text);
para.Value =Content;
com.Parameters.Add(para);
com.ExecuteNonQuery();
}
不知道怎么判断插入那个表中 --------------------编程问答-------------------- 帮顶一下,
下班了。
补充:.NET技术 , ASP.NET