.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Post New Web Links

Fetch data from JDEdwards

Posted By:      Posted Date: September 24, 2010    Points: 0   Category :ASP.Net

Dear Friends,

I want to fetch data from JDEdwards and put it in Microsoft Sql Server 2005, how it is possible ?, please describe it.



View Complete Post

More Related Resource Links

How to fetch data from textbox dynamically in a gridview

How to fetch data from textbox inside a gridview

Data Binding a DataGrid to a list fetch the same data multiple times

Hi, I'm using DataGrid to show data through data binding. My data are provided in a list. The setup I have is the following: DataGrid "binded" to the default view of my list that implement IList<T> and IList interfaces (MyList<T> : IList<T>, IList, INotifyCollectionChanged)             CollectionViewSource.GetDefaultView(_myList);             // Set the data context             DataContext = view; T: is here my 'business object' that hold the data, called 'MyRow'. Then the columns of the DataGrid are bound to public properties of 'MyRow' object. MyRow class has a public property of type 'object' (public object data[int index]) and first column of datagrid is bound to myRow.data[0], second column is bound to myRow.data[1] and so on.   When the datagrid is displayed, databinding kick in and my data are showed in the control. The issue I'm having is that data fetching is very repetitive even for the same rows. For example for a datagrid with 20 visible rows, the first row is fetched multiple times even if the datagrid is not resized or moved. I put break point inside my list (MyList<T> into This[T] property (public T this[int index]) and i got multiple hits into the property for the same index. Fetc

fetch data from cursor(what wrong?)

hi there i have a SP that send mailbut in the cursor does not appears no one record, i written PRINT'-------' , and it seems no recordwhere is wrong here?the query returns 200 records here, but not in cursoralter PROCEDURE [dbo].MAIL (@date date) AS BEGIN declare @MonthlyTimeInterval int declare @WorkingDaysBeforeOpen int declare @WorkingDaysBeforeClose int ----valorizzazione parametri MAIL--------- select @MonthlyTimeInterval=MonthlyTimeInterval, @WorkingDaysBeforeOpen=WorkingDaysBeforeOpen, @WorkingDaysBeforeClose=WorkingDaysBeforeClose FROM ParameterData --------market in apertura------------- DECLARE @getMktOpen CURSOR declare @PeriodEND date declare @PeriodStart date declare @Market Varchar(300) declare @Status bit declare @MarketID int DECLARE @MarketPeriodID INT SET @getMktOpen = CURSOR FOR SELECT MAX(Period.[Desc]) AS PeriodEND, MIN(Period.[Desc]) AS PeriodStart, Market.[Desc] AS Market, MarketPeriod.Status, Market.MarketID, MarketPeriod.MarketPeriodID FROM MarketPeriod INNER JOIN Period ON MarketPeriod.PeriodID = Period.PeriodID INNER JOIN Market ON MarketPeriod.MarketID = Market.MarketID GROUP BY Market.[Desc], MarketPeriod.Status, Market.MarketID, MarketPeriod.MarketPeriodID -- HAVING (MarketPeriod.Status = 0) -- AND (MIN(Period.[Desc]) = CONVERT(CHAR(11),@date,111) ) OPE

Infopath 2007: Cant we fetch data from a list or form library without using a Query to the data conn

I am trying to fetch data from a form library and a list (both secondary data sources). But cant do it without using a rule (Query using a data connection). However when I use the 'Refresh' control on the form it brings the value. I find it quite weird, as the connections are made properly and logically speaking all the data connetions should fetch dynamic data once the form opens or loads. Cant we do it without using a (data query) rule? Update: I am using a web based infopath forms, while using the same form on client its working fine. Why is that?

How Fetch Data from HTML tags

Aslam o alaikum to allI am working in asp.net and vb.net i want to get data from <p>Dta to get in vb code</p> this and from a table like<table><tr><td>ID</td><td>Name</td><td>1</td><td>Saleem</td></tr><table>please help me thanks and best regards

Fetch data from one list and populate another list


How to fetch the details from one list & show it in an another list in Sharepoint 2010.


List #1 : Total Project/Resource List

   Resources       Projects
         Resource1 Project1,project2
  REsource2 Project1,project3

List #2 : Resources Per project


How to fetch details from List1 based on projects (Projects (Multiline text) are comma seperted data)


How to fetch data from nested gridview


Hi, Please guide me how to fetch data from Nested gridview checkbox on Click button event which is present outside the gridview. I did try by creating an object of child gridview on button1_click but cannot fill the value from Gridview2 into my int i. Below mentioned is the Code i am using. The database I am using is Oracle.

 ==== Code =====

 protected void Button1_Click(object sender, EventArgs e)


OracleConnection con = new OracleConnection();

        con.ConnectionString = ConfigurationSettings.AppSettings["oracle"];

        //int RowIndex = Convert.ToInt32(e.CommandArgument);


        //GridView subGrid = (GridView)GridView1.Rows[RowIndex].FindControl("GridView2");


        //GridView subGrid = (GridView)GridView1.FindControl("GridView2");

        int i = 0;

        GridView subGrid =((GridView)GridView1.Rows[i].FindControl("GridView2"));


After adding filter, data fetch limit error


Alright, so i'm getting the "this page has exceeded its data fetch limit for connected web parts" error.
But it only happens if i add a filter.

Currently I have 6 lists on the page and am using 4 filters, so why can't I add a 5th filter?

Forgot to mention that I added the filters with SharePoint designer 2007

Cannot Fetch Data via SQLFetch Function (ODBC Programming)


Hello Everyone

I'm c# developer but i want use c++ for the future times.  I'm newly in ODBC Native programming. I wrote this code and compiled successful but i can't get customerIds. Because i get an error its "[Microsoft][ODBC Driver Manager] Invalid descriptor index" here is my code

#include <Windows.h>

#include <sql.h>

#include <sqltypes.h>

#include <sqlext.h>

#include <stdio.h>

int main()






	SQLWCHAR	*szDns = L"Driver={SQL Server};Server=.\\SQLEXPRESS;Database=TestForQt;Trusted_Connection=Yes;";


	int			columnValue;

	rc = SQLAllocEnv(&hEnv);


	rc = SQLAllocConnect(hEnv, &hDbc);


	rc = SQLAllocStmt(hDbc, &hStm);

	rc = SQLExecDirect(hStm, L"SELECT customerId FROM customer", SQL_NTS);

	while(SQLFetch(hStm) == SQL_SUCCESS)


Accordion inside Gridview, fetch gridview data when expanding accordion


using asp.net/vb.net 2005

I want to create an accordion inside a gridview with the following functionality:

The user will only see one field of the gridview initially, the ProductCategoryID.  When the page loads it will only query the ProductCategoryID and this will be the only field displayed.

Next when the user clicks on the accordion to expand it inside the gridview I would like to query the database to get all Products that are part of the ProductCategory.  I will query using the ProductCategoryID that is being displayed.

I need to do this for performance issues.  The main thing I am looking for is how to query the database once the user expands a given ProductCategoryID.

but now I think of it one thing I need to know:  when you bind an accordion to a dataset will it create one pane for each record returned?  It might be better to put the gridview inside the accordion.  I'm willing to do either, as long as it works



Fetch data from the database and place it in a marquee

The article Fetch data from the database and place it in a marquee was added by codenickel on Saturday, October 30, 2010.

1. First we should take the marquee tag in the source of our web form(Page.aspx) page like this:->marquee direction="up" onmouseover="this.start()" onmouseout="this.stop()"scrolldelay="300? style="height: 213px">asp:Literal ID="lt1? runat="server

Not able to fetch data for Application Domains related to .NET Framework 4.0 Process


We want to enumerate all .NET Framework 4.0 Processes on a particular machine. And then want to enumerate Application Domains for those processes.

After enumerating Application Domains, we want to fetch data about each Application Domain using following APIs.




We tried this using ICorPublishAppDomain Interface as well as following code :

ICLRMetaHost *meta; 

Script Error in MOSS 2007: "An error has occurred with the data fetch"



I faced "An error has occurred with the data fetch. Please refresh the page and retry." while browsing the adimistration site of our portal using IE7. The error was thrown when i tried to open the Edit Menu of a List Item.

Did anybody face a simlar error?

Fetch Data from sql server having different physical address or ip address



I have this sql server xxx.xx.40.221 where i am writing cursor.

I want to fetch data from xxx.xx.1.153 sql server.

But as you can see these two databases are on different physical locations, how m i suppose to do.

I m counting on u guys. Please help me!!


Caml Query to fetch the data from Sharepoint List for a specific date.



I have a sharepoint list with one of hte columns being Created Date of Type DateTime and value allowed is OnlyDate.

The submitted date in my column is 05/18/2011. When I perform a search using the below CAML query, it does not give any results though I have two items with this date.

<Where><Eq><FieldRef Name='Date_x0020_Created' /><Value Type='DateTime'>5/18/2011</Value></Eq></Where>

I dont understand what is wrong with this query. Someone please help

Janaki Thakur

I want to fetch the data between the give date range from ms sql 2005 database



I am developing one desktop application using vb.net 2008 and Microsoft SQL Server 2005. I need a help for fetching the data from database between a given range.


the date field in my table is of type VARCHAR(25) and the date format stored is dd-mm-yyyy. when I using the between clause in the SQL query then it is not giving all the data every time i.e. the date criteria in where clause is not working fine.

while my clients requirement is to keep the date format as dd-mm-yyyy and fetch the data according to the given range.

I search on the forum and found many queries to fetch the data by converting or type casting the date field within sql query but nothing worked.

so please help me out with that what shoud I do in this case.

The table structure that I am using is as follows


USE [Firm_master]
/****** Object:  Table [dbo].[tblTransaction]    Script Date: 05/17/2011 21:49:11 ******/
CREATE TABLE [dbo].[tblTransaction](
    [Tid] [int] IDENTITY(1,1) NOT NULL,
    [Dataid] [int] NOT NULL,
    [Vouch_type] [int] NULL,
    [Dr_ac_name] [varchar](50) NULL,

Binding WPF Controls to an Entity Data Model

In this interview, programming writer, McLean Schofield, demonstrates how to bind WPF controls to an entity data model, using Visual Studio 2010 Beta 1. You can also learn more in the topic: Walkthrough: Binding WPF Controls to an Entity Data Model.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend