SQL Server :: Produce DDl Box From DB Query

Feb 11, 2011

I am trying to produce a DDL box with the following listing from a DB query.

13245
12345-
12346
12348
12348-R

Some 5 digit codes do not include a suffix in the record, the following query will only show the 5 digit codes with a suffix.

SELECT itemCode + '-' + itemSuffix AS code, keyID, itemCode, itemSuffix
FROM item
ORDER BY itemCode

How can I get the codes without a suffix to appear with the codes that have a suffix? The itemSuffix field in the DB is NULL for no data records.

View 3 Replies


Similar Messages:

SQL Server :: Produce Embedded 'if' Conditions In Stored Procedure?

Feb 7, 2011

I a trying to produce embedded 'if' conditions in Stored Procedure.

I have the SP working without the embedded IF stmts indicated below.

I would like to have an easier method to choose the SQL stmt based on the user selection for the operand <>=.

[Code]....

the embedded IF stmts are the onese I am having issues with....

[Code]....

View 7 Replies

Web Forms :: Simple Server Control To Produce A Report Style Listing?

Feb 1, 2010

I currently have a gridview that is displaying tabular data from an sqldatasource that looks something like this:

[code]....

Since I have an unpredictable number of categories coming from the database, I would like to continue to use a single datasource with only one query to the database. There is no editing, it is simply for display purposes. What's the simplest way?

View 1 Replies

DataSource Controls :: Can't Find Query's / By Right Clicking On Database Created A Query In Server Explorer?

May 17, 2010

By right clicking on my database i created a query in server explorer. But where are this query stored can't find them back. I should aspect that their is a folder query's like there is a folder tables but this isn't the case.

View 10 Replies

SQL Server :: Sub Query In Cross Table Query To Create Statistics

Mar 2, 2011

I am trying to create statitics for game downloads and am having dificulty with a sub part of my query. the goup by command is not having the disired result and i think i have been looking at it too long to see what i am doing wrong. [Code]....

At the moment it is producing each result in many rows when only 4 rows should appear. its the download column that is doing it. needs to be sub queried or something to display total in relation to month,gameid,userid.

Month-download-GameID-UserID

1 1
1 1

1 1
1 1

View 2 Replies

SQL Server :: Query Slow In Loading / Trying To Display Query Result?

Feb 1, 2011

I am trying to display this query result in an aspx page.

It is very slow in loading. Here is the query. The inner query inside the outer quesry is the problem.(Please see the underlined part in the query) - (If I remove that part it is very fast.)

select

top 500

--This column is the issue
,Governing_Class=( case when exists (select top 1 tqc.class_code from
t_quote_class tqc
inner join t_quote_class_premium tqcm on tqc.class_code =tqcm.
class_code
where tqc.appid=pi.appid and tqc.class_code not in('8742' ,'8810','7380')
order by tqcm.premium_amt desc
)
then ( select top 1 tqc.class_code from
t_quote_class tqc
inner join t_quote_class_premium tqcm on tqc.class_code =tqcm.
class_code
where tqc.appid=pi.
appid
order by tqcm.premium_amt desc
)
......... From tables

View 7 Replies

Databases :: Oracle Query Convert To Sql Server Query

Sep 3, 2010

I am a biggner in SQL DB . but i started a complicated and painfull work in SQL SERVER 2008. the problem convert Oracle hierarchical query to SQL query. the query

SELECT DISTINCT
LEVEL LVL,
SCH.NSCHEDULE_SL,
SCH.NSCHEDULE_SL_FM,
SCH.CSHED_CNAME
FROM FA_SCHEDULES SCH
WHERE LEVEL = 1
AND NSCHEDULE_SL_FM IS NULL
AND NBRANCH_SL = 2
CONNECT BY PRIOR SCH.NSCHEDULE_SL_FM = SCH.NSCHEDULE_SL
AND NBRANCH_SL = 2

View 1 Replies

VS 2012 / Best Way To Produce A Percentage Bar?

Dec 2, 2013

I need to produce a simple graphic which is a simple rectangle (bar) with a variable portion filled in to denote a percentage.

What is the best way to achieve this? I had a look at the .net charting tools but the nearest I could find to what I needed was the barchart which didn't quite seem to meet my needs for a single value.

View 1 Replies

SQL Server :: How To Copy Result Query To Another Query

Nov 4, 2010

i have tow query in one stored procedure

first query and the second one every of them return only value

i want to copy the result of tow values in a new row in new table

as i want to check on this tow values in ado.net

i want to get only this tow values as a row not first and secon query

only a row has result of first and second query results

[Code]....

View 3 Replies

SQL Server :: Select Second Query If First Query Returns Nothing?

Oct 14, 2010

How can I SELECT second if first SELECT returns nothing?

View 8 Replies

Web Forms :: How To Produce Dynamic Links

Jul 5, 2010

Example site: [UL] In the left hand part of the page(refine result pane), how can I produce links/list like that? What control is used in that?? I know it has to use the data queried on the first page.

View 17 Replies

Web Forms :: Validation: 'expression Does Not Produce A Value'?

Jan 17, 2011

in the validation part.

Here goes the code:

[Code]....

At this particular part of the code:

[Code]....

I got 'Expression does not produce a value' in (ccJoin.ValidateCaptcha(tb_captcha.Text))

That code is used to validate and ensure that the user produces right value in captcha..

View 22 Replies

Web Forms :: How To Produce Table For A Chart

Mar 26, 2016

I want to display the value in table which i calcute in chart. Ex:

month                   salary

march(chart xaxis)    2000(chart yaxis sumof salary)
april       3000

View 1 Replies

How To Produce A CSV File / Loop Works Fine

Sep 16, 2010

How can I produce a CSV file. My loop shown below works just fine.. I just don't know CSV part.

foreach (Employee data in e)
{
Console.WriteLine("{0}{1}",data.EmployeeId, data.FirstName);
}

View 3 Replies

Produce File Unreadable With Excel Viewer

May 31, 2010

I want to output some dynamic data from an ASP.NET website to Excel. I found that the easiest way which does not require to use Excel XML or to install Excel on server machine is to output data as a table and specify application/vnd.ms-excel type

View 3 Replies

Inheriting From DataSourceControl Doesn't Produce IDataSource

Feb 15, 2010

I am trying to create a custom datasource control. I have been following this article to the letter (I think...). I have a skeleton / basic implementation of my datasource, however when I declare it in the markup and try to statically bind it to a gridview, I receive the following error:

The DataSourceID of 'grdVw' must be the ID of a control of type IDataSource

This seems extremely strange to me, since my datasource inherits from DataSourceControl, which in turn implements IDataSource. Even if I explicitly implement IDataSource in my custom datasource, it makes no difference. My Markup is:

<DataBrokerDataSource ID="objSrcDBroker" runat="server" />
<div>
<asp:GridView ID="grdVw" DataSourceID="objSrcDBroker" DataMember="Table0" runat="server">
</asp:GridView>
</div>
<div>
<asp:GridView id="grdVw2" DataSourceID="objSrcDBroker" DataMember="Table1" runat="server">
</asp:GridView>
</div>

And my control is:

Public Class DataBrokerDataSource
Inherits DataSourceControl
Implements IDataSource 'Have tried with this statement included AND excluded = same result
Protected Overrides Function GetView(ByVal viewName As String) As System.Web.UI.DataSourceView Implements IDataSource.GetView
'Code here
End Function
Protected Overrides Function GetViewNames() As System.Collections.ICollection Implements IDataSource.GetViewNames
'Code here
End Function
End Class

Looking at the stack trace shows that the error originates at:
System.Web.UI.WebControls.DataBoundControl.GetDataSource().

I have examined this method in reflector (see below), looking at this (based on the error message that I am getting) it appears to me as though the FindControl part is succeeding but that the source = control as IDataSource; leaves source as a null value, i.e. the conversion fails - But Why?

protected virtual IDataSource GetDataSource()
{
if ((!base.DesignMode && this._currentDataSourceValid) && (this._currentDataSource != null))
{
return this._currentDataSource;
}
IDataSource source = null;
string dataSourceID = this.DataSourceID;
if (dataSourceID.Length != 0)
{
Control control = DataBoundControlHelper.FindControl(this, dataSourceID);
if (control == null)
{
throw new HttpException(SR.GetString("DataControl_DataSourceDoesntExist", new object[] { this.ID, dataSourceID }));
}
source = control as IDataSource;
if (source == null)
{
throw new HttpException(SR.GetString("DataControl_DataSourceIDMustBeDataControl", new object[] { this.ID, dataSourceID }));
}
}
return source;
}

View 1 Replies

Make Custom Validators Produce Alert

Mar 3, 2010

All ASP.Net client validation messages can be shown as an alert by setting the ShowMessageBox="True" property on the ValidationSummary control. This works fine for anything that happens on the client.

For the custom validators that validate server-side I had assumed that what would happen is that when the page is returned to the browser, ASP.Net would inject some javascript to show the alert box. However this isnt the case.

If you had relied on the message box to show detail and just have a * next to the erroneous field (as per my clients req's) then it wont work as intended. Does anyone have a solution for doing this? What I want is a way to possibly override the ValidationSummary control to inject javascript onto the page or something like this.

View 1 Replies

Produce Trial Version For Customers To Download?

Mar 21, 2010

I've written a ASP.NET app that I hope to sell to businesses, I could host the trial but it's designed to connect to the customers data so customers will certainly want to install it to do a successful evaluation.

I've never produced anything commercial before so I'm looking for advice on how best to limit the trial, a 30 day trial seems most common, do you simply rely on the clock of the PC/Server they install it on? keep in mind this is ASP.NET app so will be installed on their web server.

View 4 Replies

Web Forms :: Dropdownlist Value Not In Different Table Produce An Error

Nov 30, 2010

I'm trying to do just as the title of this thread says:

I have a dropdownlist and to pick a client, and if there is no assignments (a different table) with that client in it I want the page to produce an error messagebox instead of going to the postbackURL.What would be the easiest way to do this?

View 1 Replies

Produce Error Message When Non Numeric Value Entered In Textbox?

May 9, 2010

If a user enters a non-numeric value into a TextBox and presses a Button, I want to show an error message on a Label. How can I achieve this?

View 3 Replies

Want C# ASPX Page To Produce Plain Text Rather Than HTML

Jul 29, 2010

I have a C# project in Visual Studio that produces an aspx page. The code I am editing is in default.asp.cs. When I build the project a file default.aspx is produced. This file looks something like this:

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="CSRValidationConnector._Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" [URL]-transitional.dtd">
<html xmlns="[URL] >
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
</div>
</form>
</body>
</html>

When I make my web request most of this page comes back. But I want the page to return only plain text and not any of this HTML. How do I configure things so that nothing is returned except what I add via Response.Write calls in default.aspx.cs?

View 2 Replies

SQL Server :: Get All Rows From Query A That Are Not In Query B?

Dec 17, 2010

Using sql server 2005.

I have an Query A of fields that returns X number of records.

I create a Query B of same fields that returns X-80 number of records.

I want to find out the 80 records that are in Query A but are not in Query B. what is the syntax for this?

View 4 Replies

How To Know Websites That Produce Free Source Code For Famous Web Application

Jul 25, 2010

I need to know websites that produce free source code for famous web application

View 2 Replies

WCF / ASMX :: Cann't Consume Web Service Produce By Oracle And Java

Oct 22, 2010

I have a hardtime to consume this web service as Web Reference or Service Reference: [URL] I'm using VS2010 and when I consume it as Web Reference, I can't use its method because in the reference.cs, it has these errrors:

// CODEGEN: The operation binding 'getStationCharacteristicSummary' from namespace '[URL]was ignored. The encoding '' is not supported.

If i consume it as WCF, then each time I call the service, it complained the encoding error. May someone try to consume it and help me with this.

View 1 Replies

SQL Server :: Trying To Get A Query Going In SQL Server But Get Bad/ Errors In The Query?

Nov 8, 2010

Trying to get a query going in SQL server but I get bad/ errors in the query.I have a 2 tables. One is the "Project" table while the other is the "Task" table.Table structure is as follows.

Project table => ProjectID,ProjectName
Task table => TaskID, TaskName,ProjectID,Quarter, Hours

A project can have many task. The ProjectID in Task table is the foreign key which reference the project ID.What I need to do is to SUM all the hours in the Task table and group it by quarter and then group it by ProjectID. Output of the SQL should be in the form of projectID,Quarter, Hours.

View 2 Replies







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