Comments by basitsar (Top 87 by date)

Thanks A lot. Below code solved problem in Master.


function calculate() {
var myBox1 = document.getElementById("<%= TextBox1.ClientID %>").value;
var myBox2 = document.getElementById("<%= TextBox2.ClientID %>").value;
var result = document.getElementById('result');
document.getElementById("<%= txtDiscount.ClientID %>").value = ((myBox1 - myBox2) / myBox1) * 100;
}

What i tried is created a temporary table called Temp_Stock columns are temp_ItmNo, temp_StockQty, temp_Location then first enter whatever stock in stock table enter in Temp_Stock then check the MIS transaction and whatever select date after the MIS_Qty enter in Temp_Stock.

How to do query in sql query

Thanks
Basit.

Thanks A lot. But o/p is coming NaN

What my question is in my inventory system how to maintain the stock table. i have two type of idea to maintain stock table. One stock table have the following field. ItemNo, GRNNo, PONo, MrNo, StockQty and StockUnitprice. In this table when i receive the Material then it will add the field as new row in stock, or another stock table is ItemNo, StockQty and StockUnit price here when receive the material then it will check the stockmaster and if the item available in stock the add/update the qty and update avgprice im asking which one is good. thanks Basit.

Thanks A lot.

Dear, there is no relation between thoes table only need to check start & endDate with operation table and check attendance table if employee is in between start & endDate then show this table.

Thanks
Basit.

Many Many Thanks

It means that while creating table we can create constraint after creating table cannot? Is that correct?

Got error
Incorrect syntax near the keyword 'ADD'.

got error

Incorrect syntax near the keyword 'ADD'.

not working showing error
Incorrect syntax near the keyword 'OFF'.

CREATE UNIQUE CLUSTERED INDEX UIX_User
ON dbo.[User]([User_Name])

then got error.

Column '[User_Name]' in table 'dbo.User' is of a type that is invalid for use as a key column in an index.

no how to do this

Many Many Thanks

I want to clear more about opening Balance Qty. Suppose i have store many items are there. One by one i will add into stock table and StockQty/OpenQty Column will updated. After Good Issue transaction will updated then StockQty will change accordingly. Is that correct? or I need to create another column called openingBalQty where i can store OpeningBalQty. Becoz stockQty will Changed according to transaction

Thanks A lot. In Mst_Stock Table i have StockQty, but I don't have column called opening qty and this StockQty will (+) & (-) depend upon GRN or GIN. Is the opening qty if we enter first time in stock table then it should not change is that correct?

Thanks A lot. I will not use word "Dear" Appreciated. Thanks

Dear, Why i'm putting the data into D:/ becoz i want to host website locally. not over internet or any production server. why i'm not putting on c:/ or in website folder becoz its in C driver where OS is installed.

I tried Image1.ImageUrl = Server.MapPath("D:\Images\AnyImage.bmp") then got error is a physical path, but a virtual path was expected.

Thanks A lot.

Thanks A lot.

Server PC. And SQL Management also on server. Only to open exe file through sql query.
What exactly want to create trigger when data inserted then open then exe file and run other things.

Thanks
Basit.

same pc dear

Same PC.

Got error asking to enter parameter c.PurchaseDate popup coming

Thanks Alot, but showing "You tried to execute a query that does not include the specific expression 'Price' as part of an aggregate function"

Is there any update for msaccess

with the help of below code convert image to base64

Public Function ConvertFileToBase64(ByVal fileName As String) As String
Return Convert.ToBase64String(System.IO.File.ReadAllBytes(fileName))
End Function

Dear,
Below is the code to convert image to base64
Public Function ConvertFileToBase64(ByVal fileName As String) As String
Return Convert.ToBase64String(System.IO.File.ReadAllBytes(fileName))
End Function

Dear im asking in msaccess this query also work?

thanks alot.
is this work in msaccess.

SELECT ItemCode, PurchaseDate, Price
FROM (SELECT *, ROW_NUMBER() OVER (PARTITION BY ItemCode ORDER By PurchaseDate DESC) AS rn
FROM Trn_Purchase) x
WHERE rn = 1

yes each item code

Dear,
Thanks for reply, but see as i mention, leavestart and leaveend can be anything. if suppose leavestart and leaveend at same year then no problem i will get year(leaveend) and group by this is easy

but if
LeavStart- 28-Dec-2015
LeaveEnd - 05-Jan-2016

then result should

2015 - 4 days
2016 - 5 days

here if i took same query year(leaveend) and group then result

2016 - 9 days that's wrong.
need to be seprate.

Thanks
Basit.

Yes dear searching means doing logic. may be need to get every period start and end date and minus from that

Dear,

i want from vb.net, becoz for some time interval the exe will work and execute .net code.
for interval i will use windows task sheduler

no till now not tried any thing

Thanks A lot.

Thanks A lot.

Thanks A lot.

Another thing dear, how to get the sum of that difference?

select CONVERT(varchar(10), DATEDIFF(HOUR,@StartDate,@EndDate)) +':'+CONVERT(varchar(10), DATEDIFF(MINUTE,@StartDate,@EndDate)%60 ) as DifferenceHour

Means how to get the sum of DifferenceHour column.

Many Thanks Dear, Perfect.

Thanks problem Solved

Thanks A lot dear, But when i used this showing (0 row(s) affected), and when i deleted header then it inserted rows.
Thanks
Basit.

Thanks A lot dear, I download whatsapp API thru NuGet Consol.
Then how to do the coding?

Thanks
Basit.

Thanks Alot Dear

Thanks A lot.

Many Many Thanks. The problem has been solved.

Dear Thanks A lot. I have edited trigger.

Below is the Trigger


ALTER TRIGGER [dbo].[CallInserted]
ON [CM].[dbo].[CustomersCalls]
FOR update
AS
BEGIN

DECLARE @us_email varchar(500);
DECLARE @CallNo varchar(500);
DECLARE @CallNo2 varchar(500);
DECLARE @CallComplaint varchar(1000);

DECLARE @LineMgrEmail varchar(500);
DECLARE @Status varchar(500);
SET NOCOUNT ON;

IF EXISTS (SELECT * FROM inserted)
BEGIN
SELECT @us_email = EmailAddress
FROM inserted i,
Users u
WHERE u.UserNo = i.AssignedBy;

SELECT @LineMgrEmail = EmailLineManager
FROM inserted i,
Users u
WHERE u.UserNo = i.AssignedBy;

SELECT @CallNo ='Notification :Call Number is :' + SPACE(1)+ CallNumber
FROM inserted
SELECT @CallNo2 ='Notification :Call Closed, Call Number is :' + SPACE(1)+ CallNumber
FROM inserted

SELECT @Status =[Status]
FROM inserted


SELECT @CallComplaint = Complaint
FROM inserted

EXEC msdb.dbo.sp_send_dbmail
@recipients = @us_email,
@profile_name = 'SendEmailCM2',
@subject = @CallNo,
@body_format = 'html',
@body = @CallComplaint



END
END

What i want is if @Status=1 then
EXEC msdb.dbo.sp_send_dbmail
@recipients = @us_email,
@profile_name = 'SendEmailCM2',
@subject = @CallNo,
@body_format = 'html',
@body = @CallComplaint
and if @Status=2

EXEC msdb.dbo.sp_send_dbmail
@recipients = @EmailLineManager,
@profile_name = 'SendEmailCM2',
@subject = @CallNo2,
@body_format = 'html',
@body = @CallComplaint

How to use CASE or If in between.
Please help on this

Thanks
Basit.

Thanks A lot dear, other thing what i want in Customercall if Assignto column is null then not execute email code how to do this. and if another column status='Closed' then send email to another persone from User table. Email Column is lineMangerEmail

Below is the example.

If (AssignTo=null) then

exit
end if

if (Status='Closed') then
send email to LineManager column from User table
and execute email
end if



thanks
Basit.

many many thanks, Ok then can you please tell me how to clear global variable in java script as my above question

Dear,
Many Many Thanks, Below is the link.
http://www.codeproject.com/Questions/1010323/How-to-Pass-UserName-Password-in-Ajax

Dear,
How to add the security in ajax? I already give the user and password to OData Services how to put in Ajax?

Thanks
Basit.

Thanks A lot the problem has been solved. But why before not accepting above code?

Thanks
basit.

Thanks Alot dear,

Dear, with the debugger with valid user name & password result is below

data = Object {d: Array[1]
Us_Admin: 1
Us_Name: "Basit"
Us_No: 1
Us_Password: "s"

with wrong user & password result is below

data = Object {d: Array[0]
No Data is shwoing

But even with the valid result its not moving in
if (data.d.Us_Admin == 1) {
//redirect
}
else
{
error
}

Below is the code.
var _url = "http://localhost:58890/DataService.svc/Mst_User?$filter=Us_Name eq 'Basit' and Us_Password eq 's' &$format=json";
$.ajax({
type: "GET",
url: _url,
timeout: 10000,
async: true,
dataType: "json",
contentType: "application/jsonp; charset=utf-8",
success: function (data) {

if (data.d.Us_Admin == 1) {
//Navigate
} else {
//shows error
}
},
error: function (xhr, status, error) {
// Shows error.
}
});

Dear you said check in console. how to do that?
Thanks
Basit.

Dear i add a quick watch when i type data.Us_Admin=1 then its shows 1 it goes to success loop but i type wrong user & password.

another when i type data.Us_Admin==1 then it goes to else loop.

Many Thanks,
I debug & try three things
data.d.Us_Admin undefined
data.Us_Admin undefined
data.d.__deferred.Us_Admin undefined

all are showing undefined.

Below is the o/p of webservices

{"d":[{"__metadata":{"id":"http://localhost:58890/DataService.svc/Mst_User(1)","uri":"http://localhost:58890/DataService.svc/Mst_User(1)","type":"CMModel.Mst_User"},"Trn_CallLog":{"__deferred":{"uri":"http://localhost:58890/DataService.svc/Mst_User(1)/Trn_CallLog"}},"Us_No":1,"Us_Name":"Basit","Us_Password":"s","Us_Admin":1,"Us_Customer":1,"Us_CallAssign":1,"Us_CreateCall":1}]}

The Us_Admin is a numeric field, if Us_admin=1 then redirect to another page. I checked in the database its showing also 1, But the code what you suggested is not working with that code showing login failed.

Thanks
Basit

showing login failed!

Ok thanks understood

Dear What i re searched is in one column only taking 255 Characters while import the data from excel to grid view. How to increase that size. please help on this.

Thanks A lot Great.

Thanks
Basit

Please tell me how to add handler in my code

Partial Public Class Page1
Inherits PhoneApplicationPage

Public Sub New()
InitializeComponent()
End Sub

Private Sub Button1_Click(sender As System.Object, e As System.Windows.RoutedEventArgs) Handles Button1.Click
Dim abc As New ServiceReference1.WebService1SoapClient
'//how to add handler here
abc.GetUserAsync(TextBox1.Text)

End Sub

Private Sub GetUserCompleted(sender As Object, e As ServiceReference1.GetUserCompletedEventArgs)
'Access e.Results here
TextBox2.Text = e.Result.ToString
End Sub
End Class

Many thanks, Please can you tell me more details where should and how to add the handler.

Below is my full page code

Partial Public Class Page1
Inherits PhoneApplicationPage

Public Sub New()
InitializeComponent()
End Sub

Private Sub Button1_Click(sender As System.Object, e As System.Windows.RoutedEventArgs) Handles Button1.Click
Dim abc As New ServiceReference1.WebService1SoapClient

abc.GetUserAsync(TextBox1.Text)


End Sub

Private Sub GetUserCompleted(sender As Object, e As ServiceReference1.GetUserCompletedEventArgs)
'Access e.Results here

End Sub
End Class

i deleted global.asax file from ASP.Net web services after that i checked the web service once again working perfectly then also same error.

Thanks
Basit.

Thanks dear. But when i removed from Global.asax file (means now no use of global.asax file), i kept in web.config file, the i got the error. Failed to load resource: the server responded with a status of 500 (Internal Server Error)

I removed then also same error.
XMLHttpRequest cannot load http://localhost/Iservice/WebService1.asmx/GetUserDetails. The 'Access-Control-Allow-Origin' header contains multiple values '*, *', but only one is allowed. Origin 'http://localhost:52083' is therefore not allowed access.

Dear,
Thanks alot. Please see in web.config file in above question. Please tell me where should i change.

Thanks
Basit.

Dear,

I already save a path in database D:abc.jpg.
How i save through upload control. and save image in D:abc.jpg in server itself.
When going to retrieve it goes to server and then retrieve not in local.

thanks
Basit.

Thanks Kornfeld. But this solution is not work in google chrome. IE and Firefox is Ok.

thanks
Basit.

Thanks David,Not installed. But we cannot add the reference. Becoz for exporting to excel purpose i used. If not then what is the alternate solution.

Thanks
Basit.

Other wise in SQL it is possible to create a schedule. on that schedule check the table if there is any expiry date the fire email??

Great Vinay.

Thanks
Basit.

Dear Mohammed,

We don't have internet in steady state, what the article is in SQL server 2008 there is replica of database on other server. what i need is my database is on local machine how to sync with the server database?

Dear Sandeep,

Thanks for your prompt reply. I created a template field where you can edit a data in a multiple rows without click on edit button there is no boundfield then how retrieve from database?

Thanks
Basit.

Binu thanks, but i want this watermark on combo/dropdown list change event. Suppose i select in the dropdown employee search then in textbox i want to show enter emloyee search.

Thanks
Basit.