asp.net mvc 3.0 -> showing description instead of ID in a toList() call - ASP.NET Discussion Boards

indian14322-Aug-12 15:20

22-Aug-12 15:20

Hi All,

I have an asp.Net application which is using Entity Framework to connect to the Database and for DML operations. So I am using User Name and Password in my web config, now my question is, is there any way to hide these credentials or encrypt it. Which approach is best for security of Database credentials in Web config files. My ASP.Net UI is interacting with WCF service that is intern interacting with Entity Framework, in which projects I should keep these connection strings and what is the best approach for security.

Thanks in advance.

Thanks & Regards,

Abdul Aleem Mohammad
St Louis MO - USA

Re: Encrypting Database Credentials

Paul Conrad22-Aug-12 16:08

Paul Conrad

22-Aug-12 16:08

You may want to read up on Basic Security Practices for Web Applications[^]...

Specifically Access Databases Securely, there's a little bit on using integrated security. I hope this helps some.

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

Re: Encrypting Database Credentials

Niladri_Biswas22-Aug-12 18:48

Niladri_Biswas

22-Aug-12 18:48

indian143 wrote:
My ASP.Net UI is interacting with WCF service that is intern interacting with Entity Framework, in which projects I should keep these connection strings

It needs to be kept in the WCF service layer

<connectionStrings>
    <add name="XYZEntities" connectionString="metadata=res://*/DataAccessStrategy.Components.PartnerRenewal.csdl|res://*/DataAccessStrategy.Components.PartnerRenewal.ssdl|res://*/DataAccessStrategy.Components.PartnerRenewal.msl;provider=System.Data.SqlClient;provider connection string="Data Source=ServerName;Initial Catalog=DBName;User ID=username;Password=password;MultipleActiveResultSets=True"" providerName="System.Data.EntityClient"/>
  </connectionStrings>

You can refer the article on Task Management System that uses the similar technologies that you are using in your project. That may help you.[^]

Niladri Biswas
(Code Project MVP 2012)

Asp.Net - Oracle Connection failed

lalithafranklyn22-Aug-12 9:46

lalithafranklyn

22-Aug-12 9:46

Hi,
I am using oracle and c#.net. In my application, i need to populate a dropdownlist from one oracle db of a particular server/port/schema and populate another dropdownlist from another oracle db from another server/port.

Both the connections were success while connecting using oracle sql developer tool but in my application, i could not load the second control. Invalid username/password. logon failed error comes for the same credentials.

I am new to oracle. Please help me where i have to correct. Thanks in advance.

Thanks,
Lalitha

Re: Asp.Net - Oracle Connection failed

Niladri_Biswas22-Aug-12 18:29

Niladri_Biswas

22-Aug-12 18:29

That means the supplied credentials are wrong (for the second case). Provide correct credentials and it should work. Check Checking Connection to Oracle Database for testing the connectivity.

In case , the credentials are correct, then may be the connection path is wrong
e.g. in

OracleConnection connection = new OracleConnection(@connectionPath);

check the value for @connectionPath e.g.

string connectionPath = "Data Source=orcl;User Id=scott;Password=tiger;Persist Security Info=False";

Hope this will help.
[^]

Niladri Biswas
(Code Project MVP 2012)

FTP virtual path .net 2.0

lalithafranklyn22-Aug-12 9:31

lalithafranklyn

22-Aug-12 9:31

Hi,

I have given ftp server (say server), username, password and virtual directory path (say xxx/yyy/zzz) and a file name(file.txt).
I need to connect to a FTP server and check that file is exists in that virtual path.
When i tried using FtpWebRequest request = (FtpWebRequest) WebRequest.Create("ftp://server/xxx/yyy/zzz/file.txt");, it say invalid directory since the directory which i mentioned is not physically present in the ftp server.

Please help me with the best approach to connect to virtual directory in ftp server. I am using dot net 2.0 & c#.

thanks in advance.
Lalitha

Re: FTP virtual path .net 2.0

Sandip.Nascar22-Aug-12 11:12

Sandip.Nascar

22-Aug-12 11:12

The code seems right.

// Get the object used to communicate with the server.
FtpWebRequest request = (FtpWebRequest)WebRequest.Create("ftp://www.testdomain.com/test.htm");

But what is wrong is the directory path. As you said, the path doesn't exists, then you should not use that.

Do one thing,
Type: ftp://server from windows explorer
enter your login details and check the right path.

Hope this helps.
cheers

asp.net mvc 3.0 -> showing description instead of ID in a toList() call

Marcel Vreuls (www.agentbase.nl)21-Aug-12 14:09

Marcel Vreuls (www.agentbase.nl)

21-Aug-12 14:09

Hi All,

I am fairly new to the MVC and am strugling with comboboxes/dropdown lists all day, but have the better part working. The following is my problem.

I have 2 models defined

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.Entity;

namespace AgentBase.ContentRepository.Models
{
    public class cContent
    {

        public int ID { get; set; }
        public string CO_TITLE { get; set; }
        public string CO_TAGS { get; set; }
        public string CO_SUMMARY { get; set; }
        public bool CO_INTEXT { get; set; }
        public Int32 CO_TYPE { get; set; } //
        public decimal CO_SIZE { get; set; }
        public string CO_NOTES { get; set; }
        public string CO_COPYRIGHT { get; set; }
    }

}

and

using System;
using System.Data.Entity;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace AgentBase.ContentRepository.Models
{
    public class cCategory
    {
        public int ID { get; set; }
        public string CA_DESCRIPTION { get; set; }
        public Int32 CA_PARENT { get; set; }
        public bool CA_ACTIVE { get; set; }
        
    }

}

Then i have 2 controllers defined

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Entity;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using AgentBase.ContentRepository.Models;

namespace AgentBase.ContentRepository.Controllers
{ 
    public class ContentRecordsController : Controller
    {
        private ContentRepositoryObjects db = new ContentRepositoryObjects();
        

        //
        // GET: /ContentRecords/
       

        public ViewResult Index()
        {
            //
            //------------------------------------------------------------------------
            var query = db.Categories.Select(c => new { c.ID, c.CA_DESCRIPTION });
            ViewBag.Categories = new SelectList(query.AsEnumerable(), "ID", "CA_DESCRIPTION");
           
            return View(db.ContentRecords.ToList());
            
        }

        //
        // GET: /ContentRecords/Details/5

        public ViewResult Details(int id)
        {
            cContent ccontent = db.ContentRecords.Find(id);
            //------------------------------------------------------------------------
            var query = db.Categories.Select(c => new { c.ID, c.CA_DESCRIPTION });
            ViewBag.Categories = new SelectList(query.AsEnumerable(), "ID", "CA_DESCRIPTION");
            return View(ccontent);
        }

        //
        // GET: /ContentRecords/Create

        public ActionResult Create()
        {
            //------------------------------------------------------------------------
            //var db = new NorthwindDataContext();           
            //------------------------------------------------------------------------
            var query = db.Categories.Select(c => new { c.ID, c.CA_DESCRIPTION });
            ViewBag.Categories = new SelectList(query.AsEnumerable(),"ID", "CA_DESCRIPTION");
            //------------------------------------------------------------------------
            return View();
        } 

        //
        // POST: /ContentRecords/Create

        [HttpPost]
        public ActionResult Create(cContent ccontent)
        {
            if (ModelState.IsValid)
            {
                db.ContentRecords.Add(ccontent);
                db.SaveChanges();
                return RedirectToAction("Index");  
            }

            return View(ccontent);
        }
        
        //
        // GET: /ContentRecords/Edit/5
 
        public ActionResult Edit(int id)
        {
            cContent ccontent = db.ContentRecords.Find(id);
            //Fill the Dropdown.
            //------------------------------------------------------------------------
            var query = db.Categories.Select(c => new { c.ID, c.CA_DESCRIPTION });
            ViewBag.Categories = new SelectList(query.AsEnumerable(), "ID", "CA_DESCRIPTION");
            //------------------------------------------------------------------------

            return View(ccontent);
        }

        //
        // POST: /ContentRecords/Edit/5

        [HttpPost]
        public ActionResult Edit(cContent ccontent)
        {
            if (ModelState.IsValid)
            {
                db.Entry(ccontent).State = EntityState.Modified;
                db.SaveChanges();
                return RedirectToAction("Index");
            }
            return View(ccontent);
        }

        //
        // GET: /ContentRecords/Delete/5
 
        public ActionResult Delete(int id)
        {
            cContent ccontent = db.ContentRecords.Find(id);
            return View(ccontent);
        }

        //
        // POST: /ContentRecords/Delete/5

        [HttpPost, ActionName("Delete")]
        public ActionResult DeleteConfirmed(int id)
        {            
            cContent ccontent = db.ContentRecords.Find(id);
            db.ContentRecords.Remove(ccontent);
            db.SaveChanges();
            return RedirectToAction("Index");
        }

        protected override void Dispose(bool disposing)
        {
            db.Dispose();
            base.Dispose(disposing);
        }
    }
}

and

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Entity;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using AgentBase.ContentRepository.Models;

namespace AgentBase.ContentRepository.Controllers
{ 
    public class CategoryController : Controller
    {
        private ContentRepositoryObjects db = new ContentRepositoryObjects();

        //
        // GET: /Category/

        public ViewResult Index()
        {
            return View(db.Categories.ToList());
        }

        //
        // GET: /Category/Details/5

        public ViewResult Details(int id)
        {
            cCategory ccategory = db.Categories.Find(id);
            return View(ccategory);
        }

        //
        // GET: /Category/Create

        public ActionResult Create()
        {
            return View();
        } 

        //
        // POST: /Category/Create

        [HttpPost]
        public ActionResult Create(cCategory ccategory)
        {
            if (ModelState.IsValid)
            {
                db.Categories.Add(ccategory);
                db.SaveChanges();
                return RedirectToAction("Index");  
            }

            return View(ccategory);
        }
        
        //
        // GET: /Category/Edit/5
 
        public ActionResult Edit(int id)
        {
            cCategory ccategory = db.Categories.Find(id);
            return View(ccategory);
        }

        //
        // POST: /Category/Edit/5

        [HttpPost]
        public ActionResult Edit(cCategory ccategory)
        {
            if (ModelState.IsValid)
            {
                db.Entry(ccategory).State = EntityState.Modified;
                db.SaveChanges();
                return RedirectToAction("Index");
            }
            return View(ccategory);
        }

        //
        // GET: /Category/Delete/5
 
        public ActionResult Delete(int id)
        {
            cCategory ccategory = db.Categories.Find(id);
            return View(ccategory);
        }

        //
        // POST: /Category/Delete/5

        [HttpPost, ActionName("Delete")]
        public ActionResult DeleteConfirmed(int id)
        {            
            cCategory ccategory = db.Categories.Find(id);
            db.Categories.Remove(ccategory);
            db.SaveChanges();
            return RedirectToAction("Index");
        }

        protected override void Dispose(bool disposing)
        {
            db.Dispose();
            base.Dispose(disposing);
        }
    }
}

then problem now is. That i have a list page where i call

public ViewResult Index()
       {
           //
           //------------------------------------------------------------------------
           var query = db.Categories.Select(c => new { c.ID, c.CA_DESCRIPTION });
           ViewBag.Categories = new SelectList(query.AsEnumerable(), "ID","CA_DESCRIPTION");

           return View(db.ContentRecords.ToList());

       }

The index page shows me then all records from the ContentRecords.ToList function but that is showing me the CO_TYPE field ID, instead of the corresponding CA_DESCRIPTION from the categories entity. Because CO_TYPE is related to the CA_ID.

So how can I make it possible that the toList function:
a) returns values from two linked entities/models.
or
b) how can i create a new model based on two other more other models by joining them.
or
c) any other method i did not think of Wink | ;-)

I hope i have made a clear point of my problem. I am stuck any help will be appreciated.

Kind regards,

Marcel Vreuls

AgentBase

<<A good idea can change your life>>

Updating or inserting entities using Entity Framework

indian14321-Aug-12 6:07

indian143

21-Aug-12 6:07

Hi All,

I have an Asp.Net application in which I am trying to insert/upate a database table in the backend. But I am getting following message.

Unable to update the EntitySet 'message' because it has a DefiningQuery and no <insertfunction> element exists in the <modificationfunctionmapping> element to support the current operation.

Can anybody help me please by giving any suggestions, links or code snippet. Mean time I will be googling about the exception.

Thanks in advance.

Thanks & Regards,

Abdul Aleem Mohammad
St Louis MO - USA

Re: Updating or inserting entities using Entity Framework

Niladri_Biswas22-Aug-12 18:50

Niladri_Biswas

22-Aug-12 18:50

Hope this[^] answers your problem

Niladri Biswas
(Code Project MVP 2012)

How to capture webcam videos using C# and ASP.NET

vinay_sinha20-Aug-12 23:30

vinay_sinha

20-Aug-12 23:30

I have to implement a new feature in my existing asp.net website, Actually in my website one can take online test, my further requirement is after completing the test i have to capture the video of candidate for 30 sec(approx) also, store it and play it again when required
AnyOne can help me PLEASE, Thanks in Advance Smile | :)

Page.ResolveUrl and reverse proxy

Sebastiaan Meijerink20-Aug-12 22:21

Sebastiaan Meijerink

20-Aug-12 22:21

Hi,

I've got an issue with Page.ResolveUrl and an ISA reverse proxy.

We've got an internal webserver that hosts multiple webapplications. The are therefore configured as applications.

Let's say we have:

http://internalserver/applicationX

By using an ISA2006 server this adres is being reverseproxy'd to:

https://subdomain.myorg.com

If i put this in my page
<script src="<%= Page.ResolveUrl("~/MicrosoftAjax.js") %>" ></script>

it wil stil resolve into
https://subdomain.myorg.com/applicationX/MicrosoftAjax.js

Is there a way to make .NET aware that it a reverse proxy is changing the path?

Or should the reverse-proxy solve this?

Kind regards,
Sebastiaan

execute a certain task every one hour in server

Farhad Eft20-Aug-12 13:01

Farhad Eft

20-Aug-12 13:01

Hi
I want to a certain task every one hour in server in my ASP .NET 4 project, I was wondering where should i put my codes to execute.

Thank you guys

Re: execute a certain task every one hour in server

fjdiewornncalwe20-Aug-12 16:08

fjdiewornncalwe

20-Aug-12 16:08

For starters, don't put repetitive server code in a web application because then you will need something to trigger the process anyway.
Why not investigate using a Windows Service or an application that is setup to be run by the Windows Task Scheduler.

I wasn't, now I am, then I won't be anymore.

Re: execute a certain task every one hour in server

Farhad Eft20-Aug-12 22:08

Farhad Eft

20-Aug-12 22:08

thank you so much for your answer
but i only have a shared hosting plan not a dedicated server and i definitely don't have access to those kinds of resources.

Re: execute a certain task every one hour in server

Rahul Rajat Singh20-Aug-12 17:55

Rahul Rajat Singh

20-Aug-12 17:55

The best way to do this is by writing a windows service and run it on the server. this windows service can be written in such a way that it will do some particular task every hour.

Every now and then say, "What the Elephant." "What the Elephant" gives you freedom. Freedom brings opportunity. Opportunity makes your future.

Re: execute a certain task every one hour in server

Farhad Eft20-Aug-12 22:08

Farhad Eft

20-Aug-12 22:08

thank you so much for your answer
but i only have a shared hosting plan not a dedicated server and i definitely don't have access to those kinds of resources.

Re: execute a certain task every one hour in server

Rahul Rajat Singh20-Aug-12 22:27

Rahul Rajat Singh

20-Aug-12 22:27

In that case, I will have to suggest a very very dirty workaround for tackling this problem.

1. Have a page that will do the required task. do the required task only when a specific query string is present. This way you will ensure that only you know this actual link that will perform this operation.

2. Now whenever you access this page with this specific query string this task will run. you can do it manually but you can still automate it. lets see how:

3. create a simple winform application with webbrowser control in it and navigate it to the required page with the specific querystring. all hard coded in the page_load. so when application opens up your task is done. close this app in webbrowser navigated event.

4. Now configure a windows service on your PC that will run this application on a specified time.

P.S. all this assuming that the task you need to perform is not time consuming otherwise you will get timeout problem.

Note: I am not recommending this approach. it is very very bad. but in desperate times such workarounds do work.

Every now and then say, "What the Elephant." "What the Elephant" gives you freedom. Freedom brings opportunity. Opportunity makes your future.

Re: execute a certain task every one hour in server

Karthik J, Coimbatore20-Aug-12 23:25

Karthik J, Coimbatore

20-Aug-12 23:25

Put ur code as console appln. Use server task-scheduler to trigger that .exe file every hour...

Re: execute a certain task every one hour in server

David Mujica21-Aug-12 2:03

David Mujica

21-Aug-12 2:03

Is this a task SQL server based?

maybe you could write a SQL job and have it scheduled. (if your hosting agreement allows it)

Just a thought.

Re: execute a certain task every one hour in server

Sandip.Nascar22-Aug-12 10:57

Sandip.Nascar

22-Aug-12 10:57

As you are using shared hosting, it is not possible to connect to windows service as this will not be allowed.

Create a web page which will do the task (as per your requirement - say adding some data or sending mail etc). Use query string to specify your parameters. Don't forget to encrypt the querystring value for security concern.

Now the interesting thing, create a windows service in your local machine which calls the above mentioned aspx page with querystring value.
Thus the page is fired in background and the code behind of the page will do the rest.

Thanks,
Sandip

Re: execute a certain task every one hour in server

Vijay Selvaraj27-Aug-12 0:13

Vijay Selvaraj

27-Aug-12 0:13

hi can you use timer control and set timer interval to hours to milisecod

configure IIS 7 to run with current user account

indian14320-Aug-12 10:38

indian143

20-Aug-12 10:38

Hi All,

I have an ASP.Net application and a WCF Service running on the same machine in IIS7. My machine name is "mmmmmmm250D" my user name is "uuuuuuu250". When I am running my applications(asp.net and wcf service), I am seeing that these applications are running under the user account "<domainname>\<machinename>$". This is taken automatically. This account is assigned when ApplicationPoolIdentity is "LocalSystem" and "NetworkService" in both the cases.
Is there any way that I can make these applications to run under my user account as I am admin for this machine where IIS is installed. The applications should run under account looks like "<domainname>\uuuuuuu250". Please help me I am struggling with this for a while.

Thanks in advance.

Thanks & Regards,

Abdul Aleem Mohammad
St Louis MO - USA

image control from Image

Jassim Rahma20-Aug-12 8:56

Jassim Rahma

20-Aug-12 8:56

Hi,

I am using an asp image control.

I want to display an image inside the image control from : Image image

is that possible or all images must be shown from physical files?

Re: image control from Image

Wes Aday20-Aug-12 9:21

Wes Aday

20-Aug-12 9:21

Do you mean something like this[^]?

Why is common sense not common?
Never argue with an idiot. They will drag you down to their level where they are an expert.
Sometimes it takes a lot of work to be lazy
Please stand in front of my pistol, smile and wait for the flash - JSOP 2012

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.