Re: MS access two connections simultaneously..... - ASP.NET Discussion Boards

I have never seen a code like this. NO NO NO NO NO No NO.

how can you declare two Connection String

How can you close the connection before you do the Delete

You Delete Statement is incorrect, before you put anything to C# make sure that you have tested it on the SQL side, that is why i prefare to use SP's than naked sql in C#, let SQL handle SQl and C# Handle C#

It seems you dont know where what should go, this is Wrong.

You need to Buy a Book and Read a little bit.

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.somee.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Ohh cnc.close() is @ last..that one is copying mistake nevrmind..but its not working..

What do you mean ? Smile | :)

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.somee.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

I mean to say that it's actually cnc1.open() not close that was mistake during i was copying the code..i have corrected but isnt there anyway to access db using two connectiong strings as i did to select and then delete..?

So when you copied the code , it changed on fly it to close(). : Laugh | :laugh:

why do you have two connection string ? why dont you trap for exception ? i dont know how you going to debug your code Smile | :)

its complicated

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.somee.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

I dont' have much idea about exceptions Frown | :(

but code is not complex 1st part is just checking wether the friend request in db is approved or not and selecting the unapproved ones and then it's calculating that how many days old the friend req is if more than 10 then delete that request from database this is what i want but deleting part not work..

That should have been done only in SQL not in C# , in C# you should have just called the SP and Pass the Parameters.

please this time make sure the connection does not change onfly Roll eyes | :rolleyes:

. Recopy the code and comment it by telling me what you want to do and i will give you a better way on how to do it

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.somee.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

The code is same. I just want to select those friend request which have exceed'd limit of 10days and delete them. I saved the username who loggd in in a connection string "uname"..and retriving dates from db (coloumn name date1) and confirm is the db coloumn in which if no means friend request not accepted. In select command im retriving dates and compairing with current date if exceeds by 10 then delete that particular request from db..

I tried to rework your code and in got more confused than you Smile | :)

, now tell me is there any particular reason why you use a datareader ? again your delete statment is incorrect.

change

"Delete from friends where Username

to

"Delete friends where Username

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.somee.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Well datareader i used for select statement..and i'll try what u said "delete friends where username" instead of "delete from"..but right now im away from my system..there is one more way i was thinking 2 do..store those dates which hasto be deleted in array and close datareader connection..and then again open new connection for delete..but i want to implement it with two queries..

The Problem with your reader is holding on to the Connection. i suggest you use a datatable. atleast your code will be a little bit clearer because there wont be any looping happening. as i stated before what youdo can be done in one sql SP

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.somee.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

I guess im getting what u trying to explain my datareader is holding up connection not passing it to other connection string..by the way what is sql sp please explain lil'..thnx

The SP i meant a Stored Procedure, i feel you could have done all this in a Stored Procedure than trying to manupilate the table in C#.

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.somee.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Stored procedure means storing data somewhr like array or datasets..? And how to use sp in ms access(sql doesnt work in ma system)..i wanna talk 2u online on IM..some direct queries i wanna solve plz if u dnt mind..

NO that is not a stored procedure. Make it fast because i have to go home. am on google talk and Skype with vuyiswamb

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.somee.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Mine is blastome on gmail and dorian_yates@yahoo.co.in..thnx but rite now im outtie home nt on system..i'll talk 2u later on IM..thnx 4 help.. Smile | :)

Cool

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.somee.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Well i've added u on gmail..vuyiswamb@gmail.com..

i have design a form and i want to insert a photograph in the form and send to databases

Hi Shukla,
Please find the follwoing article [^]which is perfect for your query I gues. I am assuming you are working on ASP.NET.

Let me know if you need any further help. Smile | :)

Regards,
Arindam Sinha
MyBlog - http://arindamsinha.wordpress.com/
Please give your feedback on this answer.

You really gona have to start using google before you post

Save An Image Into SQL Server 2000 Database[^]

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.somee.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Not only do expect someone to do the research for you, but you also expect us to not notice you posting this request again.

only two letters away from being an asset

rj shukla wrote:
i have design a form and i want to insert a photograph in the form and send to databases

Deleting old message and repost the same question again does not help you to get the answer. Dead | X|

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
View My Latest Article

Hi,
How to change the visiblity of a frame from a page in another frame?

Thankyou
Yesuprakash

Hi,

I have the following FilteredTextBoxExtender on a textbox.
<cc1:FilteredTextBoxExtender ID="FilteredTextBoxExtender1" runat="server" TargetControlID="txt_VisitorName" ValidChars=" " FilterType="Custom,UppercaseLetters, LowercaseLetters"
Enabled="True">
</cc1:FilteredTextBoxExtender>

when i select a row in the list view it will fill load data to the textboxes the FilteredTextBoxExtender is clearing the spaces in the textbox,i specified space as the valid character, but its not firing

can any body help me regarding this.

Thanks&Regards
DEEP

hi