Re: Handle string - C# Discussion Boards

NormBohana1-Jun-05 13:53

NormBohana

1-Jun-05 13:53

Thanks Christian, Visual Studio generated the stored procedures like they are. I added the '@' to the variables, and the code runs but nothing is stored in the database. Do you have anyother ideas, I am stuck at this point. I am doing more research into the problem so any help that I can get will help.

Norm
Frown | :(

Christian Graus1-Jun-05 13:56

1-Jun-05 13:56

Can you run the stored procedure in query analyser ? If you can, and it works, then the problem is in your code ( the SP looks fine to me, but you should check to be sure )

Also, have you stepped through to see if the code branch where it checks if the connection is open succeeds ? I don't see any code to notify you if the problem is that the connection is closed.

Christian Graus - Microsoft MVP - C++

NormBohana2-Jun-05 19:14

NormBohana

2-Jun-05 19:14

Christian, I can run the stored procedure in the sql analyzer, and its runs. I have since found out that my code was wrong. I have rewritten the code and here it is. I cannot find an example of what to in the datareader. Cannot you direct me to some doc. that I can use, it would help. I have purched Microsoft ADO.net its close but no example on how to use a insert stored procedure. Thanks

Norm Sniff | :^)

try
{

sqlUpdateCommand1.Connection = sqlConnection1;
if (sqlConnection1.State != ConnectionState.Open)
{
sqlConnection1.Open();
}

SqlCommand cmd = new SqlCommand("InsertCommandService");
cmd.CommandType = CommandType.StoredProcedure;

SqlParameterCollection pc = cmd.Parameters;

pc.Add("[@service-code]",SqlDbType.Int, 4);
pc.parameters[0].value = txtServiceCode.Text;
pc.Add("[@service-description]",SqlDbType.Char, 30);
pc.parameters[1].value = txtServiceDesc.Text;
pc.Add("[@large-animal-cost]",SqlDbType.Money, 8);
pc.parameters[2].value = cbLargeAnimalCost.Text;
pc.Add("[@medium-animal-cost]",SqlDbType.Money, 8);
pc.parameters[3].value = cbMediumAnimalCost.Text;
pc.Add("[@small-animal-cost]",SqlDbType.Money, 8);
pc.parameters[4].value = cbSmallAnimalCost.Text;

SqlDataReader rdr = pc.ExecuteReader();
if (rdr.Read())
{

}

this.Close();

Christian Graus5-Jun-05 10:46

Tracking time of user in AD

5-Jun-05 10:46

NormBohana wrote:
pc.Add("[@small-animal-cost]",SqlDbType.Money, 8);

Lose the square brackets. Where did they come from ? I dunno why I didn't see that before.....

Christian Graus - Microsoft MVP - C++

shaima'31-May-05 18:46

shaima'

31-May-05 18:46

Hello...

I'm trying to track the time for a user who login from Active directory in a domain controller. I'm having a problem with in which I don't know how to do that actually in real time, so that controlling the access of the user say about 10 hours only, after that the account will be disabled, I don't want that the user use these hours sequentially, but in a whatever manner he wants it, I mean login say for 5 hours then he logout, so my counter should check the remaining time for him , and if the total time is 10 hours the remaining time for him is 5 hours, so when he access again the domain controller he has only 5 hours remaining.
Can you help me with this problem, please.
Or if you know anyone who can help me with this problem or any articles discuss this problem. Confused | :confused:

Thanks in advance.

Handle string

rockxuyenmandem31-May-05 17:49

rockxuyenmandem

31-May-05 17:49

How can i do to replace Html Tag
For example in my project when i input <br> or <p> the error message will display
Could you can write an function in C# to replace the HTML Tag
Thanks for helping.

I tried so hard and got so far

Re: Handle string

MoustafaS31-May-05 20:08

MoustafaS

31-May-05 20:08

You can make a function that replaces all the ( < ) tags with (_&_l_t_;_)(<)
and the closing tag( > ) with (_&_g_t_;_). (>)
Note:
You must remove the underscore character (_) from all the codes.

Re: Handle string

Carsten Zeumer31-May-05 21:04

Carsten Zeumer

31-May-05 21:04

If you need an HTML-Encoded string you can use the System.Web.HttpUtility.HtmlEncode function.
You must reference the System.Web assembly to use this function.

If you need to actually strip the Html tags you coud use a regular expression like this:

// replace br an p tags with linefeed<br />
string cleanedText = System.Text.RegularExpressions.Regex.Replace(htmlString,@"(?:</?(br|p)[^>]*>)","\r\n");<br />
// remove tags<br />
cleanedText = System.Text.RegularExpressions.Regex.Replace(cleanedText,@"(?:<[/!]?([A-Z][A-Z0-9]*)[^>]*>)","");

This code is very basic. It will not strip scripts nor will it handle tables pretty well.

I hope this is at least a start for you.

ActiveX Autocad

Newbie_Toy31-May-05 17:29

31-May-05 17:29

Is there a ActiveX of Autocad for C#.NET? Thank you.

Christian Graus31-May-05 17:38

31-May-05 17:38

If Autocad exposes a COM object, you can import it into C# and call it.

Christian Graus - Microsoft MVP - C++

Newbie_Toy31-May-05 19:11

31-May-05 19:11

How can I know?

Christian Graus31-May-05 21:46

31-May-05 21:46

Read the docs ? Google ? Look for samples that came with it ?

Christian Graus - Microsoft MVP - C++

Reanalyse31-May-05 22:09

Reanalyse

31-May-05 22:09

There is CADIO (search for DXF on the site).
It is for unmanaged C++ so does not work directly in C#

Joel Lucsy2-Jun-05 15:34

Joel Lucsy

2-Jun-05 15:34

AutoCAD 2005 and 2006 have managed assemblies you can use. Otherwise you can ActiveX interface that AutoCAD has supported since AutoCAD 2000.

--
Joel Lucsy

Newbie_Toy2-Jun-05 16:45

2-Jun-05 16:45

Thank you for u answer but please give me some example. Sigh | :sigh:

Joel Lucsy3-Jun-05 2:37

Joel Lucsy

3-Jun-05 2:37

I might be able to, but you didn't say what version of AutoCAD you had, what approach you'd like to take, nor the scope of what you're trying to attempt.

--
Joel Lucsy

Newbie_Toy3-Jun-05 17:17

3-Jun-05 17:17

I have autocad 2006. I want to develop my application can view AutoCad File (DWG) with some feature like zoom-in zoom-out.

WindowsLocation and Mouse CoOrds.

Joel Lucsy6-Jun-05 3:42

Joel Lucsy

6-Jun-05 3:42

It sounds like you're trying to create a viewer external to AutoCAD. This isn't really possible without licensing specific things from AutoDesk.

--
Joel Lucsy

Akrynite31-May-05 16:01

Akrynite

31-May-05 16:01

So I'm making an application that alters another Windows program. I want to do it buy synthesizing mouseclicks. I have that aspect working, what I need to do now is determine the location. I'm using GetWindowLocation, However the values it returns are kind of absurd. SO I'll post my code(stolen mostly from another post) and if anyone can figure out where I went wrong...

<br />
[DllImport("user32.dll")]<br />
private static extern bool GetWindowPlacement(IntPtr hWnd, ref WindowPlacement placement);<br />
public struct WindowPlacement{<br />
	public uint length;<br />
	public uint flags;<br />
	public uint showCmd;<br />
	public POINT ptMinPosition;<br />
	public POINT ptMaxPosition;<br />
	public RECT rcNormalPosition;<br />
}<br />
public struct POINT{<br />
public long x;<br />
public long y;<br />
}<br />
public struct RECT{<br />
	public long left;<br />
	public long top;<br />
	public long right;<br />
	public long buttom;<br />
}

That's my structure definitions.
I call it like this

<br />
WindowPlacement Place;<br />
GetWindowPlacement(Handle, ref Place);<br />

Ok so there it is, the values return seem pretty absurd. Negative numbers 15 digits long and such, nothing I can make a mousepointer move to without errors. Anyhelp would be great.
jake

Re: WindowsLocation and Mouse CoOrds.

Christian Graus31-May-05 16:23

Re: stand alone application

31-May-05 16:23

In C++, a long and an int are both the same size. Change the longs to ints in POINT and RECT, and the rcNormalPosition will become valid and accurate, I've just tested it.

Christian Graus - Microsoft MVP - C++

stand alone application

ABBASI_RA31-May-05 15:20

ABBASI_RA

31-May-05 15:20

hi how i can make a stand alone c# windows application?
thanks

Miguel Andrés31-May-05 15:25

Miguel Andrés

31-May-05 15:25

select the project type Windows Application in Visual Studio?

The only thing you need is the .NET framework

Syntax colorizing a textbox

HRiazi31-May-05 14:19

HRiazi

31-May-05 14:19

Hey guys;

I want to know how can I syntax colorize a textbox. Like puting a little squiggly MSword underline under a text or letter.

Any ideas please write.
Thanks

Re: Syntax colorizing a textbox

Christian Graus31-May-05 15:32