SQL Server :: How To Get The Personalizable Datablob
Aug 11, 2010How do I get the current page's personalizable dataBlob for saving?
I cant seem to find the SqlPersonalizationProvider class code online.
How do I get the current page's personalizable dataBlob for saving?
I cant seem to find the SqlPersonalizationProvider class code online.
I am developing a dynamic site that utilizes webparts, it uses jquery's sortable to perform the drag and drop functionality. Now I am attempting to write a callback that saves the page state when the user drags and drops a webpart from a zone to another. As you can see from the code below, I am attempting to manually call a function which updates the database of the page state.
However I dont know how to get the datablob for the current page, how can I get this object for saving?Is retrieval of the datablob possible via a callback?Is there another/better way to acomplish this? //In my custom class 'CustomWebPartManager' I have the following code
protected override void OnPreRender(EventArgs e)
{
string cbReference = Page.ClientScript.GetCallbackEventReference(this, "arg", "GetDateFromServer", "context");[code]....
What is the difference between the attributes WebBrowsable and Personalizable in a Sharepoint 2010 web part?
e.g.[Personalizable(), WebBrowsable]
public string IconURL { get; set; }
vs
[WebBrowsable]
public string IconURL { get; set; }
MSDN gives the impression that personalizable is per user, whereas webbrowseable is for all users - however it doesn't explicitly mention this and I would like to get this sorted in my head.E.g. can I set a user specific property on personalizable and web-part wide on webbrowsable?
I have a web user control that contains 2 text boxes. i would like to be able to have their values persisted using the personalizable attribute, but dont want to use my user control as a web part. Can i implement the personalizable attribute on a text box in a user control without using web parts?
View 3 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.
I have created a simple website, Iam connecting to a database the is not located in local-newtwork. Connection from development machine works fine, The problem occurs when I publish the website on my server, than it can not connect to the server, Iam pinging the server I no packets are lost, I don't why it can not connect to the database server?
View 4 RepliesThere are more than 30 tables in my database.
I need to have a server log that will help to determine the number of items entered into the db and where those items are entered, without having query each table. It should be able to give me the average monthly volume of items input in SQL.
Can this be done using Sql Triggers or any other alternative?
I have to make sure that if I use trigger as the alternative I should have only one table to be updated with all the details of the Updates/Inserts being inserted into the Trigger table after the insertion into the original table.
Below given are some of the create table statements that I have for which I need to have a server log of the updates & inserts.
[Code]....
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 package..
View 1 RepliesHow to create to the package SSIS from one server to anther server using SQL SSIS
View 2 Replies