DataSource Controls :: Unique Number Needed For Tracking Use SQL Server 2005 And Framework 2 - C#
Jul 6, 2010
I have developed a Portal (Request submission) which sends an Email and also it updates all values to the Database. What ever values gets updated to the database, will be sent as an email message to an address. It works fine. I need a Unique number to be generated for a Request submission which has to be sent in the Email message and also it has to be updated in the database. I use SQL Server 2005 and Framework 2, C# laungauge.
I am generating a unique Ref number using this sql statement: SELECT REPLACE(STR(CAST(CAST(NEWID() AS binary(5)) AS bigint),12),0,0) as REF Subsequently, I need to insert this REF into sql database table in stored procedure. Here is what I did in my stored procedure:
USE [iBankRecords] GO /****** Object: StoredProcedure [dbo].[stp_addPayee] Script Date: 07/05/2010 21:57:07 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROC [dbo].[stp_addPayee] ( @CUSTID char(10), @PAYEEACCNUM nvarchar(20), @PAYEEACCTYPE char(10) , @PAYEENAME char(20), @PAYERINITIAL char(20), ) AS DECLARE @ReturnValue int INSERT INTO PAYEE (CUSTID, PAYEEACCNUM,PAYEEACCTYPE,PAYEENAME,PAYERINITIAL, REF) VALUES (@CUSTID,@PAYEEACCNUM,@PAYEEACCTYPE,@PAYEENAME,@PAYERINITIAL, REF) IF @@ERROR<>0 BEGIN PRINT 'ERROR' SET @ReturnValue=1 RETURN @RETURNVALUE END ELSE BEGIN SET @ReturnValue=0 RETURN @RETURNVALUE END
May I know how do I have generating a unique ref num and inserting the REF into the above statement?
i had the sql 2008 enterprise and i want to go back to sql server 2005 because in 2008 i created new database but when i did some changes in the table , it gave me an eror that i cant save thins and i need to creat new one if some one know what i'm talking aboutif not i need the sql server installation tutorial i tried by myself but probebly i did it wrong and now i cant connect well to the sql
I have an ASP.NET application where View.aspx page will display the details of each products in a shopping cart.The page displays dynamic data(Ex: For each product id,the content will be different).Now i want to track the unique page views of each product.What are the best solutions to approach this problem ? I am already using google analytics.But i wanna custom solution/code for my web app,so that i can know how many hits came for each product
How generate the unique no. 1,2,3 and so on .... on button click of each new user ..
the code mentioned below is a readwrite coding in vb.net ...
but the problem is it generate the same id for different users on button click event... but i want the no. of times button clicked the new ids will be generated
I have an old Web application which is using net framework 2.0(build with vs2005), now i need to move the old Web application to production server which has .net framwork 3.5 installed. Do I need recompile the web application with vs2008 or i can just go head move the the Web application without recompiling, it will automatically work?
Is there any way of tracking EF entities changes between contexts for ASP.NET applications?
Self-Tracking entities doesn't work well for me as it is primarily designed for WCF. And all approaches for tracking changes for POCO I have found are oriented on shared context.
Previous developers have developed a .SSISDeploymentManifest file (SQL Server 2005) to install SSIS packages which prompts a Package Installation wizard. I tried to install it on SQL Sever 2008 (it works on SQL Server 2005), but it failed with the error: "Storing or modifying packages in SQL Server requires the SSIS runtime and database to be the same version. Storing packages in earlier versions is not supported".
How do I install 2005 SSIS packages on SQL Server 2008? I have all the .dtsx files, not sure how to install them?
I have created my database in SQL Server 2005 Enterprise Edition and now planning to tranfer this databse to another server, But this other server is SQL Server Standard Edition, So if i try to attach my database which is created in Enterprise Edition will get sucesully connected to Standard Version ? or i will get any error message or i am doing something wrong ? This situation is fine or Version should be kept same ?
let us assume that I have a reusable business layer that further makes use of a data access layer that was implemented using Entity Framework 4.0. The entities returned/consumed by the business layer are self-tracking, allowing us all the goodies that come with those type of entities. I would like to be able to store the entities I work with across post backs (on order to avoid re-querying every time). Basically let us assume I have a paged GridView with 10 items in it, and something like a DetailsView to edit those items. Every time you select a new row on the grid, the details view updates with the information of the selected row. My preference would be to only query for the entities on the initial request of the page and store it in session. Then subsequently I have a list of entities that I can work with and eventually modify and send back to the business layer with all of the changes.
I really want to use session instead of view state to reduce the page payload (self tracking entities are heavy) however I really like view state for this because of the fact that when the user navigates away from the page there is no residual effect. Some of the things that worry me are: When a user navigates away from the page to another page, the entities from the previous page are still in session. I could always do something on load of a page to do housekeeping type of work. Not sure if that's good practice. I am worried about people opening browser tabs and having two views into the same page, it seems like that might pose a problem. Is this even a good approach? Seems like I am trying to have the best of all worlds, it would definitely be much easier to simply re-query on every post back for the entities and pay the 50-100ms hit of the database trip.
I have a model that consists of Order, OrderLine, Product.
I want to create an Order and add OrderLines (each OrderLine related to a Product). I create the Order and add new OrderLines to it. Between posts I store the Order entity in Session (or ViewState). Just so you know I have added suppport for binary serialisation which works fine.
The relationship is therefore Order > OrderLine(s) > Product(s).
You might have already guessed what the problem is - that when I SaveChanges() I get the usual 'AcceptChanges cannot continue because the object's key values conflict with another object in the ObjectStateManager.' error.
I have referred to a number of articles online but none seem to handle this case (where I have the relationship across more than two entities) e.g. [URL].
This must be a very common requirement surely? Is there anyone out there doing the same kind of thing with Entity Framework (and without using DTOs etc)?
The sites that I've got are still in classic ASP. I know this is a good reason to move to .net but I don't want to have to redo all the sites yet.
So here is the problem:
[Code]....
When I have "On Error Resume Next" no erros get posted and everything runs just fine, the pulls from the database work perfectly. But as soon as we take On error resume next we start getting the following erros: err#424err desc:Object requiredsql:SELECT Name,URL,Title FROM tblMenu WHERE Parent_ID=1 AND Deleted=0 ORDER BY SortOrderScript Name: /index2.asp
STUDENT PARENT student_id (PK) parent_id (PK) student_parent (FK) parent_status (the value is either ACTIVE OR INACTIVE)
- parent_id is refer by STUDENT table as a foreign key
- now i want to inactive the status for parent
- i want my system pop out a message something like "The parent you want to inactive is refer by a student, inactive is not allow"
- is it any constraint in SQL Server 2005 to help me check whether parent it is refer by student table? The concept i want to use is something like delete constraint in SQL Server 2005 mean it is not allow to delete a person who is refer by a student in STUDENT table.
i am tring to connect to my db in sql server 2005 :) and have some problem with it.the error that i get is : Keyword not supported: 'datasource'.the line that i have an error is :
Im using MS SQL 2005 as my database for asp.net application.. now i want to asign Static ip address to ms sql server 2005 to access all over the world... so would u plz tell me step by step to configure static ip to ms sql server 2005..
My asp.net 2.0 is deployed in web hosting.. now here in my server i have configure a static ip.. so how to access my ms sql database all over the world.. i need to know is that i need to write directly connection string in a webconfig of my static ip.. or i need to create a instance of my static ip to ms sql server 2005 to access the database..