Search results for query: *

My understanding is that .NET 3.5 uses the 2.0 core. My question is, if I compile an assembly using C# compiler version 3.5, does it emit a different binary than 2.0 even if we didn’t change any code – only the compiler?

I have an assembly that references two different versions of mscorlib.dll. Is this possible? Which one of them gets loaded and how can I tell. Is anyone here familiar with multi-version under the hood? If so, please share or point me to a good resource.

Hello everyone, I am using reflection to get a list of the assemblies that are referenced in my dlls/exe. My goal is to find out programmatically if I do have references to .NET platform 1.x. The idea is to loop through the list of referenced assemblies with major part of the version equal to...

Hi everyone, I have a deja vu about this. I am sure I solved before. For two days now I can't remember how and can't get it to work. When I try to connect to my local SSMS using a ".", it doesn't work. When I type the server name - my box name - it does. Any one knows why? Thanks all

I need to write a trigger to compare some fields when I insert a record in table to all the other records and see if we have this record before or not. The problem is, more than one record can be inserted at a time. One of my friends told me that the trigger need to be written in such a way to...

I created an aplication role and made it DataReader and DataWriter, when I set the application role using sp_setapprole and I try to select from a table in the database, I get The SELECT permission was denied on the object <table name> <database name> schema 'dbo'. Any thoughts?

I want to create an INSTAED OF trigger on a table to guarantee that only one contact is primary ‘P’ per CompanyID multiple others can be ‘S’ secondary. My problem is not how to write the trigger, it is my confusion about a fact that I learned from nice folks here in this forum which is a...

Is there any command to do this without listing each table?

I have a form Form1 that instantiate an object Obj1 which in charge of doing some lengthy process from within a method called Obj1.method1 What I need is to be able to communicate the progress status from Obj1.method1 to Form1. For that purpose, I wrote a method in the form that updates the...

I created strongly typed dataset by dragging and dropping from my server explorer. The problem is that the connection string that was added to the app stetting section uses the properties of my local database. I know I can edit the connectionString section to whatever I want and leave the name...

Is it possible to issue a query against a data set as opposed to database. For example replace price with price * 1.1 if price is less than $50 for instance. I want to be able to do this as a part of processing the records in the dataset before updating the database. Is there any way to do this...

Hi, The problem is that I have a table contains historical data I have to import in the system. Before doing so, I am cleaning the data up as much as I can to match our standards. One problem is, I have some related records (let’s say the order lines of an order) of which only one records...

Hi All, Is it possible to use SSIS to parse EDI X12 file? If yes please point me to a good resource. If no, it will really help to know that so I can try another direction. Thanks to all of you.

Hey guys, I am going blank on this one. When we insert into a table from a select statment (more than one record) if there is a trigger on that table, would it be fired for each record (one by one) or the whole insert will fire the trigger once?

Hello everyone, My question maybe simple for you, but it puzzles me. How can I get a list of all the customers (along with their Order_Count) who placed orders with us, the question up to here is easy but here is the tricky part. I want to count the orders that only a certain period of time...