Re: datatable filter - C# Discussion Boards

Draw a line avoiding objects

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.

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 ?

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));

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.

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));

problem in insert picture to sql

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.

SajjadZare5-Jan-10 21:05

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();

SeMartens5-Jan-10 21:20

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.

SajjadZare5-Jan-10 22:13

5-Jan-10 22:13

I set allowNull for that column

SeMartens5-Jan-10 22:19

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.

SajjadZare5-Jan-10 23:45

5-Jan-10 23:45

Error : parameter @pic, which was not supplied

SeMartens5-Jan-10 23:51

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.

SajjadZare6-Jan-10 2:33

6-Jan-10 2:33

Error : Operand type clash: nvarchar is incompatible with image

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

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.

use DB file without attaching

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.

SajjadZare5-Jan-10 20:55

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 ?

SeMartens5-Jan-10 21:21

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.

SajjadZare5-Jan-10 22:11

5-Jan-10 22:11

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

SeMartens5-Jan-10 22:17

5-Jan-10 22:17

So you want to use the db file (sql-express) without attaching it to the server? Well I think this is not possible. But you could use another database like derby etc. which can be used without an existing server...

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

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.