|
You should be able to use a stored procedure as the datasource for a Crystal report.
1) Verify that when you execute the sproc outside of crystal it is returning the correct number of rows.
2) Make sure you are not performing some join in crystal which is giving you too many unexpected row.
My vision would be that the sproc would return all of the data necessary to generate the report and you would not have to join to any other table for reference data (like user first name, last name, etc), this would make designing the report very straight forward.
Hope this helps. 
|
|
|
|
|
I've got a tet box and a button on my page and am using the following code ro encrypt the URL. The only unusual part is is this line in button click event
Dim strValues As String = TextBox1.Text & TextBox1.Text & TextBox1.Text
This I was forced to do beacuse for some reason it didn't like the four digit id (i.e Invalid length for a Base-64 char array) entered into the textbox so I just repeated it three times an on the other side I just look at the first third of the decrypted querysring.
Public Function Encrypt(ByVal stringToEncrypt As String, _
ByVal SEncryptionKey As String) As String
Dim key() As Byte = {}
Dim IV() As Byte = {&H12, &H34, &H56, &H78, &H90, &HAB, &HCD, &HEF}
Try
key = System.Text.Encoding.UTF8.GetBytes(Left(SEncryptionKey, 8))
Dim des As New DESCryptoServiceProvider()
Dim inputByteArray() As Byte = Encoding.UTF8.GetBytes( _
stringToEncrypt)
Dim ms As New MemoryStream()
Dim cs As New CryptoStream(ms, des.CreateEncryptor(key, IV), _
CryptoStreamMode.Write)
cs.Write(inputByteArray, 0, inputByteArray.Length)
cs.FlushFinalBlock()
Return Convert.ToBase64String(ms.ToArray())
Catch e As Exception
Return e.Message
End Try
End Function
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim strValues As String = TextBox1.Text & TextBox1.Text & TextBox1.Text
Dim strURL As String = "PasswordReset.aspx?Key=" & Encrypt(strValues, "!#$a54?3")
Response.Redirect(strURL)
End Sub
My decyption code is:
Public Function Decrypt(ByVal stringToDecrypt As String, _
ByVal sEncryptionKey As String) As String
Dim key() As Byte = {}
Dim IV() As Byte = {&H12, &H34, &H56, &H78, &H90, &HAB, &HCD, &HEF}
Dim inputByteArray(stringToDecrypt.Length) As Byte
Try
key = System.Text.Encoding.UTF8.GetBytes(Left(sEncryptionKey, 8))
Dim des As New DESCryptoServiceProvider()
inputByteArray = Convert.FromBase64String(stringToDecrypt)
Dim ms As New MemoryStream()
Dim cs As New CryptoStream(ms, des.CreateDecryptor(key, IV), _
CryptoStreamMode.Write)
cs.Write(inputByteArray, 0, inputByteArray.Length)
cs.FlushFinalBlock()
Dim encoding As System.Text.Encoding = System.Text.Encoding.UTF8
Return encoding.GetString(ms.ToArray())
Catch e As Exception
Return e.Message
End Try
End Function
Everthing works great EXCEPT when I try to decrypt the number 305930593059 (this is 3059 repeated three times). When executing the line: inputByteArray = Convert.FromBase64String(stringToDecrypt) I error out with "Invalid length for a Base-64 char array". Any other number that I try, even 5 digit ones, work fine.
Is this wierd or what?
Thanks in advance for any help.
|
|
|
|
|
Please post your code with proper formatting inside pre tag :
like,
CryptoStreamMode.Write)
cs.Write(inputByteArray, 0, inputByteArray.Length)
cs.FlushFinalBlock()
Dim encoding As System.Text.Encoding = System.Text.Encoding.UTF8
It will then readable easily.
Thanks !
|
|
|
|
|
I have been browsing and searching for articles on above topic. I didn't find equivelant and decided to ask if someone knows if there is article on that topic.
I created a DLL library that has few ASP.NET components inside to be placed on ASP.NET site. The whole point of the library is that it is movable (from any server, any folder etc.) and it has no outside resources/additions it needs. This is also the reason why IHttpHandler wasn't used. So, I needed to create an image control inside the librarys component that streams different images from its resouces. How I overcame this all was that my own image controls render method wrote img-tag to the output. Img-tags url was pointing to the control itself with a parameter. The parameter was the name of the picture. When the browser tries to load the img-tag it finds itself again in the same control from the library. On this second time, the page load method writes to Response the binary output of an desired image.
I was just wondering should I write an article of that briefly described techinque. After all, I needed to come up with some own stuff not present in any article I came up / found earlier. And yes, it uses double call to show an image but on this case, this wasn't a problem.
So, this post is just to get an indication if one article already exists and do people think that the article out of above described would be needed by someone else than me. Thanks in advance for your replies.
|
|
|
|
|
Hi,
i have the following code:
<asp:GridView ID="GridViewDetailLocuriMunca"
runat="server"
AutoGenerateColumns="False"
DataKeyNames="id"
DataSourceID="LocuriMuncaDataSource"
AllowPaging="True"
AllowSorting="True"
OnRowUpdating="GridViewDetail_RowUpdating"
Caption="Locuri de munca">
<Columns>
<asp:CommandField
ShowEditButton="True"
ButtonType="Image"
<asp:TemplateField HeaderText="grupa" SortExpression="grupa_cod" Visible="True">
<edititemtemplate>
<asp:DropDownList ID="DropDownListGrupaEdit"
runat="server"
DataSourceID="CodGrupaLocuriMuncaDataSource"
DataTextField="cod"
DataValueField="id"
AutoPostBack="true"
SelectedValue='<%# Bind("grupa_id") %>'>
</asp:DropDownList>
</edititemtemplate>
<ItemTemplate>
<asp:Label ID="grupa_cod"
runat="server"
Text='<%# Bind("grupa_cod") %>'>
</asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="comp." SortExpression="comp_cod" Visible="True">
<ItemTemplate>
<asp:Label ID="comp_cod"
runat="server"
Text='<%# Bind("comp_cod") %>'>
</asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:DropDownList ID="DropDownListCompEdit"
DataTextField="Cod"
DataValueField="ID"
DataSourceID="SqlDataSourceComp"
AutoPostBack="true"
EnableViewState="true"
OnDataBound="myDataBoundComp"
runat="server"
Enabled="True" />
<asp:SqlDataSource runat="server" ID="sqlDataSourceComp"
ConnectionString="<%$ ConnectionStrings:DecontariConnectionString %>"
SelectCommand="SELECT comp.cod, comp.id FROM [nGrupeLocuriMunca] lm, [nCompartimente] comp WHERE (comp.id = lm.comp_id AND lm.id = @grupa_id)"
>
<SelectParameters>
<asp:ControlParameter
Name="grupa_id"
ControlID="DropDownListGrupaEdit"
PropertyName="SelectedValue" />
</SelectParameters>
</asp:SqlDataSource>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="centru cost" SortExpression="cc_cod">
<ItemTemplate>
<asp:Label ID="cc_cod"
runat="server"
Text='<%# Bind("cc_cod") %>'>
</asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:DropDownList ID="ddlCentreCost"
DataTextField="Cod"
DataValueField="ID"
DataSourceID="SqlDataSourceCC"
AutoPostBack="true"
EnableViewState="true"
OnDataBound="myDataBindCost"
runat="server"
Enabled="True" />
<asp:SqlDataSource runat="server" ID="sqlDataSourceCC"
ConnectionString="<%$ ConnectionStrings:DecontariConnectionString %>"
SelectCommand="SELECT cc.cod cod, cc.id id FROM [nCentreCost] cc, [nCompartimente] comp WHERE (cc.cp_id = comp.cp_id AND cc.activ = 1 AND comp.id = @comp_id)"
>
<SelectParameters>
<asp:ControlParameter
Name="comp_id"
ControlID="DropDownListCompEdit"
PropertyName="SelectedValue"
/>
</SelectParameters>
</asp:SqlDataSource>
</EditItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
and my problem is that when i change the value for the first list: DropDownListGrupaEdit, only the second
list is updated: DropDownListCompEdit ... The last one does not refresh at all, but only when i try to select a value that is not actual in the list ...
How can i solve this issue ?
|
|
|
|
|
Hi,
I am taking some formula expression from database, after i have to eveluate the expression into VALUE. the Expression as like as below,
1) BASIC + HRA + DA
2) 3000 + ABS(2000) + Round(Basic)
3) BASIC + iif((BASIC > 1000), 2000, 1000) + 3000
The Above are Formula expression already comming from database.
i copied these expression to a string varable, then i am trying to evaluate all the mathematical expression like ROUND, ABS are giving value but IIF is not returns value ...So how to resolve this Expression...
I am clearly mentioned my problem,.. if any clarification necessary plz dont hesitate to ask ..i will tell more clearly..
regards,
kannak
|
|
|
|
|
Marking your post as Very Urgent is very rude around here. It may be urgent to you but everyone here volunteers their time, it's not urgent to them
only two letters away from being an asset
|
|
|
|
|
Kannak,
You menitioned that ROUND,ABS etc you are able to do. So you know the meaning of string "ABS" is the mathematical expression ABS.
So you should be knowing the meaning of string "IIF".
Based on the meaning you have to implement. Supposr, I think the meaning is the maximum of the 3 values then I would have a function like this -
private int GetValueFromIIF(string iifCond)
{
string[] strValues = iifCond.Split(',');
int[] intValues = new int[3];
int maxValue = -1;
for(int i = 0; i < strValues.Length;i++)
{
intValues[i] = Convert.ToInt32(strValues[i]);
if (intValues[i] > maxValue)
maxValue = intValues[i];
}
return maxValue;
}
|
|
|
|
|
|
I'm using a stored procedure to populate a crystal report, But I get repeatative(duplicated) information on my report- something like 66 pages instead of atleast 2. I want to produce a transactions statement for a particular user, using the crystal report, with the stored procedure getting data from multiple tables, accepting as a parameter the name of a particular client(user). Am I using the crystal report for good purpose or may be the stored procedure isn't just a way of doing it?
ML Lingwati
|
|
|
|
|
This is really not a ASP.NET question. But I could answer for this.
Have you checked your Stored Procedure which the same parameters? If it returns correct records then there would be no problem. Seems like you must missed some JOINs in the Stored Procedure
|
|
|
|
|
can any one guide me that i want to render grid view in divs instead of tables. is this possible or not??
Government Dyal Singh College Lahore.
|
|
|
|
|
|
I've got only PageName.aspx and PageName.aspx.cs needed to be added to the web project. How can I create its missing PageName.aspx.designer.cs?
What is the tool "Runtime Version:2.0.50727.3074" that generates those files in web projects as I've peeked into other created from New... web pages?
Чесноков
|
|
|
|
|
Create the PageName.aspx.designer.cs in the same folder. Edit the PageName.aspx.designer.cs and PageName.aspx.cs so that they contain the Partial Class, comment out the control declarations in PageName.aspx.cs.
Change something minor in the page layout design (e.g. add a label which you remove later). Rebuild the project. The designer will be generated. Revert the change made earlier if necessary.
modified on Tuesday, August 11, 2009 9:28 AM
|
|
|
|
|
|
Yes, I'm using web application.
I found that right clicking PageName.aspx item in Solution Explorer and then 'convert to web application' it generates that designed.cs file.
Obviously it converts that .aspx to be used in web application 
Чесноков
|
|
|
|
|
Hi all,
Im using a login control in my application.In that the
Remember me check box is not working fine.when i close the app.
and open in a new tab the session maintains. But when i
close the browser and open in a new browser i cant able to open the application.Solve my problem please.
code behind:
void Login1_LoggingIn(object sender, LoginCancelEventArgs e)
{
string username = Login1.UserName.Trim();
if (!string.IsNullOrEmpty(username))
{
MembershipUser user = Membership.GetUser(username);
if (user != null)
{
if (Membership.ValidateUser(user.UserName, Login1.Password))
{
Login1.UserName = user.UserName;
CheckBox Remember = (CheckBox)Login1.FindControl("RememberMe");
if (Remember.Checked == true)
{
Response.Cookies["UserName"].Value = Login1.UserName;
Response.Cookies["UserName"].Expires = DateTime.Now.AddDays(7);
Response.Cookies["Password"].Value = Login1.Password;
Response.Cookies["Password"].Expires = DateTime.Now.AddDays(7);
}
else
{
Response.Cookies["UserName"].Expires = DateTime.Now.AddDays(-7);
Response.Cookies["Password"].Expires = DateTime.Now.AddDays(-7);
}
......
Web config:
<authentication mode="Forms">
<forms timeout="30" protection="All"
slidingExpiration="true" loginUrl="http://localhost/OliveTreeNetwork/login.aspx" cookieless="UseCookies"/>
</authentication>
|
|
|
|
|
For version 2.0 the ASP.NET team changed the timeout for persistent cookies to use the <forms timeout=""/> attribute. So the life of the persistent cookie then matches the lifetime of session based cookies. In your example, the cookie will last 30 minutes.
|
|
|
|
|
Hi Mike,
Even if i extend the timeout value i cant the expected results.What to do with this.
|
|
|
|
|
Hey Guys,
I am working on a project to play videos. I used Windows Media Player control to play videos now the requirement is to use Flash Player and I have never used Flash Player in any kind of project.
Could you please help me with sample code.
I am working on ASP.NET language C# [VisualStudio2008].
Thanks
|
|
|
|
|
|
when i try to access controls from parent page to child page it shows error like "windows.opener.document" is null. How to overcome this problem?
|
|
|
|
|
There is spelling mistake.
Use:
window.opener.document
This you can use only for those popups which has been opened by using "window.open()" function.
|
|
|
|
|
I am using javascript mp3 player, but it is not working in windows swrver 2003 when i use mozilla firefox, its working fine in XP. Is there any plug in for quicktime for windows server 2003
Thankyou
Ypki
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
