ahmed khadragi's Q&A profile

• SQL Server Encrypting and Decrypting Data

  CREATE TABLE TabEncr ( id int identity ( 1 , 1 ), NonEncrField varchar ( 30 ), EncrField varchar ( 30 ) ) CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'OurSecretPassword' CREATE CERTIFICATE my_cert with subject = 'Some Certificate' CREATE SYMMETRIC KEY my_key with algorithm = triple_des encryption by certificate my_cert OPEN SYMMETRIC KEY my_key DECRYPTION BY CERTIFICATE my_cert INSERT INTO TabEncr ( NonEncrField , EncrField ) VALUES ( 'Some Plain Value' , encryptbykey ( key_guid ( 'my_key' ), 'Some Plain Value' )) CLOSE SYMMETRIC KEY my_key OPEN SYMMETRIC KEY my_key DECRYPTION BY CERTIFICATE my_cert SELECT NonEncrField , CONVERT ( VARCHAR ( 30 ), Decr ...Show All

• SQL Server Designing Reports for SQL Reporting Services 2000

  My customer has SQL Reporting Services on a server with SQL 2000 Standard Edition. The customer wants to develop his own Reporting Services reports. We have been recommending Visual Basic.NET Standard 2003 for this purpose in that it costs less than $100 (usually). However, with the advent of Visual Studio 2005, the VB.NET 2003 is becoming difficult or impossible to obtain. One option is Visual C#.NET Standard 2003 - I assume it will work - does anyone know for sure More importantly, when Visual C#.NET 2003 becomes unvailable, what options are left for developing RS 2000 reports Thanks for any suggestions. Mark You could also write a small tool that performs a RDL structure "downgrade&quo ...Show All

• Windows Forms how to change the state of checkbox without showing the error messagebox again?

  hi, following is the simple code private void cb8_CheckedChanged(object sender, EventArgs e) { if (cb12.Checked) { MessageBox.Show("You can not choose this channel. \n Please uncheck Channle D first", "Channel Tangly", MessageBoxButtons.OK, MessageBoxIcon.Error); cb8.CheckState = CheckState.Unchecked; } else ... If cb12 is checked, an error message box will be shown when user check cb8... So the checkstate of cb8 should be unchecked... However, with the above code, since the state of cb8 changed again, the error message will be shown again... So user had to close the error message box twice... Is there any way to solve this Thanks a lot! ...Show All

• Visual C# Using different versions of the same dll in one application in C# 1.2

  I want to use 2 versions of the same dll in one class. This is possible by using the alias feature provided by C#2.0 Check out this link http://blogs.msdn.com/abhinaba/archive/2005/11/30/498278.aspx I would like to know if there is any way/workaround to achieve this in earlier versions of C#. Thanks, Venu Aside from using the alias feature the only way I know to do this is through reflection and loading each assembly separately with the Assembly class ( System.Relfection.Assembly ). With it you could use it’s LoadFile() or Load() method to a specific file based on it’s path or based on it’s long name. The one obvious drawback of this method is that it is code intensive as you need to use reflection to create the type ...Show All

• Visual Studio Team System Where do I get the SQL Server 2005 Standard Edition for TFS Workgroup Edition

  I am getting ready to install the TFS workgroup edition, but need to install SQL Server 2005 first. According to the installer help file, SQL Server is included, but I don't see it anywhere on the TFS installer. ...Show All

• SQL Server Attempt to fetch logical page in database failed SQLServer2005SP2

  Hi, I am getting the following exception when i try to ran the J2EE application(deployed on WL9 and sqljdbc 1.1 driver). I am using SQL Server 2005 SP2. and the same application ran just fine with SQL server 2000. I am also getting An inconsistency was detected during an internal operation error some times . All these errors are happening intermittently. I am running a set of Junit tests against this J2EE application. Any help in this is greatly appreciated C aused by: com.microsoft.sqlserver.jdbc.SQLServerException: Attempt to fetch logical page (1:2227) in database 6 failed. It belongs to allocation unit 72057594184335360 not to 72057594217037824. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown So ...Show All

• SQL Server cluster install 2nd node unavailable

  Hi all, Try to install sql 2005 x64 on a Win2003r2 x64 two node cluster. All looks fine as far I get to the "cluster node configuration" dialog. My second node is always displayed as "unavailable node" reason "unknown". - I checked the logfiles but could not find any error. - Installation user & cluster user are both local admins. - Tried with sql 2005 x32 version -> same result. What do I miss out here Any help is highly appreciated. TIA acki Can you check thru this http://msdn2.microsoft.com/en-us/library/ms179530.aspx link and confirm whether you have following in same fashion. ...Show All

• Visual Studio Close file without saving

  VS2005/C# I just did quite a number of undo steps in a codefile and then figured I shouldn't have. So I hold Ctrl+Y ..but it didn't redo all undos. I then figure I could just close the file and reopen it. But ofcourse I 'forgot' that Visual Studio tries to 'help' the user. Because I opened the file trough the solution pane and it appears to have saved the file after all. But in the file-tab it does mark the file with a '*'. So it knows I changed the file without saving. 1. Is there any way I can get the real unedited file back. 2. Is there any way I can make VS NOT to save a file when i close it Thanks. I'm working on a Microsoft Word Add-in. In VS2005, using C#. It's all new to me, but I'm ...Show All

• Visual Studio Tools for Office Finding Page Breaks

  Re: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1179691&SiteID=1 Thanks already to Maarten van Stam , who answered part of my earlier question. I am trying to identify the page breaks in a Word document that will eventually be saved as a filtered html file for some post-processing later.I want to mark each page break with a string so it can be identified visually and/or by a regex expression. This will be part of an application-level plug in for word that is being developed in C#. No, unlike (for example) WordPerfect there's nothing you can identify. The closest you can get would be to either move down each line (Selection.MoveDown), checking the current page number as you go... Or you ...Show All

• Visual Studio Team System Problem in TFS API about member setting

  I'd like to know which API can i use to set a new member id into TFS project group. for example, i establish a TFS server " http://TFSM:8080 ". There is a team project "TP1". A user "voltafil" which is added into AD on TFS Server. Which API can i call to set "voltafil" as a member of TP1 Maybe set "voltafil" as a group member of "Administrator". The tool to use is tfssecurity.exe with /g+ option. IGroupSecurityService has AddMemberToApplicationGroup method to add users to a group. You could get identity of an account using ReadIdentityFromSource method. Here is a sample for using IGroupSecruityService and getting list of user identities in ...Show All

• SQL Server SQL Server vs Oracle

  Oracle is typically used for the 'HUGE' databases. SQL Server has had limitations with these same databases running into processing limitations. Can someone give me a realistic comparison and give me some benchmark info Or point to where I could find that info. ex. terabyte size in both programs, where does one leave off (size) and the other begin. thx, Kat here are some resources that may be helpful to you: Web page with SQL Server vs. Oracle comparison information http://www.microsoft.com/sql/prodinfo/compare/oracle/default.mspx ...Show All

• Visual Studio Express Editions One to Many relationships

  Is it possible to create a one to many relationship in VB express sql database I wish to relate a primary key in one table to several fields in another table. If this is possible what is the best way to go about this I have tried the diagram method and it does not seem to like having more than one foreign key between the same two tables. I'm pretty sure it is possible. You need to get your hands on a better database designer. Try SQL Server Management Studio Express . For a better answer, post at the SQL forums. ...Show All

• Smart Device Development Draw nice line Compact Framework

  I want to draw some lines and basic shapes on screen in Compact Framework. I've used the Graphics class and a bitmap, and then added the bitmap to a picturebox. The problem is the lines look like *** when they are not going straight up or to the side, and by *** I mean that it looks like stairs. Anyone know how I can fix this problem My screen is 640*480 pixels, and that's what I use for my bitmap. I tried to set the bitmap to 6400*4800 and then set the sizemode property for the picturebox to stretch, but the result was the same, the line is like a stair. I guess I might have to use some visual "cheat" or something, but don't know where to start. Anyone got any tips ...Show All

• .NET Development routing and remote access nat all packets

  Hi, I install and enable routing and remote access server on windows 2003 server sp1. it act as vpn ras server which client should connect to that and it nat only vpn clients to internet oublic ip address for this purpose i delete local area connection from nat interface and i add internal interface. but cilent which are not connected to the vpn server and they only have invalid private ip address work and nat ip address. Regard's R.Ordoubadi This forum is intended for questions related to developing software with the .NET Framework. I believe you will get better results posting your question in the following newsgroup. I see similar type questions there. microsoft.public.windows.se ...Show All

• Windows Forms Enabling/Disabling ToolStripMenuItem objects

  Hi, I have a big MenuStrip and I want to create a Sub to enable or disable each ToolStripMenuItem, where the Item name and the status are parameters for the Sub. The Sub can be something like: Sub SetMenuEnable(ByRef MenuName As String, ByRef Status As Boolean) myMenu.Items(MenuName).Enabled = Status End Sub Any idea how to do it in vb.net 2005 Thanks Cristian hmm you may have to do it programmatically (creating the menus), dont know why its not allowing you to do this. from examples I have seen, and I believe this would work, you can create a menu item programmatically, add sub menus in this main menu item, then set the forms' menu property to this menu item. I'll se ...Show All