ASP.NET Discussion Boards

First Prev Next

Re: Compare 160 million records

Colin Angus Mackay2-Feb-09 21:40

Colin Angus Mackay

2-Feb-09 21:40

You can find duplicates using something like this:

SELECT MAX(PrimaryKey), COUNT(*)
FROM MyEmailTable
GROUP BY EmailAddress
HAVING COUNT(*) >= 2

The above gives you a list of duplicate rows. You can then use that to delete the duplicates.

e.g.

DELETE FROM MyEmailTable
WHERE PrimaryKey IN
(
    SELECT MAX(PrimaryKey)
    FROM MyEmailTable
    GROUP BY EmailAddress
    HAVING COUNT(*) >= 2
)

Also note that it will only remove one duplicate per email address, if there are multiple duplicates then you have to run it multiple times.

NOTE: The above SQL hasn't been tried and may have some syntax errors. Always test on a development database. Do not run this on a live database until you are sure it works they way you want.

*Developer Day Scotland - Free community conference
*Colin Angus Mackay's Blog
*Latest Scottish Developers Newsletter

Vogon Building and Loan advise that your planet is at risk if you do not keep up repayments on any mortgage secured upon it. Remember that the force of gravity can go up as well as down.

custom Action

siva4552-Feb-09 3:15

siva455

2-Feb-09 3:15

Hi,
May i know how can i run an consoleapplication.exe as a part of MSI package created for asp.net application....

ie whenever i install my msi package in a system and after installing my exe(generated by consoleapplication)(which is attached to msi) should be running...

ie how should i attach my exe to msi (in a nutshell)....

Changing Gridview Color at runtime

BalasubramanianK2-Feb-09 2:11

BalasubramanianK

2-Feb-09 2:11

Hi,

I want to change the gridview cell background color when user clicks it or double click it. User clicks one cell and this cell color is changed and further user clicks another cell also. I've change the latest clicked cell color also and I've to retain the old cell color also, which is clicked by user earlier. Anybody can help for it? Thanks in adv.

Balasubramanian K.

Re: Changing Gridview Color at runtime

Vimalsoft(Pty) Ltd2-Feb-09 3:03

Vimalsoft(Pty) Ltd

2-Feb-09 3:03

override the paint method

Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswam@its.co.za

Need help for new website.

Rahul.RK2-Feb-09 1:46

Rahul.RK

2-Feb-09 1:46

Hello friends,

I am wishing to create a website for online examination.

Can any one give me the important points not to be missed.

Like how to maintain session, timer etc.

Some usefull links regarding same will help me.

Any type of help from you is appreciated.

Thanks in advance.

Re: Need help for new website.

SeMartens2-Feb-09 2:07

SeMartens

2-Feb-09 2:07

Hi,

http://www.w3schools.com/ASPNET/default.asp[^]

http://www.asp.net/get-started/[^]

Please be so kind to use google first next time and only post questions about coding problems (e.g. "my class x does y and not z, why?").

Regards
Sebastian

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

Not enough storage is available to complete this operation in asp

richa0212-Feb-09 1:40

richa021

2-Feb-09 1:40

hi,

I am unable to debug it..dis error has come for twice or thrice and it restarts itself...Plz help me out...

Richa

Re: Not enough storage is available to complete this operation in asp

SeMartens2-Feb-09 1:44

SeMartens

2-Feb-09 1:44

Hi,

so what is you application doing? Storing sth at the disk?

Regards
Sebastian

Maybe you are running out of space...

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

Re: Not enough storage is available to complete this operation in asp

richa0212-Feb-09 1:57

richa021

2-Feb-09 1:57

Hello,

Its a Web-Application in which web services has been implemented..and i am getting this error on the page in which soap coding has been done..

Richa

Re: Not enough storage is available to complete this operation in asp

SeMartens2-Feb-09 2:03

SeMartens

2-Feb-09 2:03

I just did your work and used google. They say something about the expected client token size. It was solved by setting this size up to 65535 chars. You should give it a try.

Here is the link (look in the comments for the solution):

http://blogs.technet.com/askds/archive/2007/09/21/not-enough-storage-is-available-to-complete-this-operation.aspx[^]

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

Re: Not enough storage is available to complete this operation in asp

richa0212-Feb-09 20:49

richa021

2-Feb-09 20:49

hello,

How can we limit the length of any data coming from another site.We have set it as
"getrSpice.length - 1" and within loop " strXML = strXML & getrSpice.item(intNode).xml" we have written like this..now plz tell me how the length of "getrSprice" can be limited.

Thnx

Re: Not enough storage is available to complete this operation in asp

SeMartens2-Feb-09 21:04

SeMartens

2-Feb-09 21:04

Hi,

first: What about the problem posted before? Is limiting the token size the solution?
Second: What is getrSprice? How do you get the data from another site? You can limit the size at the point where you retrieve the value for getrSpice. Maybe you can post a bit more code?

Regards
Sebastian

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

context menu with gidview without ajax toolkit

md_refay2-Feb-09 0:39

md_refay

2-Feb-09 0:39

hello
iam using vs 2005 asp.net web site
i need to create context menu on gridview without using ajaz toolkit

md_refay

Re: context menu with gidview without ajax toolkit

Abhijit Jana2-Feb-09 0:53

Abhijit Jana

2-Feb-09 0:53

You can look into JavaScript Context Menu[^]

cheers,
Abhijit
CodeProject MVP
My Recent Article : Exploring Session in ASP.Net

Context Menu With TreeView Without Ajax

md_refay2-Feb-09 0:37

md_refay

2-Feb-09 0:37

hello
iam using vs 2005 asp.net web site
i need to create context menu wit treeview that treeview changes depends on selectednode value
i need help
thanks for any help but without using ajax toolkit
thanks alot

md_refay

Re: Context Menu With TreeView Without Ajax

Spunky Coder2-Feb-09 0:55

Spunky Coder

2-Feb-09 0:55

Use Javascript to create the context menu...

"Don't worry if it doesn't work right. If everything did, you'd be out of a job." (Mosher's Law of Software Engineering)

update machine.config

siva4552-Feb-09 0:29

siva455

2-Feb-09 0:29

Hi ,

May i know how can i add userName and password elements to ProcessModel tag in Machine.config using c# console application ....

Re: update machine.config

Spunky Coder2-Feb-09 0:49

Spunky Coder

2-Feb-09 0:49

Load the Machine.Config Xml file using XmlDocument() are by many other ways...Modify the required node. Try Google to know how to add or modify a XML node

"Don't worry if it doesn't work right. If everything did, you'd be out of a job." (Mosher's Law of Software Engineering)

datagrid

vedharadha2-Feb-09 0:23

vedharadha

2-Feb-09 0:23

i write this in datagrid...

i write this in datagrid...

im got the following error what is it means...
how i can solve this..

'ASP.test_aspx' does not contain a definition for 'btnapprove_Click' <-----

<asp:templatecolumn headertext="APPROVE" xmlns:asp="#unknown">

<itemtemplate>
<asp:checkbox id="chkbox" runat="server">

<footertemplate>
<asp:button id="btnapprove" runat="server" text="Approve" onclick="btnapprove_Click">

Re: datagrid

Spunky Coder2-Feb-09 0:38

Spunky Coder

2-Feb-09 0:38

Implement an event handler btnapprove_Click for the click event of the button.
Hmm...better learn the basics of ASP.NET first

"Don't worry if it doesn't work right. If everything did, you'd be out of a job." (Mosher's Law of Software Engineering)

Re: datagrid

vedharadha2-Feb-09 0:41

vedharadha

2-Feb-09 0:41

thankx...

Scheduling file upload

Radhakrishnan G.1-Feb-09 23:36

Radhakrishnan G.

1-Feb-09 23:36

It is possible to schedule file uploads to the server with out any webservice?

Re: Scheduling file upload

Christian Graus2-Feb-09 0:12

Christian Graus

2-Feb-09 0:12

Yes. But, it's not possible to do it in ASP.NET, if you want to schedule an upload then there needs to be code running on the client machine to upload the file at the appointed time. Well, you could require them to keep a webpage open until the appointed time, but that's sure ugly.

Christian Graus

Driven to the arms of OSX by Vista.

Re: Scheduling file upload

Radhakrishnan G.2-Feb-09 0:22

Radhakrishnan G.

2-Feb-09 0:22

Yes we need to implement sheduler as a desktop application.

How to send information to the server,
do we need to keep a sperate page for doing this or
Running a webservice in the server

I mean which is better

Re: Scheduling file upload

N a v a n e e t h2-Feb-09 0:46

N a v a n e e t h

2-Feb-09 0:46

Radhakrishnan G. wrote:
which is better

Running a web service or WCF service will be better.

Smile | :)

Navaneeth

How to use google | Ask smart questions

Last Visit: 31-Dec-99 18:00 Last Update: 16-Apr-24 12:52

Refresh

ᐊ Prev 1...2361 2362 2363 236423652366 2367 2368 2369 2370 Next ᐅ

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