ASP.NET

Encrypt data from database

12-Feb-09 20:07

check this codes

http://www.codeproject.com/KB/aspnet/generate_thumbnail.aspx[^]

http://www.csharp-station.com/Articles/Thumbnails.aspx[^]

Vijay V.

Yash Softech

Guvera12-Feb-09 19:23

Guvera

12-Feb-09 19:23

Hi friends,

I am using Asp.Net 2.0 application. I have a user information form like username, password,name,lastname etc., I stored this information in a database. In the user information form one view button available. Suppose user click the view button, i show the information of user from database. What my query is that i need to show some fields like encrypted method from database. ie password and mobile no like **** or some encrypted no.Is it possible in .Net that encrypted data from database to our front end.

Hope Your's reply.

Every Successful Person Have A Painful Story

Re: Encrypt data from database

ABitSmart12-Feb-09 20:47

ABitSmart

12-Feb-09 20:47

With the information you have provided,
do you mean your data is stored in database in an encrypted form and you need to decrypt it before showing it to user ?
(well, if you have stoted it in an encrypted manner you should know how to decrypt it too ?? if you are not aware of how it was encrypted ask the person who has done it)
Or
do you want to show the data in an encrypted way(****) to the user ?
(i doubt this would be usefull ?? )

Re: Encrypt data from database

Guvera12-Feb-09 21:20

Guvera

12-Feb-09 21:20

I want to show the data in an encrypted way(****) to the user

Your second option is only i want. I dont want to store data in database in an encrypted form.

Hope yours reply.

Every Successful Person Have A Painful Story

Re: Encrypt data from database

ABitSmart12-Feb-09 21:29

ABitSmart

12-Feb-09 21:29

As I already mentioned, what is the point in showing the user ******* ?

An input box with type password could be used [^]

Tree view control

anandhakrishnan12-Feb-09 19:04

anandhakrishnan

12-Feb-09 19:04

Hi,

I am using a Treeview control with xml file as source file. I have given the html source code below.

<asp:TreeView ID="TreeLeftNavigation" runat="server" DataSourceID="XmlDataSource1" ImageSet="Simple" OnTreeNodePopulate="TreeLeftNavigation_TreeNodePopulate" >
<DataBindings>
<asp:TreeNodeBinding DataMember="Countries" Text="Countries" Value="Countries" />
<asp:TreeNodeBinding DataMember="continent" TextField="cont" />
<asp:TreeNodeBinding DataMember="country" TextField="coun" />
<asp:TreeNodeBinding DataMember="language" TextField="lang" NavigateUrlField="Url"/>
<asp:TreeNodeBinding DataMember="captial" TextField="cap" />
<asp:TreeNodeBinding DataMember="cities" TextField="city" />
</DataBindings>
<ParentNodeStyle Font-Bold="False" />
<HoverNodeStyle Font-Underline="True" ForeColor="#5555DD" />
<SelectedNodeStyle Font-Underline="True" ForeColor="#5555DD" HorizontalPadding="0px"
VerticalPadding="0px" />
<NodeStyle Font-Names="Tahoma" Font-Size="10pt" ForeColor="Black" HorizontalPadding="0px"
NodeSpacing="0px" VerticalPadding="0px" />
</asp:TreeView>
<asp:XmlDataSource ID="XmlDataSource1" runat="server" DataFile="~/XMLFile.xml"></asp:XmlDataSource>

This is my xml file content.
<?xml version="1.0" encoding="utf-8" ?>
<Countries>
<continent cont="NorthAmerica">
<country coun="United States of America">
<language lang="English" Url="Header.aspx"></language>
<capital cap="Washington D.C"></capital>
<cities city="Chicago"></cities>
</country>
</continent>
<continent cont="Europe">
<country coun="United Kingdom">
<language lang=" English" Url="Header.aspx"></language>
<capital cap="London"></capital>
<cities city="Bristol"></cities>
</country>
</continent>
</Countries>

Here i have given the url link in xml file. I am getting the url value thru NaviageUrlField property of TreeView control. I want to get the selected leaf node url value when i am clicking on some leaf node. Pls help me.

Tnx in advance.

Re: Tree view control

VijayVishwakarma12-Feb-09 19:22

Ftp Directory and Webserver director in Same Folder

12-Feb-09 19:22

try this for your solutions I hope it works for u.

protected void Node_Populate(object sender, System.Web.UI.WebControls.TreeNodeEventArgs e)
{
if (e.Node.ChildNodes.Count == 0)
{
switch (e.Node.Depth)
{
case 0:

function(e.Node); //here u can get the node value

break;
}

}

}

Vijay V.

Yash Softech

drag and drop

248912812-Feb-09 18:57

2489128

12-Feb-09 18:57

hi. i'm developing an asp.net application. here i want to drag and drop a div on html table's cell. now i want to get id of that cell on which div was dropped. please help me.

Re: drag and drop

Calin Tatar13-Feb-09 1:20

Calin Tatar

13-Feb-09 1:20

it is possible to implement dnd using JS.
For a sample, please check this[^]

Calin

Radhakrishnan G.12-Feb-09 18:37

Radhakrishnan G.

12-Feb-09 18:37

I have an FTP server configured to a directory that is inside the webserver root
Some times acessing files is not allowed
Any problem in doing the same

Configuration Error

MS Lee12-Feb-09 18:30

12-Feb-09 18:30

hi , when i run my asp.net page from IIS, it shows the following configuration error

how could to resolve..?

Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS.

Source Error:

Line 43: ASP.NET to identify an incoming user.
Line 44: -->
Line 45:authentication mode="Windows"
Line 46:

Vimalsoft(Pty) Ltd12-Feb-09 19:50

12-Feb-09 19:50

Explain the Steps you took when deploying your application

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

MS Lee12-Feb-09 20:01

12-Feb-09 20:01

previously i went to IIS tree, right-click the Default Web Site item and choose New -> Virtual Directory
gave alias name,then physical directory path,and gave virtual directory access path,and finished.

then i delete the virtual directory
and configure again with the same process, i dont know how the things went wrong previously,

now my index page is working, here am getting user name and login,
when i give signin button am getting error as

Server Error in '/MySweethomes' Application.
Cannot open database "test" requested by the login. The login failed.
Login failed for user 'SOFTWARE\ASPNET'.--------------> here my database name is 'SOFTWARE\test'

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot open database "test" requested by the login. The login failed.
Login failed for user 'SOFTWARE\ASPNET'.

Source Error:

Line 23: {
Line 24: SqlConnection conn = new SqlConnection(ConnStr);
Line 25: conn.Open();
Line 26: string MyQuery = "SELECT USERNAME,PASSWORD FROM LoginDB " + "WHERE USERNAME = '" + UName + "' AND PASSWORD = '" + Pass + "'";

Line 27: SqlDataAdapter Sda = new SqlDataAdapter(MyQuery, conn);

Source File: F:\SweetHomes\SweetHomes\Login.cs Line: 25

self confidence+hard work=SUCCESS

Vimalsoft(Pty) Ltd12-Feb-09 20:15

12-Feb-09 20:15

This tells me that your Connection string in your web.config is poiting to an incorrect database or path.

Post your Connection String in your Web.Config and let us see

MS Lee12-Feb-09 20:21

12-Feb-09 20:21

do you want all lines from that,,?
i coded only as
appsettings
add key="MyConnection"
value="Data Source=SOFTWARE;Initial Catalog=test;Integrated Security=True;" />
add/appsettings
authentication mode="Windows"

self confidence+hard work=SUCCESS

Vimalsoft(Pty) Ltd12-Feb-09 20:32

12-Feb-09 20:32

Where is the Username and Password ?

That is why it gives errors, try to write it like this

XML

<add key="MyConnection" value="User id = sa;Password=mypass;Server=SOFTWARE;Database= test" />

If you are working with SQL Server you must always pass the username and password

MS Lee12-Feb-09 20:39

12-Feb-09 20:39

there is no user name and password..
and i execute
exec
sp_grantdbaccess N'SOFTWARE\ASPNET', N'ASPNET'
exec
sp_addrolemember N'db_owner', N'ASPNET'
this commands and now its working,

self confidence+hard work=SUCCESS

Vimalsoft(Pty) Ltd12-Feb-09 20:42

12-Feb-09 20:42

You execute this in SQL ?

If yes, then before you execute this, you must first login in order to run Commands, so that user name and password that you use to log in there , is what is needed.

MS Lee12-Feb-09 20:34

12-Feb-09 20:34

i solve this problem
i execute the following query and now its working
exec
sp_grantdbaccess N'SOFTWARE\ASPNET', N'ASPNET'
exec
sp_addrolemember N'db_owner', N'ASPNET'

and .... !!

after successfully login am showing a page and in that am updating a content of text in to text file,
now when i try to update the text content am getting as

Could not find a part of the path 'C:\windows\system32\SweetHomes\Documents\SweetHomes.txt'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IO.DirectoryNotFoundException: Could not find a part of the path 'C:\windows\system32\SweetHomes\Documents\SweetHomes.txt'.

Source Error:

Line 43: string fname = "SweetHomes\\Documents\\SweetHomes.txt";
Line 44: string readcontent;
Line 45: StreamReader Srdr = new StreamReader(fname);
Line 46: readcontent = Srdr.ReadToEnd();
Line 47: Srdr.Close();

Source File: F:\SweetHomes\SweetHomes\AdminInfo.aspx.cs Line: 45

self confidence+hard work=SUCCESS

MS Lee12-Feb-09 21:10

12-Feb-09 21:10

actually
i create a folder in my application and create a text file in that,
through the coding am showing content and updating the contents to the file.
now when i run this page from IIS and try to show the contents
it shows the cannot find the path
it takes the path from C:\windows\system32\SweetHomes\Documents\SweetHomes.txt
but mine in F:\SweetHomes\Documents\SweetHomes.txt

i could not find solution to change the path !!

self confidence+hard work=SUCCESS

MS Lee12-Feb-09 23:51

asp.net html emails problem.

12-Feb-09 23:51

when specifying the path
i give server.mappath("filename") now my problem solved...
Smile | :)

self confidence+hard work=SUCCESS

VijayVishwakarma12-Feb-09 17:51

Re: asp.net html emails problem.

12-Feb-09 17:51

Hi,
I m trying to send html emails to subscribed users. The emails images are on my server, path is set,email format is set to html emails, I can check html preview by debugging the emails seems to be perfect but in Inbox of gmail,hotmail or any other mailing service the images are not being displayed even after selecting show all images.

Dont know where I m going wrong.

Can any one please help me out?

Its badly needed.

Thanks in advance.

Vijay V.

Yash Softech

VijayVishwakarma12-Feb-09 19:22