protected void Page_Load(object sender, EventArgs e) { string connetionString; SqlConnection cnn; //connetionString = @"Data Source=localhost;Initial Catalog=GUC_WEB ;User ID=sa;Password=reallyStrongPwd123"; connetionString = WebConfigurationManager.ConnectionStrings["constr"].ConnectionString; cnn = new SqlConnection(connetionString); cnn.Open(); SqlCommand ad = new SqlCommand("SELECT * FROM dbo.[User] u, dbo.Viewer v WHERE u.ID = v.ID", cnn); SqlDataAdapter da = new SqlDataAdapter(ad); DataSet ds = new DataSet(); da.Fill(ds); MSG.DataSource = ds; MSG.DataBind(); receive(); cnn.Close(); }