[Solved] SQl CASE Statement

— ok, Was a date format issue. i used a European Date Format(dd-mm-yyyy) in my query but the system i use takes USA date Format(mm-dd-yyyy) so my query failed. ** Solution ** Select Cast(Case When EventDate <=’01/01/2016′ then ‘PreSeason’ When EventDate >=’12/31/2016′ then ‘PostSeason’ Else ‘Season’ End As Varchar(25)) as Season, EventName From tblEvent Thanks … Read more

[Solved] azure.datalake.store.AdlFileSystem not found in Spark

Presently HDInsight-Spark Clusters are not available with Azure Data Lake Storage. Once we have the support it would work seamlessly. In the mean time you can try and use ADL Analytics to the same job on ADLS using U-SQL queries. For reference please visit the link: https://azure.microsoft.com/en-us/documentation/articles/data-lake-analytics-get-started-portal/ We are working for the support and it … Read more

[Solved] Constructor that takes 1 argument

If second argument is not required then you can pass any value as var menu = new Menu (dt.Rows[0][0].Tostring(),string.Empty); Or if the value of both is to be same then pass same parameter twice as you mentioned in comment var menu = new Menu (dt.Rows[0][0].Tostring(),dt.Rows[0][0].Tostring()); 4 solved Constructor that takes 1 argument

[Solved] Battery Status in winforms

I thing that what you want to do is this: private void BatteryStatus() { System.Management.ManagementClass wmi = new System.Management.ManagementClass(“Win32_Battery”); var allBatteries = wmi.GetInstances(); foreach (var battery in allBatteries) { int estimatedChargeRemaining = Convert.ToInt32(battery[“EstimatedChargeRemaining”]); label13.Text = “Remaining:” + ” ” + estimatedChargeRemaining + ” ” + “%”; } } No need for and if statment, the … Read more

[Solved] New page for every user [closed]

You should use Sessions for each user and one the bases of Session value you must populate values for the user each user will have seperate details and each user will have different data page will be same but data will be different so user feels that he has a new page solved New page … Read more

[Solved] Android Studio not installing App on device

The reason why you re getting the error is because you have no activity to launch the app , so in your manifest file , you should specify the launcher activity This is the code <activity android:name=”.activities.ControlActivity” activity android:label=”@string/title_activity_control” android:theme=”@style/AppTheme.NoActionBar”></activity> <activity android:name=”.activities.ConnectActivity”> // here specify the the <intent-filter> <action android:name=”android.intent.action.MAIN” /> <category android:name=”android.intent.category.LAUNCHER” /> </intent-filter> … Read more

[Solved] SQL Access ” Count “? [closed]

You can’t use Count as it will do just that – count the number of records for each Name ignoring the value of tap. But you check for the values of tap and sum these matches. However, while SQL Server returns 1 for a match, Access returns -1, thus – for a universal solution – … Read more

[Solved] I am not able to understand the exact meaning of this code [closed]

From a collection of DataRows a Datarow row is selected in each instance of for each. The row[“Mins”] representing Mins column in that row which is get converted into Decimal. Then compared with DbNull.Value for null check. If the value is null then 0.0 is taken else the original value from expression Convert.ToDecimal(row[“Mins”]). Same logic … Read more

[Solved] How can i check my android device having a internet connection in android? [duplicate]

This Exception is thrown because you performing networking operation in your main Thread. Do it in your Background Thread. ie AsyncTask class Task extends AsyncTask<String, void, boolean> { private Exception exception; protected boolean doInBackground(String… xyz) { if (networkConnectivity()) { try { HttpURLConnection urlc = (HttpURLConnection) (new URL( “http://www.google.com”).openConnection()); urlc.setRequestProperty(“User-Agent”, “Test”); urlc.setRequestProperty(“Connection”, “close”); urlc.setConnectTimeout(3000); urlc.setReadTimeout(4000); urlc.connect(); … Read more

[Solved] How to list all the domains in India under one website based on categories [closed]

You just cannot list 100% of Indian websites. If I understand what you want, you want something like a Web crawler for Indian domains. Another “google”. But even big spiders like Google’s, Yahoo’s, Bing’s spiders can’t build a database of all the websites. They do this with algorithms (with partly published algorithms), but I think … Read more