Insert data in JD Edwards E1 tables create Item branch F4102 , Item Location F41021 and item cost F4105 using sql-server.
create proc insert_IM_BP_CO as
declare @fmcu varchar(12)
declare @tmcu varchar(12)
set @fmcu='SOUTHAFRICA'
set @tmcu=' SAFRICA-INT'
drop table jde_rk.dbo.mar021
select * into jde_rk.dbo.mar021 from proddta.f41021 where ltrim(limcu) =@fmcu and lipqoh<>0 and lipbin='P'
update jde_rk.dbo.mar021 set limcu =@tmcu ,lipqoh=0,lipcom=0,lilrcj=0, liuser='SQL-SERVER',liupmj=109343
-----------------------------------------------
drop table jde_rk.dbo.mar02
select * into jde_rk.dbo.mar02 from proddta.f4102 where ibitm in(select liitm from jde_rk.dbo.mar021)
and ltrim(ibmcu) =@fmcu
update jde_rk.dbo.mar02 set IBmcu =@tmcu , ibuser='SQL-SERVER',IBupmj=109343
------------------------------
drop table jde_rk.dbo.mar05
select * into jde_rk.dbo.mar05 from proddta.f4105
where coitm in(select liitm from jde_rk.dbo.mar021) and ltrim(comcu) =@fmcu
update jde_rk.dbo.mar05 set comcu =@tmcu , couser='SQL-SERVER',coupmj=109343
-------
insert into proddta.f41021
select * from jde_rk.dbo.mar021
insert into proddta.f4102
select * from jde_rk.dbo.mar02
insert into proddta.f4105
select * from jde_rk.dbo.mar05
Wednesday, December 9, 2009
Tuesday, December 8, 2009
Tuesday, December 1, 2009
Wednesday, November 25, 2009
Monday, November 9, 2009
Thursday, November 5, 2009
Thursday, October 29, 2009
Wednesday, October 28, 2009
Tuesday, October 27, 2009
Saturday, October 24, 2009
Friday, October 23, 2009
My iphone weather location is showing on Cupertino and New York. how to change this?
My iphone weather location is showing on Cupertino and New York. how to change this?
Open up the weather app and in the bottom right corner there is an i. Press the i and the page will flip allowing you to change the locations.
Wednesday, October 21, 2009
Free Windows 7 Download
Free Windows 7 e-book from Microsoft http://www.microsoft.com/downloads/details.aspx?familyid=EE2A1D38-88A9-43B3-95BC-7E962F0B6030&displaylang=en
More info on Windows 7 http://windows.microsoft.com/windows-7?os=winxp
Hot link to buy windows 7 for cheap http://visli.com/mainsearch/windows-7/All/1.aspx
Tuesday, October 20, 2009
Thursday, October 15, 2009
Sunday, October 11, 2009
Invitation to connect on LinkedIn
| I'd like to add you to my professional network on LinkedIn. Confirm that you know Rajeev Kumar Every day, millions of professionals like Rajeev Kumar use LinkedIn to connect with colleagues, find experts, and explore opportunities. © 2009, LinkedIn Corporation Tuesday, October 6, 2009Monday, October 5, 2009AJAX Accordion Control DataBinding and Gridview with Code Behind C#AJAX Accordion Control DataBinding and Gridview with Code Behind C#
<html xmlns="http://www.w3.org/1999/xhtml" > <ajaxToolkit:Accordion ID="Accordion1" runat="server" TransitionDuration="100" FramesPerSecond="200" </div>
using System; public partial class Default7 : System.Web.UI.Page public void getCategories() } protected void Accordion1_ItemDataBound(object sender, AjaxControlToolkit.AccordionItemEventArgs e)
Reference:: http://programming.top54u.co Monday, September 28, 2009Thursday, September 24, 2009Monday, September 21, 2009Monday, September 14, 2009Thursday, September 10, 2009Tuesday, September 8, 2009Thursday, September 3, 2009ASP.NET Session State Overview
ASP.NET session state enables you to store and retrieve values for a user as the user navigates ASP.NET pages in a Web application. HTTP is a stateless protocol. This means that a Web server treats each HTTP request for a page as an independent request. The server retains no knowledge of variable values that were used during previous requests. ASP.NET session state identifies requests from the same browser during a limited time window as a session, and provides a way to persist variable values for the duration of that session. By default, ASP.NET session state is enabled for all ASP.NET applications.
Alternatives to session state include the following: Application state, which stores variables that can be accessed by all users of an ASP.NET application. Profile properties, which persists user values in a data store without expiring them. ASP.NET caching, which stores values in memory that is available to all ASP.NET applications. View state, which persists values in a page. Cookies. The query string and fields on an HTML form that are available from an HTTP request. read more ASP.NET Session State Overview Monday, August 31, 2009Use Office 2007 OCR Using C#
CodeProject: How To: Use Office 2007 OCR Using C#. Free source code and programming help
What is OCR ? OCR (Optical Character Recognition) is the recognition of printed or written text characters by a computer. This involves photoscanning of the text character-by-character, analysis of the scanned-in image, and then translation of the character image into character codes, such as ASCII, commonly used in data processing. Or, we can say... Optical character recognition (OCR) translates images of text, such as scanned documents, into actual text characters. Also known as text recognition, OCR makes it possible to edit and reuse the text that is normally locked inside scanned images. OCR works using a form of artificial intelligence known as pattern recognition, to identify individual text characters on a page, including punctuation marks, spaces, and ends of lines. Thursday, August 27, 2009Wednesday, August 26, 2009Monday, August 24, 2009Friday, August 21, 2009Access a Web service in a Windows-based application by using Visual Basic 2005
In Solution Explorer, right-click ServiceConsumer, and then click Add Web Reference.
after that add in your application. Imports YourApplicationName.WEBserviceName using WindowsApplication3.ElementExpress; c# How to access a Web service in a Windows-based application by using Visual Basic 2005 or Visual Basic .NET Thursday, August 20, 2009Wednesday, August 19, 2009Tuesday, August 18, 2009Sample Convert Number to Hours, Minutes in SQL Server
Convert Number to Hours and Minutes in SQL Server
SELECT pntotim/60 " hours ", pntotim % 60 " minutes" ,* FROM sATINOUT Monday, August 17, 2009Calculate Date Time difference in asp.net c#Calculate Date time difference in asp.net c# TimeSpan tmspan = DateTime.Parse(DateTime.Now.ToString()).Subtract(DateTime.Parse(YourTime.Text)); Response.Write(tmspan.Hours); Response.Write("<br>"); Response.Write(tmspan.Minutes); Response.Write("<br>"); Response.Write(tmspan.TotalHours); Response.Write("<br>"); Response.Write(tmspan.TotalMinutes);Friday, August 14, 2009Retrieving Data Using the DataReader C# Asp.net
void loaddata()
{ SqlConnection myConnection = new SqlConnection(ConnectionString); char stus = "N"; string strSQL = "select * FROM sATINOUT WHERE PNEMPID=" + Session["Udid"] + " and PNSTUS=" + stus; SqlCommand cmd = new SqlCommand(strSQL, myConnection); myConnection.Open(); SqlDataReader myReader = cmd.ExecuteReader(CommandBehavior.CloseConnection); if (myReader.HasRows) { while (myReader.Read()) { TxtUSERid.Text = myReader["UDUSRID"].ToString(); txtpasswd.Text = myReader["UDPASSWD"].ToString(); } } myReader.Close(); myConnection.Close(); } Retrieving Data Using the DataReader Thursday, August 13, 2009Tuesday, August 11, 2009Tuesday, August 4, 2009Monday, August 3, 2009Thursday, July 30, 2009Url Rebasing in ASP.NET 2.0
Url Rebasing in ASP.NET 2.0: ASP Alliance: "Url Rebasing"
Let’s say we have an image control with relative path on the masterpage html, and Masterpage is in one folder and the content page is in different folder. The relative image path given in the masterpage html markup points to the wrong location and the image is not rendered. To avoid these sorts of problems Asp.Net rebases relative urls known as Url Rebasing. Wednesday, July 29, 2009Google Toolbar disable most visited websites
Web-browsing tools : Google new tab page and most visited websites - Toolbar Help: "Enable or disable the Google new tab page
Click the Toolbar's wrench icon. On the Search tab, select (or deselect) the 'Enable the Google new tab page' checkbox. Click Save." Tuesday, July 28, 2009Thursday, July 23, 2009Rss Feed to Listview with DataPager in Asp.netDisplaying Rss Feed in Listview also using DataPager in Asp.net sample. <% @ Page Language="C#" AutoEventWireup="true" CodeFile="feedtolistview.aspx.cs" Inherits="feedtolistview" %> <! DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">< html xmlns="http://www.w3.org/1999/xhtml">< head id="Head1" runat="server"> <title>Using DataPager and ListView Controls with a Custom Data Source</title></ head>< body> <form id="form1" runat="server"> <div> <asp:DataPager ID="dataPager" runat="server" PagedControlID="listItems" QueryStringField="page" PageSize="5" > <Fields> <asp:NextPreviousPagerField FirstPageText="<<" ShowFirstPageButton="True" ShowNextPageButton="False" ShowPreviousPageButton="False" /> <asp:NumericPagerField /> <asp:NextPreviousPagerField LastPageText=">>" ShowLastPageButton="True" ShowNextPageButton="False" ShowPreviousPageButton="False" /> </Fields> </asp:DataPager> <br /> <asp:ListView ID="listItems" runat="server" DataSourceID="xmlDataSource"> <LayoutTemplate> <asp:PlaceHolder runat="server" ID="itemPlaceholder" /> </LayoutTemplate> <ItemTemplate> <h3><a href="<%# XPath("link") %>"><%# XPath("title") %></h3> </a><% # XPath("description")%> </ItemTemplate> <ItemSeparatorTemplate> <hr /> </ItemSeparatorTemplate> </asp:ListView> <asp:XmlDataSource ID="xmlDataSource" runat="server" DataFile="http://rss.news.yahoo.com/rss/topstories" XPath="rss/channel/item"></asp:XmlDataSource> <asp:DataPager ID="dataPager1" runat="server" PagedControlID="listItems" QueryStringField="page" PageSize="5"> <Fields> <asp:NumericPagerField /> </Fields> </asp:DataPager> </div> </form></ body></ html>Wednesday, July 22, 2009Friday, July 17, 2009Thursday, July 16, 2009Connection string based on the Database Environment c# Connection string based on the Database Environment c# sample: <% @ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %> <! DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">< html xmlns="http://www.w3.org/1999/xhtml">< head runat="server"> <title>Untitled Page</title></ head>< body> <form id="form1" runat="server"> <asp:ScriptManager ID="ScriptManager1" runat="server" /> <div> <asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1"> </asp:GridView> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ProviderName="System.Data.SqlClient" DataSourceMode="DataReader" SelectCommand="SELECT * FROM [mntsold]"></asp:SqlDataSource> </div> </form></ body></ html> using System;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;public partial class _Default : System.Web.UI.Page{ protected void Page_Load(object sender, EventArgs e){ if (System.Environment.GetEnvironmentVariable("COMPUTERNAME").ToString() == "xxxxxxx"){ Response.Write( "from test database");SqlDataSource1.ConnectionString = ConfigurationManager.ConnectionStrings["JDE_RKConnectionString"].ConnectionString;} if (System.Environment.GetEnvironmentVariable("COMPUTERNAME").ToString() == "ITWEB1223"){ Response.Write( "from production database");SqlDataSource1.ConnectionString = ConfigurationManager.ConnectionStrings["JDE_PRODUCTIONConnectionString"].ConnectionString;} } } SQLdatasource Connection String in code behind c# <asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1"> </asp:GridView> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ProviderName="System.Data.SqlClient" DataSourceMode="DataReader" SelectCommand="SELECT * FROM [mntsold]"></asp:SqlDataSource> code behind: SqlDataSource1.ConnectionString = ConfigurationManager.ConnectionStrings["JDE_PRODUCTIONConnectionString"].ConnectionString;web.config < connectionStrings>< add name="JDE_PRODUCTIONConnectionString" connectionString="Data Source=ENTERPRISE;Initial Catalog=JDE_PRODUCTION;User ID=sssss;password=sssss" providerName="System.Data.SqlClient" /> </connectionStrings>Machine Name in code behind C#
string name = System.Environment.GetEnvironmentVariable("COMPUTERNAME");
Tuesday, July 14, 2009Wednesday, July 8, 2009Find the SQL Server CD key Installed in your PC Using SQL command
USE master
EXEC xp_regread 'HKEY_LOCAL_MACHINE', 'SOFTWARE\Microsoft\Microsoft SQL Server\80\registration', 'CD_KEY' Tuesday, July 7, 2009Selecting unique node in a RSS feed base on user selection using c# asp.netSelecting unique node in a RSS feed base on user selection using c# asp.net
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default10.aspx.cs" Inherits="Default10" %> <html xmlns="http://www.w3.org/1999/xhtml" > <asp:TemplateField> code behind using System; public partial class Default10 : System.Web.UI.Page if (Request["url1"] == null)
} Add items in menu by role with fine cut - JD Edwards E1Master view ->click on fine cut-> click on blank space and select view by role-> select the role and add menu item -> after that agaion change the role to admin-> click on fine cut RSS feed particular Item display in a gridview
<div> <asp:GridView ID="bank" Runat="server" DataSourceID="xds" AutoGenerateColumns="False" AllowPaging="True" >
< Columns>< asp:TemplateField>< ItemTemplate> <asp:HyperLink ID="HyperLink1" Runat="server" Text='<%# XPath("title") %>' NavigateUrl='<%# XPath("link") %>' Target="_blank" Font-Names="Verdana" Font-Size="X-Small"> </asp:HyperLink></ ItemTemplate></ asp:TemplateField></ Columns></ asp:GridView>< asp:XmlDataSource ID="xds" Runat="server" DataFile="http://rss.news.yahoo.com/rss/topstories"XPath ="rss/channel/item [position()=2]"></ asp:XmlDataSource> </div>Thursday, July 2, 2009Auto Page refresh Sample Using C#, AjaxAuto Page refresh Sample Using C#, Ajax <%@ Page Language="C#" AutoEventWireup="true" CodeFile="autoreferesh.aspx.cs" Inherits="autoreferesh" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > code behind using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; public partial class autoreferesh : System.Web.UI.Page Label1.Text = "Page Refreshed at: " + DateTime.Now.ToLongTimeString(); }
Monday, June 29, 2009Friday, June 26, 2009Quotation in where condition sql-serverWindows 7 Upgrade
Windows 7 is the easiest, fastest, and most engaging version of Windows yet. Better ways to find and manage files, like Jump Lists and improved taskbar previews, help you speed through everyday tasks. Faster and more reliable performance means your PC just works the way you want it to. And great features like Windows Media Center and Windows Touch make new things possible. Get to know Windows 7, and see how it can simplify just about everything you do with your PC.
Windows 7 will be available on October 22. It includes tons of little refinements— and a few big ones—many suggested by you. The result? Everyday computing is faster, simpler, easier. Order Now Your Upgrade Version Save more then $100. Windows7 Home Premium Upgrade Windows7 Professional Upgrade Thursday, June 25, 2009Wednesday, June 24, 2009Twitter asp.net 2.0, C# sample<% @ Page Language="C#" AutoEventWireup="true" CodeFile="Default5.aspx.cs" Inherits="Default5" %> <! DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">< html xmlns="http://www.w3.org/1999/xhtml" >< head runat="server"> <title>Untitled Page</title></ head>< body> <form id="form1" runat="server"> <div> <table style="width: 50%" align="center"> <tr> <td> </td> <td> </td> <td> </td> </tr> <tr> <td align="right"> <asp:Label ID="Label2" runat="server" Text="User Id:"></asp:Label></td> <td> <asp:TextBox ID="txtusrid" runat="server" Width="144px"></asp:TextBox> </td> <td> </td> </tr> <tr> <td align="right"> <asp:Label ID="Label3" runat="server" Text="Password:"></asp:Label></td> <td> <asp:TextBox ID="txtpass" runat="server" TextMode="Password"></asp:TextBox></td> <td> </td> </tr> <tr> <td align="right" style="height: 40px"> <asp:Label ID="Label1" runat="server" Text="Messages:"></asp:Label></td> <td style="height: 40px"> <asp:TextBox ID="txtmessage" runat="server" TextMode="MultiLine" Width="259px" Height="99px"></asp:TextBox> </td> <td style="height: 40px"> </td> </tr> <tr> <td style="height: 21px"> </td> <td style="height: 21px"> <asp:Button ID="Button1" runat="server" Text="Submit" OnClick="Button1_Click" /> <asp:Label ID="Label4" runat="server" Width="126px"></asp:Label></td> <td style="height: 21px"> </td> </tr> </table> </div> </form></ body></ html> Code behind using System;using System.Net;using System.Web;using System.IO;public partial class Default5 : System.Web.UI.Page{ protected void Page_Load(object sender, EventArgs e){ } public void SubmitUserMsg(string username, string passwd, string txttweet){ string user = Convert.ToBase64String(System.Text.Encoding.UTF8.GetBytes(username + ":" + passwd)); byte[] bytes = System.Text.Encoding.ASCII.GetBytes("status=" + txttweet); HttpWebRequest request = (HttpWebRequest)WebRequest.Create("http://twitter.com/statuses/update.xml");request.Method = "POST"; request.ServicePoint.Expect100Continue = false;request.Headers.Add( "Authorization", "Basic " + user);request.ContentType = "application/x-www-form-urlencoded";request.ContentLength = bytes.Length; Stream reqStream = request.GetRequestStream();reqStream.Write(bytes, 0, bytes.Length); reqStream.Close(); Label4.Text = "Message Posted";} protected void Button1_Click(object sender, EventArgs e){ SubmitUserMsg(txtusrid.Text, txtpass.Text, txtmessage.Text); } }
Subscribe to:
Posts (Atom)
|