Comments by Maideen Abdul Kader (Top 100 by date)

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)

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

thank you for prompt reply. But how to process first. pls can you explain.

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

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

Thank you Richard. I will try

Thanks Mr.Richard
I used your advice, but result is '1' even though there are data in table.
Pls advice me.
Thank you
Maideen

ok Thanks for your reply.
What about the colors for each month? pls advice me

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

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

Thank you I have changed ["A1"] to ("A1") it is working fine

Thank you Mr.Richard
Error is in ws.cell["A1"]
pls advice me
Thank you

Thank you Maciej.
You are right. Rotation of Pallet.It make sense.
I will take your word as advice.

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

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

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

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

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

hiThank you for prompt reply.
I dont understand what is rootcore?
Pls advice me

thank you

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

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

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

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.

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

Thank you for your reply

How to use this. I am blurr
Pls explain with some example.

Pls advice
Maideen

Thank you for reply...
Still same. Is there any other solution?
Pls advice me
Thank you

Mr.Chill

thanks. You are right, Query is not formated properly. Now is OK.

Thank you once again.

Thank you Chill
I will check my query.
thank you once again

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

Thanks prompt reply

Yes there are only two value. One is P and D

Pls advice me

Thank you

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.

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

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...

Thank you very much..

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.

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>

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

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..

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...

Thanks Ryan
I am in middle in developing code in vb.net (desktop application) only for Barcode Printer as per your suggestion.

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

Thanks Wendelius
Sounds good.
I am in middle in changing as per your advice. I think I will be ok
Thanks

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.

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

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')

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

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

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

Thank You Mr.Giri
Now working. Thank you again
maideen

Mr.Giri
Thanks.
But nothing happened

Pls advice me
maideen

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

Thank you Mr.Damith
I have changed format. Now It is working
Maideen

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

sorry Mr.Mika. I have wrongly click four star. Must be Five. Sorry.

Thank you So Much Mika Solved

Yes I did. But show the Only one number... Because there are the more than 500 customer... need more than 500 DO No.

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

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

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

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

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

Hi
I do not have option "Answered" Previously I got. any issue site?

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.

Thank you very much
Solved...

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

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

thanks

both KM Perumal and Tomas takac code is working fine

Thank you very much both

madieen

thanks

both KM Perumal and Tomas takac code is working fine

Thank you very much both

madieen

Hi Damith
Thank you for prompt reply

Where to check ? I have tried, error is same

maideen

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)

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

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

Thank you Vani.
it is work.

yes. Thank you

After remove id, works fine...

peter
i need $role= (how to get value of role). pls

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

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?

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

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

praba

same error

pls

maideen

praba

same error, pls help me
maideen

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

Thanks Mr.Tatraja
Solved the problem

thanks. Mr.andre...

yes you are right. the permission issue
thank you

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

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....

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)".

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

Mr.Karthik
error Invalid object name '#tempTable'.
It is dynamic pivot , It will increase based on user input data.
Pls help me

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

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

HiThanks
MSSQL database table.
maideen