Comments by Tarun Mittal Delhi

Tarun Mittal Delhi 28-Sep-16 1:00am View

i'm already following this structure.

Tarun Mittal Delhi 27-Sep-16 1:19am View

thanks for your solution. But, value of all 44 columns also will be different for every ISBN. so, is there any method to write a short query to update all records using define a single column for all 44 columns...???? i hope, you get it what i want to do

Tarun Mittal Delhi 26-Sep-16 14:43pm View

Hi,

I have a table which is related for price of the books. Details: In this table, 44 columns are defined for 44 "latin amrican countries" and primary column is "ISBN". "ISBN" is unique for every record/book. Now, i want to update the price for all 44 countries. In this case, i will have to write the query like this: (Update CountryPrice Set MX=84, GT=84, SV=84, HN=84, NI=84, CR=84, PA=84, CO=84, VE=84, PY=84, BO=84, EC=84, BR=84, CL=84, AR=84, UY=84, PE=84, DO=84, PR=84, TT=84, JM=84, GY=84, CU=84, HT=84, GP=84, MQ=84, BS=84, BB=84, LC=84, CW=84, AW=84, VC=84, GD=84, AG=84, DM=84, KY=84, KN=84, SX=84, TC=84, MF=84, VG=84, AI=84, BL=84, MS=84 Where ISBN='9789350903186')

Note: These columns are basically country codes.

I want to update more than 3000 records like this above example. Please help me that how can i write the query for all records in a short way. If i write manually then the time will be consumed too.

---
regards,
tarun mittal

Tarun Mittal Delhi 26-Sep-16 8:33am View

yes...

Tarun Mittal Delhi 19-Sep-16 7:15am View

No, i didn't upgrade my OS. I installed a new fresh windows 10 64 bit.

Tarun Mittal Delhi 21-Jun-16 7:38am View

version: 1.5.5

i don't know that location. Because i'm new on this project which was developed by some other programmer. And, these plugins are also using in the project on click event for showing pdf and image.

Tarun Mittal Delhi 21-Jun-16 7:16am View

Dear Expertiser,

Thanks for replying on my query.

Now, please take a look into the code:

<link rel="stylesheet" type="text/css" href="js/lightbox/themes/default/jquery.lightbox.css" />
<script type="text/javascript" src="js/lightbox/jquery.lightbox.min.js"></script>
<style type="text/css">
.lightbox-border
{
padding: 5px;
border: solid 1px #EFEFEF;
}
.lightbox-border:hover
{
border: solid 1px #CCC;
-moz-box-shadow: 1px 1px 5px #999;
-webkit-box-shadow: 1px 1px 5px #999;
box-shadow: 1px 1px 5px #999;
}
</style>
<script type="text/javascript">
jQuery(document).ready(function($){
$('.lightbox').lightbox();
});
</script>

<div class="lightbox">


</div>

Now, the issue is occuring that...Image is showing with lightbox but close button is not displaying. And, how can i do it on pageload event?
can you please help me?

Tarun Mittal Delhi 20-Jun-16 7:07am View

image format: jpg

Tarun Mittal Delhi 20-Jun-16 7:06am View

i want to show a popup on page load.

when an user hit the website's defalut(main) page then it shows him a pop-up window which having an image. And, also user can close that pop up window after seeing it

Tarun Mittal Delhi 20-Jun-16 7:02am View

for closing pop-up

Tarun Mittal Delhi 20-Jun-16 6:52am View

Sir...please help me

Tarun Mittal Delhi 20-Jun-16 6:46am View

when i'm using this code then data is not showing as a pop-up.

Tarun Mittal Delhi 20-Jun-16 6:40am View

<html>
<script type="text/javascript">
$(document).ready(function(e) {
$('#popup').animate({"top":"100%","marginTop":"-200px"},500);
win.document.close();
});
</script>
<style type="text/css">
#popup
{
width:400px;
height:550px;
background:#000000;
color:#000000;
padding:5px;
position:absolute;
top:100%;
left:50%;
margin-top:-600px;
margin-left:-200px;
}
</style>
<body>
<div id="popup">
<img src="JP-and-McGW.jpg" alt="" title="" width="400" height="550" runat="server"/>
</div>
</body>
</html>

Tarun Mittal Delhi 20-Jun-16 6:38am View

on page load

Tarun Mittal Delhi 20-Jun-16 3:08am View

under script tag

Tarun Mittal Delhi 25-Jul-15 5:52am View

Error Line
Amount = Rs("TotalAmount").ToString

Data doesn't fetch anything in totalamount from the stored procedure.

Ques: I want to mention discount amount which is deducted from the price of the book. And also want to show "Total amount to be paid" which will come after deduct discount from the price in email body.

Tarun Mittal Delhi 21-Jul-15 1:36am View

Please Sir,...

Help me.

Tarun Mittal Delhi 21-Jul-15 1:28am View

Thanks again to reply on my query. I don't have rights to any change in database model from my corporate team. So, I have to work on it as per logic rules on the code page which is using on code page. You can see very well that we are managing mail content dynamically which is sent to user's mail address.

So, if you have another option then please let me know.

Looking ahead for your favorable reply.

---
Thanks & Regards,
Tarun Mittal (India)
Core Programmer
Mail Add: tarun1089@gmail.com

Tarun Mittal Delhi 21-Jul-15 1:09am View

Hello,... Mr. SA.

Greetings from Tarun..!!!
Thank you so much for your kind response.

Data model of project is maintained properly. I just want to add the " total amount to be paid with discount " in mail content. In our database, we don't maintain discounted amount because the offer doesn't valid on all books always. That's why, we maintain the discount offers only in mail content.

Now, i've found some solution of code by myself.

Now, the code is running on single order[means: if an user place a single book order via COD(cash-on-delivery...) then code is running good. ] But when an user place more than 1 order then it works only on last selected book (means: if an user select a book which has cost of 500 Rupees and then select another book which has cost of 1000 rupees then my code is add the amount and details of second book which has 1000 rupees cost in mail content with discounted price,.. but entry of both books are inserted in the database in user's session or order id.)
So, please give me solution for this problem that my code should also work for more than 1 order in a single session.

Please find below mentioned my new code:

Private Sub prcSaveData()
Try
'Add Author detail on 17th July 2015
CmdTmp2 = New OleDbCommand("spTmpDetails2", Con)
CmdTmp2.CommandType = CommandType.StoredProcedure
CmdTmp2.Parameters.AddWithValue("@SID", Session("SesID"))
Rs = CmdTmp2.ExecuteReader
While Rs.Read()
CmdInsetCart = New OleDbCommand("spInsertCart", Con)
CmdInsetCart.CommandType = CommandType.StoredProcedure
CmdInsetCart.Parameters.AddWithValue("@SID", Session("SesID"))
CmdInsetCart.Parameters.AddWithValue("@UN", txtUName.Text)
CmdInsetCart.Parameters.AddWithValue("@PID", Rs("ISBN").ToString)
CmdInsetCart.Parameters.AddWithValue("@Name", Rs("Title").ToString)
CmdInsetCart.Parameters.AddWithValue("@Desc1", Rs("Author").ToString)
CmdInsetCart.Parameters.AddWithValue("@Price", Rs("Price"))
CmdInsetCart.Parameters.AddWithValue("@Qty", Rs("Qty"))
CmdInsetCart.Parameters.AddWithValue("@Amt", Rs("Amt"))
CmdInsetCart.Parameters.AddWithValue("@Status", "VPPOrder")
CmdInsetCart.Parameters.AddWithValue("@PDate", Date.Now())
CmdInsetCart.ExecuteReader()

Dim Temp As String

Temp = Rs("Amt")
VppOrderDetail = "Order Id: " & Session("SesID")
Dim totalpaywithPromo As String

If (Session("PromoCode") = "") Then
Dim promoDiscPrice As String
promoDiscPrice = Session("promoDiscPrice")
promoDiscPrice = Temp / 10
totalpaywithPromo = Temp - promoDiscPrice
End If

VppOrderDetail = VppOrderDetail & vbCrLf & "ISBN: " & Rs("ISBN").ToString & vbCrLf & "Title: " & Rs("Title").ToString & vbCrLf & "Author: " & Rs("Author").ToString & vbCrLf & "Price: " & Rs("Price").ToString & vbCrLf & "QTY: " & Rs("Qty").ToString & vbCrLf & "Amount: " & Rs("Amt").ToString & vbCrLf & "Order Date: " & Date.Now() & vbCrLf & "Total Amount to be paid with discount: " & totalpaywithPromo

End While

Catch ex As Exception
End Try

End Sub

Tarun Mittal Delhi 20-Jul-15 8:01am View

Thank you so much for your comments.... Mr. Richard MacCutchan.

Now, i need another help in this case... My code is workng on single order. But when an user order more than 1 book in a single session then my code takes only final selected book in mail content but entry of all order is inserted in the databse.
So, please help me.... how to manage more than 1 books order in a single mail.

Comments by Tarun Mittal Delhi (Top 20 by date)