Excel interop issue - C# Discussion Boards

Re: problem in deployment

minnie mouse11-Sep-09 16:59

minnie mouse

11-Sep-09 16:59

I would investigate a thing called "Inno Setup" it is extremely good !

How to connect to a website and retrieve the page in C#?

sheateng10-Sep-09 22:00

sheateng

10-Sep-09 22:00

I'm currently doing SMS system with C#.

I have no idea how to retrieve a website(timetable) that requires an input. Anyone can help?

This is my code:

public string generateURL(string id)
{
string siteUri ="http://utptt-ex.petronas.com.my/studentInd.htm";
webrequest wr= webrequest.create(siteUri);
return wr;
}

But i have some bugs. Is there anyone who has better codes to this?

Re: How to connect to a website and retrieve the page in C#?

Md. Marufuzzaman10-Sep-09 22:17

Md. Marufuzzaman

10-Sep-09 22:17

I think you might be trying this using HTTP over TCP/IP.. If so then you need to hit an uri with some parama..and retrieve the acknowledgment.

Try this link

I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.

Don't forget to click [Vote] / [Good Answer] on the post(s) that helped you.

Thanks
Md. Marufuzzaman

Re: How to connect to a website and retrieve the page in C#?

vivasaayi11-Sep-09 0:53

vivasaayi

11-Sep-09 0:53

Follow the Following code. Pass the number to Download function in string format. You ll get the answer. Worked for me.

using System;
using System.Collections.Generic;
using System.Text;
using System.Net;
using System.IO;

namespace RequestURL
{
    class Program
    {
        static void Main(string[] args)
        {
            string response = Download("0");//Give the Number here
            Console.WriteLine(response);
            Console.ReadLine();
        }

        private static string Download(string number)
        {
            string text = "http://utptt-ex.petronas.com.my/Reporting/Individual?identifier=" + number + "&B1=View+Timetable&objectclass=students&idtype=id&width=100&periods=1-30";
            string responseFromServer = "";

            try
            {
                WebRequest request = WebRequest.Create(text);
                request.Credentials = CredentialCache.DefaultCredentials;

                HttpWebResponse response = (HttpWebResponse)request.GetResponse();

                Stream dataStream = response.GetResponseStream();
                StreamReader reader = new StreamReader(dataStream);

                responseFromServer = reader.ReadToEnd();

            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
            return responseFromServer;

        }
    }
}

Re: How to connect to a website and retrieve the page in C#?

sheateng27-Sep-09 21:43

sheateng

27-Sep-09 21:43

Thank you for the codes, can I save the response from the web into a file?

Re: How to connect to a website and retrieve the page in C#?

vivasaayi28-Sep-09 3:52

vivasaayi

28-Sep-09 3:52

using System;
using System.Collections.Generic;
using System.Text;
using System.Net;
using System.IO;

namespace RequestURL
{
    class Program
    {
        static void Main(string[] args)
        {
            string response = Download("0");
            Console.WriteLine(response);
            Console.ReadLine();
        }

        private static string Download(string number)
        {
            string text = "http://utptt-ex.petronas.com.my/Reporting/Individual?identifier=" + number + "&B1=View+Timetable&objectclass=students&idtype=id&width=100&periods=1-30";
            string responseFromServer = "";

            try
            {
                WebRequest request = WebRequest.Create(text);
                request.Credentials = CredentialCache.DefaultCredentials;

                HttpWebResponse response = (HttpWebResponse)request.GetResponse();

                Stream dataStream = response.GetResponseStream();
                StreamReader reader = new StreamReader(dataStream, Encoding.ASCII);

                responseFromServer = reader.ReadToEnd();

                StreamWriter writer = new StreamWriter("C:\\a.txt");
                writer.Write(responseFromServer);

                writer.Close();
                reader.Close();                

            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
            return responseFromServer;

        }
    }
}

Re: How to connect to a website and retrieve the page in C#? [modified]

April Fans21-Sep-09 17:09

April Fans

21-Sep-09 17:09

my english is pool. i don't know clearly.

for example:

public static string Post(string action, string parmString)
{
try
{
//Encode
Encoding myEncoding = Encoding.GetEncoding("GB2312");

//get URL
Uri myUri = new Uri(action);

//byte[]
byte[] paramBytes = myEncoding.GetBytes(parmString);

//new a webrequest
WebRequest myWebRequest = WebRequest .Create(myUri);

//set ContentType
myWebRequest.ContentType = "application/x-www-form-urlencoded";
//set Method
myWebRequest.Method = EnumWebMethod.POST.ToString();

//init request, get back stream
using (Stream requestStream = myWebRequest.GetRequestStream())
{
//send data
requestStream.Write(paramBytes, 0, paramBytes.Length);
}

//send request, get WebResponse object
WebResponse myWebResponse = myWebRequest.GetResponse();

//
using (StreamReader myStreamReader = new StreamReader(myWebResponse.GetResponseStream(), myEncoding))
{
return myStreamReader.ReadToEnd();
}
}
catch
{
return "request error!";
}
}

i hope i can help you.

modified on Wednesday, September 23, 2009 9:41 PM

April

Comm100 - Leading Live Chat Software Provider

modified 27-May-14 22:04pm.

Excel interop issue

manustone10-Sep-09 21:33

manustone

10-Sep-09 21:33

HI
I am developing a .NET MyLib.dll to be exposed via COM to Excel.
In It there is a class called MyDotNetClass ( ComVisible is set to ture
and I have GUID attributer )
When I pass a Range to my AnyMethod and I want to get the FormulaR1C1Local
everything is thine.
When I want to call other method other than this ( including the getValue to get
the real valu conatined by the cells in that range, not its formula )
I have a lot of exception most of the same time.
Can you help me with that?
I already have a reference to Microsoft.Office.Interop.Excel library V12.0
for Excel 2007.

Thanks
Mn

<br />
// C# class<br />
class MyDotNetClass<br />
{<br />
 String AnyMethod( Microsoft.Office.Interop.Excel.Range aRange )<br />
 {<br />
        object[,] formula = (object[,])aRange.FormulaR1C1;<br />
        // I can get the formulas like CONCATENATE( A1,B1 ) or<br />
        // references like D14<br />
<br />
        // most of methods and properties thrown an exception<br />
<br />
        // I cannot even get the Value or call get_Value<br />
        // I ahve this excepion<br />
        // "Old format or invalid type library. (Exception from HRESULT: <br />
        //  0x80028018 (TYPE_E_INVDATAREAD)) System.SystemException<br />
        //  {System.Runtime.InteropServices.COMException}<br />
<br />
 }<br />
}<br />
<br />
'VB CODE<br />
Function MyFoo( aRange As Range) As String<br />
Dim myLibObj As New MyLib<br />
MyFoo = myLibObj.AnyMethod( aRange )<br />
End Function<br />

Current directory problem in MDI container form

mutpan10-Sep-09 20:58

mutpan

10-Sep-09 20:58

Hi All,

I am creating one MDI application using C# in VS 2008. I attached the code below. I open one RTF file through the Open menu of the main form using Open dialog and loads the file in to the rich text box present in the child form. My problem is before loading the file in to the child form, the current directory points to the Debug folder of the application, but after loading the file in to the child form the current directory changes to the file directory which I opened in the child form.

For example,
before loading the file, my current directory is : "C:\Sample\Debug"
after loading the file, it changes to : "C:\ArchiveFiles"
because i opened a file from the "C:\ArchiveFiles" directory.

It is the intended behaviour of the MDI application. How do avoid changing the current directory? I want the current directoy should always point to the directory from where the EXE is running.

Is there any way to do this?

namespace WindowsFormsApplication1
{
  public partial class Form3 : Form
  {
    Form4 f4 = null;

    public Form3()
    {
      InitializeComponent();
      this.IsMdiContainer = true;
      f4 = new Form4();
      f4.MdiParent = this;      
      f4.Show();

      // Current directory here points to the debug folder
      string ctDir = System.Environment.CurrentDirectory;
      
    }

    private void openToolStripMenuItem_Click(object sender, EventArgs e)
    {
      if (DialogResult.OK == openFileDialog1.ShowDialog())
      {
        f4.OpenFile(openFileDialog1.FileName, this);        
      }

      // Current directory here points to the directory which you opened file from open dialog 
      string ctDir = System.Environment.CurrentDirectory;
      MessageBox.Show(ctDir);
    }
  }
}

public partial class Form4 : Form
  {
    public Form4()
    {
      InitializeComponent();      
    }

    
    public void OpenFile(string filename,Form  parent)
    {
      richTextBox1.LoadFile(filename);
    }
  }

Thanks in advance,
Mutpan

Re: Current directory problem in MDI container form

Christian Graus10-Sep-09 21:03

Christian Graus

10-Sep-09 21:03

Set the directory before showing the dialog.

mutpan wrote:
Form4 f4 = null;

You're joking, right ?

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Re: Current directory problem in MDI container form

Lyon Sun11-Sep-09 1:55

Lyon Sun

11-Sep-09 1:55

Christian Graus wrote:
mutpan wrote:
Form4 f4 = null;

You're joking, right ?

Good point! Laugh | :laugh:

Re: Current directory problem in MDI container form [modified]

April Fans21-Sep-09 17:06

April Fans

21-Sep-09 17:06

i don't know why you want to get current Directory.
so you can try these.
1) you can use:
System.IO.Directory.GetCurrentDirectory();
AppDomain.CurrentDomain.BaseDirectory;
Application.StartupPath
AppDomain.CurrentDomain.SetupInformation.ApplicationBase
Application.ExecutablePath
and so on.
2)
you can save the CurrentDirectory Path to a string at the first time you get it .
and send to the other form when you open it.

modified on Wednesday, September 23, 2009 9:45 PM

April

Comm100 - Leading Live Chat Software Provider

modified 27-May-14 22:05pm.

access font colour paterns in ToolStripCombo box Along with name

santosh_anu10-Sep-09 20:52

santosh_anu

10-Sep-09 20:52

hello
i am using toolstripComboBox.i want to access all the System colour paterns Along with there name how can i do this

i achive this on Simple combo on the form but for toolstripcombo it will not work

Re: access font colour paterns in ToolStripCombo box Along with name

Henry Minute11-Sep-09 0:05

Henry Minute

11-Sep-09 0:05

For anyone to be able to help you, we need to know what 'it will not work' means.

Some code (not too much, and properly formatted, use PRE tags) with an indication of which part fails, any error messages etc. Smile | :)

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

Re: access font colour paterns in ToolStripCombo box Along with name

santosh_anu11-Sep-09 7:09

santosh_anu

11-Sep-09 7:09

hello
if i am using simple combo box on the form the Draw item event appear and i use code on this event is

private void cmbboxClr_DrawItem(object sender, DrawItemEventArgs e)
{
Graphics g = e.Graphics;
Rectangle rect = e.Bounds;
if (e.Index >= 0)
{
string n = ((ComboBox)sender).Items[e.Index].ToString();
Font f = new Font("Arial", 9, FontStyle.Regular);
Color c = Color.FromName(n);
Brush b = new SolidBrush(c);
g.DrawString(n, f, Brushes.Black, rect.X, rect.Top);
g.FillRectangle(b, rect.X + 110, rect.Y + 5, rect.Width - 10, rect.Height - 10);
}
}
-----------------------------
and at form load event i use code

Type colorType = typeof(System.Drawing.Color);
PropertyInfo[] propInfoList = colorType.GetProperties(BindingFlags.Static | BindingFlags.DeclaredOnly | BindingFlags.Public);
foreach (PropertyInfo c in propInfoList)
{
this.cmbboxClr.Items.Add(c.Name);
}

-------------------------------
and at select index change i use the code
private void cmbboxClr_SelectedIndexChanged(object sender, EventArgs e)
{
string color = this.cmbboxClr.SelectedItem.ToString();
this.panel1.BackColor = Color.FromName(color);
}

this will do but when i use toolstripcombo i'm not getting event Draw Item how can i achive the same thing using toolstripcombo my main problem is to access system colour patern along with name to change font or background colour

Re: access font colour paterns in ToolStripCombo box Along with name

Henry Minute11-Sep-09 9:09

Henry Minute

11-Sep-09 9:09

AFAIK the ToolStripComboBox does not have OwnerDraw capability. In fact most of the ToolStrip versions of controls are 'crippled' to some extend.

You might be able to save yourself a little processing and therefore make it a little faster by modifying your load event handler.

You could do something like:

foreach (string colorName in Enum.GetNames(typeof(KnownColor)))
{
    this.cmbboxClr.Items.Add(colorName);
}

in fact you can even shorten that to either of:

this.cmbboxClr.Items.AddRange(Enum.GetNames(typeof(KnownColor)));

// *************** OR ***************
this.cbbboxClr.DataSource = Enum.GetNames(typeof(KnownColor)));

I have not done any time comparisons for these suggestions, and so cannot say which, if any, is faster than your current code.

As far as the ToolStripComboBox problem is concerned, it has occurred to me that, you might (again I have not tested it) put a standard ComboBox on the ToolStrip. Take a look at this[^] for further details.

Re: access font colour paterns in ToolStripCombo box Along with name

April Fans21-Sep-09 17:15

April Fans

21-Sep-09 17:15

why not paste your codes?

try to get system colour paterns , bind to the toolstripComboBox;
or "toolstripComboBox.items.add()" one by one;

April

Comm100 - Leading Live Chat Software Provider

modified 27-May-14 22:04pm.

Re: access font colour paterns in ToolStripCombo box Along with name

santosh_anu21-Sep-09 21:12

santosh_anu

21-Sep-09 21:12

hello
i give the code on 13th sep 09 but it is for normal combo draw item event on toolstripcombo there is not any draw item event how i achive it on toolstripcombo

How to execute SSIS package from windows service

Rajesh Koriya10-Sep-09 19:51

Rajesh Koriya

10-Sep-09 19:51

I successfully execut SSIS package from C#.net
But when i tried that using windows service then SSIS package is not
execute.
How i can execute ssis package which is stored as file using windows service.

Re: How to execute SSIS package from windows service

Kuthuparakkal21-Aug-12 17:44

Kuthuparakkal

21-Aug-12 17:44

Follow this article: [^]

Make sure that the service run at 32 bit runtime if you use JET or ACE OLEDB connections. As they do not work on 64 bit run time.

Accessing bytes in a video as it is playing in windows media player

FoxholeNorman10-Sep-09 17:28

FoxholeNorman

10-Sep-09 17:28

I have put windows media player in a form, and was wondering if there is any way to see the bytes as they are being streamed to the viewer, so that I can manipulate them. I guess this would be like a buffering area where I can check the bytes and then play them.

Thanks

Re: Accessing bytes in a video as it is playing in windows media player

Christian Graus10-Sep-09 17:52

Christian Graus

10-Sep-09 17:52

Didn't you ask this the other day ? I believe you can write what is called a 'pin' which gets inserted into the directX player sequence. If you can do this using WMP, I am not sure. But, that would be the only way to access the data as the player shows it, to have a flow of data in synch with the player.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Re: Accessing bytes in a video as it is playing in windows media player

FoxholeNorman11-Sep-09 2:38

FoxholeNorman

11-Sep-09 2:38

Thanks again for you response, I did ask this the other day. I have found that typically the problem is that in forums, if you get one reply then people move on and look for ones that have no responses. Sorry though, I'll try to refrain from double posts here. I'll give the pin thing a try, thank you.

Fox

Lighten area of a image

hardsoft10-Sep-09 11:35

hardsoft

10-Sep-09 11:35

I have a app which places a watermark (text) on an image and saves this back to a file.

What I would like to do is lighten a rectangle area behind the text so the text is clearer.

Can anyone point me to articles which would show how to lighten an area. I found many which show how to lighten/darken the image (bitmap) but noe for an area.

Re: Lighten area of a image

Christian Graus10-Sep-09 11:40

Christian Graus

10-Sep-09 11:40

My image processing articles show you how to do that, you'd just have to change the code to only iterate over the pixels you want to lighten

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

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