C#作业,悬赏80分!!!!!

Question

1,定义一个Student类，属性为String name, int age，在main方法里面生成一个Student类型的10个长度的数组，其中3个赋初值，然后生成一个带参数的方法，返回值为int(其中，如果没有找到则返回-1，如果找到则返回其在数组中的下标)，参数为String name，Student[] list

2,使用sql身份验证连接数据库，取Admin表中的符合要求的人数(要求为：用户输入的用户名和密码，Admin表中有字段：loginid nvarchar(50), loginpwd nvarchar(50))

3,使用sql身份验证连接数据库，取Student表中的所有数据(附：student表中有字段：sid, sname, ssex, sphone, saddress)

4,使用sql身份验证连接数据库，添加一条数据(附：student表中有字段：sid, sname, ssex, sphone, saddress)

5,方法为public bool AddStudent(string name)实现添加学生到Student[] list之中

6,使用SqlDataAdapter来填充DataSet

7,将查询出的数据放到DataSet中，并绑定到ComboBox的项中

8,无参方法，有参方法的定义，调用方法的方式

9,foreach语句实现遍历数组Student[] list

10,insert,update,delete,truncate语句的语法
答的好我还会加分的!!!

Answer 1

全做了，不过有些题意，不是很清楚，不知道你具体想要的
◆一题
public class student
{
private string _name;

public string Name
{
get { return _name; }
set { _name = value; }
}
private int _age;

public int Age
{
get { return _age; }
set { _age = value; }
}

}

class Program
{
public int search(string name, student[] list)
{

int i;
for ( i = 0; i < 3; i++)
{
if (list[i].Name == name)
{
break;
}

}
if (i <3)
{
return i;
}
else
{
return -1;
}
}

static void Main(string[] args)
{
student stu1 = new student();
stu1.Name = "小木1";
stu1.Age = 18;

student stu2 = new student();
stu2.Name = "小木2";
stu2.Age = 19;

student stu3 = new student();
stu3.Name = "小木3";
stu3.Age = 20;

student[] stus = new student[20];
stus[0] = stu1;
stus[1] = stu2;
stus[2] = stu3;

Program pro = new Program();
int x = pro.search("小木4",stus);

Console.WriteLine("{0}",x);

}
}

◆二，三,四题
数据库中：
create database zuxia
go
use zuxia

create table admin
(
loginid int primary key identity(1,1),
loginpwd nvarchar(50)

)
insert into admin values('123456')
insert into admin values('123456')
insert into admin values('123456')

create table student
(
sid int primary key identity(1,1),
sname varchar(50) not null,
ssex varchar(5) check(ssex='男' or ssex='女'),
sphone varchar(50) check(len(sphone)=6),
saddress varchar(50) default('四川遂宁')

)

insert into student values('小木1','男','134040',default)

select * from admin
select * from student

class DBhelper
{
public static string strcon = "server=.;uid=sa;database=zuxia;pwd=123456";

public static DataSet Commoncha(string sql)
{
SqlConnection con = new SqlConnection(strcon);
con.Open();

SqlDataAdapter baoma = new SqlDataAdapter(sql,con);
DataSet ds = new DataSet();
baoma.Fill(ds);

return ds;

}

}

private void button1_Click(object sender, EventArgs e)
{
int loginid = int.Parse(this.textBox1.Text.Trim());

String loginpwd = this.textBox2.Text.Trim();

string sql = string.Format("select * from admin where loginid={0} and loginpwd='{1}'",loginid ,loginpwd );
DataSet ds = DBhelper.Commoncha(sql);

if (ds.Tables [0].Rows.Count > 0)
{
MessageBox.Show("登录成功");
}
else
{
MessageBox.Show("登录失败");
}
}

◆五题
public class student
{
private string _name;

public string Name
{
get { return _name; }
set { _name = value; }
}
private int _age;

public int Age
{
get { return _age; }
set { _age = value; }
}

}

class Program
{
public bool AddStudent(string name,int age)
{

int count = 0;
student[] stus = new student[20];

stus[count] = new student();
stus[count].Name = name;
stus[count].Age = age;
count++;
for (int i = 0; i < count; i++)
{
Console.WriteLine("{0} {1}", stus[i].Name, stus[i].Age);
}

return true;

}

static void Main(string[] args)
{

Program pro = new Program();
if (pro.AddStudent("dd", 18))
{
Console.WriteLine("添加成功");

}

}

◆六题
class DBhelper
{
public static string strcon = "server=.;uid=sa;database=zuxia;pwd=123456";

public static DataSet Commoncha(string sql)
{
SqlConnection con = new SqlConnection(strcon);
con.Open();

SqlDataAdapter baoma = new SqlDataAdapter(sql,con);
DataSet ds = new DataSet();
baoma.Fill(ds);

return ds;

}

}

◆七题
class DBhelper
{
public static string strcon = "server=.;uid=sa;database=student;pwd=123456";

public static DataSet Commoncha(string sql)
{
SqlConnection con = new SqlConnection(strcon);
con.Open();

SqlDataAdapter baoma = new SqlDataAdapter(sql,con);
DataSet ds = new DataSet();
baoma.Fill(ds);

return ds;

}

}

public void BindXiaLa()
{
string sql = "select *from admin";

DataSet ds = DBhelper.Commoncha(sql);
this.comboBox1.DataSource = ds.Tables[0];
this.comboBox1.DisplayMember = "loginid";
this.comboBox1.ValueMember = "loginid";

}
private void Form1_Load(object sender, EventArgs e)
{

this.BindXiaLa();
}

◆八题

无参调用
#include<stido.h>
void print()
{
printf("无参调用");
}

void Main()
{
print();
}

有参调用
#include<stdio.h>
void print(int a,int b)
{
int temp;

temp=a;
a=b;
b=temp;

print("a=%d b=%d",&a,&b);
}

void Main()
{
int a=5,b=6;
print(a,b);

}

◆九题
public class student
{
private string _name;

public string Name
{
get { return _name; }
set { _name = value; }
}
private int _age;

public int Age
{
get { return _age; }
set { _age = value; }
}

}

class Program
{
public bool AddStudent(string name)
{

int count = 0;
student[] stus = new student[20];

stus[count] = new student();
stus[count].Name = name;
count++;

foreach (student stu in stus)
{
if (stu != null)
{
Console.WriteLine("{0} ", stu.Name);
}
}

return true;

}

static void Main(string[] args)
{

Program pro = new Program();
if (pro.AddStudent("dd"))
{
Console.WriteLine("添加成功");

}

}

◆十题
create table student
(
sid int primary key identity(1,1),
sname varchar(50) not null,
ssex varchar(5) check(ssex='男' or ssex='女'),
sphone varchar(50) check(len(sphone)=6),
saddress varchar(50) default('四川遂宁')

)

insert into student values('小木4','男','134040',default)
delete from student where sid=5
update student set sname ='小木' where sid=5
truncate table student

Answer 2

1
class Program
{
static void Main(string[] args)
{
Student[] students = {
new Student { Name="name",Age=1},
new Student { Name="name",Age=1},
new Student { Name="name",Age=1} ,
new Student(),
new Student(),
new Student(),
new Student(),
new Student(),
new Student(),
new Student()
};
}

}

public class Student
{
public string Name { get; set; }
public int Age { get; set; }
}

public class Find
{
public static int findStudent(string Name, Student[] list)
{
int result = -1;

for (int i = 0; i < list.Length; i++)
{
if (list[i].Name == Name)
result = i;
}
return result;
}
}
2 select count(*) from Admin where loginid="" adn loginpwd=""
3 select * from Student

些处略去N个字

追问

还有呢?

追答

今天睡觉觉了 Zzzzz~~~~

Answer 3

class program
{
此处略去N个字；
}

Answer 4

过路

Answer 5

--分没用；RMB 的说话!!!

Answer 6

........
题这么的多。。。分这么少，这可是要时间的啊！！！