|
Dear Friends,
I need help in my project, please kindly help me out..
I am having 2 application
Application 1:
database( MY SQL ) which will updating as per events occurring in it.
Application 2:
Database ( SQL SERVER) which is working in co-ordination with its hardware.
now i want to take data from 1 application and push it in application 2.. and from application 2 i will be sending request to its hardware.
Doubts i have
1. How to keep track of latest update in application 1. ( data is continuously getting updated).
So for this in my application i will using connection and other classes to connect it. but how to keep it running( using windows services / Timer or what ?) as whenever there is new entry in the database of 1st application i want to retrieve it in my application.
so that i can send it to the second application.
Thanks in advance.
|
|
|
|
|
|
Thanks any more suggestions pls
|
|
|
|
|
hi
can someone be of help, i want develop my first application which is based on Examination attendance management sysetem.. I need source code and interface design layout
|
|
|
|
|
If you need source code then you are not developing this application, you are asking others to do it for you.
Start with writing your requirements.
Failure is not an option; it's the default selection.
|
|
|
|
|
lawal olanrewaju Daniel wrote: I need source code and interface design layout
Good, I charge about 400 € / day. Does that sound reasonable to you?
V.
|
|
|
|
|
How about you actually pay attention in your lectures and do the course you're on properly?
|
|
|
|
|
Assume an array in form1 like this
public class ARR1
{
public Int64 code;
public string name;
public bool sup;
public bool[] chb = new bool[100];
public string[] param = new string[100];
public void reset()
{
int i;
code = 0;
name = "";
sup = false;
for (i = 0; i < 100; i++) chb[i] = false;
for (i = 0; i < 100; i++) param[i] = "";
}
}
public ARR1 MainArr = new ARR1();
and ofcourse we have done something with this
aaray and it is full of data, in form2 its new
data is not accessible. how can we delegate this
array in form2 to use its data.
this format ( form1 frm1=new form1(); ) doesn't work.
thus how can we delegate an array in deferent forms?
|
|
|
|
|
1. Please use the pre tags to post code (the code button on top of the edit field)
2. Your question does not make sense at all, what are you trying to achieve?
3. What do you mean with: "this format ( form1 frm1=new form1(); ) doesn't work"
4. What do you mean with delegate, because a delegate is a more complex term to explain and I doubt you need that here. I assume you mean something else.
5. You're code looks terrible, if you're a beginner, I suggest you buy a book and follow it from start to end.
V.
|
|
|
|
|
Ill do all your advices and forget my question.
as we can delegate for example a textBoxes between
forms, I want to know how can we delegate arrays
between forms.
|
|
|
|
|
You mean you want to pass the information from one form to the next?
You can do so by passing it through the constructor or via using a property.
V.
|
|
|
|
|
I've got an issue with my MDI child forms, where the form objects 'contain' data from previous instances.
I'm assuming its relating to the fact that when I open the form from the MDI parent I use the following:
frmDTC frm = new frmDTC(true);
frm.MdiParent = this;
frm.Show();
I think the errors are occurring because I don't dispose of frm. Usually I would use using, but that will close the form instantly.
So should I do something like:
frm.FormClosed += (s, ev) => frm.Dispose();
Or should this be in the form class itself?
Or have I missed something else...and the user closing the form should mean it gets disposed eventually...and I've got something else stopping it.
|
|
|
|
|
Dispose won't remove references that you've added (as fields of your form object). And yes, closing a form will generally immediately Dispose it as well, so this is probably not your problem.
My guess is you're storing frm in a collection somewhere, and not removing it when the form is closed. You can either ditch that collection entirely and use MdiChildren, or you need to add a close handler to remove subforms from any collections in your code.
|
|
|
|
|
mmm, I'm not adding it to any collection explicitly. (I do set the MDIParent property though, does this add it to any collection on the MDIParent form??)
No subforms are loaded during the lifetime of the form, and there's no complex class-level variables to dispose of either. It's a 'basic' dataset bound form.
|
|
|
|
|
This is my Stored Procedure i want to implement paging where i will get the page size as a parameter from UI..How do i implement paging in this query
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
-- =============================================
-- Author: <ragesh nair="">
-- Create date: <11/04/2012>
-- Description: <search>
-- =============================================
--exec iSRPDb_Sp_Search_WO 1,0,'0','T',10,1
--select * from tblProject where ProjectID=13849
--select * from tblProject where ProjectID=22412
--select * from tblProject where ProjectCode='B20904'
--select * from tblSubContractor where SubContractorID=88420
--select top 10* from tblWorkOrderHeader where ProjectID=22412
ALTER PROCEDURE [dbo].[iSRPDb_Sp_Search_WO]
@pBusinessUnitID as int=0,
@pProjectID as int,
@pSubcontractorID as int,
@pWONumber as varchar(10),
@PageSize as int
AS
BEGIN
SET NOCOUNT ON;
DECLARE @BusinessUnitFilter Varchar(255)
DECLARE @NameFilter Varchar(255)
DECLARE @SubConNameFilter Varchar(255)
DECLARE @WONumFilter Varchar(255)
DECLARE @Filter Varchar(2000)
DECLARE @StatusFilter VARCHAR(255)
DECLARE @PageNumber int
DECLARE @RowStart int
DECLARE @RowEnd int
DECLARE @condition varchar(255)
SET @StatusFilter=''
--if @PageNumber > 0
--
-- SET @PageNumber = @PageNumber -1
-- SET @RowStart = @PageSize * @PageNumber + 1;
-- SET @RowEnd = @RowStart + @PageSize - 1 ;
IF @pBusinessUnitID > 0
SET @BusinessUnitFilter = 'TWO. BusinessUnitID=' + Convert(Varchar(10),@pBusinessUnitID)
ELSE
SET @BusinessUnitFilter = ''
IF LTRIM(RTRIM(@pProjectID)) > 0
SET @NameFilter = ' AND TP.ProjectID =' + Convert(Varchar(255),@pProjectID)
ELSE
SET @NameFilter = ''
IF LTRIM(RTRIM(@pSubcontractorID)) > 0
SET @SubConNameFilter = ' AND TS.SubcontractorID =' + Convert(Varchar(255),@pSubcontractorID)
ELSE
SET @SubConNameFilter = ''
If ltrim(rtrim(@pWONumber))<> ''
Set @WONumFilter = 'AND TWO.WONumber LIKE ''%' + @pWONumber + '%'''
Else
Set @WONumFilter = ''
SET @FILTER =@StatusFilter + @BusinessUnitFilter + @NameFilter + @SubConNameFilter + @WONumFilter
exec('select
TWO.WONumber,
TS.Name AS SubcontractorName,
TP.ProjectCode,
TP.Description as ProjectName ,
TP.StartDate,
TP.EndDate,
ROW_NUMBER() OVER(order by TP.Description) as RowNO
from tblWorkOrderHeader TWO inner join
tblWorkOrderDetail TWOD on TWO.WONumber= TWOD.WONumber
inner join tblSubContractor TS on TWO.SubContractorID= TS.SubContractorID
inner join tblProject TP on TWO.ProjectID=TP.ProjectID
where ' + @FILTER)
end
--select * from tblProject where ProjectID=20101
--select * from tblSubContractor where SubContractorID=110244
--where (@subconid = 0 or @subconid = aa.subcontractorid)
|
|
|
|
|
Don't cross post. You picked the correct forum in the Database forum; leave it there.
|
|
|
|
|
Dear Sir i have to a problem to my project .
it has i wnat to recover to password code by using in project & How Retrive Data In gridview
|
|
|
|
|
Huh?
|
|
|
|
|
I have an MFC desktop app that implements the "Always On Top" feature by calling:
bool bOnTop = ...
CWnd* pWndOnTop = (CWnd *) (bOnTop ? &CWnd::wndTopMost : &CWnd::wndNoTopMost);
SetWindowPos (pWndOnTop, 0, 0, 0, 0, SWP_NOMOVE | SWP_NOSIZE);
This works as expected. Regardless of whether or not the app is always on top of other windows, all child dialogs (both modal and modeless) are shown on top of the app's main window.
A Windows Forms version of the app attempts to do the same thing by P/Invoking SetWindowPos(). Although the app's main window responds as expected, all modal child Forms (both modal and modeless) fail to appear on top of the app's main window, and are instead occluded by the topmost main Form. I tried setting Form.TopMostand Form.TopLevel instead of calling SetWindowPos() but am still unable to display the modal child Forms on top of the main Form.
I've Googled far and wide and have browsed both SO and MSDN to no avail. A nudge in the right direction would be appreciated. I'd hate to have to nix this feature because of a problem with .NET. (I'm sure it's me and not .NET, but I'm at my wit's end.)
Thanks for any pointers you can send my way.
/ravi
modified 13-Apr-12 1:19am.
|
|
|
|
|
An owned form always appears in front of it's owner and if this is the desired behaviour just ensure that the popup forms are shown using the Show/ShowDialog methods with the IWin32Window owner parameter.
Interestingly the difference between ShowDialog() and ShowDialog(IWin32Window owner) do not become apparent until the calling form is made TopMost. At which point the problems you describe suddenly appear!
Alan.
|
|
|
|
|
Alan N wrote: Interestingly the difference between ShowDialog() and ShowDialog(IWin32Window owner) do not become apparent until the calling form is made TopMost. At which point the problems you describe suddenly appear!
GAAAH! I'm a moron. Thank you, Alan for pointing that out! 
/ravi
|
|
|
|
|
I have an interface with a client that is been in production for many years, and I would like to alter the xml parsing system that handles this message.
Since I may have 4 different StatusTypes I desire to have an array of the these items, however, they are not in a nice collection element that will make deserlization simple, like all of the examples on the internet that I could find.
In the code below, I was hoping to get all of these items in MysticalList. Obviously, my example does not work ... How can I get my entity to work with a simple list?
<xsd:complexType name="requestRailStatus">
<xsd:sequence>
<xsd:element name="TrainID" type="xsd:string" minOccurs="0" maxOccurs="1" />
<xsd:element name="BeginTimePeriod" type="xsd:dateTime" minOccurs="0" maxOccurs="1" />
<xsd:element name="EndTimePeriod" type="xsd:dateTime" minOccurs="0" maxOccurs="1" />
<xsd:element name="StatusType" type="railStatusOptions" minOccurs="0" maxOccurs="4" />
</xsd:sequence>
<xsd:attribute name="timestamp" type="xsd:dateTime" use="required" />
<xsd:attribute name="messageId" type="xsd:unsignedInt" use="required" />
</xsd:complexType>
<xsd:simpleType name="railStatusOptions">
<xsd:restriction base="xsd:string">
<xsd:enumeration value="ActualTimeOfArrival" />
<xsd:enumeration value="ActualTimeOfWorking" />
<xsd:enumeration value="ActualTimeOfCompletion" />
<xsd:enumeration value="ActualTimeOfDeparture" />
</xsd:restriction>
</xsd:simpleType>
public partial class requestRailStatus : EntityBase
{
public string TrainID { get; set; }
public System.DateTime BeginTimePeriod { get; set; }
public System.DateTime EndTimePeriod { get; set; }
[XmlElement("timestamp")]
public System.DateTime TimeStamp { get; set; }
[XmlElement("messageId")]
public uint MessageId { get; set; }
[XmlArray]
public List<railStatusOptions> MysticalList { get; set; }
public requestRailStatus() { }
}
You can only be young once. But you can always be immature.
- Dave Barry
|
|
|
|
|
You called the property StatusType, not MysticalList, in the XSD. Also, I think you mean [XmlAttribute] not [XmlElement].
|
|
|
|
|
If I had only "StatusType" I would agree with you, however I have 4, I want all 4 of them to be placed in the single array...
You can only be young once. But you can always be immature.
- Dave Barry
|
|
|
|
|
Hello CodeProject. I'm having problems using this codeproject: http://www.codeproject.com/Articles/10162/Creating-EAN-13-Barcodes-with-C
Now it draws fine when I don't use this code in my Form1.cs
protected override CreateParams CreateParams
{
get
{
CreateParams cp = base.CreateParams;
cp.ExStyle |= 0x02000000;
return cp;
}
}
BUT I need the above code because it prevents all my controls from flickering easily. For some reason tho while using that code, the EAN13 barcode won't Draw to the pictureBox at all 
Is there a way to edit that EAN13 barcode code to make it able to work while using the CreateParams code up above?
I need the barcode code working but I also can't let my huge application to flicker.
Please help CodeProject  I would be so thankful
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
