Re: SQL Quastion - ASP.NET Discussion Boards

Uma J5-May-09 1:00

5-May-09 1:00

set the property as,
AppendDataBoundItems="True"
<asp:listitem value="0">Select

if(DropDownlist1.selectvalue == "0")
{
response.write("Select atleast one value");
}

typing special character in ie 7 and above

jhyn3-May-09 21:29

jhyn

3-May-09 21:29

Hello everyone,
I have a problem regarding special character in internet explorer 7 and above.
i typed ñ but the output is a black diamond(♦). But if i typed it in ie 6, i got it correctly. Confused | :confused:

any suggestion?

thanks

jyn

Re: typing special character in ie 7 and above

N a v a n e e t h3-May-09 21:45

N a v a n e e t h

3-May-09 21:45

jhyn wrote:
any suggestion?

Yeah, post in a right forum. This has nothing to with ASP.NET. Smile | :)

Navaneeth

How to use google | Ask smart questions

Re: typing special character in ie 7 and above

jhyn3-May-09 21:49

jhyn

3-May-09 21:49

sorry

jyn

Re: typing special character in ie 7 and above

N a v a n e e t h3-May-09 21:59

N a v a n e e t h

3-May-09 21:59

No issues. Try this[^] forum. This[^] also.

Navaneeth

How to use google | Ask smart questions

SQL Quastion

Vimalsoft(Pty) Ltd3-May-09 21:20

Vimalsoft(Pty) Ltd

3-May-09 21:20

Good Morning All

i have a Table

===================
DESCR         CYCLE 
===================
Rendle C      |	5 |
Reid M Prof   |	9 |
Randall S Ms  |	3 |
Reid M Prof   |	3 |
Rendall G Mr  |	3 |
Rendle C      |	3 |
Rendall G Mr  | 2 |
===================

Now as you can see "Rendle C" and "Rendall G Mr" appears Twice, now i want append the cyle field if the descr appears twice, the above list should now look like this

===================
DESCR         CYCLE 
===================
Rendle C      |	5 3 |
Reid M Prof   |	9 3 |
Rendall G Mr  |	3 2 |
===================

How can i do this in SQl

Thank you

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
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Re: SQL Quastion

Christian Graus3-May-09 22:12

Christian Graus

3-May-09 22:12

AS you said, this is a SQL question. It belongs in the SQL forum. But, one question - will you know for sure that each Descr will have the same number of entries ? You may want to do this in code, depending on how big the data set is.

Christian Graus

Driven to the arms of OSX by Vista.

"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )

Re: SQL Quastion

Vimalsoft(Pty) Ltd3-May-09 22:30

Vimalsoft(Pty) Ltd

3-May-09 22:30

Good Morning Chris

Am very Very Sorry for Posting this question here. i should better than. Please move it for me to the SQL Forum.

Christian : wrote
will you know for sure that each Descr will have the same number of entries ?

No, What am trying to achieve is that if the Field Descr appears more than once , take the Cycles and Append them

e.g if i have this

Descr  | cycle
===============
James  | 4
James  | 3

Now if its like this i want to add the Cyles field

like this

Descr  | cycle
===============
James  | 4 3

Please note that this is not a Duplicate, am refining an old Functionality that used to Display them in a Grid. The Dataset will not be big. But i thought i should some manipulation in SQL, because at the end i will be displaying this on a Grid.

Thank you

Re: SQL Quastion

Christian Graus3-May-09 22:44

Christian Graus

3-May-09 22:44

If the number of columns is going to be arbitrary, I really think your best bet is to get a single datatable, in the form you're getting it now, and then build the data in memory in a format that will bind to a repeater or grid.

Re: SQL Quastion

Ramesh Swaminathan3-May-09 22:56

Ramesh Swaminathan

3-May-09 22:56

Hope this will help you

CREATE FUNCTION dbo.fn_Join_Cycles
(
@V_DESCR VARCHAR(20)
)
RETURNS VARCHAR(1000)
AS
BEGIN
DECLARE @V_ConCat_Cycles varChar(1000)

SET @V_ConCat_Cycles = ''
SELECT @V_ConCat_Cycles = @V_ConCat_Cycles + ' ' + STR(CYCLE)
FROM YOURTABLE
WHERE DESCR = @V_DESCR

RETURN @V_ConCat_Cycles
END

SELECT DESCR, dbo.fn_Join_Cycles(DESCR)
FROM YOURTABLE
GROUP BY DESCR

Show Popup message dynamically

scothykonma3-May-09 20:54

scothykonma

3-May-09 20:54

Hi all,

I have to show a popup message in every page when a new customer added into my site (developing).When a page loads it shows a message with fadeIn effect and the user close the message with fadeOut effect....

Placed the label box and close button inside a div

<div class="close" id="fadediv" style="background-color:#FFF8E6; border:1px solid #ECC975 ; font-size:16px;">
        <asp:Label ID="lblMessage" runat="server" />       
       <img src="images/close.gif" alt="" onclick="fadeOut('fadediv',20,500);"></div>

How to show?....I am trying but it every time shows all the label boxes...

Give some example sites....I will try...

Thanks in Advance

Re: Show Popup message dynamically

Christian Graus3-May-09 22:14

Christian Graus

3-May-09 22:14

I assume there's a fadeIn method, so you want to call that, right ?

Re: Show Popup message dynamically

scothykonma4-May-09 0:17

scothykonma

4-May-09 0:17

yes

Re: Show Popup message dynamically

saanj3-May-09 22:55

saanj

3-May-09 22:55

You can use AJAX Modal Popup Extender.

Either you love IT or leave IT...

404 redirect for dynamically generated page(Data not found in database)

anuj_24mar@yahoo.com3-May-09 20:17

anuj_24mar@yahoo.com

3-May-09 20:17

Hi All, On my page, if data is not found, i want to redirect my page to some customized page ( saying data not found) with a status code 404 so that google dont crawl it. I am using following code - Response.Clear(); Response.Status = "404 not found."; Response.StatusCode = 404; Response.AddHeader( "Location", "error.htm"); Response.RedirectLocation= "/error.htm"; It sets my page status to 404 but doesnt redirect to "error.htm", however this code works for 301 & 302 redirection. If anyone have idea, please help me out.

anujsharma

Re: 404 redirect for dynamically generated page(Data not found in database)

N a v a n e e t h3-May-09 21:49

N a v a n e e t h

3-May-09 21:49

anuj_24mar@yahoo.com wrote:
It sets my page status to 404 but doesnt redirect to "error.htm"

I assume it redirects to the page which is configured in IIS. If yes, you need to change this to error.htm in IIS settings.

Smile | :)

Navaneeth

How to use google | Ask smart questions

[newbie] Linq cannot find the tablename..

jon-803-May-09 19:42

jon-80

3-May-09 19:42

When running a tutorial project on LINQ, I'm getting an error:

The table name property of LinqDataSource 'LinqDataSource1' must specify a table property or field on the data context type.

I tried to set the TableName property to RegClient, which is the name of the actual table name of the database created within the project, however, VS does not seem to recognize it. From the horizontal dropdown next to LinqDataSource1.TableName the table name does not show up, which might mean that it was not configured.

Any ideas?

Confused | :confused:

NOTE: Cannot paste code directly due to a network problem on the VM where the code resides.

Reference book
ASP.NET 3.5 - A Beginner's Guide written by William B. Sanders (2009).

Jon

Re: [newbie] Linq cannot find the tablename..

Abhijit Jana3-May-09 19:57

Abhijit Jana

3-May-09 19:57

jon_80 wrote:
When running a tutorial project on LINQ, I'm getting an error:

The table name property of LinqDataSource 'LinqDataSource1' must specify a table property or field on the data context type.

Can you please put the line of code?

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net

Re: [newbie] Linq cannot find the tablename..

Abhishek Sur3-May-09 22:35

Abhishek Sur

3-May-09 22:35

If you use object of Table class, it is must to provide the actual table map attribute on the header.

I think the DBML you made doesnt have the actual tables in the database. Just change the connectionstring and create the table structure as mentioned in the DBML.

This error will wiped out automatically....

Abhishek Sur

My Latest Articles
Basics on LINQ and Lambda Expressions

Create .NET Templates

[newbie] binding anomaly

jon-803-May-09 8:21

jon-80

3-May-09 8:21

I'm going through a tutorial which mentions the use of:

<br />
1. <asp: Label ID="myLabel" runat="server" Text=<%# boundMessage() %/><br />
This does not seem to compile.  Error message: <br />
Attribute values must be enclosed in quotation marks.<br />
<br />
2. <%DataBinder.Eval (Container.DataItem, "SupID" %><br />
This does not compile. Error message:<br />
The name 'Container does not exist in the current context'<br />
<br />
3. When I use the following connection string, I get an error from SQL Server, only on DELETE <br />
statements:<br />
hookUp = new SqlConnection("Database=localhost\\$INSTANCENAME; Database=$DATABASE_NAME; Integrated Security = True".<br />
<br />
I resolved this by using the connection string generated by Visual Studio and the code compiled fine (lazy fashion), however, I could not understand how the same connection string returned no errors with<br />
SQL UPDATE and SELECT statements.<br />
<br />

Reference book
ASP.NET 3.5 - A Beginner's Guide written by William B. Sanders (2009).

Jon

Re: [newbie] binding anomaly

Christian Graus3-May-09 13:20

Christian Graus

3-May-09 13:20

jon_80 wrote:
Attribute values must be enclosed in quotation marks.

Correct.

Text="<%# boundMessage() %>"

jon_80 wrote:
The name 'Container does not exist in the current context'

I assume this code exists outside of a bound control. Actually, I think you need to use <%# or <%= ( I forget which )

jon_80 wrote:
When I use the following connection string, I get an error from SQL Server, only on DELETE
statements:

And what is the error ?

Re: [newbie] binding anomaly

jon-803-May-09 19:47

jon-80

3-May-09 19:47

Well, I tried

<asp:Label ID="BindMe" runat="server" Text=<%= boundMessage() %/> to no avail, because VS generated the following error:

Server tags cannot contain <% ... %> constructs.

Jon

Are "Master pages" ASP.NET's answer to Template Engine for .NET 2.0?

Member 3653373-May-09 7:15

Member 365337

3-May-09 7:15

When first released, ASP.NET lacked a template engine.
So now, for .NET 2.0, ARE "master pages", ASP.NET'S version of a template Engine?

If no, how do regular Template engines (StringTemplate) differ from 'Master Pages'?

Thanks in advance,
Laura

Re: Are "Master pages" ASP.NET's answer to Template Engine for .NET 2.0?

Christian Graus3-May-09 13:24

Christian Graus

3-May-09 13:24

A master page provides a template for all pages, by providing for some areas to be common to all pages, and yet written once. I have no idea how this differs from what you regard a template engine to be, but it feels like a good fit to me.

execution of remote file

sarav883-May-09 6:57

sarav88

3-May-09 6:57

hi..in my project..i m dng an execution of exe file(an updation of software version) for a software present in the different machine...i,e,the update file is present in one machine, and the real software is present in differetn machien..
when i run the update file,specifically an exe file, the update should go to the specifed machine software...i want to this in a asp.net web site

thanks,in advance

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