Axe22's Q&A profile

• SQL Server RB - New table info didn't show up on the Report Builder report

  Hi All - I'd like to add some more info to an existing RB report by adding a new table. I am able to add a new table to DSV and build relationship. I am also able to add the table to report model as a new entity and source fields. The report model gets rebuilt and redeployed without problem, and the old report still runs fine. But when I open the report in report builder and want to add more info, the new table/entity/attributes are not showing up at all. A report that already contains data displays the entities related to the data already in the report. If your new entity is not related to the data in the report, you will not be able to select fields from that entity and add them to your report. If the en ...Show All

• Gadgets Gadget for my site...

  I would like a gadget for my personal site that would be able to pull dynamic content from a message board and list the 'hot topic' or top 5 topics in a seperate little window when you click the gadget. I click it...the window opens...and the selected content is displayed... Thanks, Chris This are both VERY nice and exatcly the type of stuff I am talking about. I will get with my other web guys and discuss a few things and would love to get with you for some help... THANK YOU! Chris ...Show All

• Visual Studio Express Editions using VBE across a LAN

  Hello! What I have done so far I have just taught myself some VBA where I produced a module inside Excell on my own P.c that displays some statistics from an SQL database held separately on on a server on the LAN (Using a connection string to the SQL Database ) T he Excell file is in use also by other people in my company who have it locally and produce the statistics and reports thanks to the connection string that I refer to above to the remote SQL database. (It works quite well but managing data and displaying the results in a worksheet are quite like knitting jelly) What I want to do next I want to move on and learn VBE and I am wondering about something which is ; I know that I can probably u ...Show All

• SQL Server "Creating a Mobile Application with SQL Server" Tutorial Problem

  I am attempting to go through the "Creating a Mobile Application with SQL Server" walkthrough found in the SQL Mobile Books Online help file. Towards the end of this document (under SQL Server Mobile Tasks), they show how to create a new subscription. Unfortunately, after step 10--when you are asked to click finish--I get the following error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect. HRESULT 0x80004005 (29061) ------------------------------ One potential area of concern is in setting up the w ...Show All

• Windows Forms Disable repair option

  Hi, I am creating a windows installer using Visual Studio 2003. When I run the setup.exe again after installation the user has the option to repair the installation; if they choose it the installation gets run all over again. This could be fatal. Our installation process could corrupt the database if it gets run more than once. Is there a way to disable the repair feature Or, is there a way for our custom actions to know that installation is being run a second time so that they can ignore it Thanks. McGeeky Put a condition of Not Installed on your custom action. Installed is a case-sensitive property that is set if the product is already installed. During a repair the product is installed, so a N ...Show All

• .NET Development how to read and update an xml file

  I have an xml file with the follow fields: <name> John Doe </name> <city> XYZ </city> <zip> 88888 </zip> How can i update for example the zip code to 99999 without affecting other fields Use System.Xml.XmlDocument and load the XML. Then you can use XPath with SelectSingleNode or SelectNodes to find nodes (e.g. //zip) and e.g. elementNode.InnerText = "99999" to change the contents of an element node found. ...Show All

• SQL Server Incremental cube processing

  I'm trying to use the "Process Incremental" option when processing a cube in SSAS 2005. There are about 100million records in the fact table, but I'm only interested in the most recent 1.5 mil that were added last night. It's acting like a full process because it's reading all the rows in the fact table and not the ones most recently added. Do I need to specify (in the config options) a query/table that only points to the new rows It appears that is the case, but if it is, it's not really documented in the GUI or the online help. Any insight is appreciated. Thanks, Doug I am using this query to capture the changes in an oracle db, but it does not work. When I execute the sql an ...Show All

• .NET Development phantom "=" signs?

  I have an xml reader thats reads an xml string onto it, this works fine but when i try to call the individual elements to enter into my database using an sql string some of them have the = character in them. They seem to have appeared from no where any ideas string before: "<Client><ID>WEBCLAFFKD722164086454497T</ID><DateTimeAdded>10/30/2006 13:51:00</DateTimeAdded><CompanyName>Test</CompanyName><Position>Test</Position><Title>Test</Title><FName>Test</FName><LName>Text</LName><EmailAddress>test</EmailAddress><Telephone>85763866733</Telephone><WebSite>test</WebSite><Mobile>06987354266</Mobile> ...Show All

• Visual Basic numericupdown problem

  How to make a numericupdown control to have the range between 10-2000 in step of 10...and 2000-9900 in step of 100 the code bellow worck's, but with one bug....for eg, if i have 2000 value....and i go down...he go on 1900 value...and i want 1990(if i go up again worck's fine) is posible to make that i search an event ho tell'me in witch way i'm click(up or down)...but i don't find...so, please help'me. tank's (p.s.:the value 1900 is correct...but the value 2010 is not correct....) Private Sub NumericUpDown1_ValueChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles NumericUpDown1.ValueChanged If NumericUpDown1.Value >= 2000 Then NumericUpDown1.Increment = 100 End If If NumericUpDown1.Value < 20 ...Show All

• Visual Basic Write data in VB.NET to Access using SQL

  Okay, I have an Administrator page that is able to create new users. I have a simple adduserform that has a TabControl added in it with a tab for General Info and User Info. Those have quite a few texboxes for input and outside of the TabControl are 3 buttons that are Save, Clear, and Exit. What I want to do is have the Save write the data to my small database that I have for users. If you want to see an example of my screen you can see it here.... http://redbearcustoms.no-ip.info/VB/adduserform.html ahmedilyas wrote: Dim theOleDbConnection as new OleDbConnection(" ConnectionStringHere ") Dim theOleDbCommand as new OleDbCommand("INSERT INTO [tableName] ( field ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Shader Versions

  I'm currently reading Wolfgang F. Engel's ShaderX2 Introductions and Tutorials with DirectX 9. So far, all SM 3.0 examples are written in asm. Is SM 3.0 supported by XNA And can it be written in HLSL Thanks. -Nick XNA supports all the DX9 shader models on Windows (1.1, 1.3, 1.4, 2.0, 3.0). On Xbox it supports shader model 2.0, plus an extended Xbox-customised variant of 3.0. All of these can be written in HLSL. ...Show All

• Internet Explorer Development W3C?

  Hey, This is actually just a question, since i couldn't find the information, i would like to try the forum. My questions sounds: Are the new Internet Explorer 7 using the W3C validation without any specifications that makes html pages "tilt" and look clumsy in browsers than IE (currently thinking on Firefox, Netscape etc.). Best regards Michael Nielsen Michael, I'm sorry, I didn't quite understand your question. Can you rephrase, please If you're asking about WC3 compliance, many posts on the IE blog on MSDN describe the team's forcus and goals for compliance. Perhaps one of the posts there would answer your question. I can say that there were changes to the way IE7 handles certain CSS rules and features, especi ...Show All

• Visual Studio 2008 (Pre-release) use UserControl

  Hi all am new here and am teaching xaml, but I have problem *can anybody tell me how to use the userControl that I have made *and how to call webservice thnx for help 3- does it make a difference if I change the xbap project's security zone from (Internet) to (Local Intranet) Actually the security restriction imposed on local intranet is less vigorous than that imposed on Internet, in particulars, by default the IO and UI related permissions are all implicitly granted to code loaded from the local intranet. I don't know if XBAP will impose its own security restrictions, but AFAIK, the default security configuration for CLR is that I described above. Sheva ...Show All

• Visual Studio Tools for Office Word 2002 Resources

  Hi, Does anyone know any good resources for Word 2002 development I'm guessing that I can't use VSTO if I'm using 2002 or can I Thanks in advance, M no, you can't use VSTO... Other than that, you can automate Word 2002 pretty much the same way as Word 2003 (except for things that were introduced in the later version). That means, any information you see about working with Word 2003 will basically be the same for Word 2002. For questions about how to work with Word, in detail, I recommend one of the Word newsgroups. For automating Word using a .NET language, ask in an office.developer newsgroup. You'll find links to these groups/interfaces in the Please Read First message at the top of this for ...Show All

• .NET Development InferTypedSchema (DataSet.ReadXml)

  http://msdn2.microsoft.com/en-us/library/ms135419.aspx If you use DataSet.ReadXml to pull xml data into a dataset, will specifying "InferTypedSchema" look at the actual data and try to assign type information I have datetime data that is being pulled in to one of the datatables after performing ReadXml on a DataSet. However, the column type is still being set to string. All values are being read as string. Help According to the link below, it should work for "simple types" or schema simpleType values.   http://msdn2.microsoft.com/en-us/library/kezd4ydc.aspx However, the date values that are in my xml data are in date / time format such as 2006-09-05 09:26:25 Thats probably why its not workin ...Show All