Gabriel Lozano-Moran's Q&A profile
Visual Basic calendar
how to I get the date selected by user in a calendar Mitch I am using the calendar and the user will select just "One" date I need to have access to that date.. how do I get it Need that string returned so i can use it in other calcls Thanks Mitch ...Show All
Visual Studio Master-Details Examples
Using the 2 Examples (From GotReportViewer.com) for generating Master-Details Reports using the Microsoft Report Viewer and Report Controls in ASP.NET I find I cannot get the Results Required either way!!! I can't say if I agree with either Method. For Example: Method#1: A view is Created the gets all the Required Data for Multiple tables and amalgamates the data into a single table and uses a list to Group the Data and Page Break accordingly. This method has 2 short-comings (Unless I am missing something). 1) Repetitive Data and 2) Page Numbers for the Groups. The Report will only allow page Breaks in the Report Footer Section so you can have Page Number for the Whole Report but NOT FOR THE Group Unless there is a formula o ...Show All
SQL Server Newbie: Am I really using Everywhere?
I just went through Steve Lasker's slide show on Everywhere (which was very informative) and noticed that when he setup the connection to the Everywhere database it had a .sdf extension. However, when I look at my database using SQL Server Management Studio Express it shows me as having the standard .mdf and .ldf files and *no* sdf file. I thought for a moment that I might be using Express but when I look at the connection properties of my (or what I think is my Everywhere) database I see: Product Name: Microsoft SQL Server Desktop Engine Product Version: 8.0.818 SP3 Instance Name: MICROSOFTBCM If I look at an Express database, I see connection properties of: Product Name: Microsoft SQL Server Express Edition with Advanced S ...Show All
SQL Server discover all permissions for a user
Hi folks, Is there any easy way of finding out, using a query, all permissions that a user has on any securable Also, what sort of permission (e.g. ALTER, SELECT, INSERT etc..) I'm going to hunt around on Google but thought I'd post here in case anyone can tell me before I find it. thanks in advance. -Jamie ignore this. select * from sys.database_permissions does me right! Doh! -Jamie ...Show All
Visual C++ Changing the size of an managed object array
I am making a CLR dll in C++; in which I have an array of a refrenced class. I want the end user of the dll to be able to change the size of array to suit their needs at the beginning; once its size is decided it does not have change again. Is there a way to do this I would appreciate any help. EDIT: If it helps, it is a static array, and it is declared in the main body of the class (but I can change it if needed) a such: public ref class Thingy { //methods, properties, and members } public ref class MyMainClass { static array <Thingy^> ^ ThingyArray = gcnew array <Thingy^>(10) ...Show All
SQL Server Hide empty tables
Hi, I've just creates a report with about 20 Tables. To my suprise, it almost runs as intended ;-) But there is one flaw - Is there any way of hiding an empyt table I want to hide all tables that are not filled with data. But wich one is empty differs from the entered parameter. So long Sven (Germany) YOu could set the NoRows property to an empty string, this would hide the tables and the header. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All
.NET Development Executing a query against Access and Excel
Hi, there I wrote a program that reads data from both Excel and Access. But I don't know how to submit a query to both of them. Connection to Excel is made through OleDb in code, and Access connection is made through Database Explorer, in design time. The question is: how can I make reference to these sources Thanks, Flavia Hi, Flavia Lemes wrote: How can I use this against both Yours, Flavia Do you mean on each of your connections Well, if that's the case just change the connection object on the second paramter of the OleDbCommand constructor (the code that I posted earlier). Change it to its supposed connections object. IF you want to query against your Access Dbase then use the conneciton for ...Show All
Visual C# How to create System.UInt32
I understand the SystemUInt32 is a built in struct in .NET, but was wondering how to make it. Specifically how to implement an implicit conversion that allows code like: UInt32 num = 5; How would this datatype be defined if I wanted to make something similar under a different name Thanks, wilf Do you mean you want to do something like a typedef in C++ This is not possible in C# butyou can do something similar with the "using" statement where you can create an alias for a type i.e. using System; using MyUInt = System. UInt32 ; namespace ConsoleApplication1 { class Program { static void Main( string [] args) { MyUInt x = 5; Console .WriteLine ...Show All
Windows Forms How to make verical scrollbar in gridview wider
Hi, I need to make vertical scrollbar in gridview and combobox wider because I am building a touch screen application. Any help or links will be appreciated. Control Panel + Display, Appearance tab, Advanced button. Select "Scrollbar" in the Item combobox and increase the size. This will increase the width of the vertical scrollbar for *all* applications, rarely a problem for a PC equipped with a touch screen. ...Show All
Visual Studio Express Editions Date Picker
I have got a form that has 3 date pickers tied to a dataset If the field is blank, how do you get the date picker not to display anything unless there is a date in the field Davids Learning ...Show All
SQL Server Dates in a SQL Command
hi, i have to return all the dates in a date interval, but they are not stored in a table. what i need is to calculate all the dates between 2 given dates. is it possible to do this in a SQL command thanks, levogiro. levogiro: One way to do this is to loop through a table of numbers. Here the table "small_iterator" is simply a table of integers 1-32767: declare @dayDiff integer declare @firstDate datetime set @firstDate = '12/1/6' declare @secondDate datetime set @secondDate = '1/3/7' select @dayDiff = datediff (day, @firstDate, @secondDate) --select @dayDiff as [@dayDiff] select convert (varchar (10), @fir ...Show All
Windows Forms Flash8.ocx does not work in VS2005 C#
Product Versions: MS .NET Framework Version 2.0.50727 MSVS2005 Version 8.0.50727.42 Macromedia Flash Player 8.0 r22 8.0.22.0 Definitions: FlashObj axShockwaveFlashObjects (flash8.ocx) Visual Studio Version: vs2003, vs2005 Language: C# This FlashObj works perfectly in vs2003 Fact/Symptoms Fail 1 1. I put the FlashObj on the Toolbox using "Choose Items" 2. With a new windows app I attempt to place the FlashObj on the form 3. I recieve an MSVS error: Failed to import the ActiveX control. Please ensure it is properly registered. Fail 2 1. I open a vs2003 c# app in vs2005 that already has the FlashObj on a form. This app runs good in vs2003. 2. After going thru the vs2005 conversion wizard 2. I can place another F ...Show All
Visual C++ desktop coordinate
Hi, I am currently writting a C coding compiled with visual studio 2005. The program should auto detect the screen resolution (height and width in pixel) of a desktop screen where the program run at. After detecting the height and width, i will be able to set the cursor to move in this boundary/region via " SetCursorPos" function. I not sure whether i am in the correct forum, anyone can help me with how to auto detect the screen resolution of a any desktop screen which my program runs in. Thanks alot Jas In order to obtain the screen size, try this: int width = GetSystemMetrics(SM_CXSCREEN); int height = GetSystemMetrics(SM_CYSCREEN); In order to obtain the de ...Show All
.NET Development Persistent storage and strong names
Hallo all I have a little problems with serializing to a permanent file storage. I have a complex data structure and I have to serialize compatible for future program versions. My program does its work. But when I activate strong names, after each compilation I cannot deserialize again. I suppose the version is serialized with the assembly. But I must have absolute compatibility over versions. Is there a solution Thanks Reiner Obrecht The binary formatter is, as you are finding out, always somewhat version dependent. The reason for that is that it is trying to do create an exact dump of an object graph's private state together with embedded hints for how to find the types required to reconstruct the object graph. T ...Show All
Visual Studio Team System Recommendations on approach with current 2003 VS Projects with Team System
We are going to be moving to VS 2005 with Team System. My question is whether it is recommended to attempt to move current VS 2003 projects that are in various stages to Team System and try to modify them to use all the new features of Team System (e.g. templates, tasks, etc...) or only use the full functionality of Team System on new projects and just use the source repository features of Team System on current projects. I'm new to Team System so I apologize in advance if this is a dumb question. Any advice or considerations would be appreciated. Thanks. Team System comes with many tools to simplify development, testing and management of project in general (project lifecycle tools) and it is not directly r ...Show All
