如何在C#中从SQL Server设置数据。
我的班级Student:
public class student
{
public int StudentID { get; set; }
public string FirstName { get; set; }
public string LastName { get; set; }
}
我想从SQL中设置数据
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conStr"].ConnectionString);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select * From Student";
cmd.Connection = con;
DataTable datatable = new DataTable();
con.Open();
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(cmd);
sqlDataAdapter.Fill(datatable);
con.Close();
sqlDataAdapter.Dispose();
foreach (DataRow dr in datatable.Rows)
{
//Set Data: ex: student[] students=new student[];
//students=new students{StudentID=dr["ID"],FirstName=dr["FirstName"]}
// ...
}
我的代码集数据
namespace WebApi2.myapi
{
public class StudentController : ApiController
{
student[] students = new student[]
{
new student { StudentID = 1, FirstName = "Jishan", LastName = "Siddique" },
new student { StudentID = 2, FirstName = "Bharat", LastName = "Darji" },
new student { StudentID = 3, FirstName = "Ravi", LastName = "Mori" },
new student { StudentID = 4, FirstName = "Jay", LastName = "Singh" }
};
public IEnumerable<student> GetStudents()
{
return students;
}
}
}
最后:我希望得到这样的一个结果:student.StudentID = dr["ID"]; student.FirstName = dr["FirstName"]。谢谢大家观看,抱歉我的英文不好。我在谷歌上搜索了这个结果但没有找到。
Student
列表,并在循环中填充它(但在这种情况下,你可能想使用更轻量级的DataReader而不是DataSet)。 - Zohar Peled