tabdalla's Q&A profile

• Windows Forms Can't hide first column in DataGridView

  I am unable to hide the first column in a DataGridView. I am not referring to the header column but a databound ID column in the grid. As a general rule I put the ID column at the front and hide it so I can always reference the ID column in column [0]. For some reason I am able to hide any other column by setting the visible property to false except for the first column. I was just getting ready to post about the same exact issue.  Mine works the first time I run my search.  Every subsequent time, the first column becomes visible. Hopefully someone can shed some light on this for us. ...Show All

• SQL Server Guids as primary keys

  Is it a good idea to use Guids as primary key. What is the impact on performance. Guids are random by nature that may have an impact on writing clustered index. Any comments or suggestions I'm not a complete expert, but one problem I know of with GUID's with clustering keys is that they are not naturally increasing so this could introduce lots of fragmentation in environments with lots of inserts. They are also wide (16 bytes) so having them in all indexes and foreign keys can be a hit to the size of the database, scan performance, etc. ...Show All

• Visual Studio Inspecting the DataBindings property

  I am trying to discover the properties of the components on a Form using automation, and all goes well until I get to the DataBindings property. It displays as a System.Windows.Forms.ControlBindingCollection. I can get ahold of this object and get its BindingSource, but I cannot figure out how to get ahold of the BindingSource.DataSource. I know it's bound to an object and I can see the correct object in the debugger, but when I call BindingSource.DataSource.getType(), I just get a System.RuntimeType object. So, is there an easier way to introspect the properties of DataBindings, and if not, how can I discover the type of the object boun ...Show All

• Visual Studio Any way to print a rich text content (like htm stored in database)?

  Hi Rajeev, what I am trying to do is put into  a database something like a html page (with no external file like images of course) and render it on a report. This works well with gridview thanks to the property "htmlencode" set to false in the right cell. But when I print the same field in local printing with a rdlc file, no way to render rich text for printer. It's Html encoded. Have you any idea It's so limiting to render only plain text... Thanks a lot Hi Guys, Is a feature like this STILL not available I want to just put a text box control onto my page like I can in Crystal reports, a ...Show All

• Windows Forms Error in OleDBConnection : Object reference not set to an instance of an object

  I am running the following code. It executes when the value of variable i is 1 and when the loop continues and value of i becomes 2 i am getting error "Object reference not set to an instance of an object" in the cmdSearch.CommandText line in the code. . There is no problem with connection string. It successfully retrieves when i =  ...Show All

• Smart Device Development How to overload == in CF?

  public static bool operator ==(MyObj o1, MyObj o2) { return o1.Equal(o2); } the problem with the code is that if o1 is null the code throws "Object reference not set to an instance of an object." exception. Any ideas Thanks, Alex Checking for o1 been null should help out: return null == o1 false : o1.Equal(o2); Alternatively you can call static method on object: return Object. Equals(o1, o2); ...Show All

• SQL Server run packages as part of procedure

  I have created SQL code that is contained in different procedures. I have a procedure that then runs all of the pieces that I wish to run. My last step in my process is to export the data to my c: drive. During this process I created a package to be rerun. How do I include the rerunning of my package automatically as part of the procedural process How about creating a job for the package, and calling sp_start_job from your procedure. Note this will not wait for the package to complete. A less attactive option is to enable xp_cmdshell, and call DTEXEC through xp_cmdshell, which itself can be called fr ...Show All

• .NET Development Event subscription model

  Hi, I've been struggling with the following scenario for a while and have yet to find a good solution for it, so maybe someone give me some hints: I have a component that retrieves financial market data, let's call it FMD. All the data comes in at one method and gets published via the NewData event. I have several subscribers to this NewData event, let's say S1, S2, S3. Every subscriber sends a request to the FMD, telling him to get data for a certain financial instrument. As a result, the NewData event is called when data is coming in and naturally all subscribers receive that event. However, the problem is that the different subscribers ne ...Show All

• SQL Server Access SMO objects in CLR proc

  I would like to write some CLR procs that use SMO objects. In visual studio I am unable to add refrences to the SMO objects. How can I do this Thanks Bert Because CLR was designed to work within the SQL Server engine the references available for a CLR assembly are limited. The assemblies actually run within the SQL Server context, not as operating system processes. What would you want to do using SMO that you can't do using Transact-SQL ...Show All

• SQL Server Determine date Database was last used ?

  Hi There I am trying to establish the date a database was last used. At first i checked out sp_helpfile and sysfiles to see if there was a date last modified, i also tried using xp_cmdshell to check the date on the actual .mdf or .ldf on the o/s but if the file has not grown the date will be the create date. I need to establish the date a database was last used, either the last time someone logged into it or the last time any sort of command was run against the database, i cannot use sysprocesses as there are no connections to the database, so i need to determine the last time there actually were any processes run against this datab ...Show All

• .NET Development NetworkStream.DataAvailable

  Hi guys. I've done a client server application. On the server I'm reading from the NetworkStream using Read method. Before this I'm making a test : if NetworkStream.DataAvailbale then start to read. I've noticed that this test is slowing down the performance. Do you know how can I avoid this Thank you. Mircea Why do you need to do this Just read. If you are worried about the blocking nature of the read, use the async apis. Most people overlook async apis. This is the exact purpose of the Async APIs, so that you don't need to look at the DataAvailable etc and then issue a blocking read. You simply do an asyn ...Show All

• Visual Studio Tools for Office VSTO Outlook Addin - Why doesn't my Property Page show up?

  When I click Tools|Options here's what happens: 1. The following event handler executes: void ThisApplication_OptionsPagesAdd(Outlook.PropertyPages pages) { pages.Add(new ViewPoint.PropertyTab(), ""); } 2. bool m_Dirty = false; OK, class is obviously initializing... 3. Then InitializeComponent(); OK, class is obviously initializing... But then, that's it! No call into the TabCaption method as I would expect, to get the tab caption for the property page. And the tab doesn't appear! I have no idea what I'm doing wrong. I copied this code (see below) straight out of Visual Studio Tools for Office by Eric Carter and Eric Lippert, bu ...Show All

• Visual C# how to set default dataGridView row Height

  I am using a DataGridview while i am setting the height from the code it is not working if (dgviewSearchResults.RowCount != 0) { foreach (DataGridViewRow row in dgviewSearchResults.Rows) { row.Height =5; } } i am using the above code But it is not working for me ItemCreated event not exists in dataGridView Events can u please say More Descriptive. ...Show All

• Visual Studio VSS 6c database lost all checkins and checkouts

  We are using VSS 6c (Build 9238) on a modestly sized Powerbuilder project.  We have PB integrated into the source control database so that we can run source control at the PB object level. All was fine until this morning when we discovered that all of our checkout information, and all of the checked-in files were missing from VSS Explorer and from the PB IDE (Powerbuilder 8.0.1 Build 8004). The VSS database appears as though it has reverted to the day it was created, and lost all of the subsequent changes. We have checked the VSS database files on the filesystem, and the change files that we checked in (*.a and *.b files) ...Show All

• .NET Development Displaying the contents of one record on 2 or more forms

  I have a database with a customer table that has about 60 columns I want to show the customer contact infomation on the primary form, and then show the account info, transaction info and other bits on seperate forms. I have my main form, which shows the customer contact details, but i can't seem to get a dialogform working to show the correct records. I'm trying to set the accountcode data from teh main form as the filter on the subsequent forms but i only ever get a blank result. Does anyone have any suggestions as how to acheive what i want Its very simple. I have a dataset containing a ...Show All