How To Get A Single Row (SQL)

Aug 10, 2010

is it possible to get a single row in ASP.NET?i always used dataList but this destroys my design with the item template, i need somethink that has no template only the Eval() statements

View 3 Replies


Similar Messages:

Forms Data Controls :: Using Multiple Tables Within A Single DataSet And Single SqlDataSource?

May 19, 2010

I have a stored procedure that returns 3 tables within the single recordset it returns. If I set a SqlDataSource to get data from this procedure, it works, but it only returns the first table. I want to have a GridView display the data from the 2nd or 3rd table using a SqlDataSource, but I can't figure out how to specify a particular table.

While there are some posts discussing this out there, I can't get a definitive answer about whether or not this is even possible (?). In a worst-case scenario, I can create another SP that only returns the 3rd table - but that creates a little maintenance headache that I would prefer to avoid.

View 4 Replies

DataSource Controls :: Using LINQ To Pull Out A Single Value From A Single Result Row Of A Join Query?

May 25, 2010

For context: First of all, I am new to LINQ, as I have been using SubSonic for quite some time now.

I have two tables, Users, and Affiliates. They both have a very typical schema. The FK that joins them is the UserId field, which is in the Affiliates table. I want to create a LINQ query that pulls the Username from the Users table using the AffiliateId value. The AffiliateId is a primary key of the Affiliates table.

I have tried to accomplish this using many variations of the following code:

[Code]....

In the above query, I expect to get a single row result set. However, I instead receive the entire table of results.

How can I make this work? I have yet to see an example or article out there to do what I am trying to do.

View 9 Replies

Open A Single Worksheet (single Tab) From A Huge Excel File On A Web Browser Using C#

Feb 27, 2010

I have huge excel files that I have to open from web browser. It takes several minutes to load huge file. Is it possible to open a single worksheet (single tab) at a time from excel file that contains many worksheets? I have to do this using C# / asp.net MVC

View 5 Replies

Web Forms :: Disable A Single Intem In Dropdownlist Or Stop The Ddl Change Event For A Single Item?

Sep 20, 2010

I am trying something apart of my boundries, is there any way to disable a single intem in dropdownlist or stop the ddl change event for a single item.

View 2 Replies

Multiple Single-result Sql Server Stored Procedures Or Single Multple-result Stored Procedure?

Aug 9, 2010

Background: I use stored procedures exclusively for an ASP.NET application. I am using a DataReader to load a dataset object.

View 4 Replies

IP Whitelist For A Single URL In IIS?

Aug 1, 2010

I have an ASP.NET application that's made up of several .aspx pages. I want one of those .aspx pages to be accessible by only a certain set of IPs. Is this possible?I know you can IP whitelist at the website level, but can you IP whitelist for a single URL in an application?

View 3 Replies

Web Forms :: How To Get The A Single Constant Value

Feb 26, 2010

I have a function that calculates the exchange rate between two currencies. The inputs are constants:

[Code]....

I have currency codes in my database listed as "EUR", "USD" etc. that I want to use in the function. Unfortunately the function requires a constant value like CurrencyExchangeRate.Currency.EUR instead of a string value called "EUR" How can I turn the value from the database into a usable value for the function?

I know it must be very simple but I cannot figure it out.

View 9 Replies

Register A Single Controller?

Aug 7, 2010

The code below works for adding all controllers:

container.Register(AllTypes.Of<Controller>().FromAssembly(typeof(MvcApplication).Assembly).Configure(c => c.LifeStyle.Transient.Named(c.Implementation.Name.ToLower())));

But I want to add them one at a time. Nothing I try works (example below). How do I code this?

container.Register(Component.For<CategoryController>().LifeStyle.PerWebRequest);

View 2 Replies

C# - Spring.net SQL Select A Single Value?

Nov 15, 2010

is there a way using Spring.net to run a select query and have it return a single value. If there is a way, how do I go about doing it?

View 2 Replies

Php - Single Quotes Instead Of Double?

Nov 30, 2010

Since both are acceptable by HTML as well as languages like ASP.NET and PHP when using attributes or strings, why is it that some people use single quotes and double quotes interchangeably? It is my understanding that it is syntactically correct to use double quotes where possible, single when you need to embed a double quote for inline logic. Is there something I am missing? For examples: HTML

<a href='[URL]
PHP
<? echo 'Hello World!'; ?>
ASP.NET
<form id='myForm' runat='server'></form>

View 7 Replies

Can Validate A Single Field Alone

Apr 6, 2010

i have a field DOB, i want to validate only this field when i give causes validation True for this field, What happens is it validates all the fields in the page are validate. Can we assign validation for particular fields.

View 6 Replies

ADO.NET :: Fetching A Single Row From Sql Datareader?

Aug 17, 2010

Lang-ASP.net using C# and Sql server 2005

i m trying to use the sql datareader to fetch a single row at a time i wanna know can we use it to fetch a single row at a time or not if yes i m unable to figure out what i m doing wrong here bcus its not returning any data

[Code]....

of course data is present in my table bcuz when i m using dataset i m able to the return the single row throuugh dataset

View 3 Replies

MVC :: Two ActionResult In A Single View?

Aug 19, 2010

Shall i able to create two actionresult in a single page?

I m using two Html.BeginForm() in a single page? These two forms has different data as like

BeginFrom1() - dropdownlist

<% using (Html.BeginForm("ViewByStatus", "NewsLetterAdmin", FormMethod.Post))
{ %>
<div>
Filter:
<%=Html.DropDownList("statusName",new SelectList(new[]{"#firstname#","#lastname#","#emailid#","#date#"}))%>
<input type="submit" value="?" />
</div>
<%} %>

BeginForm2() - textbox , freetextbox
<% using (Html.BeginForm("ddown", "NewsLetterAdmin", FormMethod.Post))
{%>
<fieldset>
<legend>Fields</legend>
<div>
<%= Html.LabelFor(model => model.TemplateName) %>
</div>........

When i select a dropdownlist and submit , dropdown selected value comes to textbox and freetextbox. Its working well

Again i m adding contents to freetextbox

Again i select a dropdownlist and submit , dropdown selected value comes to textbox and freetextbox. The newly selected value only comes to textbox and freetextbox, but my old contents are not exists in freetextbox.

I need old contents and dropdown selected value comes to freetextbox.

View 3 Replies

Looking For Single Webpage Templates?

Jun 12, 2010

I am looking for single webpage templates suitable for business profiles, no navigation needed. Does any such resource exisit. Frontpage use to have prebuilt pages - does the new VS 2010 have any resource for quick and simple webpage construction?

View 1 Replies

ADO.NET :: Retrieving A Single Value With A Procedure?

Feb 25, 2011

I have a stored procedure with two input parameters which calculates the distance between two points. When I call it from aspx.cs I get an error.

Here is the code:

CreateDataSet();
float raz;
String str = "";
float min = 3.4F;
String clo = "";

[Code]....

and the error I get is:

Exception Details: System.Data.SqlClient.SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

Source Error:

[Code]....

When I test the procedure in SQL Server Management Studio everything is OK and I get a value 539.551855770807 for the certain input parameters.

View 2 Replies

C# - Convert BitArray To Single Int?

Mar 12, 2011

How i can convert BitArray to single int?

View 1 Replies

Web Forms :: Run Two Websites On Single Url?

Dec 2, 2010

i hv say two website web1 and web2 both hv diff appdata and style sheet,webconfig.how can host this on single url with username and password. suppose for rajeev it redirect to web1 and for ravi redirect to web2.Is it possible todo this kind of thing. India mart did this on their websites. they have various links in thier website. suppose for website web1 they have the [URL] and so on.

View 11 Replies

C# - Match Many Cases In A Single Run?

Jan 5, 2011

So the case is this:

The user can provide a group of strings for a propert. ex:

DaysNeeded ="Sunday,Tuesday,Friday,Saturday";

In the actual UI, the days of the week are available as check boxes. I'm trying to provide a way so that the user can also set the days needed in the code behind through a property.

Now my query is, which strategy is the best way to execute certain pieces of code that are respective to the days that the user have provided. Meaning, the DaysNeeded property has sunday,Tuesday, Friday and Saturday. Each day has certain piece of code to be executed. If i have to have a forloop with a switch case for each day of the week, i feel it would cost more as i have to run the for loop, the number of days the user has given.

Is there a way that i can run a single code that matches all the set of days the user has given and run the respective code pieces?

View 3 Replies

C# - MVC Single Sign-on And Roles?

Aug 30, 2010

I have basic Single Sign-On working across 2 MVC sites (call them SiteA and SiteB) using something along the lines of the following method:http://forums.asp.net/p/1023838/2614630.aspxThey are on sub-domains of the same domain and share hashencryption keys etc in web.config. I've modified the cookie so it is accessible to all Sites on the same domain. All of this seems to be working ok.The sites are on separate servers without access to the same SQL database, so only SiteA actually holds the user login details. SiteB has a membership database, but with empty users.This works fine for my required scenario which is:1) User logs into SiteA2) The application loads data from SiteA (by AJAX) and SiteB (by AJAX using JSONP)I have the following LogOn Action on my AccountController for SiteA, which is where the "magic" happens:

[HttpPost]
public ActionResult LogOn(LogOnModel model, string returnUrl)
{

[code]...

View 2 Replies

.net - Converting Files In To Single Zip Using C#?

Mar 7, 2011

I am using C# code for aspx pages. I need to convert multiple files in to single zip file that can be readable by windows default zip software.

View 4 Replies

Compiling Multiple Projects Into A Single Dll?

May 5, 2010

Is there a way to copmile a solution into a single dll?

Said solution may have several custom projects. I want all of them, and all the third party dll's they reference compiled into a single dll.

View 5 Replies

Traditional Repositories Vs Single UnitOfWork

Aug 17, 2010

I would like to start a debate on traditional repositories versus one built on the UnitOfWork pattern. In a traditional repository, we wrap inserts, updates and deletes in a transaction, but selects don't really need them. In addition, nhibernate configuration is typically done once per application due to BuildSessionFactory being rather expensive. We often have several repositories of this type (one per aggregate chain). We also need to have projected, ahead of time, exactly what kinds of queries we'll need in order to build the interfaces and concretes correctly. In a single UnitOfWork repository we have the ability to manage both the current session and transaction, perform several operations, and then commit any changes all at once. In such a repository we may opt to put our configuration in the constructor since (typically speaking) no more than one Action is called per request anyway, initializing it in the application doesn't seem like much of an overall gain in speed. I must admit, I'm very temped to use the UnitOfWork pattern, as the following code looks really nice to me:

Csharp Code:
using (IUnitOfWork worker = new UnitOfWork()){// session and transaction are now both set
// save changes to three itemsworker.SaveOrUpdate(item1);worker.SaveOrUpdate(item2);worker.SaveOrUpdate(item3);
// grab a fourth var item4 = worker.Criteria<Foo>().Add(Expression.Eq("title", title)).UniqueResult<Foo>();
// delete the fourthworker.Delete(item4);
// all pending operations are commited or rolled back as a single unit (if one fails, all are rolled back), and then disposed, along with the session}

My proposed UnitOfWork class is rather simple. It implements IDisposable where I use a try-catch-finally in Dispose() to attempt a tx.Commit(), doing a tx.Rollback on failure, and a cleaning everything up in the finally clause. It also exposes common things like SaveOrUpdate, Delete, GetAll, Get, and even a Critera<T>() for custom on-the-spot queries. So what are your thoughts on this? I'd really like to hear about your experience with this pattern.

View 4 Replies

Single Repository Or Multiple Repositories?

May 1, 2010

In a typical business application, a session is started and persisted across several pages. It is commited only when the transaction is complete. A good example of this is a tax preparation application. Once the session is started, it is persisted through session, cookies, or both. Nothing is written to file, or database, until the entire profile is complete and the refund/return is calculated. In such an ennvironment, is makes a great deal of sense to work with the structure imposed by domain driven design, and using a single repository to simple commit the session. However, there are times when this doesn't translate correctly, even when domain driven design is used.

An example of this is my forum project. While the entities themselves are good targets for domain driven design, I am not sure about the repositories. The basic structure is that a Category has many Forums, a Forum has many Threads, and a Thread has many posts. There are other things in there, but that's enough to describe what I want to get across. If a user has navigated to /Thread/Edit/42, and they have rights to edit it, all I am concerned about is fetching that record and displaying it. On postback, all I want is to be able to save it..................

View 2 Replies

VS 2008 Single Sign On And Sharepoint

Jan 15, 2010

we have developed a ASP.NET application that required a username and password to login and use the application.Now on of our customers wants to use Single Sign on with their Microsoft Sharepoint Portal.

Basically they want their users to be able to login to the portal, and then be able to access our application, without having to provide their login details again.Does anyone have experience with implementing Single Sign on?

View 4 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved