Daikoku's Q&A profile

• SQL Server covering indexes

  Hi, I asked the similar question before but I have again some doubts about covering indexes. Besides, tomorrow I have a Microsoft MCAD 70-229 exam so please help me. In here, SELECT * FROM Order WHERE OrderID > 12 ORDER BY OrderDate we create composite nonclustered index for both OrderID and OrderDate column. Leftmost is OrderID. So when our first research is happening(Where clause), the only nonclustered index which is used is OrderID index. And then, when we pass through the second search( ORDER BY clause ), OrderDate index become activated. So we can say that the seleection of indexes in composite indexes is determined according to the situation of the quer ...Show All

• SQL Server Data Conversion Error on Excel Destination

  I am inserting rows using OLEDBDestination and want to redirect all error rows to EXCEL Destination. I have used Data Conversion Transformation to Convert all strings to Unicode string fields before sending it to Excel Destination. But its gives the following error. [Data Conversion [16]] Error: Data conversion failed while converting column 'A' (53) to column "Copy of A" (95). The conversion returned status value 8 and status text "DBSTATUS_UNAVAILABLE". [Data Conversion [16]] Error: The "output column "Copy of A" (95)" failed because error code 0xC020908E occurred, and the error row disposition on "output column "Copy of A" (95)" specifies failure on error. An error ...Show All

• .NET Development InnerXml property generates blank namespaces

  Hi, I've got some problem while generating some Xml code with the InnerXml property. After doing "myNode.InnerXml = ..... ", my Xml code has som blank "xmlns" attributes in the node added by this way. Here's an example : XmlElement destNode = doc.CreateElement( "destination" , XPath .JOB_NAMESPACE); XmlAttribute typeAttr = doc.CreateAttribute( "xsi" , "type" , XPath .SCHEMA_NAMESPACE); typeAttr.Value = BROADCAST_OUTPUT_TYPE; destNode.Attributes.Append(typeAttr); destNode.InnerXml = "<listenAddress type=\"string\">Automatic</listenAddress>" + "<listenPort type=\"uint\">" + bOutput.Port ...Show All

• Visual Basic Setting Authentication to multiple pages

  How do one set authentication for mulitple pages for an administrator using Login Function in Vb.net using vb language Is this a Forms project or a web developer project If it's forms, then you can simply maintain a login/authentication variable nd check it with each form (or a variation of such). If it's a web project, please refer to the http://forums.asp.net for answers for such questions. You also don't need to multipost the same question across similar forums. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Vector maths methods...

  Following a long day of writing and debugging some nasty rigid body physics code, and feeling the pain of the maths library I have to use for this C++ work, I thought I'd take another look at the XNA maths code to see if the results would be more readable (as you might hope ;). ... But my quick look at the framework docs seems to show more deficiencies than in the code I have been using all day... 1/ There is no Point3 class. This is a real pain as libraries that don't distinguish points and vectors are a right pain - transforming a point by a 4x4 matrix will result in a different result to transforming a vector. (And I don't want to resort to coding every point/vector as a homogeneous coordinate either!). There appears to be a ...Show All

• Visual C++ error -1073741819

  I got this error when running two Visual Studio 2005 sessions and compiling C++ code in one of them. Visual Studio crashed several times. Worked well when I was only running one session at the time. Lars ...Show All

• Visual Studio How-to: create a custom tool that runs directly against a model file

  The T4 engine that ships with the DSL tools gives you a flexible way to generate text output based on the contents of a model by running a custom tool against a template.   However, in a production environment, you may not want a user of your designer to have access to the template. You might prefer the user experience to be more like that provided by the Microsoft dataset generator, where the custom tool runs directly against the model file, rather than against a template.   This is very easy to do using the May release of the DSL tools.   1) Create and test your template as normal, but then put in a placeholder in the directive where the name of the model would usually go e.g. “%MODELFILENAME%”.   2) ...Show All

• Smart Device Development mobile application problem

  Hi. I got problem with mobile application. Every time I try to access the web using: request = ( HttpWebRequest ) WebRequest .Create(requestUri); response = ( HttpWebResponse )request.GetResponse(); I get the message: FileNotFoundException From the GetResponse() command. If I use the same code to produce regular windows program everything works fine. Do you have any idea what cause that I wrote a simple project with the problem. If you need it to help let me know and I'll e-mail it to you. I didn't find any way to attach it here... :-( Best regards, Amit. B.T.W. Some thecnical information: I'm develpoing with Professional Microsoft Visual Studio 2005 (Version 8.0.50727.42 (RTM. ...Show All

• Windows Forms bindingsource with objects

  hi, how do i go about saving to my table - + inserting records with a dgv connected to a binding source, which is connected to a list of objects. do i need to keep an original list for comparison how will i know which records changed or have been added or removed it is not quite a well defined pattern( in my mind) for now. please enlighten. I am building windows application and isnt all this stuff for the web xml soap etc. my usage of business object was solely to be able to have my bills, which is such: one record is broken into multiple records in the table., that is vat and amount and duty are seperate records, but form 1 bill. thus, when i display, i use stored rpocedures to get the data on one row, and u ...Show All

• Visual Studio report showing event

  Any one knows what event fires when the report is done loading and finaly showing in the viewer I want to show a button only after the viewr is full of results. Hi Ofer, Unfortunately the AfterRender event is only available in the web form viewer. The WinForm CrystalReportViewer control does not have such an event. Sorry, - Dave ...Show All

• Visual C# Easy way to copy a DataTable

  Is there no easier way of copying a DataTable than this int i = 0; foreach ( DataRow newRow in newTable.Rows) { DataRow drCopy = oldTable.NewRow(); drCopy.ItemArray = newTable.Rows .ItemArray; oldTable.Rows.Add(drCopy); } This returns an empty table: oldTable = newTable.Copy(); Hi; Usually DataTable.Copy() works fine for me. Try doing newTable.AcceptChanges() before doing the copy. If you need to copy only the structure then use DataTable.CLone(). Shivam ...Show All

• Visual C++ Permission Denied

  I'm a student working in a computer lab at college. We've recently installed Visual Studio 2005 in one of the labs, and have encountered a problem. Under the public user account, when someone opens Visual Studio and attempts to create a C++ Project Workspace using the Project Wizard, after all options are selected and the Wizard attempts to create the Project, an error message pops up saying Permission Denied (No other information in the error message) and the project is not created. This problem only occurs when using the Wizard to create the project, if they select the appropriate project type from the list instead of using the Wizard, it is created without any errors. There are no errors when working under the admin account. Any ...Show All

• Software Development for Windows Vista Statemachine Design and NullReferenceExcetion

  Hi all, could anyone please tell me: - how can i create the edge between States by statemachine - why do i have a NullReferenceException for wf-instance Creation in the sequenzial Wf Thanks a lot in advance Regards EP Also you can get the edges directly from the states by the small dots that appear in center on the four edges of the EventDriven activity(dropeed in a State) and dragging it to the next state you need. Thanks, Kushal. ...Show All

• Visual Basic load jsp files

  Hi developers, I hope you can help me solve this problem. I converted an asp webpage to the.net version. The following is the only line in the code that I use to call the method in both pages. asp: currfocuslocation = get_CurFocusLocation(Request( "rec_type" ), "" , "" ) & "set_PAY_TYPE();Disable_On_Load('PPAP10');" asp.net: currFocusLocation = topDisplay.Get_CurFocusLocation(Request( "rec_type" ), String .Empty, String .Empty) & "set_PAY_TYPE();Disable_On_Load('PPAP10');" I'm trying to call functions in my code, but it doesn't work in the net version. in the jsp file function set_PAY_TYPE() { //disable text fields } function Disable_On_Load(sScreen) { //disables a checkbox ...Show All

• Visual C# UInt to Int

  My program that I am working on reads a uint32 out of a file with the BinaryReader. The uint is the positive number that I need to use, but I cant get the uint converted to a regular int to be used with the other numbers without it becoming the regular int. I don't know why this happens and I am confused. "I cant [sic] get the uint converted to a regular int to be used with other numbers without it becoming a regular int." That doesn't make any sense. Do you want it converted to an int or not If you're worried about losing precision you could convert it to Int64... Maybe if you supply some sample code it may be more clear. ...Show All