C# Discussion Boards - CodeProject

10-Jan-08 19:08

Hi, my friends.
I have a question with my web services. he have two functions, the intellisense in the windows application show me this function whit the parameters of each one. But it does,t work.
The error message is terrible:

System.Web.Services.Protocols.SoapException was unhandled
Message="System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.InvalidOperationException: There was an error generating the XML document. ---> System.InvalidOperationException: Cannot serialize the DataTable. DataTable name is not set.\n at System.Data.DataTable.WriteXmlSchema(XmlWriter writer, Boolean writeHierarchy)\n at System.Data.DataTable.System.Xml.Serialization.IXmlSerializable.WriteXml(XmlWriter writer)\n at System.Xml.Serialization.XmlSerializationWriter.WriteSerializable(IXmlSerializable serializable, String name, String ns, Boolean isNullable, Boolean wrapped)\n at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationWriter1.Write1_SearchResponse(Object[] p)\n...........and much more.

thanks.

imsathy10-Jan-08 22:18

imsathy

10-Jan-08 22:18

What is the return type of the webmethod ??

Was it working separately as a function ??

Sathy

caradri11-Jan-08 5:49

11-Jan-08 5:49

thanks Sathy.
the function in the services return a datatable, but in the application if I do:

DataTable appsearch = new DataTable();
appsearch = serv.Search(var1,var2);

fail in build with the error message:
Cannot implicity convert
type 'Client.localhost.SearchResponseSearchResult' to 'System.Data.DataTable'

what that mean? please.

Torsten Mauz11-Jan-08 11:01

Torsten Mauz

11-Jan-08 11:01

Ok in that case - the Webmethod is returning the type SearchResponseSearchResult which will have some series of properties (you'll probably find that the datatable is one of them), if you are using VStudio you can use object explorer to examine that object otherwise you'll be able to find the webservice proxy class to see the class definition of SearchResponseSearchResult. Then you should be able to do something like :

<br />
Client.localhost.SearchResponseSearchResult objResult = serv.Search(var1, var2);<br />
DataTable appsearch;<br />
<br />
if(objResult.DataTableProperty ! = null)<br />
{<br />
appsearch = objResult.DataTableProperty;<br />
}<br />

caradri13-Jan-08 19:18

13-Jan-08 19:18

thanks a lot, Torsten Mauz.
I can do what you explain here but the DataTableProperty i don't have. I think this can be because i am working with a xml web service and also this is the reason why i have
System.XML.XmlElement[] SearchResponseSearchResult.Any
I dont now where this Any come from but i think i can use this XmlElement.
what you think?
Something else, in this web services i have another function boolean, this function return boolean in the application without any problem.

Torsten Mauz10-Jan-08 23:45

Torsten Mauz

10-Jan-08 23:45

DataTable name is not set

- kind of gives the game away. The webservice has issues that need resolving, i.e. the DataTable object they are trying to return needs to have it's TableName property set before it can be serialised. If you have access to the webservice code then you'll need to fix that. Otherwise you'll have to get in touch with whoever is responsible for the service.

HTH

caradri11-Jan-08 5:25

How do you check if a cell in DataGridView is null

11-Jan-08 5:25

the datatable name is set

Jacob Dixon10-Jan-08 17:41

Jacob Dixon

10-Jan-08 17:41

How do you tell if a cell in DataGridView is empty?

foreach (DataGridViewRow r in theTableDataGridView.Rows)
{
richTextBox1.Text += r.Cells[1].Value.ToString() + " " + r.Cells[2].Value.ToString() + "\n";
if (r.Cells[3].Value.ToString() == null) { return; }
else { richTextBox1.Text += r.Cells[3].Value.ToString() + "\n" ; }
}

This doesnt work... ToString().Trim() does not work... I just can not figure it out.. in the database the default value is <dbnull>.

I just can not figure it out... Thanks in advance!

Re: How do you check if a cell in DataGridView is null [modified]

Jimmanuel11-Jan-08 3:28

Jimmanuel

11-Jan-08 3:28

how about r.Cells[3].Value == null || r.Cells[3].Value.ToString().Length == 0?

Last modified: 2mins after originally posted -- fixed a bunch of syntax and logic errors

Re: How do you check if a cell in DataGridView is null

Justin Perez11-Jan-08 3:30

Justin Perez

11-Jan-08 3:30

Jacob Dixon wrote:
How do you tell if a cell in DataGridView is empty?

foreach (DataGridViewRow r in theTableDataGridView.Rows)
{
richTextBox1.Text += r.Cells[1].Value.ToString() + " " + r.Cells[2].Value.ToString() + "\n";
if (r.Cells[3].Value.ToString() == null) { return; }
else { richTextBox1.Text += r.Cells[3].Value.ToString() + "\n" ; }
}

This doesnt work... ToString().Trim() does not work... I just can not figure it out.. in the database the default value is .

I just can not figure it out... Thanks in advance!

You need to use DBNull.Value. A couple things, while we are at it. The way you formatted your string is ugly. This is 2008, format strings the right way Smile | :)

. Use string.Format(). Also, in an if statement, put the constant on the left hand side. So in the end, you would want your code to look like this:

foreach (DataGridViewRow r in theTableDataGridView.Rows)
{ 
  richTextBox1.Text += string.Format("{0} {1}\n", r.Cells[1].Value.ToString(), r.Cells[2].Value.ToString());
  if (DBNull.Value == r.Cells[3].Value) 
    return; 
  else  
    richTextBox1.Text += string.Format("{0}\n", r.Cells[3].Value.ToString());
}

Re: How do you check if a cell in DataGridView is null

Jacob Dixon11-Jan-08 14:00

Jacob Dixon

11-Jan-08 14:00

Thanks! Sorry I'm still learning. Thanks that works... There is actually alot more to that. I just did not want to paste it all..

return; actually quits the foreach so I just left it blank. a semi-colon after the r.Cells[3].Value

It just goes through and list the address (its an address book I am working on). Like in this format:

Jacob Dixon
Address
City, State, Zip
Home Phone:

and such... I just didn't want a blank line to be entered if the cell was null.. Thanks for the help!

Re: How do you check if a cell in DataGridView is null

Justin Perez14-Jan-08 2:37

Justin Perez

14-Jan-08 2:37

Jacob Dixon wrote:
and such... I just didn't want a blank line to be entered if the cell was null.. Thanks for the help!

Ah, I see

Happy to help Smile | :)

I'm going to become rich when I create a device that allows me to punch people in the face over the internet.

"If an Indian asked a programming question in the forest, would it still be urgent?" - John Simmons / outlaw programmer

how to get click events for dynamically generated buttons

mrcsn10-Jan-08 17:38

mrcsn

10-Jan-08 17:38

Hi
how to get click events for dynamically generated buttons

help me with the code

thanx in advance.

modified on Friday, January 11, 2008 2:22:18 AM

N a v a n e e t h10-Jan-08 18:17

N a v a n e e t h

10-Jan-08 18:17

Create instance for TextBox class, assign id an point, add that to Form.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

dipak.dipak10-Jan-08 18:56

dipak.dipak

10-Jan-08 18:56

Hello,

create a object of TextBox and add to the form like this way:

TextBox TxtBox = new TextBox();
this.Controls.Add(TxtBox);

U may set different location and other properties before or after add to controls collection.

Try it.

Best of luck! Blush | :O

Dipak

mrcsn10-Jan-08 20:25

mrcsn

10-Jan-08 20:25

Thanx dipak

how to get Textchanged event for dynamically generated textbox