C# (Csharp) 프로그래밍

파일 읽기 쓰기

FileSystemObject 읽기


Function Dir_OpenFile(ByVal File As String) as string
    Dim fso, FileWriter As Object
    
    Set fso = CreateObject("scripting.FileSystemObject")
    Set FileWriter = fso.OpenTextFile(File)
    Dir_OpenFile = FileWriter.ReadAll
    FileWriter.Close
End Function

Function Dir_OpenFile(ByVal File As String) as string

Dim fso, FileWriter As Object

Set fso = CreateObject("scripting.FileSystemObject")

Set FileWriter = fso.OpenTextFile(File)

Dir_OpenFile = FileWriter.ReadAll

FileWriter.Close

End Function

쓰기


Public Sub Dir_WriteFile(ByVal File As String, ByVal Text As String)
    Dim fso, FileWriter As Object
    
    Set fso = CreateObject("scripting.FileSystemObject")
    Set FileWriter = fso.CreateTextFile(File, True)
    
    FileWriter.Write Text
    FileWriter.Close
End Sub

Public Sub Dir_WriteFile(ByVal File As String, ByVal Text As String)

Dim fso, FileWriter As Object

Set fso = CreateObject("scripting.FileSystemObject")

Set FileWriter = fso.CreateTextFile(File, True)

FileWriter.Write Text

FileWriter.Close

End Sub

참조 : https://starplaying.tistory.com/316 #fileNumber 읽기


Open "fileName" For Input As #fileNumber
   VB Statements
   Input #fileNumber, variable
   VB Statements
Close #fileNumber

Open "fileName" For Input As #fileNumber

VB Statements

Input #fileNumber, variable

VB Statements

Close #fileNumber

쓰기


Open "fileName" For Output As #fileNumber
   VB Statements
   Print #fileNumber, Contents
   VB Statements
Close #fileNumber

Open "fileName" For Output As #fileNumber

VB Statements

Print #fileNumber, Contents

VB Statements

Close #fileNumber

참조 : https://aroundck.tistory.com/1917 활용


Private Sub Form_Load()

Dim sXML As String

sXML = modFunction.Dir_OpenFile("D:\samples\Test.xml")

'Debug.Print sXML
'//xml.ParseXML (sXML)
'Call SetCardData '컬렉션에 저장

End Sub

Private Sub Form_Load()

Dim sXML As String

sXML = modFunction.Dir_OpenFile("D:\samples\Test.xml")

'Debug.Print sXML

'//xml.ParseXML (sXML)

'Call SetCardData '컬렉션에 저장

End Sub

*모듈 : modFunction


'일기
Function Dir_OpenFile(ByVal File As String) As String
    Dim fso, FileWriter As Object
    
    Set fso = CreateObject("scripting.FileSystemObject")
    Set FileWriter = fso.OpenTextFile(File)
    Dir_OpenFile = FileWriter.ReadAll
    FileWriter.Close
End Function

'쓰기
Public Sub Dir_WriteFile(ByVal File As String, ByVal Text As String)
    Dim fso, FileWriter As Object
    
    Set fso = CreateObject("scripting.FileSystemObject")
    Set FileWriter = fso.CreateTextFile(File, True)
    
    FileWriter.Write Text
    FileWriter.Close
End Sub

'일기

Function Dir_OpenFile(ByVal File As String) As String

Dim fso, FileWriter As Object

Set fso = CreateObject("scripting.FileSystemObject")

Set FileWriter = fso.OpenTextFile(File)

Dir_OpenFile = FileWriter.ReadAll

FileWriter.Close

End Function

'쓰기

Public Sub Dir_WriteFile(ByVal File As String, ByVal Text As String)

Dim fso, FileWriter As Object

Set fso = CreateObject("scripting.FileSystemObject")

Set FileWriter = fso.CreateTextFile(File, True)

FileWriter.Write Text

FileWriter.Close

End Sub

COM An acronym for Component Object Model, the name of Microsoft’s design strategy to implement OLE 2+ and ActiveX. Distributed COM (DCOM) allows networked and cross-platform implementation of ActiveX and OLE 2+ operations and Automation. DCOM An acronym for Distributed Common Object Model that allows communication and manipulation of objects over a network connection. Windows… Read More »

[tp_cheapest_flights_shortcodes origin=SEL destination=LAX title=”항공권” paginate=true subid=”” currency=”KRW”]

InstallShield setup 파일 만들기


//===========================================================================
//● 설치가 된적이 없거나 Uninstall되어 있는 상태에서 실행 할 때 flow
// OnFirstUIBefore  ==>  OnMoveData  ==>  OnFirstUIAfter
//
//● Uninstall 시 flow 
//OnMaintUIBefore ==> OnMoveData ==> OnMaintUIAfter
//
//● 설치가 되어 있는 상태에서 Update(==Repair) 시 flow
//OnUpdateUIBefore  ==> OnMoveData  ==> OnUpdateUIAfter
//===========================================================================

//===========================================================================

//● 설치가 된적이 없거나 Uninstall되어 있는 상태에서 실행 할 때 flow

// OnFirstUIBefore ==> OnMoveData ==> OnFirstUIAfter

//● Uninstall 시 flow

//OnMaintUIBefore ==> OnMoveData ==> OnMaintUIAfter

//● 설치가 되어 있는 상태에서 Update(==Repair) 시 flow

//OnUpdateUIBefore ==> OnMoveData ==> OnUpdateUIAfter

//===========================================================================

//● 설치가 된적이 없거나 Uninstall되어 있는 상태에서 실행 할 때 flow // OnFirstUIBefore ==> OnMoveData ==> OnFirstUIAfter


// Included header files ----------------------------------------------------
#include "ifx.h"

//---------------------------------------------------------------------------                                                                        
// OnFirstUIBefore
//
// First Install UI Sequence - Before Move Data
//
// The OnFirstUIBefore event is called by OnShowUI when the setup is
// running in first install mode. By default this event displays UI allowing
// the end user to specify installation parameters.
//
// Note: This event will not be called automatically in a
// program...endprogram style setup.
//---------------------------------------------------------------------------
function OnFirstUIBefore()
    number  nResult;
    number  nLevel;
    number  nvSize, nSetupType;
    number  nId;
    string  szTitle, szMsg;
    string  szOpt1, szOpt2, szLicenseFile;
    string  szName, szCompany;
    string  szTargetPath;
    string  svDir;
    string  szFeatures, szTargetdir;	
    string  szId;
    BOOL    bLicenseAccepted;	
begin	
   
    nSetupType = COMPLETE;	
	         
	if ( ALLUSERS ) then
		TARGETDIR = PROGRAMFILES ^ IFX_COMPANY_NAME ^ IFX_PRODUCT_NAME;		
    else
		TARGETDIR = FOLDER_APPDATA ^ IFX_COMPANY_NAME ^ IFX_PRODUCT_NAME;
    endif;

	// Customize the default TARGETDIR for multi-instance application.
	// TODO: If you want something different customize the code below.	
	/*if( MAINT_OPTION = MAINT_OPTION_MULTI_INSTANCE  && MULTI_INSTANCE_COUNT > 0) then

		// Start with the current multi-instance count plus one.
		nId = MULTI_INSTANCE_COUNT + 1;

		// Find a unique TARGETDIR.
		while( ExistsDir( TARGETDIR ) = EXISTS )
			
			// Convert to string.
			NumToStr( szId, nId );
			
			// Update IFX_MULTI_INSTANCE_SUFFIX
			IFX_MULTI_INSTANCE_SUFFIX = "_" + szId;
		
			// Update TARGETDIR
			TARGETDIR = TARGETDIR + IFX_MULTI_INSTANCE_SUFFIX;
			
			// Update nId
			nId = nId + 1;

		endwhile;

	endif;*/

    svDir = TARGETDIR;
    szName = "";
    szCompany = "";
    bLicenseAccepted = FALSE;

// Included header files ----------------------------------------------------

#include "ifx.h"

//---------------------------------------------------------------------------

// OnFirstUIBefore

// First Install UI Sequence - Before Move Data

// The OnFirstUIBefore event is called by OnShowUI when the setup is

// running in first install mode. By default this event displays UI allowing

// the end user to specify installation parameters.

// Note: This event will not be called automatically in a

// program...endprogram style setup.

//---------------------------------------------------------------------------

function OnFirstUIBefore()

number nResult;

number nLevel;

number nvSize, nSetupType;

number nId;

string szTitle, szMsg;

string szOpt1, szOpt2, szLicenseFile;

string szName, szCompany;

string szTargetPath;

string svDir;

string szFeatures, szTargetdir;

string szId;

BOOL bLicenseAccepted;

begin

nSetupType = COMPLETE;

if ( ALLUSERS ) then

TARGETDIR = PROGRAMFILES ^ IFX_COMPANY_NAME ^ IFX_PRODUCT_NAME;

else

TARGETDIR = FOLDER_APPDATA ^ IFX_COMPANY_NAME ^ IFX_PRODUCT_NAME;

endif;

// Customize the default TARGETDIR for multi-instance application.

// TODO: If you want something different customize the code below.

/*if( MAINT_OPTION = MAINT_OPTION_MULTI_INSTANCE && MULTI_INSTANCE_COUNT > 0) then

// Start with the current multi-instance count plus one.

nId = MULTI_INSTANCE_COUNT + 1;

// Find a unique TARGETDIR.

while( ExistsDir( TARGETDIR ) = EXISTS )

// Convert to string.

NumToStr( szId, nId );

// Update IFX_MULTI_INSTANCE_SUFFIX

IFX_MULTI_INSTANCE_SUFFIX = "_" + szId;

// Update TARGETDIR

TARGETDIR = TARGETDIR + IFX_MULTI_INSTANCE_SUFFIX;

// Update nId

nId = nId + 1;

endwhile;

endif;*/

svDir = TARGETDIR;

szName = "";

szCompany = "";

bLicenseAccepted = FALSE;


// Beginning of UI Sequence
Dlg_Start:
    nResult = 0;

Dlg_SdWelcome:
    szTitle = "설치 하기 ";
    szMsg = "메시지 입니다.";
    //{{IS_SCRIPT_TAG(Dlg_SdWelcome)
    nResult = SdWelcome( szTitle, szMsg );
    //}}IS_SCRIPT_TAG(Dlg_SdWelcome)
    if (nResult = BACK) goto Dlg_Start;

// Beginning of UI Sequence

Dlg_Start:

nResult = 0;

Dlg_SdWelcome:

szTitle = "설치 하기 ";

szMsg = "메시지 입니다.";

//{{IS_SCRIPT_TAG(Dlg_SdWelcome)

nResult = SdWelcome( szTitle, szMsg );

//}}IS_SCRIPT_TAG(Dlg_SdWelcome)

if (nResult = BACK) goto Dlg_Start;


Dlg_SdRegisterUser:
    szMsg = "사용자 등록";
    szTitle = "사용자 등록 하세요";
    //{{IS_SCRIPT_TAG(Dlg_SdRegisterUser)	
    nResult = SdRegisterUser( szTitle, szMsg, szName, szCompany );
    //}}IS_SCRIPT_TAG(Dlg_SdRegisterUser)
    //if (nResult = BACK) goto Dlg_SdLicense2;
    if (nResult = BACK) goto Dlg_SdWelcome;

Dlg_SdRegisterUser:

szMsg = "사용자 등록";

szTitle = "사용자 등록 하세요";

//{{IS_SCRIPT_TAG(Dlg_SdRegisterUser)

nResult = SdRegisterUser( szTitle, szMsg, szName, szCompany );

//}}IS_SCRIPT_TAG(Dlg_SdRegisterUser)

//if (nResult = BACK) goto Dlg_SdLicense2;

if (nResult = BACK) goto Dlg_SdWelcome;


Dlg_SetupType2:   
    szTitle = "사용자 정의 설치 Dlg_SetupType2";
    szMsg = "사용자 정의 설치 Dlg_SetupType2";
    //{{IS_SCRIPT_TAG(Dlg_SetupType2)	
    nResult = SetupType2( szTitle, szMsg, "", nSetupType, 0 );
    //}}IS_SCRIPT_TAG(Dlg_SetupType2)
    if (nResult = BACK) then
        goto Dlg_SdRegisterUser;
    else
        nSetupType = nResult;
        if (nSetupType != CUSTOM) then
            szTargetPath = TARGETDIR;
            nvSize = 0;
            FeatureCompareSizeRequired( MEDIA, szTargetPath, nvSize );
            if (nvSize != 0) then      
                MessageBox( szSdStr_NotEnoughSpace, WARNING );
                goto Dlg_SetupType2;
            endif;
        endif;   
    endif;

Dlg_SetupType2:

szTitle = "사용자 정의 설치 Dlg_SetupType2";

szMsg = "사용자 정의 설치 Dlg_SetupType2";

//{{IS_SCRIPT_TAG(Dlg_SetupType2)

nResult = SetupType2( szTitle, szMsg, "", nSetupType, 0 );

//}}IS_SCRIPT_TAG(Dlg_SetupType2)

if (nResult = BACK) then

goto Dlg_SdRegisterUser;

else

nSetupType = nResult;

if (nSetupType != CUSTOM) then

szTargetPath = TARGETDIR;

nvSize = 0;

FeatureCompareSizeRequired( MEDIA, szTargetPath, nvSize );

if (nvSize != 0) then

MessageBox( szSdStr_NotEnoughSpace, WARNING );

goto Dlg_SetupType2;

endif;


Dlg_SdFeatureTree: 
    if ((nResult = BACK) && (nSetupType != CUSTOM)) goto Dlg_SdAskDestPath2;
    szTitle = "사용자 설치 Dlg_SdFeatureTree";
    szMsg = "사용자 설치 Dlg_SdFeatureTree";
    szTargetdir = TARGETDIR;
    szFeatures = "";
    nLevel = 2;
    if (nSetupType = CUSTOM) then
        //{{IS_SCRIPT_TAG(Dlg_SdFeatureTree)	
        nResult = SdFeatureTree( szTitle, szMsg, szTargetdir, szFeatures, nLevel );
        //}}IS_SCRIPT_TAG(Dlg_SdFeatureTree)
        if (nResult = BACK) goto Dlg_SdAskDestPath2;  
    endif;

Dlg_SdFeatureTree:

if ((nResult = BACK) && (nSetupType != CUSTOM)) goto Dlg_SdAskDestPath2;

szTitle = "사용자 설치 Dlg_SdFeatureTree";

szMsg = "사용자 설치 Dlg_SdFeatureTree";

szTargetdir = TARGETDIR;

szFeatures = "";

nLevel = 2;

if (nSetupType = CUSTOM) then

//{{IS_SCRIPT_TAG(Dlg_SdFeatureTree)

nResult = SdFeatureTree( szTitle, szMsg, szTargetdir, szFeatures, nLevel );

//}}IS_SCRIPT_TAG(Dlg_SdFeatureTree)

if (nResult = BACK) goto Dlg_SdAskDestPath2;

endif;


Dlg_ObjDialogs:
    nResult = ShowObjWizardPages( nResult );
    if (nResult = BACK) goto Dlg_SdFeatureTree;
    
Dlg_SdStartCopy2:
    szTitle = "Dlg_SdStartCopy2";
    szMsg = "Dlg_SdStartCopy2";
    //{{IS_SCRIPT_TAG(Dlg_SdStartCopy2)	
    nResult = SdStartCopy2( szTitle, szMsg );	
    //}}IS_SCRIPT_TAG(Dlg_SdStartCopy2)
    if (nResult = BACK) goto Dlg_ObjDialogs;
 
    return 0;

Dlg_ObjDialogs:

nResult = ShowObjWizardPages( nResult );

if (nResult = BACK) goto Dlg_SdFeatureTree;

Dlg_SdStartCopy2:

szTitle = "Dlg_SdStartCopy2";

szMsg = "Dlg_SdStartCopy2";

//{{IS_SCRIPT_TAG(Dlg_SdStartCopy2)

nResult = SdStartCopy2( szTitle, szMsg );

//}}IS_SCRIPT_TAG(Dlg_SdStartCopy2)

if (nResult = BACK) goto Dlg_ObjDialogs;

return 0;

//● Uninstall 시 flow //OnMaintUIBefore ==> OnMoveData ==> OnMaintUIAfter


//---------------------------------------------------------------------------
// OnMaintUIBefore
//
// Maintenance UI Sequence - Before Move Data
//
// The OnMaintUIBefore event is called by OnShowUI when the setup is
// running in maintenance mode. By default this event displays UI that
// allows the end user to add or remove features, repair currently
// installed features or uninstall the application.
//
// Note: This event will not be called automatically in a
// program...endprogram style setup.
//---------------------------------------------------------------------------
function OnMaintUIBefore()
    number	nResult, nType, nMediaFlags;
    string	szTitle, szMsg, szIgnore;
begin
	
	// nType defaults to MODIFY.
	nType = MODIFY;

// Beginning of UI Sequence
Dlg_Start:

	// Show Standard Maintenance Dialog
	Disable( BACKBUTTON );
	nType = SdWelcomeMaint( szTitle, szMsg, nType );
	Enable( BACKBUTTON );
    nResult = NEXT;

	// Show Uninstall Confirmation Dialog
    if ( nType = REMOVEALL ) then
		nResult = MessageBox( SdLoadString( IFX_MAINTUI_MSG ), MB_YESNO );
		if (nResult != IDYES ) then
			goto Dlg_Start;
		endif;
	endif;

Dlg_SdFeatureTree:
	if ( nType = MODIFY ) then
		szTitle = "";
		szMsg = SdLoadString( SD_STR_COMPONENT_MAINT_MSG );
		nResult = SdFeatureTree( szTitle, szMsg, TARGETDIR, "", -1 );
		if ( nResult = BACK ) goto Dlg_Start;
    endif;

Dlg_ObjDialogs:
    nResult = ShowObjWizardPages( nResult );
    if ( ( nResult = BACK ) && ( nType != MODIFY ) ) goto Dlg_Start;
    if ( ( nResult = BACK ) && ( nType = MODIFY ) ) goto Dlg_SdFeatureTree;

	switch(nType)

        case REMOVEALL:
						
			// Ensure that all previously installed features are removed
			// for media that supports updating.
			MediaGetData( MEDIA, MEDIA_FIELD_MEDIA_FLAGS, nMediaFlags, szIgnore );
			
			if( nMediaFlags & MEDIA_FLAG_UPDATEMODE_SUPPORTED ) then
				FeatureRemoveAllInMediaAndLog();
			else
				FeatureRemoveAllInMedia();
			endif;

        case REPAIR:
				
			// Changed for DevStudio 9, Disk1 files are now always updated when installed
			// so when running from ADDREMOVE we need to prevent these files from being
			// updated since this will result in files being updated that are locked by the setup.
			// Updating these files when running from ADDREMOVE should not be needed since updates
			// are not run directly from Add/Remove.
            if( ADDREMOVE ) then
                // Reinstall all previously installed features, except
                // disk1 features.
                FeatureUpdate( "" );
            else
                // Reinstall all previously installed features.
                FeatureReinstall();
            endif;

    endswitch;
 
end;

//---------------------------------------------------------------------------

// OnMaintUIBefore

// Maintenance UI Sequence - Before Move Data

// The OnMaintUIBefore event is called by OnShowUI when the setup is

// running in maintenance mode. By default this event displays UI that

// allows the end user to add or remove features, repair currently

// installed features or uninstall the application.

// Note: This event will not be called automatically in a

// program...endprogram style setup.

//---------------------------------------------------------------------------

function OnMaintUIBefore()

number nResult, nType, nMediaFlags;

string szTitle, szMsg, szIgnore;

begin

// nType defaults to MODIFY.

nType = MODIFY;

// Beginning of UI Sequence

Dlg_Start:

// Show Standard Maintenance Dialog

Disable( BACKBUTTON );

nType = SdWelcomeMaint( szTitle, szMsg, nType );

Enable( BACKBUTTON );

nResult = NEXT;

// Show Uninstall Confirmation Dialog

if ( nType = REMOVEALL ) then

nResult = MessageBox( SdLoadString( IFX_MAINTUI_MSG ), MB_YESNO );

if (nResult != IDYES ) then

goto Dlg_Start;

endif;

Dlg_SdFeatureTree:

if ( nType = MODIFY ) then

szTitle = "";

szMsg = SdLoadString( SD_STR_COMPONENT_MAINT_MSG );

nResult = SdFeatureTree( szTitle, szMsg, TARGETDIR, "", -1 );

if ( nResult = BACK ) goto Dlg_Start;

endif;

Dlg_ObjDialogs:

nResult = ShowObjWizardPages( nResult );

if ( ( nResult = BACK ) && ( nType != MODIFY ) ) goto Dlg_Start;

if ( ( nResult = BACK ) && ( nType = MODIFY ) ) goto Dlg_SdFeatureTree;

switch(nType)

case REMOVEALL:

// Ensure that all previously installed features are removed

// for media that supports updating.

MediaGetData( MEDIA, MEDIA_FIELD_MEDIA_FLAGS, nMediaFlags, szIgnore );

if( nMediaFlags & MEDIA_FLAG_UPDATEMODE_SUPPORTED ) then

FeatureRemoveAllInMediaAndLog();

else

FeatureRemoveAllInMedia();

endif;

case REPAIR:

// Changed for DevStudio 9, Disk1 files are now always updated when installed

// so when running from ADDREMOVE we need to prevent these files from being

// updated since this will result in files being updated that are locked by the setup.

// Updating these files when running from ADDREMOVE should not be needed since updates

// are not run directly from Add/Remove.

if( ADDREMOVE ) then

// Reinstall all previously installed features, except

// disk1 features.

FeatureUpdate( "" );

else

// Reinstall all previously installed features.

FeatureReinstall();

endif;

endswitch;

end;

[regular] Seg start

https://regex101.com/r/i88gXH/2/


NEUTRAL*         02JAN-WE-0001  ICNNRT(SELTYO)** ** *WLP 
ICN ALTERNATE GMP/NRT ALTERNATE HND
1  #H15906 Y4 B4 H4 M4 N. Q. V. O. ICNNRT 0700 0925      737 0E
        G. R.
    H15906 OPERATED BY T WAY AIR 
2  $7C1100 Y4 B4 K. N. Q. M. T. W. ICNNRT 0725 0950      737 0E
        O. R. X. S. L. H. E- J- F- V- G. Z. D- C- A. I- P- U.
3  #H19764 Y4 B4 H. M. Q. V. X. O. ICNNRT 0725 0950      737 0E
        G. R. U. T.
    H19764 OPERATED BY JEJU AIR CO LTD 
4*S#KE5741 Y7 B7 M7 S. H. E. K. L. ICNNRT 0730 1000      738 0E
        U. Q.
    KE5741 OPERATED BY JIN AIR 
>

NEUTRAL* 02JAN-WE-0001 ICNNRT(SELTYO)** ** *WLP

ICN ALTERNATE GMP/NRT ALTERNATE HND

1 #H15906 Y4 B4 H4 M4 N. Q. V. O. ICNNRT 0700 0925 737 0E

G. R.

H15906 OPERATED BY T WAY AIR

2 $7C1100 Y4 B4 K. N. Q. M. T. W. ICNNRT 0725 0950 737 0E

O. R. X. S. L. H. E- J- F- V- G. Z. D- C- A. I- P- U.

3 #H19764 Y4 B4 H. M. Q. V. X. O. ICNNRT 0725 0950 737 0E

G. R. U. T.

H19764 OPERATED BY JEJU AIR CO LTD

4*S#KE5741 Y7 B7 M7 S. H. E. K. L. ICNNRT 0730 1000 738 0E

U. Q.

KE5741 OPERATED BY JIN AIR


/^[1-9]\s{0,2}?(\*S|[#$])/mg

/^[1-9]\s{0,2}?(\*S|[#$])/mg


Match 1
Full match	94-98	`1  #`
Group 1.	97-98	`#`
Match 2
Full match	206-210	`2  $`
Group 1.	209-210	`$`
Match 3
Full match	332-336	`3  #`
Group 1.	335-336	`#`
Match 4
Full match	456-459	`4*S`
Group 1.	457-459	`*S`

Match 1

Full match 94-98 `1 #`

Group 1. 97-98 `#`

Match 2

Full match 206-210 `2 $`

Group 1. 209-210 `$`

Match 3

Full match 332-336 `3 #`

Group 1. 335-336 `#`

Match 4

Full match 456-459 `4*S`

Group 1. 457-459 `*S`

SeatCount https://regex101.com/r/i88gXH/3


[A-Z]([0-9]{1}|[.-])\s{1}

[A-Z]([0-9]{1}|[.-])\s{1}

참고 : https://regex101.com/r/z2cD9W/1 https://regex101.com/r/zMulAd/1

Chtml 클래스에 파일 오픈 추가


void CMFChtmlView::OnFileOpen()
{
	// TODO: 여기에 명령 처리기 코드를 추가합니다.
	
	CFileDialog fileDlg(TRUE, NULL, NULL, OFN_HIDEREADONLY, NULL);

	if(fileDlg.DoModal() == IDOK)
		Navigate2(fileDlg.GetPathName(), 0, NULL);
}

void CMFChtmlView::OnFileOpen()

{

// TODO: 여기에 명령 처리기 코드를 추가합니다.

CFileDialog fileDlg(TRUE, NULL, NULL, OFN_HIDEREADONLY, NULL);

if(fileDlg.DoModal() == IDOK)

Navigate2(fileDlg.GetPathName(), 0, NULL);

}

c# 연결 리스트 정렬하기


 LINQ to entities query 
// Descending
SearchFareInfoList = SearchFareInfoList.OrderByDescending(o => o.NoShowFee).ToList();

// Contain : True False
SegmentOrder = AirSegmentData.Select(o => o.Key).Contains(SegmentRef).ToString();

// 있으면 값 가져오기
if (AirSegmentData.Select(s => s.Key).Contains(SegmentRef).ToString() == "True")
   SegmentOrder = AirSegmentData.Single(s => s.Key == SegmentRef).SegmentOrder;

LINQ to entities query

// Descending

SearchFareInfoList = SearchFareInfoList.OrderByDescending(o => o.NoShowFee).ToList();

// Contain : True False

SegmentOrder = AirSegmentData.Select(o => o.Key).Contains(SegmentRef).ToString();

// 있으면 값 가져오기

if (AirSegmentData.Select(s => s.Key).Contains(SegmentRef).ToString() == "True")

SegmentOrder = AirSegmentData.Single(s => s.Key == SegmentRef).SegmentOrder;

자바 디비 연결

JAVA


package javaDB;
import java.sql.*;
import com.microsoft.sqlserver.jdbc.*;

public class test {

public static void main(String[] args) {
		
		// Declare the JDBC objects.
		Connection con = null;
		CallableStatement cstmt = null;
		ResultSet rs = null;
		
		try {
			// Establish the connection. 
			SQLServerDataSource ds = new SQLServerDataSource();
			
			//ds.setIntegratedSecurity(true);
			ds.setServerName("localhost");
			ds.setPortNumber(1433); 
			ds.setDatabaseName("WSP_IBE");
			ds.setUser("user01");
			ds.setPassword("password01");
			con = ds.getConnection();
			 
	        	// Execute a stored procedure that returns some data.
            		cstmt = con.prepareCall("{call dbo.uspGetAircraft()}");
            		//cstmt.setInt(1, 50);
            		rs = cstmt.executeQuery();

	        	// Iterate through the data in the result set and display it.
	        	while (rs.next()) {
	            		System.out.println("aircraft_code: " + rs.getString("aircraft_code"));
	            		System.out.println("aircraft_english: " + rs.getString("aircraft_english"));
	            		System.out.println();
	        	}
	        }
	        
		// Handle any errors that may have occurred.
	    	catch (Exception e) {
	    		e.printStackTrace();
	    	}

	   	finally {
	    		if (rs != null) try { rs.close(); } catch(Exception e) {}
	    		if (cstmt != null) try { cstmt.close(); } catch(Exception e) {}
	    		if (con != null) try { con.close(); } catch(Exception e) {}
	    	}
	}
}

package javaDB;

import java.sql.*;

import com.microsoft.sqlserver.jdbc.*;

public class test {

public static void main(String[] args) {

// Declare the JDBC objects.

Connection con = null;

CallableStatement cstmt = null;

ResultSet rs = null;

try {

// Establish the connection.

SQLServerDataSource ds = new SQLServerDataSource();

//ds.setIntegratedSecurity(true);

ds.setServerName("localhost");

ds.setPortNumber(1433);

ds.setDatabaseName("WSP_IBE");

ds.setUser("user01");

ds.setPassword("password01");

con = ds.getConnection();

// Execute a stored procedure that returns some data.

cstmt = con.prepareCall("{call dbo.uspGetAircraft()}");

//cstmt.setInt(1, 50);

rs = cstmt.executeQuery();

// Iterate through the data in the result set and display it.

while (rs.next()) {

System.out.println("aircraft_code: " + rs.getString("aircraft_code"));

System.out.println("aircraft_english: " + rs.getString("aircraft_english"));

System.out.println();

}

// Handle any errors that may have occurred.

catch (Exception e) {

e.printStackTrace();

}

finally {

if (rs != null) try { rs.close(); } catch(Exception e) {}

if (cstmt != null) try { cstmt.close(); } catch(Exception e) {}

if (con != null) try { con.close(); } catch(Exception e) {}

}

JSP mysql


<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %> 
 
<html> 
<head> 
<title>Connection with mysql database</title> 
</head> 
<body>
<h1>Connection status </h1>

<table>

<%
String connectionURL = "jdbc:mysql://localhost:3306/IBE?characterEncoding=UTF-8&serverTimezone=UTC"; 

Connection connection = null; 
PreparedStatement pstmt = null;
ResultSet rs = null;

try{
	Class.forName("com.mysql.jdbc.Driver").newInstance(); 
	connection = DriverManager.getConnection(connectionURL, "user02", "user99");
    
    String query ="SELECT airline_code,airline_korean FROM IBE.Airlines where airline_code = ?";
    //String query ="SELECT airline_code,airline_korean FROM IBE.Airlines";
    
    pstmt = connection.prepareStatement(query); 
    pstmt.setString(1,"OZ");
       		
    rs = pstmt.executeQuery();
    
    while(rs.next()){	
    	String airline_code = rs.getString("airline_code");
    	String airline_korean = rs.getString("airline_korean"); 
%>
	 	<tr>
			<td width="100"><%=airline_code%></td>
			<td width="100"><%=airline_korean%></td>
		</tr>	
<%
    }
}
catch(Exception ex){
	out.println(ex.toString());
}finally{
	if(rs != null) try{rs.close();}catch(SQLException ex){}           
	if(pstmt != null) try{pstmt.close();}catch(SQLException ex){}   
	if(connection != null) try{connection.close();}catch(SQLException ex){}
}

%>

</table>

</body> 
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>

<%@ page import="java.sql.*" %>

<html>

<head>

<title>Connection with mysql database</title>

</head>

<body>

<h1>Connection status </h1>

<table>

String connectionURL = "jdbc:mysql://localhost:3306/IBE?characterEncoding=UTF-8&serverTimezone=UTC";

Connection connection = null;

PreparedStatement pstmt = null;

ResultSet rs = null;

try{

Class.forName("com.mysql.jdbc.Driver").newInstance();

connection = DriverManager.getConnection(connectionURL, "user02", "user99");

String query ="SELECT airline_code,airline_korean FROM IBE.Airlines where airline_code = ?";

//String query ="SELECT airline_code,airline_korean FROM IBE.Airlines";

pstmt = connection.prepareStatement(query);

pstmt.setString(1,"OZ");

rs = pstmt.executeQuery();

while(rs.next()){

String airline_code = rs.getString("airline_code");

String airline_korean = rs.getString("airline_korean");

<tr>

</tr>

}

catch(Exception ex){

out.println(ex.toString());

}finally{

if(rs != null) try{rs.close();}catch(SQLException ex){}

if(pstmt != null) try{pstmt.close();}catch(SQLException ex){}

if(connection != null) try{connection.close();}catch(SQLException ex){}

}

</table>

</body>

</html>

jsp paramerer


<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page import = "java.sql.DriverManager" %>
<%@ page import = "java.sql.Connection" %>
<%@ page import = "java.sql.PreparedStatement" %>
<%@ page import = "java.sql.ResultSet" %>
<%@ page import = "java.sql.SQLException" %>

<%
String connectionURL = "jdbc:mysql://localhost:3306/IBE?characterEncoding=UTF-8&serverTimezone=UTC"; 

Connection connection = null; 
PreparedStatement pstmt = null;
ResultSet rs = null;

String code = request.getParameter("code"); //Code
if(code == null) code="";

String Decode = code;

try{
	if(code.length()==2){
		Class.forName("com.mysql.jdbc.Driver").newInstance(); 
		connection = DriverManager.getConnection(connectionURL, "user02", "user99");
	    
	    String query ="SELECT airline_code,airline_korean FROM IBE.Airlines where airline_code = ? LIMIT 0, 1";
	    
	    pstmt = connection.prepareStatement(query); 
	    pstmt.setString(1,code);
	       		
	    rs = pstmt.executeQuery();
	    
		    while(rs.next()){
		    	Decode = rs.getString("airline_korean");
		    }
	   
		    out.println(Decode);
	   
    }else	
    	out.println(code);
	
}
catch(Exception ex){
	out.println(ex.toString());
}finally{
	if(rs != null) try{rs.close();}catch(SQLException ex){}           
	if(pstmt != null) try{pstmt.close();}catch(SQLException ex){}   
	if(connection != null) try{connection.close();}catch(SQLException ex){}
}
%>

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>

<%@ page import = "java.sql.DriverManager" %>

<%@ page import = "java.sql.Connection" %>

<%@ page import = "java.sql.PreparedStatement" %>

<%@ page import = "java.sql.ResultSet" %>

<%@ page import = "java.sql.SQLException" %>

String connectionURL = "jdbc:mysql://localhost:3306/IBE?characterEncoding=UTF-8&serverTimezone=UTC";

Connection connection = null;

PreparedStatement pstmt = null;

ResultSet rs = null;

String code = request.getParameter("code"); //Code

if(code == null) code="";

String Decode = code;

try{

if(code.length()==2){

Class.forName("com.mysql.jdbc.Driver").newInstance();

connection = DriverManager.getConnection(connectionURL, "user02", "user99");

String query ="SELECT airline_code,airline_korean FROM IBE.Airlines where airline_code = ? LIMIT 0, 1";

pstmt = connection.prepareStatement(query);

pstmt.setString(1,code);

rs = pstmt.executeQuery();

while(rs.next()){

Decode = rs.getString("airline_korean");

}

out.println(Decode);

}else

out.println(code);

}

catch(Exception ex){

out.println(ex.toString());

}finally{

if(rs != null) try{rs.close();}catch(SQLException ex){}

if(pstmt != null) try{pstmt.close();}catch(SQLException ex){}

if(connection != null) try{connection.close();}catch(SQLException ex){}

}

C# ToUniversalTime 으로 사용하기

SqlDataAdapter StoredProcedure


class DBData
{
static string connectionString = "server= 111.222.333.444;uid=id;pwd=pppp;database=UEUE";

public static string QueueHTML(string SID)
{
SqlConnection conn = new SqlConnection(connectionString);
SqlDataAdapter da = new SqlDataAdapter();
DataSet QUEUE = new DataSet();

try {
conn.Open();

SqlCommand cmd = conn.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "QueueList";

SqlParameter paramSID = cmd.Parameters.Add("@SID", SqlDbType.Char, 3);
paramSID.Direction = ParameterDirection.Input;
paramSID.Value = SID;

da.SelectCommand = cmd;
da.Fill(QUEUE, "QUEUE");

XslCompiledTransform xslt = new XslCompiledTransform();
StringWriter stringWriter = new StringWriter();

xslt.Load("Queue.xsl");

XsltArgumentList args = new XsltArgumentList();

XmlDocument xml = new XmlDocument();

string dbXML = QUEUE.GetXml();
xml.LoadXml(dbXML);

xslt.Transform(xml, args, stringWriter);

string Content = stringWriter.ToString();

return Content;
}
catch (Exception ex)
{
//클라이언트에게 예외를 던진다.
//throw ex;
string Err = ex.ToString();
return "";
}

finally
{

}

}
}

class DBData

{

static string connectionString = "server= 111.222.333.444;uid=id;pwd=pppp;database=UEUE";

public static string QueueHTML(string SID)

{

SqlConnection conn = new SqlConnection(connectionString);

SqlDataAdapter da = new SqlDataAdapter();

DataSet QUEUE = new DataSet();

try {

conn.Open();

SqlCommand cmd = conn.CreateCommand();

cmd.CommandType = CommandType.StoredProcedure;

cmd.CommandText = "QueueList";

SqlParameter paramSID = cmd.Parameters.Add("@SID", SqlDbType.Char, 3);

paramSID.Direction = ParameterDirection.Input;

paramSID.Value = SID;

da.SelectCommand = cmd;

da.Fill(QUEUE, "QUEUE");

XslCompiledTransform xslt = new XslCompiledTransform();

StringWriter stringWriter = new StringWriter();

xslt.Load("Queue.xsl");

XsltArgumentList args = new XsltArgumentList();

XmlDocument xml = new XmlDocument();

string dbXML = QUEUE.GetXml();

xml.LoadXml(dbXML);

xslt.Transform(xml, args, stringWriter);

string Content = stringWriter.ToString();

return Content;

}

catch (Exception ex)

{

//클라이언트에게 예외를 던진다.

//throw ex;

string Err = ex.ToString();

return "";

}

finally

{

}