Comments by abdul subhan mohammed (Top 200 by date)

//Peek at desktop
        [DllImport("dwmapi.dll")]
        public static extern int DwmIsCompositionEnabled(out bool enabled);

        public static bool AeroEnabled()
        {
            if (Environment.OSVersion.Version.Major < 6)
                return false;

            bool result;
            DwmIsCompositionEnabled(out result);

            return result;
        }

        public static WindowsPeekAtDesktop IsPeekAtDesktop()
        {            
            return AeroEnabled() ? WindowsPeekAtDesktop.Enable : WindowsPeekAtDesktop.Disable;
        }

I tried the above code but still always its return true eventhough the PeekAtDesktop is disabled.

Please help me.

before going to call any interop action, the word file is getting blinking

the problem is not the '%' but the variable contains Arabic text for which I have to add prefix N to the variable.

Got no errors and nothing happening. I checked the log file, its working till 'File Decrypted' but its not able to communicate the web server.

To convert into the offlineResultInfo.cs

Dear, the image is on the Client's machine and your code shows server path?

Thanks for your response, I checked this code but it's not showing the Microsoft office bit version (32/64), nor the current language(English/French).

It's running after I have created one 'Create self-signed certificate'.

How can i change the font-size/color and background of the active tab?

Hi Maciej,

Could you please help me, how to get sticky notes text by using "Jesper Niedermann's .NET Blog - API for Sticky Notes in Windows 7[^]"

Does it works with windows 8/10 ??

Thanks

There are multiple tables in the excel and in the excel file, there are column and rows names.. So, how to fetch data as it having rows and column names.

how can i debug on client's machine, the visual studio is not installed on that machine.

Yes

using ajax, i'm fetching number of records and displaying one by one on button("Next")
click.

on every click on Previous or next, the question list is getting bind every time, as new.

Dear Phil,
Actually, whenever I click next or previous button, i'm getting new questionlist. Where as I want to use the same questionlist but not new one, on every click.

Dear Griff,
Actually i edited my question heading and that too is only for once. I didn't edited to get on top of the list. Please don't take me wrong. I find this website very helpful and i'm used to.
Thanks

how can i do this, plz.

can u plz help me to save this file, in the user download folder.

THANK YOU V.MUCH

protected void btnExport_Click(object sender, EventArgs e)
{
try
{
XLWorkbook workBook = new XLWorkbook();
var workSheets = workBook.Worksheets.Add("Template Questions");
var tQuestionList = SearchQuestions(1).Select(items => new
{
Code = items.ID,
Program = items.PerformanceCriteria.Outcome.Module.Program.NameEN,
Module = items.PerformanceCriteria.Outcome.Module.NameEN,
Outcome = items.PerformanceCriteria.Outcome.NameEN,
PerformanceCriteria = items.PerformanceCriteria.NameEN,
Language = items.QuestionDetails.Select(q => q.QuestionLanguage.Name).FirstOrDefault(),
QuestionText = items.QuestionDetails.Select(q => q.Details.Text.QuestionText).FirstOrDefault(),
IsActive = items.IsActive == true ? "Yes" : "No",
}).ToList();

workSheets.Cell(1, 1).Value = "Template Question";
workSheets.Cell(1, 1).AsRange().AddToNamed("Titles");
var range = workSheets.Range("A1:H1");
range.Merge();
var rangeWithStrings = workSheets.Cell(2, 1).InsertData(tQuestionList);

// Prepare the style for the titles
var titlesStyle = workBook.Style;
titlesStyle.Font.Bold = true;
titlesStyle.Font.FontColor = XLColor.White;
titlesStyle.Alignment.Horizontal = XLAlignmentHorizontalValues.Center;
titlesStyle.Fill.BackgroundColor = XLColor.Gray;

// Format all titles in one shot
workBook.NamedRanges.NamedRange("Titles").Ranges.Style = titlesStyle;

workSheets.Columns().AdjustToContents();

//Protect a sheet with a password

workBook.Protect("123");
var protection = workSheets.Protect("123");
protection.InsertRows = true;
protection.InsertColumns = true;
if (workBook.IsPasswordProtected)
{
workBook.SaveAs(@"C:\\MyFiles\\TempQuestions.xlsx");
}

}
catch (Exception ex)
{
string msg = ex.ToString();
throw;
}
}
}

Thanks karthik.
i have given ws.Protect("123"); but this one is only not allowing to edit/insert new values.

I want to protect whole excel file. Whenever user open the excel file, it should ask password. But in my case it is not asking the password.

Even i tried wb.protect("123"); this code is also not asking the password.

Could you please help me.

Thanks once again.

Yes, I know. Do you know how can I export to password protected excel.

Dear Graeme,
I know how to validate email address, but i asked, how to prompt user that the email address is not in correct format, in so and so row or rows, in CSV file?

fromDate: 05/05/2017 & ToDate: 30/07/2017

Thank you v.much Richard, after recording macro.. i got the solution. But do know to record macro for buttons like "Ribbon display","smartart", etc.

click or copy paste the url

https://ygenstorage.blob.core.windows.net/aiveo/1d8103b0-3402-4c69-a0b1-11605a303976.png

in both the questions, when i'm trying hide/show the ribbon, by code.. is not working,
nor i can't evaluate weather the ribbon is hide/shown.

Maciej, I have tried your code:
excelApplication.CommandBars.ExecuteMso("HideRibbon");
But still its not hiding the ribbon.

Hi Maciej,
I have gone through the above API but its not returning StickyNotes text. Instead, its returning clicpboardtext.

can you help me, in code for folder.

When i pressed win key, i got the start screen, at the bottom we have one more button "downArrow" when I click this button, it shows all the items, these are showing in this code: Environment.GetFolderPath(Environment.SpecialFolder.StartMenu);

but i'm looking for those items which we get when we press only win key, but not downArrow button.

could please check.

Thanks OriginalGriff, one more thing, i want to get list of items of the start menu. Could plz help me. I have tried this so far:
string appDataFolder = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData);
string startMenuPath = Environment.GetFolderPath(Environment.SpecialFolder.CommonStartMenu);
string startMenuPath1 = Environment.GetFolderPath(Environment.SpecialFolder.CommonStartup);
string startMenuPath3 = Environment.GetFolderPath(Environment.SpecialFolder.StartMenu);
string startMenuPath2 = Environment.GetFolderPath(Environment.SpecialFolder.Startup);

string[] filePaths = Directory.GetFiles(appDataFolder+ "\\Microsoft\\Internet Explorer\\Quick Launch\\User Pinned\\TaskBar", "*.lnk");
string[] csm = Directory.GetFiles(startMenuPath, "*.lnk");
string[] cs = Directory.GetFiles(startMenuPath1, "*.lnk");
string[] s = Directory.GetFiles(startMenuPath2, "*.lnk");
string[] sm = Directory.GetFiles(startMenuPath3 + "\\Programs", "*.lnk");

I'm using windows 8.1, as soon as i press win key: what are the items shows on the start menu.. i want to get that.

please help me.

Thanks once again.

I have tried removing try-catch block, but no exception has been raised.

No, i'm not setting up the value, but, i'm comparing the value with the given value.

I apologize, what you are saying is right but dear, what if my question goes to the last where only few persons will go through it.

Its an winfroms app

code
public EvaluateFontName(IQuestion question) : base(question, "Evaluate font name", new ModuleType[] { ModuleType.Word2013 })
{
DefineParameter(
"WordFile",
"The filename of the new file to be created",
false);

DefineParameter(
"Text",
"The text to be changed",
false);

DefineParameter(
"FontName",
"Font Name",
typeof(FontFamily));//FontFamily is enum, I want to display Description, instead of values.
}

Thanks Chili, But i want to display enum's description as a list, instead of enum's values. Please click on the links to check my code.

https://drive.google.com/open?id=0Bz2clgZZZsl4eUVWRUwzclBZalk

https://drive.google.com/open?id=0Bz2clgZZZsl4bWEwZllmanU4Yk0

i got stuck in Run method. How/what to check(new database/table..)?
for eg: in word, we check wordDocument, here in access what we have to check?

i apologize, i have added accesshelper.cs code, plz review.

All systems have same version of Office/Windows

added error

Yes, using Microsoft office interop from WinForms. But in some PCs its not showing the error and running perfectly.

All systems are having same version

Thanks all

thanks

The webapplication is currently running on WebServer and i have to detect when examsession is created, as soon as its created i have to send the email to the center and candidate, using windows services.

we can't assign values in case stmt,
ed.ID = @ESCID --Error
--Incorrect syntax near WHEN

i have added xml class, could u plz check.

What are the fields, i have to add, to implement this approach.

I mean, in the gui, do i have to add separate textboxes for each culture?

I have entered/added the QuizQuestion in Eng, later I have open the same page in Arabic,
now, how it will display that eng QuizQuestion in arabic for edit and changes will effect in Eng as well.

Can you please elaborate your answer?
I have not done this before, please provide in details or any link, which will help me.

Thanks

that's why, i need help to make the query sensible.

tried with find, findAll.. also

Error: does not contain a definition for FirstOrDefault

No changes in UI code

Hi karthik,

i'm filing the repeater for update, in pageload event.

When i filled check boxes(programmatically) in c#, and then unselected some checkboxes from GUI, it is giving only ',' (comma) instead of values.

where as there are some checkboxes are checked and unchecked.

can u plz help me, how to solve this.

as i'm filing candidateInfo in my list, which contains, candidate id, name, cell no, age...etc.. in the same list i want to add GroupName

Hi Richard,
yes, u r rit, but i have candidiateInfo, which contains candidate id, name, cell no, age...etc..

thanks a lot

why it is not showing the error in Chrome?

cityid contains list of city id's and where item.cityid contain single cityid

Thanks Griff

public List{TimeSlots} TimeSlotList
{
get { return _TimeSlots.Split(',').Select(DateTime.Parse).ToList(); }

set
{
TimeSlots = _TimeSlots.Remove(_TimeSlots.Length - 1);
}
}

public List{TimeSlots} TimeSlotList
{
get { return _TimeSlots.Split(',').Select(DateTime.Parse).ToList(); }

set
{
TimeSlots = _TimeSlots.Remove(_TimeSlots.Length - 1);
}
}

I want to populate in class only, as list using TimeSlot Class, get;set;

Edited:

public object SessionScheduleDates
{
get
{
string output="";
if (Session != null)
{
string input = Session.ScheduleDates;
output = "[" + "\"" + input.Replace(",", "\",\"") + "\"" + "]";
}
return output;
}
}

Javascript
<script>
var ScheduleDates = new Array();
ScheduleDates = (<%= SessionScheduleDates %>);
alert(ScheduleDates);
</script>

i tried your code, but i got only last date, "2015-09-10".

public object SessionScheduleDates
{
get
{
string output="";
if (Session != null)
{
string input = Session.ScheduleDates;
output = "\"" + input.Replace(",", "\",\"") + "\"";
}
return output;
}
}

public List<datetime> Scheduler
{
get { return ScheduleDates.Split(',').Select(item => DateTime.ParseExact(item, "yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture).ToShortDateString()).ToList(); //Error Cannot implicitly convert list<string> to list<datetiem>
}

set
{
ScheduleDates = ScheduleDates.Remove(ScheduleDates.Length - 1);
}
}

Hi karthik, i'm getting date but with time. I just want short date, how can i do this,
please let me know. Thanks

thanks alot!

could plz elobrate more

if you just wanna line to be appear on all pages, then continue drag that line in detail section.

The problem is only in my machine, if i use DateTime.now(), is working fine in other machines. so, instead of doing in coding, i want to do it, in my machine setting.

any solution without redesigning the database?

any solution for this?

i have tried with en-US as well, but the error is same

still i'm getting the same error..

updated view code

<div class="editor-field">
@Html.DropDownListFor(Model => Model.Dept, (IEnumerable<SelectListItem>)ViewBag.Dept, "Select")
@Html.ValidationMessageFor(Model => Model.Dept)
</div>

and change dept type to int.. in model

Thanks

Thank you very much, may God bless you. Hats off!

Thanks dude

But dude, i have a published server.

displaying no error

no

i have a repeater, in each row i have checkbox, i found the checkbox using its class in jquery and not able to check, whether this check box is checked or not.
hope u got me. Thanks

not working

as i mentioned above, i have 100's of rows and in each row i have 3 dropdowns(min 300 dropdowns to bind, all the time).
to bind these dropdowns using c#.. is taking more time.
so, i used ajax to bind. Its successfully bind also. But the problem is, i'm not these dropdowns values nor text.

i have to allow user to edit the values, that's why i'm using dropdownlist.

gmail n my company domain(rak.sa.com)

Dear,
i have already gone with these stuff n i tried too.
but still i didn't get, that's why i posted a question here.
Thanks

Where i have to mention the Database name?

is my insert php is correct?
because the records are not getting inserted.

i have designed only one php page, so i have only one form action.
but i have sections and in each section i have button, so when i click on particular button, particular php page should get called in form action attribute.

But i have only one php page, so one form action attribute. But number of buttons i have.

how to call particular page on particular button click.

i dont have any javascript code, when i'm using ajaxcontrols then i'm getting this error.

Thank you v.much dude

All Null values coming at most bottom of the table.
But i'm looking something like what i have drawn in the scenario table.

function error()

any other solution, other than Sessions?

I already tried this..
But it's not working

ya, i tried from the above ref but getting error.
Value cannot be null. Parameter name: url

plz help me in this:
http://www.codeproject.com/Questions/997253/How-to-Save-JQXGrid-data-into-SQL-SERVER-in-asp-ne

please help me in this:
http://www.codeproject.com/Questions/997253/How-to-Save-JQXGrid-data-into-SQL-SERVER-in-asp-ne

plz check, i have updated my tired code.

plz check, i have updated my tired code.

every time user click add button it should add data into the array.
But in my code its add only the currently passing values.

how many time button clicks, that many rows of data i want.

yes, there its not passing the arguments to the method 'data1'.
so, that's y i'm using arrays n its working but looking for serializedArrays so that user can add on every time button click.

Yes, plz help me.

how we add new row in data table, similarly i want to new row every time i click on the add button

i have updated code, plz check

updated code, plz check

i'm binding this array into the jqxgrid,
n the above code is only good to add only current data to the grid, i.e., one row only.
i'm looking for the code, which will add new line on the button click.
to bind it to the jqxgrid.

You can data above in the code, there you see i'm using asp tags.
there in data i want to use serailizeArrays(). in above formate(data).
How to convert above code into serializeArrays.
can u plz help me

http://www.codeproject.com/Questions/997144/how-to-add-data-into-arrays-on-button-click-in-jqu

I'm using Arrays n its working, but on each time i click add button its add current data only n erase the old row. any clue plz

i'm using arrays:
var data = [{ "empName": "test", "age": "67", "department": { "id": "1234", "name": "Sales" }, "author": "ravi"}];

// prepare the data
var source =
{
datatype: "json",
datafields: [
{ name: 'empName' },
{ name: 'age' },
{ name: 'id', map: 'department>id' },
{ name: 'name', map: 'department>name' },
{ name: 'author' }
],
localdata: data
};
var dataAdapter = new $.jqx.dataAdapter(source);

is it ok

Yes

Failed to load resource: the server responded with a status of 500 (Internal Server Error)

i'm getting this error:

Uncaught ReferenceError: data is not defined

please check the above link

Dude, i'm looking for the code how to pass arguments

Please help me:
http://www.codeproject.com/Questions/997063/Can-I-Pass-Arguments-In-Jqxgrid-To-Bind

Plz post your code

Do you want know, How to updated specific row in a gridview??

Plz add code for this " ddlRegItemMainGroupCodeDesc_SelectedIndexChanged " event.

more information plz??

a is ddl selected value, i'm getting a. but not in GetRef(string id)

i think error is in this line: data: "{ 'id':'" + a + "'}",

No no, not in first alert box... the undefined is coming in error one.
the GetRef(string id) is not getting its argument... i dont know why.

Undefined

its not taking the argument, which i'm passing in 'data:{id: id}' from ajax code to GetRef(string id) method... plz help me.

I have made my GetRef() as "Static" n its working now, but not taking arguments which
i'm passing from ajax code, 'data:{id: a}' and on success its not returning the result instead its returning 'object object'. Can u plz help me in this.

Thanks

http://localhost:54576/AutomobileWebApp/Default.aspx/GetRef Failed to load resource: the server responded with a status of 500 (Internal Server Error)
http://localhost:54576/resources/demos/style.css Failed to load resource: the server responded with a status of 404 (Not Found)

http://localhost:54576/AutomobileWebApp/Default.aspx/GetRef Failed to load resource: the server responded with a status of 500 (Internal Server Error)
http://localhost:54576/resources/demos/style.css Failed to load resource: the server responded with a status of 404 (Not Found)

6sec

WIN 7 64 BIT, 6 GB RAM, CORE i7.

i want to access all the class members of each class, where Programme is called in Boardcast and this Boardcast is then called in RootObject, as 'List'.

In the RootObject class i'm calling Boardcast class,
n i have created instance of RootObject also...
but now the problem is, how can i use the properties of Boardcast class.

I want to know this. Plz.

what if i bind this 'lblprice' label dynamically. Then how??

Thanks for replying, RyanDev.
I have used updatePanel for my repeater, but the problem is... the updatePanel is not finding my edit/delete button which is in the repeater in each row.

outside of the repeater its working but inside the repeater its not working...
this imagebutton is in itemtemplate of the repeater but not in header or footer

i have tried all these but still i'm not able not get button event...

Dude,
locally its running awesome, but on access from the website its getting the error.

i have typed 'telnet ip port#' n i get blank screen which means the connection connected successfully! but still i'm unable to connect to remote database.

i haved added win features for telnet, run cmd. in which i have typed 'telnet'
n its run. now to check with telnet 1433??

Thanks dude...

yes, please

its 15hr:35mins + 15hr:35mins, so why not, 31hrs:10mins

i have updated my question plz check

i have updated my question plz check

i have updated my question plz check

Dude,

the problem in the above is,

it is sum up only those who are 23.59 or not,
i mean separately, sum up 23.59 else non- 23.59 but not both...

for eg:
if we have, 15:00, 23:59, 23:59, then its sum only 15:00 or 48:00 but instead of 63:00

throwing bad result

if i enter '12:00' then it will take '12:01'

please check this link:
http://www.codeproject.com/Questions/848617/sum-of-time-in-sql-server-r

please check this link:
http://www.codeproject.com/Questions/848617/sum-of-time-in-sql-server-r

Thank you v..v.v.v..v...much Richard, thanks again.

dude i'm getting error:

CONCAT is not part of built in function

i'm using SQL SERVER 2008 R2

Declare @tb table(opt time)
insert into @tb(opt) values('15:10')
insert into @tb(opt) values('15:10')
insert into @tb(opt) values('15:10')

select * from @tb --got the values

select sum(opt) from @tb -- got the error

Msg 8117, Level 16, State 1, Line 6
Operand data type time is invalid for sum operator.

Error
Msg 241, Level 16, State 1, Line 1
Conversion failed when converting date and/or time from character string.

this updated col value to 9 in each row... instead of col value

actually i have uploaded data from excel, because of that i got white space.

01.10.01 to 01.28.80, 02.20.02 to 02.30.80.....12.02.01 to 12.28.80

i want to select b which is not matching

i want to select b, which is not matching

Thank you v.much, @DamithSL

what if i want to pass more than one parameter to javascript function: updatediff(p1, p2)

thanks a lot

i have added .cs code

still i'm getting the same error

Actually i was also facing the same problem and i tried this sol'n, it resolved it.
That's why i posted my sol'n but not for gaining the points, if u r a admin or u can contact admin, u can take all my points, make it to zero, i'm not at all concerned. Secondly i'm here just to gain others exp and want to share what i experienced.

Not a better solution

guys how to set iis app pool timeout on domain??

dude, i can uninstall it, but how can i stop user not use or configure there KASPERSKY... this website is on hosting server.

then what is the wise man string to use SQL to format data for display...

there are departments based on depts i have to increment its value

n i want to manually increment the value.

but i dont want to start from 1000 n it should to start from 0001 n then increment, plz.

Dude, I have run debug then only i came to know that it is not getting into the loop[if(!ispostback)].
I want to know why n how could i solve this, plz.

Dude, its a dropdownlist n its located in a repeater, so, if i call it from d server, then on each n every dropdownlist selection it will hit the server again n again, bcoz of this i have stored this table in the session n taking from session.
Secondly, this contains 1000's of record on which its taking time to fetch the record.
Is there any other sol'n. Please.

Dude, i have placed controls in the repeater, like dropdownlist and it has its OnSelectedIndexChanged event, i want to trigger this, of the updatepanel.

Can u plz explain me, about lnkbtncommit, how to set it n where to set.