Val Maltsev's Q&A profile

• SQL Server SQL Server 2000 failed to attach database

  hi, everybody, i copy the *.mdf and *.ldf files from another computer to my computer, and run my computer's SQL Server to attach database, but it gives me a error like this: file *.mdf's file header is not a valid file header, FILE SIZE attribute is incorrect. i don't know why, plz help me. thank you very much .mdf and .ldf files need to be properly detached from the sql server service that is runnig them before copying. Do you de ...Show All

• Visual C# How to dynamically check if a type supports the "+" operator

  All, Has anybody any idea on how we can query a type to check whether it supports the "+" operator Correct me if I'm wrong, it seems to me that we can only query those methods which are named methods, like "Add" instead of "+". Thanks. Noli Operator+ is a named method; if you inspect CIL code that is produced, you'll notice a method called op_Addition. ...Show All

• Microsoft ISV Community Center Forums Email from MS Excel

  With thanks to another poster I've managed to get the code below opening and sending an email from MS Excel. The only problem I'm having is I want the value from a particular cell in a worksheet to appear in the message body. This value is actually a formula and will change as the source worksheet changes hence it will differ each time an email is sent i.e. the value at time of sending will convey the message I require. My unsuccessful att ...Show All

• SQL Server how to knw which column is primary key in a table

  hi all my question is which query shud i use in sql server 2000 to get which column or columns are primary keys of table i dont want to use any stored procedures only sql query sp_primary_keys_rowset is one of d stored proc in sql server 2005 but i couldn't understand which query they are using i only want to use sql query select o.name as TableName, c.name as ColumnName from sysindexes i inner join sysobjects o ON i.id ...Show All

• Visual C# How to call an API function by ordinal?

  Hi all, I'm working on a project that uses some DLL that export nameless functions, in which exported only by their ordinal numbers; How can I make a declaration for that ordinal function in C# and call it Also, if I have an API function retrieved by address using GetProcAddress, is it possible to call a function in C# directly by its address Is so, how Thanks in advance, -chris Chris, The DllImport attribute has an EntryPoint membe ...Show All

• Visual C# Add events for dynamically generated DropDownList control

  This is what I have done so far: In Page_Load() ............ dd1 = new DropDownList(); this.dd1.SelectedIndexChanged += new EventHandler(this.dd1_SelectedIndexChanged); int listIndex = 0; dd1.Items.Insert(listIndex, new ListItem("MY SETTINGS", "TestDD.aspx")); dd1.Font.Name = "Verdana"; dd1.Font.Bold = true; dd1.Font.Size = 7; dd1.ForeColor = Sys ...Show All

• Visual Studio Tools for Office Open action-pane from any existing word document

  hi all, im fairly new with vsto2005, and though i have read some articles i still havnt found an answer to my question. I want to build an action pane that the user can give some properties to a question or an essay written in a word document and then save these properties to a DataBase. Now, my question is, if it is possible that when a user opens a new simple word document and writes his question in the document, will be able to open my Action ...Show All

• Windows Forms DataGridView WordWrap?

  Is it possible to make the text wrap in a datagridview text column   I've got a grid that shows a list of notes (column 0 = noteDate, column 1 = noteText).   Any suggestions would be appreciated. Set the cells autosize mode to displayed cells and it wrapmode to true EmployeesDataGridView.Columns.Item(2).AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells EmployeesDataGridView.Columns.Item(2).DefaultCellStyle. ...Show All

• Visual Studio Team System TFS Sandbox Install on Windows XP using Virtual Server 2005 R2

  I have installed a sandbox environment on my machine as follows: Host: Windows XP SP2 - VS2005 VM1: Windows Server 2003 - DC, DNS, and VPN VM2: Windows Server 2003 - TFS If my VMs are configured with static IP addresses within the same subnet (i.e. Router = 192.168.1.1, Host = 192.168.1.2, VM1 = 192.168.1.99 and VM2 = 192.168.1.98), the Host can ping the VMs and everything works great. I now would like to modify my configuration to ...Show All

• Visual Studio Express Editions A total newbie...needs help.

  Greetings, I am really new to the programming world and was wondering if anyone can lend me a hand. I am working with Visual Web Developer Express Edition and have loaded the Personal Website Starter Kit. I am looking to change the database connection string in order for the database to function correctly when it's posted online. Where or how do I do that Is it even something I can or have to edit Am I asking the right questions ;) Any ...Show All

• Smart Device Development SqlCeCommand

  I am having trouble getting a paramatized query to work. I can't seem to get the syntax right to get the correct result. If I leave out the WHERE clause it sums the whole table, but after i add it I get a null answer. SqlCeConnection conn = new SqlCeConnection ( "Data Source =FB7MobileDB.sdf;" ); conn.Open(); //SqlCeCommand cmd = new SqlCeCommand("SELECT SUM(Amount) FROM LineItem WHERE (LineItem.InvNum = @invnum)&quo ...Show All

• SQL Server creating a user with dbo access

  Hi, I need to create a user with dbo access to a specific database using sql . I created a login and added a user to the login. How do i grant dbo privilege to this user (using sql) Is there any system stored procedure for this Please help. Thanks in advance Hi. Try sp_changeowner [@loginame=]'login' Changes the owner of the current database. ...Show All

• Windows Forms Creating Custom Dialogs

  Hi, I try to create a custom dialog in VS2005(C++), but the result is, that the dialog’s behaviour is like a "normal" control. It should behave like all the standard dialogs, which means, that you can place the control at design time on the "component tray" like i.e. the printDialog. Searching around, I found, that I have to set: TopLevel to false, and the FormBorderStyle to none/FixedDialog. But this is not working for me. What’s going wr ...Show All

• .NET Development datetimepicker & a datagridview

  Hi All, I have a datetimepicker & a datagridview on my form & a mdb file to store records of its user input data. Now my objective is to when user select a date then it should display all the records for that day in datagridview. And also when user wish to edit/delete that record, it should also delete from database. I used following code to add records on my database: Try connection.Open() str = "insert into data (username,indate) ...Show All

• Visual Basic Email from vb.net 2005 using SMTP

  Hi I am trying to send email from smtp client by using system.net.mail, if i send and receive in my companies smtp server it works properly, however if i send mail to hotmail, rediff, gmail etc (all ids are valid known email id ), it gives error like Mailbox unavailable. The server response was: not local host gmail.com, not a gateway please provide me a solution. thanks Atanu   What SMTP server are you usi ...Show All