Yogesh Kumar's Q&A profile

• .NET Development Best way to display large datasets

  I have an application (VB.Net, SQL Server) in which users routinely need to display large amounts of data. We are currently getting the data from the database via stored procedures. The data is then loaded into ADO.Net data tables and data sets. The data is displayed using a DataGridView class which uses a DataView as a binding source. We are finding that when we load large amounts of data into the datagrid there is a considerable delay, which seems to be much larger than a similar amount of data being displayed in Qurey Analyzer. Does anyone have any suggestions for speeding up the data display, or are there better objects to use for displaying large amounts of data TIA Ron L hi, if you have used cursors in your stored proc ...Show All

• .NET Development HttpListener and its Exception

  I am trying to create a traffic monitor for all incoming and outgoing (Local and Remote) IP addresses. I am trying to use HttpListener and HttpListenerContext, but I get an exception that the specified port to use is preregistered on my machine. Why is this and how can I fix it HttpListener listener = new HttpListener (); listener.Prefixes.Add( "http://*/" ); listener.Start(); while ( true ) { HttpListenerContext context = listener.GetContext(); lvMain.Items.Add(context.Request.LocalEndPoint.Address.ToString()); } As I mentioned earlier, you cannot use HttpListener to monitor traffic because it is a Web Server. There will already be another web server running on your machine like IIS and ...Show All

• .NET Development Web Service Proxy Support in the .NET Framework 2.0. Problems Resolving Host Name. .PAC

  We have an Proxy Auto-Configuration (PAC) file that uses the isInNet function to determine if the current request should be directed to our proxy server for external requests or be a direct connect if connecting to an internal server. We have a .net 2.0 client application that makes a call to a webservice. If the webservice’s url is configured with the host name (http://WebServer/WebServices/simple.asmx) we get an “The proxy server could not handle the request” error message. If we configure the webservice url to use the IP address (http://169.12.50.5/WebServices/simple.asmx) the webservice call works fine. If we remove the configuration for the .PAC file on the client machine both urls will work for the ...Show All

• SQL Server How to store file attachments (text and binary).

  I need to store several different types of documents (text, MS Word, PDF, etc.) in SQL Server 2005. What is the best way to store file attachments that have different MIME types Currently I'm using a table with a varbinary(max) column which works for binary files but not for text files. Do I need to have multiple columns in the table for different file types Thanks in advance for your help. CREATE TABLE dbo.[CM_Attachment] ( [Id] int IDENTITY (1, 1) NOT NULL , [Change_Request_Id] int NOT NULL , [Attachment] varbinary(max) not null, [Created_Date] datetime NOT NULL DEFAULT GetDate() , [Created_By] varchar(30) NOT NULL , [Modified_Date] datetime NOT NULL , [Modified_By] varchar(30) NOT NULL ) GO INSERT INTO CM_Attachment(Change_Req ...Show All

• Software Development for Windows Vista Problem in executing codeactivity inside a WhileActivity

  Hi, I am writing a simple workflow which has a whileactivity which contains a codeactivity as its child activity. When i execute the workflow it throws an exception Exception has been thrown by the target of an invocation. with inner exception Could not load file or assembly 'codetest, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified. and stack trace at System.RuntimeMethodHandle._SerializationInvoke(Object target, SignatureStruct& declaringTypeSig, SerializationInfo info, StreamingContext context) at System.RuntimeMethodHandle.SerializationInvoke(Object target, SignatureStruct declaringTypeSig, SerializationInfo info, StreamingContext cont ...Show All

• Software Development for Windows Vista How do you host WWF 3.0 as a webservice (instead of using ASP.NET as a host)?

  Tom/Vihang/All WWF Gurus, Can someone please provide an example of how to host WWF 3.0 workflows as a webservice, instead of using IIS (ASP.NET) to call and host XOML only workflows Tom has provided examples of ASP.NET hosting and calling XOML only workflows (using tracking and persistence). I need to do the same with a centralized web service. The labs provided with WWF 3.0 are very similar to WWF 2.0 labs. I cannot find any examples that offer samples on how to host workflow runtime services via a webservice that can be consumed by one or more websites (on one or more webservers). MS suggests using a centralized webservice to host workflow runtime services, instead of using IIS. Unfortunately I did not find any code examples (I ...Show All

• SQL Server count(*) for Indexes?

  Hi guys, Just wondering if there's a way to do count(*) for indexes to get the total number of the indexes in a table. Cheers, Justin Hi Rob, Thanks for your help. I tried the the first way but it returns 'actual sum +1'. If I do select * from sysindexes where id = object_id('Form') and (status & 64)=0 it returns a list of indexes including a redundant index named 'tForm'. After I tried it on another database, I found out that it is because the initial test was done on the database published for Sql Replication which might have generated the hidden 'tForm ' in the sysindexes. Is there a way to do 'count(*)' while exec the ' sp_helpindex ' Cheers, Justin ...Show All

• SQL Server Order which mirroring database get up

  Hi I have 3 server configured with mirroring. When the automatic failover occur, I use alter event generate by Sql Agent to rebuild user account (problem witch orphan user). My application use multiple database and I set up mirroring to multiple database. A question is the order which database get up after automatic failover. When event occur all database are ready to use, or maybe one database get up and sql agent send me event , secound database get up and sql agent send me event. What is the order As the order of preference goes by Alphabetical order, I think it is applied on the Database mirroring failover tasks too. I can see similar action on the basis of Clustering in previous versions. I bel ...Show All

• SQL Server ODBC connection to remote computer giving invalid instance() message

  I am trying to set up a ODBC connection to a remote database using the ODBC data source administrator. I am getting an error message complaining of an invalid instance(). The database I am trying to connect to does have a default instance and a named instance. Do I need to specify the instance name somewhere in the connection settings I tried specifying the server name as <Remote computer IP Address>/<Instance Name> but this didn't work. Any ideas Thanks for ideas. I think I needed to sleep on this one a bit! I looked at it again this morning and unticked the 'dynamically determine port' option in the network lib config of the ODBC connection setup and specified the port no. the instance is lis ...Show All

• SQL Server Replication fails when table name has single hyphen

  Hey, I have SQL Server 2000 DB that was converted via DTS from Acccess 97. Replication fails for any table with a single hypen in the table name. If I copy one of these tables to a name using an underscore rather than a hyphen, then it replicates successfully. Below are errror messags from agent with -Outputverboselevel set to 2. I have also seen 'Agent error code 20082', in which case the replication command is incomplete. Any ideas Thanks, Bill Coulter [12/7/2006 1:22:40 PM]172.23.150.51.engdata: {CALL sp_MSupd_br1-16 (NULL, ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, ,0x0200020000)} Parameterized values fo ...Show All

• Visual Basic Windows service

  hi guys, i made a windows service that monitors the time spent on the internet. i can install it, run it, stop it with no problem.but the service doesn't run on windows startup. why even though i told it to start automatically. and in the "Services" window, it shows me that the startup type is automatic. in the event log, everytime i start the windows, i see two errors: -Timeout (30000 milliseconds) waiting for the Time Counter service to connect. - The Time Counter service failed to start due to the following error: The service did not respond to the start or control request in a timely fashion. plz help me. :( >> Private _netConnCol As New TimeCounter.Net ...Show All

• Windows Search Technologies How do you get the Desktop Search Bar to show?

  I am trying to figure out how to work this thing. I can not figure how to get the Desktop Search Bar to show on start bar. Can anyone give me some insight as to where I can get a Getting Started paper for this thing or tell me how this works Thanks Greg Forster I was using the version you mentioned - the latest full version. It didn't work so I installed v.3 beta to see if that would, and it didn't. I can easily uninstall v.3 and reinstall the latest full version in order to apply any fix you might have. ...Show All

• Smart Device Development Blue Tooth Programming

  hello i am new to blue tooth programming and want to learn bluetooth programming how can i do in .net can any body tell me Please do not cross post. Merging... ...Show All

• .NET Development .Net Silent Install?

  can i get the .net framework to install silently so the user has no interaction with it, besides obviously accepting the EULA, then i can throw a progress bar up so they can know it hasn't frozen and is doing something. Also, there are some additional unattended installation options for the .NET Framework 2.0 described at http://blogs.msdn.com/astebner/archive/2006/07/02/655011.aspx . Thanks! Aaron ...Show All

• Visual Studio Express Editions C# Equivalent for My Namespace

  Is there a equivalent of the My namespace in C#. I want to validate if the internet connection is available or not, and I dont want to use an API nor exceptions Thanks Kenny Almost every feature in the My namespace is a simple alias for a framework class or method. My.Computer.Network.IsAvailable maps to System.Net.NetworkInformation.NetWorkInterface.GetIsNetworkAvailable(). Note that this just tells you that you're wired to a network, not that you have an Internet connection available. You could Ping... ...Show All