soap headers are not added - C# Discussion Boards

Error in loading excel file in windows 7 ...

nassimnastaran16-Apr-12 5:34

16-Apr-12 5:34

Hi all !
in my project to reading an excel file , there is no problem in windows XP , but in Win Seven(7) , I have problem to reading the excel 2007 file . here in some part of code :

string connectionString = String.Format(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=""Excel 12.0;HDR=YES;IMEX=1;""", openFileDlgData.FileName);
string SheetName = "Test";
string query = String.Format(@"select * from [{0}$]", SheetName);
   try
     {
        OleDbConnection conn = new OleDbConnection(connectionString);
        OleDbDataAdapter dataAdapter = new OleDbDataAdapter(query, conn);
        System.Data.DataTable dt = new System.Data.DataTable("ExcelData");
        dataAdapter.Fill(dt);
        ...

Thanks in any help !

Re: Error in loading excel file in windows 7 ...

Pete O'Hanlon16-Apr-12 5:41

Pete O'Hanlon

16-Apr-12 5:41

What problem do you have? That's the important part that's missing from your question.

*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington

"Mind bleach! Send me mind bleach!" - Nagy Vilmos

My blog | My articles | MoXAML PowerToys | Mole 2010 - debugging made easier - my favourite utility

Re: Error in loading excel file in windows 7 ...

nassimnastaran16-Apr-12 6:47

nassimnastaran

16-Apr-12 6:47

System.InvalidOpertionException:The 'Microsoft.ACE.OLEDB.12.0' provider

Re: Error in loading excel file in windows 7 ...

Wes Aday16-Apr-12 7:01

Wes Aday

16-Apr-12 7:01

32 or 64 bit?

Why is common sense not common?
Never argue with an idiot. They will drag you down to their level where they are an expert.
Sometimes it takes a lot of work to be lazy
Please stand in front of my pistol, smile and wait for the flash - JSOP 2012

Re: Error in loading excel file in windows 7 ...

nassimnastaran16-Apr-12 7:32

nassimnastaran

16-Apr-12 7:32

64 bit

Re: Error in loading excel file in windows 7 ...

Wes Aday16-Apr-12 9:02

Wes Aday

16-Apr-12 9:02

nassimnastaran wrote:

64 bit

That is probably your problem.

Re: Error in loading excel file in windows 7 ...

Eddy Vluggen16-Apr-12 8:28

Eddy Vluggen

16-Apr-12 8:28

It's either not installed, or you're mixing environments. Read here[^].

Bastard Programmer from Hell Suspicious | :suss:

soap headers are not added

anandsurya16-Apr-12 0:19

anandsurya

16-Apr-12 0:19

XML

[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(Name = "TestService", ConformsTo = WsiProfiles.BasicProfile1_1)]
public class WebService : System.Web.Services.WebService {
// Add a member variable of the type deriving from SoapHeader.
public MyHeader timeStamp;

[WebMethod(Description = "A method that requires authentication")]
[SoapDocumentMethod(Binding = "TestService")]
[SoapHeaderAttribute("timeStamp", Direction = SoapHeaderDirection.InOut)]
public XmlNode GetXML()
{ XmlDocument doc = new XmlDocument();
doc.LoadXml("" + "" +"<title>Pride And Prejudice</title>" +"" + "");
return doc; }

=---client call ----
protected void Page_Load(object sender, EventArgs e)
{
localhost.MyHeader header = new localhost.MyHeader();
header.UserName = "test";
header.Password = "test";
localhost.WebService proxy = new localhost.WebService();
proxy.MyHeaderValue = header;
XmlDocument xmlDoc = new XmlDocument();
XmlNode elem = proxy.GetXML();
XmlNodeReader nodeReader = new XmlNodeReader(elem);
xmlDoc.InnerXml = elem.InnerXml;
string strXML = xmlDoc.InnerXml;
}
---output is---
<title>Pride And Prejudice</title>

----how to add soap header like----
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Header>
<MyHeader xmlns="http://tempuri.org/">
<UserName>string</UserName>
<Password>string</Password>
</MyHeader>
</soap:Header>

Please ignore - cross posted.

Pete O'Hanlon16-Apr-12 0:26

Pete O'Hanlon

16-Apr-12 0:26

As you have already been told, cross posting is not allowed. Please stop doing it.

*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington

"Mind bleach! Send me mind bleach!" - Nagy Vilmos

My blog | My articles | MoXAML PowerToys | Mole 2010 - debugging made easier - my favourite utility

.net Framework

Mandeep Sembhi15-Apr-12 23:04

Mandeep Sembhi

15-Apr-12 23:04

i making a exam suite project what may coding behind login mail,password,for new user labels and what may be coding behind ok,cancel and sign up button

Re: .net Framework

egenis15-Apr-12 23:13

egenis

15-Apr-12 23:13

Some c# to make it work I guess?

Re: .net Framework

VJ Reddy15-Apr-12 23:16

VJ Reddy

15-Apr-12 23:16

Please see this article
http://dotnet.tekyt.info/?tag=exam-project-in-aspnet[^]
it may be helpful.

Please I need help on this because it's not filling the form

relicon15-Apr-12 15:39

relicon

15-Apr-12 15:39

I made a button that if clicked, it would get the element ID of an HTML button which is "ContinueButton" and then it would invoke a click on it. Just as coded below. So basically, it will click this HTML button and it would eventually lead to the next HTML page.

private void button11_Click(object sender, EventArgs e)
        {

            webBrowser1.Document.GetElementById("ContinueButton").InvokeMember("Click");

Now, after the next HTML page has loaded, it contains a web form. This web form has an element ID by "secretnumber."

I made a code below and it should fill this web form.

webBrowser1.Document.GetElementById("secretnumber").SetAttribute("value", "320");

        }

However, the program stopped and it didn't fill the web form ("secretnumber"). Please help me.

I added this code too but it didn't seem to work.

while (webBrowser1.ReadyState != WebBrowserReadyState.Complete)
            {
                Application.DoEvents();
            }

Re: Please I need help on this because it's not filling the form

relicon15-Apr-12 15:40

relicon

15-Apr-12 15:40

This is what I tried below, but it does not work

private void button11_Click(object sender, EventArgs e)
        {

          
      webBrowser1.Document.GetElementById("ContinueButton").InvokeMember("Click");


            while (webBrowser1.ReadyState != WebBrowserReadyState.Complete)
            {
                Application.DoEvents();
            }


      webBrowser1.Document.GetElementById("secretnumber").SetAttribute("value", "320");

      {

If button11 is clicked, it will automatically click an HTML Button with the element ID of "ContinueButton." Because "ContinueButton" is clicked, it would lead to the next html page. And in this next html page contains a web form with element ID of "secretnumber." I want that web form to be auto filled with "320" but it didn't fill it.

How can I make it wait for the next page to load and then automatically fill the web form with "320"?

Re: Please I need help on this because it's not filling the form

BobJanova15-Apr-12 23:35

BobJanova

15-Apr-12 23:35

What actually happened?

Re: Please I need help on this because it's not filling the form

Member 281270416-Apr-12 0:24

Member 2812704

16-Apr-12 0:24

Use Webbrowser Document complete event..

Re: Please I need help on this because it's not filling the form

Pete O'Hanlon16-Apr-12 0:39

Pete O'Hanlon

16-Apr-12 0:39

You do know that the original poster doesn't get replies to other peoples messages, don't you?

*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington

"Mind bleach! Send me mind bleach!" - Nagy Vilmos

My blog | My articles | MoXAML PowerToys | Mole 2010 - debugging made easier - my favourite utility

CRC-ITU calculation in c#

Hilman Anshori15-Apr-12 14:25

Hilman Anshori

15-Apr-12 14:25

Hello,

I'm new to C#. I need to calculate CRC-ITU for the packet recieved from GPS devices. There is C code provided in the documentation but i don't know how to port it to C#, anyone could help me?

here is CRC-ITU algorithm in C :

C++

static const U16 crctab16[] = 
{
    0x0000, 0x1189, 0x2312, 0x329b, 0x4624, 0x57ad, 0x6536, 0x74bf,
    0x8c48, 0x9dc1, 0xaf5a, 0xbed3, 0xca6c, 0xdbe5, 0xe97e, 0xf8f7,
    0x1081, 0x0108, 0x3393, 0x221a, 0x56a5, 0x472c, 0x75b7, 0x643e,
    0x9cc9, 0x8d40, 0xbfdb, 0xae52, 0xdaed, 0xcb64, 0xf9ff, 0xe876,
    0x2102, 0x308b, 0x0210, 0x1399, 0x6726, 0x76af, 0x4434, 0x55bd,
    0xad4a, 0xbcc3, 0x8e58, 0x9fd1, 0xeb6e, 0xfae7, 0xc87c, 0xd9f5,
    0x3183, 0x200a, 0x1291, 0x0318, 0x77a7, 0x662e, 0x54b5, 0x453c,
    0xbdcb, 0xac42, 0x9ed9, 0x8f50, 0xfbef, 0xea66, 0xd8fd, 0xc974,
    0x4204, 0x538d, 0x6116, 0x709f, 0x0420, 0x15a9, 0x2732, 0x36bb,
    0xce4c, 0xdfc5, 0xed5e, 0xfcd7, 0x8868, 0x99e1, 0xab7a, 0xbaf3,
    0x5285, 0x430c, 0x7197, 0x601e, 0x14a1, 0x0528, 0x37b3, 0x263a,
    0xdecd, 0xcf44, 0xfddf, 0xec56, 0x98e9, 0x8960, 0xbbfb, 0xaa72,
    0x6306, 0x728f, 0x4014, 0x519d, 0x2522, 0x34ab, 0x0630, 0x17b9,
    0xef4e, 0xfec7, 0xcc5c, 0xddd5, 0xa96a, 0xb8e3, 0x8a78, 0x9bf1,
    0x7387, 0x620e, 0x5095, 0x411c, 0x35a3, 0x242a, 0x16b1, 0x0738,
    0xffcf, 0xee46, 0xdcdd, 0xcd54, 0xb9eb, 0xa862, 0x9af9, 0x8b70,
    0x8408, 0x9581, 0xa71a, 0xb693, 0xc22c, 0xd3a5, 0xe13e, 0xf0b7,
    0x0840, 0x19c9, 0x2b52, 0x3adb, 0x4e64, 0x5fed, 0x6d76, 0x7cff,
    0x9489, 0x8500, 0xb79b, 0xa612, 0xd2ad, 0xc324, 0xf1bf, 0xe036,
    0x18c1, 0x0948, 0x3bd3, 0x2a5a, 0x5ee5, 0x4f6c, 0x7df7, 0x6c7e,
    0xa50a, 0xb483, 0x8618, 0x9791, 0xe32e, 0xf2a7, 0xc03c, 0xd1b5,
    0x2942, 0x38cb, 0x0a50, 0x1bd9, 0x6f66, 0x7eef, 0x4c74, 0x5dfd,
    0xb58b, 0xa402, 0x9699, 0x8710, 0xf3af, 0xe226, 0xd0bd, 0xc134,
    0x39c3, 0x284a, 0x1ad1, 0x0b58, 0x7fe7, 0x6e6e, 0x5cf5, 0x4d7c,
    0xc60c, 0xd785, 0xe51e, 0xf497, 0x8028, 0x91a1, 0xa33a, 0xb2b3,
    0x4a44, 0x5bcd, 0x6956, 0x78df, 0x0c60, 0x1de9, 0x2f72, 0x3efb,
    0xd68d, 0xc704, 0xf59f, 0xe416, 0x90a9, 0x8120, 0xb3bb, 0xa232,
    0x5ac5, 0x4b4c, 0x79d7, 0x685e, 0x1ce1, 0x0d68, 0x3ff3, 0x2e7a,
    0xe70e, 0xf687, 0xc41c, 0xd595, 0xa12a, 0xb0a3, 0x8238, 0x93b1,
    0x6b46, 0x7acf, 0x4854, 0x59dd, 0x2d62, 0x3ceb, 0x0e70, 0x1ff9,
    0xf78f, 0xe606, 0xd49d, 0xc514, 0xb1ab, 0xa022, 0x92b9, 0x8330,
    0x7bc7, 0x6a4e, 0x58d5, 0x495c, 0x3de3, 0x2c6a, 0x1ef1, 0x0f78,
};

    // calculate 16 bits CRC of the given length data.
U16 GetCrc16(const U8* pData, int nLength)
{
U16 fcs = 0xffff; // Initialize
 
while(nLength>0){
fcs = (fcs >> 8) ^ crctab16[(fcs ^ *pData) & 0xff];
nLength--;
pData++;
}
return ~fcs; // Negate
}
    
// Check whether the 16 bits CRC of the given length data is right.
 BOOL IsCrc16Good(const U8* pData, int nLength)
{
    U16 fcs = 0xffff;    // Initialize
    while(nLength>0){
        fcs = (fcs >> 8) ^ crctab16[(fcs ^ *pData) & 0xff];
        nLength--;
        pData++;
    }
    return (fcs == 0xf0b8);  // 0xf0b8 is CRC-ITU的"Magic Value"
}

I've also found C# code from http://ppcode.blogbus.com/logs/1656947.html but I don't know how to use it, here's the code

public class CrcITUTable
 {
  static ushort [] crctab16 =
   {
    0x0000, 0x1189, 0x2312, 0x329b, 0x4624, 0x57ad, 0x6536, 0x74bf,
    0x8c48, 0x9dc1, 0xaf5a, 0xbed3, 0xca6c, 0xdbe5, 0xe97e, 0xf8f7,
    0x1081, 0x0108, 0x3393, 0x221a, 0x56a5, 0x472c, 0x75b7, 0x643e,
    0x9cc9, 0x8d40, 0xbfdb, 0xae52, 0xdaed, 0xcb64, 0xf9ff, 0xe876,
    0x2102, 0x308b, 0x0210, 0x1399, 0x6726, 0x76af, 0x4434, 0x55bd,
    0xad4a, 0xbcc3, 0x8e58, 0x9fd1, 0xeb6e, 0xfae7, 0xc87c, 0xd9f5,
    0x3183, 0x200a, 0x1291, 0x0318, 0x77a7, 0x662e, 0x54b5, 0x453c,
    0xbdcb, 0xac42, 0x9ed9, 0x8f50, 0xfbef, 0xea66, 0xd8fd, 0xc974,
    0x4204, 0x538d, 0x6116, 0x709f, 0x0420, 0x15a9, 0x2732, 0x36bb,
    0xce4c, 0xdfc5, 0xed5e, 0xfcd7, 0x8868, 0x99e1, 0xab7a, 0xbaf3,
    0x5285, 0x430c, 0x7197, 0x601e, 0x14a1, 0x0528, 0x37b3, 0x263a,
    0xdecd, 0xcf44, 0xfddf, 0xec56, 0x98e9, 0x8960, 0xbbfb, 0xaa72,
    0x6306, 0x728f, 0x4014, 0x519d, 0x2522, 0x34ab, 0x0630, 0x17b9,
    0xef4e, 0xfec7, 0xcc5c, 0xddd5, 0xa96a, 0xb8e3, 0x8a78, 0x9bf1,
    0x7387, 0x620e, 0x5095, 0x411c, 0x35a3, 0x242a, 0x16b1, 0x0738,
    0xffcf, 0xee46, 0xdcdd, 0xcd54, 0xb9eb, 0xa862, 0x9af9, 0x8b70,
    0x8408, 0x9581, 0xa71a, 0xb693, 0xc22c, 0xd3a5, 0xe13e, 0xf0b7,
    0x0840, 0x19c9, 0x2b52, 0x3adb, 0x4e64, 0x5fed, 0x6d76, 0x7cff,
    0x9489, 0x8500, 0xb79b, 0xa612, 0xd2ad, 0xc324, 0xf1bf, 0xe036,
    0x18c1, 0x0948, 0x3bd3, 0x2a5a, 0x5ee5, 0x4f6c, 0x7df7, 0x6c7e,
    0xa50a, 0xb483, 0x8618, 0x9791, 0xe32e, 0xf2a7, 0xc03c, 0xd1b5,
    0x2942, 0x38cb, 0x0a50, 0x1bd9, 0x6f66, 0x7eef, 0x4c74, 0x5dfd,
    0xb58b, 0xa402, 0x9699, 0x8710, 0xf3af, 0xe226, 0xd0bd, 0xc134,
    0x39c3, 0x284a, 0x1ad1, 0x0b58, 0x7fe7, 0x6e6e, 0x5cf5, 0x4d7c,
    0xc60c, 0xd785, 0xe51e, 0xf497, 0x8028, 0x91a1, 0xa33a, 0xb2b3,
    0x4a44, 0x5bcd, 0x6956, 0x78df, 0x0c60, 0x1de9, 0x2f72, 0x3efb,
    0xd68d, 0xc704, 0xf59f, 0xe416, 0x90a9, 0x8120, 0xb3bb, 0xa232,
    0x5ac5, 0x4b4c, 0x79d7, 0x685e, 0x1ce1, 0x0d68, 0x3ff3, 0x2e7a,
    0xe70e, 0xf687, 0xc41c, 0xd595, 0xa12a, 0xb0a3, 0x8238, 0x93b1,
    0x6b46, 0x7acf, 0x4854, 0x59dd, 0x2d62, 0x3ceb, 0x0e70, 0x1ff9,
    0xf78f, 0xe606, 0xd49d, 0xc514, 0xb1ab, 0xa022, 0x92b9, 0x8330,
    0x7bc7, 0x6a4e, 0x58d5, 0x495c, 0x3de3, 0x2c6a, 0x1ef1, 0x0f78,
   };

  public CrcITUTable()
  {
   //
   // TODO: 在此处添加构造函数逻辑
   //
  }

  unsafe public ushort GetCrcITU_T(byte * pData,int nLength,out string crcCode)
  {
   ushort fcs=0xFFFF;
   ushort uRlt;
   string strTmp;
   while(nLength>0)
   {
    fcs= (ushort) ((ushort)(fcs>>8)^ crctab16[(fcs ^ *pData) &0xFF ]);
    nLength--;
    pData++;
   }

   uRlt=(ushort)~fcs;
   strTmp=uRlt.ToString("X4") ;
   crcCode=strTmp.Substring(2,2) + " " + strTmp.Substring(0,2);

   return uRlt;
  }

  unsafe public bool IsCrcITUGood_T(byte * pData,int nLength)
  {
   ushort fcs=0xFFFF;
   while(nLength>0)
   {
    fcs= (ushort) ((ushort)(fcs>>8)^ crctab16[(fcs ^ *pData) &0xFF ]);
    nLength--;
    pData++;
   }

   return (fcs==0xF0B8);
  }

 }

here is some example in the documentation :

full packet : 0x78 0x78 0x0D 0x01 0x01 0x23 0x45 0x67 0x89 0x01 0x23 0x45 0x00 0x01 0x8C 0xDD 0x0D 0x0A

Start bit : 0x78 0x78
lenght : 0x0D
Protocol No. : 0x01
Device ID : 0x01 0x23 0x45 0x67 0x89 0x01 0x23 0x45
Serial No. : 0x00 0x01
CRC Verify : 0x8C 0xDD
Stop Bit : 0x0D 0x0A

quote from documentation :

Device or server can judge the accuracy of data received with identifying code. Sometimes, because of the electronic noise or other interference, data will be changed a little in the transit process. In this case, identifying code can make sure the core or associated core do nothing with such kind of wrong data, which will strengthen the security and efficiency of system. This identifying code adopts CRC-ITU identifying method. The CRC-ITU value is from "Package Length' to "Information Serial Number" in the protocol (including "Package Length" and "Information Serial Number ").
If the receiver receives CRC wrong calculating information, then ignore it and discard this data package.

So anyone have idea how to get crc value from above example? thx

Re: CRC-ITU calculation in c#

Wes Aday15-Apr-12 16:54

Wes Aday

15-Apr-12 16:54

I highly doubt that you will find anyone here that will port this to C# for you. Most of us have our own jobs to do. If you are so "new" to C# then why were you assigned to do this? You just might have to do it yourself OR hire someone to do it for you. Are you unable to package this code into a DLL and just P/Invoke it?

Re: CRC-ITU calculation in c#

BobJanova15-Apr-12 23:42

BobJanova

15-Apr-12 23:42

This is not even hard, just some type conversions (U16->ushort, U8->byte) and changing pointer access to array access:

    // calculate 16 bits CRC of the given length data.
ushort GetCrc16(byte[] pData)
{
 ushort fcs = 0xffff; // Initialize
 
 for(int i = 0; i < pData.Length; i++){
  fcs = (fcs >> 8) ^ crctab16[(fcs ^ pData[i]) & 0xff];
 }
 return ~fcs; // Negate
}
    
// Check whether the 16 bits CRC of the given length data is right.
bool IsCrc16Good(byte[] pData)
{
 return GetCrc16(pData) == 0x0f47; // ~F0B8
}

You might need to cast to get a ushort back out of the shift and XOR, though.

Dispose groupbox

Ronny Portier15-Apr-12 3:06

Ronny Portier

15-Apr-12 3:06

Hi,

When I dispose a groupbox do I have to dispose all
of its child controls myself or is this done implicitly?

Tia

Re: Dispose groupbox

Luc Pattyn15-Apr-12 3:15

Luc Pattyn

15-Apr-12 3:15

I never found any such information in MSDN, however AFAIK Controls dispose of their children automatically, and I never felt a need to dispose explicitly of one, so why are you disposing of a GroupBox?

Smile | :)

Luc Pattyn [My Articles] Nil Volentibus Arduum

Re: Dispose groupbox

Ronny Portier15-Apr-12 5:21

Ronny Portier

15-Apr-12 5:21

I create a GroupBox with a TableLayoutPanel and readonly TextBoxes in that panel during runtime. I want the GroupBox and its controls to remove itself also at runtime. So I do :

this.Controls.Remove(m_CustomerInfoGrpBx);
m_CustomerInfoGrpBx.Dispose();

Is this enough ?

tia

Re: Dispose groupbox

Luc Pattyn15-Apr-12 5:44

Luc Pattyn

15-Apr-12 5:44

when you remove a Control you no longer need, then disposing it is fine. As I said before, I expect all of its content will be disposed of automatically, so don't try and move the GroupBox content onto another Container.

Smile | :)

Luc Pattyn [My Articles] Nil Volentibus Arduum

Re: Dispose groupbox

phil.o15-Apr-12 5:32

phil.o

15-Apr-12 5:32

Maybe it has been bad. It needed a serious lesson.
We should never let groupboxes make the rules.

No memory stick has been harmed during establishment of this signature.

Last Visit: 31-Dec-99 18:00 Last Update: 8-May-24 23:13

Refresh

ᐊ Prev 1...2080 2081 2082 208320842085 2086 2087 2088 2089 Next ᐅ

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