Jack of All Trades's Q&A profile

• Visual Studio BATCH FILE and VB.NET

  I am creating a project with VB.NET and i need to write a batch file and excute it or call it from there, how can i do this Another thing about writting the batch file, I dont have any experince in writting batch files, but from my readings i understand that it should be written with dos commands and saved in a .bat format.. I want the batch file to open a text file and read it charecter by charecter, and output the charecters+1 to a new document.. For example if the text file has 'a b c' the batch file should write the following output to a new text file 'b c d'. Any HELP will be appreciated.. Thanks. Yah i tried that but for some reason it didnt work... although i put the batch file ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Unable to render mesh

  Hello there, guys! I've a little problem with Direct3D9. I'm following a book written by Jim Adams, called "Advanced Animation with DirectX" This book show you how to extend the classes D3DXMESHCONTAINER and D3DXFRAME, and using them to render meshes. Now i'm trying a my example, that you can see here http://phpfi.com/182098 But there are some problems: At first, the mesh is not rendered, i've tryied so much position with camera but nothing i can't find it., but the Device->Clear works... I'm also using a simple shader, here is it... float4x4 matWorld; float4x4 matView; float4x4 matProj; float4x4 matTotale; texture TextMesh; sampler2D STextMesh = sampler_state { texture = <TextMesh>; MIPFILTER = linear; ...Show All

• SQL Server Key Maintenance and Stored Procedures

  Basically I would like to ask whether parameters can be used to pass the value of the 'symmetric key id', 'certificate' and optionally 'password' to a stored procedure that uses encryption functions. The reason this is appealing is that when encryption keys etc change over time (we have a requirement to decrypt data, destroy and create new keys, then encrypt data every time we lose a staff - don't ask), as we would be passing the value of keys, passwords and certificates as parameters to a standard stored procedure. Hardcoded Example (Working) USE PSS GO CREATE PROC insert_payer_ba -- define parameters @param_rec_id NVARCHAR ( MAX ), @param_bsb NVARCHAR ( MAX ), @param_account NVARCHAR ( MAX ), ...Show All

• Visual C++ arrays

  i have an array that i have debuged to make sure it contains stuff. when i access it like arr[1]; it is fine. but is i try int pos = 1; arr[pos]; i get an exeption at runtime of "System.IndexOutOfRangeException" the array is highlited. what can i do Also note that when you create an array, the elements start at 0. If you do something like int array[1];, the first element would be array[0]. ...Show All

• Windows Forms ToolStripStatusLabel properties

  I'm using a ToolStripStatusLabel and it doesn't seem to have all the properties that a normal label does. For example, AutoEllipsis. I need that property for the StatusLabel control. Am I just not looking for the right property If the text is too long, I need to add an ellipsis and I'm hoping I'm not going to have to figure it out manually. Any help is appreciated. Thanks! Ya-Tin The statuslabel control does not have an ellipsis property like the regular label...however the statuslabel does have an autosize property that will size the control according to the text and image in the control ...Show All

• SQL Server Export whole database with relations and keys

  Hi, I've been trying to export a whole database from one server to another (connected through a local network) but the keys always get lost: when I open the diagrame I can actually see them just before the tables names appear. I've tried inserting the primary keys for each table manually with the export wizard, which took me some time, but no relations were exported. Any way of doing this automatically Here's a free tool that will generate scripts for all objects and data in any 2000 or 2005 database, a separate file for each. It's good for getting your database objects into source control if they aren't already. http://www.elsasoft.org/tools.htm ...Show All

• Windows Live Developer Forums Strange Error coden when adding negative keywords

  Hi, I am trying to implement the use of negative keywords, but I keep getting this strange error: FAILED_NOT_KEYWORD_MISSING_AMT A negative keyword within the order is missing a partial match amount. I am sending a string array in the orderitem with the values ag nega1 ag nega2 Could someone please explain what this error code actually means What is a partial match amount Another strange thing is that the documentation says that negative keywords are send as a string where each negative keyword is separated by a comma. But in the orderitem class notkeywords are send as an array of strings. Is the documentation wrong Best, Peer Jakobsen Ok, I found out that neg ...Show All

• Windows Forms Using the Windows Forms PropertyGrid

  IHow do I create an expandable set of related properties within a category (i.e. the Font property in the property grid found in Developer Studio 2005) Hi, It seems that you want to customize your display of the data. Have a look at this article and hope you can have some hints. http://www.codeproject.com/cs/miscctrl/customizingcollectiondata.asp Here's also a good article introducing the general use and customization. http://msdn.microsoft.com/library/en-us/dndotnet/html/usingpropgrid.asp frame=true EDIT: You don't need to post your question all around, though we can understand your eagerness. :-) ...Show All

• Visual Studio Express Editions How to connect a new form to a button?

  Hi everyone, I was wondering how i can make a button connect to a form so when I click on it it takes me to that form but the form cannot be opened repeatedly. code in the button click. (this is written in vb convert it to c#) Dim objForms As Form dim flag as boolean = false For Each objForms In frmMDI.MdiChildren If Not objForms.Tag Is Nothing Then If Convert.ToString(objForms.Tag).ToUpper = "XYZ" Then objForms.Show() objForms.Focus() flag = true End If End If Next if falg = false then dim frm1 as Form1 frm1.Tag = "XYZ" frm1.show() end if ...Show All

• SQL Server Payment Tables - Design Best Practice

  I'm creating a payments table to be ledger style but don't know which design to implement. Design 1 TranID TranSubId Status 1 1 Cancelled 1 2 Live 2 1 Live Then have a compound key across tranId and tranSubId. This would be quick for look ups but when I have to enter a new record I have to find the max(transubid) + 1 for the transaction I want to insert (if it already exists) Design 2 Id TranId Status 1 1 Cancelled 2 1 Live 3 2 Live Id would be the PK and an autoidentity field making inserts much easier. Perhaps making ID nonclustered PK and TranId clustered would be better than the other way round Which of these would ...Show All

• .NET Development xml serialization problems with asynchronous callback

  hey guys, im developing a windows application that uses asynchronous callback as network communication technique with xml serialization for sending complex objects over the network. the problem is that at receiving the buffer to be written to the file is never written fully and in correct format. its always cutted from the middle and so the serialization always fails. any clue thanks I'm also guessing you are having the same problem I had a while back - its the way TCP is, sending out data in bursts, so your reciever appears to read all the data it recieves but actually on the next read, the rest of the data just turns up. Are you also able to post the code for your recieving end, whe ...Show All

• SQL Server Suspect mode ... cant even attach mdf file using sp_attach_db

  Hi, In sql server 2005... I am trying to take a backup, When i was trying one of my database is marked as suspect, I tried lot of ways finall i tried stopping the service , and copy mdf,ldf files of that database ...and again started the service ... pasted it in other server and tired to attach using sp_attach_db it shows database cannot open, I/O error occured..i also tried sp_singlefile_attach_db Can any one tell me how to bring suspect mode database to normal mode... also how to solve the I/O error when attaching mdl , ldf files. i am sorry , i am using this syntax only... Exec sp_attach_db @dbname = N'TfsworkitemTracking', @filename1 = N'C:\Programfiles\mssqlserver\mssql\data\TfsWorkitemTracking.mdf', @fil ...Show All

• .NET Development ADO.NET2.0-SqlConnection,SqlCommand and DataReader used in VBExpress:Unable to cast object of type 'System.Decimal' to String

  Hi all, In my SQL Server Management Studio Express, I have a database "ssmsExpressDB" with a table "Table-dbo.LabTests" that has the following columns:         ID(Int)   AnalyteID(Int)  AnalyteName(nvarchar)  CasNumber(nvarchar)  Result(decimal) Unit(nvarchar) LabQualier(nvarchar)..... I created a project in Visual Basic 2005 Express and had the following code: ////////--Form1.vb---////////// mports System.Data Imports System.Data.SqlClient Public Class Form1 Private Sub Form1_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load Dim mySqlConnection As SqlConnection Dim mySqlCommand As ...Show All

• Windows Forms maximize application up to taskbar

  Hi I have a windows form app which I maximize on startup. The bottom of the form however seems to dissapear behind the taskbar giving an unfinished affect. How can I set the form to fill the screen up to the taskbar Matt Odd problem, perhaps you are running on an old version of Windows Try using Screen.PrimaryScreen.WorkingArea. For example: private void Form1_Load(object sender, EventArgs e) { this.Location = Screen.PrimaryScreen.WorkingArea.Location; this.Size = Screen.PrimaryScreen.WorkingArea.Size; } ...Show All

• SQL Server How to import Pervasive Database into SQL Server 2005

  Hi I have tried to import Pervasive Database to SQL Server 2005. I am not getting any option in Data Source for Pervasive So I tried following I have Provided the following Connection String to SQL server Import and Export Wizard (in .net framework data provider for ODBC) Connectio String: Dsn=DEMODATA;Driver={Pervasive ODBC Engine Interface} DSN: DEMODATA Driver:Pervasive ODBC Engine Interface but i m getting error that "Can not get supported data types from th database connection." Can you please look in to it and tell me possible ways by which I can import pervasive Database into SQL server 2005. and let me know if there is any other tool by which we can see "Pervasive ODBC Engine Interface& ...Show All