Stack Overflow
Stack Overflow

Questions tagged [extended-properties]

101 questions
112
votes
10 answers

Read/Write 'Extended' file properties (C#)

I'm trying to find out how to read/write to the extended file properties in C# e.g. Comment, Bit Rate, Date Accessed, Category etc that you can see in Windows explorer. Any ideas how to do this? EDIT: I'll mainly be reading/writing to video files…
David Hayes
  • 7,402
  • 14
  • 50
  • 62
94
votes
1 answer

Can you explain the use of sys.sp_addextendedproperty in the following code?

What's going on in the following code after the View is created? Can you give me any thoughts or path to follow? This code is taken from here. /****** Object: View [dbo].[vProductImages] Script Date: 04/28/2008 16:59:05 ******/ SET ANSI_NULLS…
stacker
  • 14,641
  • 17
  • 46
  • 74
40
votes
9 answers

Check if extended property description already exists before adding

So, I have a script that adds extended properties, some describing a table, some describing a column. How can I check if the extended property exists before adding it so that the script does not throw an error?
ScubaSteve
  • 7,724
  • 8
  • 52
  • 65
19
votes
2 answers

How to add custom attributes to SQL connection string?

I want to add some custom attributes in SqlServer connection string, something like this: Integrated Security=SSPI;Extended Properties="SomeAttr=SomeValue";Persist Security Info=False;Initial Catalog=DB;Data Source=SERVER And then get that…
Hossein POURAKBAR
  • 1,073
  • 2
  • 15
  • 33
9
votes
1 answer

How to get extended MacOS attributes of a file using python?

I'm interested in getting more information from a file using python. I know that using os.stat (such as below) returns information on the file, but I'd like to get other attributes from the file such as 'Where…
Chris
  • 5,444
  • 16
  • 63
  • 119
8
votes
2 answers

Where are extended properties stored in SQL Server?

Where are extended properties stored in SQL Server? Are they stored in the database containing the object it was added to, or are they stored separately and bound to the local machine somehow. For example, if I add populate the "Description" field…
Triynko
  • 18,766
  • 21
  • 107
  • 173
7
votes
1 answer

How to update Extended Properties of a Column?

The questions really says it all, Is it possible to update an extended property of a column in a table. I have been looking around online but they only seem to show updating the extended property for a table and not the columns in a table.
Ben
  • 245
  • 4
  • 13
6
votes
4 answers

Slow search for items using extended property on Exchange

Problem at hand Our C# Windows application uses EWS Managed API 2.0 to create appointments in a user's calendar. Each appointment has an extended property with a unique value. It later locates an appointment using FindItems and an ItemView. Users…
bernhof
  • 6,219
  • 2
  • 45
  • 71
5
votes
1 answer

How can I use ExtendedProperties on a DataRow

A C# DataTable has a PropertyCollection ExtendedProperties. A DataColumn in that table also has an ExtendedProperties Why would DataRow not have this? So, for example, If I have multiple tables and want to add some metadata to be used in the view,…
David Starkey
  • 1,840
  • 3
  • 32
  • 48
5
votes
2 answers

Read a comment of the file

Some files has Summary tab in their Properties, This tab include information like Title, Author, Comments. Is there any way in C# to read the Comments of the file. I have to read only comments from image files like jpg.
PsCraft
  • 620
  • 1
  • 8
  • 18
4
votes
2 answers

How do I set Outlook extended properties on an email in C#?

I have currently written code to send an email in C# using the usual SMTPClient and MailMessage objects. My new requirement is that the email being sent should have "permissions" set as if the user was sending the email via Outloook and using the…
Brian Scott
  • 9,221
  • 6
  • 47
  • 68
4
votes
2 answers

Select Extended Property from SQL Server tables

I am writing a simple CMS for a client's database. There are 12 tables and they need to manage all of the data in 4 of them. I set up a dynamic data project (Linq-to-SQL as that's what I'm most familiar with) and the first page makes all 12 tables…
nycdan
  • 2,819
  • 2
  • 21
  • 33
4
votes
1 answer

Extended Properties not in Visual Studio DB Projects?

Maybe it's me, hopefully I am missing something. I added some Extended Properties to tables and columns in my MSSQL 2008 database. In Visual Studio 2010 I created a new database project, ran a "schema comparison" to load the DB into my project, and…
Snowy
  • 5,942
  • 19
  • 65
  • 119
4
votes
3 answers

EWS - Determine if an e-mail is a reply or has been forwarded

I am using the Exchange Web Services Managed API 2.2 to monitor users inboxes and need to determine if an e-mail is a new item, a reply or a forwarded message. I have seen various articles on SO such as how to notice if a mail is a forwarded mail?…
Newm
  • 1,313
  • 3
  • 16
  • 29
4
votes
1 answer

Why CalendarProvider doesn't allow writing ExtendedProperties?

Google calendar events have extended properties that can be used to attach name/value pairs to an event. We are implementing a collaborative calendar application that uses those extended properties to attach extra information to the event. As…
ivacf
  • 1,163
  • 3
  • 11
  • 15
1
2 3 4 5 6 7