C# Discussion Boards - CodeProject

OriginalGriff21-Jul-10 9:51

21-Jul-10 9:51

Then the problem must be the string you get back from the DataReader - which implies a problem in your DB. Try checking for nulls in your for loop:

for (int j = 0; j < i; j++)
   {
   if (s[j] == null)
      {
      HttpContext.Current.Response.Write("HELP!\n");
      }
   else
      {
      HttpContext.Current.Response.Write(s[j] + "\n");
      }
   }

If you get "HELP!" in your HttpContext, look at your data!

Did you know:
That by counting the rings on a tree trunk, you can tell how many other trees it has slept with.

Dhyanga21-Jul-10 10:10

21-Jul-10 10:10

the error was same as always.. no change in error.

System.NullReferenceException: Object reference not set to an instance of an object.
   at catagories.Default_View.filetesting() in C:\Documents and Settings\smanandhar\My Documents\Visual Studio 2008\Projects\catagories\Default_View.ascx.cs:line 1224

Also if it was the database error, then it wouldn't be showing when i display the same data in datagrid. Well I can show them in datagrid without any error.

suchita

OriginalGriff21-Jul-10 21:55

21-Jul-10 21:55

Post the actual code you are using (cut and paste rather than hand modify the existing post).
Since you say (for the first time) it is a null-reference error at line 1224 in your code: look at line 1224 in your code. I am pretty sure you will find it is the line:

HttpContext.Current.Response.Write(s[j] + "\n");

(Since there are 1224 lines, just post the single method - but make sure it comes from the VS source, and don't forget the "encode HTML" option when you paste it).

SayamiSuchi wrote:
Also if it was the database error, then it wouldn't be showing when i display the same data in datagrid. Well I can show them in datagrid without any error.

What on earth makes you believe that? Laugh | :laugh:

All that means is that the datagrid takes care to check for null entries and display them as blank!

Did you know:
That by counting the rings on a tree trunk, you can tell how many other trees it has slept with.

Dhyanga22-Jul-10 3:00

22-Jul-10 3:00

It is showing the error is at line

s[i] = dr[0].ToString();

. The code

HttpContext.Current.Response.Write("HELP!\n");

also not working. Well I am using '\n' tab for new line. If i put "\n" , it will just print as "\n" and so i tried 'HELP!\n', which also didn't work. The code i was using is shown below :

protected void filetesting()
        {
           
            SqlConnection cnx = new SqlConnection(categories.strCnx);
          
            string query = @"select i.Name,i.Type,j.Item,j.ItemDescription from categories i, items j where i.ID = j.ID";
            
            SqlCommand objCmd = new SqlCommand(query, cnx);
            SqlDataAdapter objDA = new SqlDataAdapter(objCmd);
            
            
           
            HttpContext.Current.Response.Clear(); //clear anything in io buffer
            HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;filename=categories.doc");
            HttpContext.Current.Response.Charset = "";
            HttpContext.Current.Response.ContentType = "application/vnd.ms-document";
            SqlDataReader dr;
      
            cnx.Open();
            SqlCommand cmd = cnx.CreateCommand();
            cmd.CommandText = query;
            try
            {
                i = 0;
                dr = cmd.ExecuteReader();
                while (dr.Read())
                {
                    s[i] = dr[0].ToString();

                    i++;

                }

                for (int j = 0; j < i; j++)
                {
                    if (s[j] == null)
                    {
                        HttpContext.Current.Response.Write("HELP!\n");
                    }
                    else
                    {
                        HttpContext.Current.Response.Write(s[j] + '\n');
                    }
                }
                HttpContext.Current.Response.End();

                // HttpContext.Current.Response.Write(s[0].ToString());

            }
            catch (Exception ex)
            {
                string pt = ex.ToString();

            }
            finally
            { HttpContext.Current.Response.End(); }
          
        }

Is there any other way to show the user formatted data in word document. Well if grab all my requirements in datagrid, how do I show them in word document. I guess the way I'm using is not correct..thats why I am getting these problems.

suchita

OriginalGriff22-Jul-10 3:49

22-Jul-10 3:49

There are pretty much only two errors you can generate easily from

s[i] = dr[0].ToString();

One is an access violation, and implies that the string array "s" is not big enough to hold the data.
The other is a null reference exception, which implies that dr[0] returns a null.

Since you have said it is a null reference error you are getting, it must be dr[0] is null. Add a check for this in your code, and do not process that line any further:

if (dr[0] != null)
   {
   s[i] = dr[0].ToString();
   }

What are you actually trying to achieve? Is this winforms, or ASP? If you are writing to a Word document, why are you using httpContext? Why not use Interop?

Did you know:
That by counting the rings on a tree trunk, you can tell how many other trees it has slept with.

Dhyanga22-Jul-10 4:14

Re: problem writing in doc file [modified]

22-Jul-10 4:14

But I do not think dr[0] is null because if i put the following code, it displays the data.

while (dr.Read())
            {
                HttpContext.Current.Response.Write(dr[0]);

            }

so I dont know where the error is ?

suchita

Dhyanga22-Jul-10 4:17

Line on open/close brackets

22-Jul-10 4:17

Well I tried to use another way. I showed it first to the datagrid and after i try to show it in word file. well that one works well. But here my problem is since I am showing them in datagrid, when it comes in word document, it shows the same way as in datagrid. But I want to have some formatting on it. Like for example, i want some field of the datagrid on the top where as somefield on the other side. Can I be able to do that in word document ?

suchita

modified on Thursday, July 22, 2010 10:28 AM

Blubbo21-Jul-10 4:26

Blubbo

21-Jul-10 4:26

I'm not sure if I can get the answer on this...

I'm trying to find out of Visual Studio 2010 has the line to show location of open/closing bracket as seen on the photo... (this was from NotePad ++)

This will help me to see better where the open/close bracket belongings, rather than click on the closing bracket and look for the highlighted opening bracket.

Oh, speaking of photo, how do I attach the pix on this?

the line on opening/closing bracket can be seen on Notepad++ software.

I'll do the ascii text here... <sigh>

for (int i = 0; i < 5; i++)
{
| if (i == 2)
| {
| | ....
| | ....
| }
| else
| <throw exception>
}

Re: Line on open/close brackets

Ennis Ray Lynch, Jr.21-Jul-10 4:36

Ennis Ray Lynch, Jr.

21-Jul-10 4:36

I personally use end of brace comments. Also, if a method is larger than the screen, it is too large. With this rule of thumb and a preference for a lot of little methods deep nesting of loops can be avoided. As for getting visual studio to do what you want, good luck. It can barely manage MS preferences Frown | :(

for (..){
;
}//end for ...

Need custom software developed? I do custom programming based primarily on MS tools with an emphasis on C# development and consulting. I also do Android Programming as I find it a refreshing break from the MS.

"And they, since they Were not the one dead, turned to their affairs" -- Robert Frost

Re: Line on open/close brackets

OriginalGriff21-Jul-10 4:56

Re: Line on open/close brackets

21-Jul-10 4:56

It is certainly available for VS 2008 as part of the MS extension CodeRush[^], but I don't know if that will work in VS 2010 (I'm waiting for SP1 before I think about upgrading). Worth a try though.

Did you know:
That by counting the rings on a tree trunk, you can tell how many other trees it has slept with.

PIEBALDconsult21-Jul-10 18:22

PIEBALDconsult

21-Jul-10 18:22

Even though I use that brace-placement format, that's one of the things I don't like about Notepad++
It's not as flexible as VS' way of highlighting matching items.

convert date question

Jassim Rahma21-Jul-10 3:36

Jassim Rahma

21-Jul-10 3:36

0I have this date in xml web services..

7/19/10 5:00 PM Local Time

how can I convert it to:

Mon 19 Jul 2010 Local Time

Re: convert date question

OriginalGriff21-Jul-10 3:46

Re: convert date question

21-Jul-10 3:46

Try:

DateTime d = DateTime(2010, 7, 19, 17, 0, 0);
string s = d.ToString("ddd dd MMM yyyy");

See Formatting a DateTime for display[^] for full details

Did you know:
That by counting the rings on a tree trunk, you can tell how many other trees it has slept with.

Luc Pattyn21-Jul-10 3:47

how to open www.google.com and insert any text to the textbox search (only for show)

21-Jul-10 3:47

How about you drop the "Local Time" and use DateTime.Parse/ParseExact/TryParse/TryParseExact?

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

Gali197821-Jul-10 3:32

Gali1978

21-Jul-10 3:32

hi
how to open www.google.com and insert any text to the textbox search (only for show)
or another website that has textbox ?

in C# Winforms ?

thank's in advance

Re: how to open www.google.com and insert any text to the textbox search (only for show)

Luc Pattyn21-Jul-10 3:46

Re: how to open www.google.com and insert any text to the textbox search (only for show)

21-Jul-10 3:46

Hi,

not sure what you want.

1.
http://www.google.com/#q=any+text[^]

2.
Google Search has an API

3.
If there's only one editable control on a web page, it is likely to have the focus, so simply send some text (SendKeys) to the app.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

Jason Vetter21-Jul-10 4:31

Jason Vetter

21-Jul-10 4:31

These guys have made a really sweet automation tool:
http://www.autoitscript.com/autoit3/index.shtml[^]

Regex Problem,Extracting text from Table

NaveenHS21-Jul-10 2:03

NaveenHS

21-Jul-10 2:03

Hello Everyone,

I am trying to extract the contents of the table from a static HTML file.
Program is almost giving the expected output.

Program :-

class Program
	{
		static void Main()
		{
			StreamReader str = new StreamReader("C:\\AllRoles.html");
			string SFile = str.ReadToEnd();
						
		    Regex regex = new Regex(
				@"<tr>(\s* <td[^>]*>  \s* (?<value>[^<]*?) \s* </td> )+ \s*</tr>",
		 		RegexOptions.ExplicitCapture | RegexOptions.IgnoreCase | RegexOptions.IgnorePatternWhitespace);


			 foreach( Match m in regex.Matches( SFile ) )
			 {
				foreach( Capture item in m.Groups["value"].Captures ) {

				Console.WriteLine( item.Value );
			}
			
				Console.WriteLine( );
			}
				Console.ReadLine();
		}
	}

I am facing one problem there is a comment in between the table content

HTML File :-

<table border="0" cellpadding="5" cellspacing="0" width="100%">
            <tbody><tr>
            <td class="columnheading" nowrap="nowrap">Last Name</td>
            <td class="columnheading" nowrap="nowrap">First Name</td>
           <td class="columnheading" nowrap="nowrap">Role</td>
           <td class="columnheading">Term</td>
           <td class="columnheading">Company</td>
           </tr>
           <tr>
           <td valign="top">

           <!-- Logic Here-->


           Gottlieb

           </td>
           <td valign="top">Pradep</td>
           <td valign="top">President

           </td>
           <td valign="top">8/15/2009 - 9/1/2010</td>
           <td valign="top">DSCMIT</td>

           </tr>
           <tr>
           <td valign="top">
           <!-- Logic Here-->


           Rajesh

           </td>
           <td valign="top">H</td>
           <td valign="top"> President

           </td>
           <td valign="top">8/15/2009 - 8/14/2010</td>
           <td valign="top">BHSIT</td>
           </tr>

I am getting the Output as

Last Name
First Name
Role
Term
Company

and it stops at this line 

Can anyone please help me to solve this problem.

Thanking you,
Naveen HS

Re: Regex Problem,Extracting text from Table

Luc Pattyn21-Jul-10 2:13

Re: Function Call Mechanism

21-Jul-10 2:13

I would try adding RegexOptions.MultiLine

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

Function Call Mechanism

califax2k20-Jul-10 23:15

califax2k

20-Jul-10 23:15

Hi all,

I am looking for a library which can perform the following tasks:

- Taks a description of a method call (e.g. Method name, Parameter name and parameter Value)
- Parse the method description
- invoke a method depending on the parsed description.
- encode the result of the method invocation and pass it as text back.

I know that all of this isn't rocket science, the question is: Is there a library that I can use.

best regards

Lars

#pragma error( disable : * )

PIEBALDconsult21-Jul-10 2:37

PIEBALDconsult

21-Jul-10 2:37

Reflection. But it will also need a Type to operate on.

How to call C# function from unmanaged C++ code.?

deadlyabbas20-Jul-10 19:58

deadlyabbas

20-Jul-10 19:58

Hi,

I need to call a function written in C# from the unmanaged code.
The code from where I have to call the function is purely written in VC++ and it come in the unmaged part of the solution code.
Most of the solution is written in C# .NET 3.5.
Please help me out.

Thanks In Advance
Abbas

Re: How to call C# function from unmanaged C++ code.?

Luc Pattyn20-Jul-10 23:14