Gurpreet_Sodhi_69db48's Q&A profile

• SQL Server Timeout expired on Index Creation

  I am trying to change the index' on a table I have to create a Clusterd index. When I apply the changes I want I get a message 'SiteData' table - Unable to create index 'IX_SiteControlData'. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The table has around 6M records How do I change the timeout period and what is the default so I can set it back Thanks in advance for the help Thanks, that helps.  But it leads to another question.  If there is no timeout....why am I getting a timeout error when I try to change my index the actual nessage is: 'SiteControlData' table - Unable to create index 'IX_SiteControlData_SiteID_Calc_Date_Calc_Time'.& ...Show All

• Visual Studio 2008 (Pre-release) Displaying popup listview/gridview within a Listview/gridview?

  Hai guys, I have created a listview with gridview. Whenever an item from the listview selected or clicked, a popup listview is to be shown with some more details of the item currently selected. How to achieve this functionality in WPF Is it possible to get it Thanks, cssjm you can create a popup in XAML and add controls to it. for ex: < Popup Name = " popup1 " Width = " 300 " Height = " 300 " Placement = " Center " PlacementTarget = " {Binding ElementName=win2} " > < StackPanel Background = " Beige " > < TextBlock Text = " {Binding Path=FirstName} " ></ TextBlock > < TextBlock Text = " {Bin ...Show All

• Visual C# Mysql with c#

  Hi.. friends. I'M with a problem in my variable. See this code. public static void Insert_SQL( string nick, string email, string nome, string datanasc, string ruaenumero, string bairro, string cidade, string cep, string pais, string sexo, string estado, string home_page) { string table = "clientes"; MySqlCommand com = new MySqlCommand(); try { com.Connection = Conexao_mysql(); com.CommandText = "INSERT INTO " + table + " (nick,email,nome,datanasc,ruaenumero,bairro,cidade,cep,pais,sexo,estado,home_page) VALUES ('nick', 'email', 'nome', 'datanasc', 'ruaenumero', 'bairro', 'cidade', 'cep', 'pais', 'sexo', 'estado', 'home_page')"; com.E ...Show All

• Visual FoxPro VBA to VFP code conversion

  Can anyone help with converting the following from VBA code generated in Excel to VFP code: Sheets("Notes").Copy Before:=Workbooks("AB0KF3FK.XLS").Sheets(1) Thank you Well, Worksheet has a Copy method, so I'm not sure what the problem is. Try saving a reference to the before worksheet and using that reference in the call: oBefore = loWBTo.Sheets(1) loWBFrom.Sheets("Notes").Copy(oBefore) You might also try working with this from the Command Window to help you see exactly what's going on. Tamar ...Show All

• Windows Forms l.com How can I change the Font.Bold in Treeview Control

  Hi I have a Treeview Control that I load all root Nodes and its Child, but now I want the Root Node Font to be Bold and the Child to be Normal, How can I do this Your Help will be highly appreciated. MisaSimic wrote: Hi Sibusiso, Before you Added Root Node you have to setup the font for it. TreeNode rootNode = new TreeNode(); Font f = new Font("Arial",10,FontStyle.Bold) rootNode.NodeFont = f; TreeView1.Nodes.Add(rootNode); Best Regards, Misa Simic MCSD .NET Cool, thats a very nice way to structure it ...Show All

• Gadgets How do I hide scrollbars in Firefox?

  How can I hide the scrollbars of gadgets in Firefox I've tried adding overflow:hidden to the css, but it doesn't do a thing. Hi Todd. Sorry, I don't understand your explanation. Netvibes and Google both allow third party modules that display in iFrames that look great in in FireFox without scrollbars. how are they able to do this and Live.com cannot ...Show All

• Visual Studio Express Editions 0x80040154 - publish c# application (2005 Express)

  Morning Newbie at this. Please give detailed answer or good reference. I have developed a module that uses the Quickbooks SDK to access their account system. It workes well on my machine but when I build the app and install it on a test machine without the SDK installed I am unable to access the com object. I get the following error : System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM class factory for component with CLSID {4877276C-A727-486D-B201-F096035CA4DF} failed due to the following error: 80040154. at QBInterface.IQBCustomer.LoadQBCustomers(). ErrLookup tell me that this means that the class is not registered. Please can someone tell me how (if possible) build an installation (msi) file from ...Show All

• Visual Studio 2008 (Pre-release) Data access layer, so many questions

  I have been using a stronly typed dataset for my data access. It works but it has much to be desired. For one, you can't really query a dataset, using full SQL statements. Anyway, I see that linq creates a layer for you, I believe it uses a tool that is called sql metal. As far as I can tell, this layer does everything the typed dataset does. My first question is, can typed datasets be completely replaced by the classes generated by sqlmetal If so, is there any functionality that the typed datasets posses that won't be included in sqlmetal classes And, how does the sqlmetal classes compare to other object relational mappers that are currently available on the market today Can anyone see Linq bringing a change to current methodolog ...Show All

• SQL Server Deplying a custom assembly to the Reporting Server

  I'm having a load of grief trying to deply a custom assembly I wrote to the Reporting Server and get a #Error on a report where I call my custom code. The assembly acts as a wrapper to a web service we already had and works within the report designer IDE, returning the correct data in preview mode. I have added the AllowPartiallyTrustedCallers attribute into the Assemblyinfo with the following syntax: [assembly: AllowPartiallyTrustedCallers ] and have also added the following security assert into the classes header: [ UrlIdentityPermissionAttribute ( SecurityAction .Assert, Url = "http://xxxx/PeopleFinderWS/PFWS.asmx" )] I've compiled the assembly and saved the dll into the following folder on the Repor ...Show All

• Visual Studio 2008 (Pre-release) WCF service : Cannot browse the .svc file & hence the WSDL after hosting the service in IIS

  I have created a simple WCF  service as below. But after hosting it in IIS, I am facing problems as I am unable to browse the .svc   file, it gives ‘Page cannot be displayed’ error. But when I host the same service to some other machine, I can browse .svc file & hence the WSDL. Can anyone help me on this   My service contract & service code as below (GreetMessage.cs) using System; using System.Collections.Generic; using System.Text; using System.ServiceModel; using System.Runtime.Serialization;     namespace GreetMessageSolution {     [ ServiceContract ()]     public interface IGreetMessage     { & ...Show All

• Visual Studio Express Editions Unresolved symbol for MessageBoxA?

  I'm trying to use the MessageBox() function and I'm getting the follow error: HGETest.obj : error LNK2019: unresolved external symbol __imp__MessageBoxA@16 referenced in function _WinMain@16 If I add "user32.lib" to my additional dependencies it fixes the problem, but do I have to do this for every project I create I think I'm missing a setting, because I'm trying to compile example projects and none of them have user32.lib in the additional dependencies so I'm wondering if I should enter user32.lib into some kind of "global dependencies" list or something... It sounds like you missed a step when setting up the PlatformSDK. By default only kernel32.lib is linked to programs, ...Show All

• .NET Development Breakpoint issue on VS2005 SP1 / Vista x64

  Hello, I'm experiencing odd behavior with a new installation of VS and Vista: My new VS2005 install w/ SP1 (Beta) on Vista Ultimate x64 refuses to stop at a ‘breakpoint’ when I run in debug mode. I tested a breakpoint with a WinForm and had no problem. Is there something additional I need to do when running on Vista I've used VS2005 on XP for a long time without such an issue. Here are the details of a simple one page web project that has this behavior. (File System WebSite) Default.aspx Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load BREAK->> Response.Write("test") End Sub Web config: <compilation debug=" ...Show All

• .NET Development Showing Console from Service

  Hello All, I have an Console Application that i converted into a service. Somehow i want the service to show logging on Console. Is this possible. Well there is no console when the process is running as a Service you could of course create your own console - but one is not provided for you by default. in addition, the service needs to be configured to be able to interact with the desktop - otherwise even if it creates a console no one actually sees it. So in short, while this is theorically possible you need to consider a possible alternative - perhaps logging to a file instead of to the console ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Whats finaly in and out?

  Hellooo there... Anyone have an Idea which features are finaly in or out with the upcomming GSE What about fonts and ui, are there more api changes. I found an post to give a wishlist at connect for the next release but how could we do that without to know whats in this time... Oke... to say the truth: i'm just excited... I can't see anything being added that's not in the current beta, as it wouldn't be properly tested. There's a couple of font rendering classes that the community has released. I'd bet a GUI library would pop up soon (not that I'm working on one or anything ). I'm sure the XNA team is going to put out ver. 1.1 with all kinds of new stuff soon after the RTM. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. TorqueXNA

  I had a look at the XNA version of the Torque 2d engine and noticed that it converted 4mb worth of png files into over 60mb of xna files; Is this a Torque issue or xna as its a massive increase and would make releasing any games online a virtual impossibility. This brings up an important point. Reading through the forums since the beginning of beta, I've noticed that file compression is a common complaint. Both in the mandatory use of WAV files and on the conversion of PNG to XNA files. In case anyone hasn't noticed, Microsoft prefers to use their proprietary file types (.bmp, .wav, .x, etc). But most people use other types (.png, .mp3, etc) for various reasons, file compression being one of the biggest in my mind. I don't think ...Show All