如何在表格中插入值 [英] how to insert value in tabel

问题描述

我正在一个asp.net应用程序上工作..
我在使用ms sql时遇到一个问题
我想在一个表中插入值，就像我在另一个表中插入值..


就像我有一个表Test1，其中包含字段UID，fname，Lname
另一个表格Test2包含字段UID ..
我希望在Test2中插入记录时增加Test2中的UID值..

i m working on one asp.net application..
i m facing one problem while working with ms sql
i want to insert the values in one table as i insert the values in another tabel..


like i have one tabel Test1 which contain field UID,fname,Lname
and another tabel Test2 which contain field UID ..
i want UID values in Test2 get incremented as i insert in records in Test1..

推荐答案

您需要触发器...

阅读:
MSDN:触发器 [

You need triggers...

Read:
MSDN: Trigger[^]

Alternatively, if you need to add something else (you need some manual work) then you can use a stored procedure where you can have both inserts.
OR
have a transaction and commit once both the tables are updated.

Reading Good SQL book will be of great help.

尝试以下两个查询


对于table1

字符串str ==插入测试值(" + txtbox1.text +''，""+ txtbox1.text +"''....);
sqlcommand com = new sqlcommand(str，connection);
com.executenonquery();


对于表2

首先获取Uid的值

字符串str1 =从table2中选择Max(UID)";
sqlcommand com1 =新的sqlcommand(str1，connection);
int i =(convert.toint32(com.executeScaler().tostring()));
i = i + 1;

然后执行插入查询；

try following two query


For table1

String str=Insert into test values(''"+txtbox1.text+"'',''"+txtbox1.text+"''....);
sqlcommand com=new sqlcommand(str,connection);
com.executenonquery();


For table 2

first retrive the value of Uid

String str1="Select Max(UID) from table2";
sqlcommand com1=new sqlcommand(str1,connection);
int i=(convert.toint32(com.executeScaler().tostring()));
i=i+1;

then execute insert query;

这篇关于如何在表格中插入值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！