Discussions - .NET (Core and Framework) Discussion Boards

Hammad Mansoor18-Aug-09 20:45

18-Aug-09 20:45

Hi all

When I execute this query in Oracle I get perfect results.

1. SELECT * FROM TOTAL_CASES
2. WHERE (TRIM("NTN") = TRIM(:NTN)
3. OR '%'||upper("NAME")||'%' LIKE '%'||upper(:NAME)||'%')
4. AND (upper(TRIM("STATUS")) LIKE nvl(upper(TRIM(:STATUS)),'%'||''||'%'))

It means that if :STATUS is NULL then give all results matching step 3 or 4. If there is a value for :STATUS then also filter results according to that value.

This query gives accurate results when executed in SQL. However, I also use this to populate a Data Grid in ASP.NET. When STATUS is NULL in ASP.NET, the Data Grid shows no results. However, when I select value for the STATUS, then it shows results according to the value chosen for STATUS.

Please help me as to how to populate Data Grid when I select no value for STATUS.

Thanks.

Hammad

Re: ASP.NET not executing Oracle query

Kalyan_A19-Aug-09 3:08

Kalyan_A

19-Aug-09 3:08

hi hammad

it is possible that your page is passing a blank string instead of NULL to the query.

check if the following works in line 4

AND (upper(TRIM("STATUS")) LIKE ('%' || upper(TRIM(nvl(:STATUS,'%')) || '%')

i havent been able to check it but hope that helps.

Obfuscator

Suren_112618-Aug-09 18:39

Suren_1126

18-Aug-09 18:39

Hi ,someone suggest an obfuscation tool and if anyone used .NetReactor ,can u specify in detail the problems you are currently facing with it.

Re: Obfuscator

Moreno Airoldi18-Aug-09 22:51

Moreno Airoldi

18-Aug-09 22:51

Eazfuscator, been using it for some time now. It's free and offers all I need (namely, string encryption besides good obfuscation).

2+2=5 for very large amounts of 2
(always loved that one hehe!)

Re: Obfuscator

Hristo-Bojilov19-Aug-09 1:41

Hristo-Bojilov

19-Aug-09 1:41

Nice one Moreno Airoldi.I was looking for good free obfuscator too. Smile | :)

Life is a stage and we are all actors!

Re: Obfuscator

Moreno Airoldi20-Aug-09 0:06

Moreno Airoldi

20-Aug-09 0:06

Who wasn't hehe! Smile | :)

2+2=5 for very large amounts of 2
(always loved that one hehe!)

ASP.Net Activex problem

smamidi18-Aug-09 11:53

smamidi

18-Aug-09 11:53

Hello all,

I have a problem using activex in my asp.net webpage..
I have developed an activex control code:
Public str As String
Public lastpath As String

Event Acceptpath(str As String)

Private Sub Drive1_Change()
Dir1.path = Drive1.Drive
End Sub

Private Sub Submit_Click()
Text1.Text = Dir1.path
RaiseEvent Acceptpath(Dir1.path)
End Sub

Public Property Let Last(path As String)
lastpath = path
PropertyChanged "Last"
MsgBox (lastpath)
End Property

Public Property Get Last() As String
Last = lastpath
End Property

'Public Property Let Last(path As String)
'lastpath = path
'PropertyChanged "Last"
'End Property

Private Sub Last_Click()
Dir1.path = lastpath
MsgBox (lastpath)
End Sub

Private Sub UserControl_Initialize()
Dir1.path = "E:\Myproject\controls"
End Sub

Private Sub UserControl_ReadProperties(PropBag As PropertyBag)
lastpath = PropBag.ReadProperty("Last")
End Sub

Private Sub UserControl_WriteProperties(PropBag As PropertyBag)
Call PropBag.WriteProperty("Last", lastpath)
End Sub

I have created the CAB file and added to the asp.net page so I can see activex in my page when i run the code but when I send values to the activex control it is not showing any thing.. ASP.Net web code:

<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>
<code>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>My ActiveX control<title>   
           
</head>
<body>

<OBJECT ID="UserControl1" 
CLASSID="CLSID:A9CC0BA6-38B7-4CCA-9244-648EA26F5FD1" 
codebase="Project1.CAB#version=1,0,0,0>
<PARAM name="Last" value="E:\myproject" /></OBJECT>;
   <form id="form1" runat="server">
   
    </form>

</body>
</html>

any help with this code...

So that i can send the values and retrive from Activex...

Thanks
MSK

Message Removed

18-Aug-09 6:20

N_tro_P

18-Aug-09 6:20

Message Removed

Re: Program Icon when using a Setup Project

Moreno Airoldi18-Aug-09 7:52

Moreno Airoldi

18-Aug-09 7:52

The properies for the link to the file in the setup project's file system view contain an "icon" field that lets you select the icon you want to show.

Be aware that the icon must be either copied as a separate file to the installation directory or embedded in the exe - the dialog box you bring up from the "icon" property will let you select one of these.

2+2=5 for very large amounts of 2
(always loved that one hehe!)

Message Removed

18-Aug-09 10:12

N_tro_P

18-Aug-09 10:12

Message Removed

Re: Program Icon when using a Setup Project

Moreno Airoldi18-Aug-09 14:26

Moreno Airoldi

18-Aug-09 14:26

I hope I understood correctly what you need - to set the icon shown in the Programs menu for your executable.

You can find the "Icon" property this way:

- right click on the setup project's name in the Solution Explorer
- click on "View" and then on "File System"
- in the File System view select "User Program's Menu"
- locate the link to your executable, which will usually be under a folder in "User Program's Menu", and select it
- the "Properties" tab will now show the link's properties, including "Icon"

Hope it's all clear and it's what you need. Smile | :)

2+2=5 for very large amounts of 2
(always loved that one hehe!)

Message Removed

20-Aug-09 10:14

N_tro_P

20-Aug-09 10:14

Message Removed

Re: Program Icon when using a Setup Project

Moreno Airoldi20-Aug-09 22:48

Moreno Airoldi

20-Aug-09 22:48

Collin Jasnoch wrote:
It would be nice if the icon propogated over from the actual project... but I guess you can only ask for so much from MS.

Too true! It's just nonsense that the icon is not taken automatically from the exe.

2+2=5 for very large amounts of 2
(always loved that one hehe!)

EnterpriseLibrary 4.1

Helfdane18-Aug-09 4:42

Helfdane

18-Aug-09 4:42

Hi,

I've been asked to port a .net 1.1 application with entlib of january 2006 to .net 3.5 with entlib 4.1. It seems most things are transported okay, but some classes inherit from the ProviderData class. I am unable to locate it in the 4.1 package. I tried google, but somehow my googling skills have abandoned me.

The ProviderData class is present in entlib2006 under Microsoft.Practices.EnterpriseLibrary.Configuration. (believe it's entlib version 1.1 as I don't have the installed packages, I only have a bunch of solution files with references).

Anyone knows where I can find it now or what action I should take to work around this problem?

The consumer isn't a moron; she is your wife.

Export DataSet To Excel [modified]

#realJSOP18-Aug-09 2:53

#realJSOP

18-Aug-09 2:53

I found some code on the net that allows me to export a dataset/datatable to Excel, and as far as I know the code works (it actually creates a XML file with a ".xls" extension.

However, when I try to open the file in Excel, it displays as an XML file. The first part of the file looks like this:

<?xml version="1.0" encoding="utf-8"?>
<?mso-application progid="Excel.Sheet"?>
<ss:Workbook xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet">
  <ss:Styles>
    <ss:Style ss:ID="General" />
    <ss:Style ss:ID="Number">
      <ss:NumberFormat ss:Format="General Number" />
    </ss:Style>
    <ss:Style ss:ID="DateTime">
      <ss:NumberFormat ss:Format="General Date" />
    </ss:Style>
    <ss:Style ss:ID="Currency">
      <ss:NumberFormat ss:Format="Currency" />
    </ss:Style>
    <ss:Style ss:ID="ShortDate">
      <ss:NumberFormat ss:Format="Short Date" />
    </ss:Style>
  </ss:Styles>
  <ss:Worksheet ss:Name="Sheet1">
    <ss:Table>
      <ss:Row>
        <ss:Cell>

In Notepad, the VS IDE, and Word, the xml appears exactly as you see it above. In Excel, there's a few weird characters preceding the first < character - I don't know if this is an indication of what's wrong, but I thought I'd mention it. Can anyone help?

EDIT===============================================================

I also tried to use DataSet.WriteXML, and that file acts the same way.

I also tried opening the file in OpenOffice and it does the same thing as Excel.

"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001

modified on Tuesday, August 18, 2009 9:18 AM

Re: Export DataSet To Excel [modified]

Eddy Vluggen18-Aug-09 5:21

Eddy Vluggen

18-Aug-09 5:21

What version of Excel are you using? I just tried to load your XML in Excel 2002, and it doesn't show any strange characters at the start. When I enter some data and save, the structure gets modified to this;

<?xml version="1.0"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:o="urn:schemas-microsoft-com:office:office"
 xmlns:x="urn:schemas-microsoft-com:office:excel"
 xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:html="http://www.w3.org/TR/REC-html40">
<Worksheet ss:Name="Sheet1">
  <Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="2" x:FullColumns="1"
   x:FullRows="1">
   <Row>
    <Cell><Data ss:Type="String">Hello</Data></Cell>
   </Row>
  </Table>
  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
   <Selected/>
   <Panes>
    <Pane>
     <Number>3</Number>
     <ActiveRow>1</ActiveRow>
    </Pane>
   </Panes>
   <ProtectObjects>False</ProtectObjects>
   <ProtectScenarios>False</ProtectScenarios>
  </WorksheetOptions>
 </Worksheet>
</Workbook>

This seems to work on both 2002 and 2007, but Excel punishes me whenever I try to remove the header. I'm guessing that that's not the problem, and that your document is somehow not encoded as UTF-8. Have you copied/pasted fragments across a language-barrier?

The computer is mightier than the pen, the sword, and usually the programmer.

modified on Tuesday, August 18, 2009 2:29 PM

MSBuild [modified]

Tristan Rhodes18-Aug-09 0:45

Tristan Rhodes

18-Aug-09 0:45

Hi Guys -

I've been experimenting with MSBuild, and in my quest for meaninful output, have found an odd problem with displaying messages:

I have the following section:

<Target Name="MyAfterBuild">
	<Message Text="==================MESSAGE=================="/>
	<Warning Text="==================WARNING=================="/>
	<Error Text="==================ERROR=================="/>
<Target/>

Which displays an Error Message, a Warning Message, but no normal Message in the error list.

I have set the MSBuild output to Max, and set the message Importance to High, but still it is not displaying any output. What can i do to fix this?

Regards

-------------------------------

Carrier Bags - 21st Century Tumbleweed.

modified on Tuesday, August 18, 2009 6:52 AM

How to change type of JIT compiler

Rohit Kulkarni18-Aug-09 0:33

Rohit Kulkarni

18-Aug-09 0:33

Hi all,

I want to know how we can change JIT compiler for our application. As per my knowledg when we use VS.Net IDE, we get a standard JIT. What if I want pre-JIT or econo-JIT? How I can change mode of compilation.....

Re: How to change type of JIT compiler

Eddy Vluggen18-Aug-09 1:52

Eddy Vluggen

18-Aug-09 1:52

There's two article's on CodeProject that might help you;
* JIT methods at runtime[^]
* Pre-compile (pre-JIT) your assembly on the fly, or trigger JIT compilation ahead-of-time[^]

Enjoy the read Smile | :)

Hug a developer[^]

Re: How to change type of JIT compiler

Rohit Kulkarni18-Aug-09 23:15

Rohit Kulkarni

18-Aug-09 23:15

Thanks eddy.....

Need some help with socket programming.

Soumya9217-Aug-09 22:18

Soumya92

17-Aug-09 22:18

I am using VB.net, but samples in any language will do.
The problem is that I have to connect to a secure site with an invalid certificate. Every browser based control fails, so I have turned to raw sockets. The website is for internal use only, however its certificate is unverified.
I need to know what commands to send and how to respond over https. My socket app, so far, can connect to http, and even view pages. On https, any command like GET /url?parameters HTTP/1.1 gives me an empty response.
Thanks in advance.

~ Soumya92

Re: Need some help with socket programming.

Mark Salsbery19-Aug-09 6:47

Mark Salsbery

19-Aug-09 6:47