Re: webBrowser.Url == null ? - C# Discussion Boards

First Prev Next

Re: how to 4 sql command to reduce 1 sql command

Colin Angus Mackay31-Oct-07 3:27

Colin Angus Mackay

31-Oct-07 3:27

eraydeniz wrote:

That isn't very nice. The guy tries to help you and you respond with a MAD face. If the answer is not the one you seek then perhaps you need to ask a better question.

Upcoming FREE developer events:
* Glasgow: SQL Server Managed Objects AND Reporting Services ...

My website

Re: how to 4 sql command to reduce 1 sql command

Frank Kerrigan31-Oct-07 3:40

Frank Kerrigan

31-Oct-07 3:40

That was a fair suggestion show some respect sir.

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)

http://www.frankkerrigan.com/[^]

Re: how to 4 sql command to reduce 1 sql command

Paul Conrad31-Oct-07 13:59

Paul Conrad

31-Oct-07 13:59

Exactly, I don't understand the mad face for a decent response.

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

Re: how to 4 sql command to reduce 1 sql command

Colin Angus Mackay31-Oct-07 3:26

Colin Angus Mackay

31-Oct-07 3:26

eraydeniz wrote:
how to 4 sql command to reduce 1 sql command?

That doesn't make much sense.

Depending on how that should be interpreted there are two answers I can think of:

You could UNION the results together to form one result set.

OR

You could just execute it all in on SqlCommand and get 4 result sets back, but it is sent as one SqlCommand.

Upcoming FREE developer events:
* Glasgow: SQL Server Managed Objects AND Reporting Services ...

My website

webBrowser.Url == null ?

ZenyukIV31-Oct-07 2:46

ZenyukIV

31-Oct-07 2:46

Could You please provide me with solution
I have a panel and only one control on it - WebBrowser control. When I try to access to webBrowser.name is OK, but webBrowser.Url == null

WebBrowser webBrowser = webBrowserTabControl.SelectedPanel.Controls[0] as WebBrowser;<br />
                webBrowsersCollection.SelectedWebBrowser = webBrowser.Name;<br />
                currentURL = webBrowser.Url.ToString();

Thanks in advance

Re: webBrowser.Url == null ?

pmarfleet31-Oct-07 2:52

pmarfleet

31-Oct-07 2:52

Have you browsed to a URL? If not, the Url property is going to be null. You should check this before calling the ToString() method on the Uri object instance.

Paul Marfleet

Re: webBrowser.Url == null ? [modified]

ZenyukIV31-Oct-07 21:36

ZenyukIV

31-Oct-07 21:36

Thank for all

I created additional dictionary to collect URL, becouse it seems to me that WebBrowswer has URL property resolved after "web paged displayed", But I can't create additional thread to wait while it will be finised

-- modified at 8:29 Thursday 1st November, 2007

Re: webBrowser.Url == null ?

laserbaronen31-Oct-07 2:53

laserbaronen

31-Oct-07 2:53

probably because it has no url set?

fafafa, ringakta icke sådant som bringa ack så naggande högönsklig välmåga å baronens ära.

DataGridView

half-life31-Oct-07 2:38

half-life

31-Oct-07 2:38

HI,

i've got a DataGridView to which i load data from a file.
i like to know how can i change the color of a cell (or the text)

the idea is :
when i load the data i check a certain cell an if it's Value <0 then i like
to see the (Value in a Red Color)

i'm using this kind of insert to the datagridview :

<br />
for(....)<br />
{<br />
 string cColumn1 = value;<br />
 string cColumn2 = value;<br />
 .<br />
 .<br />
 .<br />
<br />
 Object [] rRow = { cColumn1 ,cColumn1 };<br />
 dataGridView1.Rows.Add(rRow);<br />
}<br />

THNKS in Advance Smile | :)

Have Fun
Never forget it

Re: DataGridView

Frank Kerrigan31-Oct-07 3:44

Frank Kerrigan

31-Oct-07 3:44

Use the itemdatabound event look at an article I wrote a while ago for this on DataGrids which will work for gridviews.
http://www.codeproject.com/aspnet/PrettyDatagrids.asp[^]

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)

http://www.frankkerrigan.com/[^]

Re: .NET Framework 3.0 var data type - Aspect Oriented

Pete O'Hanlon31-Oct-07 2:44

Pete O'Hanlon

31-Oct-07 2:44

Please don't cross post. It's not very polite.

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

Image URL as .aspx page

jaishankar270431-Oct-07 1:43

jaishankar2704

31-Oct-07 1:43

Hi, I am using VS 2005.
I need to display an image in my web form.
i am giving the Image URL as a .aspx file(say Image.aspx)
In Image.aspx, i am creating & saving an image & writing the code to save as Response.OutputStream.

In local server, its working fine but after diployment its giving an error as Cannot convert type 'ASP.templates_image_aspx' to 'System.Web.UI.WebControls.Image'

What shall i do.. Please help me..

Regards,
JaiShankar

Re: Image URL as .aspx page

Paul Conrad31-Oct-07 14:00

Paul Conrad

31-Oct-07 14:00

jaishankar2704 wrote:
local server, its working fine but after diployment its giving an error

Is the deployment machine configured the same as the local machine?

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

Assigning value to Column in DatagridView

Osama12331-Oct-07 1:37

Osama123

31-Oct-07 1:37

Hi All,

I have datagridview populated from a database thru a datasource.
I have an integer col status with values (1,2,3)
I want to Fill grid with values for status ex 1 is Active,2 is Inactive and 3 is default
How shud i do this.

I am using Visual Studio C# 2005 express edition.

Regards,
Ahmad

Re: Assigning value to Column in DatagridView

Frank Kerrigan31-Oct-07 3:42

Frank Kerrigan

31-Oct-07 3:42

use the itemdatabound to change the value.

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)

http://www.frankkerrigan.com/[^]

How to use ExecuteReader() with Oracle DB?

babutkchn31-Oct-07 1:30

babutkchn

31-Oct-07 1:30

hi,

In my appication i'm using Oracle as a back end. In that when i'm using ExecuteReader() it shows an exception. Can any one of help me to solve this issue.

<br />
oleDBConnection = new OleDbConnection(connectString);                   <br />
                    string query = "SELECT V_FIRST_NAME,V_LAST_NAME,V_PHONE_NUMBER,V_EMAIL,V_FAX_NUMBER,V_ADDRESS,V_TITLE,V_POSTAL_CODE,V_COUNTRY from UserDetails where (V_USER_ID = ?) AND (V_PASSWORD = ?)";<br />
<br />
                    OleDbCommand oledbCmd = new OleDbCommand(query, oleDBConnection);<br />
                    oledbCmd.CommandText = query;<br />
<br />
                    oledbCmd.CommandType = CommandType.Text;<br />
<br />
                    OleDbParameter par = oledbCmd.Parameters.Add("UserName", OleDbType.VarWChar, 50);<br />
                    OleDbParameter parm = oledbCmd.Parameters.Add("password", OleDbType.VarWChar, 50);<br />
<br />
                    oledbCmd.Parameters["UserName"].Value = userName;<br />
                    oledbCmd.Parameters["password"].Value = password;<br />
<br />
                    oledbCmd.Connection = oleDBConnection;<br />
<br />
                    oleDBConnection.Open();<br />
                    <br />
                    OleDbDataReader dr ;<br />
                    dr = oledbCmd.ExecuteReader();<br />

It threw an exception when executing the last line. The exception states that Unspecified error.Oracle error occured,but error message could not retrieved from Oracle.Data Type is not supported.

Thanks in advance

Babu

Re: How to use ExecuteReader() with Oracle DB?

Andrei Ungureanu31-Oct-07 2:15

Andrei Ungureanu

31-Oct-07 2:15

babutkchn wrote:
string query = "SELECT V_FIRST_NAME,V_LAST_NAME,V_PHONE_NUMBER,V_EMAIL,V_FAX_NUMBER,V_ADDRESS,V_TITLE,V_POSTAL_CODE,V_COUNTRY from UserDetails where (V_USER_ID = ?) AND (V_PASSWORD = ?)";

You add parameters to the query, but you don't specify anywhere these parameters. Try this

 string query = "SELECT V_FIRST_NAME,V_LAST_NAME,V_PHONE_NUMBER,V_EMAIL,V_FAX_NUMBER,V_ADDRESS,V_TITLE,V_POSTAL_CODE,V_COUNTRY from UserDetails where (V_USER_ID = @UserName) AND (V_PASSWORD = @password)";

OleDbCommand oledbCmd = new OleDbCommand(query, oleDBConnection);
oledbCmd.CommandText = query;

oledbCmd.CommandType = CommandType.Text;

OleDbParameter par = oledbCmd.Parameters.Add("@UserName", OleDbType.VarWChar, 50);
OleDbParameter parm = oledbCmd.Parameters.Add("@password", OleDbType.VarWChar, 50);

Hope it helps.

There are 10 kinds of people: those who understand binary and those who don't

Re: How to use ExecuteReader() with Oracle DB?

babutkchn31-Oct-07 2:22

babutkchn

31-Oct-07 2:22

we are using oracle not sql server('@symbol is not supported in Oracle').
give me the solution

Re: How to use ExecuteReader() with Oracle DB?

Andrei Ungureanu31-Oct-07 3:51

Andrei Ungureanu

31-Oct-07 3:51

Ok, my bad. But still, you have to find a way to specify the parameters in the query. I think that that's your problem.

There are 10 kinds of people: those who understand binary and those who don't

how to pass link through gridview using linkbutton [modified]

alok217131-Oct-07 1:15

alok2171

31-Oct-07 1:15

how to pass link through gridview using linkbutton..i dont want to delete it.just pass a link.

alok2171

Re: how to pass link through gridview using linkbutton

soni uma31-Oct-07 1:28

soni uma

31-Oct-07 1:28

Here Code For the Delete Link In grid view

<asp:GridView DataKeyNames="CategoryID" ID="GridView1"
runat="server" AutoGenerateColumns="False"
OnRowCommand="GridView1_RowCommand"
OnRowDataBound="GridView1_RowDataBound"
OnRowDeleted="GridView1_RowDeleted" OnRowDeleting="GridView1_RowDeleting">
<Columns>
<asp:TemplateField HeaderText="Select">
<ItemTemplate>
<asp:LinkButton ID="LinkButton1"
CommandArgument='<%# Eval("CategoryID") %>'
CommandName="Delete" runat="server">
Delete</asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>

:-

Logical Drive Info

half-life31-Oct-07 0:29

half-life

31-Oct-07 0:29