|
|
I have created on crosstab report in crystal report and applying the css to that report,and showing report in webapplication which is developed in .net (ASP and c#.net). I am trying to export that report, it export but css is lost.
can we export the report along with css? if yes How?
|
|
|
|
|
Good Afternoon All
I have a Code that write a WebConfig everytime it loads.
public void UpdateConfig(string strKey, string strValue)
{
Configuration objConfig = WebConfigurationManager.OpenWebConfiguration("~");
AppSettingsSection objAppsettings = (AppSettingsSection)objConfig.GetSection("appSettings");
if (objAppsettings != null)
{
objAppsettings.Settings[strKey].Value = strValue;
objConfig.Save();
}
}
Its working,on the Developement side, and i have deployed my app to the Testing side and when i go to the page i get the Following Error that i cant google, it seems it has something to do with the Permission. so i get the Following Error
Parser Error Message: An error occurred loading a configuration file: Access to the path 'C:\inetpub\wwwroot\o!Booking\1vc6a6ca.tmp' is denied.
[No relevant source lines]
Source File: C:\inetpub\wwwroot\o!Booking\web.config Line: 0
Thanks
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswam@its.co.za
|
|
|
|
|
Good Afternoon
Thanks for your Help.
The Problem was the Permission for the ASP.NET Account that was never inherrited when i created a Virtual Directory. The Following thread helped me
http://bytes.com/groups/net-asp/634802-configuration-error-web-config-no-relevant-source-line
Thank you
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswam@its.co.za
|
|
|
|
|
I am doing a project. Its 1 of the module is deigning of Forum same as the structure of Code project Forum. Can anyone suggest the database for it? Please...
|
|
|
|
|
Karthick_gc wrote: Can anyone suggest the database for it?
SQL Server?
|
|
|
|
|
Yes. I want the table structure for that?
|
|
|
|
|
Karthick_gc wrote: I want the table structure for that?
this depends exactly on your requirements ....
first think what functionality you want to have in your forum, then go on adding corresponding field to your database (or separate tables !)
Apurv
A man is but the product of his thoughts. What he thinks, he becomes.
.......Mahatma Gandhi
Be the change you want to see in the world.
.......Mahatma Gandhi
|
|
|
|
|
<pre>
<%@ Page Language="VB" MasterPageFile="~/MasterPage.master" Title="Untitled Page" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<script runat="server">
Dim MyReader As SqlDataReader
Dim mySQLConnection As SqlConnection
Dim mySQLCommand As SqlCommand
Dim PID As Integer
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs)
If (TextBox1.Text <> "") Then
Panel1.Visible = True
Panel2.Visible = True
Else
Panel1.Visible = False
Panel2.Visible = False
End If
End Sub
Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click
mySQLConnection = New SqlConnection("server=localhost;AttachDbFilename=C:\Documents and Settings\ANISHA\My Documents\Visual Studio 2005\ROHINI\WindowsApplication1\WindowsApplication1\Database.mdf;Integrated Security=True;User Instance=True")
mySQLCommand = New SqlCommand("SELECT * FROM PATIENT WHERE PID='111'", mySQLConnection)
Try
mySQLConnection.Open()
MyReader = mySQLCommand.ExecuteReader()
If (MyReader.Read()) Then
Panel1.DataBind()
End If
Catch ex As Exception
MsgBox(ex.ToString())
Finally
MyReader.Close()
mySQLConnection.Close()
End Try
End Sub
</script>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<center>
<table>
<tr>
<td colspan="2">
<asp:Label ID="Label2" runat="server" Height="4px" Text="Patient Details" Width="139px" Font-Bold="True" Font-Size="Larger"></asp:Label></td>
</tr>
<tr>
<td style="width: 114px">
<asp:Label ID="Label1" runat="server" Text="Patient Id"></asp:Label></td>
<td style="width: 100px">
<asp:TextBox ID="TextBox1" runat="server" Height="15px" Width="66px"></asp:TextBox></td>
</tr>
<tr>
<td colspan="2">
<asp:Button ID="Button2" runat="server" Text="Display" OnClick="Button2_Click" /></td>
</tr>
<tr><td style="width: 114px"><asp:Panel ID="Panel1" Visible="false" runat="server" Height="176px" Width="185px" HorizontalAlign="Left" BorderColor="Cyan" >
Panel1<br /><br /><br /><br /><br /><br /><br /><br /><br /><br />
<tr><td>
<asp:Label ID="Label3" runat="server" Text="Report Incident" Width="117px"></asp:Label></td>
<tr><td><asp:DropDownList ID="drop1" runat="server" Height="6px" Width="54px">
<asp:ListItem>Yes</asp:ListItem>
<asp:ListItem>No</asp:ListItem>
</asp:DropDownList></td><br /><br /><br />
<center>
<asp:Button ID="Button1" runat="server" Text="Enter to Report" PostBackUrl="~/Rep Entry Screen.aspx" OnClick="Button1_Click" /> </center>
</asp:Panel>
</td>
<td style="width: 100px">
<asp:Panel ID="Panel2" Visible="false" runat="server" Height="176px" Width="185px" HorizontalAlign="Left" BorderColor="Cyan" >
<center>
Displayed Report Entry Scren</center><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><center>
</center></asp:Panel>
</td>
</tr>
</table>
</center>
</asp:Content>
</pre>
Thanx,
KOUNDINYA
|
|
|
|
|
Hi i just give u a logic .
Bind Dataset ds or DataReader dr with Query ... select * from tablename where pid =@pid
for dataset use
if(ds.Teables[0].Rows.Count>0)
{
Panel1.DataBind()
}
else
{
"NOthing"
}
for datareader use
while(dr.read())
{
if(dr.HasRows())
{
Panel1.DataBind()
}
else
{
"NOthing"
}
}
Try This May Be This Help .
|
|
|
|
|
i think i did use the same logic... haven`t i??
Thanx,
KOUNDINYA
|
|
|
|
|
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<script type="text/javascript">
var change = false;
function showmsg(id) {
var res = confirm("proceed");
if (res)
change = true;
}
</script>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Label runat="server" ID="lbl" />
<asp:TextBox ID="TextBox1" runat="server" onblur = "showmsg(this.id)" ></asp:TextBox>
<asp:Button ID="Button1" runat="server" Text="Button"
OnClientClick = "return change;change=false;" onclick="Button1_Click" />
</div>
</form>
</body>
</html>
.cs
public partial class blurtest : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
lbl.Text = "test msg";
}
}
How can i set the label text here.
|
|
|
|
|
Hi expertzzz
i am working with a searching tool...i am using google API for finding the location ..
that latitute and longitude along with company address i am keeping in database...
i want to list some of nearest companies with my selected location..
eg: i selected a location "Grand Rapids"..from there i want to list the nearest location with in the specified kilometer range(eg:100 KM).
Regards
Rajeesh MP
|
|
|
|
|
Hi all,
I don`t know whether it`s the right forum to ask this question, i had some problems using the crystal reports.
Well the first problem is the crystal report that comes bundled with VS 2005 doesn`t support newline characters set through code behind. So to solve the issue you have to add the stored proc in the field explorer and drag in the field to report and tick the check box in field format to "can grow".
But then the proc has an input parameter which it receives from the querystring. I tried doing
rpt.SetParameterValue("@param1", Request("Trans_no").ToString)
but it always asks for this parameter before loading the report. Instead it should take it from the query string.
Does any one know how do i achieve this...
|
|
|
|
|
Solution found...
Just use in the foll code in your page load event
<br />
Dim paramField As New ParameterField()<br />
Dim paramFields As New ParameterFields()<br />
Dim paramDiscreteValue As New ParameterDiscreteValue()<br />
paramField.Name = "@param1"<br />
paramDiscreteValue.Value = Request("Trans_no").ToString<br />
paramField.CurrentValues.Add(paramDiscreteValue)<br />
paramFields.Add(paramField)<br />
CrystalReportViewer1.ParameterFieldInfo = paramFields<br />
|
|
|
|
|
Hi All,
I was trying to find out a correct regular expression to match 0 < i < 1 with no luck. It will be very helpful to me if you can provide me some help on wrtiting a regular expression to validate any values between in 0 and 1.
Thanks and Regards
Pani
|
|
|
|
|
|
You can use an online regular expression generator to validate your fields. This one is explains how to construct one-
http://gskinner.com/RegExr/[^][^]
Good luck!
Ranjit Viswakumar
Professional Services Specialist
HostMySite.com[^]
|
|
|
|
|
Hi,
I have a problem with binding data to dropdownlist from database in alphabetical order.
My database contains some fields like All,Air,Airline,Books,Cars etc.
There are 2 dropdown lists one dropdown contains A to Z list like A,B,C,D..Z.
2nd list contains above items like All,Air,Books.Now I want that when I select A from A-Z list it will display A items in alphabetical order and the Top item should be "All" after that remaining items.But if I display items in alphabetical order All is displaying like Air,Airline,All.Can anybody help me to resolve the problem.
Thanks in advance
Pavani
|
|
|
|
|
So you can't sort alphabetically, you have to provide your data sorted in the order you want.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
U have to use "Order by" clasue. Each and every change event of your drop down list, you have to change your query to bind data.....
Balasubramanian K.
|
|
|
|
|
Thanks for your response.
I already used order by clause to display in alphabetical order.Then it looks like Air,Airline,All.When we select alphabets A-Z i want to display first All and after that remaining items.Eg if i select A it will display All,Air,Airline if i select B it will display All,Books,Bank etc.All should be at top position.
|
|
|
|
|
I think that it is not possible if 'All' is in your database. I think that even you cant use "union all" also. Bind data by excluding 'All' and add it. Before adding add 'All' in to your drop down list directly as first index. I think it is possible. Try it.
Balasubramanian K.
|
|
|
|
|
Thanks for your suggestion.I tried with that I have so many dropdowns like that and I already saved All in database. Now i need to change for all pages.I will follow your suggestion first i will remove binded "All" from dropdown and i will insert at top position.Thank you.
|
|
|
|
|
HI , in first dropdownlist1 you Bind All Allphabates . in selection of First Dropdownlist you have to Bind Second Dropdownlist with query ;
it may be like this . select * from tablename where fieldname like 'dropdownlist1.selectedtext.text%'
Try This may be its help .
|
|
|
|