Resource Responses

Search Guest Response by Email:
Total 30 responses found.
How to change the caption of the Console application
Hello Nirav Lalan,

Thanks for you suggestion. I have attached the sample output .

Author: Nathan      Posted Date: 10 Dec 2015
Tips for SQL Server Performance
You can try something like as following

INSERT INTO [dbo].[Table_2]
([Col1]
,[Col2])
( SELECT count(*) as Col1, hour
FROM [Test11].[dbo].[Table_1] )

Author: Nathan      Posted Date: 18 Aug 2015
Tips for SQL Server Performance
I think you did not understand my point.

1. CURSOR is only for enumerate the record inside SP.
2. You have 1 lakh records in C# right?.
3. How will you send this C# Records into SQL Server?. Two way (SP and Dynamic Query)
4. What am I telling, Your case is "bulk insert", Create Dynamic SQL Query from C#, then execute only once.
5. Why you are going for SP and CURRSOR?.
For your case you do not need SP and CURRSOR.
6. According to your design pattern, If it is compulsory to create SP and call that for 1Lak. You can discuss with your team and change the desing pattern. Because it will be create you performance issue.

Author: Nathan      Posted Date: 07 Aug 2015
Tips for SQL Server Performance
In your case you have 20 rows in c# code.
So there is no need to talk about the cursor. The challenge is how to send the rows from C# to SQL

1. you can have SP for insert and call that the 20 times

2. you can create SQL insert query in c# for 20 records and execute it only one time.

I hope this will help you.

Author: Nathan      Posted Date: 06 Aug 2015
Tips for SQL Server Performance
Can you post your Stored Procedure. So that I can try.
Author: Nathan      Posted Date: 06 Aug 2015
System Information
'To use this class you must add a reference
'to System.Management from the Project | References
'menu

Imports System.Management
Author: Nathan      Posted Date: 06 Oct 2010
Web Crawler
No Gaurav, it will not.
It is simple one.
For that we need to do more code
Author: Nathan      Posted Date: 21 Jun 2010
Teacher and Student
kali raj..

Thanks for your comments.
I will changes it..


Author: Nathan      Posted Date: 15 Jun 2010
System Information
Thanks for you response
Author: Nathan      Posted Date: 29 Apr 2010
Tech Matrix:::First offline event from HT on 24 april,2010 in Liquidhub hyderabad
Very Nice,

Please post this kind of news in Technology news section of Resource
Author: Nathan      Posted Date: 23 Apr 2010
Coding Guidelines
its Very nice...
keep it up...
Author: Nathan      Posted Date: 01 Apr 2010
Capture your desktop
Yes Rabiya, But in the above program we are capturing the whole desktop...

We can using this code for spy....the desktop from back end using timer and service.

Author: Nathan      Posted Date: 23 Nov 2009
CPU Monitor
Nice code, but But I could not understand..
Please give some discription
Author: Nathan      Posted Date: 17 Sep 2009
Redirect the web page after particular time seconds
OnClientclick you can call one javascript and set the value there
Author: Nathan      Posted Date: 21 Aug 2009
Second Highest and Lowest Salary using SQL Query
Thanks Pandian, This will make my resourece more usefull
Author: Nathan      Posted Date: 19 Aug 2009
Second Highest and Lowest Salary using SQL Query
n means 1 st, 2nd, 3rd highest or lowest salary
dont give n please give (if you want 2nd highest salary give n=1
for 3rd n=2 like that..
Author: Nathan      Posted Date: 18 Aug 2009
Second Highest and Lowest Salary using SQL Query
Yes raghunath, you are right

you can also replace the n-1 into n by replacing the < into <=



Author: Nathan      Posted Date: 18 Aug 2009
Create your own Web Browser
It is nothing..
you just right click the project and add reference
in the tab .net you can add "AxInterop.SHDocVw" as reference.

Now you are ready to use the name space "using AxSHDocVw"

add the form.. and copy and past the code.. you will get...
Author: Nathan      Posted Date: 10 Aug 2009
MD5
yes, you need to use the following namespace.
using System.Security.Cryptography;

Whereever you are using the formsauthentication you can use that line.
Author: Nathan      Posted Date: 07 Aug 2009
How to retrieve other rows except 1st row from a data table.
I dnot understand ... the code.. Please give it little bit details
Author: Nathan      Posted Date: 17 Jul 2009
Vista virtualization problem
Good Work Chenthil
Author: Nathan      Posted Date: 17 Jul 2009
Method to reverse the string
Good work chenthil
Keep it up
Author: Nathan      Posted Date: 11 Jul 2009
What do you believe?

Nice joke
Author: Nathan      Posted Date: 26 Jun 2009
Begger and Software Engineer...
nice joke
Author: Nathan      Posted Date: 26 Jun 2009
Magic tables in SQL Server
Thanks guys,

This point will add more value to my resource.



Author: Nathan      Posted Date: 22 Jun 2009
Client server sample using WCF and net.tcp binding
Nice article...

Author: Nathan      Posted Date: 17 Jun 2009
Slide show with out refreshing the page
just asign the serverside
var AnimalImages = GetFolderImages() // Asign as server side methord .. it is not posting so that i asigned as client side
Actully it will get the image names from the folder specified.
like.
var AnimalImages='images/Dealerlogos/altorfer.jpg;images/Dealerlogos/altorfer.jpg;'
Author: Nathan      Posted Date: 11 Jun 2009
Slide show with out refreshing the page
define DisplayAnimalImages in the aspx page.
It is the javascript function.
tag of "Script" and give the language "javascript"
Author: Nathan      Posted Date: 11 Jun 2009
Generating PDF files with iTextSharp and ASP.NET 2.0
Hi,

Where will get the "iTextSharp.dll"

Thanks
Nathan
Author: Nathan      Posted Date: 09 Jun 2009
Apress[1][1].Pro.dot.NET.2.0.Code.and.Design.Standards.in.C.Sharp.
Hello Anand,

What is the advantages of this book.
how is this book differ from other books.

Thanks
Nathan
Author: Nathan      Posted Date: 08 Jun 2009



Top Contributors
TodayLast 7 Daysmore...

Awards & Gifts

Online Members

John Bhatt
More...
 
Copyright © SpiderWorks Technologies Pvt Ltd., Kochi, India