C# Discussion Boards - CodeProject

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

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.

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

C# + MS ACCESS application - daily report problems

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.

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

Creating this "Please wait..." window?

5-Jul-09 18:08

What is the error?

SimpleData5-Jul-09 7:49

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.

dan!sh 5-Jul-09 7:59

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.

SimpleData5-Jul-09 8:09

5-Jul-09 8:09

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

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"

SimpleData5-Jul-09 8:35

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.

dan!sh 5-Jul-09 8:41

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.

Christian Graus5-Jul-09 14:13

Christian Graus

5-Jul-09 14:13

What could possibly be simpler than what you were told to do ? I mean, seriously ?

you need to put it in another thread if you want it to repaint itself while the app is busy. yes, the other apps do that, too

Christian Graus

Driven to the arms of OSX by Vista.

"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.

I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp

SimpleData5-Jul-09 22:48

5-Jul-09 22:48

What I ment by simpler was something built-in to windows.

DaveyM695-Jul-09 8:35

DaveyM69

5-Jul-09 8:35

This is what I used the last time I needed this in Load event (formSplash is a borderless form).

Hide();
bool done = false;
ThreadPool.QueueUserWorkItem(
    (x) =>
    {
        using (formSplash = new FormSplash())
        {
            formSplash.Show();
            while (!done)
                Application.DoEvents();
            formSplash.Close();
        }
    });
// Do stuff...
done = true;
Show();

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
Why are you using VB6? Do you hate yourself? (Christian Graus)

SimpleData5-Jul-09 8:37

5-Jul-09 8:37

Thank you for the code but a borderless form and a label does a little bit different comparing to the screen in screenshot.

DaveyM695-Jul-09 8:54

DaveyM69

5-Jul-09 8:54

You can use whatever border style you like if you set the form's ControlBox to false and Text to empty.

Alternatively, override OnPaint in the splash form and draw your own border etc eg.

protected override void OnPaint(PaintEventArgs e)
    {
    using (Pen pen = new Pen(Color.FromKnownColor(KnownColor.InactiveBorder)))
    {
        e.Graphics.DrawRectangle(
            pen,
            new Rectangle(
                Point.Empty, new Size(Width - 1, Height - 1))
                );
    }
    base.OnPaint(e);
}

SimpleData5-Jul-09 9:04