Chronusus's Q&A profile

• .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 Well actually it is possible to include both Access and Excel in the same (heterogeneous) query although it still isn't clear to me what needs to be accomplished. Are you trying to provide a join between the data from each data store I think we just a need little more information as to how Access and Excel are being used together. OK, I'm editing my message here after looking at yo ...Show All

• Visual Studio How can I pass parameter .......

  Hi in Form1(using c#.net) I have a CheckBox Control . I want to display all of the record of specified field , form e.g. "FirstName" field of table, When I Checked CheckBox1 . I wrote this : public bool Chk1; ... private void btnShowName_Click(object sender, EventArgs e) { if(CheckBox1.Checked) Chk1=true; sqlconn.Open(); da = new SqlDataAdapter(strQuery, sqlconn);//da is SqlDataAdapter SqlCommandBuilder scb = new SqlCommandBuilder(da); da.Fill(DS.MyTable);//Ds is a DataSet crystalReport11.SetDataSource(DS); //definition Parameter for CR ParameterField paramfield = new ParameterField(); ParameterFields paramfields = new ParameterFields(); ParameterDiscreteValue discreteval = new ParameterDiscreteValue(); paramfield.Name = "fieldName"; ...Show All

• Windows Forms ClickOnce just reboots PC with no warning, why?

  Hi, I've recently tested the deployment of an application that I have been working on. After a bit of fiddling and Googling. I have managed to get it successfully installed on a number of PC's, but one PC just reboots when the download is 100% complete. There is no server_deployment_log to refer to and no error messages displayed so I am at a bit of a loss as to what to do. I have tried uninstalling the 2.0 Framework and deleting the Apps folder etc, but it still reboots at the same point. Note: It does install the 2.0 Framework OK as a prerequisite (if needed - I've tried it with and without it already installed). There are no other prerequisites defined in the project for it to be failing on so... can anyone offer any thought ...Show All

• Software Development for Windows Vista Host WF in Client applcation

  Is it practical the host WF in Client appliaction for ad hoc changes Lets say my client application has its own business to do. but its behavior can be change at runtime by some sort of controller. can i host WF that listen to that change event and make the changes on the fly not sure if this is overkill or misuse of WF anyone can advice me that what is cost of hosting a WF Thanks advice. Thanks for the answer. I was actualy asking how expensive to host WF in my client application. in another word, what is the best and worse case to do that. as i know, WF is good for long running activies. but in my case, i only have one or two activies in the WF and they do nothing but listen to changes ...Show All

• Visual Studio 2008 (Pre-release) XBAP distribution

  Hello, There is one item that has caused me some confusion and that is XBAPs and WPF/E applications. I understand that XBAPs provide more functionality. However, my question is, can you run an XBAP on a Windows machine through Firefox Or must an XBAP run within Internet Explorer Thank you, Alan XBAPs must be launched within Internet Explorer. A workaraound is to install the IETab extension on firefox and add a *.xbap filter in the IETab options dialog. While you’re at it you can also add the .xaml extension to handle Loose XAML the same way. Simon ...Show All

• SQL Server Unnatended uninstallation

  Does anyone knows how to Uninstall SQL Server Express from command promt in unnatended way I've already achieve the unnatended Installation but i try the reverse steps to uninstall and they didn't work. Any information wolud be helpful I've already tried that but two things happen, if the " are closed after setup.exe as you tell me an error message appears idicating that that the modifier is not valid: "qb", in the other hand if the " are colosed before setup.exe for example "C:\Program files\Microsoft SQL Server\90\Setup Bootstrap" setup.exe /qb REMOVE=ALL INSTANCENAME=SQLEXPRESS a message appears indicating that for Installing and configuring system components you must ...Show All

• SQL Server CalendarTransform

  when trying to install the calendarTransform component i receive following error: the command "....\..\regcomponent calendarTransform" exited with code 1 any idea what it means   KirkHaselden wrote: It would help to know what the calendar transform component is. http://www.microsoft.com/downloads/details.aspx familyid=e603bde7-44bb-409a-890f-ed94a20b6710&displaylang=en ...Show All

• SQL Server VBA and 64-Bit

  In my search why the Instr function doesn't work, I found out that not all VBA functions are supported on 64-bit machines. Can anyone give me a list of VBA functions that are available for 64-bit Or an alternative to my issue. I'm trying to find a string, like 'arts' in field. I have SELECT NON EMPTY { [Measures].[Search Count] } ON COLUMNS , NON EMPTY { ([Date].[Date Value].[Date Value]. ALLMEMBERS * [Course Type].[Course Type].[Course Type]. ALLMEMBERS * [Higher Education Providers].[Higher Education Providers].[Higher Education Providers]. ALLMEMBERS * [Course Search Name].[Course Search Criteria].[Course Search Name]. ALLMEMBERS * [Award].[Award].[Award]. ALLMEMBERS * [ASCED].[ASCED Code].[Detailed ASCED ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Directsound: Read buffer to display data contained within

  Hi I am very new to directx and am trying to create an app in C# using MDX i have been coding c# for about a year though. I would like to create a program in which I can view the 'waves' of a wav file but am having considerable problems finding any examples of this sort of thing or anything that might lead me towards my goal. I have looked at the following helpful articles and many more that proved not so helpful: http://del.icio.us/e_mpika My aim is to read all the data that is held in a static audio buffer and then loop through it and obtain the value for each samples left and right channels, with this data i will then be able to plot it in a bitmap or somthing. my question is then, how do i utilize the SecondaryBuffer.read() function I ...Show All

• Software Development for Windows Vista Question related to UAC

  Hi, I have question about UAC What I understand is that any software program is excuted in User Mode in Windows Vista even though the user loged in as Admin To execute software program in Admin Mode as in previouse OS, I should mark XML using the executing software program's manifest and get the user prove in the middle of program execution, then the mode will be changed to Admin mode I'm developing the system management program which must utilize all of Vista system resource I have marked XML using manifest in the program and register this at HKCU...Run registry key after registration, automatic execution does not occure. I expected that the user is asked to change mode every ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Will XNA Game Studio Express support multiplayer?

  Please, please tell me that XNA Game Studio Express will support multiplayer... Singleplayer games are fun, but multiplayer games are 10x as fun. You are right. I haven’t thought about this kind of multiplayer even if I had build such multiplayer games in the past. ...Show All

• Visual C++ ERROR MESSAGE

  well i am a naive at vc++ and prcticing my hand on small problems like finding a factorial,string operations etc.But the problem with visual studio is that many a times when i run an application it gives the following error: This application has failed to start because MSVCP80D.dll was not found.Reinstalling the application may fix the problem. I'm tired of this error.and i don't know how to send you the picture of error to you[i'm naive please forgive me!!!) i think this error occurs generally when some decision in the program is compiler dependent. please help me out please!!!!!!!!!!!!! no i am not trying to install and run my application on a different machine. just read my first post and you will understand wh ...Show All

• Visual C++ hangman project

  Hello, I'm somewhat new to C++. I am taking a class on it in college, but the teacher doesnt like to explain things very well. Basically her idea of helping us learn C++ is this: "this is how you start all your programs in this class: #include <iostream> using namespace std; int main() { } " She never explainted even what "#include <iostream>" or "using namespace std;" ment. So, this brings us to my question. I'm trying to write a c++ program *for a project in class* that is a hang man game. The hangman is stored in a character array. The user is able to input a word into a 25 character array "char word[25];". There are a couple of things I need to do. the first thing is, I need to know h ...Show All

• Visual C# Concat two strings

  I got two strings....string1 and string2 and want to show a dash "-" between them so i did it like so string1 + "-" + string2... but i dont think that works.....can anyone point me in the right direction. I need to get two strings concatanated with a dash - separating them..... you can do this: string finalString = String.Concat( string1 , "-", string2 ); or string finalString = string1 + "-" + string2 ; or StringBuilder theBuilder = new StringBuilder(); theBuilder.Append( string1 ); theBuilder.Append( "-" ); theBuilder.Append( string2 ); MessageBox.Show(theBuilder.ToString()); do any of these work for you ...Show All

• SQL Server problem with sql mail (sql 2000)

  Hello, I have a problem with sql mail. I have to install mail notification on more than 10 servers. They have bunch of SQL servers with different combination of OS and SQL Server: WIN 2000/SQL 7.0 WIN 2000/SQL 2000 SP3, SP4 WIN 2003/SQL 2000 SP4 - 2 servers We use Novell GroupWise for our company email system and don't have Exchange server. So on every server I installed Outlook and created profiles to use in SQL Server. All except one were succeed and we can use email notification through alerts, use xp_sendmail st.proc. But I cannot create the same on one of them (WIN 2003/SQL 2000 SP4). I compared installation process with another server with the same OS/SQL configuration and it was the same. I can send email from server outlook with ...Show All