|
Syed Shahid Hussain,
What are you asking for? Ways to speed up the insert?
Well, you'll need to give us some code to see what you currently do, and how many rows are you inserting?, also, have a google for Bulk Copy (BCP) or read http://www.codeproject.com/KB/database/SqlBulkCopy.aspx[^]
|
|
|
|
|
one way you can speed up insertion is using stored prcedure which is precompiled code.
try to use store proc plz
Abdul Rahaman Hamidy
Senior Student Student in Computer Science
Kabul, Afghanistan
Software Developer
|
|
|
|
|
Hi syed,
You can check
1. whether over indexing is used in the table.
2. use stored procedure.
3. whether u r inserting multiple records at a time?
4. please give complete picture of your work.
Sarvesh Upadhyay
Senior Software Engineer
Birlasoft India Ltd.
Microsoft Certified Professional Developer in Dotnet 2.0 Enterprise Application
|
|
|
|
|
My Dears I am new in using MyNeoReport as reporting for .Net applications.
I would really appreciate if i could have some reference for using MyNeoReport.
you are the most welcome to assist me plz.
Abdul Rahaman Hamidy
Senior Student Student in Computer Science
Kabul, Afghanistan
Software Developer
|
|
|
|
|
I doubt anyone here has heard of it, does it not offer any support ?
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
There is a tutorial for this here[^] on Code Project.
|
|
|
|
|
hi
I am doing a project in which i have two forms
frmMain and frmTest
in the frmTest i am having a rich textbox and a static string declared;
so from the frmMain i am setting the string value to some text; and then i am creating a object of that form and showing it
This was running perfect till yesterday
today i have a peculiar problem
its giving a exception
"
SEH Exception was unhandled
External Component has thrown an exception " Please tell me how to solve this
THANK YOU
*** Why EXPERTS behave like a fool ***
|
|
|
|
|
Firstly, there are better ways of passing data from one form to another than using public static members (think constructor arguments or properties). Secondly, please post what exception you are seeing and maybe a stack trace.
--
gleat
http://blogorama.nerdworks.in[ ^]
-- Once we figured out that taking our shoes and socks off would double our counting ability the technical glitch was quickly rectified. -- Chris Maunder, from the CP newsletter
|
|
|
|
|
What you're doing is nasty as all hell. There's an excellent article on cP on how to share data between forms. The short version - use delegates.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
if i say
Enter your full name :Peter Alian Smith
So this name has to be start from char no space from starting name.
once user write his first name only one space allow not more then one space.
again user write his middle name and only one space allow not more then one space...
So is that anyone can help me.what should i use ?
-Thanks
Peter
|
|
|
|
|
Why do you need it to be so strict ?
The Trim method removes leading and trailing spaces. A regex or a split and then rejoining with only one space would fix the rest.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
is there any other method i can use here ?
Peter
|
|
|
|
|
You mean, you tried Christian's suggestion and it didn't work?
--
gleat
http://blogorama.nerdworks.in[ ^]
-- Once we figured out that taking our shoes and socks off would double our counting ability the technical glitch was quickly rectified. -- Chris Maunder, from the CP newsletter
|
|
|
|
|
Why ? Are you thnking I am trying to keep the good methods a secret ?
A regex is your best bet. Splitting and rejoining the string is more code, and messier, but perhaps easier to understand. If you don't want either of those methods, I recommend prayer.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Christian Graus wrote: keep the good methods a secret
Yeah, let's not tell him about
name = name.Trim().Replace ( "\t" , " " ).Replace ( " " , " " ) ;
as it's far too advanced.
|
|
|
|
|
i want to execute a code once in 24 hours..how do i do this in C#.NET..
plz..urgent..
Kaveri..
|
|
|
|
|
kaveri2604 wrote: plz..urgent..
But not urgent enough to use google ?
If the book you're using doesn't cover timers, it probably lacks in other areas. Buy a better book, and keep applying yourself.
Or try here[^].
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi all,i need change the following code into an array..But it shows error whn i change it..Here is the coding..
string hex = "03D";
int code = Convert.ToInt32(hex, 16);
richTextBox1.Text = Encoding.Default.GetString(new byte[] { (byte)code });
I need insert about 5 hexadecimal value..Pls help me..Thank you.
KAM83
|
|
|
|
|
richTextBox1.Text = Encoding.Default.GetString(new byte[] { (byte)code1 , (byte)code2 , (byte)code3 , (byte)code4 , (byte)code5 });
|
|
|
|
|
I currently have an application in which i am storing a connection string in a class. I would like to not have to hardcode this into the class, but instead store it in some sort of text file.
I thought of placing this into a text file, but I want to be able to hide this file, and not allow user to view the connection string.
Thanks for your help.
modified on Monday, March 24, 2008 11:17 PM
|
|
|
|
|
Put it in your settings, and encrypt it so the user can't change it.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
What i have done is placing the connection string setting in the text file .
[code]
StreamReader sr = new StreamReader(@"C:\ConnectionString.txt");
ConnectionString = sr.ReadLine();
[/code]
|
|
|
|
|
Sure - but that doesn't solve your problem, does it ? It can, if you also encrypt the string, but why create an extra file when .NET has this sort of stuff built in to it via the app.config file ?
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Good People,
I need some advice on what direction I should take. I have been asked to write an application. While I know C# and the nuts and bolts of coding and software design (to a reasonable degree), I don't know how to make it look nice. They want it to have a nice looking GUI, cool buttons, pictures and other graphics to augment the software experience. Yep, this application is also meant to be fun and interesting to use, thus they don't want it to feel like they're using MS Access or some other mundane application.
At any rate, I do have some time so I'd like some advice on what I need to learn to do that type of stuff. For example, how do I make semi transparent menus and glossy buttons? How do I add images on a page that will scale properly? Is WPF the answer.
Any advice you can give me on what directions I need to take will be helpful. Also, if you know of any articles I should read on this site let me know.
Thanks,
BP
|
|
|
|
|
From what you've described, I'd go with WPF.
|
|
|
|