|
I have two datatable named lik dtSource(from Source Database) and dtDestination(from Destination database),
I have to insert all record of dtSoruce in dtDestination using CommandBuilder.
I am generation the query using commandbuilder
daDestination.InsertCommand = commandBuilder.GetInsertCommand();
daDestination.Update(dtDestination);
the above line of code insert all record successfully in destination table,
But my proble is that i want to insert record in Identity field of destiantion table
from dtSoruce.
I am using sqlbulkcopy but it also not do.
what is the process of inserting recording in identity field using commandbuilder???????????
|
|
|
|
|
An identity field can not be set using insert. It will be auto-incremented by sql.
If you want to intially set the values because you need to seed the table with pre-existing values, remove identity, insert values, then turn back on.
On an on-going basis, if you want to control the values in the identity column, you will not want to have the field as an identity column at all.
sqlbulkcopy does have an keepidentity option.
http://msdn.microsoft.com/en-us/library/tchktcdk(VS.80).aspx[^]
For performance reasons, I would handle the identity outside of the sqlbulkcopy process as well as other contraints and indexes. Depends on what, how often, how much...
modified on Thursday, March 25, 2010 9:27 AM
|
|
|
|
|
hoe to get repeater generated it for all items used to delete rows of repeater??
|
|
|
|
|
Your question is not clear.Can you explain bit more?
|
|
|
|
|
i need to delete rows in repeater.. how to do that...
as each row has unique id in repeater control how do i know the id of each row...
|
|
|
|
|
So what is the problem,Just have an link button in repeater, and on itemcommand event delete that item then again bind the repeater.
For examle have alook to the link Click here
|
|
|
|
|
two columns descriptionname and description and dont hav any id..
sqlcmd.xommandtext="delete from descriptiontable where descriptionname=@descriptionname and description=@description"
if two rows has same values then both will be deleted i want to delete only one row...
the values entered are from dynamic textboxes in repeater control
|
|
|
|
|
You can genrate your own id, like some identity column in DB and put a check while deleting.You can put the id in some hidden field in repeater if you require.
|
|
|
|
|
I am using ASP.NET 3.5 Menu Control.
Is there a way to disable the default "fly-out on hover" behavior, and change it so that user CAN CLICK on the static menu item to make the child menu item appear?
|
|
|
|
|
Hi All,
do u guys know how to integrate RSA SecurID with .net
Thanks and regards,
Amit Patel
|
|
|
|
|
I am not sure exactly how to implement this on ASP.NET but I think you can have some idea from this article: Why and how to implement SecurID Authentication[^].
From my experience as SecureID user (not a developer), SecureID is used as a first layer of security that makes sure I am authorized to access the login page of a resource that I am trying to access. Second layer of security is the login page itself of the resource (webpage, network share, etc).
No links to any API, though. I am interested in implementing SecureID on my future projects as well, so I am monitoring this post. 
Remember, your work is not yours alone. Somewhere, there are some codes written by others amongst us that depends on your work. By failing to see that you are part of their ecosystem, you are bound to break their code. *http://dotnetrandz.blogspot.com*
|
|
|
|
|
Hi people i am busy writing a monitoring website
Using ASP,the website need to get data from netbotz cams via SNMP.
now i thought it would be a interesting subject to talk about
if it is possible to query data straight from the cam using ASP or SQL
and if not then how would you retrieve the data from the cams?
|
|
|
|
|
Hi,
I am having a web application in asp.net 3.5 . Now i need to convert / re architecture / redesign that application to the asp.net mvc framework2 web application.
I have downloaded the framework and working in my system.
The existing project has the following parts.
1) database (in sql server 2005) with tables and stored procs.
2) aspx pages and its code behind
3) WCF service contains all the business logic classes.
The new asp.net mvc 2 framework has three folders like model view and controller.
Pls help me to decide what shoould come in which folder?.
As per my knowledge, the db paert should come in model. But all my business logic classes are in a separate wcf service.Do i need to create that service in controller? Then where i can include the code behind code.
Pls help me.I am totally confused.
Thanks in advance,
Chit
|
|
|
|
|
Asking the same question several places wont help!!! Post it at one place only.
|
|
|
|
|
Hello .
I have a problem in asp.net i have used imagebuttons. OnClick event of imagebuttons is not firing on mozilla firefox, IE it is working. Can anyone help me about. If i share my code then only u can understand the problem. can any one tell how to share the code here.
thnx & Regards
Bhaskar
|
|
|
|
|
You can share the post your in this forum itself.Just put your code in code block.
Copy and paste your code in code bolck.
|
|
|
|
|
Hello Brij,
I am new to the asp.net is thr any option to send the attachment. then i can send the complete solution. plz help me about this.
|
|
|
|
|
There is no need to post the entire solution.Just post the relevant code (aspx mark up and server side code) and explain the code little bit.It'll suffice.Also tell whether you are using Ajax or not?
|
|
|
|
|
I am using ajax.
I have created one control PrinterInfoControl.ascx In this i have create on panel in that panel. i have added a table. in that i have added a imagebutton.
sry brij i am not able to explain because this is a big code. can u tel me ur mail id i will send the code. plzzzzzz
|
|
|
|
|
brij_mishra2003@yahoo.co.in
|
|
|
|
|
Hello Brij
I have a mail to u plz check
|
|
|
|
|
actually in my project i am getting the problem. thats why i created the same and i sent to u. in that application u have to see only PrinterInfoControl.ascx ,PrinterLineControl.ascx,LineDetailsView.aspx
|
|
|
|
|
Hai all
I am using Hierarchical grid , i need to get bands[1] row value. How to get it?
|
|
|
|
|
I Want Picture Box in Asp.net not Image Control
|
|
|
|
|
Can you elaborate your requirement?
Please don't place your question at multiple forums, you have already asked this question in the Quick Answers section.
Regards,
Prakash Kalakoti
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
