private void BindMessage() { string conn = ConfigurationManager.ConnectionStrings["conn"].ConnectionString; using (SqlConnection con = new SqlConnection(conn)) { using (SqlCommand cmd = new SqlCommand("select * from Message WHERE TargetID ='" + Convert.ToInt32(Session["KullaniciID"]) + "'", con)) { using (SqlDataAdapter sda = new SqlDataAdapter(cmd)) { DataTable dt = new DataTable(); sda.Fill(dt); RepMessage.DataSource = dt; RepMessage.DataBind(); } } } }
private void BindMessage() { string conn = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(conn)) { using (SqlCommand cmd = new SqlCommand(" SELECT dbo.[User].*, dbo.Message.* FROM dbo.Message INNER JOIN dbo.[User] ON dbo.Message.SenderID = dbo.[User].UserID WHERE TargetID ='" + Convert.ToInt32(Session["KullaniciID"]) + "'", con)) { using (SqlDataAdapter sda = new SqlDataAdapter(cmd)) { DataTable dt = new DataTable(); sda.Fill(dt); Session.Add("MesajSayisi", dt.Rows.Count.ToString()); //string[] msgArr = new string[dt.Rows.Count]; //for (int i = 0; i < dt.Rows.Count; i++)//bosuna ugrastin amk . //{ // string someDate = dt.Rows[i]["SendDate"].ToString(); // DateTime startDate = DateTime.Parse(someDate); // DateTime now = DateTime.Now; // TimeSpan elapsed = now.Subtract(startDate); // double daysAgo = elapsed.TotalDays; // msgArr[i]= daysAgo.ToString("0"); // //Session.Add("DaysAgo", daysAgo.ToString("0"));//item databoundda yapman lazim // //messages = Session["SeatNum"] as List<string>; //} //Session["Days"] = msgArr; RepMessage.DataSource = dt; RepMessage.DataBind(); if (dt.Rows.Count == 0) { RepMessage.Visible = false; zeroMsg.Visible = true; } } } } }