|
Hi guys
what is wrong her keep getting this error:
" Parameterized Query '(@type nvarchar(4000))select price from titles where type=@type' expects parameter @type, which was not supplied "
I think it's something to do with my QueryString, which seems to be null, but I don't know how to fix it - any suggestions please....
Here is a code snippet:
strType = Request.QueryString["type"]; //using pubs database
strSelect = "select price from titles where type=@type";
cmdTitles = new SqlCommand( strSelect, conPubs );
cmdTitles.Parameters.Add("@type", strType);
conPubs.Open();
rptTitles.DataSource = cmdTitles.ExecuteReader();
rptTitles.DataBind();
conPubs.Close();
All the best
Al
|
|
|
|
|
ComCoderCsharp wrote: strType = Request.QueryString["type"];
Make sure this is returning something.
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
|
|
|
|
|
Hi!
I want to create setup of my project using InstallShield. i am using InstallShield 6.1 for this. I found this [^] article on using InstallShield but first of all it is for VC++ not C#, and i am not sure will it will work same for C# or not.
Secondly it does not specify how to verify license key during installation and how to insert a registry key?
Please help me in this regard, thanks, in advance...
Regards,
Affan Ahmad Toor
..................
QUAIDIAN FOR ONCE, QUAIDIAN FOR EVER!
|
|
|
|
|
I would look for some kind of InstallShield forum or call their support if they have one. You probably won't find answers for this question here.
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
|
|
|
|
|
How get MotherBoared serial no. from c# program?
|
|
|
|
|
|
My question is primarily about audio but hooking is also involved.
I am trying to figure out if I manage to get a hook set up to catch messages (I *think* messages heading to audio playback fall under a WH_GETMESSAGE Hook type) will fall into the same format since I'm going to have to be able to filter out the messages I'm not concerned with.
I, also, assume it's not possible to 'hook' to the default output sound device itself since it's a hardware device but shouldn't there be some kind of software handling the playback I can hook into (thus hooking 1 process instead of a list of processes) or is each program calling sound output the last software in line for me to hook to for that?
Note: I'm not looking at using global hooking here as I want to avoid angering World of Warcraft's Warden program.
|
|
|
|
|
What are you trying to do with World of Warcraft itself then?
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
|
|
|
|
|
This is a personal project I came up with due to my distaste for Ventrillo and TeamSpeak. I dislike them because if I'm using them, I have to turn my volume down/off on other applications so I can hear the chat clearly. Then I get irritated that my music/in game sound is down when everyone is quiet.
I can't turn it back up then because if someone started talking I'd miss parts of it as I'd have to go back and turn the sound back down/off on those applications.
My goal with this project is to:
>Detect when Ventrillo / TeamSpeak / (user selected app perhaps?) is using the microphone or outputting sound.
>When the above is true (either by shared memory space or rigging some file writes/reads), other application sound (specific applications, most likely) gets any sound they output turned down so as not to interfere with chat.
>After Vent/TS/etc have finished using the mic/outputting sound (and after an appropriate wait for possible responses, etc) the sound of the applications is no longer 'hushed' (back to normal).
The point of using local-hooking rather than system-hooking is to avoid WoW's warden as it doesn't like things to interfere with WoW and I'd rather stay on the safe side. To have WoW's sound act similarly, I was planning on a simple file out so that a custom UI can read the file to tell when to moderate WoW's Master Sound down (assuming WoW's subset of LUA will allow for it).
|
|
|
|
|
I am not sure exactly how the World of Warcraft warden works but I doubt it can look for a global hook. I am sure it looks in a similar way virus scanners work. That being they just look for common ways a program gets something done, i.e. looking for things speeders do.
My suggestion would be to try a global hook and see if the warden complains.
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
|
|
|
|
|
World of Warcraft aside, a global hook is best way to do it, I agree.
I'll send an email out to Blizzard and try to get their support team to let me know if global hooks will cause an issue while I work on designing this.
Either way I implement this, I'll still need to figure out exactly what message type I'm trying to catch. I think once I have the right message and catch it, it shouldn't be a big deal to change the volume level in it but I won't be sure until I get the right message figured out and take it apart.
Any suggestions on that or some way to look at what calls programs use to output audio? I was thinking if I had some kind of tool to look at all those sorts of calls, I could just watch what winamp puts out when I hit play.
Note: I have also been looking at IAT Hooking and since I don't completely understand hooking yet I may be mixing ideas that I shouldn't. Feel free to correct me.
|
|
|
|
|
I have a xml file that looks something like this
<?xml version="1.0" encoding="ISO-8859-1"?>
<?xml-stylesheet href="../../../../formatmall/dtd_dok_1_4.xsl" type="text/XSL"?>
<?Fm Condition Comment Red SINGLE_UNDERLINE show?>
<?Fm Condition Inserted Red CHANGEBAR show?>
<datamodul xmlns:xlink = "http://www.w3.org/1999/xlink" xmlns:num = "http://www2.mil.se/namespaces/num" xmlns:punkt = "http://www2.mil.se/namespaces/punkt" xmlns:ill = "http://www2.mil.se/namespaces/ill" xmlns:term = "http://www2.mil.se/namespaces/term" xmlns:tab = "http://www2.mil.se/namespaces/tab" xmlns:alt = "http://www2.mil.se/namespaces/alt" xmlns:obs = "http://www2.mil.se/namespaces/obs" xmlns:anm = "http://www2.mil.se/namespaces/anm" xmlns:kommentar = "http://www2.mil.se/namespaces/kommentar">
<niv1>
<rubrik>something</rubrik>
<niv2>
<rubrik>something else</rubrik>
<text>some text</text>
<niv3>
<rubrik>something more</rubrik>
<text>bla bla</text>
</niv3>
</niv2>
<niv2>
<rubrik>more headlines</rubrik>
<text>some simple text...</text>
<lista-num>
<lista-elem>
<lista-text>(1) list
</lista-text>
</lista-elem>
</lista-num>
</niv2>
</niv1>
</datamodul>
I've tried to rename some elements using XmlDocument() but with no success.
So if anyone can tell me how it is done, I would be glad.
Elements to rename:
niv1, niv2 and niv3
And ofcourse, save the file with changes.
|
|
|
|
|
Hi!
I had this problem too and after a lot of effort i figured out that using DOM, there isn't any way you can rename an element directly. May be i am wrong but at least i couldn't find its solution.
I changed the structure of my xml file and used a generic name for xml element and stored the data as attribute...e.g.
<element1 attr="niv1">
<element2 attr="niv2">
</element2>
</element1>
This way you can easily modify the attributes of element.
Another possible way (if you don't want to change the structure of xml file) might be by storing the innerXml of node to be renamed, then delete that node and create new node with modified name and assign innerXml to that new node.
Hope that helps, if i have made any mistake please correct me. I would love to know if there is any other way of renaming an element.
Thanks,
Regards,
Affan Ahmad Toor
..................
QUAIDIAN FOR ONCE, QUAIDIAN FOR EVER!
|
|
|
|
|
I cant change the structure of my xml files, because I have over 4000 of them. 
What I tried is to copy a node if it is named for example niv1, delete it, and create a new node with the new name and add the content that I copied erlier.
But I dont get it to work.
|
|
|
|
|
Phrone wrote: What I tried is to copy a node if it is named for example niv1, delete it, and create a new node with the new name and add the content that I copied erlier.
But I dont get it to work.
That's what I'd think is way to do it, what problem do you have with this approach?
"Throughout human history, we have been dependent on machines to survive. Fate, it seems, is not without a sense of irony. " - Morpheus
"Real men use mspaint for writing code and notepad for designing graphics." - Anna-Jayne Metcalfe
|
|
|
|
|
dnh wrote: Phrone wrote:
What I tried is to copy a node if it is named for example niv1, delete it, and create a new node with the new name and add the content that I copied erlier.
But I dont get it to work.
That's what I'd think is way to do it, what problem do you have with this approach?
I'm not sure what I do wrong. And I've tried to find code samples to see how other done, but with no luck.
MSDN doesn't have much information about it either.
|
|
|
|
|
try doing this:
string nodeData = "";
XmlDocument xmlDoc = new XmlDocument();
XmlNode root = xmlDoc.DocumentElement();
XmlNodeList nodeList = root.GetElementByTagName("nav1");
XmlNode node = nodeList[0];
if(node!=null)
{
nodeData = node.InnerXml;
root.RemoveChild(node);
//Create new node with modified name
XmlElement newNode = xmlDoc.CreateElement("New nav1");
newNode.InnerXml = nodeData;
root.AppendChild(newNode);
}
hope that helps...
..................
QUAIDIAN FOR ONCE, QUAIDIAN FOR EVER!
|
|
|
|
|
This code gives me errors.
Error 1 'System.Xml.XmlDocument.DocumentElement' is a 'property' but is used like a 'method' U:\ModXML\ModXML\GUI.cs 265 43 ModXML
Error 2 'System.Xml.XmlNode' does not contain a definition for 'GetElementByTagName' U:\ModXML\ModXML\GUI.cs 266 49 ModXML
Affan Toor wrote: try doing this:
string nodeData = "";
XmlDocument xmlDoc = new XmlDocument();
XmlNode root = xmlDoc.DocumentElement();
XmlNodeList nodeList = root.GetElementByTagName("nav1");
XmlNode node = nodeList[0];
if(node!=null)
{
nodeData = node.InnerXml;
root.RemoveChild(node);
//Create new node with modified name
XmlElement newNode = xmlDoc.CreateElement("New nav1");
newNode.InnerXml = nodeData;
root.AppendChild(newNode);
}
hope that helps...
|
|
|
|
|
I'm going to be slightly annoying here but that is exactly what XSLT[^] was designed for. You can execute the transformations from .NET by using the XslTransformation (I think that's it's name) class.
|
|
|
|
|
I dont know so mutch about XSLT, but isn't it so that it doesn't change the element names only the apperance?
Ed.Poore wrote: I'm going to be slightly annoying here but that is exactly what XSLT[^] was designed for. You can execute the transformations from .NET by using the XslTransformation (I think that's it's name) class.
|
|
|
|
|
No, basically it's a scripting language which can transform one xml document into another (text) document. You can get it to output any form of text, plain text, xml, html etc. The transformations won't affect the original file unless you overwrite it. What you may be thinking of is you can link a stylesheet into an xml file (link a css stylesheet into html) and when IE or FF go to display it they try to find the stylesheet and apply the transformation (what it'll normally output is a nice-pretty formatted html version of the xml file so that it's easier to read than a plain xml file).
|
|
|
|
|
Hi
How Can I Run A Form In External Seluotion
|
|
|
|
|
What do you mean by that?
Forms are in projects, projects are in solutions. So, what type of project is the form in? If it is a class library then that's easy to do. You can add a project to many solutions - just add the project the form is in to the solution that you want to use it in and then add the appropriate reference in project that you want to use the form in.
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
* Reading: Developer Day 5
Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton
My website
|
|
|
|
|
I Mean That I have tow projects first project Will be the menu witch Call the Other projects ? How Can I Do That My Forms Is Not in one selution or 1 project its destiputed
|
|
|
|
|
Do you mean you want to make a program that will start your other programs? Look at the Process class.
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
