ADO.NET :: How To Avoid Identity_insert To Set Max Value As Identity
Jan 18, 2011
im using sql server 2008
as per microsoft, [URL]
when i execute the following
set identity_insert on
//insert statements here
set identity_insert off
the identity of the column is set to the maximum value. can i aviod this.
consider the following scenario,
my table has 2 rows as follows
id, name comm
1, John, 232.43
2, Alex, 353.52
now using the above code, when i insert
10, Smith, 334.23
as per the above link, sql server automatically sets the identity to 10. so for newly inserted records(without using identity_insert on), id automatically starts with 11.
i want the identity value to be 3, after using identity_insert on/off
I've got 2 tables where each has a primary key which is also the identifier (Both fields called "id" in each table) In the "picture" table as one of the fields I've got the photoalbumid (The id of the "photoalbum" table). This field is just an int field. I'm getting the following error: "Cannot insert explicit value for identity column in table 'Picture' when IDENTITY_INSERT is set to OFF" Can anyone give me some advise? It's such a basic thing I would hope that there's just something small in the creation of the database that I've missed out. Let me know if you need more info.
I am developing a asp.net application and i am using SQL Server 2008. I took a IDENTITY column as Record_ID for detail table where i will have trillions of records per year. So just want to ask whats the largest number record id (identity) column can hold and in ASP.NET which data type i should use to handle record id as i am using this id as a reference to update the table data. I don't want to end up being trapped some day.
In IIS Manager center pane, there is an icon titled "Authentication" as follows: Clicking the icon, we get 3 items as follows: Right clicking the Anonymous Authentication and select edit, we have: Question: which one should I use? What is the difference?
I am trying to complete a seemingly simple task that has turned into a several hour adventure: Getting @@Identity from TableAdapter.Insert()
protected void submitBtn_Click(object sender, EventArgs e) { AssetsDataSetTableAdapters.SitesTableAdapter sta = new AssetsDataSetTableAdapters.SitesTableAdapter(); int insertedID = sta.Insert(siteTxt.Text,descTxt.Text); AssetsDataSetTableAdapters.NotesTableAdapter nta = new AssetsDataSetTableAdapters.NotesTableAdapter(); [code...
I need to create Unit Tests for an ASP.NET MVC 2.0 web site. The site uses Windows Authentication.I've been reading up on the necessity to mock the HTTP context for code that deals with the HttpContext. I feel like I'm starting to get a handle on the DI pattern as well. (Give the class an attribute of type IRepository and then pass in a Repository object when you instantiate the controller.)
What I don't understand, however, is the proper way to Mock the Windows Principal object available through User.Identity. Is this part of the HttpContext? have a link to an article that demonstrates this (or a recommendation for a book)?
I need to retrieve the identity value after the record has been created for another datasource. I.E. When the record is created in SqlDataSource7 the identity value (4700) would be assigned to Label1.text and used in SqlDataSource8 to insert a new record.
How do I do this? In the CodeBehind retrieve the identity value using SqlDataSource7 Scope_Identity() and putting that value into the SqlDataSource8 ApplicantID column.
I know that if i use newRow = StronTypeDataTable.NewStrongTypeDataRow();
there is a way that i can add the row to the database using the table adapter and have the ID value of the Row accurately reflect the ID on the data base but i cant seem to figure it out.
I've got a situation where it seems I am required to have an identity impersonate statement in my compiled web app, i.e. <identity impersonate="true" username = "mydomainmyusername" password ="xxx" /> The thing is, it is not required when running from Visual Studio and virtual web server, as everything works fine, but when I do not have the <identity> tag in the web.config file in my compiled web app, I get a connection error. Simply won't connnect to the database if the <identity> tag is not there. I'd rather just do away with this requirement, and have been looking through IIS for a solution, but can't seem to find any.
I am where you "Create" an entry in the table, i have deleted the Id field, as Id is my primary key, and Is Identity = Yes, Identity Increment = 1, Identity Seed = 1.
When i hit the create button, the Id value is being validated, giving an invalid error. If i add the Id column back to the page, and fill in any number and click create, the entry is added to the database, with the Id value incremented (the typed in value does not matter). I believe this must have to do with the Movies.Designer.cs... but not sure how to fix it. Id should not be validated as it auto-incraments, but the model is looking for a Id value..
I just not created a new database with 2 tables in it. In a table, I have set a column as a primary key and trying to change its properties i.e. setting is Identity to YES, but am not able to do so.
So far it seems like I get something figured out then run into another issue... Anyways, I was finally able to grab an ID from a table and enter the value into a Label using this code:
[Code]....
Now i want to make things trickier by grabbing the last value enterd. Now there will possibly be multiple people using the application simultaneously, i think it is still possible to do this. Here is the statement that enters VALUES into the table that generates the CaseID that i want to grab from:
[Code]....
From what i have researched, I may need to do a WHERE some where to grab the @@IDENTITY. I am having trouble figuring out where the @@IDENTITY goes, and possibly the correct syntax as well.
I have a registration page that must contain a user id label. When a user tries to register, the label on the page should show the identity value for the registration before completion. How to do this?
I want to know if this kind of authentication is possible.
We have an Active Directory account and that account we are using to log in to windows. I have a simple system that needs authentication using the IIS log in box (i dont know what do you call this but what I know is it only comes out when Anonymous user is unchecked in the IIS configuration.) Now, I want this box to appear before my page and the user will be authenticated and be compare to the user who logged in to the windows. If the user who have been authenticated is the same as the user who logged in to the windwos then we will let him in if not he must be denied in accessing the page.
The first problem I have in my mind is how to code it in asp.net to make an authentication when he will try to access my page.
Second is, let us say we have succeeded to show the authentication box, how can I get the username from the log in box and compare it to the user who logged on in windows. Of course we can get the user id of the logged in user from the windows using User.Identity.Name but how about the username from the log in box.
Note: I will not use log in forms even using https. Just the log in provided by the IIS according to the configuration.
Possible Duplicate: How to change programmatically non-identity column to identity one? I want to set a column as identity as I have already created this column in a table. What syntax do I need?
