Zechariah's Q&A profile

• .NET Development static constructor

  Dear All, I am first to C# .net. I heared about static constructor. I want to know more about these. Can you explain this to me. It is a sample code I modified. Please use this code to explain the static constructor. public class Bus { static int AAA; static int BBB; static int CCC; static Bus() { System.Console.WriteLine("The static constructor invoked."); AAA=AAA+1; } public static void Drive() { System.Console.WriteLine("The Drive method invoked."); BBB=BBB+1; } public static void Start() { System.Console.WriteLine("The start method invoked."); CCC=CCC+1; } public void Stop() { System.Console.WriteLine("The Stop method invoked."); } ...Show All

• SQL Server create index

  I need to check if an index available on table T1 and field F1. If not, create a non-clustered on F1. How can I do this in a stored procedure SELECT C . [Name] AS [IndexedColumns] FROM sys.indexes I INNER JOIN sys.index_columns IC ON ( I . index_id = IC . index_ID ) INNER JOIN sys.columns C ON ( IC . column_ID = C . column_ID ) WHERE OBJECT_NAME ( I . OBJECT_ID ) = 'StoreContact' ...Show All

• Windows Forms How to create an instance of System.Windows.Forms.AxHost.State ?

  I am writing an user control, it would add the ActiveX control by checking the installed version of Office Web Component SpreadSheet (currently there are OWC11, OWC10, OWC components). After checked the installed version of OWC, I create the instance of the axXXX library which generated by vs.net 2003 & add this instance to UserControl.Controls. If I do nothing more then it would be OK, but I wish to set the CSVData property of the instance after the constructor of the UserControl finished. I got an error said that OcxState of the OWC instance is valid. I noticed when I drag & drop the OWC control into the UserControl, the designer would generate the code such as : owc.OcxState = ((System.Windows.Forms.AxHost.State)(res ...Show All

• Windows Forms Typed dataset is not seen

  Hi all, I have deleted some columns from the table of the typed dataset. After that, I had an error that this dataset is not defined. This dataset is still in the project but I cannot see it from intelisense list of types. That is I cannot see it in the drop down list when I type this line Dim dsMyDataset as Please. help. I have no idea how to make this typed dataset to get back in the list Hi, The problem was resolved. The reason of this problem was that dataset was not compiled and dataset wrapper (vb - file) was not created. There might be a lot of possible compillation erros. None of them is shown during compillation, unfortunately. My error was incorrect setting of relation between two tables. To be ho ...Show All

• SQL Server Cannot Load SQLSpars.dll

  Hello, I have had numerous problems installing SQL Server 2005 on various machine. Most of those problems are related to insufficient rights to various users. But I am baffled by this one: Setup Failed: Could not load SQLSpars.dll Why would this happen I see this message after beginning the SQL Server 2005 Standard setup and making my installation selections and beginning the install. The process stops after about 30 seconds, and displays the above message. My machine is running Windows XP SP2. Any ideas Thank you, Jon500 There are at least 4 log-related files in the Files folder. This is from my file called: SQLSetup0008_DSLPTP05_Core(Local).log I copied and pasted the top of the file to the point at which it l ...Show All

• SQL Server Insert or Update SSIS for Composite Primary Key

  Hi , We have scenario like this .the source table have composite primary key columns c1,c2,c3,c4.c5,c6 .when we move the records to destination .we have to check columns (c1+ c2 + c3 + c4 + c5 + c6) combination exist in the destination. if the combination exist then we should do a update else we need to do a Insert . how to achive this .we have tryed useing conditional split which is working only for a single Primary key . can any one help us . Jegan.T Linkies, As dit jy is, stuur vir my jou foon nommer dat ons weer n slag kan chat. My e-mail address is jolivier@pizzadelight.ca Jakes ...Show All

• Windows Forms Blinking DataGridView

  Good afternoon, I've created a DataGridView dataGridViewHosts on a new form in design mode and create columns for my Host class properties. Then, I've specified as DataSource a table Host[] containing instances of my class Host. dataGridViewHosts.DataSource = EtcHosts.ListeHosts; The datas are correctly displayed but when I click in a cell or move the form, whether the desktop icons or the DataGridView cells text is blinking. Auto-generated InitializeComponent() : private void InitializeComponent () { this .dataGridViewHosts = new System.Windows.Forms. DataGridView (); this .isCommented = new System.Windows.Forms. DataGridViewCheckBoxColumn (); this .IP = new System.Windows.Forms. DataGridViewT ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Effect file parameters

  Hi, I am unable to understand shaders so I use FX Composer. I created (loaded) an effect to one of my meshes and saved its code. When I try to apply it, I can't see anything. I don't know what parameters should I set so I ask for help. How can I make this reflection effect work Here is the XNA code: foreach (ModelMesh spheremesh in sphere.Meshes)             {                 foreach (ModelMeshPart modmeshpart in spheremesh.MeshParts)                 {               &n ...Show All

• Windows Forms Setup file creattion using c# and outlook Add-in

  I have created two projects, i developed one project using c#,and another one i created in outlook Add-in using VSTO. Now i created the setup files for c# project and the outlook adding individually. But i want to create only one setup file. it should include both means the c# setup and the outlook setup file. how to create hi Thank u very much for u timing help. my setup file is working fine. i had put outlook express setup file into my c# project setup file. First i created my outlook express setup then i had include my project setup file. ...Show All

• SQL Server Variable Length Procedure Arguments

  Is there any way to have variable length arguments for stored procedures - kinda like how there is in C/C++ For example, if I wanted to send 2 arguments at one time, and then at another time send 7 to the same procedure, is that possible THERE IS NO ARRAY DATATYPE IN TSQL....BUT U CAN MAKE USE OF TEMP TABLE..OR TABLE DATATYPE...u can insert the params into either of these and then use them is SP...probably use a runner SP to call this SP.... ...Show All

• .NET Development Send data to Between pcs

  Hi, sorry if this is the wrong forum but I'm not too sure where to start with this one. I have been tasked with finding a way to send data to and from pcs on a network based upon IP address. In a nutshell, PC1 will recieve data on its com port. Depending upon the deviceID of the scanner which sent the data to the comport I need to then re-send the data to a different PC on the Network, each PC on the Network needs to listen for a communication from PC1. If data is recieved an app on the recieving PC will process the data and send a response back to PC1. I have no idea where to start here and any guidance would be greatly appreciated Kev ...Show All

• SQL Server report manager

  i have a sql server 2005 standard box with a \Dev engine and a \Tst engine on it for dev, i cannnot see the site settings from within Report Manager for tst, i cannnot see the new folder, new data source, upload file, site settings from within Report Manager my windows domain account is in the Local Admin for that box. what's the issues here I found the solution here: http://msdn2.microsoft.com/en-us/library/bb283249.aspx ...Show All

• Software Development for Windows Vista Getting text out of DrawingVisual?

  I'm playing with Feng Yaun's watermarking sample at http://blogs.msdn.com/fyuan/archive/2006/08/23/715938.aspx It basically creates a DrawingVisual and adds it to a page's children collection. Later on, I can enumerate the page's collection and get back my DrawingVisual. What I can't figure out now is how to get the actual text that I drew into it. From the DrawingVisual, I can get the DrawingGroup and DrawingChildren collection, but none of these have anything that remotely looks like text. Maybe I'm misinterpreting what the original DrawText into the DrawingContext does, and it's really just storing a bitmap (meaning, later changing the watermark would be a little tricky). So the obvious first question is: is there a way for me ...Show All

• Windows Forms Changes in database and update datagridview problem

  hi, i have a WinForm datagridview (dgvUser) that is populated with data from a SQLEXPRESS db. On the same form I collect user input using textboxes and after user clicked on OK button, those information will be saved to the database. At this point, everything is perfect. At the same time, I want the dgvUser to update itself with the new info. I have read others' posts regarding this issue and tried some suggestions from posters. From what i see, the datagridview was refreshed but the data wasn't updated. Anyone with solutions or suggestion please help. Million thanks. Regards, Sha private void dgvUserUpdate() { this.tblUserBindingSource.EndEdit(); dgvUser.DataSource = dmsDataSet1.tblUs ...Show All

• Windows Live Developer Forums Messenger Plug Inn Question

  Hi I wrote a plug in for messenger, it is very simple. It is compile ok, and i install in Messenger. All seems to be ok but it doesn't work. What's wrong I use strong name assemblie Thanks Here is the code: using System; using System.Collections.Generic; using System.Text; using Microsoft.Messenger; namespace AnswerMachine { public class AnswerMachineAddIn : IMessengerAddIn { public MessengerClient m_client; public void Initialize( MessengerClient client) { m_client = client; m_client.AddInProperties.FriendlyName = "Answer Machine" ; m_client.AddInProperties.PersonalStatusMessage = "Envia un mensaje" ; m_client.AddInProperties. ...Show All