Zannadar's Q&A profile

• Visual Studio Express Editions error in connecting to SQL Server 2000

  Hello, I have a problem when I try to connect to SQL Server 2000 I got this error message http://arabicpro.arablycos.com/myerror.JPG please how do I solve it --------------------------------- and I want to know how do I connect to it by code please give me full information (I`m a beginner in .NET) Thanks i have a problem when i try to connect sql server 2000 by clinet computer in p2p windows xp networking. server access denied/ not found. ...Show All

• .NET Development DefaultButton - Property of Panel

  Hi, I have a panel in my aspx page for which I have set the defaultbutton property of panel to submit button. The problem I am facing is that on click of enter the page gets submitted the first time however when I press enter second time the page is not submitted. Also, this is happening at the production installation, the page works fine on the development environment. Do we need to have specific browser settings\.net settings to make this work. Also, we are using AJAX Extension for .Net version 1.0. Any suggestions will be of great help. Not sure, whether this is the right however couldn't get hold of any better place. Please let me know if this can be discussed in any other forum. TIA Ritesh ...Show All

• SQL Server About @@ERROR in SQL 2005 online book

  Here http://msdn2.microsoft.com/en-us/library/ms190193.aspx it is explained that @@ERROR will be cleared and reset. But here: http://msdn2.microsoft.com/en-us/library/ms190248.aspx http://msdn2.microsoft.com/en-us/library/ms187009.aspx we still see: IF (@@ERROR <> 0) SET @ErrorSave = @@ERROR Chester Here http://msdn2.microsoft.com/en-us/library/ms190193.aspx It says exactly: Conditional statements, such as the IF statement, reset @@ERROR. If you reference @@ERROR in an IF statement, references to @@ERROR in the IF or ELSE blocks will not retrieve the @@ERROR information. In the following example, @@ERROR is reset by IF and does not return the error number ...Show All

• Visual Studio Express Editions How can I add the content in the end of existing file by using C#? Better approach?

  Dear all, I met one problem about adding content in the end of the existing file by using C#. I implemented it as follows by using StreamReader, StreamWriter and ArrayList. However, I don't know whether my implmentation is good or how can I improve it i.e. The file structure will be like: 1234666\n 44234252\n 123141245345\n ... I wanna add the value 99999 in the end of the file. The snippet of code is as follows. public static void logfileWirter() { StreamReader sreader = new StreamReader(logfile_URL); string input = null; List<int[]> temp_intlist = new List<int[]>(); while ( ( input = sreader.ReadLine() ) != null ) { input = Convert ...Show All

• Visual C# Disk Partition Free Space

  I am attempting to programatically retrieve the free space for all partitions on each disk in any given system. Using WMI, I have found a way to get the free space for logical drives within Windows but, I have found no way to get the free space for partitions that are hidden to Windows Explorer. For instance, dell PCs ship with a hidden partition that hold the restore image. This partition (and it free space) is visible in computer management (disk manager) but I can find nothing in WMI to retrieve this information. Is there a way using WMI or other means to retrieve this infomation in a C# windows app Thanks... if you are using .NET 2.0 you would be better in using the DriveInfo classes as it woul ...Show All

• SQL Server Invalid Character in Flat File or Turncate problem

  My source is a csv flat file. Currently I use that same flat file on SQL 2000 and SQL 2005. On SQL 2000 it runs fine and it inserts that character as part of the string (varchar), however, it gives me truncate error on sql 2005. I already use the "Suggest Types...." and my Output columns have the correct lenght (specially that lehght of that column is only 30 char which is less than the default anyways). If I remove that character it runs fine for that column..... This is the values that I get in my flat file for the trouble coulmn is "ATTN: JON OLSEN a€“ CTRL8 " And the error that I get when running the SSIS is [Flat File Source OrderDetail [1]] Error: Data conversion failed. The data conversion for ...Show All

• Microsoft ISV Community Center Forums vlookup

  Hello can anyone help me with how to write the excel vlookup function in vba the function in excel looks like this VLOOKUP(O2,'[Consolidated list of supplier.xls]Sheet3'!$A$5:$F$218,6,FALSE) how can i get something similar working in a macro. thanks namrata Hi, How about some like this Dim rngLookupValue As Range Dim rngtable As Range Dim lngColIndex As Long Dim blnRangeLookup As Boolean Set rngLookupValue = Range("O2") Set rngtable = Workbooks("Consolidated list of supplier.xls").Worksheets("Sheet3").Range("$A$5:$F$218") lngColIndex = 6 blnRangeLookup = False vntResult = Application.WorksheetFunction.VLookup(rngLookupValue, rngtable, lngColI ...Show All

• Visual Studio Team System SOAP Exception while connecting to TFS project through another workstation

  Someone is trying to connect to TFS project that I created from his workstation and getting this error: Server did not recognize the value of HTTP header SOAPAction. http://schemas.microsoft.com/TeamFoundation/2005/06/Services/ServerStatus/02/CheckAuthentication I have looked up this error at many places. But have not seen this specific to TFS client. This workstation has team suite installed with TFS client installed. Naren's right - the schema version being 02 means it's not an RTM client. (The way I check is to look in %ProgramFiles%\Visual Studio 2005\Common7\IDE, check the version on tf.exe - should be 50727.147 for Whidbey RTM). If you still see problems after upgrading to the RTM version, ...Show All

• Windows Forms Graduation Project

  hi all, i'm student in the last year in computer science faculty in egypt , i need badly for Graduation Project ideas to make , i need new ideas that can be new trend in the computer science , please any one who has any good idea for the graduation project , give it to me , don't hesitate to give the idea even it's difficult. please help me... i'm waiting for your ideas... best Regards john nabil remember that out of 20 groups, at most 10 will write a program for the university itself, something that happens every year, they hardly use these stuffs, 5 will go for medical field, its vast and complete, and the rest 5 , 3 will top the class:) ...Show All

• Visual Studio Express Editions precomiled header directives

  I am using some user defined header files and i have included the header files in the program but when i try to compile it, i get the following error: fatal error C1010: unexpected end of file while looking for precompiled header directive Error executing cl.exe. I went onto project->settings->c++ and changed the option to not use precompiled headers but it did not solve teh problem. I had a similar problem before but changing the project settings solved my problem but thats not the case anymore. Could someone shed some light on this please!! Thanks very much What i meant was, when you were using those libraries, you had to create a solution of some kind, was it a basic win32 console application A ...Show All

• Windows Forms return type

  hi all, we all write the functions with return type as int,double but why we need return type as another class name e.g public class abc() { some code here } public abc functionname() { } why we want return type as name of the class also why we need the return type of function as an object any help......... Hi, 1. Person p = new Person(); 2. Person p; The difference between the two is that with the first, you declare a variable of type Person and instantiate it. The second only declares the variable but doesn't instantiate it yet. You can not request an object 's properties as long as it is not instantiated. Greetz, Geert Geert Verhoeven ...Show All

• Windows Live Developer Forums Dynamically load API JS file kills IE6

  I'm trying to load the veapi.ashx file dynamically, but I'm having a big problem with IE6, please test the following code out in IE6, you will need to clean your cookies and cache, to do that in IE6 you need to go to Tools --> Internet Options -->Delete Cookies & Delete Files.. and close all your IE, and start IE6 with these code.. <html> <head> <title></title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <script> var map=null; function include_js(file) { var html_doc = document.getElementsByTagName('head').item(0); var js = document.createElement('script'); js.setAttribute('type', 'text/javascript'); js.setAttribute('src', file); html_doc.appendChild(js); js.onre ...Show All

• SQL Server New to SQL 2005 Express

  I haven't used this software except locally on my laptop. If you have built a databased web app using this, how do you deploy the db Does it have to be installed and/or supported on your webhosting service If so, it seems to be of limited use, if not, very helpful. Thanks for the help Thanks Mike, My host doesn't offer mssql 2005 yet. They do have mssql 2000, and maybe(hopefully)some of sqlexpress2005 is backwards compatible. I can always generate scripts and run a query for db population on mssql 2000. I'll take a look at CodePlex. I appreciate the help! Terry ...Show All

• SQL Server backup operator

  I have to assign a group db_backupoperater permissions. Do they need any other role like db_dbwriter or dbreader I don't usually assign roles like this. Thanks Hello, This of course will depend upon what permissions you want the group to have. If you only want the group to be able to issue backup commands against the database in question, then db_backupoperater is all that is needed. Cheers Rob ...Show All

• SQL Server Problem connecting to external SQL Server

  Hi all... Very much a newbie here to setting up SQL server, and am pulling my hair out over a problem... I have a VPS running Win2003 64bit and have setup my ASP forum on it (I also have SQLExpress 2005 installed on the VPS) - I have a SQL DataBase running on an external server which my old host setup for me and the old forum has been using... Now all I want to do is for my ASP forum on my server to connect to this external SQL DB... How easy! Well not for me .. This is the error Microsoft OLE DB Provider for SQL Server [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied I know its my VPS causing the problem, as I asked a friend to see if he could connect to it via his server and the forum worked straight o ...Show All