shareeef's Q&A profile

• SQL Server Why CodeBase property of CurrentAssembly in CLR SP is empty string?

  Where is SQL storing and caching the assemblies used by CLR SP I want to read a mapped configuration file for that assembly but it seems that assemblies are not read form their initial location. Is there a way to use configuration files for the assemblies used by CLR SPs (I don't want to use a static string to point to a file on the disk) In the SQLCLR, assemblies are either loaded from inside the database - if they are user assemblies - or from the GAC if they are System assemblies on the "blessed" list. To see where the user assemblies are loaded from look in the content column in the sys.assembly_files view. Niels ...Show All

• Visual Studio 2008 (Pre-release) Linq to Entities and Linq to SQL

  I've just about finished reading the ADO.NET Entity Framework Overview document and have been playing with Linq, Xlinq, Dlinq (apologies for no political correctness in what these are all called now). One thing i don't quite get is why the distinction between ADO.Net entities (Linq to Entities) and Linq to SQL - other than for historical reasons. Now i think i grasp the intentions and purposes of both (disclaimer : i haven't read all the docs about dLinq quite yet!), but why they are defined as being different is a little confusing for me. Would Linq to SQL not be regarded as conceptual "Linq to Entity" - that is ADO.Net entity over a single table In other words, although they operate on a slightly different basis, should I ...Show All

• Internet Explorer Development How to catch certain browsing events

  Hi everyone, i'm currently developing a BHO with ATL as i'm in need to write an application that would record the interaction between a user and the browser while surfing the internet. With my BHO i'm able to get notification of the events thanks to the DIID_DWebBrowserEvents2 interface. This way i can record when new windows are opened, a page is navigated to, a print template is istantiated and so on. But this just takes care of half of the events i'd like to catch. What i'd like to record too is when a user presses the back, forward and refresh button, saves a page or the content of a link, adds a bookmark, and similar. I can't get notifications of those events from the DWebBrowserEvents2 interface. How could i manage in getting this in ...Show All

• Visual Studio 2008 (Pre-release) ComboBox Binding

  I bound ComboBox to products' collecttion and ComboBoxItem to product name. But when I select an item I get in Selection box the name of object, not a product name. How can I manage this problem protected Products list; public Window1() {InitializeComponent(); this.list = Fill(); MyComboBox.DataContext = list;}   < ComboBox Margin = " 8 " Width = " 120 " Name = "MyComboBox " ItemsSource = " {Binding} "/ > <!-- SimpleStyles: ComboBox --> < Style x:Key = " {x:Type ComboBox} " TargetType = " {x:Type ComboBox} " > < Setter Property = " OverridesDefaultStyle " Value = " true " /> < Setter Property = " ScrollViewer.CanContentScroll " Value ...Show All

• Windows Forms Creating Flat Tabs

  Hey there, I'm working on an app that has one tabControl component, and which has a bunch of tabs associated with it. I noticed that in the properties for buttons you have the option to control FlatAppearance. However for the tabControl, there is no option to display the tabs flat (like that you see in Excel and Visual Studio). Its a nice look imho, and I'd like to implement it into my app. I was poking around the MSDN library to come up with something that could control the look of the tabs I found the VisualStyleRenderer.DrawEdge Method public Rectangle DrawEdge ( IDeviceContext dc , Rectangle bounds , Edges edges , EdgeStyle style , EdgeEffects effects ) Does anyone have any experience with this metho ...Show All

• SQL Server Upsizing from Access Problems

  We are moving from Access 2003 to a hosted SQL Server (2005). In the process of uploading the data, we overloaded the log files, to the point we can't do anything additional. Questions: 1) is there a way to turn off the log file when uploading the info and then turn it back on once all data is in place 2) is there a way to delete the existing log file From my research, it looks like command for Vers 7 was "BACKUP LOG <dbname> WITH NO_LOG". But I can't find reference to this in the on-line books. Can someone bail us out Thanks Paul P Hi Paul, You can't turn off logging when you're uploading the data and the BACKUP functionality doesn't really apply here. Could you tell ...Show All

• Windows Forms OwnerDraw TextBox

  I'm having a little problem here, with TextBox. As far as i understood, is pretty hard to create custom textbox, derived from textbox control, so, i need textbox, with little less borders, and with custom colors, anyway, how to make it, that my Custom TextBox have one border(Top) with custom color Any ideas Hi Vitalijus, if you want to make your own custom controls with your own look and feel then you can override the OnPaint and OnPaintBackground methods in your class which derive from TextBox. The background paint method can be used to paint borders and background colours and the paint method can be used to draw the text in the textbox. This site gives some good tips and tricks regarding GDI+ ...Show All

• Visual C# Using OleDbConnection to populate DataGridView

  I'm a bit new to this, so pardon my ignorance if this is well-known. I've been searching the net, but no luck yet. I have an established OleDbConnection that I want to use to populate a DataGridView. I can run SQL queries on the connection and see data sets, but I would like to present a view of that data in my grid. Also, I'd like to be able to only show a fouple of the columsn, but hold on to the full data set for later use. Any pointers would be appreciated... Thanks. So, here is my grid init code.  The grid seems to display fine:             // make the connection to the database             _db = new OleDbConnection ...Show All

• Visual Studio Report Viewer not Refreshed

  Hi I am working with Using the ASP.NET 2.0 ReportViewer in Local Mode. On my page i have a dropdown which is populated with "rdlc" names.The issues is that when ever i select some other report from the dropdown the new data is not updated in report viewer, to over come this i even start creating report viewer object in my code and then add it in the page but still the old report contents are shown but if i click on the refresh icon of the reportviewer then the content got updated. i am also using the reportviewer.LocalReport.Refresh() in my code. here is my code: ReportDataSource s = new ReportDataSource(resourceName, _dataTable); ReportViewer objViewer = new ReportViewer(); objViewer.ID = this.ddlReport.Se ...Show All

• Visual Studio Express Editions Need help with wildcards in query

  I've been using Microsoft Visual Basic 2005 Express Edition: Build a Program Now! ( by Patrice Pelland) to try to learn VB, but I am having a problem with the Car Tracker example in Chapter 8 (databases). Set up the following query using 'Query Builder': SELECT Listing.ListingID, Listing.ColorID, Listing.MakeID, Listing.CarTypeID, Listing.DateSeen, Listing.Year, Listing.Price, Listing.Cylinder, Listing.HP, Listing.URL, Listing.EPGCity, Listing.EPGHighway, Listing.Notes FROM Listing INNER JOIN Color ON Listing.ColorID = Color.ColorID WHERE (Color.ColorName LIKE '%' + @colorname + '%') Tested it out (from within the Query building wizard) and it does return values as expected ('b' returns both 'Dark Blu ...Show All

• Smart Device Development How can i get the phone number?

  Is there any API in .NET Compact Framework 2.0 to get the local cell phone's phone number Many thanks, No, there’s no such API in NETCF V2. This should help: http://groups.google.com/group/microsoft.public.dotnet.framework.compactframework/search hl=en&group=microsoft.public.dotnet.framework.compactframework&q=get+phone+number&qt_g=1&searchnow=Search+this+group ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Errors in Linking Direct x9 SDK .h &.lib

  Good Day I want to ask this question that many forums cann't answer it... I installed the Direct x 9 SDK ,and I use Visual Studio.net 2005 ..When I run any Tutorial(Like Tutorial 2: Vertices ) the following Errors occurs : ------------------------------------------------- Error 1 error LNK2019: unresolved external symbol _Direct3DCreate9@4 referenced in function "long __cdecl InitD3D(struct HWND__ *)" ( InitD3D@@YAJPAUHWND__@@@Z ) Vertices2.obj Error 2 fatal error LNK1120: 1 unresolved externals Debug/Vertices2.exe ----------------------------------------------------------------- and the out put is: ----------------------------------------------------------------- 1>------ Build started: Project: Ve ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Humorous but somewhat serious question about XNA

  Microsoft has claimed the Nintendo Wii as a "kids toy;" however, if XNA can produce graphics and push performance up to what the Wii is capable of handling (games like Half-Life, Sims 2 from most XNA performance claims), does that mean that XNA is a kids toy too What exactly constitutes "commercial development" Wii games are commercial after all, right Are we talking Project Gotham 4 and Half Life 3 What exactly are you looking to do with XNA ...Show All

• Software Development for Windows Vista com +

  I am looking at COM+ these days to deploy an application that will be accessed from multiple clients As the number of clients grow, I want us to be able to have more server machines share the load of clients, but with transparency to the clients. This means the clients should still be using one server (primary server machine), but if the load is more this promary server should share its load with one or more server machines Is this something that is seamlessly possible in COM+ Can you point me to a related site that explains this Please see http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1112987&SiteID=1 HTH, Florin ...Show All

• SQL Server Web Synchronization

  Hello guys! I went through the bunch of documentation pages about configuring the one for providing web subscriptions. The most usefull for me were: Security Architecture for Web Synchronization How to: Configure an IIS Server for Web Synchronization (SQL Management Studio) How to: Configure a Subscription to Use Web Synchronization Topologies for Web Synchronization Securing the Publisher Subscribing to Publications Mssubscription_properties (Transact-SQL) How to: Configure a Subscription to Use Web Synchronization (Replication Transact-SQL) sp_addmergepullsubscription (Transact-SQL) Web Synchronization for Merge Replication   But I still have questions about it. If ...Show All