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;
}
