|
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?
|
|
|
|
|
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
|
|
|
|
|
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?
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
for()
{
for()
{
}
}
I think you need to do it by nesting two foreach loops...You dont need 3 nested loops for doing this.. .
![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
|
|
|
|
|
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
|
|
|
|
|
make sure flash plugin is installed on fire fox.
|
|
|
|
|
yeah thats not the problem.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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!
|
|
|
|
|
|
Thanks it looks great. Do you by chance know of any free control in .NET? 
|
|
|
|
|
I am agree with Mark. If you are using .NET 3.5 SP1 Framework, Microsoft having own Chart Control.
Have a look
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.
|
|
|
|
|
|
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
|
|
|
|
|
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?
Pankaj
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
I got a solution by which I can hide the column in the column expression. i.e. I have selected Jul column
Select Column -> Propeties -> Visibility -> Select Expression radio button and type the following expression
=iif(Fields!Jul.IsMissing,true,false)
However this is not the perfect solution. If I fetch records which contains Jun, Jul, Aug and write the above expression to hide the jul column then the Jul column will be hide but there would be space between the Jun and Aug. I want the space should not be there if the column does not hide. I am getting the following formate
before hide
State Jun Jul Aug
A 10 12 12
B 12 14 15
After hiding
State Jun <--space--> Aug
A 10 <--space--> 12
B 12 <--space--> 15
Pankaj
|
|
|
|
|
Hi friends,
how can i send long data in query string????
Query string data length is around 6000 character,,,,,Here i know the limitation of query string.....
can i use any different way to implement this task....I have to send data in query string only.
Because this thing i have to do in different domain like yahoo to gmail.
thanks,
Hemant Patel
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
