62,047
社区成员
发帖
与我相关
我的任务
分享
String ConnectionString = "Data Source=192.168.1.155;Initial Catalog=BugManage;Persist Security Info=True;User ID=sa;Password=123456";
SqlConnection MyConnection = new SqlConnection(ConnectionString);
MyConnection.Open();
string SqlString = "SELECT Pub_Roles.RoleId,Pub_Tabs.TabId"
+"FROM Pub_Roles,Log_RolTabs,Pub_Tabs"
+"AND Pub_Roles.RoleId=Log_RolTabs.RoleId"
+"AND Log_RolTabs.TabId=Pub_Tabs.TabId";
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand(SqlString, MyConnection);
DataSet ds = new DataSet();
da.Fill(ds);
MyConnection.Close();
return ds;
string SqlString = "SELECT Pub_Roles.RoleId,Pub_Tabs.TabId"
+" FROM Pub_Roles,Log_RolTabs,Pub_Tabs"
+" AND Pub_Roles.RoleId=Log_RolTabs.RoleId"
+" AND Log_RolTabs.TabId=Pub_Tabs.TabId";
string SqlString = "SELECT Pub_Roles.RoleId,Pub_Tabs.TabId "
+"FROM Pub_Roles,Log_RolTabs,Pub_Tabs "
+"WHERE Pub_Roles.RoleId=Log_RolTabs.RoleId "
+"AND Log_RolTabs.TabId=Pub_Tabs.TabId";
tring SqlString = "SELECT Pub_Roles.RoleId,Pub_Tabs.TabId "
+"FROM Pub_Roles,Log_RolTabs,Pub_Tabs "
+"AND Pub_Roles.RoleId=Log_RolTabs.RoleId "
+"AND Log_RolTabs.TabId=Pub_Tabs.TabId";