LonelyPixel's Q&A profile

• SQL Server how to pass strange looking Passwords to SQLCMD ?

  I have problems with passing strange looking passwords from my win.form application to sqlcmd. I tried to do this: sqlcmd -S myServer -U myUser -P 2pQ-""xELfG~fze<= -d "McSpalDB" -i "C:\myProcedure.sql" -o "C:\temp\myOutput.out" but it fails, so I tried to encapsolate the passwoard in "": sqlcmd -S myServer -U myUser -P "2pQ-""xELfG~fze<=" -d "McSpalDB" -i "C:\myProcedure.sql" -o "C:\temp\myOutput.out" but it fails too, because i have "" in my pass, since " isn't a forbiden symbol. How to pass strange looking passwoards to sqlcmd Thank you Jeff. "pass" works  . ...Show All

• .NET Development OleDbCommand.Update method bug - parameter values overlap

  Here's a weird one I haven't been able to figure out. I have a DataSet with several new rows that I need to insert into my Access database. I have a query in access called 'insNewUser' that takes a single parameter -- 'UserName'. My DataAdapter fills the DataSet with no problem. If I add a single new row to the DataSet and then call my DataAdapter's Update() command, the row gets added without a problem. If, however, I add 2 new rows to the DataSet and call the Update() command, the first row gets inserted properly, but the second row contains "left-over" text from the first row! For example, if I added two new rows with the values: 1) "UsuallyPrettyKnowledgeable" 2) "Stumped" my DataAdapter would ins ...Show All

• Windows Forms Creative inspiration

  Hi Guys, I want to build a scrollable information-rich GUI list, rather like the list of emails in MS office. That is, a list of boxes, with each box containing a couple of lines including title (maybe in bold), some information, some numbers and maybe a couple of icons. What do you think is be best way to construct this I'm guessing many of you will say datagridview or some sort of custom control. These would be fine, but any help in terms of exactly how to do this would be really appreciated. Two things to think about: 1) I'm not an expert programmer, eg. I'm not completely sure how to do complicated inheritance. 2) I only have VC++ Express - can you create custom controls with this If so, how Any help appreciated - any good ...Show All

• SQL Server decryptbykey multiple session issue

  Hi I'm having some issues using the decryptbykey method via multiple connections. When I run the below test script simultaneously on two machines the sum function is always less then the known amount (ie 14945490 and 36382777). Does anyone know of any locking method or alternative way to sum an encrypted column Thanks in advance Waz open symmetric key HR01 decryption by password = 'yes' DECLARE @Bonus decimal DECLARE @Salary decimal DECLARE @Errors int DECLARE @Success int DECLARE @LoopCount int SET @Errors = 0 SET @Success = 0 SET @LoopCount = 0 WHILE ( @LoopCount < 40 ) BEGIN SELECT @Bonus = SUM ( convert ( float , convert ( varchar ( 80 ), decryptby ...Show All

• Software Development for Windows Vista CreateFile Assistance

  I have the following code taking out from windows system programming 3rd edition book. I'm having a hard time running this code, I know where the problem occurs, but don't know how to remedy the solution. I want to pass the command line arg(in this case argv[1]) for CreateFile, but I get an error. If I were to use TEXT("filename") everything will work fine. How can I get CreateFile to work with argv[1] Here is a snippet of my file. int main( int argc, LPTSTR argv[] ) { if ( argc != 3 ){ std::cerr << "Usage: cpW file1 file2" << std::endl; exit( 1 ); } HANDLE hIn, hOut; DWORD nIn, nOut; hIn = CreateFile( argv[1], // file to open GENERIC_READ, // open for reading FIL ...Show All

• SQL Server Update slow(5 Hrs, 14mil rows) on perm tables, however as part of SP using temp tables fast(45 mins 14mil rows)

  Greetings All ITEM1: Here is the statement :(Perm Tables) update jkk_AllLogic_Allocation1_Work set ExpAllocValue = a.ExpFinValue * (a.SalesFinValue / s.TotSalesValue) from jkk_AllLogic_Allocation1_Work a, jkk_SumOfSales2 s where a.ID = s.ID ITEM2 Here is the similar Statement(excerpt) from SP: /* Adjust Expense amount depending on sales ratio */ update #AllLogic_Allocation1 set ExpAllocValue = a.ExpFinValue * (a.SalesFinValue / s.TotSalesValue) from #AllLogic_Allocation1 a, #SumOfSales2 s where a.ID = s.ID The SP does a lot of things Update being the longest. QUESTION Why is ITEM1 taking 6 times longer to run than ITEM2. I am totally confus ...Show All

• Visual Studio 2008 (Pre-release) Using web services with xbap application

  I have created an wpf browser application that relies on calling a web service. However, whenever I call the web service, I recieve a "System.Net.WebPermissions" error message. The web service is located on a different server. How do I get this to work Thank you for the help. Steve Well, the Atlas part is for the server so it's a non-issue there. It could be Java on the other side for all you care, makes no difference. Soooo.... admittedly I haven't looked at the sandbox restrictions for WCF. I just went and did some research based on your comment and sure enough it looks like partially trusted callers are not supported and WCF because support for CAS was dropped. Thank you for correc ...Show All

• Windows Live Developer Forums How do you print a bird's eye view in Local Live?!

  How do you print in windows local live ! I've tried numerous times, but have come up empty! Why can't I simply do file:print Why does windows only allow me to print an aerial or a road map It's stupid! I'm going to Google Earth. Do you still need help with this if so email me at storms1151@hotmail.com and put in the subject "Birds Eye View" and i'll give you some Ideas. It's kind of tedious but I've printed some good pics. ...Show All

• Visual C# XML Code Documentation

  We all know that if you type \\\ on the line above a function or variable definition etc. what you get is: ///<summary> /// ///</summary> public void myRidiculouslyLongFunctionNameForNoParticularReason() {    DoSomeStuff(); }   or maybe /// <summary> /// /// </summary> /// <param name="iVal"></param> /// <returns></returns> public double myLittleMathFunction(int iVal) {      double rVal =  DoSomeMaths();      return rVal; }   And this is Great.  Does anyone know if it is possible to change/modify/add to the XML Documentation comments that are generated For example, I want the automatically generated XML c ...Show All

• Visual C# detecting close button of browser in C#

  Hi all, i am developing an application in which i want to perform certain action when user clicks on the close(X ) button of the web browser. Please anyone help me out to resolve this issue.Any tutorials or sample application would also be helpful. Regards. Hi farshad, Thanks for reply.But can u suggest me how could i check whether the user have clicked on the close button of the browser or not.Like in my application i want to check whether the user has clicked the close button and then want to update the database accordingly. ...Show All

• Visual Basic Making a COM

  I was just wondering what one does to make a COM in visual basic (or C# if any one reading this knows that better) basically i want to turn a class ive made into a COM; why I don't know, but it seems cool, and i think i need to learn how to make a com any way; I checked MSDN and it talked about what you should and should not do in your code when making one, but never how to make one. A dll is a class library. A COM Dll, is simply a class library with the attributes on it. Every version of VB.NET allows you to create a class library. ...Show All

• Visual Basic How to not get combobox SelectedIndexChanged be executed on load

  Hello, As what the subject line is.... What is the method to not allow combobox SelectedIndexChanged to be executed on load... and only make it to be executed when a "USER" changes the selection value. Thanks Why is the boolean flag not the best practice There isn't a way that I know of to prevent the SelectionIndexChanged if you change the index at load time. ...Show All

• Windows Forms Is it possible to change the number of tabs in a tabcontrol at runtime?

  I want to be able to generate additional pages in my tabcontrol on the fly (at runtime) and subsequently remove them. Is it possible How difficult is it Thanks private void button1_Click(object sender, EventArgs e) { tabControl1.TabPages.Add("Nobugz"); TabPage page = tabControl1.TabPages[tabControl1.TabCount - 1]; Label lbl = new Label(); lbl.Text = "was here"; lbl.Location = new Point(5, 5); page.Controls.Add(lbl); } ...Show All

• Visual Studio Express Editions stand by exe

  how do i make a simple exe that when i run it, ti puts windows in to stand by and what would be the same for restart, shut down, and log off So, how far are you Do you have a Windows Forms app, where you want to call that function from a button or menu Or do you build a console app For the form: add the above declares to your form class and you can just call them. For the console: add the declares to your class which has the Main function and just call them. For details about the APIs: http://msdn2.microsoft.com/en-gb/library/aa376868.aspx http://msdn2.microsoft.com/en-us/library/aa373201.aspx -- SvenC ...Show All

• .NET Development How to read the record data (byte array) while writing a Metafile (WMF/EMF) and edit it

  Hi! Need your ideas urgently! I have a metafile which I wish to convert to PDF on the fly. The idea is to create a metafile template with placeholder text, which will be parsed and replaced by user information at runtime before generating the PDF. When editing the metafile, I have progressed to the following steps: 1. Called the Graphics.EnumerateMetaFile() method, which calls the callback method (lets call it ‘Play’) 2. Called the callback method and obtain the record data public bool Play( EmfPlusRecordType recordType, int flags, int datasize, IntPtr data, PlayRecordCallback callback) { byte [] dataArray = null ; if (data != IntPtr .Zero) { dataArray = ne ...Show All