15,611,775 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View Python questions
View Javascript questions
View C++ questions
View Java questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by Maideen Abdul Kader (Top 100 by date)
Maideen Abdul Kader
25-Jan-23 2:30am
View
Thank you for your reply OriginalGriff.
I have done as per your advice. Now can generate json. But once the post to API url,
It will throw error
"$error": "[ISS.0086.9249] Missing Parameter: document",
"$pipeline": [
because the json start with '[' but API accept without '[' ,
how to solve this, pls advice me.
===================
Code start with
Dim root As List(Of Root) = New List(Of Root)()
========================
code end with
root.Add(New Root With {
.manifestRequest = manifesto
})
Where did I wrong.? Pls let advice me.
Thank you OriginalGriff.
Maideen Abdul Kader
31-Dec-22 22:11pm
View
Thank you for prompt reply Mr.Sandeep
when I run this code, I got the result like this
[{
"SenderName": "ABC",
"ShipmentServiceType": "Standard Delivery",
"RecipientName": "XYZ"
"ShipmentAddressFrom": [{
"SenderName": null,
"CompanyName": "ABC ENTERPRISE",
"UnitNumber": "6,",
"Address": "Jalan TP2,"
}],
"ShipmentAddressTo": [{
"CompanyName": "XYZ Enterprise",
"UnitNumber": "10, ",
"Address": "Jalan TP5, "
}],
"InsurancePurchase": [{
"ProductDescription": "The description of the item A for buying insurance",
"Quantity": "0.00",
"UnitPrice": "0.00"
}],
"WayBill": [{
"WayBillNo": ""
}]
}]
But actual Json needs to POST in API
{ "Shipment": [{
"ShipmentServiceType": "Standard Delivery",
"SenderName": "ABC",
"RecipientName": "XYZ",
"ShipmentAddressFrom": {
"CompanyName": "ABC ENTERPRISE",
"UnitNumber": "6, ",
"Address": "Jalan TP2, "
},
"ShipmentAddressTo": {
"CompanyName": "XYZ Enterprise",
"UnitNumber": "10, ",
"Address": "Jalan TP5, "
},
"InsurancePurchase" : [
{
"ProductDescription":"The description of the item .",
"Quantity": 1,
"UnitPrice": 110
}],
"WayBill": [
{
"WayBillNo": ""
},
],
"DONumber": ""
}
] }
Pls advice me.
Thank you...
Maideen Abdul Kader
24-Dec-22 23:31pm
View
Mr.Sandeep. thank you very much for prompt response. There is no Line breaks or space in XML Format I have already posted.
Pls advice me.
Maideen Abdul Kader
22-Dec-22 2:57am
View
Deleted
hi Thank you.
Now xml generate fine. How to remove <documentelement> this.
Pls advice me. Thank you
<documentelement>
<xml>
<sname>Jetpharma Sdn Bhd
<saddress1>1, 11 & 13, Jalan Rajawali 2, Bandar Puchong Jaya,
<saddress2>N/A
<scity>Bandar Puchong Jaya
<spostcode>47000
<sstate>Selangor
<dairport>N/A
<scountry>Malaysia
<detailofcontent>Medicines/Drugs
<weight>0.00
<productpackages>1
<dimensionx>1.00
<dimensiony>1.00
<dimensionz>1.00
<chargeablerate>1.00
<rname>Klinik Syifa'
<rphone>rer
<raddress1>No. 15, Tingkat Bawah, Lorong Permai 1, Taman Perm
<raddress2>No. 15, Tingkat Bawah, Lorong Permai 1, Taman Perm
<rpostcode>rer
<rcity>
<rstate>SARAWAK
<rairport>N/A
<rcountry>MALAYSIA
<rremark>
<rvia>N/A
<servicemodeid>1
<agentid>1
<trackingno>
Maideen Abdul Kader
31-Oct-22 3:14am
View
Hi Grant. First of all I thank you for advice "not posting Bearer Token". Accepted your advice.
Json Data are from remote/externals API url when i have debugged.I have changed class as per.
But still same error when debugging. Pls advice me...
Thank you
Maideen Abdul Kader
16-Sep-21 1:05am
View
HiI have added "Text;Database=", Now is working fine.
Thank you very much
Below is final Code
declare @query varchar(5000)
declare @FileName varchar(100)
declare @FilePath varchar(100)
set @FilePath = 'C:\textfiles';
set @FileName = 'test.txt';
set @query = 'insert into [dbo].[ZZ_Flat_Data]
(CoCode, CoName, CoAddress1, CoAddress2, CoAddress, CoPost, SPeron, Transporter, DocDate, DocNo,
Category, Amount, Type)
SELECT * FROM OPENROWSET (''Microsoft.ACE.OLEDB.12.0'',''Text;Database=' + @FilePath + ''',
''SELECT CoCode, CoName, CoAddress1, CoAddress2, CoAddress, CoPost, SPeron, Transporter, DocDate, DocNo,
Category, Amount, Type FROM ' + @FileName +''')';
print @query
execute(@query)
Maideen Abdul Kader
16-Sep-21 0:37am
View
hi.
thank you for your prompt reply. Once run this below is error
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)"
Pls advise me
thank you
Maideen Abdul Kader
6-Jul-21 5:37am
View
thank you for prompt reply. But how to process first. pls can you explain.
Maideen Abdul Kader
19-Jun-21 4:24am
View
Thank you
I have removed and tried, could not
if add docno in url. it is working
example: http://courier.silsnetwork.com/WebService.asmx/GetBizTrak_DOCNO?strDocNo=900
this server is just for testing temporary uploaded.
Please advice me
Thank you
Maideen
Maideen Abdul Kader
6-Apr-21 0:35am
View
Thanks Richard
this is the code
Dim url As String = "http://localhost/delivery/JsonData/WebService.asmx/GetAllCustomer"
ServicePointManager.Expect100Continue = True
ServicePointManager.SecurityProtocol = CType(3072, SecurityProtocolType)
Dim json As String = (New WebClient).DownloadString(url.TrimEnd())
Dim res As List(Of BouncesAndBlocks) = JsonConvert.DeserializeObject(Of List(Of BouncesAndBlocks))(json)
For Each bouncesAndBlock In res
Dim cmd As New SqlCommand
cmd.Connection = conn
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "usp_API_Customer_List"
cmd.Parameters.Add(New SqlParameter("@Action", "INSERT"))
cmd.Parameters.AddWithValue("@code", bouncesAndBlock.code)
cmd.Parameters.AddWithValue("@Name", bouncesAndBlock.name)
cmd.Parameters.AddWithValue("@type", bouncesAndBlock.type)
cmd.Parameters.AddWithValue("@transporter", bouncesAndBlock.transporter)
Dim da As New SqlDataAdapter(cmd)
Dim dt As New DataTable
da.Fill(dt)
cmd.Parameters.Clear()
cmd.Dispose()
Next
Maideen Abdul Kader
5-Apr-21 1:50am
View
Thank you Richard. I will try
Maideen Abdul Kader
27-Jan-21 19:05pm
View
Thanks Mr.Richard
I used your advice, but result is '1' even though there are data in table.
Pls advice me.
Thank you
Maideen
Maideen Abdul Kader
16-Apr-20 20:55pm
View
ok Thanks for your reply.
What about the colors for each month? pls advice me
Maideen Abdul Kader
22-Nov-19 4:57am
View
Thank you all
Below I mentioned string, But in table it is int. So i have changed to int, working fine
Previous code
private bool MOExists(string id)
{
return db.tbl_Editorial.Count(e => e.Id == id) > 0; (this line)
}
Current code
private bool MOExists(int id)
{
return db.tbl_Editorial.Count(e => e.Id == id) > 0; (this line)
}
Thank you all gave me advice
Maideen
Maideen Abdul Kader
19-Nov-19 18:28pm
View
Hi
Thank you for prompt reply
Error in MORepository module
Operator '==' cannot be applied to operands of type 'int' and 'string'
private bool MOExists(string id)
{
return db.tbl_Editorial.Count(e => e.Id == id) > 0; (this line)
}
This is happened when debugging.
Pls advice me
Thank you
Maideen
Maideen Abdul Kader
25-Jul-19 21:34pm
View
Thank you I have changed ["A1"] to ("A1") it is working fine
Maideen Abdul Kader
25-Jul-19 21:21pm
View
Thank you Mr.Richard
Error is in ws.cell["A1"]
pls advice me
Thank you
Maideen Abdul Kader
17-Jun-19 22:05pm
View
Thank you Maciej.
You are right. Rotation of Pallet.It make sense.
I will take your word as advice.
Maideen Abdul Kader
27-May-19 4:16am
View
Hi Thanks of prompt reply.
I need to update column ToHours for all rows or records.
Even in Where clause, there is same error.
Pls advice me
Thank you again
Maideen
Maideen Abdul Kader
27-Apr-19 9:17am
View
Thanks Gerry.
Issue is if I add runat=server in input control, data could not populate from smartcard device.
If i remove runat=server, data can populate from smartcard device, but could not save. error is not member....
pls advice me.
Thank you
Maideen Abdul Kader
2-Mar-19 5:51am
View
Thank you
Above code in Startup.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Builder;
using Microsoft.AspNetCore.Hosting;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Extensions.Configuration;
using Microsoft.Extensions.DependencyInjection;
namespace PayRoll
{
public class Startup
{
public Startup(IConfiguration configuration)
{
Configuration = configuration;
}
public IConfiguration Configuration { get; }
// This method gets called by the runtime. Use this method to add services to the container.
public void ConfigureServices(IServiceCollection services)
{
services.Configure<cookiepolicyoptions>(options =>
{
// This lambda determines whether user consent for non-essential cookies is needed for a given request.
options.CheckConsentNeeded = context => true;
options.MinimumSameSitePolicy = SameSiteMode.None;
});
services.AddMvc().SetCompatibilityVersion(CompatibilityVersion.Version_2_2);
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
else
{
app.UseExceptionHandler("/Home/Error");
}
app.UseStaticFiles();
app.UseCookiePolicy();
app.UseMvc(routes =>
{
routes.MapRoute(
name: "default",
template: "{controller=Home}/{action=Index}/{id?}");
});
}
}
}
Pls advice me
Thank you
Maideen Abdul Kader
22-Feb-19 23:29pm
View
hiIf i use iis express vs2017, it will work, http://localhost:10417/. Only in localhost/payroll is not displayed any thing
using System;
using System.Collections.Generic;
using System.Diagnostics;
using System.Linq;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Mvc;
using PayRoll.Models;
namespace PayRoll.Controllers
{
public class HomeController : Controller
{
public IActionResult Index()
{
return View();
}
public IActionResult Privacy()
{
return View();
}
[ResponseCache(Duration = 0, Location = ResponseCacheLocation.None, NoStore = true)]
public IActionResult Error()
{
return View(new ErrorViewModel { RequestId = Activity.Current?.Id ?? HttpContext.TraceIdentifier });
}
}
}
Pls advice me.
Thank you
Maideen Abdul Kader
22-Feb-19 1:57am
View
thank you for prompt reply.
I have tried chrome just normal : localhost/payroll
Nothing happened.
I have tried http://localhost/payroll
result : This site can’t be reached. localhost refused to connect.
pls advice me.
Thank you
maideen
Maideen Abdul Kader
1-Feb-19 19:28pm
View
hiThank you for prompt reply.
I dont understand what is rootcore?
Pls advice me
thank you
Maideen Abdul Kader
29-Oct-18 20:31pm
View
Thank you all of you. Solved as per your link. copy all dll into bin and changed in web config.
Problem is that I have developed in old version vs 2012. I have changed in aspx page
<%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %> to
<%@ Register Assembly="Microsoft.ReportViewer.WebForms" Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
is working fine.
Thank you
Maideen Abdul Kader
25-Oct-18 19:32pm
View
Thank you for prompt reply
My scenario is I have developed web application using vs 2017 and Report viewer 15.
I have installed the Report viewer through NuGet Package Manager Console
and only got dll files.
I have copied following file in BIN
1. Microsoft.ReportViewer.WebForms.dll
2. Microsoft.ReportViewer.ProcessingObjectModel.dll
3. Microsoft.ReportViewer.Common.dll
and changed in web config file
<add assembly="Microsoft.ReportViewer.Common, Version=15.0.0.0, Culture=neutral, PublicKeyToken=89845DCD8080CC91"/>
<add assembly="Microsoft.ReportViewer.DataVisualization, Version=15.0.0.0, Culture=neutral, PublicKeyToken=89845DCD8080CC91"/>
<add assembly="Microsoft.ReportViewer.Design, Version=15.0.0.0, Culture=neutral, PublicKeyToken=89845DCD8080CC91"/>
<add assembly="Microsoft.ReportViewer.ProcessingObjectModel, Version=15.0.0.0, Culture=neutral, PublicKeyToken=89845DCD8080CC91"/>
<add assembly="Microsoft.ReportViewer.WebDesign, Version=15.0.0.0, Culture=neutral, PublicKeyToken=89845DCD8080CC91"/>
<add assembly="Microsoft.ReportViewer.WebForms, Version=15.0.0.0, Culture=neutral, PublicKeyToken=89845DCD8080CC91"/>
and I have downloaded this file Microsoft.RdlcDesigner.vsix and installed in my pc
on developtin mechine It is working fine.
Now need to upload in server. Server does not have VS2017 installed and also I cannot installed Microsoft.RdlcDesigner.vsix
Pls Advice me
Thank you
Maideen
Maideen Abdul Kader
31-Jul-17 20:47pm
View
ended with error
I ended up with error :
Msg 206, Level 16, State 2, Procedure usp_OP_Leave_Date, Line 13
Operand type clash: date is incompatible with int
Maideen Abdul Kader
31-Jul-17 20:45pm
View
Thanks
I ended up with error :
Msg 206, Level 16, State 2, Procedure usp_OP_Leave_Date, Line 13
Operand type clash: date is incompatible with int
Pls advice me.
Maideen Abdul Kader
29-Apr-17 21:36pm
View
Hi
thank your reply.
I have tried. but outcome is 0.
it is code i have changed
buf = Space(256)
ret = HolderName(buf)
If ret = 0 Then
txtName.Text = ret
End If
It is Smart card reader for college. It is working in VB6 for long time
Now we are converting into .Net. We have converted entire project into .NET.
But the only Part reading smartcard, we have the problem. below is declaration in vb
Declare Function HolderName Lib "mykaddll.dll" (ByVal buf As String) As Long
pls advice.
Thank you in advance
Maideen
Maideen Abdul Kader
29-Apr-17 8:44am
View
Thank you for your reply
How to use this. I am blurr
Pls explain with some example.
Pls advice
Maideen
Maideen Abdul Kader
27-Apr-17 1:28am
View
Thank you for reply...
Still same. Is there any other solution?
Pls advice me
Thank you
Maideen Abdul Kader
10-Apr-17 21:03pm
View
Mr.Chill
thanks. You are right, Query is not formated properly. Now is OK.
Thank you once again.
Maideen Abdul Kader
3-Apr-17 10:01am
View
Thank you Chill
I will check my query.
thank you once again
Maideen Abdul Kader
3-Apr-17 9:36am
View
thanks. No error
But I could not get correct results. for example,
if "p" = 43 and D=11.
But result should show 43 for P and 11 for D.
But It shows 54
Pls any solution for this.
Thank you
Maideen Abdul Kader
3-Apr-17 9:19am
View
Deleted
Thanks prompt reply
Yes there are only two value. One is P and D
Pls advice me
Thank you
Maideen Abdul Kader
3-Apr-17 9:14am
View
Thanks prompt reply
Yes there are only two value. One is P and D
Pls advice me
Thank you
Maideen Abdul Kader
14-Dec-16 1:09am
View
mr.Rayn
Yes agree what you said. HTML is look good and nice than Gridview. Also it is a requirement using HTML
Report.We have already as given report view.That is all in printable. Client needs HTML Only.
if there is no way, we have to stick with query string.It is little bit slow to display the data.
Mr.Rayn If you have any other way on this issue pls advice me.
Thank you.
Maideen Abdul Kader
30-Sep-16 6:39am
View
Thank you very much for your view and advice. I agree with you.
There are lots work to do. I will start soon on next week.
Thank you,
maideen
Maideen Abdul Kader
30-Sep-16 5:05am
View
Thanks for prompt reply.
You are right that Primary Key is important. First I will delete all and create new one. Because Some table primary key naming are total wrong like 'SNo' and 'SONo' from the previous programer. Now I need change all as 'ID'.
It is hard to find in views there are lots of views(210) table(136). This is the my Problem. I newly appointed to rectify this. Is there any Idea?
Pls advice Me...
Maideen Abdul Kader
2-Aug-16 19:50pm
View
Thank you very much..
Maideen Abdul Kader
9-May-16 21:10pm
View
Hi Ryan
thank you. I have tried as per your advice. But it is so long because it has more then 200 items and two hundred line in email
But Now I have done email attached PDF. Thank you for your reply.
Maideen Abdul Kader
23-Apr-16 6:16am
View
HiI have done some research and found that the value of popup windows only display on Lable only. Not in text box. Pls help
Below is code
<script type="text/javascript">
function SelectName() {
if (window.opener != null && !window.opener.closed) {
var form = window.opener.document.getElementsByTagName("form")[0];
var txtName = GetElement(form, "span", "Label19");
txtName.innerHTML = document.getElementById("txtItemName").value;
}
//return false;
window.close();
}
function GetElement(parent, tagName, id) {
var elem = parent.getElementsByTagName(tagName);
for (var i = 0; i < parent.getElementsByTagName(tagName).length; i++) {
if (elem[i].id.indexOf(id) != -1) {
return elem[i];
}
}
return null;
}
</script>
Maideen Abdul Kader
22-Apr-16 21:27pm
View
Hi Thiyagaran
Yes I have used. It works in html. But it is not working asp.net page with master. page
Any Idea?
I am using bootstrap for designing. Is there any issue in Bootstrap or Master Page.? Pls
maideen
Maideen Abdul Kader
20-Apr-16 3:15am
View
Thanks Alex
Yes, I am agree with you.User do not like. But our client needs this even though I have told them.
Popup code, I have given is full html code. code behind page is below
Sub SearchProducts()
Dim query As String = String.Format("SELECT id,itemid,itemdes,category,uom,suppprice,taxcode from ADM_ProductInfo where itemdes like '" & Me.txtSearch.Text & "%' or itemid='" & Me.txtSearch.Text & "' order by itemdes")
Try
Dim dt As DataTable = GetData(query)
Me.GridView1.DataSource = dt
Me.GridView1.DataBind()
Catch ex As Exception
ScriptManager.RegisterStartupScript(Me, Me.[GetType](), "Message", "alert('Error occured : " & ex.Message.ToString() & "');", True)
Finally
cmd = Nothing
conn.Close()
End Try
End Sub
Once select the product from grid, I capture id of product into Textbox that name is "txtItemName"
Parent page has textbox name "txtItemID". From the id we can pull details from database.
Parent page has master.page. and I am using Bootstrap css and js. for designing.
Do you have any idea? pls let me know..
Thank you..
Maideen Abdul Kader
25-Feb-16 2:17am
View
Pls check the link
http://www.aspsnippets.com/Articles/Export-data-from-SQL-Server-to-Excel-in-ASPNet-using-C-and-VBNet.aspx
It will help you...
Maideen Abdul Kader
19-Feb-16 4:15am
View
Deleted
Hi
You can find the ajax line chart. I have send only one pages. All other pages are also not working.. It is just sample page- Pls advice me
HTML Code
%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="mod_cpanel_Default" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
<%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta charset="utf-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=edge"/>
<meta name="viewport" content="width=device-width, initial-scale=1"/>
<meta name="description" content=""/>
<meta name="author" content=""/>
<title>CMS Dash Board</title>
<!-- Bootstrap Core CSS -->
<link href="../mod_cpanel/assets/bower_components/bootstrap/dist/css/bootstrap.min.css" rel="stylesheet"/>
<!-- MetisMenu CSS -->
<link href="../mod_cpanel/assets/bower_components/metisMenu/dist/metisMenu.min.css" rel="stylesheet"/>
<!-- Timeline CSS -->
<link href="../mod_cpanel/assets/dist/css/timeline.css" rel="stylesheet"/>
<!-- Custom CSS -->
<link href="../mod_cpanel/assets/dist/css/sb-admin-2.css" rel="stylesheet"/>
<!-- Morris Charts CSS -->
<link href="../mod_cpanel/assets/bower_components/morrisjs/morris.css" rel="stylesheet"/>
<!-- Custom Fonts -->
<link href="../mod_cpanel/assets/bower_components/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css"/>
<!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
<!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
<!--[if lt IE 9]>
<script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
<script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script>
<![endif]-->
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
<script type="text/javascript" src="https://www.google.com/jsapi"></script>
<script type="text/javascript">
google.load("visualization", "1", { packages: ["corechart"] });
google.setOnLoadCallback(drawChart);
function drawChart() {
var options = {
title: '',
'width':400,
'height': 200,
'top': 50,
'left':50
};
var chartType = $("#rblChartType input:checked").val();
//3D Pie Chart
if (chartType == "2") {
options.is3D = true;
}
//Doughnut Chart
if (chartType == "3") {
options.pieHole = 0.5;
}
$.ajax({
type: "POST",
url: "Default.aspx/GetData_CATCODE",
data: '{}',
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (r) {
var data = google.visualization.arrayToDataTable(r.d);
var chart = new google.visualization.PieChart($("#chart1")[0]);
chart.draw(data, options);
},
failure: function (r) {
alert(r.d);
},
error: function (r) {
alert(r.d);
}
});
}
</script>
&
Maideen Abdul Kader
16-Oct-15 23:56pm
View
Thanks Ryan
I am in middle in developing code in vb.net (desktop application) only for Barcode Printer as per your suggestion.
Maideen Abdul Kader
16-Oct-15 10:27am
View
thanks
attached in client PC. Is it possible to develop C# desktop for barcode printing?
If so, how can i convert the above code into C#? Pls Help me
Maideen Abdul Kader
16-Aug-15 6:07am
View
Thanks Wendelius
Sounds good.
I am in middle in changing as per your advice. I think I will be ok
Thanks
Maideen Abdul Kader
15-Aug-15 4:05am
View
Mr.Wendelius
PrivilegeId is not identifier. It is menu array. "1" means user get access the menu and "0" means user cannot access.
It is sequence of menu to load based on group. I have sent schema and data.if below 30 menu,it working fine. no issue.
but above, cannot work. i have more them 80 menu.and 20 types of group
Pls advice me.
Maideen Abdul Kader
15-Aug-15 3:39am
View
It is not fit full
Continuation
--
INSERT [dbo].[tblMenuMst] ([MenuID], [Text], [Description], [ParentID], [NavigateUrl]) VALUES (18, N'Extension Date', N'Extension Date', 3, N'../sub_mod_extand/')
INSERT [dbo].[tblMenuMst] ([MenuID], [Text], [Description], [ParentID], [NavigateUrl]) VALUES (19, N'Expiry Date Report', N'Expiry Date Report', 3, N'../sub_mod_subscription/expiry_sub.aspx')
INSERT [dbo].[tblMenuMst] ([MenuID], [Text], [Description], [ParentID], [NavigateUrl]) VALUES (20, N'Renewal Form', N'Renewal Form', 3, N'../mod_sub_Renewal/')
INSERT [dbo].[tblMenuMst] ([MenuID], [Text], [Description], [ParentID], [NavigateUrl]) VALUES (21, N'Refund', N'Refund', 3, N'../sub_mod_refund/')
INSERT [dbo].[tblMenuMst] ([MenuID], [Text], [Description], [ParentID], [NavigateUrl]) VALUES (22, N'Label Print', N'Label Print', 3, N'../sub_mod_lable/')
INSERT [dbo].[tblMenuMst] ([MenuID], [Text], [Description], [ParentID], [NavigateUrl]) VALUES (23, N'Complimentry Copies(Market)', N'Complimentry Copies(Market)', 2, N'../sub_mod_lable/Market_view.aspx')
INSERT [dbo].[tblMenuMst] ([MenuID], [Text], [Description], [ParentID], [NavigateUrl]) VALUES (24, N'Complimentry Copies(Editorial)', N'Complimentry Copies(Editorial)', 2, N'../sub_mod_lable/Editorial_view.aspx')
INSERT [dbo].[tblMenuMst] ([MenuID], [Text], [Description], [ParentID], [NavigateUrl]) VALUES (25, N'Email-Receipt', N'Email-Receipt', 2, N'../sub_mail_RC/')
INSERT [dbo].[tblMenuMst] ([MenuID], [Text], [Description], [ParentID], [NavigateUrl]) VALUES (26, N'Complains Log', N'Complains Log', 4, N'../sub_mod_Complient/')
INSERT [dbo].[tblMenuMst] ([MenuID], [Text], [Description], [ParentID], [NavigateUrl]) VALUES (27, N'Complains Reports', N'Complains Reports', 4, N'../sub_mod_Complient/complaint_RPT.aspx')
INSERT [dbo].[tblMenuMst] ([MenuID], [Text], [Description], [ParentID], [NavigateUrl]) VALUES (28, N'Reports By SAgent', N'Reports By SAgent', 4, N'../sub_mod_Complient/Compalins_By_SAgent.aspx')
INSERT [dbo].[tblMenuMst] ([MenuID], [Text], [Description], [ParentID], [NavigateUrl]) VALUES (29, N'DTEM-Master-SSOD', N'DTEM-Master-SSOD', 4, N'../sub_mod_SSOD/')
INSERT [dbo].[tblMenuMst] ([MenuID], [Text], [Description], [ParentID], [NavigateUrl]) VALUES (30, N'Commence Date Summary', N'Commence Date Summary', 5, N'../sub_rpt_finance/')
INSERT [dbo].[tblMenuMst] ([MenuID], [Text], [Description], [ParentID], [NavigateUrl]) VALUES (31, N'Payment Summary', N'Payment Summary', 5, N'../sub_rpt_finance/wk_rpt_Mode.aspx')
INSERT [dbo].[tblMenuMst] ([MenuID], [Text], [Description], [ParentID], [NavigateUrl]) VALUES (32, N'Detailed Transaction Report', N'Detailed Transaction Report', 5, N'../sub_rpt_finance/Detail_Trans.aspx')
INSERT [dbo].[tblMenuMst] ([MenuID], [Text], [Description], [ParentID], [NavigateUrl]) VALUES (33, N'Total Payment with GST', N'Total Payment with GST', 5, N'../sub_rpt_finance/wk_Control_RPT.aspx')
INSERT [dbo].[tblMenuMst] ([MenuID], [Text], [Description], [ParentID], [NavigateUrl]) VALUES (34, N'Detailed By Issue No', N'Detailed By Issue No', 5, N'../sub_rpt_Audit/')
INSERT [dbo].[tblMenuMst] ([MenuID], [Text], [Description], [ParentID], [NavigateUrl]) VALUES (35, N'Detailed By Issue No(Pack)', N'Detailed By Issue No(Pack)', 5, N'../sub_rpt_Audit/Summary_PKcode.aspx')
INSERT [dbo].[tblMenuMst] ([MenuID], [Text], [Description], [ParentID], [NavigateUrl]) VALUES (36, N'Detailed By Issue No(State)', N'Detailed By Issue No(State)', 5, N'../sub_rpt_Audit/Summary_State.aspx')
INSERT [dbo].[tblMenuMst] ([MenuID], [Text], [Description], [ParentID], [NavigateUrl]) VALUES (37, N'Registration', N'Registration', 7, N'../mod_registration/')
INSERT [dbo].[tblMenuMst] ([MenuID], [Text], [Description], [ParentID], [NavigateUrl]) VALUES (38, N'Menu Management', N'Menu Management', 7, N'../mod_registration/menu_add.aspx')
INSERT [dbo].[tblMenuMst] ([MenuID], [Text], [Description], [ParentID], [NavigateUrl]) VALUES (39, N'Session Tracker', N'Session Tracker', 6, N'../hp_help/SessionHe
Maideen Abdul Kader
15-Aug-15 3:37am
View
Mr.Wendlius
It is data
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[tblDesgMst] ([DesigCode], [Description], [Active]) VALUES (N'SA ', N'SYSTEM ADMIN', 1)
INSERT [dbo].[tblDesgMst] ([DesigCode], [Description], [Active]) VALUES (N'AD ', N'ADMIN', 1)
INSERT [dbo].[tblDesgMst] ([DesigCode], [Description], [Active]) VALUES (N'DE ', N'DATA ENTRY', 1)
INSERT [dbo].[tblDesgMst] ([DesigCode], [Description], [Active]) VALUES (N'CS ', N'CUSTOMER SERVICE', 1)
INSERT [dbo].[tblDesgMst] ([DesigCode], [Description], [Active]) VALUES (N'MM ', N'MANAGEMENT', 1)
INSERT [dbo].[tblGroupPrivMst] ([GroupCode], [GroupDesc], [PrivilegeID]) VALUES (N'SA ', N'SYSTEM ADMIN', N'1111111111111111111111111111111111111111111111111111')
INSERT [dbo].[tblGroupPrivMst] ([GroupCode], [GroupDesc], [PrivilegeID]) VALUES (N'AD ', N'ADMIN', N'1111111001111111111111111111111111111111111111111100')
INSERT [dbo].[tblGroupPrivMst] ([GroupCode], [GroupDesc], [PrivilegeID]) VALUES (N'DE ', N'DATA ENTRY', N'1010100001000101111100001000000000000000000000000000')
INSERT [dbo].[tblGroupPrivMst] ([GroupCode], [GroupDesc], [PrivilegeID]) VALUES (N'CS ', N'CUSTOMER SERVICE', N'1001000001000000000000000000000000000000000000111100')
INSERT [dbo].[tblGroupPrivMst] ([GroupCode], [GroupDesc], [PrivilegeID]) VALUES (N'MM ', N'MANAGEMENT', N'1000100001000000000000000011011111110000000000000000')
SET IDENTITY_INSERT [dbo].[tblMenuMst] ON
INSERT [dbo].[tblMenuMst] ([MenuID], [Text], [Description], [ParentID], [NavigateUrl]) VALUES (1, N'Home', N'Home', NULL, N'../mod_cpanel/default.aspx')
INSERT [dbo].[tblMenuMst] ([MenuID], [Text], [Description], [ParentID], [NavigateUrl]) VALUES (2, N'Administration', N'Administration', NULL, N'#')
INSERT [dbo].[tblMenuMst] ([MenuID], [Text], [Description], [ParentID], [NavigateUrl]) VALUES (3, N'Subscription', N'Subscription', NULL, N'#')
INSERT [dbo].[tblMenuMst] ([MenuID], [Text], [Description], [ParentID], [NavigateUrl]) VALUES (4, N'Customer Service', N'Customer Service', NULL, N'#')
INSERT [dbo].[tblMenuMst] ([MenuID], [Text], [Description], [ParentID], [NavigateUrl]) VALUES (5, N'Reports', N'Reports', NULL, N'#')
INSERT [dbo].[tblMenuMst] ([MenuID], [Text], [Description], [ParentID], [NavigateUrl]) VALUES (6, N'Utilities', N'Utilities', NULL, N'#')
INSERT [dbo].[tblMenuMst] ([MenuID], [Text], [Description], [ParentID], [NavigateUrl]) VALUES (7, N'User Registration', N'User Registration', NULL, N'#')
INSERT [dbo].[tblMenuMst] ([MenuID], [Text], [Description], [ParentID], [NavigateUrl]) VALUES (8, N'System Admin', N'System Admin', NULL, N'#')
INSERT [dbo].[tblMenuMst] ([MenuID], [Text], [Description], [ParentID], [NavigateUrl]) VALUES (9, N'Help', N'Help', NULL, N'#')
INSERT [dbo].[tblMenuMst] ([MenuID], [Text], [Description], [ParentID], [NavigateUrl]) VALUES (10, N'Logout', N'Logout', NULL, N'#')
INSERT [dbo].[tblMenuMst] ([MenuID], [Text], [Description], [ParentID], [NavigateUrl]) VALUES (11, N'Parameter', N'Parameter', 2, N'../sub_mod_parameter/')
INSERT [dbo].[tblMenuMst] ([MenuID], [Text], [Description], [ParentID], [NavigateUrl]) VALUES (12, N'Main Agent', N'Main Agent', 2, N'../sub_mod_MAgent/')
INSERT [dbo].[tblMenuMst] ([MenuID], [Text], [Description], [ParentID], [NavigateUrl]) VALUES (13, N'Sub Agent', N'Sub Agent', 2, N'../sub_mod_SAgent/')
INSERT [dbo].[tblMenuMst] ([MenuID], [Text], [Description], [ParentID], [NavigateUrl]) VALUES (14, N'Subscription', N'Subscription', 3, N'../sub_mod_subscription/')
INSERT [dbo].[tblMenuMst] ([MenuID], [Text], [Description], [ParentID], [NavigateUrl]) VALUES (15, N'Cancel Receipt', N'Cancel Receipt', 3, N'../sub_mod_receipt/Receipt_Cancel.aspx')
INSERT [dbo].[tblMenuMst] ([MenuID], [Text], [Description], [ParentID], [NavigateUrl]) VALUES (16, N'Print Receipt', N'Print Receipt', 3, N'../sub_mod_receipt/')
INSERT [dbo].[tblMenuMst] ([MenuID], [Text], [Description], [ParentID], [NavigateUrl]) VALUES (17, N'Export Receipt', N'Export Receipt', 3, N'../sub_mod_receipt/ReceiptExport.aspx')
Maideen Abdul Kader
15-Aug-15 3:33am
View
Mr.Wendelius
Below is my tables with data.
pls advice me
----
GO
/****** Object: StoredProcedure [dbo].[W_usp_MENU_access] Script Date: 15/08/2015 3:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[W_usp_MENU_access]
@UserID [varchar](50)
WITH EXECUTE AS CALLER
AS
BEGIN
--DECLARE @GroupCode VARCHAR(5)
--SET @GroupCode=(SELECT DISTINCT GroupCode FROM tblUserGrpMap WHERE UserID=@UserID)
CREATE TABLE #TMP(MenuID INT, Text VARCHAR(50), Description VARCHAR(50), ParentID INT, NavigateUrl VARCHAR(100))
DECLARE @VAL VARCHAR(MAX), @Pos INT, @len INT
SET @VAL=(SELECT REPLACE(REPLACE(CONVERT(VARCHAR(150), SUM(CAST(PrivilegeID AS
numeric(38,0)))), '2', '1'), '3', '1') FROM tblGroupPrivMst WHERE GroupCode
in (SELECT GroupCode FROM tblUserGrpMap WHERE UserID=@UserID))
SET @Pos=1
SET @len=LEN(@VAL)
WHILE(@len!=0)
BEGIN
DECLARE @Value CHAR(1)
SET @Value=SUBSTRING(@VAL, @Pos, 1)
IF @Value=1
BEGIN
--PRINT @Value
INSERT INTO #TMP SELECT * FROM tblMenuMst WHERE MenuID=@Pos
END
SET @Pos=@Pos+1
SET @len=@len-1
END
--For first Node (Inserting The Parent Node)
INSERT INTO #TMP SELECT * FROM tblMenuMst WHERE MenuID IN(SELECT DISTINCT
ParentID FROM #TMP WHERE ParentID NOT IN(SELECT MenuID FROM #TMP))
--For second Node (Inserting The Parent Node)
INSERT INTO #TMP SELECT * FROM tblMenuMst WHERE MenuID IN(SELECT DISTINCT
ParentID FROM #TMP WHERE ParentID NOT IN(SELECT MenuID FROM #TMP))
--For third Node (Inserting The Parent Node)
INSERT INTO #TMP SELECT * FROM tblMenuMst WHERE MenuID IN(SELECT DISTINCT
ParentID FROM #TMP WHERE ParentID NOT IN(SELECT MenuID FROM #TMP))
SELECT * FROM #TMP ORDER BY MenuID ASC
DROP TABLE #TMP
END
--INSERT INTO #TMP SELECT * FROM tblMenuMst WHERE MenuID IN(SELECT DISTINCT
--ParentID FROM #TMP WHERE ParentID NOT IN(SELECT MenuID FROM #TMP))
GO
/****** Object: Table [dbo].[tblDesgMst] Script Date: 15/08/2015 3:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tblDesgMst](
[DesigCode] [char](3) NOT NULL,
[Description] [varchar](50) NULL,
[Active] [bit] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[tblGroupPrivMst] Script Date: 15/08/2015 3:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tblGroupPrivMst](
[GroupCode] [char](3) NOT NULL,
[GroupDesc] [varchar](50) NULL,
[PrivilegeID] [varchar](150) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[tblMenuMst] Script Date: 15/08/2015 3:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tblMenuMst](
[MenuID] [int] IDENTITY(1,1) NOT NULL,
[Text] [varchar](50) NULL,
[Description] [varchar](200) NULL,
[ParentID] [int] NULL,
[NavigateUrl] [varchar](100) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[tblUserGrpMap] Script Date: 15/08/2015 3:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tblUserGrpMap](
[UserID] [char](10) NULL,
[GroupCode] [char](3) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[tblUserMst] Script Date: 15/08/2015 3:31:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tblUserMst](
[ID] [int] IDENTITY(1,1) NOT NULL,
[UserID] [char](10) NOT NULL,
[Name] [varchar](70) NULL,
[Password] [varchar](40) NULL,
[DOB] [datetime] NULL,
[DOJ] [datetime] NULL,
[DesigCode] [char](3) NULL,
[EmailId] [varchar](50) NULL,
[TelNo] [varchar](26) NULL,
[HandPhone] [varchar](25) NULL,
[Active] [bit] NULL,
[Question] [varchar](100) NULL,
[Answer] [varchar](100) NULL,
[Status] [nvarchar](15) NULL
)ON [PRIMA
Maideen Abdul Kader
15-Aug-15 3:19am
View
Mr.Wendelius
Also I have tried Only this part
(SELECT REPLACE(REPLACE(CONVERT(VARCHAR(150), SUM(CAST(PrivilegeID AS
FLOAT(53)))), '2', '1'), '3', '1') FROM tblGroupPrivMst WHERE GroupCode
in (SELECT GroupCode FROM tblUserGrpMap WHERE UserID='maid'))
"maid" is user login id
But result is '1.11111e+051' But it should be "1010100001000101111100001000000000000000000000000000"
Pls advice me
Maideen Abdul Kader
15-Aug-15 3:09am
View
Mr.Wendelius
Thank for your reply
I have changed as per instruction, But another error message
"Conversion failed when converting the varchar value '.' to data type int"
Pls advice me
Maideen
Maideen Abdul Kader
13-Aug-15 2:02am
View
Thank You Mr.Giri
Now working. Thank you again
maideen
Maideen Abdul Kader
13-Aug-15 1:45am
View
Mr.Giri
Thanks.
But nothing happened
Pls advice me
maideen
Maideen Abdul Kader
13-Aug-15 0:49am
View
Hi
I have tried. But nothing happend
Dim ch As CheckBox
For i As Integer = 0 To GridView1.Rows.Count - 1
ch = CType(GridView1.Rows(i).Cells(0).FindControl("chk"), CheckBox)
If ch.Checked = True Then
Me.txtPrivCode.Text = 1
ElseIf ch.Checked = False Then
Me.txtPrivCode.Text = 0
End If
Next
pls advice me
Maideen Abdul Kader
3-Aug-15 1:13am
View
Thank you Mr.Damith
I have changed format. Now It is working
Maideen
Maideen Abdul Kader
3-Aug-15 0:16am
View
Thanks Mr.Damith
It is working. But there is small issue.
Date format (dd-MM-yyyy)
If user first select date like below order
07-08-2015 , 15-08-2015 , 09-09-2015, 21-09-2015
but grid view shows below order
07-08-2015
09-09-2015
15-08-2015
21-09-2015
is there any advice for this?
Thank you in advance
maideen
Maideen Abdul Kader
14-Jul-15 4:51am
View
sorry Mr.Mika. I have wrongly click four star. Must be Five. Sorry.
Maideen Abdul Kader
14-Jul-15 4:50am
View
Thank you So Much Mika Solved
Maideen Abdul Kader
14-Jul-15 3:13am
View
Yes I did. But show the Only one number... Because there are the more than 500 customer... need more than 500 DO No.
Maideen Abdul Kader
14-Jul-15 3:08am
View
Thanks
In MsSQL 2012,there is option that can create the Sequences. It is under Programmability -> Sequences. I have created the DONo (Delivery order No) in the Sequences and call into Stored Procedure. Pls
Maideen Abdul Kader
14-Jul-15 0:41am
View
Thank for your reply.
I explain my issue. Pls advice me
I have the view "vwRDMS". It is basic data of customer nearly 500 customer. Every month user need to generate DO and Invoice based on Standing order. Once execute SP, It is inserted the data into temp table "SOMaster_TEMP". It is work fine. But DO No can not be generated.
I have setup DONo In Sequences. It capture the same DO number for all customer. Here is I am facing problem.
Pls advice me.
Thank you
Maideen
Maideen Abdul Kader
8-Jul-15 23:49pm
View
Thank you
I have solved the issue. This is the code
Private Sub SendHtmlFormattedEmail(ByVal recepientEmail As String, ByVal subject As String, ByVal body As String)
'After config mailSettings section in web.config, you don't need to initialization client's property
Dim client As New SmtpClient()
Dim message As New MailMessage()
message.Body = body
message.To.Add(recepientEmail)
message.Subject = subject
message.IsBodyHtml = True
client.Send(message)
End Sub
Maideen Abdul Kader
8-Jul-15 20:28pm
View
Hi Giri
thank you first of all
It sends mail But in html format. Pls advise.
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head><title></title>
<style>
.text_style
{
/*height: 23px;*/
font-size:25px;
font-family:Calibri,Verdana,Arial,'Times New Roman';
}
.position_image
{
text-align:center;
}
.tbl_size
{
width:750px;
border:double;
}
.text_style_body
{
font-size:14px;
font-family:Calibri,Verdana,Arial,'Times New Roman';
}
.text_style_bold
{
font-weight:bold;
}
.html_formating
{
/*border-collapse:collapse;*/
/*padding:1px;
border: 1px solid black;
padding: 5px;*/
width:750px;
text-align: left;
font-family:Calibri,Verdana,Arial,'Times New Roman';
color: black;
/*border:2px;*/
}
.headercolor {
background-color:#B43104;
border:double;
color:#fff
}
.rowcolor {
background-color: #eee;
background-color:#DF7401;
}
</style>
</head>
<body>
<table class="tbl_size position_image">
<tr>
<td colspan="2" class="position_image"><img src="http://www.silsnetwork.com/edge/TEM.logo_Sendblaster.jpg" /></td>
</tr>
<tr>
<td colspan="2" class="position_image">----------------------------------</td>
</tr>
<tr>
<td colspan="2" class="position_image text_style" >
THE EDGE FEEDBACK LOG
</td>
</tr>
</table>
<br />
<div class="text_style_body">Date:7/9/2015 8:26:50 AM</div>
<br />
<div class="text_style_body">Complains Log No:- 00035</div>
<br />
<div class="text_style_body">Dear Mr/Mrs/Dato/Datin/Dato Seri/Datin Seri maideen</div>
<p class="text_style_body">Greetings From The EDGE.</p>
<p class="text_style_body">Thank you for your feedback.</p>
<table class="text_style_body">
<tr>
<td>Nature of Complain</td>
<td>:</td>
<td>DELIVERY UP</td>
</tr>
<tr>
<td>Issue No</td>
<td>:</td>
<td>123</td>
</tr>
<tr>
<td>Remarks</td>
<td>:</td>
<td>fgsfgs</td>
</tr>
<tr>
<td>Subscriber ID</td>
<td>:</td>
<td>32824</td>
</tr>
<tr>
<td>Delivery Agent ID</td>
<td>:</td>
<td>B-APD*</td>
</tr>
<tr>
<td>Address</td>
<td>:</td>
<td>address1</td>
</tr>
<tr>
<td></td>
<td></td>
<td>address2</td>
</tr>
<tr>
<td>Delivery Address</td>
<td>:</td>
<td>address1</td>
</tr>
<tr>
<td>Post Code</td>
<td>:</td>
<td>poscode</td>
</tr>
<tr>
<td>City</td>
<td>:</td>
<td>pj</td>
</tr>
<tr>
<td>State</td>
<td>:</td>
<td>MELAKA Country: MALAYSIA</td>
</tr>
<tr>
<td>Complain Status</td>
<td>:</td>
<td>ACTIVE</td>
</tr>
</table>
<br />
<div class="text_style_bol
Maideen Abdul Kader
6-Jul-15 21:31pm
View
In our country, GST has been implemented just 2 month before. Our Govt want to round up 5 and 10 cents. because we do not have 1 cents and 2 cents in coin. that why i need. Anyway credit goes to PIEBALD
maideen
Maideen Abdul Kader
6-Jul-15 20:45pm
View
Hi
I do not have option "Answered" Previously I got. any issue site?
Maideen Abdul Kader
6-Jul-15 20:42pm
View
thank
By using your advice
If I round
12.31 / 12.32 goes to 12.30
12.33 / 12.34 / 12.35 / 12.36 / 12.37 goes to 12.35
12.38 / 12.39 goes to 12.40
I think so, sounds good. in Cents, not so much lose or gain. Thank you.
Maideen Abdul Kader
2-Jul-15 4:36am
View
Thank you very much
Solved...
Maideen Abdul Kader
2-Jul-15 4:24am
View
Thank you for fast reply Mr.Griff
Your code solved this line
UPDATE [dbo].[SOMaster_TEMP] SET [BEND] =[Qty] % [STDB]
I got result is 2. It is fine.
Then How i get 302. ( UPDATE [dbo].[SOMaster_TEMP] SET [BSTD] = [Qty] /[STDB])
Please advice me
Maideen
Maideen Abdul Kader
17-Dec-14 6:55am
View
Hi KM Perumal.
I am using your code. Thanks working fine. But If any table does not have data, the result not appear
Example if #tableRc does not have data for the particular client, the result shows nothing.
Pls help me in this issue
Maideen
Maideen Abdul Kader
17-Dec-14 5:52am
View
thanks
both KM Perumal and Tomas takac code is working fine
Thank you very much both
madieen
Maideen Abdul Kader
17-Dec-14 5:51am
View
thanks
both KM Perumal and Tomas takac code is working fine
Thank you very much both
madieen
Maideen Abdul Kader
5-Dec-14 9:33am
View
Hi Damith
Thank you for prompt reply
Where to check ? I have tried, error is same
maideen
Maideen Abdul Kader
10-Jul-14 19:17pm
View
Thanks Atyant
As per advice I did the Stored procedure. Working fine. But only in single value like '2011' cannot be range value
like 2010 to 2013.
Pls Advice.
Thank You.
Below is my SP
ALTER PROCEDURE [dbo].[usp_pivot_by_Year_AGENT]
@vYEAR varchar(100)
AS
BEGIN
SET NOCOUNT ON;
Declare @sSQL varchar(1000)
Set @sSQL = 'SELECT * FROM
(SELECT salesEXE,SalesEXEName,name,gross,YearNo FROM vw_Pivot_Month_ALL) TableYearNo
pivot (Sum(gross) for YearNo IN (['+@vYEAR+'])) pivotTable'
exec(@sSQL)
Maideen Abdul Kader
8-Jul-14 22:00pm
View
Hi abhinav
I have tried, But error Incorrect syntax near '@Year'.
Below is my SP
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[usp_pivot_by_Year_AGENT]
@year varchar(4)
AS
BEGIN
SET NOCOUNT ON;
truncate table tbl_Pivot_AGENT
insert into tbl_Pivot_AGENT
SELECT * FROM ( SELECT salesEXE,SalesEXEName,name,gross,[Year] FROM vw_Pivot_Month_ALL) TableYearNo
pivot (Sum(gross) for [year] in (@year)
)pivotTable
END
Pls advice
Maideen
Maideen Abdul Kader
2-Jul-14 4:06am
View
Hi Vani
I have given the small example.
for example I need to retrieve all data under Sabah whether match with newspaper i have selected or date i have selected.
There are lot data under sabah
Pls advise me.
Thank you
Maideen
Maideen Abdul Kader
26-Jun-14 4:05am
View
Thank you Vani.
it is work.
Maideen Abdul Kader
7-Apr-14 10:08am
View
yes. Thank you
After remove id, works fine...
Maideen Abdul Kader
22-Mar-14 21:21pm
View
peter
i need $role= (how to get value of role). pls
Maideen Abdul Kader
22-Mar-14 21:20pm
View
and also i need to know if i change the code like
Select login_id,password,role from user_right where login_id='$username' and password='$password'
why the error prompt "login id and password wrong. If i run original code with same username and password, it fine
and also i need $role= how should i get value of role. pls
Maideen Abdul Kader
22-Mar-14 20:52pm
View
coz, i need some other column like role and access no to be in session.
I do not know how to do this. Let say I need to know the role of the user and email id how to do?
Maideen Abdul Kader
9-Nov-13 20:36pm
View
hi mike
i have changed according to your suggestion. No error, but cannot update the data. working fine in mssql console using exec command.
working fine. But cannot update. any idea. I have posting my code once again
cmd = New SqlCommand
cmd.Connection = conn
cmd.CommandText = "web_usp_empData_Update"
cmd.Parameters.Add(New SqlParameter("@id", Me.txtID.Text))
cmd.CommandType = CommandType.StoredProcedure
Try
cmd.Parameters.AddWithValue("@Code", Me.txtCode.Text)
cmd.Parameters.AddWithValue("@Name", UCase(Me.txtName.Text))
cmd.Parameters.AddWithValue("@Address", Me.txtAddress.Text)
cmd.Parameters.AddWithValue("@Tel", Me.txtTel.Text)
cmd.Parameters.AddWithValue("@Hp", Me.txtHP.Text)
cmd.Parameters.AddWithValue("@email", Me.txtEmail.Text)
cmd.Parameters.AddWithValue("@Nric", Me.txtNRIC.Text)
cmd.Parameters.AddWithValue("@Jobtitle", Me.cboJobTitle.SelectedValue)
cmd.Parameters.AddWithValue("@Dept", Me.cboDepartment.SelectedValue)
conn.Open()
cmd.ExecuteNonQuery()
'cmd.Dispose()
conn.Close()
Session.Remove("empID")
Response.Redirect("empVIEW.aspx")
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "alert", "alert('Updated!');", True)
Catch ex As Exception
ScriptManager.RegisterStartupScript(Me, Me.[GetType](), "Message", "alert('Error occured : " & ex.Message.ToString() & "');", True)
'Throw ex
Finally
cmd.Dispose()
conn.Close()
End Try
Maideen Abdul Kader
9-Nov-13 20:31pm
View
Hi
it is working. I have added cmd = New SqlCommand on the top of coding. Now no error. but cannot store
have any idea? pls
Maideen Abdul Kader
9-Nov-13 5:32am
View
praba
same error
pls
maideen
Maideen Abdul Kader
9-Nov-13 5:32am
View
praba
same error, pls help me
maideen
Maideen Abdul Kader
17-Oct-13 5:41am
View
Hi Below code work fine. thank all of you to support me
function CookieSetText()
{
var cookieEnabled=(navigator.cookieEnabled)? true : false
//if not IE4+ nor NS6+
if (typeof navigator.cookieEnabled == "undefined" && !cookieEnabled)
{
document.cookie="testcookie"
cookieEnabled=(document.cookie.indexOf("testcookie")!=-1)? true : false
}
if (cookieEnabled)
{
document.write("Cookies are enabled");
}
else
{
document.write("Cookies are not enabled");
}
}
window.onload = function () {
//calling the function on page load
CookieSetText();
};
maideen
Maideen Abdul Kader
14-Oct-13 1:56am
View
Thanks Mr.Tatraja
Solved the problem
Maideen Abdul Kader
14-Oct-13 1:56am
View
thanks. Mr.andre...
Maideen Abdul Kader
11-Oct-13 23:21pm
View
yes you are right. the permission issue
thank you
Maideen Abdul Kader
17-Jul-13 9:18am
View
Mr.Raja Sekhar.
I have tried to select data between two date. But it shows the error
"Must declare the scalar variable "@FDate".
I have inserted the line and i have declare the variable
ALTER PROCEDURE [dbo].[usp_pivot_by_RCVD_Dynamic]
@FDate AS DATETIME,
@TDate AS DATETIME
SELECT * into tbl_RCVDfor_Rajan FROM (SELECT dbo.vwRCHeadDetails.RCDate,dbo.vwRCHeadDetails.CourseCode,dbo.vw_PIVOT_RCVD_DISTINCT.RCVDFor,
dbo.vwRCHeadDetails.Amount FROM dbo.vw_PIVOT_RCVD_DISTINCT INNER JOIN vwRCHeadDetails
ON dbo.vw_PIVOT_RCVD_DISTINCT.rcvdfor = dbo.vwRCHeadDetails.rcvdfor
WHERE dbo.vwRCHeadDetails.RCDate >=@FDate and dbo.vwRCHeadDetails.RCDate <=@TDate
) AS PivotData
PIVOT ( SUM(Amount) FOR RCVDFor IN (' + @PivotColumnHeaders + ' )) AS PivotTable '
Pls Advise me where is my wrong.
maideen
Maideen Abdul Kader
17-Jul-13 9:08am
View
Thank you Mr.Karthik.
But cannot export. There is an error in execution.....
annot process the object "set fmtonly off exec dbo.usp_pivot_by_RCVD_Dynamic".
The OLE DB provider "SQLNCLI" for linked server "(null)" indicates that either the object has no columns or
the current user does not have permissions on that object.
Any solution....
Maideen Abdul Kader
17-Jul-13 9:02am
View
Thanks Mr.Raja sekher
Finally got it. Thanks. can create table.
But cannot export into excel. The error is
"OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "The Microsoft Jet database engine could not find the object 'Sheet1'. Make sure the object exists and that you spell its name and the path name correctly.".
Msg 7350, Level 16, State 2, Procedure usp_pivot_by_RCVD_Dynamic, Line 16
Cannot get the column information from OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".
Maideen Abdul Kader
17-Jul-13 8:48am
View
Mr.Karthik
Thanks for reply
I have error in export to excel. I have tried in admin privilege also. The error is
Cannot process the object "set fmtonly off exec dbo.usp_pivot_by_RCVD_Dynamic".
The OLE DB provider "SQLNCLI" for linked server "(null)" indicates that either the object has no columns or
the current user does not have permissions on that object.
Maideen
Maideen Abdul Kader
16-Jul-13 8:45am
View
Mr.Karthik
error Invalid object name '#tempTable'.
It is dynamic pivot , It will increase based on user input data.
Pls help me
Maideen Abdul Kader
16-Jul-13 8:17am
View
Mr.Raja sekhar
Thanks for reply
Thing is we do not know the number of column. Because it is dynamic pivot, It will create according to data in table.
Example:
+ @PivotColumnHeaders + is based on data input by user. It will increase. So I need to export directly to excel or need dynamic table.
Is it possible for dynamic table? Increase in column based on user input. Like category. Category can be increased at any level. This is my problem now. Pls
Pls
Maideen
Maideen Abdul Kader
16-Jul-13 5:48am
View
Mr.Karthik
thanks for quick reply. I have executed. No error. But how can i see the data in the temptable. the whole idea is to export the result into excel sheet. If it is in table, i can export. I think you understand my issue. Pls
Pls
Maideen
Maideen Abdul Kader
16-Jul-13 5:14am
View
HiThanks
MSSQL database table.
maideen
Show More