hery

Hello, How to run exe program from windows service using c#. This is mycode: [CODE]System.Diagnostics.Process.Start(@"E:\PROJECT XL\INI SQLLOADER\ConsoleApplication2\ConsoleApplication2\ConsoleApplication2\bin\Debug\ConsoleApplication2.exe");[/CODE] When i run this service not happening. Please tell me whats wrong with my code. Thanks

Hello, How to display list process, when i run sql*loader in c#. I mean when i run sql*loader from cmd windows, i get list process how many row has been inserted. But when i run SQL*Loader from C#, i can't get process SQL*Loader. This is my code: [CODE] string strCmd, …

Hello, How to run command SQLLoader Oracle in c#. I try my sourcode for run this SQLLoader, but nothing happen and error "No process is associated with this object.". Please tell me how i fix it. Thanks. This is my code: [CODE] System.Diagnostics.Process process1; process1 = new System.Diagnostics.Process(); process1.EnableRaisingEvents = …

Hello, How to import csv data into Oracle using c #. Where data to be imported 3GB in size and number of rows 7512263. I've managed to import csv data into Oracle, but the time it takes about 1 hour. How to speed up the time it takes to import …

I want to question how to embed variable value in sqldatasource session parameter in c#. This is mycode: default.aspx: [CODE] <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:Ora2011 %>" ProviderName="<%$ ConnectionStrings:Ora2011.ProviderName %>" SelectCommand="SELECT ID, CATEGORY_NAME FROM (:INVENT_CATEGORY)"> <SelectParameters> <asp:SessionParameter Name="INVENT_CATEGORY" SessionField="INVENT_CATEGORY" Type="String" /> </SelectParameters> </asp:SqlDataSource> [/CODE] C#: [CODE]protected void Page_Load(object sender, EventArgs e) …

Hello all, I want to ask for you, how to i create function with optional parameter in webservice and how i call this function in my application. Thanks this is my code... Webservice: [code] [WebMethod(Description = "Input data ke Database")] public bool inputAllData(string myTable, [Optional, DefaultParameterValue("")] string field1, [Optional, DefaultParameterValue("")] …

hello all, i want to ask how to i set variable in asp:sqldatasource in sqlcommand in asp.net c#.... This is my code asp.net [code] <dx:ASPxListBox ID="lsAssignToko" runat="server" DataSourceID="SqlDataSource6" TextField="NAMA" ValueField="ID" AutoPostBack="true" EnableCallbackMode="True" SelectionMode="CheckColumn" onselectedIndexChanged="lsAssignToko_SelectedIndexChanged"> <Columns> <dx:ListBoxColumn FieldName="ID"/> <dx:ListBoxColumn FieldName="NAMA" /> </Columns> </dx:ASPxListBox> <asp:SqlDataSource ID="SqlDataSource6" runat="server" ConnectionString="<%$ ConnectionStrings:Ora2010 %>" ProviderName="<%$ ConnectionStrings:Ora2010.ProviderName …

this is my code:: [code] TextBox[] tbArray = new TextBox[] { TextBox1, TextBox1, TextBox1 }; for (int j = 0; j < tbArray.Length ; j++) { tbArray[j].Visible = true; } [/code] this code is success but only one textbox show not three textbox.. Can any one help me. Thanks

this is my code: [code] sdsNamaSales.SelectCommand = "SELECT ID, NAMA FROM REF_SALES_OFFICER WHERE" + " SOF_TYPE = '" + ddlJenisSales.SelectedValue + "' AND KOT_ID = '" + ddlKota.SelectedValue + "'"; // insert nama sales manual ddlNamaSales.Items.Clear(); ddlNamaSales.DataSource = sdsNamaSales; ddlNamaSales.DataTextField = "NAMA"; ddlNamaSales.DataValueField = "ID"; ddlNamaSales.DataBind(); ddlNamaSales.Items.Insert(0, new ListItem("--PILIH--", "--PILIH--")); …

hello all, i want to question how to i get value query sql in asp.net c# example: this is my sample code: [CODE] string no_hp = ""; string queryNoHP = "SELECT NO_HP FROM REF_OWNER WHERE ID = '" + ID.Text + "'"; [/CODE] i want to how to get value …

this is my code [code] MSFlexGrid1.Clear On Error Resume Next Set rs = cn.Execute("SELECT count(*) FROM ENTRY_GAJI_BAGIAN") If Err.Number <> 0 Then MsgBox "Cannot open recordset due to this error: " & Err.Description MousePointer = vbDefault Exit Sub End If If rs(0) > 0 Then MSFlexGrid1.Rows = rs(0) + 1 …

this is my code: [code] $user = "sa"; $pass = ""; $host = "192.168.1.246"; $db ="payroll_hti"; $dbhandle = mssql_connect($host, $user, $pass) or die("Couldn't connect to SQL Server on $myServer"); [/code] i access from my computer with ip 192.168.1.100 this is my error report: Unable to connect to your database server …

hi, how the way backup database in sql server 2000 with syntax sql for one month, i mean query. Thank's

Hello, when i input to database show error cannot convert type varchar to type numeric.. I' m using convert(numeric, quantity). Where my quantity is empty. Please help me. Thanks

I'm using netbeans 6.7.1 and i'm trying to connect to the sql server 2000 database that i have created and i get this error message, SQL Exception: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host pc05801, port 1433 has failed. Error: "connect timed out. Verify the connection properties, check that an …

how to import data from excel to sql server using vb.. Thanks

This is my code: [code] Private Sub cmdHitung_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdHitung.Click Dim tempBASIC As String If strChrDec = "." Then strFormatDec = "#,##0.00;(#,##0.00)" formatSAVE = "############0.#0" Else strFormatDec = "#.##0,00;(#.##0,00)" formatSAVE = "############0,#0" End If If Val(Format(Convert.ToDouble(txtGajiPokok.Text), formatSAVE)) > 0 Then If Trim(txtGPPilih.Text) = …

Hello, all I want to question for all. How to i make script like monitoring real time market data using Java, ex: [url]http://www.rabotransact.com/wps/portal/rtwpub[/url]. Can you help me??? Thank's

this is my code.. In my code i have succesful get table column name. But i want the first table column name showing not all. Thanks' [code] rs.Open(strSQL, adcLEDGER, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockPessimistic) Flds = adrCURR.Fields TotalCount = Flds.Count For Each fld In Flds MsgBox(fld.Name) Next [/code]

this is my code. [code] Private Sub cmdSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdSearch.Click temp = "DaftarGaji" modPY.LookUp("SELECT * FROM MS_UMR ORDER BY TAHUN", strCONNECT, 0, 1, temp) End Sub [/code] [code] Public Sub LookUp(ByVal strRecordtoSearch As String, ByVal strCONNECT As String, ByVal KeyFieldPos As Short, ByVal …

This is m y code:: [code] Private Declare Function WritePrivateProfileString Lib "kernel32" Alias "WritePrivateProfileStringA" (ByVal lpApplicationName As String,[B] ByVal lpKeyName As Any[/B], [B]ByVal lpString As Any[/B], ByVal lpFileName As String) As Long Private Declare Function GetPrivateProfileString Lib "kernel32" Alias "GetPrivateProfileStringA" (ByVal lpApplicationName As String, [B]ByVal lpKeyName As Any[/B], ByVal lpDefault …

This is my code after upgrade vb6 code: [code] Public ReadOnly Property TUJUHResult() As Object Get Dim vrn7Result As Object 'UPGRADE_WARNING: Couldn't resolve default property of object vrn7Result. Click for more: 'ms-help://MS.VSCC.v90/dv_commoner/local/redirect.htm?keyword="6A50421D-15FE-4896-8A1B-2EC21E9037B2"' 'UPGRADE_WARNING: Couldn't resolve default property of object TUJUHResult. Click for more: 'ms-help://MS.VSCC.v90/dv_commoner/local/redirect.htm?keyword="6A50421D-15FE-4896-8A1B-2EC21E9037B2"' TUJUHResult = vrn7Result End Get End …

This is my code in vb6. How to in vb.net??? Please tell me. I'm stuck in here.. [code] Public Function LookUpST(ByRef adcCON As ADODB.Connection, strSTT As String, Optional vntHasil As Variant, Optional vntRETURN As Variant, Optional vntNEXT As Variant, Optional vntNEXT_TO As Variant) As Boolean On Error GoTo ErrHndl Dim …

this is my code in vb6. How to in vb.net??? Please tell me?? Thank's [code] Public Function Tgl_Max(Month As Integer, YEAR As Integer) As Integer Tgl_Max = Day(DateSerial(YEAR, Month + 1, 0)) End Function [/code]

Hello all, How i can delete value variable using vb.net.. I try this one.. strTBL_T5_Lookup = "" or strTBL_T5_Lookup = nothing But value is still in there. Why my code is not working. Please tell me??? Thank's

[code] Dim workspace(1 To 4) As Long ' (1)=left (2)=top (3)=right (4)=bottom SystemParametersInfo &H30, 0, workspace(1), 0 ' &h30 = get workspace size Dim X As Long, Y As Long, w As Long, h As Long X = workspace(1) * Screen.TwipsPerPixelX Y = workspace(2) * Screen.TwipsPerPixelY w = workspace(3) * …

In VB6 i use "Form.Show VbModal" to prevent user to interact with other window than current one. I wanna know how to do this in VB.Net? Thank's

I have a textbox with "10000" i want to format it to "10,000.00". How i can make it in vb.net ..

I want to question for all. I use Visual Studio 2008. Why everytime i show my form, i must declaration variable. Example [code] Dim form1 as new Form1 form1.show() [/code] Why i can't use form1.show() direction. My friend can use form1.show direction without declaration variable in Visual Studio 2008. What's …

Hello, How can input number to database where my field in database data type money.. This is my code: [code] Private Sub SaveData() Try If adcLEDGER.State = ADODB.ObjectStateEnum.adStateOpen Then adcLEDGER.Close() adcLEDGER.ConnectionString = strCONNECT adcLEDGER.Open() Catch ex As Exception MsgBox(ex.Message) End Try Try Dim vANSWER vANSWER = vbYes modPY.LookUpST(adcLEDGER, "SELECT * …