|
Hi,
Can i have some link or sample program on that which u have stated as a beginner i need that....dont mistake me..
|
|
|
|
|
Hi!
In below code if dr.IsNewOrUpdated is equals to 1 I want to change the font of the text how can i do this
please help. any better suggestion to code below will be greatly appreciated
if (dr.IsNewOrUpdated != 1)
{
_ws.Cells[i, (int)ExcelColumnIndexEnum.EnglishColumn] = dr.English;
_ws.Cells[i, (int)ExcelColumnIndexEnum.TranslationColumn] = dr.Translation;
_ws.Cells[i, (int)ExcelColumnIndexEnum.ContextColumn] = dr.Context;
_ws.Cells[i, (int)ExcelColumnIndexEnum.CultureColumn] = dr.CultureCode;
_ws.Cells[i, (int)ExcelColumnIndexEnum.HFVersionNumberColumn] = dr.HFVersionNumber;
_ws.Cells[i, (int)ExcelColumnIndexEnum.ResourceSetColumn] = dr.ResourceSet;
_ws.Cells[i, (int)ExcelColumnIndexEnum.ResourceKeyColumn] = dr.ResourceKey;
}
else
{
/*Highlight the entire row or change the font of text in each cell*/
_ws.Cells[i, (int)ExcelColumnIndexEnum.EnglishColumn] = dr.English;
_ws.Cells[i, (int)ExcelColumnIndexEnum.TranslationColumn] = dr.Translation;
_ws.Cells[i, (int)ExcelColumnIndexEnum.ContextColumn] = dr.Context;
_ws.Cells[i, (int)ExcelColumnIndexEnum.CultureColumn] = dr.CultureCode;
_ws.Cells[i, (int)ExcelColumnIndexEnum.HFVersionNumberColumn] = dr.HFVersionNumber;
_ws.Cells[i, (int)ExcelColumnIndexEnum.ResourceSetColumn] = dr.ResourceSet;
_ws.Cells[i, (int)ExcelColumnIndexEnum.ResourceKeyColumn] = dr.ResourceKey;
}
|
|
|
|
|
Excel.Range.Font.Color = ColorTranslator.ToOle(Color.AliceBlue);
You can use this to change the font color.
Loading signature. Please wait...
|
|
|
|
|
thanks but how do i implement this in my case?
lets say If i want to change a particular cell color for instance
_ws.Cells[i, (int)ExcelColumnIndexEnum.EnglishColumn]
_ws means worksheet.
|
|
|
|
|
here is an answer if anyone needs.
((Range)_ws.Cells[i, (int)ExcelColumnIndexEnum.EnglishColumn]).EntireRow.Interior.Color = 16777164;//.Bold = true;
((Range)_ws.Cells[i, (int)ExcelColumnIndexEnum.EnglishColumn]).EntireRow.Borders.Color = 00000000;
|
|
|
|
|
How to retrieve Language of your current window operating system.
Like if you are working in spanish windows XP then get the language spanish.
|
|
|
|
|
Check System.Globalization.CultureInfo.CurrentCulture. It might help.
Loading signature. Please wait...
|
|
|
|
|
hi
First thanks for reply.
actually its not working
i have used
String OSLanguage =System.Globalization.CultureInfo.CurrentCulture.EnglishName;
but it is giving information of my application's language not of OS langauge.
I have to use that code which will give Language information of current running windows OS.
|
|
|
|
|
String OSLanguage =System.Globalization.CultureInfo.InstalledUICulture.EnglishName;
it is working fine
|
|
|
|
|
DateTime today;
My new instance today has new members....
I am a beginner and this might sound like a dumb question but can anyone tell me why after a create an instance of DateTime Class.....I get new members magically show up in my new instance?
Whereas DateTime has a short list of members.
Thanks
|
|
|
|
|
Possibly because you are looking at the difference between static and instance methods??
Static methods and properties can be called without an instance. Whereas, instance methods, obviously, need an instance of the object to be used.
|
|
|
|
|
I have an excel spreadsheet where i can input some data and it does a number of calculations on that data. The calculations are quite complex as they rely on the results of other calculations within the spreadsheet.
I am looking for a way to basically cut and paste the functionality and format of the spreadsheet into a C# program. I have has a little experience with datatable but i am no expert.
Is there a way that i can setup a datatable with some inputs in the first few columns and then setup expressions to populate the remainder of spreadsheet.
I am using visual studio express 2008. I know I can just use while loops but I was thinking there could be a simpler way to do it in VS
Any help would be appreciated.
modified on Tuesday, November 18, 2008 10:49 PM
|
|
|
|
|
A DataGrid or DataGridView is not a spreadsheet, nor does it work like one. You cannot put formulas in cells and expect them to work on other cells like excel does. You CAN put numbers into certain cells, but you have to provide all the code to do the calculations and put the results in whatever cells you need, then continue with more calculations as needed. Frankly, if you require that functionality, keep the stuff in Excel and write an Add-In for Excel to do whatever else you need. Google for "Visual Studio Tools for Office" for more information and downloads.
|
|
|
|
|
thanks. I thought that was the case but i just wanted to check.
|
|
|
|
|
I have a service that opens a listening tcp socket and cant get connection from remote pc. No problem with local connection.
It works fine as console app.
I tried using networkservice, localservice, localsystem but none worked.
I dont know if it works as user service - problem installing the service, with invalid user or password error although im using administrator account and have password.
Firewall is off, but should not be a problem since it works as console app.
Am I missing something?
|
|
|
|
|
do you log occurred errors?
what error do you have?
dhaim
ing ngarso sung tulodho, ing madyo mangun karso, tut wuri handayani. "Ki Hajar Dewantoro"
in the front line gave a lead, in the middle line build goodwill, in the behind give power support
|
|
|
|
|
There is no error messages. The socket can listen, but from the network, it seems that no port is listening.
|
|
|
|
|
I would like to ask what's the best way to change content of main form. I have 3 items in menu strip (Add user,Delete user,List of users) I don't want to open new window after clicking on menu strip item but i want to have only main window and change content. Thanks
|
|
|
|
|
You could put your subforms in User Controls, then just show the appropriate one when the proper button is clicked.
|
|
|
|
|
you can use what Dave said, otherwise use a classic ways, make visible/invisible panels that contains your sub form
hope it helps
dhaim
ing ngarso sung tulodho, ing madyo mangun karso, tut wuri handayani. "Ki Hajar Dewantoro"
in the front line gave a lead, in the middle line build goodwill, in the behind give power support
|
|
|
|
|
Hi All,
I've just been working on some drag and drop functionality in a C# app and came upon this exception:
Invalid FORMATETC structure (Exception from HRESULT: 0x80040064 (DV_E_FORMATETC))
This was occuring when debugging ... I would drag the item out of my app and hover over the related app in the taskbar in order to restore that apps screen to drop the item in the other application.
So I rebuilt the entire application in Release mode to test the same thing there and there is no problem. After reading a bit it seems that this is actually related to protected memory. Can I just put this down to the app being in debug mode and rest easy that it works in Release mode?
Kinda worrying when your app behaves better in Release mode ... there is always a first I guess 
|
|
|
|
|
Jammer wrote: So I rebuilt the entire application in Release mode to test the same thing there and there is no problem.
Did the error occur if you executed the Debug build without Debugging?
led mike
|
|
|
|
|
Interesting. I didn't think to try at the time, so I just did ... no error ... it must be related to the debugger.
|
|
|
|
|
How extensively are you using generic methods in your codebase? I've gone through some simple implementations like creating a generic Max() method to get the max value of different integral types.
I'd like to know the extent of the practical generic method implementations you are using in your codebase.
|
|
|
|
|
Extensively. I use them extensively.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
