private void Inboxshow()
{
string userid = Session["MarketingUser"].ToString();
string sql2 = "select sim_no,IMEINO from LongCodeRegistration where usrUserid='" + userid + "'";
DataSet dd = cc.ExecuteDataset(sql2);
string sim = Convert.ToString(dd.Tables[0].Rows[0]["sim_no"]);
string IMEINo = Convert.ToString(dd.Tables[0].Rows[0]["IMEINO"]);
string date = DateTime.Today.ToShortDateString();
date = cc.ChangeDatenewformat(date);
string sql = "select top(50)* from longCodeSmsReceve where p1='" + sim + "' and p2='" + IMEINo + "' order by id desc";
DataSet ds = cc.ExecuteDataset(sql);
gvInbox.DataSource = ds.Tables[0];
gvInbox.DataBind();
sql = "select count(*) from longCodeSmsReceve where p1='" + sim + "' and p2='" + IMEINo + "'";
lblcount.Text = cc.ExecuteScalar(sql);
}
