C# Discussion Boards - CodeProject

First Prev Next

Re: scan using Twain in c#.net

Luc Pattyn20-Jul-09 4:50

Luc Pattyn

20-Jul-09 4:50

My C# compiler most strongly objects D'Oh! | :doh:

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.

Re: scan using Twain in c#.net

DaveyM6920-Jul-09 5:18

DaveyM69

20-Jul-09 5:18

I know the feeling - I've still got a little more work to do on my MIDI wrapper, and most of the implementation has come from studying the relevant C header file rather than relying on stuff on PInvoke.net (which can be useful, but occaisionally just plain wrong) etc. It made my brain hurt - lots, which is why it's not finished yet!

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)

read a excel and show it in datagrid c#

Bird3720-Jul-09 4:07

Bird37

20-Jul-09 4:07

Hi,
i can read a excel File but i can´t populate it on a datagrid. Can somebody help me?
That´s my code:
private void button1_Click(object sender, EventArgs e)
{
this.openFileDialog1.FileName = "*.xls";

if (this.openFileDialog1.ShowDialog() == DialogResult.OK)
{
ApplicationClass xlApplication = new ApplicationClass();
Workbook xlWorkbook = null;

Worksheet xlWorksheet = null;

Range xlRange = null;

xlApplication.Visible = false;
xlApplication.ScreenUpdating = false;
xlApplication.DisplayAlerts = false;

string workbook = this.openFileDialog1.FileName;
xlWorkbook = xlApplication.Workbooks.Open(openFileDialog1.FileName, 0, true, 5, "", "", true, XlPlatform.xlWindows, "\t", false, false, 0, true, 0, false);

xlWorksheet = (Worksheet)xlWorkbook.Worksheets[1];

}
}

Now, how can i report this excel in my datagrid?

Thanks

Re: read a excel and show it in datagrid c#

Adam R Harris20-Jul-09 5:53

Adam R Harris

20-Jul-09 5:53

Well you are on the right track.

What you have to do now is loop through the worksheet and populate a DataTable.
This can be a real pain in the ass if you don't know the "Schema" of the Worksheet.

If you know the last cell and column that data is in you can just loop through it and add new rows to the DataTable. If you don't know the last cell and column, this is where it's a pain in the ass, you have to look for them.

Once you have the data in a DataTable, just set the DataSource of your grid to the DataTable.

You can find a little bit more info on how to properly read excel here[^].

JUST REMEMBER when working with excel you actually have to loop through each open workbook / sheet and close them, pass the parameters for saving, to actually kill excel otherwise it just sits in the background taking up precious resources.

If at first you don't succeed ... post it on The Code Project and Pray.

Re: read a excel and show it in datagrid c#

Wendelldh21-Jul-09 3:52

Wendelldh

21-Jul-09 3:52

You can also use SpecialCells[Excel.XlCellType.xlCellTypeLastCell] to get the last cell.
This returns a crll which will have the last row and last column.
I beleive it just finds the last one with data.

I believe it is a member of the worksheet class.

Re: read a excel and show it in datagrid c#

Adam R Harris21-Jul-09 6:20

Adam R Harris

21-Jul-09 6:20

Hey thats great news .... where were you a few years back when I really needed that.

If at first you don't succeed ... post it on The Code Project and Pray.

LPR failed after 10 jobs

balu1234520-Jul-09 4:06

balu12345

20-Jul-09 4:06

Hi all,

I am getting the error after performing LPR on 10 jobs

"A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond"

please help me...

Framework Version - using 2.0 instead of 3.5

chrisx5120-Jul-09 3:43

chrisx51

20-Jul-09 3:43

Hi,
i am developing an application in Visual Studio 2008.
My Destination Framework - Setting is set to ".Net Framework 2.0"; I do not need special functions of .Net 3.5 and I want the tool installed as quick and easy as possible.
I am using the Built-In "Setup Project" to install my application.

The problem now is that When only including .Net Framework 2.0 in my installation package, the installer says it need .Net Framework 3.5. How can this happen?

If not really needed I want to keep using the 'old' Framwork 2.0.

Regards,
Chris

Re: Framework Version - using 2.0 instead of 3.5

jo H20-Jul-09 4:52

jo H

20-Jul-09 4:52

Check your project properties. What does the Application ->Target Framework say?

If that still says .NET Framework 3.5, then you know why its not using 2.0

Re: Framework Version - using 2.0 instead of 3.5

chrisx5120-Jul-09 4:59

chrisx51

20-Jul-09 4:59

This is the strange thing! I selected .Net Framework 2.0. But even in the begining when creating the setup Project it wants to include .Net Framework 3.5. I deselected 3.5 and selected 2.0.
On another machine where i tried the setup process, a message told me that 3.5 is needed and can be downloaded online.

Re: Framework Version - using 2.0 instead of 3.5

mypicturefaded20-Jul-09 5:03

mypicturefaded

20-Jul-09 5:03

Right click the setup solution on the solution explorer. At the bottom there is a "prerequisite" button. Make sure that the 3.5 Framework and 3.5 Framework SP1 are deselected. Maybe that will fix it.

Re: Framework Version - using 2.0 instead of 3.5

chrisx5120-Jul-09 5:27

chrisx51

20-Jul-09 5:27

This is where i delesected .NetFramwork 3.5 and only selected .NetFramwork 2.0.

Re: Framework Version - using 2.0 instead of 3.5

jo H20-Jul-09 5:33

jo H

20-Jul-09 5:33

Are you using any features that are only available in 3.5? LINQ for instance

Re: Framework Version - using 2.0 instead of 3.5

chrisx5120-Jul-09 5:38

chrisx51

20-Jul-09 5:38

Not to my knowledge. I am not using LINQ.
Is there a possibility to check what framework is needed; and because of what?
I thought Visual Studio would tell me when it needs 3.5 to compile...

Re: Framework Version - using 2.0 instead of 3.5

jo H20-Jul-09 6:18

jo H

20-Jul-09 6:18

What is the original source project properties -> Application Framework setting?

Re: Framework Version - using 2.0 instead of 3.5

chrisx5120-Jul-09 21:39

chrisx51

20-Jul-09 21:39

Thats a good question. I suppose the one that created the project started with using Framework 3.5.
Could this be the reason?

Re: Framework Version - using 2.0 instead of 3.5

Wendelldh21-Jul-09 3:58

Wendelldh

21-Jul-09 3:58

Right click the setup project and select View->Lauch Conditions.
Click to expand the Launch Conditions in the little tree, then select .NET Framework.
In properties, you can select the Version.

Re: Framework Version - using 2.0 instead of 3.5

chrisx5121-Jul-09 4:47

chrisx51

21-Jul-09 4:47

Thank you very much Wendelldh!
You made my day! Now it works fine.

Thanks to all the other helpers.

Regards
Chris

Re: Framework Version - using 2.0 instead of 3.5

Wendelldh21-Jul-09 5:09

Wendelldh

21-Jul-09 5:09

Glad to finally find one I could answer. I always ask for help, but never get a chance to give a little.

Have a great day.

execute powershell script on remote machine

arkiboys20-Jul-09 3:38

arkiboys

20-Jul-09 3:38

Hi,
The c# code below shows how I am executing a powershell script on the local machine.
Do you know how it can be altered so that I can do the same thing but on a remote server?

Thanks

            /// <summary>
            /// Runs the given powershell script and returns the script output.
            /// </summary>
            /// <param name="scriptText">the powershell script text to run</param>
            /// <returns>output of the script</returns>
            private void PowerShellExecuteAndRun(string strServer, string strScript,
                                                                        out string strResult, out string strResultFull)
            {

                  //// create Powershell runspace
                  Runspace runspace = RunspaceFactory.CreateRunspace();

                  //// open it
                  runspace.Open();

                  //// create a pipeline and feed it the script text
                  Pipeline pipeline = runspace.CreatePipeline();
                  pipeline.Commands.AddScript(strScript);

                  //// add an extra command to transform the script output objects into nicely formatted strings
                  //// remove this line to get the actual objects that the script returns. For example, the script
                  //// "Get-Process" returns a collection of System.Diagnostics.Process instances.
                  pipeline.Commands.Add("Out-String");

                  //// execute the script
                  Collection<PSObject> results = pipeline.Invoke();

                  //// close the runspace
                  runspace.Close();

                  //// convert the script result into a single string
                  StringBuilder stringBuilder = new StringBuilder();
                  foreach (PSObject obj in results)
                  {
                        stringBuilder.AppendLine(obj.ToString());
                  }

                  strResult = stringBuilder.ToString();
                  strResultFull = stringBuilder.ToString();

            }

Windows Form does not show if created in other thread

gehbitte20-Jul-09 3:33

gehbitte

20-Jul-09 3:33

Hi,

I have the Class 'Buy.cs'. The method 'openBuyWindow' contains code to create and open a new Windows Form.

In the Program.cs class following code works correctly and the new Form is shown:

Buy b = new Buy();
     b.openBuyWindow();

In the class Buy.cs I also have the method 'buy'. The method 'buy' calls 'openBuyWindow'. If i start the method 'buy' via threading, all procedures are done correctly, but the new Form is not shown:

Buy buy = new Buy();
Thread t1 = new Thread(new ThreadStart(buy.buy));
t1.Start();

Why?

Any suggestions appreciated Smile | :)

Re: Windows Form does not show if created in other thread

stancrm20-Jul-09 3:39

stancrm

20-Jul-09 3:39

Just example:

...

private void button1_Click(object sender, EventArgs e)
{
  Thread t = new Thread(InvokeNewForm);
  t.IsBackground = true;
  t.Start();
}

private void InvokeNewForm()
{
  Invoke(new MethodInvoker(CreateForm));
}

private void CreateForm()
{
  Form1 form1 = new Form1();
  form1.Show();
}

...

Re: Windows Form does not show if created in other thread

gehbitte20-Jul-09 4:27

gehbitte

20-Jul-09 4:27

Tank you very much, but I need to pass some parameters to my Form Object. Methodinvoker does not support this - how can I solve this problem?

Re: Windows Form does not show if created in other thread

DaveyM6920-Jul-09 4:41

DaveyM69

20-Jul-09 4:41

It can be done like this

BeginInvoke(new MethodInvoker(
 delegate() { method(parameters); }) );

Re: Windows Form does not show if created in other thread

gehbitte20-Jul-09 4:59

gehbitte

20-Jul-09 4:59

Tank you but somehow this won't work - BeginInvoke is not recognized from VS...

Last Visit: 31-Dec-99 18:00 Last Update: 20-Jun-24 4:18

Refresh

ᐊ Prev 1...4676 4677 4678 467946804681 4682 4683 4684 4685 Next ᐅ

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