|
Hi,
I am inserting in database using ASP.Net. But the insertion in the tables is not happening in the order of insertion. Please help me how to insert in order.
for()
{
for()
{
for()
{
//method to insert(like Physics1A)
}
//method to insert(like Physics1)
}
//method to insert(like Physics)
}
I want in this order.
Class
Physics1A
Physics1B
Physics1C
Physics1
Physics
Chemistry1A
Chemistry1B
Chemistry1
Chemistry
But it is not inserting in this order. Please help me.
|
|
|
|
|
The above tells us almost nothing about what you are trying to achieve. Post the code that you have tried, and pointing out the areas that do not work. Do not expect someone to write your code for you.
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
