C# Discussion Boards - CodeProject

SeMartens5-Jan-10 22:38

5-Jan-10 22:38

Hi,

the selectSingleNode-method expects a string containing a xpath-expression. See here:

<a href="http://msdn.microsoft.com/en-us/library/h0hw012b%28VS.80%29.aspx">http://msdn.microsoft.com/en-us/library/h0hw012b%28VS.80%29.aspx</a>[<a href="http://msdn.microsoft.com/en-us/library/h0hw012b%28VS.80%29.aspx" target="_blank" title="New Window">^</a>]

So the second line you posted is a correct xpath-expression.

So with this xpath-expression:

<code>
/mynode/comment()
</code>

you select all comments within the node mynode. To access the first comment use:

<code>
/mynode/comment()[1]
</code>

This should do the trick.

Regards
Sebastian

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

Re: C# and Resource File

jojoba20105-Jan-10 23:05

jojoba2010

5-Jan-10 23:05

Sorry I didnt get your idea
how can i get the value of
would you explaine more.....

in my Resource file i have this tags

<value>Ok
<comment>button Ok

<value>0,0
<comment>button Ok

<value>75, 23
<comment>button Ok

Re: C# and Resource File

SeMartens5-Jan-10 23:21

SeMartens

5-Jan-10 23:21

Is this an xml-file? Okay let us assume your file looks like this:

<br />
<resources><br />
  <item><br />
    <tag1>OK</tag1><br />
    <tag2>button OK</tag2><br />
    <!-- button2 --><br />
  </item><br />
  <item><br />
    <tag1>0,0</tag1><br />
    <tag2>button OK</tag2><br />
    <!-- button2 --><br />
  </item><br />
  <item><br />
    <tag1>75,23</tag1><br />
    <tag2>button OK</tag2><br />
    <!-- button2 --><br />
  </item><br />
</resources><br />

Then you can get the first comment with (with itemNode is set to the first node with the tag item):

<br />
 string b = itemNode.SelectSingleNode("./comment()[1]").InnerText<br />

Does this help you?

Regards
Sebastian

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

Re: C# and Resource File

jojoba20106-Jan-10 0:01

jojoba2010

6-Jan-10 0:01

Thanks a Lot !!!!!!!!!!!!!!!
Thumbs Up | :thumbsup:

it was great help to me

Re: C# and Resource File

carlecomm6-Jan-10 18:16

carlecomm

6-Jan-10 18:16

You can't get this value as far as I know. You can put this value in a hidden label, than get this value.

modified 27-May-14 5:05am.

Draw a line avoiding objects

Zaegra5-Jan-10 21:45

Zaegra

5-Jan-10 21:45

Hello,

I have a problem:
I want to draw a line between object A (Say an ellipse) and object B (also an ellipse). Now, between those object lies object C (which is a triangle). Now how can I draw the shortest line between A and B avoiding object C, using GDI+?

Thanks in advance,
Zaegra

Motivation is the key to software development.

Re: Draw a line avoiding objects

Skippums6-Jan-10 7:58

Skippums

6-Jan-10 7:58

In two steps:
1) Solve the mathmatical formula to determine the line's endpoints
2) Draw the line

I can't tell from your question which of the two steps you need help with, but it seems like you are asking for help with step 1. If you already know how to do step 2, then this is the wrong forum to ask your question as part 1 is not C# related.

Sounds like somebody's got a case of the Mondays

-Jeff

datatable filter

abcurl5-Jan-10 21:38

abcurl

5-Jan-10 21:38

I have a datatable(code behind datatable class) that contains a column with the name aa which have ulphanumeric values.
Is there any way to find those rows having numeric values onlywithout doing iteration ?

Re: datatable filter

Greg Chelstowski5-Jan-10 23:26

Greg Chelstowski

5-Jan-10 23:26

The Select method of the DataTable class allows you to do just that, using pseudo T-SQL.
It returns an array of DataRow.

E.g.:

DataRow[] results = yourDataTable.Select("aa=15");

var question = (_2b || !(_2b));

Re: datatable filter

abcurl5-Jan-10 23:38

abcurl

5-Jan-10 23:38

Thanks for replying.. Smile | :)

Greg Chelstowski wrote:
DataRow[] results = yourDataTable.Select("aa=15");

I have to check it at runtime, and there is no static value as written by you in query. the datatable can have any number of both numeric, alphanumeric records.

Please suggest something.

Re: datatable filter

Greg Chelstowski5-Jan-10 23:55

Greg Chelstowski

5-Jan-10 23:55

abcurl wrote:

I have to check it at runtime

???

abcurl wrote:
and there is no static value as written by you in query

Then use variables. And by static I'm sure you meant hard-coded.

abcurl wrote:
the datatable can have any number of both numeric, alphanumeric records.

Use single quotes in the query then!

Now, once you actually got your DataRow array, I'm sure you'll be asking next how to extract values from it. Look, do some reading on MSDN, there are a million tutorials and examples on the .Select method of DataTable.

var question = (_2b || !(_2b));

Re: datatable filter

Kaushal Arora6-Jan-10 20:33

Kaushal Arora

6-Jan-10 20:33

If possible try to use the Regex. May be it helps solving your problem.

problem in insert picture to sql

SajjadZare5-Jan-10 21:05

SajjadZare

5-Jan-10 21:05

I use below code for add picture to dataBase but if I need that insert null instead of picture into database the program give me Error (I set allowNull for column in Sql)
(it's neccesary becuase maybe user dosen't have picture for insert into database)
how can I do that?

MemoryStream mstr = new MemoryStream();
pictureBox1.Image.Save(mstr, pictureBox1.Image.RawFormat);
byte[]pic= mstr.GetBuffer();

SqlConnection sq=new SqlConnection(...);
SqlParameter sp1 = new SqlParameter("@pic", pic);
SqlCommand sc = new SqlCommand("insert into Info values(@pic)", sq);
sc.Parameters.Add(sp1);
sc.ExecuteNonQuery();

Re: problem in insert picture to sql

SeMartens5-Jan-10 21:20

SeMartens

5-Jan-10 21:20

Hi,

could you post the error you receive (message etc.)? Maybe your db-schema doesn't allow null-values for the picture column.

Regards
Sebastian

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

Re: problem in insert picture to sql

SajjadZare5-Jan-10 22:13

SajjadZare

5-Jan-10 22:13

I set allowNull for that column

Re: problem in insert picture to sql

SeMartens5-Jan-10 22:19

SeMartens

5-Jan-10 22:19

And the error you receive is?

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

Re: problem in insert picture to sql

SajjadZare5-Jan-10 23:45

SajjadZare

5-Jan-10 23:45

Error : parameter @pic, which was not supplied

Re: problem in insert picture to sql

SeMartens5-Jan-10 23:51

SeMartens

5-Jan-10 23:51

Try to pass

<br />
System.DBNull.Value<br />

as parameter value when pic1 is null.

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

Re: problem in insert picture to sql

SajjadZare6-Jan-10 2:33

SajjadZare

6-Jan-10 2:33

Error : Operand type clash: nvarchar is incompatible with image

Re: problem in insert picture to sql

Pete O'Hanlon6-Jan-10 3:23

Pete O'Hanlon

6-Jan-10 3:23

There's your problem right there. nvarchar is a text based field, and you are trying to store an image in it - you need to change the column type in the database, or save the image to disk and store the location of the image in this field.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

Re: problem in insert picture to sql

carlecomm6-Jan-10 19:16

carlecomm

6-Jan-10 19:16

hi, try the following code, it may help you.
int len = Upload.PostedFile.ContentLength;
byte[] pic = new byte[len];
Upload.PostedFile.InputStream.Read (pic, 0, len);

SqlConnection sq=new SqlConnection(...);
SqlCommand cmd = new SqlCommand ("insert into values(@pic)", sq);
cmd.Parameters.Add ("@pic", pic);
cmd.ExecuteNonQuery ();

modified 27-May-14 4:59am.

Re: problem in insert picture to sql

April Fans6-Jan-10 19:19

April Fans

6-Jan-10 19:19

April

Comm100 - Leading Live Chat Software Provider

modified 27-May-14 9:00am.

use DB file without attaching

SajjadZare5-Jan-10 20:55

SajjadZare

5-Jan-10 20:55

How can I use DataBase without attach ?

I want to write a program and use sql how can I Insert,... data to sql without attach database file ?

Re: use DB file without attaching

SeMartens5-Jan-10 21:21

SeMartens

5-Jan-10 21:21

Hi,

what do you mean by 'attach'?

Regards
Sebastian

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

Re: use DB file without attaching

SajjadZare5-Jan-10 22:11

SajjadZare

5-Jan-10 22:11

attach means not attaching dB file just put It in program's directory and use it like SQLEXPRESS

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