Batisse's Q&A profile

• Visual Studio Change a dataset connectionstring at runtime

  Hi, I have two databases having the same objects and an asp .net application that logs to one of them (depends on user login). The problem is the reports connection, because the user can be working in one of the two databases. I don't want to make two equal reports (one for each database) Maybe the best solution is to change the dataset connectionstring of the report dataset. How do I set up the report dataset at runtime Can anyone help me Thanks, At runtime you can set the database to query by handling the ObjectDataSource_ObjectCreated event, and then setting the Connection property of TableAdapter. ...Show All

• .NET Development Generic performance... benefit?

  Hi, in every article about generics is written that they improve performance because no boxing, etc. occurs. So I wrote this simple test code and was astonished that the non generic part actually performs a couple milliseconds faster than the generic part About 59.8 seconds for the generic and 59.1 seconds for the non generic (avg. of 10 runs). Am I missing something here [code] using System; using System.Collections.Generic; using System.Text; using System.Xml; using System.Collections; namespace ConsoleApplication6 { class Program { static void Main(string[] args) { string s = ""; Test<string> test = new Test<string>("hi"); DateTime start = DateTime.Now; for (int j = 0; j < 1000000; j++) { foreac ...Show All

• Visual Studio User session problem help

  Hi, I'm sorry if i post in wrong section.I'm new user of Asp.net. I have encounter user session & authenticated coding problem which need somebody hit and help. I failed to retrieve user name after user login. Meanwhile others function .aspx page which code same "bAuthenticated = Context.User.Identity.IsAuthenticated and Context.User.Identity.Name " all failed to retrieve the user information from database, either. there is not error display while i try launch aspx locally. All my application failed to work because "authentication" problem, i guess. Does anybody have any hit/idea if my below coding is wrong How authentication work together with web.conf The below code intend to display user name after ...Show All

• Internet Explorer Development IE 7 opening to Run Once page with error on it.

  I downloaded updates last week. I have been using IE7 for a while with no problem. I dwnloaded the updates. Now when I open my browser the page tries to go to http://runonce.msn.com/runonce2.aspx . There is an error reported for this page and it will not open up I get a blue screen. How do I eliminate this I have my home page set in the tools section but when opening it won't go to my home page until I hit the home button on the tool bar. I tried running IE7 with out add-ons. The run once page did not come up to open at all. The browser did not go to anything except a page that said that the add-ons were disabled. ...Show All

• Visual Studio Tools for Office Working with Excel Pivot Tables

  Has any body worked with Excel Pivot tables and VSTO Please reply me ASAP. Reza, see Chelvy's original question from July 7: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=537200&SiteID=1 ...Show All

• .NET Development Can I get interop attributes by reflection?

  In my project I have a large number of structs defined. Some of the fields are defined like the following [ MarshalAs ( UnmanagedType .ByValTStr, SizeConst = 128)] public String fifteenth; Is it possible through reflection to obtain the value of the SizeConst field Thanks in advance liam Try this: using System; using System.Runtime.InteropServices; using System.Reflection; namespace ConsoleApplication1 { class Program { static void Main(string[] args) { MemberInfo[] info = typeof(Test).GetMember("fifteenth"); object[] attr = info[0].GetCustomAttributes(typeof(MarshalAsAttribute), false); MarshalAsAttribute maa = (MarshalAsAttribute)attr[0]; Console.Wri ...Show All

• SQL Server How do you get the last modified date column in SQL Management Studio

  In 2000, the last modified date was show as a column when viewing the various database objects. So, after a long off-line session with a copy of a database, you could sort the query list, by last date modified, and script the recently changed queries to a file. It was very easy to see exactly what was changed recently. How do you do this in 2005 thanks lkh wrote: One other thought....SQL Server Service Pack 2 will be released soon. It has a new feature, Custom Reports, that will allow you to create a report based on any system object with the columns you want sorted the way you want and attach it to the node you want in Object Explorer. Books Online will have How-to infor ...Show All

• Gadgets Bad Ratings

  Can I suggest that people are prevented from giving ratings without leaving a comment. I want to learn why people are raiting my gadget badly (plus be sure its not just another developer trying to raise there own raitings) Ross Hi Ross and ljames28. We definitely understand this is an issue on Windows Live Gallery. Right now we are collecting more information from the rating service to understand what the next steps are. Thanks. ...Show All

• Visual Studio 2008 (Pre-release) svcutil and collections

  As I found here and also in several posts in this forum, it is possible to generate generic lists instead of arrays with svcutil. But I can't gettin it work! I try 1:1 the same call like in the mentioned example and get the error-message: Error: No type could be loaded for the value System.Collections.Generic.List1 passed to the /collectionType option. Ensu re that the assembly this type belongs to is specified via the /reference options My command: svcutil http://localhost/rms/rangemanagementservice.svc /r:"C:\Windows\Microsoft.NET\Framework64\v2.0.50727\System.dll" /ct:System.Collections.Generic.List`1 Thank you Dani very strange... I always tried the command in PowerShell - with the result I m ...Show All

• Visual Studio Tools for Office Outlook form region

  Dear All, I'm trying to create outlook form region to customise the outlook 2007 mail form - add a combo box that gets its data from sql server 2005 database - ; however I cant create even a basic form region. I searched a lot throgh the net and msdn but with no luck. All the samples that I try seems to be old, or was created for the beta VSTO or beta Office 2007. Kindly could you help me by a sample that creates a basic form region for outlook 2007. Another point: should I create xml manifest and registry file with the latest VSTO SE. I'm using: Windows XP Visual studio 2005 VSTO SE Office 2007. Thanx for your help. Emad. Hey Emad, Creating a form region isn't really a ...Show All

• Internet Explorer Development IE7 embedded webbrowser control and SWF/PDF files

  My app embeds a webbrowser control. One issue I notice after installing IE7 is that if I browse directly to a SWF or PDF in the webbrowser control, the page is blank. If I browse to an html page that embeds a SWF, it works fine. Browsing directly to a SWF or PDF in my embedded webbrowser control works fine in IE6. Am I missing a flag/setting when creating my webbrowser control BTW - I'm using WinXP SP2. If I browse to the SWF or PDF in standalone IE7, it works fine. MY application generates a PDF file, it loads the PDF shows the text I have embedded (token from a database) but is ignores the embedded pictures. It is a typical IE7 issue becouse when I load that page with Firefox or Opera ...Show All

• SQL Server Datafields in report header

  Hi. I want some information stored in the database to be shown on the top of each page in my report. But in the report designer I get an error message if I try to drop a table in the header, and if I try to assign the value of a textbox in the header to e.g. "First(Fields!sometable.Value)", I get a runtime-error in the preview that says "... Fields cannot be used in page headers or footers". How can I do this Regards, Tomsi Another way to do this is to have the Data you want displayed in the header to be retrieved into Report paramaters. Then the parameters can be put in the Page Header. Set up a Paramater for each piece of Data you require and retrieve into the Paramaters setting ...Show All

• SQL Server Detecting ODBC query timeouts

  Is there any way to set the timeout attribute for an ODBC query to something less than 65K and have it work properly Tried 30 seconds and got told to use 65K. Is there any way to cancel an ODBC query after a time has expired The queries are using stored procedures, not much data is involved, usually one record. If the connection is broken we do not get any type of notification and the call to the SP just hangs. We are using SQL Server 2005 running on Windows Server 2003, ODBC 3.x and the driver is SQL Server. Any help will be appreciated. ...Show All

• .NET Development C# Com Interop problem - should be simple!

  I have some trivial vb6 sample code that uses a com dll to interface to talk to some hardware but I can't seem to port it over to C# Interop successfully. I have tried many permutation of marshalling attributes but I get a "Attempted to read or write protected memory..." exception with types I believe will work and DataTypeError returned from the com interface function if I am deliberately incorrect with the types.   The com interface declaration in OLE Viewer: long RpcCall(long iJobCode, VARIANT SendData, [in, out] VARIANT * RecvData);   The sample in vb6: Dim n() as Byte Dim r() as Long n = StrConv("Time_s" & vbNullChar, vbFromUnicode) conn.RpcCall(10012, n, r)   The intero ...Show All

• Windows Forms asyccallback in child app

  hi, i've made an parent - child (4) app. in one of the childs (titeled: get data) i make an ethernet connection to an micro processor. when i have connection i send a string so the processor can responed and send the data i need. but receiving the data takes time, even when its only a minute, the user will see it. so i thought to receive the data asychron but i still remain with the waiting problem. the user most be able to do things in the three other child wile 'get data' is getting his data im not sure how to do this, i am formiliar with asynccallback, ect. because i use this to make my ethernet connection. so here is my problem in short: 4forms, 1 where data is beeing received and during this the user most be able to use the ot ...Show All