lkshikoh's Q&A profile

• Visual Basic SQL Error Help

  I was working on a login script for my VB.NET 2005 program and I came across this error. Can somone please help me. System.Data.SqlClient.SqlException was unhandled Class=11 ErrorCode=-2146232060 LineNumber=65536 Message="Cannot open database "C:\AITP NEW\AITP\AITP\Users.mdf" requested by the login. The login failed. Login failed for user 'DESKTOP\Matt'." Number=4060 Procedure="" Server=".\SQLExpress" Source=".Net SqlClient Data Provider" State=1 StackTrace: at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data. ...Show All

• .NET Development <clear /> tag

  What happens if we failed to give <clear /> tag in <pages> tag of web.config file regards, kailai ...Show All

• Visual C# Create instance failed when the type depends on external dlls

  During runtime i need to load some dll. Assembly.LoadFile works ok, but when i invoke CreateInstance on some type from this dll it throws me exception because my type depends on dll's which are in the same directory. My question is : how can i create instance when it depends on external dlls which the systems can not locate. Do i need to put all the externals dll into GAC Or is there another workaround Thanks Slava. ...Show All

• Visual Basic Datagridview bound custom collection, how to refresh

  I am binding a custom collection to my Datagridview. That works fine dgvUsers.DataSource = users Now, if I add a user to the user's collection, it is not reflected back into the datagridview. How can I get the Datagridview to update or reflect my changes made within the collection. thanks, Dean You could use the BindingSource component, which will provide the functionality to notify DataGridView when underlying data source changes. Set your users collection to BindingSource's DataSource property and DataGridView's DataSource to the BindingSource instance, something like in the following code example: bindingSource1.DataSource = users dgvUsers.DataSource = bindingSource1 Andrej ...Show All

• Visual FoxPro SELECT .... INTO TABLE <existing table>

  G_TempDBF = "C:\scratch\" + SUBSTR(SYS(2015), 3) + ".DBF" SELECT field1, field2 FROM myTable INTO TABLE (G_TempDBF) USE (G_TempDBF) ALIAS CUSTOMER INDEX ON field1 TAG field1 I have created a temporary table, stores the retrieved records into it and alias it CUSTOMER How can i reuse this temporary table for other SELECT statements SELECT field3, field4 FROM myTable INTO CURSOR CUSTOMER ---> results in an error saying Alias CUSTOMER has been used. Hi Cetin >>If they ever created on disk If they ever created on disk I assume you are referring to those cases where VFP will offer a filtered view in memory rather than create a physical disk pres ...Show All

• .NET Development Conversion failed when converting datetime from character string.

  ms visual studio 2005 sql erver 2005 I originally posted this question at experts-exchange without resolution http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_22069012.html http: / / www. experts- exchange. com/ Programming/ Programming_ Languages/ Dot_ Net/ VB_ DOT_ NET/ Q_ 22068922. html I get the following error when trying to insert into db from web app have tried.... txtrequireddate.Text.ToString("dd-MMM-yyyy ") reqrddate = Convert.ToDateTime(txtrequireddate.Text) reqrddate= CDate(txtrequireddate.Text) Server Error in '/' Application. ---------------------------------------- ---------- ---------- ---------- ---------- Conversion failed when converting datetime from character string. Description: An unhan ...Show All

• .NET Development Socket Exception : No connection could be made...

  I'm working on a test app to familiarize myself with sockets and msmq before implementing a real solution and I'm running into some problems. I have simple TCP server and client applications set up to send strings from client to server. Basically, i'm retrieving messages from a message queue (client end) and sending them over to the server (just output to text box for the moment). I'm not sending anything back to the client...just a one-way send from client to server. It works perfectly the first time, but if I close the client and re-open (when message queue receives more messages), when I attempt to send them over to the server I get "No connection could be made because the target machine actively refused it." I know the ...Show All

• SQL Server Copying a column to a SSIS package variable

  I need to use a value retrieved in one data flow in the second data flow. What's the best way to do this How do I copy the column retrieved to a variable so I can use that variable in the second data flow Data Flow implies multiple rows, which doesn't naturally fit with a single variable. Normally I would be using an Exec SQL Task to populate a variable from a table. You could use a Script Component in the data flow, or perhaps the Recordset Destination if there are several rows. If reading just one value/line from a file for example, then I'd just use the Script Task. ...Show All

• Visual Studio Cannot install VS 2005... UDF ISO-13346 issue

  Hey everyone, I'm having the devil of a time installing the VS trial version (team package) on my xp pro machine. I've been fiddling with it for the last 2 days and can't get the DVD to even recognize the UDF portion of the disc at all, which is where all the installation files are. argggg... I've tried extracting it with ISOBuster, which fails almost 1/3 of the way through. I've tried ripping it to an image with Nero and fails at 69%... And those are the only two programs that I have that will even recognize that there is a UDF partition on there... Explorer is clueless to its presence. Could anyone help me I would sooooo greatly appreciate. Thanks, Tim Hi, I had the same problem and als ...Show All

• .NET Development how 2 move from 1 web page 2 another

  Heya al- got abit of a problem - im programing a web form in VB2003 that will run on a local host. So this is using asp.net. However i cant seem to run command in the vb part- e.g. say i wanted to move from 1 web page to another by clicking a button. In normal VB.net this would be form2.showdialog. However in this new web form ive placed a button and trying to load another form when user clicks on it- but it underlines the showdialog whats wrong cant i use normal VB.net programing to call another page/form Also can i use the menu feature that in windows forms when devloping a web page pls reply thanks There various way to navigate using asp.net. You could use a link control from the tool box and place ...Show All

• Visual Studio Express Editions Combining Express Editions into one IDE or Solution Explorer

  I've downloaded various express editions and have installed them. Each has an individual IDE. I'd prefer to be able to click on one IDE to be able to use the different languages or tools. I have VB, VC++, and SQL Server. I am asking how can I put these three together instead of having to choose between three different programs to launch their respective IDE's. Thank you for any help. Unforunately, integrated functionality is only available in VS Std or above. The Express SKUs are intended to be separate from each other. If you want that feature, you will have to upgrade Visual Studio. ...Show All

• Visual Studio Express Editions Serial Port: Writing Codes in HEX, not in ASCII

  Msgbox ("Hello World") :) I have some troubles with my serial Port. This time, I am adressing a DLP Projecotor. (PJ). The PJ listens only to commands it receives in hex format. The command 02h 01h 3e 03 makes the PJ switching on. When I write ComPort.Write("02H" & "01H" & "3E" & "03H") to the PJ, my Serial Port Monitor(monitoring HEX) says 30 32 48 30 31 48 33 45 30 33 48 Thus I wrote some ASCII to the PJ and the Oj does nothing. When I write ComPort.Write(Chr(2) & Chr(1) & Chr(122) & Chr(3)) my portmonitor is saying: 02 01 7A 03 and the PJ reacts correctly. It is quite long winded changing the decimal 122 to hex 7a. Now we come to my question: Is there a chance of ...Show All

• SQL Server SUM a column of values derived from an IIF expression

  I have a table in my report which shows sales values for each month by looking at the month number so for Jan i use =IIf(Fields!period_.Value=1,Fields!nett_.Value,0) for Feb =IIf(Fields!period_.Value=2,Fields!nett_.Value,0) this is all good and I get a series of rows per customer with the correct value in the correct column JAN FEB Mar Customer A 250 Customer A 350 Customer A 5000 . However I want to create a summary a line JAN FEB Mar Customer A 250 350 5000 I tried using SUM but this doesn't give all of the values in the summary line. It might just give the first and the rest are zeros. Or if the customer didn't have a ...Show All

• SQL Server Reading Records from Excel File

  Hi all, Whilst reading in records from an excel source via the SQL command method I've stumbled across a problem. my SQL query takes in all records where the date column is not NULL, this ensures that only populated rows are obtained. If the date is in a format that is incorrect i'd really like the whole data flow to fail. However... What seems to happen is that any rows with a fault in the date column are just missed out and not pulled through the pipeline. I have tried changing the error output from fail component to ignore error and redirect row but nothing seems to catch it. Does anyone have any suggestions as to why this may be the case Many thanks, Grant Hi Douglas, Thats exactly what i was needing ...Show All

• Visual C# Using System.Reflection.Emit

  Hi All Does anyone know to create new field in an exising class using System.Refelection.Emit Any help or sample code much appreciated ...Show All