JavaBoy's Q&A profile

• Windows Search Technologies WDS 3.0 Beta 2- Rebuilding index by itself and more

  Hey Guys, Brandon pointed this as the right place to post some concerns/issues with the WDS 3.0 beta 2 Few issues with WDS 3.0 beta 2: - When adding a new file extension to be indexed, WDS prompts to full rebuild of the index. This is a very bad behaviour especially, like me that has more than 100,000 indexable items. (anyway to avoid that ) - The WDS is rebuilding the index itself without any user intervention - The current pdf I-filter are not capable to index within the pfd files. - The configuration GUI interface still very rough, clearly need some refining. That's it for now. Thanks, Marcus   Marcus, We have testers working on these issues as I type.  I appreciate your offer to let us ...Show All

• SQL Server insert in row small chunks

  hi, i have a big table (120 million records) and i want to take all this table and to insert it into another table. since this BULK insert operation can make all kind of performance problem i would like to make the bulk insert via small chunks. the table does not have any idintity. can someone give me an exapmle with rowcount or with a loop to make each time an insert into select statment and to insert in each time for example 5000 rows. help is appriciated, thx, Tomer You can select a portion of data using the following statement select * from ( select startTime, row_number() over (order by startTime asc) as NUM from trace01 ) X where NUM between 99 and 200 If you have also to automate ...Show All

• Visual Basic Signing in Project Properties. Certificate. Certmgr. Makecert.

  I have an application that I wrote some time ago and have distributed it to several customers. Now that I'm looking at the project properties again I see that the Certificate experation date is 1/27/2007. Frankly, I have no idea about how and when the date was established nor do I understand any of this signing business. There are check boxes for the ClickOnce manifest and the Assembly on this page. My question is: will this application stop running on 1/27/2007 What do I need to do to make certain there that the application does not stop running at the customer sites Thanks, jerryk Hi, I did a "search files" on my PC for the word certificate under VS2003 as i have the MSDN library files in ...Show All

• Visual Basic Need help VStudio2.0 Deployment

  I used to use the copy project feature in VStudio1.1 to copy a files "Only files needed to run this application" option. Is there something similar feature in VStudio2.0 I have tried using the publish feature or copy website feature but they all copy all the not required files also like sourcesafe files and project files etc. Is there a good way to do the same thing as Copy Project in 2.0. I appreciate your taking the time to go through this post.Thanks a lot in advance. S Girase ...Show All

• Windows Forms programmatically find a row in a DataGridView and select it

  Hi There, I've got a DataView populated with data from a Table. The Table contains a PrimaryKey. With this DataView I populate a DataGridView and show all Columns except the PrimaryKey Column. What I now want is to find a row due to a given PrimaryKey Value. How can I do this without to iterate thorugh all rows and check the PrimaryKey from each DataRowView Thanks in advance... Greet Markus Okay, found the answer to the above. I just dropped a bindingsource on my form, and bound it to the adapter, and bound the datagridview to the bindingsource instead of to the adapter. Then I wrote this little sub to find a person's last name in the datagridview. Problem is, it only succeeds with the find ...Show All

• Visual C# Please help me confirm on windows service

  Dear All, I have a windows service which I need to run on particular time of a day. So I have build my windows service and add the code of my action of checking the database in the onStart function Is this correct or must I have a main function Another thing I have added is the debug.write I dont know whether it prints or not I done with installer and manage to successfully install my window service. So I dont know how to confirm if my windows service is running or not How can I set the time to be like specify for certain hours in a day eg. to run at 10 am, 12 pm, 2pm and 4pm daily Thanks. Dear Rizwan, About the timer I am confuse. Some articles say use Timer some say use Timer.Th ...Show All

• .NET Development Secure Webservices

  HI, I have created a simple Webservice with Add operation it..I have made IIS5.1 SSL secured.I have " Require Secure Channel" option enabled in it.Now when i accesed the webservice using https in browser i get "Page cannot be displayed" error. I turned off my windows firewall but no use.Also i looked into browser settings for https connection,it didnt helped me.Can anybody bail me out of this Thanks Venkat Hi Nathan, Thanks for your quick response.No page is workingwith https.If i uncheck "Require Secure Channel" and try acessing with http it is working fine. Thanks Venkat ...Show All

• SQL Server Service Pack 1 -- account information could not be verified

  When installing Svcpack 1 ontop of my 9.00.1399.06 RTM Developer Edition I get the following error everytime: --------------------------- Invalid Login Information --------------------------- Your account information could not be verified for one or more instances. Ensure that you can connect to all the selected instances using the account information provided. To proceed further deselect the instances to which connectivity cannot be established. --------------------------- OK   --------------------------- I have followed all possible suggestions on the following post http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=358003&SiteID=1 but nothing works.  I'm running as the local admin on t ...Show All

• SQL Server use of CASE in script

  I have been working on a job that is supposed to do the following: 1) Imports last name, first name, date of birth, ssn, medical record number, and enterprise id from TAB seperated text file an example of the format would be ENTID<tab>LAST<tab>FIRST<tab>DOB<tab>MEDREC<tab>SSN 2) Looks up the person in the import system and inserts a primary key value that represents the person into another table, along with some id numbers representing the system the file originated from. This is to identify people in one system that have been in the other as well. I have been working on a solution that imports the text file to a new table, then a cursor that reads each record, looks up the person, and then inse ...Show All

• .NET Development Changes made to multiple tables

  Hello all, This may sound rather silly (a newbie question...), but is there a way to have more than one table in a dataset, and to have the dataAdapter updated afterwards with changes that were made to all tables If not (as I believe would be the case), what is the easiest way to go about this Am I obliged to create a dataAdapter & dataset for each table if I wish to minimize the usage of dataAdapter.update dataAdapter.fill methods (initializing/filling the Dset & Dadapter upon Form load, then having a certain point to update, instead of updating with every click event and the likes..) Hope this was coherent enough , thanks for any answer.. Here's what I've done- I've got one DataSet and one DataAdapter (da) with a select co ...Show All

• Windows Forms filter out some excel data and display it into datagridview

  Hi, I need help in filtering out repeated rows in excel file and display as 1 row only in datagridview. For example: my excel file will be: Company || Origin || Destination || Airline || Rates || A || XXX || YYY || SQ || 250 || A || XXX || YYY || GA || 300 || B || XXX || ZZZ || GA || 350 || So datagridview1 will contains these 3 columns, Company, Origin and Destination. Company || Origin || Destination || A || XXX || YYY || B || XXX || ZZZ || Please help me as I'm very new to .Net languages. Thank you very much in advance. ...Show All

• Software Development for Windows Vista Bugcode_USB_Driver error w/USB devices attached

  I just completed installing Windows Vista RC1 on a VMWare 5.5 machine, and everytime I power down Windows Vista when USB devices are attached, I get a BSOD with the Bugcode_USB_Driver error. If I remove the USB devices before powering down, which include a Intellipoint Explorer wireless mouse and a portable storage devices, the BSOD/error does not appear and system shuts down just fine. The following message appears during subsequent startup. Problem signature: Problem Event Name: BlueScreen OS Version: 6.0.5600.2.0.0.256.1 Locale ID: 1033 Additional information about the problem: BCCode: fe BCP1: 00000008 BCP2: 00000006 BCP3: 00000009 BCP4: 837DD5CC OS Version: 6_0_5600 Service Pack: 0_0 Product: 256_1 I get an "Access Denied" e ...Show All

• SQL Server Hosting SQL Everywhere In a Windows Service

  The Sql Mobile site on MSDN recommends that you do not host SQL Everywhere when running as a service. Is this a recommendation, if so why, or is it simply not possible. My understanding is that when hosteed in a IIS hosted application a not supported exception is throw. If anyone has any ideas on this or pointers to some resources i would appreciate them. Thank You At present we have blocked hosting Microsoft SQL Server Everywhere Edition under IIS (by default). This is not a officially supported scenario. There are few techinal + business jsutifications behind this decision. You can get it working under hosted environment, but it is not officially supported. After Microsoft SQL Server Everyw ...Show All

• Windows Forms how to use configuration file with multiple info

  Hi, I've been working on configuration file with appsettings. I want to convert to config file from the code shown below; newParser.AllowedExtension = new string[] { ".aspx", ".xml", ".html", ".htm" }; // note that AllowedExtension is string array I this case, there are 4 elements in string array. I don't know how to store 4 elements into configuration file. I know the file should include add and value keywords. Ideally, I want to convert the code shown below instead; newParser.AllowedExtention = ConfigurationManager.AppSettings["extentions"]; // add using System.Configuration namespace I appreciate your help. I still cannot accsess to C ...Show All

• SQL Server Checking Job Status using T-SQL

  Hi. How can i check the job status using SQL Query Raja, I meant If the job (last execution/historical) executed successfully or not..From the above query.. KangKang, use RUN_Status column to find the status 1=Executed Successfuly 0=Failed with error When Failed you can find the details from the Message Column ...Show All