|
Any sql query with more then 2100 parameters should be looked at. the design for this must need reworking!
|
|
|
|
|
I think this one qualifies as a coding horror and a WTF!  
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
Why are you using VB6? Do you hate yourself? (Christian Graus)
|
|
|
|
|
What's the error? BloodyStupidSQLStatementException?
|
|
|
|
|
I never thought I'd say anything good about MS access, but depending on the query type it limits you to either 127 or 255 parameters per query. (Don't ask how I know this.  )
It is a truth universally acknowledged that a zombie in possession of brains must be in want of more brains.
-- Pride and Prejudice and Zombies
|
|
|
|
|
Holy what?!!!!! Surely, you cannot be serious. 2100 parameters? Dude, you must be doing something extremely bad to get into that situation...
Regards,
Rob Philpott.
|
|
|
|
|
What database system? What ADO.net connector? Is the database local or on a remote server? What Exception is thrown? Does it succeed with 2100 parameters? Why would you try anyway?
|
|
|
|
|
shine_paravur wrote: with more 2100 parameters
Dude, you need Code Consultation Officer. Please go to your nearest Emergency Code Consultation Office Immediately. This could be life career threatening issue.
|
|
|
|
|
Hi,
Can we find on which platform the dll/.Net assembly has been build? Either on x64 or x86.
I want to find this through C# code.
I tried this through reflection but not able to find correct property.
Thanks in Advance.
|
|
|
|
|
From memory, the Environment class has members to discover the system processor.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
Thanks for reponse.
From that i will get the current CPU bits, but what i want to find is that,
I will get a dll as input and from that i need to find on which platform it has been
builted. Does it support x86 or x64 or both.
Thanks
|
|
|
|
|
Well, if built with X64 it won't run on 32 bit Windows, not sure about the other way round though.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
I wouldn't like to say for sure that you can't but I'd expect not. Assemblies are after all a load of metadata tables and MSIL instructions. The very essence of it all is that MSIL isn't linked to one particular processor - the JIT compiler does that at runtime.
Why do you need to know this?
Regards,
Rob Philpott.
|
|
|
|
|
Do you mean you want to find out whether it has been build for "x86" or "x64" or "I64" or "Any CPU"?
If you just need to distinguish between 64/32bit at runtime you can look at the size of IntPtr.
|
|
|
|
|
If it's built for x64, the .exe/.dll file will use PE32+.
For x86 or AnyCPU assemblies, it'll use PE32.
If you need to find the difference between AnyCPU and x86-only assemblies, you'll need to look at the 32-bit flag in the CLR Runtime Header.
You can find the documentation of the .dll/.exe file format on http://www.microsoft.com/whdc/system/platform/firmware/PECOFF.mspx[^].
|
|
|
|
|
Is there any built in method that create a boolean array from a byte or int - basically a bit array indicating whether each element (bit) is set or not?
I've easily created my own function to do this but wondered if there was already an in built method?
[Edit] Jst found the BitArray class that will take a byte[] parameter and set the bits accordingly  [/Edit]
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
Why are you using VB6? Do you hate yourself? (Christian Graus)
|
|
|
|
|
I dont think there is the way you describe. But depending on your needs for it you could use an enum with the 'Flags' attribute. This can be set as a whole be passing it a byte or int...
[Flags]
public enum MyFlags{
Flag1,
Flag2,
Flag3,
Flag4
}
public MyFlags myFlags = 4;//set with int or byte value
this will result in Flag3 being set and the others not set... likewise, assigning a value of '6' would set both Flag2 and Flag3.
Life goes very fast. Tomorrow, today is already yesterday.
|
|
|
|
|
The BitArray class did it. It's actually a UInt16 (from an interop function) that I needed to convert.
_ChannelMask is the UInt16 and _ChannelAvailability is the Boolean[]
new BitArray(new byte[] { (byte)_ChannelMask, (byte)(_ChannelMask >> 8) })
.CopyTo(_ChannelAvailability, 0);Thanks for the suggestion 
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
Why are you using VB6? Do you hate yourself? (Christian Graus)
|
|
|
|
|
hi
had a look in the BitArray class in the System.Collections namespace.
maybe this will help you.
regards
|
|
|
|
|
Thanks - I actually discovered that class just after posting! Serves me right for not googling for BitArray!
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
Why are you using VB6? Do you hate yourself? (Christian Graus)
|
|
|
|
|
the following code plays video files by storing it in a playlist.But it stops when the last file is played. I want the files to play in repeat mode...how can i enable repeat mode, in my code
plz help-----
thanks !!!!
**************************************************************************
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.IO;
namespace WindowsApplication1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
System.IO.FileInfo[] files = null;
int index = 0;
string plist;
private void Form1_Load(object sender, EventArgs e)
{
System.IO.DirectoryInfo df = new DirectoryInfo("C://Images");
files = df.GetFiles("*.wma");
WMPLib.IWMPPlaylist pl;
pl = axWindowsMediaPlayer1.mediaCollection.getByName(plist);
WMPLib.IWMPMedia m;
if (files != null)
{
if (files.Length <= index)
{ index = 0; }
else
{
m = axWindowsMediaPlayer1.newMedia(files[index++].FullName);
pl.appendItem(m);
}
}
axWindowsMediaPlayer1.currentPlaylist = pl;
}
}
}
**************************************************************************
----mist-----
|
|
|
|
|
create a bool field
bool keepPlaying = true; then<br />
<pre><br />
while (keepPlaying)<br />
{<br />
pl.Clear()
if (files != null)<br />
{<br />
if (files.Length <= index)<br />
{<br />
index = 0;<br />
}<br />
else<br />
{<br />
m = axWindowsMediaPlayer1.newMedia(files[index++].FullName);<br />
pl.appendItem(m);<br />
}<br />
<br />
}<br />
<br />
axWindowsMediaPlayer1.currentPlaylist = pl;<br />
}<br />
<br />
</pre><br />
<br />
then you can have a cancel button and in the <code>onclick handler have keepPlaying = false;. Of course that will only stop when it reaches the end of the playlist, unless you also stop the player when setting the flag to false.
You are having a lot of problems getting this application working, mostly with concepts that are elementary. I would seriously suggest that you get a C# getting started book and work through it, before continuing.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
Hi guys,
Hope you are doing well.
I have a Onix complaint XML document that I want to validate it with some Onix complaint DTD. I did coding for same in C#
XmlReaderSettings settings = null;
try
{
string xmlPath = Server.MapPath("XML/nielsen_onix.XML");
//Load XML into XmlTextReader
// reader = new XmlTextReader(xmlPath);
//Load XmlTextReader into XmlValidatingReader
settings = new XmlReaderSettings();
//Set the validation type
settings.ValidationType = ValidationType.DTD;
settings.ProhibitDtd = false;
settings.CheckCharacters = false;
//Hook up the XmlValidatingReader’s
//ValidationEventHandler to a call
//back method named ValidationCallBack
settings.ValidationEventHandler += new ValidationEventHandler(
this.ValidationCallBack);
XmlReader reader = XmlReader.Create(xmlPath, settings);
//Read through the XML document by calling
//the Read() method
while (reader.Read()) { }
//Check boolean field named valid (located at top of code)
if (valid)
Response.Write("Validation is Successful!");
reader.Close();
}
catch(Exception ex) {
Response.Write(ex.Message);
}
This code runs good and show the xml file invaid while my xml file is valid when I validated it on
http://www.w3schools.com/XML/xml_validator.asp[^]
Could you please check what's wrong going with me?
Any help would be highly appreciable.
Thanks
Rohit
|
|
|
|
|
I am a new c# programmer and i need to create a c# program which can connect to a network printer and swap the ports i.e if printer 1's port is 192.11.36.1 and printer 2's port is 192.11.36.3 i need to be able to swap these over by the click of a button then switch them back again. Please Help
|
|
|
|
|
I am using System.Data.DataRelation object to get the child rows using DataRow.GetChildRows method. GetChildRows method works for 100000 records but when there are 100001 records it do not return any child rows. Is there any limitation for this?
Thanks
|
|
|
|
|
Hi, my project is in ms studio 2005. when i use comm component(axWinSock)
in my project and again installed it to the client pc.
the program is not running.
"it gives an error project.exe encountered an error needs to close"
however
i installed .Net Freamwork 2.0 on that machine but problem is same..
i copied the mscomm.ocx file in the system32 folder but i could not solve this..
the mswsock.dll is also available on client side...
* What is the funda behind the comm component.. ?
* is there any program that I have to run on client machine..
![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
