|
ashkitt,
You can use the ID (userId) or the related column right. Text comparisons are slower.
Also, one suggestion. Comparing against TextBox1.Text directly in a query is a potentially dangerous thing and that too in a Web Application, which I think would open doors for SQL Injection attacks.
You may like to move this into a Stored Procedure rather.
Vasudevan Deepak Kumar
Personal Web: http://www.lavanyadeepak.tk/
I Blog At: http://deepak.blogdrive.com/
|
|
|
|
|
Change the data type of the FirstName field to VarChar or NVarchar. You don't need a text or ntext field for this, FirstName should not exceed 4000 characters...(limit for the size of an nvarchar is 4000 unicode characters)
Don't arbitrarily make fields text,ntext or image type, since, as you have seen, they can't be compared... They are also substantially slower to retrieve as the always involve an extra level of indirection in the database.
Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
All that is necessary for the triumph of evil is that good men do nothing.
Edmund Burke
|
|
|
|
|
Thanx Rob,
Problem solved )
|
|
|
|
|
I want to program an application that runs as a trayicon in the taskbar - I dont need any window.
But a notifyIcon seems to depend on an activ form so I don't get how to do it!  Please help me...
|
|
|
|
|
You can always hide your form at startup, so the user would see only the taskbar icon. The other option is to run your own message pump using Application.Run, which is slightly more difficult to do.
Regards
Senthil
_____________________________
My Blog | My Articles | WinMacro
|
|
|
|
|
I know how to hide my App (you mean by setting visible to false, don't you?) - this is no difficult task but isn't my application using some more ressources of my computer? For that I don't need a window, the resources would be wasted. Maybe you (or anybody else) can give me a link for a tutorial or something else which explains how to build my own message pump as you proposed.
|
|
|
|
|
Dear all,
I have a database that contains numbers. I want to draw the Normal distribution graph for a column in my C# program and display it in a panel or a form (in whatever)
is there a way to do that?
thanks very much
|
|
|
|
|
mhmo
You may try to use a Graphing component, which exports as GIF and then embed that GIF into the panel.
It works like this:
<img src="graph.aspx?<regdparams>">
graph.aspx would be using the Graph component which plots the graph and exports it as GIF.
Vasudevan Deepak Kumar
Personal Web: http://www.lavanyadeepak.tk/
I Blog At: http://deepak.blogdrive.com/
|
|
|
|
|
I hope that u understand my question.
I will take the numvers from a database in one column and it is a form not a web page.
|
|
|
|
|
I have an application with multiple forms, and can't figure out how to make their variables and functions visible to one another. This is what I'd like to do:
<br />
namespace app1<br />
{<br />
<br />
public class Form1<br />
{<br />
public int state;<br />
private void btn_LoadForm_Click(...)<br />
{<br />
Form2 f = new Form2();<br />
f.Show();<br />
}<br />
public void SetState(int x)<br />
{<br />
state = x;<br />
}<br />
}<br />
<br />
public class Form2<br />
{<br />
private void Form2_Load (...)<br />
{<br />
Form1.SetState(1);<br />
}<br />
}<br />
<br />
Why doesn't this work? How do I make this work?
Thanks, -mutty
|
|
|
|
|
That doesn't work because Form1 is not an object, it's a class. You have to have a reference to the specific object to access non-static members of the class.
You can send a reference to the first form in the constructor of the second form:
Form2 f = new Form2(this);
Add a reference in Form2 and store the reference to the first form:
private Form mainForm;<br />
<br />
public Form2(Form mainForm) {<br />
this.mainForm = mainForm;<br />
}
Then you can reach the first form:
private void Form2_Load(...) {<br />
this.mainForm.SetState(1);<br />
}
---
b { font-weight: normal; }
|
|
|
|
|
I understand all this except the line:
this.mainForm = mainForm;
Do I need to declare a form mainForm in form2?
|
|
|
|
|
The line takes the reference to Form1 and stores it in the private variable.
"this.mainForm" refers to the private variable in the Form2 class. "mainForm" refers to the parameter that you send to the constructor.
---
b { font-weight: normal; }
|
|
|
|
|
Thank you very much for the assistance. I have it working now! -mutty
|
|
|
|
|
Hi, all,
I use below command to get X drive to be mapped. I get the drive but it is not actived. I need to double click on it to make it active. Is it possible to make it active in the programs.
string strCmdLine;
strCmdLine = "/C net use X: \\\\locla01\\d$ \"******\" /user:coby";
System.Diagnostics.Process.Start("CMD.exe",strCmdLine);
I appreciate your help.
Thanks.
coby
coby
|
|
|
|
|
Hello everybody
Can you please tell me how can i start the explorer search engine from within a c# program... say.. when i press a button...just as if i would press
start\search\For Files or Folders...
please help me... thx
|
|
|
|
|
|
Hope this helps... thank you.
|
|
|
|
|
Hi,
Is there a way to make NumericUpDown controls unlimited in the number that's allowed to be entered? I think the default maximum is 100.
Thanks,
Yigal
|
|
|
|
|
Unlimited is not possible, how could a computer store unlimited numbers?
The NumericUpDown uses the "decimal" datatype, which has a maximum value of 79228162514264337593543950335.
Set the Maximum property of the NumericUpDown control to the value you want to use.
|
|
|
|
|
Hello all,
I have an XML schema that has been converted to a class file using the Framework XSD tool, this schema has default values specified within it and these have been carried across into the schema class. If I read in an XML file and then deserialise it to an object if any of the elements are not present the default value is picked up and the object uses that instead.
All it good, code works fine, I have happy little imps running around inside my head.
but......
For logging purposes I would like to know when this happens, ie. when the deserialiser uses the class based default value. The only solution I can think of is to parse through either the text XML or the desrialised object, which is an for to much additional processing for my liking.
Parsing the object values also present the problem that the XML file may actually contain the default value so you wouldnt know if it came from the XML file or the class defaults.
On a similar subject, XSD generate default values using the following header:
[System.ComponentModel.DefaultValueAttribute("localhost")]
public string blah = "localhost";
Is there any way in code I can access the DefaultValueAttribute??
post.mode = postmodes.signature;
SELECT everything FROM everywhere WHERE something = something_else;
> 1 Row Returned
> 42
|
|
|
|
|
hi.
I new to C# and would like to know how i send an ARP packet to a computer using sendarp from iphlpapi.dll.
I saw this code somewhere on the web, and its what i need. but i have little idea how to use it:
[DllImport("iphlpapi.dll", ExactSpelling = true)]
public static extern int SendARP(int DestIP, int SrcIP, [Out] byte[] pMacAddr, ref int PhyAddrLen);
I can see that a function is being build.
Can i just use it by doing this:
Int32 IP = Convert.ToDecimal(192.168.0.1);
SendARP(IP,0,0,IP.Length)
or how do i do it ?
|
|
|
|
|
Mmm, no, that won't work.. You can't create integer IP's from just using Convert.ToDecimal(). That would be too simple.
Also, you can't pass in a 0 for the 3rd parameter, it's a byte[] that's returned out as your data that you receive from the ARP I think (I haven't done any research, I'm just letting you know basic things that are wrong.)
What this all means is that you need to:
a) Declare a byte[] to use for the 3rd parameter. I'd reccomend using one that's got a decent length, like 256...declared as so: byte[] buffer = new byte[256]; (Note: You might not even need to declare a length, since you have that ref integer parameter that seems to tell you how much data you got out of the function - I'd try both ways)
b) for the 4th parameter, you need to declare an integer before calling the function, then pass that integer in as a ref parameter...that variable will hold the length of the actual output from the function (how much data it filled in the buffer)
c) you need IP's as integers...fortunately for you, I've written code that does that.
public static int StringIPToInt(string IPString)
{
string[] _splitString = IPString.Split(new char[]{'.'});
int _retVal = 0;
if (_splitString.Length < 4)
throw new ArgumentException("Please pass in a valid IP in dotted-quad notation!","IPString");
else
{
_retVal += (int)(int.Parse(_splitString[3]) * Math.Pow(256,0));
_retVal += (int)(int.Parse(_splitString[2]) * Math.Pow(256,1));
_retVal += (int)(int.Parse(_splitString[1]) * Math.Pow(256,2));
_retVal += (int)(int.Parse(_splitString[0]) * Math.Pow(256,3));
}
_retVal = (int) (((_retVal & 0x000000ff) << 24) +
((_retVal & 0x0000ff00) << 8) +
((_retVal & 0x00ff0000) >> 8) +
((_retVal & 0xff000000) >> 24));
return _retVal;
}
I won't go into detail except that all the compound addition you see is parsing the dotted-quad notation and creating an integer value to represent it (dotted-quad just stores the 32 bits of an IP address as four octets, so it's easy to go back to a 32bit integer). The last bit of code with all the bitshifting and binary AND's flips the endianness of the output integer so that you have the correct value.
So, a call like this may be appropriate:
byte[] outputData;
int dataLength = 0;
SendARP(StringIPToLong("192.168.1.101"),StringIPToLong("127.0.0.1"),outputData,ref dataLength);
I would then use BitConverter.ToString() or something similar to get human-readable data out of that buffer byte[].
|
|
|
|
|
I think i have figured the SendARP() out now, but i still can't give it the IP destination in integer.
i tried with the code you provieded me, like this:
<br />
public partial class _Default : System.Web.UI.Page <br />
{<br />
[DllImport("iphlpapi.dll", ExactSpelling = true)]<br />
public static extern int SendARP(int DestIP, int SrcIP, [Out] byte[] pMacAddr, ref int PhyAddrLen);<br />
<br />
protected void Page_Load(object sender, EventArgs e)<br />
{<br />
<br />
}<br />
protected void Button1_Click(object sender, EventArgs e)<br />
{<br />
byte[] outputData = new byte[6];<br />
int dataLength = outputData.Length;<br />
SendARP(StringIPToLong("192.168.1.101"), StringIPToLong("127.0.0.1"), outputData, ref dataLength);<br />
Label1.Text = "MAC:" + BitConverter.ToString(outputData, 0, 6);<br />
}<br />
<br />
public static int StringIPToInt(string IPString)<br />
{<br />
string[] _splitString = IPString.Split(new char[] { '.' });<br />
int _retVal = 0;<br />
if (_splitString.Length < 4)<br />
throw new ArgumentException("Please pass in a valid IP in dotted-quad notation!", "IPString");<br />
else<br />
{<br />
_retVal += (int)(int.Parse(_splitString[3]) * Math.Pow(256, 0));<br />
_retVal += (int)(int.Parse(_splitString[2]) * Math.Pow(256, 1));<br />
_retVal += (int)(int.Parse(_splitString[1]) * Math.Pow(256, 2));<br />
_retVal += (int)(int.Parse(_splitString[0]) * Math.Pow(256, 3));<br />
}<br />
_retVal = (int)(((_retVal & 0x000000ff) << 24) +<br />
((_retVal & 0x0000ff00) << 8) +<br />
((_retVal & 0x00ff0000) >> 8) +<br />
((_retVal & 0xff000000) >> 24));<br />
return _retVal;<br />
}<br />
The error i get is:
Default.aspx.cs(24): error CS0103: The name
'StringIPToLong' does not exist in the current context
That sound like it can't find the StingIPToLong function in the current codeblock, but the function is declared "public" so i thought that it worked in all codeblocks.
|
|
|
|
|
GentooBoxX wrote:
That sound like it can't find the StingIPToLong function in the current codeblock, but the function is declared "public"
Look at your code. You renamed the function to "StingIPToInt" but are calling "StringIPToLong"
Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
All that is necessary for the triumph of evil is that good men do nothing.
Edmund Burke
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
