Web 服务应用程序,实现增删改查功能
SqlServer2008 创建数据库以及表的代码
use master;
create database MyDatabase;
use MyDatabase;
//创建表
create table teacher(
t_no int primary key,
t_name varchar(8) not null,
t_sex char(2),
t_salary money,
d_no char(2) not null,
t_remark varchar(200)
);
//插入几条数据
insert into teacher values('1','2','3','4','5','6');
insert into teacher values('2','黄家驹','男','400.00','55','唱歌很厉害');
insert into teacher values('3','黄家驹','男','400.00','55','唱歌很厉害');
C# 代码:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
namespace SQLSIDU001
{
public partial class WebForm1 : System.Web.UI.Page