Error : dt is a variable but is used like a method

Question

0.00/5 (No votes)

See more:

Hi Friends,
Can you please help in this I'm getting error at dt(0) saying that dt is a variable but is used like a method.
Thanks for your help

C#

private void pubSelectHL7Server()
{
  try
  {
    //-&gt; if valid ip address, no need to get from database.
    if (HL7ServerIP.Trim().Split(&#39;.&#39;).Length == 4)
      return;

    classDataSource mClsDs = new classDataSource();

    mClsDs.Add(&quot;HL7_SelectServer&quot;, &quot;@pServiceName&quot;, (Char)SqlDbType.NVarChar, 10, ServiceName);

    using (DataTable dt = mClsDs.GetRs(&quot;LABIMAGEDB&quot;, &quot;Constultation&quot;).Tables[0])
    {
      if (dt != null && dt.Rows.Count > 0)
      {
        HL7ServerIP = dt(0)("ServerIP").ToString();
        HL7SendPort = dt(0)("SendPort").ToString.Trim;
        TempLogFolder = dt(0)("TempLogFolder").ToString.Trim;
        StopSendPort = Module1.CheckNullIntegerToBoolean(dt(0)("StopSendPort"));
      }
    }
    writeMessage(&quot;ServiceName &quot; + ServiceName, true);
  }
  catch (Exception ex)
  {
    ModuleHl7.WriteExeptionLog(ex, &quot;-PubSelectHL7sERVER.  Error Getting Connection Info&quot;);
  }
}

Posted 18-Mar-14 21:46pm

shahed.sohail

Updated 18-Mar-14 22:09pm

Kornfeld Eliyahu Peter

v2

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Naz_Firdouse · Accepted Answer · 2014-03-18T22:01:00

Solution 2

Try like this

C#

HL7ServerIP = dt.Rows[0]["ServerIP"].ToString();
HL7SendPort = dt.Rows[0]["SendPort"].ToString.Trim;
TempLogFolder = dt.Rows[0]["TempLogFolder"].ToString.Trim;

Posted 18-Mar-14 22:01pm

Naz_Firdouse

Abhinav S · Accepted Answer · 2014-03-18T21:54:00

Solution 1

C#

HL7ServerIP = dt(0)("ServerIP").ToString();
HL7SendPort = dt(0)("SendPort").ToString.Trim;
TempLogFolder = dt(0)("TempLogFolder").ToString.Trim;
StopSendPort = Module1.CheckNullIntegerToBoolean(dt(0)("StopSendPort"));

Try box brackets instead -

C#

HL7ServerIP = dt[0]["ServerIP"].ToString();
HL7SendPort = dt[0]["SendPort"].ToString.Trim;
TempLogFolder = dt[0]["TempLogFolder"].ToString.Trim;

Posted 18-Mar-14 21:54pm

Abhinav S

Comments

shahed.sohail 19-Mar-14 3:56am

I have already try it but still the same error.

Meysam Toluie 19-Mar-14 4:06am

Maybe you are getting errors but you must change your code in a way that Abhinav has been mentioned.

Kornfeld Eliyahu Peter 19-Mar-14 4:11am

dt is a DataTable - it has no indexer. See solution 2...

Abhinav S 19-Mar-14 4:15am

Intent is to make the OP reealize he has to use box brackets. He can figure out the rest himself.

Kornfeld Eliyahu Peter 19-Mar-14 4:17am

It seems he's not :-)

shahed.sohail · Accepted Answer · 2014-03-19T00:20:00

Thanks friends for your suggestions. I have solved it below is the correct code.

HL7ServerIP = dt.Rows[0].Field<string>("ServerIP");
HL7ServerIP = dt.Rows[0].Field<string>("SendPort");
HL7ServerIP = dt.Rows[0].Field<string>("TempLogFolder");
StopSendPort = Module1.CheckNullBooleanToInteger(dt.Rows[0]["StopSendPort"]);

I have used the syntax like Variablename = dt.Rows[0].Field<string>("stringName");
it works fine for me. Thanks alot.