|
I had a command that inserted two tables, both using identity columns as primary keys. The identity value obtained from the first insert was used in inserting the second table, and two output parameters on the command should reflect the value of the two primary keys after insertion.
The command text was hence something like
INSERT A VALUES (@p1, @p2);
SET @A_ID = SCOPE_IDENTITY();
INSERT B VALUES (@p3, @p4, @A_ID);
SET @B_ID = SCOPE_IDENTITY();
I had added sql parameters for the identity values, and set the parameter direction to Output. After executing the command, I found that cmd.Parameters["@B_ID"].Value had been correctly set, but the @A_ID parameter invariably had the value zero.
Looking at the inserted data however what was really made me wonder what was going on here. The B record contained the correct foreign key, demonstrating that @A_ID had indeed been assigned correctly!
After hours of headscratching I stumbled upon the explanation: The code creating the command first added a parameter @A_ID as an input parameter, then added another parameter also named "@A_ID" as an output parameter. I don't know how exactly the provider communicates the variable declarations to SQL Server, but it appears that the second declaration simply overwrote (redeclared) the already-defined @A_ID. Then, when my code attempted to get the value, the SqlParameterCollection probably did a linear search returning the first parameter with a matching name, which of course was the input parameter.
While not checking for duplicate declarations may save a few microseconds, it would have been nice if by default such validation was performed and could be disabled instead via the ado.net configuration (for production). I certainly lost a lot of time, and probably some hair, before I found out. If it sounds like I was just being slow, let me add it wasn't that easy to check everything when the command had about 100 parameters.
|
|
|
|
|
Good find bro. I would surely try out this and see. If it really happens, it wouldnt be good.
dojohansen wrote: I was just being slow, let me add it wasn't that easy to check everything when the command had about 100 parameters.
Definitely. 
|
|
|
|
|
Hi,
This is what I want to do.
- Want to display an HTML page in a browser, kioskmode.
- Depending on information I get through a webService, I need to change the URL.
Any suggestions/technology how to achieve this ?
Additionally, how can a browser render its HTML 'in the background', and when ready, swap the 'old content' with the newly 'rendered' content.
So, in the kioskmode, we avoid the 'building' being displayed to the viewer. Any idea ?
Thanks in advance !
Dirk
|
|
|
|
|
WinForms has a WebBrowser control[^] that you can use to display a web page on your form.
You could have 2 of the controls and keep one hidden, then do the reloading on the hidden one and switch them around when the rendering is complete.
As your app is just a win forms app you should be able to set it up as the endpoint for a WCF (or webservices or whatever) service and when it receives a message, you can load the appropriate URL in your browser controls.
Simon
|
|
|
|
|
Thanks for your prompt reply !
This indeed works. However, I have two additional questions
1) Can I know when the WebBrowser is finished rendering the page ?
and secondly
2) As being a newbee to WCF... do you have a good link to explain me
2.a) how to design the service
2.b) subscribe as endpoint.
Many thanks !!!
Dirk
|
|
|
|
|
Hi,
I have a website that's running from several months. Most of the web pages contain a common marquee tag. I want to put the tag in a html file and embed the html file wherever needed so that when ever a change is made to the marquee tag it affects all the web pages.
Thanks in advance
|
|
|
|
|
The easiest way is probably with Server Side Includes[^]
You put a tag like this in your main html page
<!--#include virtual="../TheOtherFile.html" --> which points to the other html file that contains the html you want to insert. The server (either IIS or Apache) will insert this file when the page is served.
This is something that I believe is turned on by default on IIS and Apache, but you may have to rename your main html to myfile.shtml to indicate that you want to process SSIs in the file. (This means that you may also have the change the default pages for your directories if you rely on default pages being default.html or something like that). Some of this may vary between providers though, so if in doubt check with your web host.
Simon
|
|
|
|
|
Didn't even know you could turn off server side includes. You definitely do not need to rename the file though. However aspx pages may not process server side includes. Not much point considering what they do.
If you have knowledge, let others light their candles at it.
Margaret Fuller (1810 - 1850)
www.JacksonSoft.co.uk
|
|
|
|
|
The Man from U.N.C.L.E. wrote: Didn't even know you could turn off server side includes. You definitely do not need to rename the file though.
You can[^], and you can also configure them to only be executed for specific file extensions, so it does depend on what your web host has got setup. My web host only processes SSIs on files named .shtml and .shtm. By default I think it's just on for all files, but you can't rely on that when you didn't do the IIS install yourself.
The Man from U.N.C.L.E. wrote: aspx pages may not process server side includes. Not much point considering what they do.
Yup, SSIs are not processed on aspx pages. You could probably hack up an alternative using something like Response.Write(), but like you say, not much point for asp. You'd probably just use something like master pages instead.
Simon
|
|
|
|
|
First, this would probably be better asked in the Web Development or ASP.NET forum since it has nothing to do with .NET Framework.
Have you considered using an asp.net master page?
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Is it possible to write excel UDF with the help of build-in Visual Studio project type "Excel 2007 Add-In"?
|
|
|
|
|
Not that I know of... could be wrong though.
|
|
|
|
|
Google[^] says you can create an Automation Add-in that does the job.
If you have knowledge, let others light their candles at it.
Margaret Fuller (1810 - 1850)
www.JacksonSoft.co.uk
|
|
|
|
|
check this:
http://blogs.msdn.com/eric_carter/archive/2004/12/01/writing-user-defined-functions-for-excel-in-net.aspx
richta
|
|
|
|
|
my first dll is
using System;
namespace myfirst
{
public class demo
{
public string getmessage()
{
return "Hi!How Are You";
}
}
}
in folder e:\prac
and more dll is
using System;
using myfirst;
namespace mysecond
{
public class demo1
{
public string getmessage1()
{
demo d=new demo();
string str1=d.getmessage();
Console.WriteLine(str1);
}
}
}
and now i am using csc /t:library mysecond.cs
then i have following error and problem was same.please help me
mysecond.cs(2,7): error CS0246: The type or namespace name 'myfirst' could not
be found (are you missing a using directive or an assembly reference?)
|
|
|
|
|
vikas shukla wrote: are you missing a using directive or an assembly reference?
that tells you what is missing.
csc.exe has a lot of switches, try "csc /?" to get its help, and discover what "/r" does for you.
FYI: csc is part of .NET, hence look in a folder such as C:\Windows\Microsoft.NET\Framework\v2.0.50727
Luc Pattyn [Forum Guidelines] [My Articles]
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
|
|
|
|
|
Just because you have the assemblies in the same folder, C# compiler does not automatically resolve referenced assemblies for you. You have to specify the referenced assemblies using the '/r' switch.
|
|
|
|
|
Hi,
I am using the connected Socket communication to send and receive messages from one application to another application. i will send or receive the messages by serializing the objects.
how can i differentiate the different messages received.
Thank you.
|
|
|
|
|
k3rkiran wrote: how can i differentiate the different messages received.
The obvious way is to put an identifier at the beginning of each message.
|
|
|
|
|
I think the absolute simplest way is to lead each message with
a message size field of a known size. Receive that field then use
that count to know how many bytes of message to receive. When you've
received the message bytes, you're ready to read the next message
length field....and so on.
Mark Salsbery
Microsoft MVP - Visual C++
![Java | [Coffee]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/coffee.gif)
|
|
|
|
|
Hi
Is it possible to hook the events of a WebBrowser navigation events further than just Navigating? I want to intercept certain types of events, like clicking on a webpages form-control (textarea or submit button)?
Seems to me that I can only hook the rather generic Navigating event which apparently does not allow for me to know the type of event.
Thanks in advance!
|
|
|
|
|
Hi all,
In VB.NET project, I'm trying to add an attachment to MailItem. Visual Studio 2008 timeout after around 60 seconds
A fatal error has occured.....please see Microsoft.....HRESULT=0x80131C8 ErrorCode=0x0
My code is failing at myMailItem.Attachments.Add line. it seems that i cannot add any attachment.
Failing SUB
Sub AddAttachment(ByVal MailId As String)
Dim myOlApp As Olk.Application
Dim myOlkNS As Olk.NameSpace
Dim myMailItem As Olk.MailItem
Dim myAttachments As Olk.Attachments
Dim myAttachment As Olk.Attachment
Const OlkCatExt As String = ".OlkCat"
myOlApp = New Olk.Application
myOlkNS = myOlApp.GetNamespace("MAPI")
myMailItem = myOlkNS.GetItemFromID(MailId, PSTStoreID)
Debug.WriteLine(myMailItem.Subject)
Debug.WriteLine(myMailItem.ReceivedTime)
Dim MyOlCat() As String = Split(myMailItem.Categories, ";")
If MyOlCat Is Nothing Then
'
'
'
Else
For Each OlkCat In MyOlCat
myAttachment = myMailItem.Attachments.Add((OlkCat + OlkCatExt), Olk.OlAttachmentType.olByValue)
myAttachment.DisplayName = OlkCat
'myMailItem.Save()
Next
End If
End Sub
All ideas are welcome
Best
Jean
|
|
|
|
|
Does anyone have any idea how to take a PDF and set this property using iTextSharp or any other free open source tool? Basically the idea is that we have a program generating PDF's and we want to be able to have someone in the office sign the document and then pass it down the line to the next person. Everything I have found has pointed to buying one tool or another, but we would really like to be able to do this without buying any tools.
Thanks in advance for any help!
--
"Keyboard not found. Press < F1 > to RESUME. "
Source unknown (appears in many common BIOSes as a real error message)
|
|
|
|
|
I know its a bit late, but here is a very nice article i found about signing of PDFs using iTextsharp and hence stopping others from tempering it. I hope its helpful for you.
|
|
|
|
|
Salve Michela,
grazie in partenza per l'attenzione. Ho un problema da risolvere abbastana urgentemente.
Premetto che sono una programmatrice .NET autodidatta, per cui presumo che il mio problema dipenda da un'ignoranza di fondo, cmq proverò a spiegarmi nel modo più chiaro possibile.
Sto sviluppando un'applicazione desktop in .NET 2005 (C#) che crea dei report in Word e li memorizza sul disco del client. L'esigenza è che l'applicativo funzioni su pc che abbiano un O.S. che va da Windows 98 a Vista, e di conseguenza che funzioni con tutte le versioni di Office.
Sul pc di sviluppo (XP) è installata la versione di Office 2007, per cui nell'applicazione punto alle seguenti librerie (v. 12.0.0.0)
- Microsoft.Office.Interop.Word
- Microsoft.Vbe.Interop
- office.dll
e per creare i report mi baso su dei modelli (.dot) creati sempre con word 2007, ma salvati con formato Word 97-2003.
Aggiungo che per puntare alla directory su cui vengono salvati i .doc, utilizzo la variabile Application.StartupPath + "percorso relativo all'interno della dir di installazione".
Ovviamente sul pc di installazione va tutto bene, ma se mi sposto su un altro pc, anche sempre con XP ma con una versione differente di Office, le cose nn quadrano più.
Trattandosi di oggetti COM, nel progetto di setup ho aggiunto la registrazione delle librerie (opzione VsdraCOM) e la registrazione nel Registry Key delle dll. Ho creato i file reg appositi con l'utility RegAsm delle dll su menzionate.
Fatto sta che la situazione è la seguente:
Nel GAC sono registrate le versioni 11.0.0.0 e 12.0.0.0 delle librerie suddette
Nel Registry Key ho un errore dovuto al caricamento dei tipi dll.
E non ho impostato nulla di particolare riguardo i diritti di lettura/scrittura su disco.
Dovrei forse creare una zona "trusted" con AppDomain o sbaglio qualcosa nella registrazione delle COM??? o altro!??!??!
Ho le idee un po' confuse su quanto ci sia da fare per risolvere questo problema, ma mi chiedo (e giro la domanda): è possibile raggiungere l'obiettivo prefisso senza l'ausilio di librerie ad hoc, come ad es CrystalReport? Cioè, possibile creare dei report validi per tutte le versioni di word, ceh giri su pc che hanno anche OS datati?
Nel caso in cui si possa fare, ti sarei grata se almeno potessi indicarmi degli articoli di riferimento.
Purtroppo sono arrivata ad avere davvero poco tempo a disposizione per risolvere questo problema.
Grazie ancora e buon lavoro,
Daniela.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
