EvgenyG's Q&A profile

• SQL Server Missing Data on subscriber?

  I am using Transactional Replication as a backup for our main database. The subscriber database however is smaller than the original database. Is there something that I'm missing Is the subscriber missing data well, i mean the actual disk space it takes up is different. say the primary database is 3,031,040 KB and the subscriber database is 2,650,112 KB. In the Article setup, i set everything to True under 'Copy Objects and Settings to Subscriber'. under 'Destination Object' i changed 'Convert data types' to True. And under 'Statement Delivery' i changed INSERT, UPDATE and DELETE delivery format to INSERT, UPDATE and DELETE statements. ...Show All

• Windows Forms Datagrid - Dynamic Bound Column -Column Names case Sensitive

  Hi, I'm using asp.net datagrid control to populate the data. I have a datatable with columns and rows in one situation where im using pivot table to convert the columns as rows and rows as columns. then I'm adding columns by using BoundColumn class to the grid dynamically. finally binding the datatable to the datagrid. Datatable has two columns like "SERVICE" and "service" their value will be assume 1 and 2 when binding datatable to the datagrid by datasource its displaying two columns and values will be 1 and 1 irrespective of actual values 1 and 2. can any one help me regarding this. Thanks in advance. Here I'm giving sample code For intColumnCount = 0 To datatable1.Columns.Count- 1 Dim BoundColu ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Text Renderer and Font Generator

  Check out my font rendering system. I think its the easiest one to use that's out right now that can handle any character set :) There is full source to the font generator as well as the font renderer. Here is a tutorial on how to use the font renderer as well as the downloads to the generator and a sample that uses it. http://www.ziggyware.com/readarticle.php article_id=44 All of the samples on my site that render text use this system. http://www.ziggyware.com/articles.php cat_id=6 This class (TrueTypeFont) does not work with the AngelCode tool mentioned. I used the BitmapFont tool to generate a ".fnt" file as text and it cannot parse the text w/o throwing exceptions. ...Show All

• SQL Server Question transport-level error

  Hi all, I'm having a little problem with my sqlserver 2005. I'm trying to crate a user in Microsoft SQL Server Management Studio throug a query. Like this: ------------------------------------------------------------------------------------------- USE [master] GO CREATE LOGIN [MYUSER] WITH PASSWORD = N 'MYPASSWORD' , DEFAULT_DATABASE = [MYDB] , DEFAULT_LANGUAGE = [us_english] , CHECK_EXPIRATION = OFF , CHECK_POLICY = OFF GO ALTER LOGIN [MYUSER] ENABLE GO USE [msdb] GO CREATE USER [MYUSER] FOR LOGIN [MYUSER] ; GO GRANT EXECUTE ON [sp_start_job] TO [MYUSER] GO EXEC sp_addrolemember 'db_datareader' , 'MYUSER' GO EXEC sp_addrolemember 'db_datawriter' , 'MYUSER' GO EXEC sp_addrolemember 'SQLAgentOperatorRole' ...Show All

• SQL Server print version

  I have created a report which contains grouping.  Yesterday I learnt how to add a boolean paramter to expandAll.  Now in my ASP.Net front end I am using ReportViewer to retrieve the report... Now I want to introduce a "Print Version" and "Normal Version" (print version being all rows showing (expanding all grouping) and normal being groups showing.... Will this work Use javascript to create to div... 1 showing ReportViewer1 where expandAll parameter is true and div 2 containing ReportViewer2 where parameter is false...a radiobutton conrolled by javascript code will hide 1 div and show the other !  For some reason it doesnt load the report in ReportViewer2 !   Please help! Thanks!!! ...Show All

• .NET Development Multiple Client Connection Simultaneously

  I am working on Server client online game on which multiple player can play. But the problem is that connection can me made one at a time. If we make more than one connection simultaneouly then game will hung. I Have implement this with the tcplistener . Can I implements this with asynchronouly. If yes then how can I achive multiple connection and receive and send message from the clients. my server code is : public ServerForm() { processor = new Thread(new ThreadStart(StartListening)); processor.Start(); } listener = new TcpListener(clsGetIpAddress.PortNo); listener.Start(); while (true) { try { lock(this) { Socket s = listener.AcceptSocket() ; clientsocket = s; clientservice = new Thread(new Threa ...Show All

• Visual Studio 2008 (Pre-release) May CTP: Where are array extension methods defined?

  Nice work, the CTP - a tad flaky, but usable. I am in the process of upgrading one of my projects using LINQ to the May CTP. I managed to get the build process running, found the "missing" DLL's. I am now stuck with basically 5 compiler errors all related to extension methods. DLL's included are: System.Core; namespaces used are: System; System.Collections.Generic; System.Linq.Expressions; System.Linq; System.Text; System.Xml; The compiler chokes on: public IEnumerable < object > GetValues() { return _FieldValues.ToSequence(); } where _FieldValues is defined as: object [] _FieldValues; Can anyone enlight me In the May CTP ToSequence sas a valid extension that was de ...Show All

• Visual Studio Team System Schema compare locks up

  I ran a schema compare between two live databases. While in the process of choosing to skip certain objects, I clicked on update for an object and the application froze. I checked task manager and my processor was at 100% and devenv.exe had 99% of the CPU cycles. After 4-5 minutes, I killed the process. I had tried the same compare multiple times. It seems to function properly the first time I select schema compare, choose objects to skip, and then script the changes, but on the second time I execute it, on about the 20th change from update to skip, the visual studio freezes. This is the trial version of visual studio team suite with the database professional edition and I have applied the team services service pack. ...Show All

• Windows Forms datagrid keypress handler

  This works well but seems to work for all columns, Can anyone correct or advise me - thanks. void Numeric_KeyPress(object sender, KeyPressEventArgs e) { string str = "\b0123456789"; e.Handled = !(str.Contains(e.KeyChar.ToString())); } private void dataGridView1_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e) { if ((dataGridView1.CurrentCell.ColumnIndex) == 0) { e.Control.KeyPress += new KeyPressEventHandler(this.Numeric_KeyPress); } } Yes, it affected every column, as soon as you change column 1 or column 4 then all columns will only accept numerics. Do I need to remove the handler for columns other than 1 or ...Show All

• Visual C# Adding Web References at Run Time

  I'm working on a program and need to be able to add web references at runtime and haven't been able to find anything that would let me do this. Basically this is the way the program will work: 1. Allow user to enter asmx URL. 2. During runtime process the web service so it is accessible. 3. For now lets just say I want to print out all of the methods available from the Web Service. I've found examples of the AddWebReference method using an Add-In but can't seem to find anything explaining how to use this from a c# program. Any ideas or thoughts would be helpful. - Chris I know that I could always go to the WSDL and look through the xml myself, but I'd ideally not have to d ...Show All

• Internet Explorer Development asp.net 2.0 application with Master Page does not display properly under ie7

  I have an asp.net 2.0 application which when viewed on internet explorer 7 does not display properly. There is a footer that tends to appear in the middle of the screen, which was previously at the bottom, and also when grids appear and have enough data to scroll down the screen, the footer and the outline of the content page do not move down to accomodate this. I tried some recomendations from the ie7 site, but couldn't get it to work. Also this is specific to one website, others using a similiar setup work fine Any thoughts on where I should look next regarding this I have tried the site in firefox and it experiences the same display issues that I am having with ie 7. Haven't tried it with opera. ...Show All

• SQL Server Smart Client - Data Centric - SQL 2K to SSE local

  Trying to develop a smart client which will have data centric approach for storage of local data. The server is SQL Server 2000 and foot print database is going to SQL Server Express 2005. Is Merge replication a vaiable option. Can somebody guide me on this approach Is there any other architecture proposed for Smart client arcjitecture where the data tranfer will be in a couple of GBs. Can somebody tell me more about SOA as well Thanks! If you configure SQL Server 2000 as a publisher/distributor you can't subcribe using sql server express. I read that you can subscribe using MSDE or SQL Server Mobile(SQL Server Everywhere). I prefer to subscribe using SQL Server Mobile(SQL Server Everywhere) du ...Show All

• Windows Forms CPU usage

  Hi, I am looking for a simple way to diaplay CPU usage and (if possible) memory usage on a windows form. Cameron. should be: private PerformanceCounter theMemCounter = new PerformanceCounter ( "Memory" , "Available MBytes" ); ...Show All

• .NET Development data multiple bursts?

  Hi. This is a question I've been meaning to ask but then sometimes able to resolve it by adding a small delay before sending the next message. I have a server/client app client connects and sends data via the network stream.   .. this .theNetworkStream.Write(bytesOfData, 0, bytesOfData); this .theNetworkStream.Flush(); Thread.Sleep(140); //small delay     this works fine when sending 1 piece of data at a time, but when sending it in a loop, sometimes the data is sent properly whilst other times the data for some reason is recieved at the server end in 1 big string, instead of chunks of data, even with the delay from the client.   When recieving  data on the server, I am doing ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Any tips on drawing a "control panel"

  I'm doing a simple little space shooter, and things are going fairly well. Ships are moving, planets are spinning, background stars are scrolling along. However, the one thing I haven't figured out is how to do a "control panel" to display information about the ship, the "mini-map" of star locations, etc. I can do this through sprites, by sticking a large sprite across the lower third of the screen, then mapping each star onto the map using a scaled down texture. However, this seems to be very wasteful. After all, action on the "main screen" needs to be updated as often as possible, but if I were to update the star map no more than once every few seconds, it would be fine. Some of the control settings need to ...Show All