DataConnect cn = new DataConnect();
SqlConnection cm = cn.GetConnect();
cm.Open();
SqlCommand fn = new SqlCommand("select Users.UserID,Role.RoleID from.....); 将select得到的两个int型的数据(UserID,RoleID)添加到表User_Role中,谁能写个代码我是新手
SqlConnection cm = cn.GetConnect();
cm.Open();
SqlCommand fn = new SqlCommand("select Users.UserID,Role.RoleID from.....); 将select得到的两个int型的数据(UserID,RoleID)添加到表User_Role中,谁能写个代码我是新手
SqlDataReader dr = fb.ExecudeReader();
while(dr.read())
{
//insert into User_Role(Users.UserID,Role.RoleID) values("+dr.getint32(0)+","+dr.getint32(1)+")
}
前提是 User_Role 有 UserID,RoleID这两个字段