16,004,761 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View .NET questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by Subramanyam Shankar (Top 66 by date)
Subramanyam Shankar
7-May-15 13:06pm
View
Do you mean you want to set the format of columns to text?
Subramanyam Shankar
7-May-15 12:50pm
View
You can use Visual Studio setup or WIX. You have options for all those.
Subramanyam Shankar
19-Mar-15 5:03am
View
Your code should be able to handle the exceptions. Please add code to Catch the exception. The see from where the issue occurs in the stack trace. and see for which reference an object is not created and is null.
Subramanyam Shankar
18-Mar-15 12:15pm
View
Do you have knowledge of WIX Bootstrapper?
because I cannot write all the steps.
Subramanyam Shankar
18-Mar-15 4:49am
View
void CompareData(DataTable dataTab)
{
string filePath = @"F:\Book2.xlsx";
Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook xlWorkBook;
try
{
xlWorkBook = xlApp.Workbooks.Open(filePath, 0, true, 5, "", "", false, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", true, false, 0, true, 0);
Microsoft.Office.Interop.Excel.Worksheet worksheet1 = (Microsoft.Office.Interop.Excel.Worksheet)xlApp.Worksheets["Sheet1"];
//Reading for rows 10 to 15 and columns 5 to 10.
//j is used for rows
//Note:- 1st row in excel will be header values. so starting with +1.
for (int j = 10; j <16 ; j++)
{
//i is used for columns
for (int i = 5; i < 11; i++)
{
//In the datatable the row starts with 0 .so doing a subtraction.
if (dataTab.Rows[j-10][i-5] == Convert.ToString(worksheet1.Cells[j, i].Value2))
{
Console.WriteLine(dataTab.Rows[j][i]);
Console.WriteLine("Data matched");
}
else
{
Console.WriteLine("Data mismatch");
}
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
xlApp.Quit();
}
}
Subramanyam Shankar
17-Mar-15 6:48am
View
If my solution provided above is correct.Please mark as accepted.I will surely help you with this one. Will give it tomorrow.
Subramanyam Shankar
17-Mar-15 6:32am
View
You are welcome :)
Subramanyam Shankar
17-Mar-15 4:53am
View
Thanks :)
Subramanyam Shankar
16-Mar-15 13:57pm
View
Have you tried the excel interop dlls?
Subramanyam Shankar
16-Mar-15 13:54pm
View
you can get the range of cells using interop dll and change the color of specific portions in that range.
Subramanyam Shankar
16-Mar-15 13:48pm
View
if I understood it correctly you want to write data into excel and sort it and save it in excel?
Subramanyam Shankar
16-Mar-15 13:42pm
View
Please can you post your code?
Subramanyam Shankar
16-Mar-15 13:40pm
View
It is possible. Try doing it on your own if there is an error we are here to help
Subramanyam Shankar
16-Mar-15 13:38pm
View
Any errors you are getting?
Subramanyam Shankar
16-Mar-15 12:46pm
View
What language do you want the code?
Subramanyam Shankar
16-Mar-15 12:45pm
View
you logic is correct .do a string concatenation of text enter with the text in string array and reload it to the datagridview rows. Where are you stuck? You need the code ?
Subramanyam Shankar
16-Mar-15 12:40pm
View
Hi,
Do you mean a header info of a cell ?
Subramanyam Shankar
16-Mar-15 12:36pm
View
did you try with the extension .xls?
Subramanyam Shankar
16-Mar-15 12:30pm
View
Instead of casting DataTable to Excel.DataTable. Trying moving the data from DataTable to Excel.DataTable object with in a loop.
Subramanyam Shankar
16-Mar-15 12:21pm
View
Please can you share your implementation? If any issues we will help you.
Subramanyam Shankar
16-Mar-15 12:18pm
View
Instead of directly trying to implement a design pattern code the functionality.You will get a better understanding of what all things can be refactor and what design pattern can be used. So you will be the best judge to use the right design pattern.
Subramanyam Shankar
16-Mar-15 8:39am
View
declare the integers outside the try block. like I have shown above so that they will be accessible in the catch block.
Subramanyam Shankar
16-Mar-15 8:39am
View
int row;
int column;
try
{
for (Row = 22; Row <=23; Row++)
{
for (Colm = 5; Colm <= 18; Colm++)
{
excelProperties.excelCell.Set_CellIndices(Row, Colm);
string values = excelProperties.excelCell.Get_CellValue();
Assert.AreEqual("0", values);
Playback.Wait(500);
}
}
MessageBox.Show("There is no zero data in revenue input sheet");
}
catch (Exception ex)
{
MessageBox.Show("This sheet contains non zero amount, please check it in row " + Row + " and column " + Colm);
Assert.IsNull(ex, ex.Message);
}
}
Subramanyam Shankar
16-Mar-15 8:31am
View
You have rejected both the solutions. Please can you tell me what went wrong?
Subramanyam Shankar
16-Mar-15 8:16am
View
Hi,
When using multiple threads you need to be careful about the race conditions and the locks. if your table is locked then they are chances of transaction failures.So you should be able to handle those as well.
Subramanyam Shankar
16-Mar-15 8:10am
View
Can you check whether the requested resource is present in the location C:\inetpub\wwwroot\XYZ\Home.
Subramanyam Shankar
16-Mar-15 8:01am
View
If you want to call the service from the Jquery. You could use something like this. You could change the type to "POST" if you are posting something to the server.
function CallService() {
var ajaxRequest = $.ajax({
type: "GET",
url: "http://localhost:36161/Service1.svc/EmployeeDetailsByEmpNoJson",
contentType: false,
processData: false
});
ajaxRequest.done(function (xhr, textStatus) {
alert(textStatus);
});
ajaxRequest.fail(function (xhr, textStatus) {
alert(textStatus);
});
}
Subramanyam Shankar
13-Mar-15 11:48am
View
where is the code to save into database?
Subramanyam Shankar
13-Mar-15 11:37am
View
Where is the code snippet?
Subramanyam Shankar
13-Mar-15 11:36am
View
use the scroll into view . use it as cascade so that if one changes the other also changes.
Subramanyam Shankar
11-Mar-15 7:05am
View
i represents row and j represents the columns in your excel.i=1 because your row will start from 2 as the first row will have header information. j=1 because you need to start with first column "A". if you want to check data from 10th to 25th row then you need to replace the condition with for(i=10;i<=25;i++) and for(j=5;j<=8;j++).
Subramanyam Shankar
10-Mar-15 11:48am
View
I have already given the solution. The logic will work in both windows and web app.
Subramanyam Shankar
10-Mar-15 11:09am
View
The logic will work the same. it will work for UI also. If you face some issues,We are here to help you.
Subramanyam Shankar
10-Mar-15 6:12am
View
I need sometime for that. Will give the solution once I am done.
Subramanyam Shankar
10-Mar-15 6:04am
View
obvious your data set is null right. check why you are not getting the data from the database.
Subramanyam Shankar
10-Mar-15 5:07am
View
Put a check for null and the number of rows you are getting if it is not null and the rows count is > 0 then try to get data by indexing.
Subramanyam Shankar
7-Mar-15 12:32pm
View
Are you using relay command for command binding?
Subramanyam Shankar
7-Mar-15 12:22pm
View
Post your xml code
Subramanyam Shankar
7-Mar-15 12:08pm
View
Can you be more clear as to what exactly is required? All the product names will be passed to c# using this query.
Subramanyam Shankar
7-Mar-15 11:57am
View
What have you tired? Paste your code if you are tried with some issue we can help you.
Subramanyam Shankar
7-Mar-15 11:38am
View
What is the error you are getting?
Subramanyam Shankar
7-Mar-15 11:35am
View
Interesting .I'm curious to know why you are using this approach.
Subramanyam Shankar
7-Mar-15 11:33am
View
What is the issue. provide more details
Subramanyam Shankar
7-Mar-15 11:21am
View
why do you want to parse this WSDL file? create a proxy using svcutil.exe
and it will generate the proxy class with all the details you need. You don't need to parse this file.
Subramanyam Shankar
7-Mar-15 11:09am
View
Can you provide exception details please
Subramanyam Shankar
7-Mar-15 11:06am
View
read the excel and check the data in database. if both are same then display your GS. What's the issue here?
Subramanyam Shankar
7-Mar-15 10:59am
View
Can you provide more details?
Subramanyam Shankar
7-Mar-15 10:09am
View
I tried your code it did work fine. Please check once again.
Subramanyam Shankar
7-Mar-15 8:42am
View
The .net reflector converts a dll to code .it's a reverse engineering of converting a dll assembly language to C# code. you idea will not work converting a .exe how come it will help end users. Converting a .dll to C# code helps deverlopers to understand the code.
Subramanyam Shankar
7-Mar-15 1:58am
View
The example is not correct. Please check this link
http://www.codeproject.com/Tips/882256/Using-a-background-worker-in-WPF-along-with-Animat
I have written an article to do the same along with animation and without animation. You can download the code and check for your selves.Hope that's helpful :) .
Subramanyam Shankar
7-Mar-15 1:50am
View
you need to over ride the installer class and have a code to copy the xml file from your folder during installation to the destination folder.
Subramanyam Shankar
7-Mar-15 1:27am
View
You cannot return a list like that in WCF you need wrap your list of datacontracts in your message contracts and then send it. Hence it's failing.
Subramanyam Shankar
7-Mar-15 1:20am
View
Can you provide more details?
Subramanyam Shankar
6-Mar-15 10:26am
View
To auto refresh you would be doing it on some event right. Refresh the collection in view model if you have used view model. It will automatically refresh the control in UI.
Subramanyam Shankar
6-Mar-15 10:12am
View
Hi,
Can you provide more details please? what was the error you getting or if there was any error or exception? which columns were not null and whether values are coming properly.
Subramanyam Shankar
6-Mar-15 10:07am
View
Can you post the code please?
Subramanyam Shankar
6-Mar-15 7:20am
View
is this web app or windows app?
Subramanyam Shankar
6-Mar-15 7:14am
View
Hi,
Have you tried inter process communication?
Subramanyam Shankar
6-Mar-15 7:12am
View
Hi,
If I am not mistaken what you are trying to do is store the student data in an xml file instead of DB and display the details in WPF. Please let me know if my understanding correct so that I can provide solution or discuss further?
Subramanyam Shankar
6-Mar-15 7:08am
View
Can you please provide additional details of what exactly you want?
Subramanyam Shankar
6-Mar-15 6:49am
View
The right question to ask here would be why there is a time out. Please try debugging and finding the root cause of the time out or try increasing the time out of the service.If it still persists then find the root cause and fix it. You will not get the time out scenario when you use local file.
Subramanyam Shankar
6-Mar-15 6:01am
View
Can you post your xaml code?
Subramanyam Shankar
6-Mar-15 5:52am
View
Hi,
Kindly can you tell me why do you want to convert a word to text file? Why can't we use the word file for what ever processing you are doing?I just wanted to understand the scenario.
Subramanyam Shankar
6-Mar-15 1:58am
View
Hi,
Can you take a look at bootstrap.js. you can achieve it using bootstrap.js or Jquery Animation. bootstrap has specific controls which are made for this purpose.
Subramanyam Shankar
6-Mar-15 1:54am
View
Hi,
Can you check in regedit what is the location the application is installed and can you try using it?
Subramanyam Shankar
6-Mar-15 1:47am
View
Hi,
What do you mean by pagination tree view control. Do you want a lazy loading of the tree view control or you want to implement some kind of pagination in a tree view control?
Please can you provide some more details.
Show More