|
str = dss.Tables[0].Rows[0].Item[1].ToString();
It is giving error at all ".Item[1]" s of the block :
'System.Data.DataRow' does not contain a definition for 'Item'
|
|
|
|
|
here items(1) its working in vb u try by putting dot(.)after rows(0). i think columns(1) is there. try in debug mode so u know exactly.
|
|
|
|
|
No, '.columns[1]' is also not there after .rows[0]
After tables[0].rows[0] is there and
------tables[0].columns[0] is there.
how to use?
if possible chk it wen u have time, i m leaving office now.
Going home, if net is working send u the copy of documentatn. ok.
cu soon. tc.
thanx.
regards nekshan.
|
|
|
|
|
ok. columns(0).item(0).tostring()
or columns(0).rows(0).tostring()
try this.
|
|
|
|
|
Nekshan wrote: 'System.Data.DataRow' does not contain a definition for 'Item'
You get this error because 'Item' doesn't exist.
Use this instead:
str = dss.Tables[0].Rows[0][1].ToString();
or
str = dss.Tables[0].Rows[0].ItemArray[1].ToString();
Visual Studio can't evaluate this, can you?
public object moo<br />
{<br />
__get { return moo; }<br />
__set { moo = value; }<br />
}
|
|
|
|
|
Thank you joon_ 
|
|
|
|
|
Don't use .Item[1]. Instead, you would write this as dss.Tables[0].Rows[0][1].ToString();. Note that it is a bad idea to rely on the ordinal position though - try using the column name instead. That way, if you reorder the columns in your query you aren't going to get unexpected results.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
i will call u in night ok.bye..
|
|
|
|
|
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)(0).tostring()
str += ds.Tables(0).Rows(0)(1).ToString();
str += ds.Tables(0).Rows(0)(2).ToString();
str += ds.Tables(0).Rows(0)(3).ToString();
str += ds.Tables(0).Rows(0)(4).ToString();
}
MessageBox.Show(str);
|
|
|
|
|
good carry on. mane to rate tav avto hato. hamna thoru saru che.bye..
|
|
|
|
|
|
waah.good. i will call u in night.i want to tell u 2mow story. here work is hard. bye.
|
|
|
|
|
hi all,
I have a string containing text data.
How can i know whether the text is bold or italic or a normal text in C#.Is there any property through which i can determine this?
Thanks in advance.
Regards
Anuradha
|
|
|
|
|
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.
|
|
|
|
|
Dim ds As DataSet1 // this is in vb.
how to declare this in c#? 
|
|
|
|
|
sorry no dataset1 it is dataset. which u already declare in your code.
like i think. Dataset ds = new Dataset();
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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 />
}
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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 ?
|
|
|
|
|
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.
|
|
|
|
|
|
What about it?
V.
I found a living worth working for, but haven't found work worth living for.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
