请问这条asp语句用C#怎么写？
sql="select * from mod where right(start,1)<="&right(c,1)&" and right(end,1)>="&right(c,1)&" and left(start,6)="&left(c,6)&" and left(end,6)="&left(c,6)&" and grade=1"

用SqlCommand，你先把.Connection = 你的连接，把.CommandText = 你的SQL语句，用string格式，然后用ExecuteNonQuery()方法就可以。

       string tableCreate = @"USE student;
 CREATE TABLE login
    (身份 char(4) NOT NULL,
     帐号 varchar(15) NOT NULL,
     密码 varchar(10) NOT NULL);

INSERT INTO login Values('教师', 'admin', '123')
INSERT INTO login Values('学生', 'live41', 'welcome')
INSERT INTO login Values('学生', 'Soil', '831002')
INSERT INTO login Values('学生', 'Queenie', '831015')
";
                SqlCommand fCommand2 = new SqlCommand();
                 = tableCreate;
                fCommand2.Connection = fConn;
                fCommand2.ExecuteNonQuery();

十三楼上的寡妇----------高手啊!

我顶

大家各抒己见把，看看怎么样去帮助人家阿