|
Hope the Article by LeoSelmani Crystal Report[^] here in CP will Help you.
Regards,
Satips.
|
|
|
|
|
Use the crystal report viewer from the toolbox of the visual studio.
|
|
|
|
|
Hi, I was searching the web for ways to check if a user name is already in existence and I found the following code.
Function DBAuthenticate(ByVal strUsername As String, ByVal strPassword As String) As Integer
Dim bResult As Boolean = False
Dim objConn As New OleDbConnection
Dim strSQL As String
Dim strGoodPassword As String
Dim objCommand As New OleDbCommand
objCommand.Connection = objConn
strSQL = String.Format("SELECT p_w FROM myDB WHERE (email='{0}');", strUsername)
objCommand.CommandText = strSQL
objCommand.CommandType = CommandType.Text
objConn.Open()
strGoodPassword = CType(objCommand.ExecuteScalar, String)
objConn.Close()
If Not strGoodPassword Is Nothing Then
If strGoodPassword = strPassword Then
bResult = True
Else
lblMessage.Text = "Invalid Login!"
lblMessage.Text &= " If you are not a member please click the above link to register."
End If
Else
lblMessage.Text = "Invalid Login!"
lblMessage.Text &= " If you are not a member please click the above link to register."
End If
Return bResult
End Function
I don't understand three lines of the code above. what does the following mean?
Dim objConn As New OleDbConnection(ConfigurationSettings.AppSettings("myDB"))
Also what do the lines below do?
strSQL = String.Format("SELECT p_w FROM myDB WHERE (email='{0}');", strUsername)
strGoodPassword = CType(objCommand.ExecuteScalar, String)
Thank you in advance for your help.
|
|
|
|
|
ASPnoob wrote: Dim objConn As New OleDbConnection(ConfigurationSettings.AppSettings("myDB"))
This line of code instantiates an OleDbConnection. This is a connection to a database such as MS Access. It can be used to query for data, etc.
ASPnoob wrote: strSQL = String.Format("SELECT p_w FROM myDB WHERE (email='{0}');", strUsername)
This ling of code basically creates a string, and assigns the value to strSQL. For example, if strUserName contains the value "you@urdomain.com", the string that will be contained in strSQL will be "SELECT p_w FROM myDB WHERE (email='you@urdomain.com');"
ASPnoob wrote: strGoodPassword = CType(objCommand.ExecuteScalar, String)
OK, this one is a little more complicated. objCommand is an OleDbCommand, which can be used to query, update, delete, insert data to or from a database (using the OleDbConnection assigned to it). In this case, they are selecting a single field (p_w) from the table myDB for a particular email address.
When you use the .ExecuteScalar() method, you basically are indicating that you are only expecting a single value back from whatever query you are executing. So basically the CType will return a String representation of the p_w you are looking up in the table myDB. If none is found, strGoodPassword will be equal to nothing, otherwise, it will be equal to the p_w value stored in the table myDB for the corresponding email address.
I know I probably could've worded that a little better, but hopefully you get the general idea of what is going on now.
HTH.
|
|
|
|
|
ASPnoob wrote: I don't understand three lines of the code above. what does the following mean?
Dim objConn As New OleDbConnection(ConfigurationSettings.AppSettings("myDB"))
There is a Configuration file(web.config in case of web application and App.config in case of Windows application) where we can set the connection string as well as other configuration settings of our .NET solution.This is an XML file.Under the appSettings node the connection string is written with the string variable name myDB .whereever in the project you need to reference the connection string you will get it by
ConfigurationSettings.AppSettings("myDB")
Tirtha
Do not go where the path may lead, go instead where there is no path and leave a trail.
Author: Ralph Waldo Emerson (1803-82), American writer, philosopher, poet, essayist
|
|
|
|
|
I have a classic asp page (webfor1.asp). I did this
and in proceesForm.aspx page I have to get the data from input fields
"fvFirstName" and "fvLastName" and have to show that data in some
lables in processForm.aspx.
Should I use Request.form("fvFirstName"). but where I have to use
this form objects in ProcessForm.aspx. and How can I reffer
ProcessForm.aspx to Webform1.asp
seema
|
|
|
|
|
seemamltn wrote: Should I use Request.form("fvFirstName")
Yes.
seemamltn wrote: ut where I have to use
this form objects in ProcessForm.aspx
Anywhere you like. The Request.Form collection is available during the entire process of creating the page.
Page_Load is generally used for this.
seemamltn wrote: How can I reffer
ProcessForm.aspx to Webform1.asp
What do you mean? In what way would you refer to it, and why?
---
single minded; short sighted; long gone;
|
|
|
|
|
I have a listbox with multi-select options.Upon selection some rows are displayed and then i have a form passed to a child form control and upon return i loose the values. I finally managed to get the values in an array,but now i do not know how to set the values of this listbox.
When i say Listbox.selectedindex it just highlights the last value
Any help?
thanks
|
|
|
|
|
You have to loop into to the Array and do like the below,
ListBox1.Item(i).Selected = True
Here i would be the Index of the Item with is previously selected.
|
|
|
|
|
I have a classic ASp Page at server. How Can I transfer the data from classic asp page from server to a Asp.net (aspx) page.copuld you please provide me coding
seema
|
|
|
|
|
Here are two common ways to transfer data in an ASP/ASP.NET scenario. The first is a system in which servers transfer data based on a key provided by clients. This unique key identifier allows the two servers to contact each other directly and exchange the necessary information. You might see this in a passport-style authentication system. This article, however, uses a second method of transferring data. Instead of passing a unique token through the client, the data itself will be encrypted and transferred via the client to its destination server.
Inside the DataManager.dll file, the Encryption class contains all the methods needed to encrypt data that will be transferred via the client. Behind the scenes the Encryption class uses a hash table to store key-value pairs added by calling the EncryptValue methods.
public void EncryptValue(String strKey,
String strValue)
{
data.Add(strKey, strValue);
TextWriter tw = new StringWriter();
MemoryStream ms = new MemoryStream();
serializer.Serialize(ms, data);
encryptedData = Encrypt(
ASCIIEncoding.ASCII.GetString(ms.ToArray()),
"KEY");
}
Hope this will Help you.
Regards,
Satips.
|
|
|
|
|
Hi.
I have a SSIS package named TESTPACKAGE on the 2005 SQL Server.
How I can exeucte it from ASP.NET?
I found some articels that refer to Microsoft.SQLServer assembly but I use older .NET Framework version (1.1) and this assembly is not availabe for me in Visual Studio (2003).
I read something about DTEXEC command. Can I use it in the Stored Procedure to run SSIS. I used this code in the Stored Procedure to run DTS package on the previsous/older SQL Server version.
CREATE PROCEDURE dbo.exportData AS<br />
Exec master..xp_cmdshell <br />
'DTSRUN /SMYSERVER /NTESTDTS /Umyaccess /Pmypassword'<br />
GO
Thank you,
|
|
|
|
|
Hope this will Help you.
DECLARE @cmd VARCHAR(255)
DECLARE @Wait INT
DECLARE @result INT, @OLEResult INT
DECLARE @ShellID INT
SET @Wait = 0
SET @cmd = 'DTEXEC /sq "TestSSPSPackageName" /ser <server name=""> /Set \Package.Variables[User::varTargetName].Properties[Value];"c:\dtsxTest\Test2.txt"'
-- create instance of OLE object
EXECUTE @OLEResult = sp_OACreate 'WScript.Shell', @ShellID OUT
IF @OLEResult <> 0 SELECT @result = @OLEResult
IF @OLEResult <> 0 RAISERROR ('CreateObject %0X', 14, 1, @OLEResult)
-- run package
EXECUTE @OLEResult = sp_OAMethod @ShellID, 'Run', NULL, @cmd, 0, @Wait
IF @OLEResult <> 0 SELECT @result = @OLEResult
IF @OLEResult <> 0 RAISERROR ('Run %0X', 14, 1, @OLEResult)
If @OLEResult <> 0 EXEC sp_OAGetErrorInfo @ShellID, @OLEResult
-- drop object
EXECUTE @OLEResult = sp_OADestroy @ShellID
-- I think this will run an an asynchronous process.
Regards,
Satips.
|
|
|
|
|
Thank you. As I understand this is a Stored Procedure, right? The other question I have is: can I just run this command separetly from my code:
EXEC master..xp_cmdshell 'DTEXEC /sq "TEST_PACKAGE_NAME" /ser TEST_SERVER'
Package doesn't accept any parameters. I created it when I was importing test.txt file and selected the option to create package on the fly. By the way how can I modify it if needed?
Thanks a lot.
|
|
|
|
|
Apols, this is probably a VERY stupid question!
I'm a C# programmer for a "living" (lol) and not done any ASP before...however I've written a couple of small apps as a hobby - but people have commented that they want to use them but don't because they don't want to download/install the .Net framework to their PC.
Seems lots of people are "scared" of .Net! Doesn't help when the app .msi is 350kb and .Net another 25MB!!
So, I thought ASP might be the answer.
The apps are for the Nike+iPod sports kit...and one of my requirements would be to read files direct from the iPod (user chosen filepath), do the processing and then write the amended files back to the iPod.
Is that possible in ASP?
Any advice VERY gratefully received...I thought I'd better ask now before diving straight in to something I know little about! lol
Thanks everyone.
-- modified at 17:22 Monday 11th June, 2007
OK, now I AM confused...I've been reading around and come across ActiveX!
What's the difference between ActiveX and an ASP.Net "control"?
Help!!!
|
|
|
|
|
When I use Server.Transfer["ProcessForm.aspx"]; my btn_click event
it gives me following error message
only assignments, call, increment, decrement, and new object expressions can be used as a statement
cannot apply indexing with [] to an expression of type 'method group'
seema
|
|
|
|
|
Seema
Server.Transfer is a method, not an indexed property... you should use parentheses ( ) rather than square brackets [] around the parameters:
Server.Transfer("ProcessForm.aspx");
Hope this helps
Tom
|
|
|
|
|
Please learn the syntax first before doing program.
Regards,
Sylvester G
sylvester_g_m@yahoo.com
|
|
|
|
|
Hi,
How do I dynamically change the failure text of the asp:ChangePassword control. Currently it displays the following text which I don't like:
Password incorrect or New Password invalid. New Password length minimum: 8. Non-alphanumeric characters required: 0.
Please can someone advise?
Regards
ma se
|
|
|
|
|
|
Hi,
I am using the asp:LoginName control, and it displays the user name corretly, but how do I modify this, or do a check, that it displays "Guest" if no one is logged on? I also want to add a <a></a> to the logged on user name so that the user is taken to his/her acount.
<asp:LoginName
ID="MySignInName"
CssClass="divider"
runat="server" />
Please can someone advise me what to do please?
Regards
ma se
|
|
|
|
|
Hi,
I have my asp:LoginStatus control's LogoutPageUrl property to ="~/Account/SignOut.aspx". But when I click on the Sign Out link then it takes me to the Default.aspx page. Why is this?
<asp:LoginStatus
ID="MySignInStatus"
CssClass="divider"
LoginText="Sign In"
LogoutAction="Refresh"
LogoutPageUrl="~/Account/SignOut.aspx"
LogoutText="Sign Out"
runat="server" />
Please can someone advise?
Regards
ma se
|
|
|
|
|
Hi,
I am using a custom asp:Login control, and I am having difficulty in setting the colour of the failure text. This is what I have:
<asp:Login
ID="MySignIn"
DestinationPageUrl="~/Account/Default.aspx"
runat="server">
<LayoutTemplate>
<!-- Here I have my user name and password controls -->
</LayoutTemplate>
<FailureTextStyle ForeColor="Red" />
</asp:Login>
If there is an invalid sign in then the text is still black.
Please can someone advise?
Regards
ma se
|
|
|
|
|
Hey dude
You have posted lot of questions regarding login control n I hope u must have some more questions in ur mind. So its better to read about Login Control in detail from : http://msdn2.microsoft.com/en-us/library/ms178329.aspx[^].
Well if text color is always in Black then I think you have written some code for it in CSS that force label's color always to be BLACK.
|
|
|
|
|
Hi,
This is the first time I use ASP.net and I have some question:
1) I have some controls on a web form and I would like to change their location dynamically from the code based on user action. Is it possible? how?
2) Their is something that replace the MessageBox? I see that their is a snippet for MessageBox.show() but how can I use it?
Thank in advance for an answer.
|
|
|
|