private void todaysMiscal()
{
string userid = Session["MarketingUser"].ToString();
string sql2 = "select sim_no,IMEINO from [Come2myCityDB].[come2mycity].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 = System.DateTime.Now.ToShortDateString();
date = cc.ChangeDt2(date);
lblCalc.Visible = true;
string sql1 = "select count(*) from Connection1 where p1='" + sim + "' and MIMENumber='" + IMEINo + "'";
lblCalulate.Text = cc.ExecuteScalar(sql1);
string sql = "select * from Connection1 where p1='" + sim + "' and MIMENumber='" + IMEINo + "'";
DataSet ds = cc.ExecuteDataset(sql);
gvLongCodeshow.DataSource = ds.Tables[0];
gvLongCodeshow.DataBind();
}
