Re: Help in HTML tags entry in SQL server - C# Discussion Boards

Problem in inserting large data in database!

Affan Toor6-Apr-07 3:45

6-Apr-07 3:45

Hi!
i am facing problem when inserting very large amount of data in database. my application inserts 100,000 or more records in database but when i try to insert only 1000 records it takes too much time, approximately 2-3 minutes. and when i try to insert more than 1000 records application crashes.

I am using Microsoft Access and C# for my application. one more thing i am not using Stored procedures for this.

Can anybody tell me how can i make this insertion fast...?

Thanks in advance..

Regards,
Affan Ahmad Toor

Re: Problem in inserting large data in database!

Not Active6-Apr-07 5:01

Not Active

6-Apr-07 5:01

Affan Toor wrote:
Can anybody tell me how can i make this insertion fast...?

Don't use Access. Use SQL Express or SQL Server COmpact Edition

only two letters away from being an asset

Re: Problem in inserting large data in database!

Affan Toor6-Apr-07 5:19

Affan Toor

6-Apr-07 5:19

Hi!
Thanks for reply! is it the only solution for my problem...? migrating from Access to SQL Server will cost alot of time and effort, i will have to do alot of work again...

Is there any other option like optimizing code or any thing else...? please dont tell me that i am standing on a dead end...!! Frown | :(

Regards,
Affan Ahmad Toor

Re: Problem in inserting large data in database!

Not Active6-Apr-07 5:27

Not Active

6-Apr-07 5:27

Access is not the best tool for that amount of data.

Affan Toor wrote:
alot of time and effort, i will have to do alot of work again...

Depends on your data structure and coding. If your data layer were properly constructed the changes should be minimal.

only two letters away from being an asset

Disabling any particular property form the Property List at Design Time

Arijit Majumder6-Apr-07 2:20

Arijit Majumder

6-Apr-07 2:20

Hi,
At design time there are a lot of properties that are available for a particular form or a control in the form. Those properties can be changed in the design time. But how do I disable/hide any one of these properties so that the designer cannot edit/update that property while designing. For ex: Say there is a button in a form. I want to disable the Image property in the Property List, so that the designer of the form cannot edit/put any Image on the Button. Is there any function/api present that can do so?

Re: Disabling any particular property form the Property List at Design Time

Not Active6-Apr-07 3:17

Not Active

6-Apr-07 3:17

Place the Browsible(false) attribute on the property.

http://msdn2.microsoft.com/en-us/library/system.componentmodel.browsableattribute(vs.71).aspx[^]

only two letters away from being an asset

Help in HTML tags entry in SQL server

EEmaan6-Apr-07 2:01

EEmaan

6-Apr-07 2:01

Hi!
I m developing an application in C# asp.net....when i give value like <abc>in my text box and then insert it into sql server by using insert query ....it gives exception message

A potentially dangerous REquest.Form value was detected from the client

is there any way to insert values like this coz i have to do it must

Re: Help in HTML tags entry in SQL server

Not Active6-Apr-07 3:06

Not Active

6-Apr-07 3:06

The exception is being thrown is a SqlException? Or is it from the page? It is more likely the exception is being thrown from the page as a HttpRequestValidationException. Setting ValidateRequest=true on the page will stop this, however it opens you potentially dangerous attacks.

ValidateRequest
Indicates whether request validation should occur. If true, request validation checks all input data against a hard-coded list of potentially dangerous values. If a match occurs, an HttpRequestValidationException exception is thrown. The default is true.

This feature is enabled in the machine configuration file (Machine.config). You can disable it in your application configuration file (Web.config) or on the page by setting this attribute to false.

Note
This functionality helps reduce the risk of cross-site scripting attacks for straightforward pages and ASP.NET applications. An application that does not properly validate user input can suffer from many types of malformed input attacks, including cross-site scripting and Microsoft SQL Server injection attacks. There is no substitute for carefully evaluating all forms of input in an application and making sure that they are either properly validated or encoded, or that the application is escaped prior to manipulating data or sending information back to the client.

only two letters away from being an asset

Re: Help in HTML tags entry in SQL server

EEmaan6-Apr-07 5:42

EEmaan

6-Apr-07 5:42

thanx i will try that then i will inform U Smile | :)

Access violation writing location 0x00000000

Farhan Ali6-Apr-07 1:50

Farhan Ali

6-Apr-07 1:50

Asalam o Alaikum:

I have made a desktop application in c# which gets text from the controls like textboxes.on some forms it works fine but sometime gives this error

Access violation writing location 0x00000000

how this error can be removed.

Thanx

Re: Access violation writing location 0x00000000

rp_suman6-Apr-07 2:12

rp_suman

6-Apr-07 2:12

This will happen when you assign something to a NULL pointer.
Put a break point and debug step by step. See the variable at the left of error happening line.
Best Regards,
Suman

Re: Access violation writing location 0x00000000

Farhan Ali6-Apr-07 2:22

Farhan Ali

6-Apr-07 2:22

It happens when this line executes

SendMessage(lvwHwnd, LVM_GETITEMTEXT, selectedrow, _lvi);

_lvi is the pointer which is not null it has some address.

hopefully this info will help u to answer

Thanx

Re: Access violation writing location 0x00000000

CPallini6-Apr-07 3:12

CPallini

6-Apr-07 3:12

Seems the wrong forum (C++ one is more appropriate), anyway...

you have to pass valid pointer to a valid LVITEM struct, i.e. a properly initialised struct (you have to take special care with pszText and cchTextMax members, the former must point to an allocated buffer, the latter must contain the size of the buffer itself, see MSDN [^]).

Hope that helps.

Smile | :)

If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.

Re: Access violation writing location 0x00000000

Luc Pattyn6-Apr-07 4:21

Luc Pattyn

6-Apr-07 4:21

Hi,

if you happen to send a message to another process, and that message needs an address,
then that address must be valid in that process, not in the local process.

whatever, publishing the entire method (and relevant data members) may allow us
to comment.

Smile | :)

Luc Pattyn

[My Articles]

How to enerate random numbers in C#

Test2703076-Apr-07 1:26

Test270307

6-Apr-07 1:26

Hello,

I want to generate random numbers to rename files when i uploaded employees CV.
suppose first i uploaded a cv for emp1 name aa.doc i rename it a random numbers.
then i uploaded a cv for emp2 name bb.doc. but also that files i remaned it randomly.

pls help me.

thanks.

Re: How to enerate random numbers in C#

V.6-Apr-07 1:49

6-Apr-07 1:49

generate a GUID or use the Random class.

hope this helps.

V.
I found a living worth working for, but haven't found work worth living for.

Re: How to enerate random numbers in C#

CPallini6-Apr-07 1:52

CPallini

6-Apr-07 1:52

To generate random numbers, use Random class.
Not so detailed, I know, but you post wasn't that clear...
Smile | :)

If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.

How to use Windbg for windows

Farhan Ali6-Apr-07 0:37

Farhan Ali

6-Apr-07 0:37

Hi;

I want to debug my application(which has been developed in c#) with Windbg.but i dont know how to use this software.
Can anybody guide me.

Thanx

Re: How to use Windbg for windows

rp_suman6-Apr-07 2:18

rp_suman

6-Apr-07 2:18

Please visit these pages:
http://www.codeproject.com/debug/windbg_part1.asp[^]
http://en.wikipedia.org/wiki/WinDbg[^]
Best Regards,
Suman

Configuration error!

Nafiseh Salmani5-Apr-07 23:55

Nafiseh Salmani

5-Apr-07 23:55

visit this address:

http://www.moshaveran.net/npc/[^]

this is a web application which i uploaded it . but how can i solve the error?!! what is it? D'Oh! | :doh:

Re: Configuration error!

SABhatti6-Apr-07 6:00

SABhatti

6-Apr-07 6:00

Have you looked and tried to follow what the error description says

It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS.

Is the virtual directory configured as an application in IIS?

-----

GDIPlus Thread safeness

a.mulay5-Apr-07 23:34

a.mulay

5-Apr-07 23:34

Is the GDIPlus functionalty in .Net threadsafe?

e.g For Bitmap class, the MSDN states "Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe. ".

I am using the GDIPlus functionality inside .Net web services, is that safe?

Thank you,
Amit.

Help for Window Service.

blue_arc5-Apr-07 23:07

blue_arc

5-Apr-07 23:07

Hello friends ,

I have a problem with window services, actually i am new to it. and i have to complete few things.

i want my service get started as soon as system boots up. but i want it to perform any task only when any particular system event occurs..

so my question is How can i do this?

Can i add another event with apart from OnStart and OnStop

and if yes then how can i check the any perticular system event has occured..

Thanks in adv Wink | ;)

Ravi Kant Srivastava
(System Analyst)
HandsOn Technology & Engineering
Gurgaon
(India)
e-mail:ravikant@hte.co.in

Using a C++ function (defined in a dll) with char* param [modified]

jozsurf5-Apr-07 22:35

jozsurf

5-Apr-07 22:35

Hi All,

I'm reasonably new to C# and have recently been coding parts of a C# user interface which operates in tandem with a C/C++ back-end. Things have been going O.K. until I had to make use of a function, whose prototype looks like this:

int functionName (const char* param1, const char* param2, char* nastyParam)

In my C# code, I have been dealing with the const char* params by mapping them to C# strings...that has been working quite well. Now the problem with nastyParam above is the intention is for the function to (possibly) return some string value to the caller via nastyParam. The following is what I have done thus far for the function above:

...<br />
      private static extern int functionName(<br />
            [MarshalAs(UnmanagedType.LPStr)] param1,<br />
            [MarshalAs(UnmanagedType.LPStr)] param2,<br />
            [MarshalAs(UnmanagedType.LPArray)] IntPtr nastyParam);

I've been trawling the net for solutions and came across a suggestion which involved mapping the char* to a C# IntPtr (as above)...the explanation in that article made sense to me, so I gave it a go but no luck thus far.

Anyone have any ideas?

cheers!

-- modified at 4:44 Friday 6th April, 2007

Re: Using a C++ function (defined in a dll) with char* param

CPallini6-Apr-07 2:06

CPallini

6-Apr-07 2:06

Have a look here [^] (see the author's approach to GetClassName marshaling).

Hope that helps

Smile | :)

If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.