Comments by Mathi2code

Mathi2code 7-Jul-15 9:28am View

Thanks for your reply Kaushal, the link which you have shared uses only SPServices to retrieve but I require this to be done by Angular JS only.

Mathi2code 23-Jan-15 9:29am View

Hi Tejas,
Thanks for the response.
But the solution whichever you gave was if the number of columns are fixed isn't it?
what should I do if the the AutoGenerateColumn = "true" in the my grid.

Also I want to freeze the column 0 and column 1 when we scroll horizontally.

With Regards,
Mathi

Mathi2code 21-Jan-15 8:42am View

this worked thanks

Mathi2code 21-Jan-15 6:48am View

I tried using this but got unrecognised escape sequence as build error. If I remove that escape sequence it didnt work as expected.

Mathi2code 21-Jan-15 6:46am View

I think the escape sequence is not required for dot.

Mathi2code 15-Oct-14 6:45am View

Cool Gopu raj. Thanks

Mathi2code 15-May-14 2:58am View

Thanks Bernhard.
Is there any article or link which I could follow to learn to do it?
Or do you have any idea?
If so could you please give me an idea. Since I dont have a start point in doing this.

Mathi2code 15-May-14 2:48am View

Deleted

Actually I dont have any idea how to do this.<br>
If you tell me an approach to use a third part DLL which will do Virus Scanning we can go for it.<br>
If you tell me you want to install a particular anti-virus in the system which has ability to interact with C# code I can do that.<br>
So have to decide from ideas that I get from you guys.

Mathi2code 15-May-14 2:46am View

Actually I dont have any idea how to do this.
If you tell me an approach to use a third part DLL which will do Virus Scanning we can go for it.
If you tell me you want to insall this anti-virus in the system to do such action I can do that.
So have to decide from ideas that I get from you guys.

Mathi2code 16-Apr-14 9:39am View

Hi Andrius,

Yes, I need something like this but I need to have this as dynamic. Since the XML structure will be dynamic. Meaning I cannot say column names in where condition like this.

Thanks & Regards,
Mathi.

Mathi2code 16-Apr-14 6:42am View

Hi Abinash,

Yes it is getting generated from a DataSet.
If I can insert from DataSet to Table is there an option to Merge data.
Meaning If the entry is already there update else insert.

Thanks & Regards,
Mathi

Mathi2code 31-Mar-14 6:27am View

Thanks for the suggestion Mukesh. Will think about this, but the link which you pinged has solution only for inserting BLOB to DB. But there is another part which is Reading the BLOB from DB and displaying it in the UI using C# code. Could you please help me on this.

Regards,
Mathi.

Mathi2code 25-Mar-14 1:31am View

Thanks +5.

Mathi2code 25-Mar-14 1:21am View

Thanks Maciej

Mathi2code 17-Mar-14 0:01am View

This Query resolved but in partition by need to mention only ID. I have that solution pasted below.
Thanks Prakash

Mathi2code 20-Feb-14 6:17am View

Thanks I've added an ID column to get it order by ID as suggested.

Mathi2code 19-Feb-14 8:17am View

Ok :( Thanks.

Regards,
Mathi.

Mathi2code 19-Feb-14 0:52am View

If I use distinct, it automatically does order by asc, and the result will be like below.

Allocation
Business
Country
Currency
CurrencyAUDRate
CurrencyEURRate
CurrencyUSDRate
Region

but I want in the same order as mentioned in the question. Is this possible.

Mathi2code 19-Feb-14 0:52am View

If I use distinct, it automatically does order by asc, and the result will be like below.

Allocation
Business
Country
Currency
CurrencyAUDRate
CurrencyEURRate
CurrencyUSDRate
Region

but I want in the same order as mentioned in the question. Is this possible.

Mathi2code 19-Feb-14 0:50am View

If I use distinct, it automatically does order by asc, and the result will be like below.

Allocation
Business
Country
Currency
CurrencyAUDRate
CurrencyEURRate
CurrencyUSDRate
Region

but I want in the same order as mentioned in the question. Is this possible.

Mathi2code 4-Feb-14 22:59pm View

let me try this

Mathi2code 2-Feb-14 23:04pm View

The post is related to combo box isn't it?But in Web pages I have drop down will the same work in my case.

Mathi2code 20-Jan-14 8:13am View

Thanks bro will check and update you on this.

Mathi2code 20-Jan-14 5:16am View

sure...
Will get back to you in case of any help...

Mathi2code 20-Jan-14 4:45am View

I know stored procs but reflection have to learn...

Mathi2code 20-Jan-14 4:10am View

Bro please help me in this...
I'm in desperate need of this concept...

Mathi2code 20-Jan-14 4:09am View

Deleted

Bro Could you please help me in this...
I'm in desperate need of this concept...

Mathi2code 30-Dec-13 23:58pm View

Hi Mehdi,

I'm new to sharepoint. So didn't get the point which you have mentioned. If I take the backup and restore the SQL content DB of the original sitecollection and restore the same into new environment will I get as it is like I do the back up and restore of sitecollection through sharepoint ?
Like Lists and workflows will be restored if I just restore the content DB.
Thanks & Regards,
Mathi

Mathi2code 14-Oct-13 5:16am View

I'm trying to add the namespaces but I'm unable to find it anywhere. Please let me know how to find this
using Microsoft.SqlServer.Management.Smo;
using Microsoft.SqlServer.Management.Common;

Mathi2code 13-Oct-13 23:26pm View

ok.. Actually I tried giving sa login. But it failed. Then I got to know that the sa login is disabled. And it worked fine when I created with another login.
Thanks a lot Renju.

With Regards,
Mathi

Mathi2code 11-Oct-13 3:24am View

Hi Renju,

When I use this particular code I'm getting an error saying "Create Database Access denied from MASTER database". Do I need to do something else.

Mathi2code 10-Oct-13 22:47pm View

Hi, You can use krypto tool to decrypt the password protected file but .xlsb is not supported by NPOI I could read .xlsm file. Thanks

Mathi2code 23-Sep-13 5:08am View

Thanks

Mathi2code 23-Sep-13 5:08am View

Thanks

Mathi2code 23-Sep-13 5:05am View

Thanks Gauri

Mathi2code 23-Sep-13 5:05am View

Thanks Mehdi

Mathi2code 23-Sep-13 5:05am View

Thanks Veera

Mathi2code 23-Sep-13 5:01am View

yes exactly

Mathi2code 4-Sep-13 9:28am View

I'm not getting this IExcelDataReader.
Could you please help me to refer this interface.
What namespace do I need to get this interface.

Also will this support .xlsb and .xlsm type files.
Kindly help.

Mathi2code 4-Sep-13 9:25am View

Hi, Thanks for reply.
Will NPOI supports password protected file and .xlsb file ?

Mathi2code 6-Aug-13 6:16am View

anyhow thanks a lot dude...

Mathi2code 2-Aug-13 0:20am View

Thanks a lot dude this worked for me.....
"ResolveUrl"....

May be add it as a solution I'll accept that which will get you more points

Mathi2code 1-Aug-13 8:18am View

Thanks Raja sekhar

Mathi2code 1-Aug-13 8:18am View

Thanks Sudhakar

Mathi2code 1-Aug-13 3:17am View

Thanks Maciej for the response.
I have to prefer entity framework since my requirement will be copying tables from one db to another which should happen during runtime.
So will try and let you know how it works for me...

Mathi2code 1-Aug-13 0:06am View

It is there in the physical path but when I try to right click the default image icon and open in new tab am getting an error saying file not found 404 issue. I'm not even hosting it to IIS I've just create the website appln. and clicked on debug button.

Mathi2code 30-Jul-13 23:58pm View

When I right clicked and selected Copy Image Url I'm getting this http://localhost:1311/Images/9.gif
and in my system the file is present in the folder path D:\Website1\Images\9.gif

Mathi2code 30-Jul-13 8:55am View

tried like this dr1["ImageID"] = @"http://localhost:1311/Images/HereSmiley.JPG"; the image is not loading...
Previously nothing was displaying now I'm getting a default image icon which has been broken

Mathi2code 30-Jul-13 8:52am View

tried giving like this
dr["ImageID"] = "../Images/9.gif";
still not working
but Previously nothing was displaying now I'm getting a default image icon which has been broken

Mathi2code 23-Jul-13 2:36am View

I'm pleased to do so :)

Mathi2code 23-Jul-13 2:35am View

Deleted

pleasure to do so :)

Mathi2code 23-Jul-13 2:22am View

Thanks Sampath, the first link itself worked fine.

Mathi2code 22-Jul-13 4:53am View

Maciej,

What do you mean by My virtual 5!

Mathi2code 22-Jul-13 4:52am View

Kenneth,
While saving it is saving as bytes the Datatype I have used to save excel file is Varbinary(MAX). So I think it will work...

Mathi2code 19-Jul-13 8:35am View

Thanks Tadit
Accepted and voted 5 since this really helped me to understand well.

Mathi2code 17-Jul-13 5:49am View

Thanks Tadit

Mathi2code 14-Jun-13 6:17am View

Hi Shafeequl,

Thanks for your reply . I tried with the given code but still facing same issue :-(

Mathi2code 11-Jun-13 16:23pm View

Thanks Prasad

Mathi2code 11-Jun-13 3:33am View

Thanks Jo

Mathi2code 11-Jun-13 2:00am View

Hi Prasad,
Thanks for replying. The above is completely working good.
Could you please help me out in formatting the header text and its background. Like I want to make the header text alone to be bold and its background should be some color.

Please let me know the possible way to achieve.

Mathi2code 28-May-13 2:36am View

it was helpful Thanks

Mathi2code 28-May-13 2:35am View

Thanks a lot Amey...

Mathi2code 24-May-13 4:07am View

Hi Member61 Thanks for replying and need some help
If it already stores in viewstate how to retrieve it? is there any sample for that?Lets say,
I have some 50 controls in my application so will all the values be stored in viewstate
How can store it... Please share code sample which would be great....

Mathi2code 22-May-13 13:16pm View

could you please provide me an example for using XDocument (System.Xml.Linq;)

Mathi2code 15-May-13 7:09am View

Provide the data so that it would be easy to identify the issue

Mathi2code 10-May-13 2:41am View

Thanks a lot

Mathi2code 10-May-13 0:20am View

is there a way that I can do the same in Javascript...

Mathi2code 9-May-13 0:19am View

Thanks Tadit....

Mathi2code 2-May-13 4:31am View

I want it to be loaded automatic....In that case will this work ?

Mathi2code 30-Apr-13 4:33am View

The point is the depth may be 3 or 4 or 5 or n that comes from user so based on that I need to create 'n' no. of nodes dynamically.

Mathi2code 29-Apr-13 1:32am View

Hi TrushnaK
Thanks a lot this helped. Is there anyother way without looping we can directly load a dataTable to hashtable or the vice-versa stuff

Regards,
Mathi

Mathi2code 29-Apr-13 1:29am View

Interop is easiest way but for that we require the excel to installed in our local machine. Also Each and every time when a user uses a session of excel will be opened which is another drawback which I consider. Hence I go for the link which I have added to this post. Please check that.

Regards,
Mathi

Mathi2code 22-Apr-13 5:06am View

We dont have UsedRange Properties in Excel Service I think...

Mathi2code 22-Apr-13 1:45am View

What is 'rs' here can you tell me how to populate that rs too....

Mathi2code 5-Apr-13 2:01am View

Hi Maciej,

Thanks for the response. I have updated my requirement clearly. Please help me in this. Also have an example like that you can have 'n' Excel formulae like Roundup,IsBlank,recursive IF condition etc.

With Regards,
Mathi

Mathi2code 5-Apr-13 1:59am View

Hi Jose and Kenneth,

Thanks for the response. I think my Question was not clear earlier, now I have updated it in a clear Please help me in this.

With Regards,
Mathi

Comments by Mathi2code (Top 76 by date)