Jehan Badshah's Q&A profile

• .NET Development DataSet.Copy problem

  Hi! I have a problem with a DataTable that has a DataColumn like this: DataColumn id = new DataColumn ( "Id" , typeof ( SqlInt64 )); id.AutoIncrementSeed = 0; id.AutoIncrement = true ; id.AutoIncrementStep = 1; id.ReadOnly = true ; The DataTable has some rows (id=0, 1, 2, etc.) and I want to make a copy of the DataSet. But when I call the DataSet.Copy method it throws the following DataException: "Cannot convert object of type 'System.Data.SqlTypes.SqlInt64' to object of type 'System.Int64'." If the AutoIncrement=false and I type the values manually it works perfectly. Have you any idea what the problem is I'm not the owner of the DataSet ...Show All

• SQL Server Create Procedu SQL Server 2005

  Hi everyone, I'm creating a online e-letter registration system. That saves 'temp' values to a 'temp' table, and then sends a automated email to the subscriber, from which he/she can then except, or decline the registration. bu now i want to create a procedure, or some kind of funciton in T-SQL that will be scheduled to run every 2 or so hours, to check and see if there is any values in the temp table that is older than 24hours, and if that values is greater than 24hours, it must delete that values from the temp table... so that the temp table doesn't become too full of old, outdated data. Please help. Thanks OK, it would be interesting to know which SKU you are using (in detail if you use Expr ...Show All

• SQL Server Alternative to Merge Replication?

  Is there a simpler alternative to merge replication I am concerned about the splash of GUID across the DB, performance issues, and the complexity of the deployment. Peer 2 Peer does not currently handle conflicts (it will in the next version of sql server), so you can count that out for now. Merge replication does exactly what you need, there are many many references to customers using Merge replication with hundreds, if not thousands, of subscribers. My only suggestion to you is to try it out in a test environment. Yes it does require guid columns on every table as that is the mechanism used to track changes. If you can be patient, you can also wait for OCS to come out early next year with the next rel ...Show All

• Visual Studio Express Editions Access -> SQL Server migration

  Hi all, I developed a quite complex application using Access ad DBMS. I would like to try to migrate the same application from Access to SQL Server. Could you kindly suggest me if and how I could quickly do that I know that I have to replace the char for parameters used in my SQL query with the @ char but how could I mantain the same Dataset.xsd structure from Access to SQL Server Thanks in advance. I successfully converted the structure using upsizing tool or the newer "Microsoft SQL Server Migration Assistant for Access". My problem is how to could I mantain the same Dataset.xsd structure in my VB application from Access to SQL Server. ...Show All

• Visual Studio Unable to create SourceSafe Object

  I'm currently using VSS2005. I did register ssapi.dll by "regsvr32 ssapi.dll"; however, I got error: "could not create object named "SourceSafe" from vbscript below. Please help. Set oVSSDatabase = WScript.CreateObject( "SourceSafe" ) oVSSDatabase.Open ( "C:\VSSData\srcsafe.ini" ) Set oVSSItem = oVSSDatabase.VSSItem( "$/Test/testingfile.cs" ) oVSSItem.Parent.LocalSpec = "C:\Projects" oVSSItem.Get Alin, Thanks, I got my script working; however, I search for entire document on msdn. I can't find and return code for VSSItem ...Show All

• Visual Studio Express Editions concatenate differing field types into single column datagridview

  I have 3 fields in my database. City, State, Zip where zip is an integer. I would simply like to combine all 3 using a dataset and use the result to populate a single column datagridview. The output would look like Wausau, WI 544026097 the Below SQL looks right but fails as Zip is an integer . How can I convert zip to string in the SQL and then concatenate the fields into a string and display in a single DGV column SELECT City + " " + State + " " + Zip AS Expr1 FROM Addresses Thanks ! solved SELECT City + " " + State + " " + cstr(Zip) AS Expr1 FROM Addresses ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA GSE Language restrictions

  I've gone through the XNA GSE FAQ and I'm not sure I understand the decision in developing XNA GSE in a manner that doesn't allow it to integrate into Visual Studio languages other than the Express editions. Sure you can run C# Express alongside Standard, Pro and Team editions of Visual Studio, but I would suspect that a great many hobbyists (to which XNA GSE is targetted) have invested in at least Standard and even Pro editions. Won't these users be giving up extremely useful IDE features and coding tools because Express editions lack these features due to the nature of them being free products I honestly fail to see the logic in all this :) - Seef   exal wrote: It doesn't happ ...Show All

• Windows Live Developer Forums Calling Map Object From Another Browser Window

  Is there some reason why I can't do step "(c)" The intent is to enable a given hyperlink, when clicked, to pan to a specific lat/lon. This used to work before new Map control version. (a) Create a map instance in Window #1. (b) From Window #1, open a popup window populated with hyperlinks containing lat/lon data. (c) Refer to the map object in Window #1 using, var map = opener.map; Here is the relevant script located in the popup window: < html xmlns ="http://www.w3.org/1999/xhtml" > < head > < title > Mapped Facilities </ title > < script language ="javascript" type ="text/javascript" src ="http://dev.virtualearth.net/mapcontrol ...Show All

• .NET Development how to begin developing bluetoth application in c#

  please any help in how to begin building application in c# ..and what configuration must be done thnx man..but..is this article is enough for develop an application that will send data such as file of any type , from my pc (bluetooth device) to my labtop(bluettoth device ),,,also is there any configuration needed.. thanx for your time Mr Brendan ...Show All

• Windows Live Developer Forums How to extract Lat and Long values from map.GetCenter();

  Hi, I need to extract lat and long from map.GetCenter(); as separate values but I'm not sure exactly how, or if it is possible at all. The following returns "undefined": var ctr = map.GetCenter(); var lt= ctr.latitude; alert (lt); As well, is there any way to identify lat and long values of the corners of the map I need at least one long value... Any suggestions much appreciated. ..and for the corners of the map, use map.GetMapView(). It returns a VELatLongRectangle object, which has 2 properties: TopLeftLatLong and BottomRightLatLong. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. how to define On Mouse Over eventin DirectX

  I wish to create some onmouseover event function, can anyone tell me how to do it in DirectX, i've checked some example from DirectX tutotrial, the addbutton function got on mouse over event, but it's already preset in the library. If I want to set OnMouseOver event in my own code, what should I do. Thanks. Sorry i'm not sure what is DXUT, I'm just got an "Empty Project" example from DirectX Sample Browser as the template of my project. Is that the DXUT, do you know which example i'm saying ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Undefined errorcode from D3DXGetImageInfoFromFile

  At the moment i'm programming a 2d graphical engine with directX9, but when i try to run the function D3DXGetImageInfoFromFile((LPCWSTR) filename, &imginfo); it gives back an undefined error code, i'm using the directx october 2005 sdk with the latest version of the directx runtimes. Full engine GraphEngine.h: #pragma once class GraphEngine; #include <D3d9.h> #include <Windows.h> #include "GraphResource.h" class GraphEngine { public : IDirect3D9 *D3D; IDirect3DDevice9 *D3DDevice; IDirect3DSurface9 *D3DScreen; GraphEngine(HWND hWnd); ~GraphEngine( void ); void drawImage(GraphResource *img, int X, int Y); void RefreshScreen(); }; GraphEngine.cpp: ...Show All

• Visual Studio Linker Error .ctor

  ShMem.obj : error LNK2020: unresolved token (06000001) App.Net.App::.ctor Does anyone know to which constructor .ctor refers I believe I have all my constructors for App defined. Knowing which one the linker believes is missing might help me find what's gone wrong. thx Sorry, there is no more information to give. That's all the message says. I take it from your response there's no way to tie the message (or any other information generated in some other log/map file) to which constructor the message refers. For example, the period/full stop '.' before the ctor " . ctor" does not indicate a default constructor or a generated constructor etc. I just know it's some constructor. ...Show All

• Visual C# Using a Console with a Windows Form...

  Alright, I've been searching but I can't find anything related to my question... I need to use a Console with my Windows Form (for debug purposes). How do I "add" a Console Another thing... I need to find out how to make a rich text box unwritable. Thanks! Another easier (but not a pretty) way is just to set your program as a console application (by pulling up the properties of the project). It will create a console window as well as your form. ...Show All

• Visual Studio Parameters and jump to report.

  Hi, i hope this is not answered somewhere else - if so i have missed it. I have a bunch of reports with various user selectable parameters and jump to links inside (SSRS 2005). They work fine if you view the reports in /reports or /reportserver. I am now using the ASP control reportviewer. The reports render fine but inside the ASP page the reports do not respond to parameter selection or jump to. It's like the whole report refreshes when you select a parameter back to their defualt state. The reportview is running in remote mode not local. Thanks in advance :) Hi, yeah i fixed it. I used ispostback to stop the page refreshing. My page is c# the report code is just placed inside ...Show All