Re: Query - C# Discussion Boards

20-Mar-07 23:57

A string is a string is a string. By it's very definition, it has no styling associated with it. I suspect that you mean that it contains something like RTF. If so, then you can parse through the string for the relevant formatting conditions. For instance, it would contain \b for bold or \embo for embossed. You can find the RTF spec at RTF[^]

Deja View - the feeling that you've seen this post before.

query.

Nekshan20-Mar-07 23:21

Nekshan

20-Mar-07 23:21

Dim ds As DataSet1 // this is in vb.

how to declare this in c#? Frown | :-(

Re: query.

virendra patel20-Mar-07 23:23

virendra patel

20-Mar-07 23:23

sorry no dataset1 it is dataset. which u already declare in your code.
like i think. Dataset ds = new Dataset();

Re: query.

Pete O'Hanlon20-Mar-07 23:25

check if i can r/w from/to file in smart client

20-Mar-07 23:25

Strictly speaking, the C# version would be

DataSet ds = null;

because you haven't instantiated it in your VB version, but you may want to consider this version if you want it instantiated

DataSet ds = new DataSet();

Deja View - the feeling that you've seen this post before.

VirtualVoid.NET20-Mar-07 23:21

VirtualVoid.NET

20-Mar-07 23:21

Hello all,

i'm developing application which have two modes, normal (standalone) and application that is using ClickOnce deployment (smart client). The problem is when the application is running in the second mode (SC) and i'll try to check the permissions with the FileIOPermission class.
The SC app is Partial trust type, and doesn't have File IO included in included permissions (that was demand by our customer), so i'm calling code like this:

<br />
public static bool CheckFWIOPerm(string filename)<br />
{<br />
   bool res = false;<br />
   try<br />
   {<br />
       CodeAccessPermission cap = new FileIOPermission(FileIOPermissionAccess.Write, filename);<br />
       cap.Demand();<br />
       res = true;<br />
   }<br />
   catch (SecurityException sx)<br />
   {<br />
       res = false;<br />
   }<br />
<br />
   return res;<br />
}<br />

.. the application will end with the security exception, ...
But i want the true/false result of this function.
How can I check the IO permissions without that sucky exception/programm fall?

thanks

VirtualVoid.NET

Re: check if i can r/w from/to file in smart client

joon _vh.21-Mar-07 2:35

21-Mar-07 2:35

As I understand it, you want a way to use this function without an exception being thrown?
I don't think that it is possible by using CodeAccessPermission. Take a look in Object Browser:

public void Demand()
    Member of System.Security.CodeAccessPermission

Summary:
Forces a System.Security.SecurityException at run time if all callers higher in 
the call stack have not been granted the permission specified by the current instance.

Exceptions:
System.Security.SecurityException: A caller higher in the call stack does not have 
the permission specified by the current instance.-or- A caller higher in the call 
stack has called System.Security.CodeAccessPermission.Deny() on the current permission 
bject.

It behaves like it should. I hope I understood your question. I don't think it's possible to avoid the exception being thrown.

Visual Studio can't evaluate this, can you?

public object moo<br />
        {<br />
__get { return moo; }<br />
__set { moo = value; }<br />
}

Query

Nekshan20-Mar-07 22:56

Nekshan

20-Mar-07 22:56

I have tried something like this, but not working :
conn.Open();
// i want all these values(in bold) in one variable to be displayed later(in a messagebox).
Is it possible to display these 5 values in one variable? how?
SqlCommand cmm = new SqlCommand("select url, sitehit, survey, tellafriend, addtooutlook from tblsummary", conn);
SqlDataAdapter ad = new SqlDataAdapter(cmm);
DataSet sd = new DataSet();
ad.Fill(sd, "tblsummary");
//string str = sd.Tables(0).Rows(0).Item(0);
//for (i = 0 To ds.Tables(0).Rows.Count)
for(int i = 0;i<=ds.Tables(0);i++)
{
string str = sd.Tables(0);
MessageBox.Show(str);
}
It is giving error at ".Rows(0)" (wich is commented).
Is it proper?
Thanx 4 d response in adv.
Regards nekshan.

Re: Query

virendra patel20-Mar-07 23:11

virendra patel

20-Mar-07 23:11

conn.Open();
SqlCommand cmm = new SqlCommand("select url, sitehit, survey, tellafriend, addtooutlook from tblsummary", conn);
SqlDataAdapter ad = new SqlDataAdapter(cmm);
DataSet ds = new DataSet();
ad.Fill(ds, "tblsummary");

string str
Dim ds As DataSet1
if (ds.Tables(0).Rows.Count != 0)
{
string str ="";
Str = ds.Tables(0).Rows(0).Item(1).ToString(); ' i think item is starts from 0 if not work then write here 0 then 1 upto 4 ok.
str += ds.Tables(0).Rows(0).Item(2).ToString();
str += ds.Tables(0).Rows(0).Item(3).ToString();
str += ds.Tables(0).Rows(0).Item(4).ToString();
str += ds.Tables(0).Rows(0).Item(5).ToString();
}
MessageBox.Show(str);

run in debug mode with putting break point over this code so u get it better.
if it skip if condition then no row is coming from database ok so check query if not going in if condition.

replay me feedback after testing.

Re: Query

N a v a n e e t h20-Mar-07 23:12

N a v a n e e t h

20-Mar-07 23:12

Nekshan wrote:
//string str = sd.Tables(0).Rows(0).Item(0);
//for (i = 0 To ds.Tables(0).Rows.Count)
for(int i = 0;i<=ds.Tables(0);i++)
{
string str = sd.Tables(0);
MessageBox.Show(str);
}

Try changing () to [].

Nekshan wrote:
string str = sd.Tables(0);

How can u assign table object to string ?

printf("Navaneeth!!")

www.w3hearts.com

Re: Query

com.neeraj20-Mar-07 23:21

com.neeraj

20-Mar-07 23:21

You can simplay conconate the output fild in sql query
like
select field1+field2+....+finldn as newfieldname from tablename
now you get only one value per row
then as same as you have done
Check it
I have not try but soure about it.

Art network with C#

pariisa20-Mar-07 22:21

pariisa

20-Mar-07 22:21

Art network with C#

V.20-Mar-07 22:39

20-Mar-07 22:39

What about it?

V.
I found a living worth working for, but haven't found work worth living for.

PlayByTheRules20-Mar-07 23:46

PlayByTheRules

20-Mar-07 23:46

pariisa wrote:
Art network with C#

Syntax error: Missing verb or verb misconjugated.

If "art" is used as an ajective and "network" the noun then the question or sentence is missing a verb.

If "Art" is used as a proper noun (the diminutive form of "Arthur" and "network" is a misconjugated verb, should be "networks", then this statement is missing context. Who is Arthur, and what does he wish to network with C#?

Pete O'Hanlon20-Mar-07 23:50

20-Mar-07 23:50

PlayByTheRules wrote:
Who is Arthur, and what does he wish to network with C#?

He wants to take it out to dinner. A nice meal, with a few glasses of wine. Maybe a gypsy band playing in the backgroung. Then, who knows?

Deja View - the feeling that you've seen this post before.

Russell Jones21-Mar-07 1:12

Russell Jones

21-Mar-07 1:12

PlayByTheRules wrote:
If "Art" is used as a proper noun (the diminutive form of "Arthur" and "network" is a misconjugated verb, should be "networks", then this statement is missing context. Who is Arthur, and what does he wish to network with C#?

I believe that network is being used as a verb in the imperative and there should therefore be a comma or exclamation mark

Art! Network with c#.

Russell

Pete O'Hanlon21-Mar-07 2:22

21-Mar-07 2:22

Ooh. I like that one.

Deja View - the feeling that you've seen this post before.

Having issues with Object comparison [modified]

Colin Angus Mackay21-Mar-07 4:52

Colin Angus Mackay

21-Mar-07 4:52

Russell Jones wrote:
Art! Network with c#.

Very good! I like that interpretation.

Upcoming events:
* Edinburgh: Web Security Conference Day for Windows Developers (12th April)
* Glasgow: Introduction to AJAX (2nd May), SQL Server, Mock Objects

My website

myNameIsRon20-Mar-07 20:59

20-Mar-07 20:59

Hi,
I'm tying to use code from the MS web site (Implement a DataSet GROUP BY Helper Class ):
http://support.microsoft.com/kb/326145

The code works well with the DataTable sample they show, but when I use a DataTable populated from an Access database, the object comparison does not work. It only works if I convert to string... any idea why?

********************************************************************************
if (!ColumnEqual( LastSourceRow[Field.FieldName, SourceRow[Field.FieldName] ))
{// yada }

private bool ColumnEqual(object a, object b)
{
/*
* Compares two values to see if they are equal. Also compares DBNULL.Value.
*
* Note: If your DataTable contains object fields, you must extend this
* function to handle them in a meaningful way if you intend to group on them.
*/
if ((a is DBNull) && (b is DBNull))
return true; //both are null
if ((a is DBNull) || (b is DBNull))
return false; //only one is null
return (a==b); //value type standard comparison
}
*********************************************************************************
I did this to make it work:

if (!ColumnEqual( LastSourceRow[Field.FieldName].ToString(), SourceRow[Field.FieldName].ToString() ))
{//yada }

private bool ColumnEqual(string a, string b)
{
/*
* Compares two values to see if they are equal. Also compares DBNULL.Value.
*
* Note: If your DataTable contains object fields, you must extend this
* function to handle them in a meaningful way if you intend to group on them.
*/
if ((a == "") && (b == ""))
return true; //both are null
if ((a == "") || (b == ""))
return false; //only one is null
return (a == b); //value type standard comparison
}

thanks,
Ron

-- modified at 3:07 Wednesday 21st March, 2007

joon _vh.20-Mar-07 22:09

20-Mar-07 22:09

it works here, with datatable and regular cells.

<br />
            DataTable dt = new DataTable("temp");<br />
            dt.Columns.Add("col1");<br />
            dt.Rows.Add("row1");<br />
            dt.Rows.Add("row2");<br />
            dt.Rows.Add("row3");<br />
<br />
            Console.WriteLine(ColumnEqual(dt.Rows[1][0], dt.Rows[1][0]));<br />
            Console.Read();

--> This outputs True (can test it in an empty console app).

You should check it with the debugger, using breakpoints, to see what values are actually compared.

Visual Studio can't evaluate this, can you?

public object moo<br />
        {<br />
__get { return moo; }<br />
__set { moo = value; }<br />
}

myNameIsRon21-Mar-07 5:05

21-Mar-07 5:05

Hi joo,
I used MessageBox to show me the comparison, row by row, and they do have the same string in the object (object.ToString()).
They don't compair to true if left in the object (This only happends if the DataTable is populated by ADO). If building the DataTable by code (as in your example), this works fine.

Ron

joon _vh.21-Mar-07 5:23

21-Mar-07 5:23

It still works when I use ADO...
Your problem appears to be very strange.

            SqlConnection conn = new SqlConnection("connstring");<br />
            SqlDataAdapter da = new SqlDataAdapter("select * from [table]",conn);<br />
            DataSet ds = new DataSet();<br />
            da.Fill(ds);<br />
            dataGridView1.DataSource = ds;<br />
<br />
            Console.WriteLine(ds.Tables[0].Rows[1][1] == ds.Tables[0].Rows[1][2]); //returns false<br />
            Console.WriteLine(ds.Tables[0].Rows[1][1] == ds.Tables[0].Rows[1][1]); //returns true

Visual Studio can't evaluate this, can you?

public object moo<br />
        {<br />
__get { return moo; }<br />
__set { moo = value; }<br />
}

myNameIsRon21-Mar-07 5:40

21-Mar-07 5:40

Yes, I spent hours trying to figure out why it was not grouping. Finally, I tried changing the object to a string right at the compairison (a.ToString() == b.ToString()) and magically the grouping worked.

Damn, I guess I have to go to work (day job).

Ron

joon _vh.21-Mar-07 5:46

21-Mar-07 5:46

Yes, it is probably a good solution. But I still think it's strange that it didn't work before, because here in my sandboxapp it does. Weird.

Have fun working Wink | ;)

Visual Studio can't evaluate this, can you?

public object moo<br />
        {<br />
__get { return moo; }<br />
__set { moo = value; }<br />
}

myNameIsRon21-Mar-07 16:50

21-Mar-07 16:50

Hi again joon,

I've been playing around with the stock code again...
I've noticed that if you try and Group By the other columns (OrderID",Int32) [I did change a few rows so some are the same value], it will not group. The stock code only seems to group on a string column? Could you check it our with your sandboxapp?

thanks,
Ron

myNameIsRon21-Mar-07 18:55