DanO84's Q&A profile
SQL Server Where to Get SQL Management Studio?
Hi Guys, I know my question looks very stupid but cant help. I got SQL Server 2005 Evaluation Copy along with Visual Studio 2005. I want to do some evaluation of Reporting Services. I am able to create reports from VS 2005 i.e. rdlc extension. and chaning the extension I can publish them to reporting server but I want to create reports with parameters which will be passed from UI form. On looking some resources i can to know that I will need SQL Server Management Studio to generate RDL reports. Where can i get Management Studio Do i need to download it or need to purchase it Thanks in Advance Hemant Hi, first of all, asking no questions is stupid for me, not the other way :-) If you ...Show All
Visual C# networkstream eventhandler
can anyone help me or advice me I am making an application whereby actions are done according to what is read from networkstream. considering that my application is quite big, i wanna reduce threads and one that i see can be reduced is the thread for scanning of data available in the networkstream. what i am thinking of is somekind of eventhandler whereby if there's a networkstream.dataAvailable then it will execute. here's what i did, private void OtherCode() { thread = new Thread(new ThreadStart(wait_for_commands)); thread.Start(); thread.Priority = ThreadPriority.Normal; } &nb ...Show All
Visual Studio Tools for Office Problem Saving Attachment's with the same (sent) file name. How to clear outlook internet temporary files?
Hi, I am sent an update file from a third party using email. They are not able to use FTP, and I am one of many users so their side of the system cannot be changed. The update file is attached and called update.txt, an outlook rule places the emails in . There is a maximum size that file can be (on the third parties side) which is about 10K. So if there are 300,000 updated items to send this equates to about 135K which results in 135 emails all containing an attached file called 'update.txt' and all sent at the same time. I Create a unique file name and save the file using .SaveAsFile The code for this is below. foreach (Outlook.MailItem UGM in TFILE.Items) { count++; foreach (Outlook.Attachment TFILE in UGM ...Show All
Visual Studio Team System FROZEN rule behaviour
When the FROZEN rule is applied to a field, it is still possible to select other values, but you can not save them. An error message "The value for field "foo" must be empty or the same as the original value" is displayed. Why is it still allowed to select other values If you do select another value, you will have to look in the history to find the original value before you can save any other modifications. Frozen field with a value is editable, although in a limited way - you can set it to an empty string. This is the reason why we did not make it read only. Thanks, Alex ...Show All
Visual Basic Device driver creation tutorial. Anyone please?
Hi, Does anyone know of a tutorial that would detail how i could create a device driver file in WinXP or Vista by using Visual Studio Pro 2005 please Basically i have a mouse with 5 buttons, left right, middle and 2 others. The other 3 buttons do not fire the middle or X-button events in VB.Net so how can i read the mouse port input to see what's going on etcetera to enable a driver to be created please By the way my mouse is an Airmouse with the middle button having a 4 way ( joystick like ) wobble on it for left-right and up-down scrolling. The default AirMouse driver does not work with Win XP. Regards, S_DS Ah exactly the type of thread i wanted. Ok some copy protections instal ...Show All
Visual Basic Standalone Executables in VB 2005 Express?
Is it possible to produce an .exe executable stand alone program in Visual Basic 2005 Express or is it intentionally hamstrung so as not to allow compilation but only to produce scripts for an interpreter Any help appreciated. All executable in VB.Net will require the .net framework to be installed. The .exe file it produces are actually IL (Intermediate language) which will be compiled by the JIT (Just In Time) Compiler when run. The compiler is part of the framework. So the executable are compiled (but at runtime) and all .NET applications whether VB or C# require the appropriate version of the framework to be installed - which includes the compiler (and has a free redistributable) ...Show All
Visual C++ Need to re-register???
I installed service pack 1 for Visual C++ the other day, and now im being told to register Visual C++, yet it is already registered is it possible to use the registration key I was using before, or do I need a new one hello I haven't really tried to repro this situation but it seems you do need to re-register with previous license, refer to: http://www.hauser-wenz.de/s9y/index.php /archives/219-Visual-Studio-2005-Service-Pack-1-Gotchas.html thanks rico ...Show All
SQL Server Clustered SQL Server freezes & restarts itself in Enterprise Manager
Hi, In our large organisation we have SQL Server 2000 running on a 2 node cluster using Windows 2000 Advanced Server Clustering. Each node has 2GB RAM. The server has about 10 databases only one of which is significant size at about 1GB. Our website accesses this database via ASP. The website receives between 10000-40000 hits per hour. The problem is that periodically (not necessarily during high load periods at all) this single database 'freezes' (not the whole server - the other databases seem fine) and refuses all login attempts from the website. This happened again on the weekend when the database was down for about 6 hours. When we go into Enterprise Manager and click on the instance, there is initially no activity for an unusual amou ...Show All
Smart Device Development Device ID Data Type
Hi All, I want to be able to uniquely identify a mobile device. I've discovered that devices have a Device ID but is only accessible via the Win API through PInvoke() calls. The article I found is here: http://msdn2.microsoft.com/en-us/library/ms172516.aspx PInvoking is not a problem for me. I actually found this article through a message board where someone actually had problems using it. 1) Is this article up to date and compatible with WM 5.0 devices Most Importantly 2) Is the device ID a GUID Or is it something else The article indicates it converts the final result into a string not a native GUID. This doesn't actually mean that the string doesn't contain a GUID though. I haven't run it through yet to see, but I do ...Show All
Visual C# With Statement With Word Automation
How do i change the With Satement in C#....can someone help me out...Take out the look at the code.... I have this code in VB.Net that takes my value in my textbox and writes it to a value in my MS word 2003 document but how do i complete this in C# here is the VB.net code and here is how i began to do it in C# [code language=VB] For Each rng In doc.StoryRanges With rng.Find .Text = "[name]" .Replacement.Text = txtname.Text .Wrap = Microsoft.Office.Interop.Word.WdFindWrap.wdFindContinue .Execute(Replace:=Microsoft.Office.Interop.Word.WdReplace.wdReplaceAll) End With [\code] [ code language=c#] doc = word.Documents.Open( "c:\\dee.doc" ); doc.Activate(); Microsoft.Office.Inte ...Show All
SQL Server Cannot access Stored Procedure
Hi I'm using SQL 2005 with Management Studio. I started having trouble accessing one particular scalar function today. I am able to run alter, drop and even exec commands against it but when I try to generate a script for it (or Modify it using Management Studio) I get the following exception: Syntax error in TextHeader of UserDefinedFunction 'sp_name'. (Microsoft.SqlServer.Smo) at Microsoft.SqlServer.Management.Smo.ScriptNameObjectBase.CheckTextCorectness(String ddlText, Boolean enforceCreate, Boolean checkName, String[] expectedObjectTypes, DdlTextParserHeaderInfo& headerInfo) at Microsoft.SqlServer.Management.Smo.ScriptNameObjectBase.CheckAndManipulateText(String ddlText, String[] expectedObjectTypes, ScriptingOptions so, Boolea ...Show All
Visual C++ Because com and DCOM is the old school ,it is not necessnary to study com and DCOM technology in vs.net platform? I want to kno
Because com and DCOM is the old school ,it is not necessnary to study com and DCOM technology in vs.net platform I want to know what is the replacement for COM and DCOM in .net. I appreciate your answer. How to create a .net object I know how to build a vc# windows application ,console application and asp.net program normally. Can you give me some links for me to know more about that I appreciate your help. ...Show All
SQL Server Casting...
I've got an ftp task that will be downloading a couple of files each night. today they're called blah20060830blah the date value in the middle changes each day. I'm trying to adjust this value with an expression. The expression doesn't want to cast my getdate function into a string that this property will accept. I know i'm missing something stupid. Thank you Maybe I'm completely missing the boat here. in an ftp task, there is a property called "Remote Path" As I understand, this designates what the path and filename of the remote file to be downloaded. Here's my leap of understanding. I want that value to change daily, I'm assuming that I can define this using an expression. I will concat the ...Show All
Visual Basic Auto Append and semi complete Form
I open a form with a Tableadapter to which I have created a query based on a field on the form which I populate from the previous opening form. This displays the results of a query which shows header records and a Datagrid view of the linked many transactions. (Like a simple Invoice Header and Transaction lines details tables) What I would like to happen, is that when no data is returned by the query, the form automatically appends a new record and fills in certain information (ie the Account) which is already known. This would be done in the onLoad event, but I do not seem to get the data to 'autofill' Any help or direction to look in would be appreciated. The MSDN help just seems to lead me round in circles (although I may ju ...Show All
.NET Development Problem refreshing datasource in RDLC file
Hi all.. I developed a local report to be viewed using Report Viewer control. That report is attached to an object data source. All works perfectly, but when I add other property to the object data source, that property appears in the data sources window (after I press refresh button), but when I edit properties of a textbox, and by expanding the Value combobox, the new field isn't shown. If I drag & drop the field from the data sources view, the Textbox Value appears to be "=First(Fields!NEWPROP.Value)". To solve the problem, I have to edit the RDLC file using the XML editor and manually add the new added field(s). After that, the field is added to the combobox and as the value of the TextBox I can finally use &q ...Show All
