bahadir's Q&A profile
Microsoft ISV Community Center Forums Making connection from one Access database to another.
I have a mdb file called the CustomReportsModule.mdb, and a Data.mdb file. I am trying to create a module within the Customom Reports Module to connect to the data.mdb (which is used only for data storage), and execute a select query. Then I want to create a table based on the query's results. I've been trying to use ADODB, but can't seem to really wrap my head around what to do. I have been searching the net, but haven't found what I think I'm looking for. Any help is appreciated -Thanks! I found my own answer, but can't remember where exactly. I know I found some in the help files in the visual basic editor, but also found some on the net when I searched for "adodb.connection recordset". Anyhow, I hope this he ...Show All
Visual Studio Express Editions How to refill a dataset?
I have this code in my vb.net program. Me.TickersTableAdapter.Fill(Me.DataSet1.Tickers) It fills the data from the external file fine. However, I'd like to be able to refill the data after it has been changed by an external program. Calling the line a second time doesn't work because I get "datareader already active on this command" error. How can I refill the data from the external file tia hi, as what ahmad said to retrieve data from database to dataset you use adapter.fill(), to save the changes back to the database from a dataset you use adapter.update(), so to refill your dataset you have to take 2 steps , 1) to clear it from data, 2) to fill it again from your database hope this helps ...Show All
Visual C# [C to C#] Send Structur with byte array from C# to C
hi, i have a structure : ------------------------------------------------------------------------------- [StructLayout(LayoutKind.Sequential)] public struct DRVBINFO { public UInt16 wCardsNumber; public UInt16 wChannelsNumber; [MarshalAs(UnmanagedType.LPArray)] public byte[] myIntArray ; } ------------------------------------------------------------------------------- i want to send this structure from a C# to a C function ------------------------------------------------------------------------------- [DllImport("LightMng.dll", SetLastError = true)] static extern uint LightMngInit([MarshalAs(UnmanagedType.Struct)]DRVBINFO DRVBinfo); -------------------------------------------------------------- ...Show All
.NET Development Returning an ArrayList from a WS to AJAX page
I want to return an ArrayList from a C# webservice to a AJAX enabled webpage and access it through Javascript. What is the best way to do this Do I need to serialise the ArrayList to an XML string and then loop through the XML using Javascript or is there a better way A better way might be to use a <List> from System.Collections.Generics. .Net 2.0 already knows how to serialize his datatype and it will sent as an array of objects. Also you can use atlas to geenrate the proxy javascript class for this see http://www.topxml.com/WS-web-services/re-51132_Understanding-ASP-NET-AJAX-Web-Service-Proxies.aspx ...Show All
SQL Server Drill Downs in the Report
I am working on a report in our application, when suddenly a design problem strikes me..how can i make the drill downs to be expanded initially if there is a record to show and not expanded if there is no record to show..is this possible in the reporting services 2005 any help will be highly appreciated..tnx in advance.. GOD bless us.. In RS , it is written like IIF(expression, truepart, falsepart).But it doesn't work. You should think like IIF(expression, falsepart, truepart) So you should write = Not IsNothing(Fields!task_name.Value) ...Show All
Visual Studio Tools for Office Cant debug
hi all i created a simple outlook add-in o project in vsto, i just typed Messagebox.show("hello"); on the startup event and put a breakpoint on this line, the appliaction cant debug this single line, i checked configuration manager , it is set to debug. can any body answer my question. in the Com adiin, i can find this addin, but why doesn't it work I re-installed VS2005, vsto, office . need help Hello, Could the add-in be disabled or have you already confirmed that it has not been disabled IIf it were disabled, it would still appear in the Com Addins dialog box, but the checkbox would not be selected. This topic discusses re-enabling a disabled add-in http://msdn2.microsoft.com/en-gb/library/ms268871(VS.80).aspx . ...Show All
SQL Server linked server problem
i linked to a remote server (sql 2000) using sp_addlinkedserver when i tried to insert data in a table in the remote server it is throwing the following error. i used transaction in the query. The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "server1" was unable to begin a distributed transaction. - Export Operation Failed please find me way thx in advance.. This is not a SQL Server Integration Services issue, so I have moved it to a more appropriate forum. Linked servers are in the are data access/engine not part of the SSIS toolset. The error seems a bit sparse, I would have expected a bit more about why it cannot create a distributed transaction. Since the distri ...Show All
SQL Server creating a new database in SQL 2005
I have been trying to create a new database in SQL 2005 and each time I do so, it brings tables in from other locations. Any suggestions Dave The Model database is one of the SQL Server system databases. It's used as the basis for creation of any new database on the server -- if you have a table (or any other object) in Model, it will be created in a new database as well. You can find it if you navigate under the Databases tab, to the System Databases. -- Adam Machanic Pro SQL Server 2005, available now http://www..apress.com/book/bookDisplay.html bID=457 -- <Dave U.@discussions.microsoft.com > wrote in message news:8cf6fea0-b89a-4c46- ...Show All
Visual Studio Express Editions setjmp.h(197) : error C2059: syntax error : '('
I found this error when I tried porting my project from VC++ 6.0 (32-bit configuration) to VC++ 8.0 project (64-bit configuration). setprop.c C:\Program Files\Microsoft Visual Studio 8\VC\include\setjmp.h(197) : error C2059: syntax error : '(' setls.c rpml.c C:\Program Files\Microsoft Visual Studio 8\VC\include\setjmp.h(197) : error C2059: syntax error : '(' crtbuf.c C:\Program Files\Microsoft Visual Studio 8\VC\include\setjmp.h(197) : error C2059: syntax error : '(' There are no using of setjmp() or longjmp() in those files that show errors. And this project can be compiled without any errors in VC++6.0 (32 bit) This is what I see at line 197 in setjmp.h: typedef _CRT_ ...Show All
Visual C# Exclamation Icon cursor in IDE
Hi, Anyone know why, when I load my c# project into VS2005, my cursor flashes as a exclamation icon (yellow triangle with black exclamation mark) This is very fast and may (or may not) do it every time. I can't see any obvious warning messages anywhere, everything appears to work. It's a real "did I just see that " thing - it's that fast, but it does happen quite often. Someone, somewhere, coded it to do that. It probably took some time to do. Shame it's not at all apparent why ! Indeed, weird. Perhaps you have any 3rd party tools/apps installed which could cause this behaviour. Don't know anything else... I recently experienced similar curiosities with UltraMon and Firefox (resizing/cursor issues with dual ...Show All
Windows Forms question of DoubleClick on ListView in C#,need help!!!
Hi, does anyone know to write the C# codes on how to create a double click event for ListView to delete/remove the item that i select from ListView control Edit: Very Good Aproach Here: http://msdn2.microsoft.com/en-us/library/ms172533.aspx Best Regards, Rizwan aka RizwanSharp There is no double click event in compact framework. You can do a trick by using a Timer. See this Post: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=732678&SiteID=1 I hope this will help. Best Regards, Rizwan aka RizwanSharp ...Show All
SQL Server "Attempted to read or write protected memory. This is often an indication that other memory is corrupt."
In SQL BI Studio, I'm adding a new named query to a data source view and consistently get the same error (I've tried restarting my session, etc): --------------------------- Microsoft Visual Studio --------------------------- Attempted to read or write protected memory. This is often an indication that other memory is corrupt. --------------------------- OK --------------------------- My named query looks like - select * from a, b where a.eventtypeid in (38,39) and b.auditlogid = (select top 1 auditlogid from auditlog ...) Is there anywhere I can pull any additional debug info so I can see what's going wrong Hmm, I worked around this issue by putting my query in a SQL View. Intriguingly, the SQL View de ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Installing C# Express Edition After VS2003/VS2005
I waited till the last minute to install C# Express, but I wanted to point out that the download page is potentially confusing. Yes, it says beta versions must be uninstalled, but immediately following it says that any previous versions of SQL Server 2005, VS2005 need to be uninstalled. The good news is that it will install without issue, but I wanted to post this as a recommendation to change the text. Uninstall beta versions Before installing, you must uninstall any previous versions of SQL Server 2005, Visual Studio 2005, and the .NET Framework 2.0 (this includes Tech Preview, Beta, or CTP versions). JR Nip wrote: And game Studio Express will only run with C# express. It cannot integrate with vs 2005 pro. The pr ...Show All
Visual C# best way to create an interface for multiple assemblies
i want to create an interface to share between some classes. i have an assembly that references 6 other assemblies. in each assembly there may or may not have a class that implements this interface. should i just create a new project with just the interface, build it, and have those assemblies that need to implement the interface, reference it. or is there a better approach Hi, I am not much clear about the question, can you please elaborate it a bit to explain what exactly you want to do using interface If possible try to post some code that can explain it! Regards, ...Show All
Visual Studio 2008 (Pre-release) ASP.Net does not identify .svc file
Hi, I've downloaded the dotnet 3 installs and have installed them. I also have installed the Visual Studio addons. The WPF demos run fine. I'm having hassles with WCF. I've downloaded the "Getting Started" sample. I've configured IIS to point to the folder that the sample is sitting in. When I browse the "service.svc" file with my browser I get the following ... @ServiceHost language=c# Debug="true" Service="Microsoft.ServiceModel.Samples.CalculatorService" % It seems that asp.net does not recognise WCF ( http://www.devx.com/dotnet/Article/29706/1954 pf=true ). From the link just mentioned I'm recommended to run xws_reg.exe to reinstall WCF. But I cant find xws_reg.exe anywhere on my machin ...Show All
