Can some one help me to achieve below task
Save/Update/Delete Sql Server data base table using Sharepoint Designer.
View Complete Post
I have a fairly complex SharePoint Designer 2007
Data View they have added two more requirements.
1. Have the columns on the right side be able to scroll left to right as there is a large number of columns, while the first 3 columns on the left side stay locked in place. This is only one list not two, and because of some other requirements
I have it must remain to be just one list.
2. Then they also need to have scrolling up and down of the entire list with the headers locked in place.
The first requirement is more important than the second, but preferrably I need to do both.
I am new to XSL so not familar with the syntax. Is this something I can do on a custom Data View? Does anyone have any examples of how?
I have a drawing that show how it needs to look but I don't see an option here to upload a graphic.
So here is a link to my graphic example uploaded to my blog area: http://lindachapman.blogspot.com/ or just the image here: http://4.bp.blogspot.com/_aB01ue__NvQ/TGL42MOvrGI/AAAAAAAAAA4/c3xP4uCy4BU/s1600/Scrolling.png
I failed to mention that 3/4 of the columns are HTML Calculated fields wh
how to get value this table output is
row 1, cell 1
row 1, cell 2
row 2, cell 1
row 2, cell 2
and save automatically in database no any where click
<table border="1"><tr><td>row 1, cell 1</td><td>row 1, cell 2</td></tr><tr><td>row 2, cell 1</td><td>row 2, cell 2</td></tr></table>
I have created dummy database, Table in SQL Server 2005 with some values.
Iam able to pull data from the SQL database to sharepoint dataview webpart through data connection using sharepoint desigher.
Now i have to enter new record in to SQL table through sharepoint. i have checked with sharepoint designer but unable get it done.
Can some one have idea on this. Please help me to get it done
Thanks in Advance.
When I create a REST data source to access a sharepoint list, I have permission issues because of the Forefront sever in front of my SharePoint 2010 server. I've tested in an environment without the Forefront server and it works as expected.
1. Tested in browser and works fine againsted forefront server (https://myforefrontserver.com/site/sub/_vti_bin/ListData.svc/MyList)
2. Added this to web.config
<proxy autoDetect="true" />
3. Created Rest Data Source in SharePoinbt designer pointing to
https://myforefrontserver.com/site/sub/_vti_bin/ListData.svc/MyList and tried all logon options with no sucess.
Out of ideas
my aspx page works in VWD, and everything works on the server EXCEPT update and delete sql functions. any ideas?
Hi, I am using a IIS 7.5 on Windows 7. I have a simple application that uses System.Net.WebRequest to POST data to another URL (in fact, the server side URL is on my local computer and it is hosted in IIS 7.5).
1. The problem is the server does not save data from client although on the client side codes when I debug and I see the OK message return from the code line
response.StatusDescription; // this has value of "OK"
2. How can I debug the server code side where to receive the request from client side who posts the data ?
The following is the codes for client who posts data using System.Net.WebRequest, and codes for server side who received posted data to save to database.
Client side codes: // also run on my local computer
public string PostIntegrationXml(XmlDocument xmlSubmitDoc)
New spatial data support in SQL Server 2008 opens the door to mapping and querying geometric and geographic data, allowing you to build exciting new applications.
MSDN Magazine February 2009
The knowledge worker is greatly empowered if she is able to access information across the enterprise from a central access point. With the SharePoint Portal Server 2001 Search Service you can catalogue information stored in Exchange public folders, on the Web, in the file system, and even in Lotus Notes databases. This article discusses the use of ActiveX Data Objects and the Web-based Distributed Authoring and Versioning protocol for creating search solutions based on SharePoint Portal Server 2001.
MSDN Magazine April 2002
Handheld device users need to be able to synchronize with a main data store when it's convenient and, preferably, when the back-end database server isn't busy. SQL Server 2000 Windows CE Edition allows you to build a traveling data store that can be displayed and run on a variety of devices. SQL Server CE supports a subset of the full SQL Server package, and can be used as a standalone server or in tandem with SWL Server and IIS. The architecture of SQL Server CE, along with data manipulation, synchronization, and connectivity issues, are discussed in this article. Topics such as making your data public, choosing the right type of replication, and handling errors are also covered.
Paul Yao and David Durant
MSDN Magazine June 2001
i created a dataview for a user table to insert new records. now i have to use a dropdown list that get data from another table. to insert in my user table. in the user table only the code is stored. but i need to get that code description that is in another
table in my dropdownlist to choose from in my dataview.
how can i do this in sharepiont designer2007?