Đonny's Q&A profile

• SQL Server What permissions to give Cluster account in SQL

  Hey guys. I'll have an active/active cluster and seperate accounts for SQL Services and Cluster service. The question is what rights should the cluster account have in SQL if I've removed the 'builtin admins' from SQL Thank you The cluster account must be in a domain group, which will automatically have previlege of "builtin admins". This is due to a security problem as "builtin admins" still not strong enough to protect cluster services. See BOL for more details. ...Show All

• SQL Server named set questions

  As I understand it, a named set is not processed until it is needed. Once these are processed are they cached for use by other client requests If there are Aggregations set up in the cube will this trigger the named sets be processed right away with the cube I assume that if a named set is too big there could be loss in performance, is there a way to hold down the size of a named set here are some examples of named sets i've created using some calculated members. perhaps there is a better way of doing this *************** Calculated Members*************************** CREATE MEMBER CURRENTCUBE .[MEASURES].[HP Plus Addl Billing] AS aggregate ([PREP CONTROL HDR].[Bill Formats].&[19],[Measures].[Billed Sales ...Show All

• Windows Forms Refresh DataSet

  Hi There, I have created a simple form containing a DataGridView. DataGridView displays the detail of an account from database. Details updates every 4-6 seconds in the database. My question is that how can I refresh the data displayed in DataGriedView every 5-6 seconds. And how can I retrieve the data into Dataset every 5-6 seconds from the database, which is DataSource for DataGridView control. Here is my code. ------------------------------------------------------------------------------------------------------------------------------ namespace DataGridViewSample { public partial class AccountForm : Form { public AccountForm() { InitializeComponent(); DataTable dataTable = GetAccountDetails().Tab ...Show All

• .NET Development CONFUSED

  I wanted to learn as much database technology as I could. I started with Access and learned some Visual Basic and SQL along the way. Meanwhile, I have been able to write a few programs that have made life much easier for my business, a few firends and my church. I feel it is time to improve myself but I am confused about Visual C++. Will I really gain much if I learn Visual C++ Will Visual C++ be an improvement on what I have learned so far Do you recommend something else VB is now old and unsupported, .NET is the new thing that has taken the world by storm. These forums for example, are created on the .NET technology using ASP.NET, you can develop .NET application for your Windows powered mobile device u ...Show All

• Windows Forms ProgressBarStyle.Marquee won't grow while task run

  Hello, I load a lot of data into a form (takes about 20 to 40 seconds). Before I load the data I open a new "wait" form with a progressbar inside. I do follwoing: frmwait2 = New frmWait Dim frmData As New frmData frmData.show frmwait2.progB.Style = ProgressBarStyle.Marquee frmwait2.Show() Application.DoEvents() frmData .loadData() 'Calls a procedure that loads the data frmwait2.Close() The frmwait control is displayed and begins to process. But when .loaddata is called, it stops working. I think the loaddata function slows down the complete application and so the progressbar can't process anymore. Have somebody an idea how to process with the progressbar while the data is loaded ...Show All

• Visual C# Recommendation

  Hi Guys Basicaly i am a MSCE and want to expand my horizons. so i decided i wanted to start programing and i have decided to start with C# it may not be the easist but i would like to start there. if anyone could give me advice were to start and which C# book would be the best for someone who has had little coding expeirence. Thanks Hi, Welcome to the C# world! This thread can help you: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1221320&SiteID=1 Thank you ...Show All

• SQL Server Which one is better?

  I have 2 tables A - having 118040500 records B(its temporary table) - having 1500 records. When I say select * from A where a.id in (Select b.id from B) A.ID is unique it takes almost 2 minutes to return data. How can I optimize this. Should I remove in with join Will it help Please suggest incase you have any other suggestion thanks in advance You should just experiment with it-try all alternatives and chose the best one. Generally, the server is having more alternatives choosing a plan when executing a join than a correlated subquery, so you might try this: Select A.* from A join B on A.fID=B.fID. I guess this join will work best when you have Clustered index on both A.fID and B.fI ...Show All

• Visual Basic List Folderames in a folder

  How do I list the names of all the folders inside another folder you would pretty much do a string parsing process: Dim theFolders() as String theFolders = Directory.GetDirectories( path ) for each currentFolder as string in theFolders Me.theListBox.Items.Add(currentFolder.SubString(currentFolder.LastIndexOf("\")) next that should do it hopefully. Another way would be: Path.GetDirectoryName(currentFolder) in the for each loop does this help ...Show All

• Visual C# form closing problem

  I could not invent a realistic title for the post since I do not know how to name that object. On the top border of every form there is a small button on the right that closes the form. It is next to Maximize/Minimize button. I wish I knew a special term for it. I want to prevent my form from having the option of being closed by pressing on it. I want to always close it via a custom close button. How can I do it The reason for this is as follows. I have a stream of records that accumulate in memory and when the number of rows in a DataTable reaches a certain threshold a portion thereof is being sent to SQL Server. About 2000 records remain in memory. When the process of downloading ends I may still have some records that are unsav ...Show All

• Visual C# Delete XML elements

  < RadioBar >   < Genre_Genre_Country > Genre_Country </ Genre_Genre_Country > - < Genre_Genre_Country >   < Title > KPIG presents Cowboy Cultural Society Radio - an American tradition since 2002 </ Title >   < url > http://205.188.215.232:8028 </ url >   </ Genre_Genre_Country > - < Genre_Genre_Country >   < Title > Classic Heartland - Classic Country, Western, Bluegrass, Alternative Country [Dial-up] </ Title >   < url > http://130.166.72.1:8008 </ url >   </ Genre_Genre_Country &g ...Show All

• Windows Forms Can't Create Deployment project

  I am currently using Visual C# 2005 Express. I want to create a deployment project for my application, but when I go to new project I don't have the option to create a setup & deployment project, so I can't create an installer for my application. Am I missing something on my side with the IDE or doesn't Visual C# 2005 Express support that function Thanks in advance. ...Show All

• Visual Studio Documentation Compiler - Sandcastle

  We did code complete of documentation compiler ( code named "Sandcastle") on June 15th and currently we are testing the tool building our .NetFramework documentation. We would like to release the CTP version of Sandcastle in Microsoft download center by next week. The perf in our testing has been great as we are able to build the entire framework content in less than 1 hour. I am in the process of going through final check and code signing required to post this in our download center. Please expect the CTP in the next week or so and I will provide an update here as soon I post the CTP. Anand.. Will source code be available I know this is a redundant question, but the way in which you've architected the application trou ...Show All

• Windows Forms Help in implementation of a magnifying glass

  I have an image viewer application which I want to apply a magnifying glass effect on certain area of the image. The problem I've run into is that when I slowly dragged the magnifying glass across (when left mouse down) the magnifying glass window didn't move smoothly. I believe it has something to do with drawing the graphics of the original image on the background. May someone please help me solve this issue Thanks. Okay, so what's "this.image" Sounds like a bitmap. magnifyGlass_Paint() will be very slow if that bitmap is not in PixelFormat32PArgb format and this.image gets large. If you get this image from a resource, copy it into a bitmap with that format and use that bitmap for all your pa ...Show All

• Microsoft ISV Community Center Forums Take out the ability to input values on combo box?

  How do I take out the ability to input values on a combo box For instaance, if I want the user to select the month ...Show All

• Smart Device Development application for send SMS

  Hi expert, Is there any source code or application created using VS 2005 standard edition that can use to send SMS to smartphone or pocket PC emulator .Can anyone out there provide me a link that can download this kind of application. Thanks in advance. Hi Ilya Tumanov, Can you please give me code or guide me how to send SMS from Desktop to mobile. How to proceed for this Is there any free webservice Thanks in Advance, ...Show All