Akshay Bhargava's Q&A profile

• Windows Forms How to get the identity key when adding rows?

  Hi! I have a DataGridView control bounded to a table in SQL Server 2005. This table has an identity primary key with auto increment of 1. Facts: 1.- I add the rows manually with success: I create the DataRow from the related table in the typed dataset. Then I just update the table adapter and the row is created without a problem. 2.- However in the DataGridView I display another column of the table, not the one with the primary key. I would like to know: a) How do I know which was the newly added row in the datagridview (please consider fact 2). Right now I have to look row by row! (I know, I know: this is a brute force solution). b) When adding the row to the dataset is there any way to know the newly created row's ke ...Show All

• SQL Server Can OWC 11 work with SSAS 2005 cubes?

  Office Web Components 11 problem with SQL Server 2005 Apr 05 CTP Can OWC 11 work with SSAS 2005 cubes When using the Business Scorecard Manager 2005 builder   - added a Report View - set the data source for the OWC pivot table (Used the MS Ole DB provider for Analysis Services 9.0 provider) - Test connection succeded, but cannot get a listing of the cubes under "Use Data from" Cannot get the dimension & measures in the Field list The Pivot table gives an error "Cannot connect to the server xyz. The server is either not started or too busy" Have also installed ptslite (pivot table service) - followed steps as in installation instructions for use with SQL Server 2005 per the engineer: The basic use of ...Show All

• Smart Device Development Native Exception Error - 0xc0000005

  I am running the following code - which takes the data from an XML file and updates a SQL Mobile table - it seems to consistenly throw a native exception error (ExceptionCode: 0xc0000005) Here is the code: #region DataRefreshFromXML public void RefreshDataFromXML() { if ( File .Exists(appPath + @"\data\HandheldInventory.xml" )) try { DataSet ds = new DataSet (); ds.ReadXml(appPath + @"\data\HandheldInventory.xml" ); if (ds.Tables.Count > 0) { using ( SqlCeConnection cn = GetConnection()) { SqlCeDataAdapter da; da = new SqlCeDataAdapter ( "SELECT * FROM MobileInventory" , cn); SqlCeCommandBuilder cb; cb = new SqlCeCommandBu ...Show All

• .NET Development Debug to Release version

  It's probably got a really simple answer... i've just started using VS2005, and am converting my web services over. How do I switch from Debug to Release mode Thanks! In VS 2005, a web site cannot be set to be compiled to release mode in the solution properties. Instead, you need to edit your web.config and set the debug element from "true" to "false" (it's under the compilation element). Another way is to create the web services using the web application project instead of the default web site project type (you'll need to download the web application project add-ons from the Visual Studio site). Best of luck, Ido. ...Show All

• .NET Development How to know when a remote object is no more available

  Hello, Is it possible to know when a remote object is no more available. I mean something like the OnClose event of the MFC CAsyncSocket class. Marco Hi Marco, Remoting doesnt provide this kind of server events. There are couple of options that you can try 1. Implement a ping method on the server that clients can periodically ping to check the health of the server 2. Implement a callback mechanism and then make the server invoke all clients in its InitializeLifetimeService method (which should be called when the server's lease expired) to let them know its going down. Hope this helps. ...Show All

• .NET Development RSA Sign without using SignData or SignHash

  Does anyone know if there is possible to encrypt a byte array with an RSA private key and decrypt with the public key In all the examples I've seen, they encrypt the data with the public and decrypt it with the private. I've tried the other way round but it doesn't work. I just want to sign a byte array but without the function signData or signHash. I want to calculate my own hash and sign it. I've try the following code: RSACryptoServiceProvider rsaBob; RSACryptoServiceProvider rsaAlice; ASCIIEncoding ByteEncoding = new ASCIIEncoding(); rsaAlice = new RSACryptoServiceProvider(); rsaBob = new RSACryptoServiceProvider(); rsaBob.ImportParameters(rsaAlice.ExportParameters(false)); byte[] EnAlice = rsaAl ...Show All

• Smart Device Development Value does not fall within the expected range

  string test = "30"; CoBoxProduct.Items.Clear(); ArrayList Products = new ArrayList(); Products = pdb.ProIDProNamebyID(test); CoBoxProduct.SelectedValueChanged += new EventHandler(CoBoxProduct_SelectedValueChanged); CoBoxProduct.DataSource = Products; CoBoxProduct.DisplayMember = "productname"; CoBoxProduct.ValueMember = "productid"; Listview Problem. When bulding a listview with a databse question. The SQL syntax works, the class files work but not when adding the valuemember. public Order(int productid, string productname) { _productid = productid; _productname = productname; } private int _productid; public ...Show All

• SharePoint Products and Technologies RSSAggregator error

  On our default MOSS 2007 sites I have an out-of-the-box RSSAggregator connected to a text filter. The RSSAggregator fails with a "empty uri error".  Here's the log entry:   RssWebPart: Exception handed to HandleRuntimeException.HandleException System.UriFormatException: Invalid URI: The URI is empty.     at System.Uri.CreateThis(String uri, Boolean dontEscape, UriKind uriKind)     at System.Net.WebRequest.Create(String requestUriString)     at Microsoft.SharePoint.WebControls.XmlUrlDataSource.FetchData(String requestUrl)     at Microsoft.SharePoint.WebControls.BaseXmlDataSource.Execute(String request)     at Microsoft.Shar ...Show All

• Windows Live Developer Forums Error MSN Search When Putting Live

  I've just finished testing an implementation of the MSN Search functionality into one of my projects. During debugging and testing on my local machine everything was working successfully, searches were being carried out and everything was fine. However when putting it onto the server I came across an error: The remote name could not be resolved: 'soap.search.msn.com' I believe that the problem will be down to permissions on the server. Before messing around with the permission settings I thought I'd ask and see if anyone else has had this problem and whether or not they managed to solve the issue. Thankyou James I've just finished testing an implementation of the MSN Search functionality into one of my projects. During debugging and ...Show All

• SQL Server Why date Columns default to 1900 after inserting dates in SQL Server Everywhere.?

  I have created a sample Database for the school project, After executing the query below, the Date column is supposed to have the dates I have entered before, However the dates shown are 1900. Any idea why is this happening I appreciate your help. Thank you. Query:   Drop table AccountReceivable GO --BEGIN TRANSACTION Create table AccountReceivable (   AccountRecID int identity ( 1 , 1 ) not null,   PatientID int not null,   PresentCharges int default 0 not null,   PaymentMade money default 0 not null,   PreviousBalance money default 0 not null,   BalanceDue money default 0 not null,   LastPay ...Show All

• Visual C++ backward debugging in Visual Studio??

  Hello everyone, Suppose a program looks like, -------------------- code block 1; if (condition == true) { code block 2; } -------------------- I want to see the state of block 1 (variable values) if condition is true. So I am wondering whether Visual Studio supports backward debugging, if it supports, I could set a breakpoint at the beginning of code block 2, and if it is executed, I could run *back* to the beginning of code block 1 to execute code block 1 again see the detailed running process of code block 1. thanks in advance, George You're looking for information about a processor state that no longer exists. Let's say your code (well, pseudo-code) looks like this: code block 1 { allocate some m ...Show All

• Visual C++ Where is wrong in the combobox

  In my simple text to speech dialog based program, the combobox doesn't show all the voice items, there is only one voice "Microsoft Sam" added in the box. here is the code in the method of OnInitDialog(): ---------------------------------------------------------- HWND hWndCombo; GetDlgItem(IDC_COMBO_VOICE, &hWndCombo); HRESULT hr=SpInitTokenComboBox(hWndCombo,SPCAT_VOICES); ---------------------------------------------------------- TO find the problem, I added another CCombox in the dialog, it doesn't show the string items either here is the code in the method of OnInitDialog():: ---------------------------------------------------------- CString str; for (int i=0;i<20;i++) { str.Format(_T("this is the str ...Show All

• .NET Development Start automatically Windows service

  I created a windows service in VS Standard .Net 2005 I installed it and set to start automatically, but when boot machine, an error 1053 occured. If I click in button to Start, everything is OK. I can stop it... Please, what can I do Tks! What are you doing in OnStart There seems to be an operation witch takes too long for the service control manager. -- SvenC ...Show All

• .NET Development Counting values in a hash table

  I am populating a hash table with values retrieved from a dataset. Once the data is in the hash table I'd like to query against the hash table, look for a particular value and then have a count of that particular value returned. Not having worked with hash tables before I have no idea how to do this; nor do I know if employing a hash table is indeed the best way to accomplish this, so if anybody has a better idea I'd be very appreciative to be told so and given an example. Thank you. Sean. I assume you want to do something like this: foreach(DictionaryEntry dictionaryEntry in hashTable) {     Debug.WriteLine( dictionaryEntry.Key.ToString() + " => " + dictionaryEntry.Value.ToStrin ...Show All

• Windows Forms VS 2005: Joining tables with update/delete/insert commands?

  I’m trying to have two related tables appear in one datagridview with the ability to update/insert/delete in the table adapter. Here is a simplified version of what the table structure looks like: Table1 Table2 Table1_ID Table2_ID Order_No Part_No Table1_ID I want the datagridview to show: Order_No, and Part_No Upon trying to create this in the Designer, I was able to make a dataset that included fields from both tables (with an inner join). The automatically created Fill works fine, however, I’m unable to have the wizard create the update/insert/delete. Since I’m a novice, I’m not really sure how to implement them myself (with concurrency). What would be the easiest ...Show All