Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Type or namespace definition, or end-of-file expected [closed]
- public partial class SeenSMS : System.Web.UI.UserControl
- {
- //temp sql connection
- //public SqlConnection mycon;
- SqlConnection mycon = new SqlConnection(@"Data Source=ASOFT20MAMUT;Initial Catalog=ViltraNew;UserID=sa;Password=sa123");
- protected void Page_Load(object sender, EventArgs e)
- {
- string[] msg_arr = Request.QueryString["arr"].Split('|');
- if (!IsPostBack)
- {
- string Moose = Request.QueryString[1];
- }
- if (msg_arr != null)
- {
- if ((msg_arr.Length == 3) && (msg_arr[1].ToLower() == "slett"))
- {
- int Hours = Convert.ToInt32(msg_arr[2]);
- if (Hours > 0)
- {
- string username = msg_arr[0];
- SqlCommand com = new SqlCommand("SELECT count(*) as count FROM Animal Where Hours=@Hours", mycon);
- com.Parameters.AddWithValue("@Hours",Hours);
- using (SqlDataReader reader = com.ExecuteReader())
- {
- if(reader.HasRows)
- {
- while (reader.Read())
- {
- // int number = Convert.ToInt32(con.ExecuteReader());
- int number = Convert.ToInt32(reader["count"]);
- }
- }
- else{
- }
- }
- }
- // if( number == 0)
- // {
- // Response.Write("Improper Plain Summaries.");
- // }
- // else
- {
- }
- }
- }
- }
- public bool number { get; set; }
- public object Hours { get; set; }}
- // public System.Collections.Specialized.NameValueCollection Moose { get; set; }
- // public string Value { get; set; }
- // public object msg_arr { get; set; }
- }
- }
- public object Hours { get; set; }}
- public object Hours { get; set; }}
Add Comment
Please, Sign In to add comment