View Complete Post
I'm using the following code to upload images, pdf files, word files and excel to a sql table as binary data. However, I can only figure out how to display the images but am clueless about the other type of files. What adjustments do I need to make so that with a button click I can access the other files? 't By the way, I'm using an image control to display the binary data and I'm aware that that will only work to display images, I just don't how to access all the other types of files once uploaded. Thanks
Partial Class Uploads_UReceipts
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Request.QueryString("ImageID") IsNot Nothing Then
Dim strQuery As String = "select Name, ContentType, Data from tblFiles where id=@id"
Dim cmd As SqlCommand = New SqlCommand(strQuery)
I have a table with 100 records. I need to import extra 50 records in the same table. So from 101 to 150 records should insert the data which is present in excel Simply I want to import 50 records from Excel to Table without disturbing the first 100 records.
Please suggest me
Ok, I am using Sharepoint 2010 and Designer as well as Infopath 2010. I have a requirement to send out a word document (via workflow) that will be a template that references fields from my Sharepoint List.
Any help is appreciated, I do not want to buy anything extra and a no-code solution would be best.
I have seveal spread sheets loaded on MOSS 2007 (we have Excel Services). We host our SP on Sql Server 2008 R2 64 Bit on a Windows 2008 64bit server. I want to be able to write a query on that SQL Server database that can somehow access excel
data directly from SP and cmpare that to data in SQL. I have been able to create a linked server (using 32 bit sql server) but have only been able to link files directly off the server and NOT from MOSS.
So the Crux of the matter: Is there a way of making some love connection that would allow me to get data directly from my excel spreadsheet that resides ON SHAREPOINT, via my Sql Server?