msatmti's Q&A profile

• Windows Forms Binding columns...

  I have a datagridview with two columns (ID, Customer). I use the next code to fill the datagridview: dim strSQL as string = "SELECT CustomerID, CustomerName FROM Customers" da = New OledbDataAdapter (strSQL, conn)  da.Fill(ds, "Customers") datagridview1.DataSource = ds.Tables("Customers")   'conn is my connectionstring to an Access DB   'ds is my dataset The thing is ...Show All

• .NET Development Firefox and Other Browser Support in ASP.Net 2.0

  After working hard on developing a website for my company that was user-friendly, and using numerous ASP.Net 2.0 Controls such as asp:Panel and asp:MultiView I have found a serious problem that is still unresolved since the classic ASP era. asp:Panel controls render horribly in Firefox, Safari, IE Mac and other Non-WinIE browsers. I find this is very disgusting that MS still hasn't corrected this problem even when it was evident in ASP.Net 1.0/1.1! I need to find a solution to have ASP.Net 2.0 Correctly render all panels and similar controls. Does anyone have a solution other than BrowserCaps I tried numerous ways of configuring it, but it s ...Show All

• .NET Development Primary Key getting problem with SqlDataAdapter.Update

  Hi, I am using SqlDataAdapter.Update method to insert new row in database using commandbuilder(i.e, generating insert,update commands on the fly). Now I want the new primary key generated in this row to insert it into another table. I dont want to fire another query with database. Is there something I m doing wrong or missing some attributes to set. Thx Thanks for the reply. But Is there no way to get the key that has been generated automatically using SqlDataAdapter. Currently I m finding that record after insertion using select query and then getting the new key. But this is a very inefficient method. I hope there woul ...Show All

• SQL Server Need help on Matrix Column Grouping

  Hi all, I am trying to make column grouping which look like this: Group1 Group2a Group2b Group2c G3a G3b G3c G3d G3a G3b G3c G3d G3a G3b G3c G3d Data Data ...Show All

• Visual Basic Problem with Combobox and SelectedValue

  Hi again from Spain. I'm working with the beta2 (VB.NET) and i have a problem with a ComboBox and the SelectedValue propertie. I fill a Combo from a database and i use the AutoComplete feature to make easy select a value. But... if i use TAB to enter the Combo... i type the value or select it with the keyboard... and ... then use the TAB to go to the next control (or click with the mouse in other field, button, etc)... the SELECTEDVALUE of this combo is NULL. In the combo appear the text of the value... but i need to select it with the mouse or press ENTER to assing the value to the SELECTEDVALUE propertie of the Combo. Sorry if my engl ...Show All

• SQL Server Users for encrypt and decrypt purposes only

  Hi there, Using symmetric keys and certificates in SQL2005, can one assign users permission to only decrypt or encrypt data Reason would be say data capturer and data reader type roles. I tried to create some with the GRANT CONTROL and GRANT VIEW for certificates and definitions on Symmetric keys, but havent been to successfull. Would be great if someone here can offer some advise on it, and if it's possible using SQL rights. thanks You can do this, but it requires encapsulating the encryption and decryption operations into procedures. Then you can grant permissions appropriately on the stored ...Show All

• .NET Development Combining Interfaces

  Hi I have the following two interfaces: interface IFirst { .... } interface ISecond { .... }   i need to combine these two interfaces without using third one or any other class. is there any way It is used in the .NET Framework all the time. Rather than implementing the same methods and properties as another interface, you can simply inherit that interface. For example, IList inherits ICollection and IEnumerable. ...Show All

• Windows Forms A little puzzle with passing ID and displayed fields from form to another in combo box i VB2003

  I have a combo box populated by OleDbDataAdapter in a form. And I have to pass the selected value to other forms for display. But I also want to pass the ID field (which is integer) so that I can sae the ID of the selected item rather than the text itself. I use a OleDbDataAdapter in, oledbconnection and data set in my forms. I also use Display member to display the right column (text in my case) and and Value member to associate my item to the ID field which is integer. My problem I can pass either the ID field or the selected text field but I don t know ho to pass both Thanks a lot. I apreciate your help. ...Show All

• Smart Device Development running a program inside emulator

  I am using Win CE emulator 5.0 after I build the application on VS.2005 I reach it from emulator by main menu-file sharing. Althought my project is win CE project I can not run it in the emulator how do you run your program in the emulator regards You need to compile your application for X86 CPU architecture. You can select the output type of the project in a drop down on the toolbar. Thanks, Vladimir ...Show All

• Visual FoxPro import from excel

  how can i import an excel sheet with huge text on some cells... i try it, but the character field is only 254 chars size, i did try to create a table and then append the big text cells to memo fields, but they remain empty... thanks for the help !! Cetin says to use SPT... why I never thought to do this is beyond me. (Probably because I associate (wrongly) SPT with relational databases Here you go : MCONNSTR="Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=C:\FOX\TEST.xls;DefaultDir=c:\FOX;"  nConn = sqlstringco ...Show All

• .NET Development Urgent:Add,Edit,Delete,Modify an XML document in vb 6.0 using DOMDocument

  For Example XML document is shown below: <emps> <emp> <ename>Srikanth</ename> <empno>1</empno> <sal>6000</sal> </emp> </emps> The values of ename,empno and sal are displayed in textbox control. Add: If I click on the add button i want to add new node to the xml file. example to add : To add i have written code, this is working fine... Dim objperson As IXMLDOMNode Dim objchild As IXMLDOMNode Set objperson = xml_document.createElement("emp") xml_document.documentElement.appendChild objperson Set objchild = xml_document.createElement("ename&q ...Show All

• SQL Server dealing with .dll files after creating Assembly

  Hi I want to use CLR for developing database object such as stored procedures. I have read the "Getting Started with CLR Integration" from MSDN help and successfully create my first procedure . I create an assembly in SQLServer2005 with this code: CREATE ASSEMBLY helloworld from 'c:\helloworld.dll' WITH PERMISSION_SET = SAFE My questions are : How should I deal with helloworld.dll after creating Assembly Can I delete this file What should I do for uploading my application on the webserver Should I upload any .dll file Yes, Your Answe ...Show All

• Windows Forms Sharing same data on two forms

  I am new to VB.Net and windows form so bear with me. I am working on an inventory program and am having some trouble figuring out how to do the following. I have a dataset with several tables adapters. The viewSalesCallItems table adapter combines several tables and has the following columns: ItemKey UPC ProductDescription SalesCallKey CutIn Npnt Discontinued Dispaly Price ReducedPrice Facing The second table adapter handles the tblSalesCallItems table and has the following columns   pk_SCIKey ItemKey SalesCallKey CutIn Npnt Discontinued Dispaly Price ReducedPrice Facing On form1 there is a datagrid that displays the UPC and ...Show All

• Windows Forms Menu merging without MDI

  When using MDI, you can merge menu and toolstrip (and taskbar ) items. Luvly. But how should I go about creating a SDI application with muliple parent windows that have common items. For example 3 parent windows that inherit from a common base form. They all inherit "File -> Exit" and "Options -> Settings", but each have their own "File -> Print Report" etc. It doesn't appear I can extend the menus in the derived forms (even though modifiers=protected). Do I have to (can I) add their extra menu items at runtime You can merge any two menus (any ToolStrip derivatives actuallly) manually via methods on To ...Show All

• Visual Studio Package 'Visual Studio Source Control Integration Package' failed to load

  When I build our source code using DevEnv I get an error message saying "Package 'Visual Studio Source Control Integration Package' failed to load" in the log file. I am just test-building a copy of our source code with VS2005 so no source control should be involved. How can I get rid of this message When I build the very same solutions interactively I do not get any messages concerning source control. Dan, Thanks for the response, however, this is a new install of VS 2005. This hasn't been a real problem for me since the project actually builds in spite of the error messages. I'm just not real sure wh ...Show All