private void BindDataGridFromClassLinq() { MemberOLD mem = new MemberOLD(); DataSet myReceiveDataSet = mem.GetMemberData(); DataTable myDataTable = myReceiveDataSet.Tables[0]; GridViewMemInfoLinq.DataSource = myDataTable; GridViewMemInfoLinq.DataBind(); //IEnumerable<MemberOLD> queryresult = from members in myDataTable select members; //GridViewMemInfoLinq.DataSource = queryresult; //GridViewMemInfoLinq.DataBind(); }
private void BindDataGridFromLinq() { SampleDataContext dataContext = new SampleDataContext(); //string[] val = { "memberinfo.MemberFname", "memberinfo.MemberLname" }; //GridViewMemInfoLinq.DataSource = from memberinfo in val // select memberinfo; //GridViewMemInfoLinq.DataBind(); GridViewMemInfoLinq.DataSource = from memberinfo in dataContext.Members select new { memberinfo.MemberFname, memberinfo.MemberLname, memberinfo.Phone_Nr }; GridViewMemInfoLinq.DataBind(); //GridViewMemInfoLinq.DataSource = from memberinfo in dataContext.Members // where memberinfo.MemberID==11 // select memberinfo.MemberFname; //GridViewMemInfoLinq.DataBind(); }
private void BindGridViewData_forallMember() { try { System.Configuration.Configuration rootWebConfig = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("/MyWebSiteRoot"); System.Configuration.ConnectionStringSettings connStringSQL; connStringSQL = rootWebConfig.ConnectionStrings.ConnectionStrings["DefaultConnection"]; string MyconnStr = null; if (rootWebConfig.ConnectionStrings.ConnectionStrings.Count > 0) { if (connStringSQL != null) { if (connStringSQL.ProviderName == "System.Data.SqlClient") { MyconnStr = connStringSQL.ConnectionString; SqlConnection conn = new SqlConnection(@"" + MyconnStr + ""); conn.Open(); //Image_MemberPicture.ImageUrl = ImageConverter(strBase64); SqlCommand MyCommand; string MySqlString = null; SqlDataReader dataReader; //MySqlString = "Select * FROM [NRB_MMS].[dbo].[Member] order by FAMILYID,MemberID ASC"; MySqlString = "SELECT [MemberID],[FamilyID],[MemberFname],[MemberLname]," + " [MemberAvgift],[Status],[Email_UserName], " + " [Phone_Nr] FROM [NRB_MMS].[dbo].[Member] order by FAMILYID,MemberID ASC"; //MySqlString = "SELECT PERSONLIGIMAGE FROM [NRB_MMS].[dbo].[Member] order by FAMILYID,MemberID ASC"; MyCommand = new SqlCommand(MySqlString, conn); dataReader = MyCommand.ExecuteReader(); //List<IMAGE> userImageInfobyID = dataReader.Automap<dataReader> ["PERSONLIGIMAGE"]; //var dt=new DataTable(); //dt.Load(dataReader); //List<IMAGE> dr=dt.AsEnumerable().ToList(); ////GetImageSign1FromImageByID //IMAGE TheValue = userImageInfobyID.FirstOrDefault(); //if (TheValue != null) //{ // //GridView_Info.Visible = false; // //GridView_Info.DataSource = userImageInfobyID; // //GridView_Info.DataBind(); // GridView_Info.Visible = false; // Repeater1.Visible = true; // Repeater1.DataSource = userImageInfobyID; // Repeater1.DataBind(); //} //MyCommand.Parameters.AddWithValue("@user", TextBox_UserName.Text); GridViewMemInfoLinq.DataSource = null; GridViewMemInfoLinq.DataBind(); if (dataReader.HasRows) { GridViewMemInfoLinq.Visible = true; GridViewMemInfoLinq.DataSource = dataReader; GridViewMemInfoLinq.DataBind(); } dataReader.Close(); dataReader.Dispose(); } else { Response.Write("<script LANGUAGE='JavaScript' >alert('Ingen information hittades!')</script>"); //dataReader.Close(); //MyCommand.Dispose(); } } } } catch (Exception ex) { throw new ApplicationException(ex.Message.ToString()); } //IsSearch_MemberID = 1; }