If I use the Membership, it is advisable for new tables I add column ID primarykey autoinc? Since I use a different ApplicationName, it is necessary to also add column ApplicationId of each table?
View 1 Replies
I'm having a gridview in my aspx page with checkbox, User can select one or more than one record(s) at a time and clicks on delete button, Then i'm constructing an object of my DTO and adding all the checked row's Primary Key (DataKeyNames - GUID's in case) to a serializable class and generating an XML and sending it as parameter to the Stored Procedure.
My Doubt is, can i bulk delete all the rows from database table those are present in my XML document??
If it works, I can do bulk update with XML only, i already did bulk insertion by generating an XML..
My Another Question is, Will it affect the performance? Each time when i construct an DTO object and adding it to the Generic List??
WHich one is better, I mean ObjectDataSource or SQLDataSource or my XML method?
My XML will be like this
<root>
<Customer>
<CustomerID>GUID1</CustomerID>
<CustomerID>GUID2</CustomerID>
<CustomerID>GUID3</CustomerID>.....
How do I set that autoinc ID?
Example:I have a base Table1.In my column this database:
- ID - How to set autoinc that many will never be repeated?
- Firstname
- Address ...
I've read somewhere that ApplicationID is a unique id for a website (iis site path). But I'm still confused. When and why do I need this? I'm trying to implement asp.net membership for a website and I'll create some additional SQL tables (such as Companies, Services, etc) other than asp.net membership tables. So; do I need to include an ApplicationID column to these custom tables? Why?
View 1 RepliesI'm using asp.net 2.0, vwd, sqlServer 2005, c#
After much researching I'm still @ a loss of how to do this.
I've looked @ scope_identity & @@identity but haven't been able to get it going...but I don't know if this is the command I should be using
I CAN: (from webform) insert data to Table2, ColumnA & ColumnB via stored procedure to db
I WANT TO:Insert the primary key of *Table1 to Table2 ColumnC so that it becomes the foreign key of Table2
*Table1 has data already displayed on the webform (used select command) & have class that contains the @ID_PK as Parameter
I thought this would be easy before I started, but I should've known better.
I just need to get the value of primarykey from the newly inserted record so I can pass it in the query string to the next page the user will be directed to.
Here's my code:
Markup:
[Code]....
VB Code-Behind:
[Code]....
I had found what looked like a good soultion yesterday by the moderator "ecbruck" at this post:
[URL], but after spending many hours trying to figure out why I couldn't get it translated and working in my own project, I found that MS Access does not allow use of an Output Paramter. And unfortunately I don't have time to teach myself a new database platfrom and am stuck with MS Access for the moment...teaching myself asp.net has my head spining enough as it is.
I am using SQL SERVER 2008 database. I have a table Customers in which the CustomerID column is had datatype INT intially but due to increase in Customers the number range is exceeding which may cause error arithmetic overflow of data. Hence I thought to modify the datatype from INT to BIGINT and wrote an alter script but when I ran the script it failed. Hence provide me in creating alter script for the updating the datatype of the primarykey column for the Customers table.
View 2 Replieshow to pick a specific field (besides Primarykey field ) through HQL query ???
View 5 RepliesHow to insert data from local SQL server to remote SQL server (without using linked server) like below?
insert * into [remote server].[northwind].orders
from [local server].[northwind].orders
I have a site that is running on a Windows Server 2008 machine with IIS 7.0, when I try to open it with Visual Web Developer 2010, it says the following:
error: unable to open site: ... The Web server does not appear to have FrontPage Server Extensions installed.
Looking on the server Frontpage Extensions 2002 are installed, so what could be wrong?
The thing is, I used to be able to open the project and work on it, etc...
Open Website -> Remote Site -> Enter remote site name -> tries to open & error above!
I have to programmatically import a table from a database "A" in Sql Server 2000 to a database "B" in another server 2005.
View 1 RepliesThis issues has been driving me nuts. I am trying to follow the tutorial on [URL] I am trying to connect to a database in Microsoft SQL Server 2008. The way I do this is by right clicking on the "Data Connections" > Add Connection. Afterwards the Add Connection window comes up, I make sure my data source is "Microsoft SQL Server (SqlClient). And, I choose a server name; the only server I can choose is DomainSQLEXPRESS. The issue is when I go down to the "Select or enter a database name" drop down box, I do not see my database listed. I have also made sure in the SQL Server Management Studio that I have given my user all the privileges for the database. I know my explanation is kind of vague, but would anyone know the reason why I would not see my database?
View 3 RepliesI have SQL Server 2005 in my computer.I am using SQL Server 2005 for Development.
I can connect to my local & "COMPAQSQLEXPRESS" Server.
But while connecting to Remote Server i m getting the following error
TITLE: Connect to Server
------------------------------
Cannot connect to x.x.xxx.xx.
------------------------------
ADDITIONAL INFORMATION:
This version of Microsoft SQL Server Management Studio can only be used to connect to SQL Server 2000 and SQL Server 2005 servers. (ConnectionDlg)
------------------------------
BUTTONS:OK
-----------------------------
This is probably an easy one, but can I use SQL Server Management Studio Express to work on a regular SQL Server database?
View 2 RepliesI want to convert sql server 2000 database into sql server 2005 database. I am using sql server 2005 express.
I am trying by taking backup/Restore method, but it not work.
I want to replicate data from branch server to main server using SSIS with scheduling .. Every daily at 12 AM. I can have more than 5 branch servers, I need to transfer datas from these server to my main server. how can i do with SSIS and Error handler in SSIS , While replicating if some error happens , it need to save log file or send mail to me Like this i need to do.. and also i need to scedule the created SSIS pac
View 1 Repliesaccording to what i read from web there 3 types of custom server controls
1. composite
2.superclass
3.rendered
i found video tutorial to create and use superclass custom control in your project (extending dropdown control functionality)
i am trying to search video tutorial for other 2 types .
the difference between SQL Server 2000 and SQL Server 2005 features.
View 3 Repliesthe main difference between sql server 2005 and 2008 in interview point of view?
View 2 RepliesI am trying to connect my sql server 2000 using the sql server utility. It is perfecly working fine on my system but when try it on some other system i am getting an error message as "Could not find the server".
Is there any other configuration change that i need to make? I am connecting using TCP/IP
I want to transfer the data from one server to another by sql query. I want query. I dont know how to write?
View 2 RepliesHOWTO create ASP.NET C# controls on server side for posted data that had no runat=server on the client.
I have processes needing to post files to a ASP.NET application. These processes must post without runat=server as such:
<form ~~~~ to some ASP.NET/C#/aspx page>
<input type=file name=MY_FILE ~~~>
</form>
On the ASP.NET page, in the Page_Load I would code somethign like this:
[URL]
Here is the trick, the control "fileLIST_FILE" does not exist because the HTML does not have runat=server on it.
If the client did have runat=server the designer.cs would have somethign liek this:
System.Web.UI.HtmlControls.HtmlInputFile fileLIST_FILE;
With all that said, I want to make "fileLIST_FILE" on the fly inside Page_Load fromt he posted name of "MY_FILE".
do not focus on the fact that this is a file upload. I would like to know how to do this for any posted FORM data.
I used SQL SERVER 2008 R2 express as my web development database and I set its compatibility level to 2005. Unfortunately this database cannot be be attached to SQL server 2005. Are there any other options?
View 3 RepliesI want to Access remote server( ie., want to access online server not local server) in my Application.. I change Settings in SQL surface Area Configuration---> Remote Connection ( checked the Local and Remote Connection ) Then while running the application it showing the following error.(I make off the firewall also) An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
View 1 RepliesI just installed sql server 2008 R2 on my computer. I am trying to connect to sql server throught my C# code and everytime I run the C# program,
I get this error "A network-related or instance-specific error occurred while establishing a connection to SQL Server.
The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) "
The connection string that I used in my web.config file is
[Code]....
I am not sure what am I doing wrong, but I followed this article below step by step and still I am getting the same error
http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/
My instance name is MSSQLSERVER and the server that I am using is on my local machine and it has my computer name in it.
