Problems on Insert and Update Statement - C#: "Problems on Insert and Update Statement"
http://www.visli.com/
This is my Technical area of troubleshooting and learning new Programming skills and many more. Here you will find answers for many new technologies like asp.net 2.0/3.5,4.0 C# access, mysql, Amazon Webservice ,Sql-server, JD Edwards, SAS, Salesforce, APIs, MVC and many more. please visit & discuss.
Monday, June 30, 2008
Cannot update MySql database from DataSet
cannot update MySql database from DataSet : Visual Basic General : [LOC] MSDN Forums: "cannot update MySql database from DataSet"
ECNDA.InsertCommand = custCB.GetInsertCommand
ECNDA.UpdateCommand = custCB.GetUpdateCommand
ECNDA.DeleteCommand = custCB.GetDeleteCommand
www.visli.com
ECNDA.InsertCommand = custCB.GetInsertCommand
ECNDA.UpdateCommand = custCB.GetUpdateCommand
ECNDA.DeleteCommand = custCB.GetDeleteCommand
www.visli.com
Complex Data Binding with the Accordion Control
Complex Data Binding with the Accordion Control: ASP Alliance
The Accordion control is a flexible way to group data output to the screen. This article demonstrates the usage of the control to data bind information in ASP.NET. Brian clearly examines each step in detail with the help of database structure diagram, relevant explanation, and plenty of source code.
http://www.visli.com/
The Accordion control is a flexible way to group data output to the screen. This article demonstrates the usage of the control to data bind information in ASP.NET. Brian clearly examines each step in detail with the help of database structure diagram, relevant explanation, and plenty of source code.
http://www.visli.com/
Sunday, June 29, 2008
Creating Custom Data Field Controls
Creating Custom Data Field Controls - Part 1: ASP Alliance
Abstract This article discusses the basics of creating custom data control fields that can be used in the ever popular GridView and DetailsView controls. It will also show you a base class that Brian uses to simplify this process altogether.
http://www.visli.com/
Abstract This article discusses the basics of creating custom data control fields that can be used in the ever popular GridView and DetailsView controls. It will also show you a base class that Brian uses to simplify this process altogether.
http://www.visli.com/
Friday, June 27, 2008
Linux.com :: Running MySQL queries on multiple servers
Linux.com :: Running MySQL queries on multiple servers: "Running MySQL queries on multiple servers"
http://www.visli.com/
http://www.visli.com/
Silverlight SDK : Create an Animation in Code (e.g. C#, VB .NET, etc)
Silverlight SDK : Create an Animation in Code (e.g. C#, VB .NET, etc): "Create an Animation in Code (e.g. C#, VB .NET, etc)"
http://www.visli.com/
http://www.visli.com/
Thursday, June 26, 2008
How to Upload Sales Data with line Attachment JD Edwards
This is my process to upload the Data in F4211/F4201 with Attachment completeled tested:
1> inset data from excel to JD Edwards table :
--upload to temp order file
delete from proddta.f554084a
insert testdta.f554084a
SELECT [detail key] UKID,[client id] AN8,[line #]*1000 lineno1,
(datepart(yy,[order date]) - 1900) * 1000+ cast(datepart(dy,[order date])as int) orderdate,
'00870' company,[client id] AN8,[client id] Shan,
product,[Branch plant] bp,quantity,[Dollar Amount],
(datepart(yy,[order date]) - 1900) * 1000+ cast(datepart(dy,[order date])as int) Addj,
'USD' Curr,'' edsp,[customer po] ARGS, 'SQL' cUser ,'SQL-SERVER' Pid,
(datepart(yy,getdate()) - 1900) * 1000+ cast(datepart(dy,getdate())as int) cdate,'120000.0'ctime
FROM XLTEST_SP...upload1$ order by [client id]
2> Run R554784 to load data in F47012/F47011
3>Insert Data in Comment detail file F4715
insert testdta.F4715
select 8 szedty,1 szedsq,szkcoo,szedoc,szedct,szedln,'' szedsp,szedbt,'F47012' ZDFILE,szkcoo,szdoco,szdcto,szlnid,''PNTC,
f4*100 Lins,comment,'SQL','SQL',
'SQL','SQL','108177','120000'
from XLTEST_SP...upload2$
left outer join testdta.f47012 on szdmct=ukid
--where szdoco=410123.0 and szlnid=1000 and f4<10
order by szdoco,szlnid,f4
4>Run R47011 to load data in F4211/F4201 and also comment in item line level.
www.visli.com
1> inset data from excel to JD Edwards table :
--upload to temp order file
delete from proddta.f554084a
insert testdta.f554084a
SELECT [detail key] UKID,[client id] AN8,[line #]*1000 lineno1,
(datepart(yy,[order date]) - 1900) * 1000+ cast(datepart(dy,[order date])as int) orderdate,
'00870' company,[client id] AN8,[client id] Shan,
product,[Branch plant] bp,quantity,[Dollar Amount],
(datepart(yy,[order date]) - 1900) * 1000+ cast(datepart(dy,[order date])as int) Addj,
'USD' Curr,'' edsp,[customer po] ARGS, 'SQL' cUser ,'SQL-SERVER' Pid,
(datepart(yy,getdate()) - 1900) * 1000+ cast(datepart(dy,getdate())as int) cdate,'120000.0'ctime
FROM XLTEST_SP...upload1$ order by [client id]
2> Run R554784 to load data in F47012/F47011
3>Insert Data in Comment detail file F4715
insert testdta.F4715
select 8 szedty,1 szedsq,szkcoo,szedoc,szedct,szedln,'' szedsp,szedbt,'F47012' ZDFILE,szkcoo,szdoco,szdcto,szlnid,''PNTC,
f4*100 Lins,comment,'SQL','SQL',
'SQL','SQL','108177','120000'
from XLTEST_SP...upload2$
left outer join testdta.f47012 on szdmct=ukid
--where szdoco=410123.0 and szlnid=1000 and f4<10
order by szdoco,szlnid,f4
4>Run R47011 to load data in F4211/F4201 and also comment in item line level.
www.visli.com
Wednesday, June 25, 2008
Link Excel with SQL Server 2000
How to use Excel with SQL Server linked servers and distributed queries: "How to use Excel with SQL Server linked servers and distributed queries"
DECLARE @RC int
DECLARE @server nvarchar(128)
DECLARE @srvproduct nvarchar(128)
DECLARE @provider nvarchar(128)
DECLARE @datasrc nvarchar(4000)
DECLARE @location nvarchar(4000)
DECLARE @provstr nvarchar(4000)
DECLARE @catalog nvarchar(128)
-- Set parameter values
SET @server = 'XLTEST_SP'
SET @srvproduct = 'Excel'
SET @provider = 'Microsoft.Jet.OLEDB.4.0'
SET @datasrc = 'c:\book1.xls'
SET @provstr = 'Excel 8.0'
EXEC @RC = [master].[dbo].[sp_addlinkedserver] @server, @srvproduct, @provider, @datasrc, @location, @provstr, @catalog
SELECT * FROM XLTEST_SP...Sheet1$
DECLARE @RC int
DECLARE @server nvarchar(128)
DECLARE @srvproduct nvarchar(128)
DECLARE @provider nvarchar(128)
DECLARE @datasrc nvarchar(4000)
DECLARE @location nvarchar(4000)
DECLARE @provstr nvarchar(4000)
DECLARE @catalog nvarchar(128)
-- Set parameter values
SET @server = 'XLTEST_SP'
SET @srvproduct = 'Excel'
SET @provider = 'Microsoft.Jet.OLEDB.4.0'
SET @datasrc = 'c:\book1.xls'
SET @provstr = 'Excel 8.0'
EXEC @RC = [master].[dbo].[sp_addlinkedserver] @server, @srvproduct, @provider, @datasrc, @location, @provstr, @catalog
SELECT * FROM XLTEST_SP...Sheet1$
Tuesday, June 24, 2008
xmldatasource RSS feed showing Limited no of items
xmldatasource RSS feed showing first 2 news only - ASP.NET Forums: "xmldatasource RSS feed showing first 2 news only"
XPath="rss/channel/item[position()<3]"
www.visli.com
XPath="rss/channel/item[position()<3]"
www.visli.com
Monday, June 23, 2008
LINQ to SQL N-Tier with Web Services
LINQ to SQL N-Tier with Web Services: "LINQ to SQL N-Tier with Web Services"
LINQ: .NET Language Integrated Query
LINQ: .NET Language Integrated Query: "LINQ to XML: XML Integration"
NET Language-Integrated Query for XML (LINQ to XML) allows XML data to be queried by using the standard query operators as well as tree-specific operators that provide XPath-like navigation through descendants, ancestors, and siblings. It provides an efficient in-memory representation for XML that integrates with the existing System.Xml reader/writer infrastructure and is easier to use than W3C DOM. There are three types that do most of the work of integrating XML with queries: XName, XElement and XAttribute.
XName provides an easy-to-use way to deal with the namespace-qualified identifiers (QNames) used as both element and attribute names. XName handles the efficient atomization of identifiers transparently and allows either symbols or plain strings to be used wherever a QName is needed
http://www.visli.com/
NET Language-Integrated Query for XML (LINQ to XML) allows XML data to be queried by using the standard query operators as well as tree-specific operators that provide XPath-like navigation through descendants, ancestors, and siblings. It provides an efficient in-memory representation for XML that integrates with the existing System.Xml reader/writer infrastructure and is easier to use than W3C DOM. There are three types that do most of the work of integrating XML with queries: XName, XElement and XAttribute.
XName provides an easy-to-use way to deal with the namespace-qualified identifiers (QNames) used as both element and attribute names. XName handles the efficient atomization of identifiers transparently and allows either symbols or plain strings to be used wherever a QName is needed
http://www.visli.com/
LINQ: .NET Language Integrated Query
LINQ: .NET Language Integrated Query: "LINQ to XML: XML Integration"
NET Language-Integrated Query for XML (LINQ to XML) allows XML data to be queried by using the standard query operators as well as tree-specific operators that provide XPath-like navigation through descendants, ancestors, and siblings. It provides an efficient in-memory representation for XML that integrates with the existing System.Xml reader/writer infrastructure and is easier to use than W3C DOM. There are three types that do most of the work of integrating XML with queries: XName, XElement and XAttribute.
XName provides an easy-to-use way to deal with the namespace-qualified identifiers (QNames) used as both element and attribute names. XName handles the efficient atomization of identifiers transparently and allows either symbols or plain strings to be used wherever a QName is needed
http://www.visli.com/
NET Language-Integrated Query for XML (LINQ to XML) allows XML data to be queried by using the standard query operators as well as tree-specific operators that provide XPath-like navigation through descendants, ancestors, and siblings. It provides an efficient in-memory representation for XML that integrates with the existing System.Xml reader/writer infrastructure and is easier to use than W3C DOM. There are three types that do most of the work of integrating XML with queries: XName, XElement and XAttribute.
XName provides an easy-to-use way to deal with the namespace-qualified identifiers (QNames) used as both element and attribute names. XName handles the efficient atomization of identifiers transparently and allows either symbols or plain strings to be used wherever a QName is needed
http://www.visli.com/
LINQ: .NET Language Integrated Query
LINQ: .NET Language Integrated Query: "LINQ to XML: XML Integration"
NET Language-Integrated Query for XML (LINQ to XML) allows XML data to be queried by using the standard query operators as well as tree-specific operators that provide XPath-like navigation through descendants, ancestors, and siblings. It provides an efficient in-memory representation for XML that integrates with the existing System.Xml reader/writer infrastructure and is easier to use than W3C DOM. There are three types that do most of the work of integrating XML with queries: XName, XElement and XAttribute.
XName provides an easy-to-use way to deal with the namespace-qualified identifiers (QNames) used as both element and attribute names. XName handles the efficient atomization of identifiers transparently and allows either symbols or plain strings to be used wherever a QName is needed
http://www.visli.com/
NET Language-Integrated Query for XML (LINQ to XML) allows XML data to be queried by using the standard query operators as well as tree-specific operators that provide XPath-like navigation through descendants, ancestors, and siblings. It provides an efficient in-memory representation for XML that integrates with the existing System.Xml reader/writer infrastructure and is easier to use than W3C DOM. There are three types that do most of the work of integrating XML with queries: XName, XElement and XAttribute.
XName provides an easy-to-use way to deal with the namespace-qualified identifiers (QNames) used as both element and attribute names. XName handles the efficient atomization of identifiers transparently and allows either symbols or plain strings to be used wherever a QName is needed
http://www.visli.com/
Saturday, June 21, 2008
Friday, June 20, 2008
.NET - Error Logging using ASP.NET 2.0
.NET - Error Logging using ASP.NET 2.0: "Error Logging using ASP.NET 2.0"
JD Edwards Bank Currency Code Invalid Voucher Match
This is caused by a mismatch between the Default Currency Code value on the A/P (supplier master) portion of the address book record for your supplier vs. the currency code for the Bank account.
Execute Sql Server 2005 Integration Services package from C#
CodeProject: Execute Sql Server 2005 Integration Services package from C#. Free source code and programming help: "Execute Sql Server 2005 Integration Services package from C#"
www.visli.com
www.visli.com
How to a lock table SQL-Server
LOCK TABLE statement
LOCK TABLE table-Name IN { SHARE EXCLUSIVE } MODE
Get a Web Page's Title from a URL (C#)
Noah Coad : Get a Web Page's Title from a URL (C#): "Get a Web Page's Title from a URL (C#)"
www.visli.com
www.visli.com
Thursday, June 19, 2008
random no in a range c# asp.net
random Number generation in a range c# asp.net
System.Random RandNumb = new System.Random();
int MyRandomNumber = RandNumb.Next(1, 11);
Response.Write(MyRandomNumber);
JD Edwards Upload Sales Data By using EDI with Media Object
The EDI Inbound Purchase Order (850/ORDER) (R47011) pulls information from the 47 tables and populates the Sales Order Header (F4201), Sales Order Detail (F4211), Item Location (F41021), SO Detail Ledger (F42199), Media Object (F00165) and Order Address Information (F4006) files.
EDI Inbound Purchase Order (850/ORDER) - Inbound (P47010) is the Status Inquiry/Revisions program for this process. Records can be added, revised and reviewed here before running the EDI Inbound Purchase Order (850/ORDER) (R47011) UBE.
Media Objects need to be attached at the Header and/or Detail level using F4714/F4715 (Again media objects will be stored in the F00165 table)
Steps:
Using status inquiry P47010, inquire on specific EDOC
1) Exit to Header OR Detail
2) Exit a second time to add text/objects
3) Save
4) Run R47011 to create new sales order
Inquire on new order within P4210 to confirm object attachment/creation
JD Edwards - Account Balance Report for particular Month year
select gbco,cast(GBSBL as int) JDE,rtrim(wwgnnm)+' '+ltrim(wwsrnm) OwnerName,sum(gbapyc+GBAN01)/100 "07_01",sum(gbapyc+GBAN01+GBAN02)/100 "07_02", sum(gbapyc+GBAN01+GBAN02+GBAN03)/100 "07_03" , sum(gbapyc+GBAN01+GBAN02+GBAN03+GBAN04)/100 "07_04" , sum(gbapyc+GBAN01+GBAN02+GBAN03+GBAN04+gban05)/100 "07_05" , sum(gbapyc+GBAN01+GBAN02+GBAN03+GBAN04+gban05+gban06)/100 "07_06" , sum(gbapyc+GBAN01+GBAN02+GBAN03+GBAN04+gban05+gban06+gban07)/100 "07_07" , sum(gbapyc+GBAN01+GBAN02+GBAN03+GBAN04+gban05+gban06+gban07+gban08)/100 "07_08" , sum(gbapyc+GBAN01+GBAN02+GBAN03+GBAN04+gban05+gban06+gban07+gban08+gban09)/100 "07_09" , sum(gbapyc+GBAN01+GBAN02+GBAN03+GBAN04+gban05+gban06+gban07+gban08+gban09+gban10)/100 "07_10" , sum(gbapyc+GBAN01+GBAN02+GBAN03+GBAN04+gban05+gban06+gban07+gban08+gban09+gban10+gban11)/100 "07_11" , sum(gbapyc+GBAN01+GBAN02+GBAN03+GBAN04+gban05+gban06+gban07+gban08+gban09+gban10+gban11+gban12)/100 "07_12", sum(gbapyc+GBAN01+GBAN02+GBAN03+GBAN04+gban05+gban06+gban07+gban08+gban09+gban10+gban11+gban12+gban13)/100 "07_13" from proddta.f0902 left outer join proddta.f0111 on cast(GBSBL as int)=wwan8 where gbfy=7 and GBAID in (33333,44444,5555,555555) and GBLT='AA' and gbsblt='A'group by cast(GBSBL as int),gbco,wwgnnm,wwsrnm,gbfy, GBAIDorder by gbco,cast(GBSBL as int)
Wednesday, June 18, 2008
Disable Linkbutton Before Postback?
Disable Linkbutton Before Postback?: "ASP Net - Disable Linkbutton Before Postback?"
http://www.visli.com/
http://www.visli.com/
Disable an asp.net LinkButton (or HyperLink) without graying it out - Peter's Gekko
Disable an asp.net LinkButton (or HyperLink) without graying it out - Peter's Gekko
lnkHyperLink.Visible = False
lbtnLinkButton.Visible = False
lbtnVisible.Text = "Make Visible!"
www.visli.com
lnkHyperLink.Visible = False
lbtnLinkButton.Visible = False
lbtnVisible.Text = "Make Visible!"
www.visli.com
menu control is not working on apple safari browser asp.net C#
safari menu control - ASP.NET Forums: "safari menu control"
solution
if (Request.UserAgent.IndexOf("AppleWebKit") > 0)
{
Request.Browser.Adapters.Clear();
}
http://www.visli.com/
solution
if (Request.UserAgent.IndexOf("AppleWebKit") > 0)
{
Request.Browser.Adapters.Clear();
}
http://www.visli.com/
Using LinqDataSource with ASP.NET data controls [Part II].
CodeProject: Using LinqDataSource with ASP.NET data controls [Part II]. Free source code and programming help: "Using LinqDataSource with ASP.NET data controls"
www.visli.com
www.visli.com
Jd Edwards Important Sales Tables
1. F4211 - SALES ORDER DETAIL
2.F4201 - SALES HEADER
3. F42119 - SALES ORDER HISTORY
4. F42199 - SALES LEDGER FILE
WWW.VISLI.COM
2.F4201 - SALES HEADER
3. F42119 - SALES ORDER HISTORY
4. F42199 - SALES LEDGER FILE
WWW.VISLI.COM
Tuesday, June 17, 2008
Monday, June 16, 2008
Amazon Webservice Link by node ID
Hi
I created an application to disply data based on your tag id and subscripton ID. please visit
http://svdeals.com/amzbiz.aspx. Any question contact @ webmaster@visli.com
must verify your link from amazon webservice associate account. I am not responsible for any loss.
How To Read XML Data into a DataSet by Using Visual C# .NET
How To Read XML Data into a DataSet by Using Visual C# .NET: "How To Read XML Data into a DataSet by Using Visual C# .NET"
http://www.visli.com/
http://www.visli.com/
Temporary Tables With MySQL
Temporary Tables With MySQL: "Temporary Tables With MySQL"
CREATE TEMPORARY TABLE TempTable ( ID int, Name char(100) ) TYPE=HEAP;
INSERT INTO TempTable VALUES( 1, "Foo bar" );
SELECT * FROM TempTable; DROP TABLE TempTable;
www.visli.com
CREATE TEMPORARY TABLE TempTable ( ID int, Name char(100) ) TYPE=HEAP;
INSERT INTO TempTable VALUES( 1, "Foo bar" );
SELECT * FROM TempTable; DROP TABLE TempTable;
www.visli.com
How to send raw data to a printer by using Visual Basic .NET
How to send raw data to a printer by using Visual Basic .NET: "How to send raw data to a printer by using Visual Basic .NET"
To send raw data to a printer from the Microsoft .NET Framework, your program must work with Win32 spooler functions. Through the .NET Framework, you can print by using PrintDocument, PrintController, and associated classes. However, with the .NET Framework, you cannot send preformatted printer-ready data to a printer. You may have to send raw data to a printer to do the following:
•
Send escape sequences.
•
Download, and then use soft fonts.
•
Spool preprinted files.To send these types and other types of raw data to a printer, your code must work with Win32 Spooler Application Programmer Interfaces (APIs). The following code shows how to read the contents of a preformatted file into memory, and then send those bytes to the printer by using WritePrinter.
http://support.microsoft.com/?scid=kb;EN-US;322090
http://www.visli.com/
To send raw data to a printer from the Microsoft .NET Framework, your program must work with Win32 spooler functions. Through the .NET Framework, you can print by using PrintDocument, PrintController, and associated classes. However, with the .NET Framework, you cannot send preformatted printer-ready data to a printer. You may have to send raw data to a printer to do the following:
•
Send escape sequences.
•
Download, and then use soft fonts.
•
Spool preprinted files.To send these types and other types of raw data to a printer, your code must work with Win32 Spooler Application Programmer Interfaces (APIs). The following code shows how to read the contents of a preformatted file into memory, and then send those bytes to the printer by using WritePrinter.
http://support.microsoft.com/?scid=kb;EN-US;322090
http://www.visli.com/
Page Refresh/Reload - JavaScripts
Page Refresh/Reload - JavaScripts - Grizzly WebMaster: "Page Refresh/Reload"
Refresh JavaScript Example
www.visli.com
www.visli.com
Sunday, June 15, 2008
Execute/run/submit a JD Edwards(XE/E810/E811/E12) UBE, By Batch File or Command line
RUNUBE USERID PASSWORD PD810 ADMIN R42565 ZJDE0001 QBATCH "BATCH" "Hold" "SAVE" PRINTER_NAME
www.visli.com
www.visli.com
Saturday, June 14, 2008
DevCity.NET :: Working with MS Access Stored Procedures in VB.NET. Part 1
DevCity.NET :: Working with MS Access Stored Procedures in VB.NET. Part 1: "Working with MS Access Stored Procedures in VB.NET. Part 1"
The LINQ Project
The LINQ Project: "The LINQ Project"
The LINQ Project is a codename for a set of extensions to the .NET Framework that encompass language-integrated query, set, and transform operations. It extends C# and Visual Basic with native language syntax for queries and provides class libraries to take advantage of these capabilities.
www.visli.com
The LINQ Project is a codename for a set of extensions to the .NET Framework that encompass language-integrated query, set, and transform operations. It extends C# and Visual Basic with native language syntax for queries and provides class libraries to take advantage of these capabilities.
www.visli.com
Matt Berseth: Freezing GridView Column Headers using Only CSS
Matt Berseth: Freezing GridView Column Headers using Only CSS: "Freezing GridView Column Headers using Only CSS"
Next, I created the container css style class as Mitch suggests .../* So the overflow scrolls */
.container {overflow:auto;}
/* Keep the header cells positioned as we scroll */
.container table th {position:relative;}
/* For alignment of the scroll bar */
.container table tbody {overflow-x:hidden;}
.csharpcode, .csharpcode pre
{
font-size: small;
color: black;
font-family: consolas, "Courier New", courier, monospace;
background-color: #ffffff;
/*white-space: pre;*/
}
.csharpcode pre { margin: 0em; }
.csharpcode .rem { color: #008000; }
.csharpcode .kwrd { color: #0000ff; }
.csharpcode .str { color: #006080; }
.csharpcode .op { color: #0000c0; }
.csharpcode .preproc { color: #cc6633; }
.csharpcode .asp { background-color: #ffff00; }
.csharpcode .html { color: #800000; }
.csharpcode .attr { color: #ff0000; }
.csharpcode .alt
{
background-color: #f4f4f4;
width: 100%;
margin: 0em;
}
.csharpcode .lnum { color: #606060; }
www.visli.com
Next, I created the container css style class as Mitch suggests .../* So the overflow scrolls */
.container {overflow:auto;}
/* Keep the header cells positioned as we scroll */
.container table th {position:relative;}
/* For alignment of the scroll bar */
.container table tbody {overflow-x:hidden;}
.csharpcode, .csharpcode pre
{
font-size: small;
color: black;
font-family: consolas, "Courier New", courier, monospace;
background-color: #ffffff;
/*white-space: pre;*/
}
.csharpcode pre { margin: 0em; }
.csharpcode .rem { color: #008000; }
.csharpcode .kwrd { color: #0000ff; }
.csharpcode .str { color: #006080; }
.csharpcode .op { color: #0000c0; }
.csharpcode .preproc { color: #cc6633; }
.csharpcode .asp { background-color: #ffff00; }
.csharpcode .html { color: #800000; }
.csharpcode .attr { color: #ff0000; }
.csharpcode .alt
{
background-color: #f4f4f4;
width: 100%;
margin: 0em;
}
.csharpcode .lnum { color: #606060; }
www.visli.com
Thursday, June 12, 2008
Fix RB Batch in JD Edwards - f03b13 f03b14
select ryaap,rypost,RYPSTQ,* from proddta.f03b13 where rypyid=199829.0
select rzpost,rzpaap,* from proddta.f03b14 where rzicu=406690
Change Open Amount ryaap , chang rypost=P, and RYPSTQ= P in F03b13
and change rzpost="P" in F03b14 file. and run report program again.
http://www.visli.com/
select rzpost,rzpaap,* from proddta.f03b14 where rzicu=406690
Change Open Amount ryaap , chang rypost=P, and RYPSTQ= P in F03b13
and change rzpost="P" in F03b14 file. and run report program again.
http://www.visli.com/
JavaScript with ASP .NET server controls
JavaScript with ASP .NET server controls: "JavaScript with ASP .NET server controls"
JD Edwards Auto Invoice Printing
JD Edwards Auto Invoice Print without doing data selection , call invoice print program from Form.If you have any question contact me @ webmaster@visli.com
http://visli.com/
Fixing Double Sales update(R42800) in JD Edwards
Fixing Double Sales update(R42800) in JD Edwards
Identify the IB batch and go to customer ledger inquiry (P03b2002) and pull that batch and delete all the invoices. This will fix GL/AR side.
www.visli.com
Identify the IB batch and go to customer ledger inquiry (P03b2002) and pull that batch and delete all the invoices. This will fix GL/AR side.
www.visli.com
Wednesday, June 11, 2008
Insert Data in C# asp.net by using stored proc.
Inserting Data in C# asp.net by using stored proc sql-server .
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
SqlConnection myConnection = new SqlConnection(ConnectionString);
string strSQL;
strSQL = "xxxx_Ins_yyyy";
SqlCommand cmd = new SqlCommand(strSQL, myConnection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@fname", fname.Text);
cmd.Parameters.AddWithValue("@lname", lname.Text);
cmd.Parameters.AddWithValue("@Address", Address.Text);
cmd.Parameters.AddWithValue("@zip", zip.Text);
cmd.Parameters.AddWithValue("@dphone", dphone.Text);
cmd.Parameters.AddWithValue("@ephone", fname.Text);
cmd.Parameters.AddWithValue("@emailid", fname.Text);
cmd.Parameters.AddWithValue("@UpDated", System.DateTime.Now);
myConnection.Open();
cmd.ExecuteNonQuery();
myConnection.Close();
}
private string ConnectionString
{
get
{
string connectionString = ConfigurationManager.ConnectionStrings"ConnectionString"].ConnectionString;
return connectionString;
}
}
www.visli.com
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
SqlConnection myConnection = new SqlConnection(ConnectionString);
string strSQL;
strSQL = "xxxx_Ins_yyyy";
SqlCommand cmd = new SqlCommand(strSQL, myConnection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@fname", fname.Text);
cmd.Parameters.AddWithValue("@lname", lname.Text);
cmd.Parameters.AddWithValue("@Address", Address.Text);
cmd.Parameters.AddWithValue("@zip", zip.Text);
cmd.Parameters.AddWithValue("@dphone", dphone.Text);
cmd.Parameters.AddWithValue("@ephone", fname.Text);
cmd.Parameters.AddWithValue("@emailid", fname.Text);
cmd.Parameters.AddWithValue("@UpDated", System.DateTime.Now);
myConnection.Open();
cmd.ExecuteNonQuery();
myConnection.Close();
}
private string ConnectionString
{
get
{
string connectionString = ConfigurationManager.ConnectionStrings"ConnectionString"].ConnectionString;
return connectionString;
}
}
www.visli.com
Using JSON with ASP.NET 3.5
Using JSON with ASP.NET 3.5: "Using JSON with ASP.NET 3.5"
Almost any application that you write will involve exchanging data from a client application to the server. This process involves selecting a data format and exchange protocol that will be required to enable this communication. When it comes to selecting these data formats, you have a variety of open standards that you can consider and the ideal choice depends on the requirements of the application.
For example, if you use SOAP based Web services, you format the data in an XML payload that is wrapped within a SOAP envelope. Although XML works well for many application scenarios, its inherent chatty nature makes it less than ideal for certain scenarios. For example, in an AJAX style Web application, you make asynchronous lightweight out-of-band calls to the server side to get the required data without even refreshing the browser. In this scenario, you need a lightweight, open, text-based platform independent data exchange format for transferring data back and forth between the client and server. That’s exactly what the JSON (Java Script Object Notation) standard provides.
This article will discuss the use of JSON in ASP.NET Web applications. In addition, you will also see how to use JSON as a data format for exchanging data from a WCF service to an AJAX based ASP.NET Web application.
www.visli.com
Almost any application that you write will involve exchanging data from a client application to the server. This process involves selecting a data format and exchange protocol that will be required to enable this communication. When it comes to selecting these data formats, you have a variety of open standards that you can consider and the ideal choice depends on the requirements of the application.
For example, if you use SOAP based Web services, you format the data in an XML payload that is wrapped within a SOAP envelope. Although XML works well for many application scenarios, its inherent chatty nature makes it less than ideal for certain scenarios. For example, in an AJAX style Web application, you make asynchronous lightweight out-of-band calls to the server side to get the required data without even refreshing the browser. In this scenario, you need a lightweight, open, text-based platform independent data exchange format for transferring data back and forth between the client and server. That’s exactly what the JSON (Java Script Object Notation) standard provides.
This article will discuss the use of JSON in ASP.NET Web applications. In addition, you will also see how to use JSON as a data format for exchanging data from a WCF service to an AJAX based ASP.NET Web application.
www.visli.com
Tuesday, June 10, 2008
ASP.NET 2.0: XmlDataSource - Default Caching Feature
This is because, by default, the EnableCaching propery is set to "true". You can also find that the CacheDuration is set to "Infinite". This forces the Data in the XmlDataSource to be cached and hence the change in the underlying Data, wont get reflected.
The resolution is to set the EnableCaching property to false or specify a CacheKeyDependency, or set the CacheDuration to a lesser time.
To referesh XmlDataSource as current data put EnableCaching="false"
http://www.visli.com/
The resolution is to set the EnableCaching property to false or specify a CacheKeyDependency, or set the CacheDuration to a lesser time.
To referesh XmlDataSource as current data put EnableCaching="false"
http://www.visli.com/
How do I copy or move a MySQL database?
How do I copy or move a MySQL database?: "How do I copy or move a MySQL database?"
You cannot reliably move a MySQL database by moving the binary files in the MySQL directory. Use the procedure that follows.
http://support.adobe.com/devsup/devsup.nsf/docs/52353.htm
You cannot reliably move a MySQL database by moving the binary files in the MySQL directory. Use the procedure that follows.
http://support.adobe.com/devsup/devsup.nsf/docs/52353.htm
Another DataGridView Printer
CodeProject: Another DataGridView Printer. Free source code and programming help: "Another DataGridView Printer"
Dynamically add and remove user controls
CodeProject: Dynamically add and remove user controls. Free source code and programming help: "Dynamically add and remove user controls"
Creating Serverside Clock control Using Asp.net Ajax and C#
CodeProject: Creating Serverside Clock control Using Asp.net Ajax and C#. Free source code and programming help: "Creating Serverside Clock control Using Asp.net Ajax and C#"
Standard CustomValidator Textbox
CodeProject: Standard CustomValidator Textbox. Free source code and programming help: "Standard CustomValidator Textbox"
The Custom Control eliminates the use of adding validators for each and every textbox added. Just by setting a couple of properties we can make our textbox validate credit card numbers, phone numbers or any other Custom expression. It provides some other built in functionalities. VB, Windows, .NET 3.0, Dev, Intermediate.
www.svdeals.com
The Custom Control eliminates the use of adding validators for each and every textbox added. Just by setting a couple of properties we can make our textbox validate credit card numbers, phone numbers or any other Custom expression. It provides some other built in functionalities. VB, Windows, .NET 3.0, Dev, Intermediate.
www.svdeals.com
Monday, June 9, 2008
Youtube API C# Sample in asp.net 2.0
youtube API for C#
sample Code in PDF and Live Example For C# asp.net 2.0
http://www.svdeals.com/youtube.aspx?searchtxt=nfl
sample Code in PDF and Live Example For C# asp.net 2.0
http://www.svdeals.com/youtube.aspx?searchtxt=nfl
Dynamic Label or control in asp.net C# - ASP.NET Forums
Dynamic Label or control in asp.net C# - ASP.NET Forums: "Dynamic Label or control in asp.net C#"
for (int i = 0; i < 10; i++)
{
Label label = new Label();
label.Text = i.ToString();
PlaceHolder1.Controls.Add(label);
}
www.visli.com
for (int i = 0; i < 10; i++)
{
Label label = new Label();
label.Text = i.ToString();
PlaceHolder1.Controls.Add(label);
}
www.visli.com
Sunday, June 8, 2008
Microsoft SQL Server 2008: Reporting
Microsoft SQL Server 2008: Reporting: "Reporting Services"
Top New Features
Author reports with any structure, using the unique data format of Tablix.
Benefit from enhanced performance and scalability to reach any number of users.
Render reports to Microsoft Office Word format.
Integrate Reporting Services with Microsoft Office SharePoint Server 2007 for central delivery and management of business insight.
Enable users to quickly gain insight into complex sets of data by displaying data graphically with enhanced visualization capabilities.
www.visli.com
Top New Features
Author reports with any structure, using the unique data format of Tablix.
Benefit from enhanced performance and scalability to reach any number of users.
Render reports to Microsoft Office Word format.
Integrate Reporting Services with Microsoft Office SharePoint Server 2007 for central delivery and management of business insight.
Enable users to quickly gain insight into complex sets of data by displaying data graphically with enhanced visualization capabilities.
www.visli.com
Unable to create temp file in path 'C:\Windows\TEMP\': sp1 vista asp.net
After installing vista sp1 I started getting this error.I went to 'C:\Windows\TEMP\ and gave user full control permission and error went away.
Hot Programming.cheer
Thursday, June 5, 2008
LINQ Language Integrated Query - Wikipedia, the free encyclopedia
Language Integrated Query - Wikipedia, the free encyclopedia: "Language Integrated Query"
Language Integrated Query (LINQ, pronounced "link") is a Microsoft .NET Framework component that adds native data querying capabilities to .NET languages using a syntax reminiscent of SQL. Many of the concepts that LINQ has introduced were originally tested in Microsoft's Cω research project. LINQ was released as a part of .NET Framework 3.5 on November 19, 2007.
LINQ defines a set of query operators that can be used to query, project and filter data in arrays, enumerable classes, XML, relational database, and third party data sources. While it allows any data source to be queried, it requires that the data be encapsulated as objects. So, if the data source does not natively store data as objects, the data must be mapped to the object domain. Queries written using the query operators are executed either by the LINQ query processing engine or, via an extension mechanism, handed over to LINQ providers which either implement a separate query processing engine or translate to a different format to be executed on a separate data store (such as on a database server as SQL queries). The results of a query are returned as a collection of in-memory objects that can be enumerated.
www.svdeals.com
Language Integrated Query (LINQ, pronounced "link") is a Microsoft .NET Framework component that adds native data querying capabilities to .NET languages using a syntax reminiscent of SQL. Many of the concepts that LINQ has introduced were originally tested in Microsoft's Cω research project. LINQ was released as a part of .NET Framework 3.5 on November 19, 2007.
LINQ defines a set of query operators that can be used to query, project and filter data in arrays, enumerable classes, XML, relational database, and third party data sources. While it allows any data source to be queried, it requires that the data be encapsulated as objects. So, if the data source does not natively store data as objects, the data must be mapped to the object domain. Queries written using the query operators are executed either by the LINQ query processing engine or, via an extension mechanism, handed over to LINQ providers which either implement a separate query processing engine or translate to a different format to be executed on a separate data store (such as on a database server as SQL queries). The results of a query are returned as a collection of in-memory objects that can be enumerated.
www.svdeals.com
AJAX Control Toolkit Tutorials : The Official Microsoft ASP.NET Site
AJAX Control Toolkit Tutorials : The Official Microsoft ASP.NET Site: "AJAX Control Toolkit Tutorials"
Wednesday, June 4, 2008
ASP.net 2.0 DropdownList bound to SQLDataSource and setting SelectedIndex
ASP.net 2.0 DropdownList bound to SQLDataSource and setting SelectedIndex: "ASP Net - ASP.net 2.0 DropdownList bound to SQLDataSource and setting SelectedIndex"
Tuesday, June 3, 2008
Sql-server to Mysql migration C# Asp.net Code Issue
1. Download connector .
2 add in your code using MySql.Data.MySqlClient;
3. Change connection string to ConnectionString="<%$ ConnectionStrings:ConnectionString %>"ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>"
4.in SqlDataSource change @ with ? in sql command SelectCommand="SELECT * FROM vnflsch WHERE (week = ?week)
5. replace all "[" and "]" with blanks.
www.visli.com
2 add in your code using MySql.Data.MySqlClient;
3. Change connection string to ConnectionString="<%$ ConnectionStrings:ConnectionString %>"ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>"
4.in SqlDataSource change @ with ? in sql command SelectCommand="SELECT * FROM vnflsch WHERE (week = ?week)
5. replace all "[" and "]" with blanks.
www.visli.com
Mysql SqlDataSource and Parameter to Query
change the @ to ?
like loginm = ?loginm
Mysql SqlDataSource and Parameter to Query - ASP.NET Forums: "Mysql SqlDataSource and Parameter to Query"
www.svdeals.com
like loginm = ?loginm
Mysql SqlDataSource and Parameter to Query - ASP.NET Forums: "Mysql SqlDataSource and Parameter to Query"
www.svdeals.com
Mysql SqlDataSource and Parameter to Query
change the @ to ?
like loginm = ?loginm
Mysql SqlDataSource and Parameter to Query - ASP.NET Forums: "Mysql SqlDataSource and Parameter to Query"
www.svdeals.com
like loginm = ?loginm
Mysql SqlDataSource and Parameter to Query - ASP.NET Forums: "Mysql SqlDataSource and Parameter to Query"
www.svdeals.com
Session & Control variable in select Asp.net 2.0 SqlDataSource
asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>"
SelectCommand="SELECT DISTINCT nicknm,uweek FROM uNflsel WHERE ((loginm = @loginm) AND (uWeek = @uWeek))"
SelectParameters
asp:SessionParameter Name="loginm" SessionField="loginm" Type="String"
asp:ControlParameter ControlID="DropDownList1" Name="uWeek" PropertyName="SelectedValue" Type="String"
SelectParameters
asp:SqlDataSource
www.visli.com
Incorrect Link after page Load In Amazon link checker
As long as the link on your site is correct, you'll get credit for any sales. It doesn't matter what's displayed in the address bar after you get to Amazon.com. Amazon stores your Associates Tag and creates a new session for the visitor then redirects to a URL that includes the session ID.
Amazon Web Services Developer Connection : Incorrect Link after page Load In link ...
www.visli.com
Amazon Web Services Developer Connection : Incorrect Link after page Load In link ...
www.visli.com
Using Syndication Classes to Generate RSS Feeds
DotNetBips.com :: Blossom your .NET skills: "Using Syndication Classes to Generate RSS Feeds"
http://www.dotnetbips.com/articles/4826711c-3f25-48ef-94d0-5c40b628c203.aspx
http://www.visli.com/
http://www.dotnetbips.com/articles/4826711c-3f25-48ef-94d0-5c40b628c203.aspx
http://www.visli.com/
Monday, June 2, 2008
Amazon Associates / Affilate - Link Checker
Link Checker lets you test your links to make sure they are correctly tagging to your Associate ID or one of your Tracking IDs. The only way Amazon can track a referral is through your Associate ID or Tracking ID so using the Link Checker tool is one way to help ensure that you'll be credited for all of your referral fees. To test a link, follow the two step process: 1. Enter your link URL into the field and click the 'Load Link' button. 2. After you see the correct page load, click the 'Check Link' button below the loaded page to check that the link tags to your Associates ID or one of your Tracking IDs.
http://affiliate-program.amazon.com/gp/associates/network/tools/link-checker/main.html/
http://www.visli.com/
http://affiliate-program.amazon.com/gp/associates/network/tools/link-checker/main.html/
http://www.visli.com/
Generating Types from external metadata.
CodeProject: Generating Types from external metadata. Free source code and programming help: "Generating Types from external metadata"
http://www.svdeals.com/
http://www.svdeals.com/
Import CSV file in Mysql Database
Copy your csv file in following folder.
C:\Program Files\MySQL\MySQL Server 5.0\bin.
run following command:
LOAD DATA Local INFILE "export_vnflsch_1.csv" INTO TABLE YourTable FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY """" LINES TERMINATED BY "\r\n";
p2p.wrox.com Forums - How do you get SqlDataSource to requery?
p2p.wrox.com Forums - How do you get SqlDataSource to requery?: "How do you get SqlDataSource to requery?"