ASP Free Forums - .NET Development

Changing font color based on cell value....

jpritch — Thu, 16 May 2013 00:34:34 GMT

I am a total newbie at this and am having trouble changing the color of the font based on a cell value - red if negative, green if positive.

Here is my code... any help would be appreciated.

<%@ Control Language="vb" AutoEventWireup="false" CodeBehind="Control2.ascx.vb" Inherits="OSDASHBOARD20.Control2" %>

Width="1000px" DataSourceID="SqlDataEasternDivision" Font-Bold="True"
Font-Names="Times New Roman" ForeColor="#333333" EmptyDataText="-" HorizontalAlign="Left"
AllowSorting="True" OnLoad="GridView1_Load">

SortExpression="FirstName">

ControlStyle-CssClass="jt" ControlStyle-Width="80px" DataTextFormatString="{0:c0}"
DataNavigateUrlFields="FirstName">

ControlStyle-CssClass="jt" ControlStyle-Width="75px"
DataTextFormatString="{0:c0}" DataNavigateUrlFields="FirstName">

ControlStyle-CssClass="jt" ControlStyle-Width="75px"
DataTextFormatString="{0:c0}" DataNavigateUrlFields="FirstName">

ControlStyle-CssClass="jt" ControlStyle-Width="75px"
DataTextFormatString="{0:c0}" DataNavigateUrlFields="FirstName">

ControlStyle-CssClass="jt" ControlStyle-Width="80px" DataTextFormatString="{0:c0}"
DataNavigateUrlFields="FirstName">

SortExpression="YTDATTAINMENT" HtmlEncode="False">

ControlStyle-CssClass="jt" ControlStyle-Width="80px" DataTextFormatString="{0:c0}"
DataNavigateUrlFields="FirstName">

ControlStyle-CssClass="jt" ControlStyle-Width="75px"
DataTextFormatString="{0:c0}" DataNavigateUrlFields="FirstName">

SortExpression="NetInvoiced" HtmlEncode="False">

ControlStyle-CssClass="jt" ControlStyle-Width="75px" DataTextFormatString="{0:c0}" Visible="false"
DataNavigateUrlFields="FirstName">

ProviderName="<%$ ConnectionStrings:RSMGMTConnectionString.ProviderN ame %>"

SelectCommand="SELECT FirstName, [YTD FEES], [FutureBindingDeals], [InvandFutureInv], [YTD Fees Invoiced], Change, [YTD BUDGET], YTDAttainment, Attainment, NetInvoiced, SortEmployeesinDash, [SumofBudget Revenue] FROM [RS Dashboard Chart] WHERE (FirstName = 'Sylvain') OR (FirstName = 'Gino') OR (FirstName = 'DavidK') ORDER BY SortEmployeesinDash DESC">

Crystal Reports 11.5 and VisualStudio 2005

arturo.franco — Wed, 15 May 2013 21:46:10 GMT

HI:

I've already created a different reports on CR 11.5, and they are running well, in fact, if I asing one of these as source of CrystalReportViewer control in VS2005, it runs well.

My problem is, I need to crate an application for let a user to select the report that he/she need to see, I'm trying to do this changin th ReportSource with an OnCLick event from a button. Every time that I try to run the report, it comes an error prompted taht just said, "The Report Can't be shown" or something like this.

Could somebody help me to undertand how to run a report builded in Crystal outside of VS2005?

I just have 2 months progarmming.

Thank's a lot.

Adding records to a database. Its very simple but im stuck!!

Sanjay10 — Wed, 15 May 2013 12:10:30 GMT

Guyzz... Im working on my AL project and i have this task : Adding records to a MS ACCESS database. Im finding it hard and i would love to find the solution ... with some help...

Here's my code :

conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Sanjay XD\Desktop\Institution.mdb"

If Not conn.State = ConnectionState.Open Then
conn.Open()
End If
cmd.Connection = conn
cmd.CommandText = " INSERT INTO Student_Information_Table (First Name, Middle Name, Last Name)VALUES('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "' )"
'cmd.Parameters.AddWithValue("@firsttext", TextBox1.Text)
'cmd.Parameters.AddWithValue("@middletext", TextBox2.Text)
'cmd.Parameters.AddWithValue("@lasttext", TextBox3.Text)

cmd.ExecuteNonQuery()
conn.Close()

What would be the best method for authenticating users and retrieving only their info

codeman061988 — Wed, 08 May 2013 15:08:42 GMT

Hi,
I am developing a website in .NET 4.5. And C#.
I've got my MasterPage and Base Page all set up.
I am now to the point were I want to add a user login and registration page.
What would be the best method of storing the users data and what is the best method of retrieving user specific data on a member's page.
Rather than just a general Member's page, I would like the page to retrieve data specific to the user who is logged in.

In C# Windows Application

sam198979 — Tue, 07 May 2013 10:40:48 GMT

From my machine is it possible to retrieve the Systeminfo ,HostName,IP Address of other all machines working in organization. in C# Windows Application.

Combo box DATA Value Comparison problem

immad — Sat, 27 Apr 2013 08:32:48 GMT

i have a web page in this web page i have seven combo boxes. every combo box data come from sql server 2005 table. combobox name is
PC , RAM , IP ADDRESS , OPERATING SYSTEM , CPU , Mother Board , HARD DISK .
if i select PC AND RAM combo box value and this value matches from database TABLE then its show all the related data in crystal report viewer other vise its show a label that VALUES are not match. if i select PC , OPERATING SYSTEM and Mother Board data and if its match then all related data show on crystal report or if data not match then its show error that data not match.

my data is like this :

-PC---------------- IP ADDRESS------- Operating System ----------- CPU --------------------------------------------- mother board------ RAM--------- Hard disk
Pentium 4-----192.168.0.134------ Windows 7 ---- Intel(R) Pentium(R) 4 CPU 1.70GHz (1695 MHz)--07E4h (Compaq) -256 MB ---- 40 GB
Pentium 3-----192.168.0.215------ Windows XP ----- Intel Pentium III Xeon processor (3192 MHz) ---0M3849 (Dell Inc. )-512 MB --- 80 GB

for example if i select PC Pentium 4 and Ram 256 MB then it show all realted data in crystal report:
like this.
Pentium 4-----192.168.0.134------ Windows 7 ---- Intel(R) Pentium(R) 4 CPU 1.70GHz (1695 MHz)------ 07E4h (Compaq) ---256 MB ---- 40 GB

but if i select PC Pentium 4 and ram 512 MB then it give me error that data not match:

or if i select PC Pentium 4 and Ram 256 MB and IP ADDRESS 192.168.0.134 then it show all data in crsytal report
like this
Pentium 4-----192.168.0.134------ Windows 7 ---- Intel(R) Pentium(R) 4 CPU 1.70GHz (1695 MHz)------ 07E4h (Compaq) ---256 MB ---- 40 GB

but if i select PC Pentium 4 and Ram 256 MB and IP ADDRESS 192.168.0.215 then it give me error that data dont match.

in this problem i want C# coding.
Please Help ME i am new in .net.
Thanks in advance

Combo box Value Comparison problem

immad — Sat, 27 Apr 2013 08:09:19 GMT

i have a web page in this web page i have seven combo boxes. every combo box data come from sql server 2005 table. combobox name is
PC , RAM , IP ADDRESS , OPERATING SYSTEM , CPU , Mother Board , HARD DISK .
if i select PC AND RAM combo box value and this value matches from database TABLE then its show all the related data in crystal report viewer other vise its show a label that VALUES are not match. if i select PC , OPERATING SYSTEM and Mother Board data and if its match then all related data show on crystal report or if data not match then its show error that data not match.

my data is like this :

PC IP ADDRESS Operating System CPU mother board RAM Hard disk
Pentium 4-----192.168.0.134------ Windows 7 ---- Intel(R) Pentium(R) 4 CPU 1.70GHz (1695 MHz)------ 07E4h (Compaq) ---256 MB ---- 40 GB
Pentium 3-----192.168.0.215------ Windows XP -----Intel Pentium III Xeon processor (3192 MHz) ----- 0M3849 (Dell Inc. )---512 MB ---80 GB

for example if i select PC Pentium 4 and Ram 256 MB then it show all realted data in crystal report:
like this.
Pentium 4-----192.168.0.134------ Windows 7 ---- Intel(R) Pentium(R) 4 CPU 1.70GHz (1695 MHz)------ 07E4h (Compaq) ---256 MB ---- 40 GB

but if i select PC Pentium 4 and ram 512 MB then it give me error that data not match:

or if i select PC Pentium 4 and Ram 256 MB and IP ADDRESS 192.168.0.134 then it show all data in crsytal report
like this
Pentium 4-----192.168.0.134------ Windows 7 ---- Intel(R) Pentium(R) 4 CPU 1.70GHz (1695 MHz)------ 07E4h (Compaq) ---256 MB ---- 40 GB

but if i select PC Pentium 4 and Ram 256 MB and IP ADDRESS 92.168.0.215 then it give me error that data dont match.

in this problem i want C# coding.
Please Help ME i am new in .net.
Thanks in advance

Web application not working in IE10

ASPNEWBIE07 — Wed, 24 Apr 2013 21:39:19 GMT

Hi,

I have a website which is working good in IE9. But recently I have updated my IE9 to IE10 , then some of the webpages are not working properly.

I found a solution to forcebly render IE10 browser to IE9.
like this.
That works fine in local and test environments. But its not working in live environment.

If i open my website in IE, press F12( developer tools), in that browser mode - ie10 and document mode is getting like my solution which is - ie9.

If i change browser mode to IE10 compatibility view, website works fine in all 3 servers(local, test and live). but i can't setup each and everytime for IE10 compatibility view.

Is there any way to change browser mode to IE10 compatibility view through programatically(vb.net)

Thanks in advance. It's little bit urgent, can anyone help on this?