how to write in excel cells using DataReader if a particular cell is “ReadOnly” using C# - C# Discussion Boards

Re: Error after selecting text in richtextbox

Luc Pattyn6-Jul-09 0:26

6-Jul-09 0:26

Hi
as Alan said, look at line 841.

Read the Exception text, it is there to help you. Look in particular to the first line that mentions one of your filenames, and a line number.
And tell Visual Studio to always show line numbers in edit windows (menu Tools/Options/TextEditor/AllLanguages...).

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

Report Viewer Control -

devvvy5-Jul-09 20:25

devvvy

5-Jul-09 20:25

hello

In ASP.NET, we can use Report View control to access reports on a Reporting Service instance.

Now,
(1) if I want default PDF format - i.e. without having use to click that "Export to PDF" button in reporting viewer command bar...?
(2) What if some of my own .NET process (MyReportServer.exe) wants to call SQL/Reporting Service directly to export PDF? How do I do that?

Thanks

dev

how to get only time from datetime?

swetha_insoft5-Jul-09 20:22

swetha_insoft

5-Jul-09 20:22

how to get only time from this string
string strtime="Tue-07-Jul-2009 12:00 PM";

Re: how to get only time from datetime?

SeMartens5-Jul-09 20:26

SeMartens

5-Jul-09 20:26

Well try to parse the string with DateTime.Parse() and then access DateTime.Hour and DateTime.Minutes. Have a look at http://msdn.microsoft.com/en-us/library/system.datetime.aspx[^]

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

Re: how to get only time from datetime?

Anubhava Dimri5-Jul-09 20:41

Anubhava Dimri

5-Jul-09 20:41

Set the format of time in which you want to get it.
strtime.format("dd/MM/yyyy");

If you can think then I Can.

Re: how to get only time from datetime?

himanshu25615-Jul-09 20:44

himanshu2561

5-Jul-09 20:44

Try like
(1)

string strtime = "Tue-07-Jul-2009 12:00 PM";
      strtime = strtime.Substring(strtime.IndexOf(" ")+1,strtime.Length-strtime.IndexOf(" ")-1);

(2)

DateTime dt3=DateTime.Parse(strtime);
        strtime= dt3.ToShortTimeString();

himanshu

Re: how to get only time from datetime?

stancrm5-Jul-09 20:56

stancrm

5-Jul-09 20:56

string strtime = "Tue-07-Jul-2009 12:00 PM";
string format = "ddd-dd-MMM-yyyy hh:mm tt";
CultureInfo formatProvider = new CultureInfo("en-US");
DateTime dt = DateTime.ParseExact(strtime, format, formatProvider);

Console.WriteLine(dt.ToString("hh:mm:ss tt"));

how to write in excel cells using DataReader if a particular cell is “ReadOnly” using C#

Krishna Aditya5-Jul-09 20:20

Krishna Aditya

5-Jul-09 20:20

Hi Guys,

I tried a lot to figure out how to skip writin onto a particular excel cell using C#, but couldnt get the proper logic.

my eg:
*Team Leader (required)     abcxyz     User1     user2
Customer Interface Focal     dfgidf     user23     user3*

each of the names above has to be in a particular cell... but in the excel template, first cell (Team Leader (required)) is readonly, so i cant write into that cell, so my final excel sheet should show

                                          abcxyz     User1     user2
Customer Interface Focal     dfgidf     user23     user3.....
.....

i tried various logics for this... please see the code below

1. Microsoft.Office.Interop.Excel.Workbook   SelWorkBook = excelappln1.Workbooks.Open(curfile,
      0, false, 5, "", "", false, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "", true, false, 0, false, false, false);

      Microsoft.Office.Interop.Excel.Sheets      excelSheets =      SelWorkBook.Worksheets;

      Microsoft.Office.Interop.Excel.Worksheet      excelworksheet =      (Microsoft.Office.Interop.Excel.Worksheet)excelSheets.get_Item(CurSheetName);

      Microsoft.Office.Interop.Excel.Range      excelRange =      excelworksheet.UsedRange;

if ((!excelworksheet.Cells[CurTaskNode.DATA_MIN_ROW + minRow, CurTaskNode.DATA_MIN_COL + minCol]).Locked)
   {

            // Assigning the Value from reader to the particular cell in excel sheet excelworksheet.Cells[CurTaskNode.DATA_MIN_ROW + minRow, CurTaskNode.DATA_MIN_COL +         minCol] = values[iValueIndex];
            iValueIndex++;
   }

but the error shows, in the if statement
Error     1     Operator '!' cannot be applied to operand of type 'object'

so, please say how to handle this case.

Thanks
Ramm

Re: how to write in excel cells using DataReader if a particular cell is “ReadOnly” using C#

dan!sh 5-Jul-09 20:51

dan!sh

5-Jul-09 20:51

Krishna Aditya wrote:
if ((!excelworksheet.Cells[CurTaskNode.DATA_MIN_ROW + minRow, CurTaskNode.DATA_MIN_COL + minCol]).Locked)

Can you see some incorrect braces here?

Moreover, I cannot see any locked property for cells. However, you can use Microsoft.Office.Interop.Excel.Range.Locked for this.

Re: how to write in excel cells using DataReader if a particular cell is “ReadOnly” using C#

Krishna Aditya5-Jul-09 20:57

Krishna Aditya

5-Jul-09 20:57

ya d@nish,

I used the same Microsoft.Office.Interop.Excel.Range.Locked for test...

if ((!Microsoft.Office.Interop.Excel.Range (excelworksheet.Cells[CurTaskNode.DATA_MIN_ROW + minRow, CurTaskNode.DATA_MIN_COL + minCol])).Locked)

{
/// stuff her
}

it shows error here
Error 1 'Microsoft.Office.Interop.Excel.Range' is a 'type', which is not valid in the given context

Am I using the property wrongly here??

Please help.

Thanks
Ramm

Re: how to write in excel cells using DataReader if a particular cell is “ReadOnly” using C#

dan!sh 5-Jul-09 21:10

dan!sh

5-Jul-09 21:10

You are doing it all wrong. Create a Range object for Cell(s) you need to check. Then check locked property.

Read through this[^] code for understanding interop.

C# + MS ACCESS application - daily report problems

daydr3am3r5-Jul-09 19:34

daydr3am3r

5-Jul-09 19:34

Hi.

I'm developing a small application in C# and I use MS ACCESS database.
Right now the application is 95% done and I'm stucked at a report.
I used MS Report Wizard to create and filter reports and I had no problem till now.
I have to filter a report by date so that it shows only the record from the curent date.
The probloblem is that I tried everything I know but it seams that The Query Wizard in C# does not allow me to use any function for filtering by date.
I used Today(), Now(), CurDate(), SysDate(). Date() but none of them worked.
I'm assuming that this has something to do with date format in VC# and MS ACCESS but I'm not sure.
Since I'm new to C# I considered MS Report Wizard to be a fast solution but I'm not so sure anymore.
Now I have 2 more days to finish the app and I can't find anything to help me solve thios problem.
Any idea or suggestion is much appreciated.

[Message Deleted]

Bimal's5-Jul-09 19:30

Bimal's

5-Jul-09 19:30

[Message Deleted]

Re: Making copy of a FILE

Baeltazor5-Jul-09 19:38

Baeltazor

5-Jul-09 19:38

Have you even taken the time to learn any of this yourself? There are tens of thousands of examples on Google and MSDN. Have you even looked there?

At the top of your C# file where the Using directives are, type this (no pasting):

using System.IO;

Now, Assuming you're going to copy that file once a button's been clicked, enter this code into the button's click event:

if( textBox1.Text.Length > 0 )
{
    File.Copy(textBox1.Text, @"DESTINATION\path\GOEShere.txt");
} else MessageBox.Show("Please enter filename");

Re: Making copy of a FILE

Mycroft Holmes5-Jul-09 19:42

Mycroft Holmes

5-Jul-09 19:42

And you problem is!

You have stated a desire to accomplish something, what have you done towards doing it. Look into the System.IO namespace for the operations you want.

Never underestimate the power of human stupidity
RAH

Re: Making copy of a FILE

himanshu25615-Jul-09 19:44

himanshu2561

5-Jul-09 19:44

File.Copy
Have you try to do this yourself or just posted your so called big problem here???

himanshu

Finding usages of classes from a reference in Visual Studio (C#)

Bijesh5-Jul-09 18:42

Bijesh

5-Jul-09 18:42

I don't know if this is even possible, but..would be really nice if it were!

I have a solution with multiple projects. The main project has references to these other projects,and presumably is using classes from those other projects. Now I can see from the using section, which namespaces are being used by which files. But I can't tell which classes from those namespaces are being used. Is there any way (direct or indirect) of finding out, from a namespace, which classes are being used inside a file?

thanks
Bijesh

Link textbox to postgresql database

daffy_20035-Jul-09 17:03

daffy_2003

5-Jul-09 17:03

Hi! how am i suppose to do if i wan to search the data in the database by typing the info in the textbox and it will show the information onto the comboBox?

For example, I type the Employee name into the textbox, then from there, it will search the database and show the contact number of the employee in the combobox.

Is there any way to do it?
I tried using npgsql.dll but it keeps giving errors?
This is the code that i used :
string strConnString = "Server=remote_server;Port=5432;User Id=john;Password=john;Database=testserver";
try
{
NpgsqlConnection objConn = new NpgsqlConnection(strConnString);
objConn.Open();
string strSelectCmd = "SELECT MachineID FROM MachineDeviceMatrix";
NpgsqlDataAdapter objDataAdapter = new NpgsqlDataAdapter(strSelectCmd, objConn);
objDataAdapter.Fill(this.MachineDeviceMatrix);
objConn.Close();
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message, "Error message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}

please help, thanks!

Re: Link textbox to postgresql database

dan!sh 5-Jul-09 18:08

dan!sh

5-Jul-09 18:08

What is the error?

Creating this "Please wait..." window?

SimpleData5-Jul-09 7:49

SimpleData

5-Jul-09 7:49

Hi I would like to show this windows in my application because it takes lot of time for it to load itself.

How can I show this window.

http://img36.imageshack.us/img36/7597/wnd.jpg[^]

Thanks.

Re: Creating this "Please wait..." window?

dan!sh 5-Jul-09 7:59

dan!sh

5-Jul-09 7:59

You can use a form with border set to none and having a label with required text.

This[^] does the same.

Re: Creating this "Please wait..." window?

SimpleData5-Jul-09 8:09

SimpleData

5-Jul-09 8:09

I've thought about that but there should be a simpler way because lots of applications use it.

Re: Creating this "Please wait..." window?

danzar5-Jul-09 8:31

danzar

5-Jul-09 8:31

Are you tring to figure out how to show the form or how to show it while the program is loading? If you are wanting to show it while the program load, then what i did was loaded the "loading form" at the ever beginning of the other form. then when it was done with all the other stuff I closed the "loading form"

Re: Creating this "Please wait..." window?

SimpleData5-Jul-09 8:35

SimpleData

5-Jul-09 8:35

I am not having trouble on figuring out those, the thing I am wondering is creating a form in that style. I think that form style is built-in Windows as a standart loading screen.

Re: Creating this "Please wait..." window?

dan!sh 5-Jul-09 8:41

dan!sh

5-Jul-09 8:41

Do whatever you are doing in load on a separate thread. And while that is executed, set the border of your form to none and hide all the controls. Display just a label to the user with needed text.

This is no different than the previous post of mine except instead of having a separate form, you are doing same thing in the current form itself. This, IMO, is not a good way. You will need to write same thing again and again if there are some more forms which take time to load.

Go for what I had posted earlier. AFAIK it is a decent way to achieve this. I don't know if there is any other way to do this.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.