Hi Friends, I need to save an arabic data into sql server using dataset.The Arabic data will be enteered correctly but it will be saved using a dataset.In Dataset the Arabic data willnot display correctly.It displays like ??.How can i solve the issue.I need to save the data in arabic format.But the data will be added into the dataset like ??.Please help me to overcome this issue.

Thanks for your kind reply sir.Is there any way to show using a custom control to display image and text but will look like a dropdownlist.

Hi Friends, I need to display an image along with text in asp dropdownlist.I code it like that. <asp:DropDownList ID="DropDownList1" runat="server" Width="200px"> <asp:ListItem Text="<img src='Nature-2.jpg' alt=''/>Sreejith"></asp:ListItem>; </asp:DropDownList> But the image willnot display in the text it displays the text i given in the text itself.Please help me to display image along with dropdownlist text in the dropdownlist.

Thanks for your kind reply sir.Actually my question is not that.We can secure the access database file by setting username and password.When anyone tries to open the file they ask password.Like that is there any way to secure my webconfig file in an application.If anyone tries to open the config file ask password(not in browser) and if teh password is correct only he can open the config file.Please i need that secureation.Not encrypting teh connectionstrings and not.

Not from the browser sir.If anyone open the config file in the application ask username and password first and if both are correct only he can edit the config files in the application.

Hi Friends, I need a help.In my application i set the connectionstrings and all settings in webconfig file.But anyone can edit teh webconfig.Is there any option to protect the webconfig editing in .net application as in access database.If anyone tries to edit the webconfig ask username and password.If the entered username and password is correct only the user have to edit the whole webconfig. Send some queries to solve it.Because after publishing alos if anyone tries he can simply edit the webconfig.So i think in this way.

I need to call a web application in another web application.How can i call the project into another project.

Hi Friends, I need an sql query help.i need to implement distinct staetement in my select query.I need the Assets.AsstId should be distinct in query.i attach the query below .please help me i need its urgently.The bolded value should be distinct. SELECT aspnet_Users.UserName, AssetsSettingsTypes.AssetSettingsName, CONVERT(varchar(MAX), Assets.AssetShortDescrition) AS AssetShortDescrition,Assets.AssetId, '<img src="' + CONVERT(varchar(MAX), Images.ThumbUrl) + '" width="100" height="100"/>' AS Image, dbo.GetFriendlyDateTimeValue(UserAssets.CreationTime) AS TimeDiff, UserAssets.CreationTime as CreationTime, 'profileUser/Profileview.aspx?' + CONVERT(varchar(MAX), aspnet_Users.UserName) AS UrlProfile, 'profileUser/userPhotos.aspx?AssetId=' + CONVERT(varchar(MAX), UserAssets.AssetId) + '&UserName=' + aspnet_Users.UserName AS NavUrl, 'forntend/Commentview.aspx?' + CONVERT(varchar(MAX), UserAssets.AssetId) + '&' + CONVERT(varchar(MAX), UserAssets.UserId) AS UrlComment, '(' + CONVERT(varchar(MAX), (SELECT COUNT(*) FROM UserComments WHERE (UserAssetId = UserAssets.UserAssetId)))+ ')' AS CommentCount FROM AssetsSettingsData INNER JOIN Assets ON AssetsSettingsData.AssetId = Assets.AssetId INNER JOIN AssetsSettingsTypes ON AssetsSettingsData.AssetSettingsTypeId = AssetsSettingsTypes.AssetSettingsTypeId INNER JOIN Images ON Assets.AssetId = Images.AssetId INNER JOIN UserAssets ON Assets.AssetId = UserAssets.AssetId INNER JOIN aspnet_Users ON UserAssets.UserId = aspnet_Users.UserId WHERE (aspnet_Users.UserId = '9D4C2631-BB10-47C0-A4EE-5B1E92FE1AB9')

Hi Friends, I have a doubt in routing.I send an action code view to a page on button click of another page.How i get the action name in the second pageload.Please help me.

Hello Friends, I want to use asp.net routing in my project.Also i am using .net authentication for login.When i set a url in global.asax like Routes.Add("Home", new System.Web.Routing.Route("{Home}/{*Id}", new CustomRouteHandler("~/FrontEnd/Home.aspx"))); I call the Home url on a button click like Response.Redirect("Home/View"); But the url in addressbar looks like http://localhost:4254/CGCBM.Website/FrontEnd/Home.aspx?ReturnUrl=%2FCGCBM.Website%2FFrontEnd%2FHome%2FView as per routing the url looks like http://localhost:4254/CGCBM.Website/Home/View but it looks like entirely different.Please help me to sort it out.

Alert also will be applied in serverside.

I tried this also.but i the textbox wont be cleared.I used alert box to show no such user message.How i solve the textbox after displays the alert box.

Hi Friends, I put a logincontrol in a page to login using Membership.If no such user exists then i write code in login_error event to show a message box that no such user.I want to clear the 2 textboxes if no such users exists.How i clear the textboxes for entering username and password in logincontrol if login fails.

Thanks for your corordination sir...

Hi Kumar Sir, I got it sir.Actually we have to given Formsauthentication.LoginUrl then it cleanely works.

Sorry to say again it works wrongly.the user can access pages after paster the page in pageload of first page.

Not when i click the back button when i click any menu link also i can easily access the datas without logged in.

Hi, Actually i put a login control in masterpage enabled page and i put menu in masterpage.in the menu i put a menuitem logout and in the menu item click event i given formsauthentication.signout and the above given code.and i retdirect the page to home page where the login control, is situated.This is the flow of login and logout.After logout i checked username is null or not in another menuitem page.but i can easily access the page because the username still exists.What is the problem.

Hi Friend, I Given the code but it willnot cleared the cookie and i can took all datas,it willnot ask again to login.

How can i clear all cookies when we click on logout.