getip gi = new getip();
                    string result = gi.IPAddress();
                    SqlConnection conn = new SqlConnection();
                    conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["diagnoiseSystemConnectionString"].ConnectionString;
                    conn.Open();
                    SqlDataAdapter da = new SqlDataAdapter();
                    SqlCommand selectcmd = new SqlCommand();
                    selectcmd.Connection = conn;
                    selectcmd.CommandText = "select loginIP from getuseip where UserName='" + Login1.UserName.ToString() + "' ";
                    da.SelectCommand = selectcmd;
                    DataSet ds1 = new DataSet();
                    da.Fill(ds1, "ip");
                    int i = 0;
                    foreach(DataRow dr1 in ds1.Tables["ip"].Rows)
                    {
                        if (String.Compare(dr1[0].ToString(), result)==0) 
                        {
                            i = i + 1;
                          
                            break;
                        }

                        
                    
                    }
                    if(i==0)
                    {
                        SqlCommand selectcmd1 = new SqlCommand();
                        selectcmd.Connection = conn;
                        selectcmd1.CommandText = "select * from getuseip";
                        SqlCommand insert = new SqlCommand();
                        insert.CommandText = "insert into getuseip values(@UserName,@loginIP)";
                        insert.Connection = conn;
                        da.SelectCommand = selectcmd1;
                        da.Fill(ds1, "getuseip");
                        insert.Parameters.Add("@UserName", SqlDbType.VarChar, 50, "UserName");
                        insert.Parameters.Add("@loginIP", SqlDbType.NChar, 10, "loginIP");
                        da.InsertCommand = insert;
                        DataRow dr2 = ds1.Tables["getuseip"].NewRow();
                        dr2[0] = Login1.UserName.ToString();
                        dr2[1] = result;
                        ds1.Tables["getuseip"].Rows.Add(dr2);
                        da.Update(ds1, "getuseip");
                        SqlCommand udata1 = new SqlCommand();
                        udata1.CommandText = "Update Role,ipchange set logincount=logincount+1,ipchange=ipchange+1 where UserName=@UserName";
                        udata1.Connection = conn;
                        SqlParameter param = new SqlParameter("@UserName", Login1.UserName);
                        udata1.Parameters.Add(param);
                        udata1.ExecuteNonQuery();
                        conn.Close();
                    }

                    Login1.DestinationPageUrl = "~/Main.aspx";