ASP.NET

Ashfield17-Sep-09 9:25

Ashfield

17-Sep-09 9:25

Why is the insert order important? The select should be responsible for the order the data is presented in.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

srikantha_nagaraj18-Sep-09 20:01

srikantha_nagaraj

18-Sep-09 20:01

Actually i am selecting in order and insertion also happen in order as per as the code. But in the table instead of going to last row of the table it is inserting in the middle of the other rows. For example, it is inserting like this,

Physics1A
Physics1C
Physics1B
Chemistry
Chemistry1
Physics
Chemistry1C
Physics1
Chemistry1A
Chemistry1B

But i want in this order.

Physics1A
Physics1B
Physics1C
Physics1
Physics
Chemistry1A
Chemistry1B
Chemistry1
Chemistry

I am using cmd.ExecuteNonQuery() for insertion is it giving a problem?
Can i use anything other than that?

Ashfield18-Sep-09 21:36

Ashfield

18-Sep-09 21:36

Add an identity column to your table, then select back ordered by the identity column. I bet they are in the order you inserted them. A select without an order by is not guaranteed to return the records in any specific order (although generally it will be in the order of the PK idf there is one). Thats what is happening in this case, they are inserted in the order you do them (if its not the order you think then your code is wrong), but you do not define the order when you select them back, hence the difference.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

srikantha_nagaraj18-Sep-09 22:35

srikantha_nagaraj

18-Sep-09 22:35

How to put an identity column to my table? Please help me.
I don't have primary key defined. For this is it giving problem?

Ashfield20-Sep-09 22:42

Ashfield

20-Sep-09 22:42

I have told you what to do, and also that there is no problem. To find how to put an identity column on the table try google, I'm not dong the entire job for you.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Christian Graus17-Sep-09 10:26

Christian Graus

17-Sep-09 10:26

They will insert in the order you insert them. However, as someone else said, if the order they come out matters, and it's not alphabetical, you should use an index to sort by to specify the order from.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

swf embed fails in firefox

Abhishek Sur17-Sep-09 11:25

Abhishek Sur

17-Sep-09 11:25

//Method to insert Class in heading
for() //will loop through {physics, chemistry ... }
{
   for()
   {
      //Write Physics1A, 1B, 1C
   }
   //method to insert(like Physics1)
   //method to insert(like Physics)
   //Next loop again for Chemistry.. .and so on...  
}

I think you need to do it by nesting two foreach loops...You dont need 3 nested loops for doing this.. .

Rose | [Rose]

Abhishek Sur

My Latest Articles
Create CLR objects in SQL Server 2005
C# Uncommon Keywords
Read/Write Excel using OleDB
Don't forget to click "Good Answer" if you like to.

AndyInUK17-Sep-09 4:41

AndyInUK

17-Sep-09 4:41

Hi Devs,

The code below works fine in IE . It basically embeds swf file onto aspx page, but when i try this on Firefox - it doesn't work

<object id="myMovieName" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0"
    height="100%" width="100%" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" >
    <param name="_cx" value="994" />
    <param name="_cy" value="1482"/>
    <param name="FlashVars" value=""/>
    <param name="Movie" value="..\test.swf"/>
    <param name="Src" value="..\test.swf"/>
    <param name="WMode" value="Window"/>
    <param name="Play" value="0"/>
    <param name="Loop" value="-1"/>
    <param name="Quality" value="AutoHigh"/>
    <param name="SAlign" value=""/>
    <param name="Menu" value="-1"/>
    <param name="Base" value=""/>
    <param name="AllowScriptAccess" value="always"/>
    <param name="Scale" value="exactfit"/>
    <param name="DeviceFont" value="0"/>
    <param name="EmbedMovie" value="0"/>
    <param name="BGColor" value=""/>
    <param name="SWRemote" value=""/>
    <param name="MovieData" value=""/>
    <param name="SeamlessTabbing" value="1"/>
    <embed src="..\test.swf" flashvars=""init=yes&check=true"" quality="high" bgcolor="#FFFFFF"
    width="100%" height="100%" name="myMovieName" scale= "exactfit" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer">
    </embed>
</object>

Any Ideas ?

Thank you

Re: swf embed fails in firefox

Muhammad Mazhar17-Sep-09 9:03

Muhammad Mazhar

17-Sep-09 9:03

make sure flash plugin is installed on fire fox.

Share your experience with others
Check my Blog...

Re: swf embed fails in firefox

AndyInUK17-Sep-09 11:53

AndyInUK

17-Sep-09 11:53

yeah thats not the problem.

Saving Classic ASP Session Data to a SQL Database

aj_coder17-Sep-09 3:54

aj_coder

17-Sep-09 3:54

From forum posts, the MSDN article below seems to be the most popular solution to saving classic ASP session state data to a SQL Server.

How to Share Session State Between Classic ASP and ASP.NET

The sample code and instructions are very straightforward. Unfortunately after attempting to implement the solution several times, the classic ASP page still isn't storing the session data to the database as promised. Has anyone used this solution and actually gotten it to work? If so, were there additional steps taken?

Also if you didn't use this solution to save classic ASP session date, what method did you use?

Thanks a million.

Re: Saving Classic ASP Session Data to a SQL Database

Christian Graus17-Sep-09 10:57

Christian Graus

17-Sep-09 10:57

I've done this by writing a service that both the asp and asp.net code can talk to

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

.NET Dashboard

Civic0617-Sep-09 3:32

Civic06

17-Sep-09 3:32

I was looking for a dashboard where I'll have couple of odometer's where the number's on each are dynamic pulled from database and the needles point to the current number which comes from database as well. On the Odometer there will also be a legend showing 2008 and 2009. There will be two needles one that shows the 2008 values and the other that shows the 2009 values. How can I achieve this? Either in Classic ASP or in .NET. Is there something already built that I can use like a third party control or is this something that can be written from scratch in .NET?

Thanks!

Abhijit Jana17-Sep-09 3:52

Abhijit Jana

17-Sep-09 3:52

Have a look into it[^]

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Civic0617-Sep-09 4:20

Civic06

17-Sep-09 4:20

Thanks it looks great. Do you by chance know of any free control in .NET? Smile | :)

Abhijit Jana17-Sep-09 4:23

Abhijit Jana

17-Sep-09 4:23

I am agree with Mark. If you are using .NET 3.5 SP1 Framework, Microsoft having own Chart Control.
Have a look Smile | :)

MS Chart Control[^]

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Abhijit Jana17-Sep-09 4:27

Abhijit Jana

17-Sep-09 4:27

One more link, It may be more interesting to you.
http://www.fusioncharts.com/widgets/Gallery.asp[^]

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Not Active17-Sep-09 4:12

Dynamic column in SSRS 2005

17-Sep-09 4:12

Of course you can always write your own, but Microsoft's .NET Charts don't come with an odometer control, so if you want this there are plenty of third-party components such as Dundas, Infragistics, Telerik to choose from

only two letters away from being an asset

Pankaj Saha17-Sep-09 3:11

17-Sep-09 3:11

I have to create a report, where I have to show the columns dynamically according to the parameters. i.e. I have a date selection criteria may 2008 to june 2008 or june 2009. Now the report will be shown by the month of different locations. Here numbers of month are changing according to the selected date. I have used matrix, could not change the column dynamically. Is there any method to achieve this? Confused | :confused:

Pankaj

Not Active17-Sep-09 4:15

17-Sep-09 4:15

In the report designer you should be able to right-click on the column and select Column Visibility. From there set an expression to hide or show the column as necessary

only two letters away from being an asset

Pankaj Saha17-Sep-09 18:40

17-Sep-09 18:40

Thanks for the replay. But the columns are generated dynamically, so we do not know how many column and what column will be shown.

Pankaj

Not Active18-Sep-09 1:46

18-Sep-09 1:46

Your statement make no sense at all.

Pankaj Saha wrote:
what column will be shown.

Then how can you determine when to show or hide in the first place.

Pankaj Saha wrote:
columns are generated dynamically

Are you generating the RDL for the report? Then you control the columns anyway.

only two letters away from being an asset

Pankaj Saha20-Sep-09 18:54

20-Sep-09 18:54

Mark Nischalke wrote:
what column will be shown.

There are 12 months in the column, but when I select a date range i.e. March, April and December of 2009 then there would be only 3 month columns. So its depends on the selected date range. Months column can be increased/decrease according to the selected date range. Since I have to show in the matrxi form because I am also selecting the location/country with date range then it will show the records by location and by selected date. I have used Sql Server procecdure where I have to pass the date range and location information then it shows the result in the following manner

State January March April

A 20 30 40
B 5 6 30

Hera state rows and columns are generated dynamically. This the report in SSRS 2005. I did not get any solution to show this type of records where columns are generated dynamically.

Pankaj

Not Active21-Sep-09 2:00

21-Sep-09 2:00

So return 0's or nulls for the columns you don't want to show and use an expression to hide/show the columns.

State January Febuary March April May June July
A 20 0 30 40 0 0 0
B 5 0 6 30 0 0 0

It seems like you're making this more difficult than it is

only two letters away from being an asset

Pankaj Saha23-Sep-09 22:58