使用C#实现数据导入数据库
来源:百度知道 编辑:UC知道 时间:2024/07/02 08:06:43
我在网吧,远程没用,没有开发程序,你直接写出代码来给我就好,可以么?
一共3个文件
sql:
create database userReg
2use userReg
3
4create table users
5(
6 userName varchar(20) primary key,
7 userPwd varchar(20) not null
8)
9
10insert into users values('admin','admin')
11
12create procedure checkUserName
13@userName varchar(20)
14as
15select count(*) from users
16where userName=@userName
17go
18
19create procedure insertUsers
20@userName varchar(20),
21@userPwd varchar(20)
22as
23insert into users values(@userName,@userPwd)
24return
25go
26
27select * from users
28
29
Connection.cs
1using System;
2using System.Data;
3using System.Configuration;
4using System.Web;
5using System.Web.Security;
6using System.Web.UI;
7using System.Web.UI.WebControls;
8using System.Web.UI.WebControls.WebParts;
9using System.Web.UI.HtmlControls