Hi! I'm using Microsoft Visual Studio 2008, Microsoft SQL Server Management Studio. I need help. I cant figure out this if else statement for this condition: ///to check condition either the way ID exist in database ///if not exist then way ID can be delete ///if exist, message box appear show message this cannot be delete My code was be like this. Protected Sub btnDelete_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnDelete.Click Dim i As Integer Dim iResult As Integer Dim hypWayID As HyperLink Dim chkRemove As New CheckBox Dim clsWay As New Way() Try For i = …

Member Avatar
Member Avatar
+0 forum 4

Hi all :) Before i'm starting futher more about my problem. lets me tell a short description about my program. user will choose path ID (retrieve all this data from table TPATH of database SDO) that they want to delete. before the path ID would be delete, it will compare this path ID from table TTENS of database SDO and table TPATH of database SDO where this two table share the same column namely as M_C and also share the same database. ![Capture4.PNG](/attachments/large/4/9f0610598636750086f8c6fcb873b442.PNG "align-center") this comparing method was write in Stored Procedure(SP). **this SP will be called on this class …

Member Avatar
+0 forum 0

Hi all. As mention on the title above, i got an error `Fill: SelectCommand.Connection property has not been initialized` Anyone here have any idea or suggestion on how to solve this error? My code (.aspx.vb) for this program Protected Sub btnDelete_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnDelete.Click Dim i As Integer Dim result As DataSet Dim hypID As HyperLink Dim chkRemove As New CheckBox Dim clsPath As New Path() Try For i = 0 To grdPath.Rows.Count - 1 chkRemove = DirectCast(grdPath.Rows(i).FindControl("chkRemove"), CheckBox) hypID = DirectCast(grdPath.Rows(i).FindControl("hypID"), HyperLink) If chkRemove.Checked Then result = clsPath.getComparedPathID(chkRemove.Text) End If Next i lblErrorMessage.Text …

Member Avatar
Member Avatar
+0 forum 4

windows 7 home premimum x64 access denied for saving files to app_data folder and any other folder in the projects root directory. Code below is what im using to save and getting... doc.Save(Server.MapPath("~/App_Data/Logs")) I get a couple access to path denied msgboxes. Set a few permissions and no go.

Member Avatar
Member Avatar
+0 forum 2

Good Morning, I am this --- close to turning in a final project and my instruction states that for my asp.net vb application that we will need to turn in an executable or runtime. Since my project is .aspx I realize that an executable is not required but that I should turn in a runtime. My question? I am confused by the "turn in a runtime"? What files am I to include. I have attempted to reach my instructor but he is out of the office due to his wife's maternity leave. Guidance would be greatly appreciated. Thank you, Danielle

Member Avatar
+0 forum 0

I have the following code for connecting to an Oracle DB [code] using Oracle.DataAccess.Client; // C# ODP.NET Oracle managed provider OraDb= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP)(HOST=ORASRVR)(PORT=1521)) ) (CONNECT_DATA= (SERVER=DEDICATED) (SERVICE_NAME=ORCL) ) ) string oradb = "Data Source=//192.168.100.108;User Id=hr;Password=hr;"; // C# string oradb = "Data Source=(DESCRIPTION=" + "(ADDRESS=(PROTOCOL=TCP)(HOST=ORASRVR)(PORT=1521))" + "(CONNECT_DATA=(SERVICE_NAME=ORCL)));" + "User Id=hr;Password=hr;"; OracleConnection conn = new OracleConnection(oradb); // C# OracleConnection conn = new OracleConnection(); // C# conn.ConnectionString = oradb; conn.Open(); // C# string sql = " select department_name from departments where department_id = 10"; // C# OracleCommand cmd = new OracleCommand(sql, conn); cmd.CommandType = CommandType.Text; conn.Close(); // C# conn.Dispose(); // C# [/code] …

Member Avatar
Member Avatar
+0 forum 1

This is in class file Imports Microsoft.VisualBasic Imports System.IO Imports System.Collections.Generic Public Class FileSrch '' File Search Options Public Enum FileSearchOptions YearFirst MonthFirst DateinExtension NormalFiles End Enum Public Shared Function GetSearchcriteria(ByVal DatetoSearchwith As Date, ByVal Filename As String, ByVal FileExtension As String, ByVal SearchOptions As FileSearchOptions) Select Case SearchOptions Case FileSearchOptions.YearFirst Return String.Format("{0}_{1:yyyyMMdd}{2}", Filename, DatetoSearchwith, FileExtension) Exit Select Case FileSearchOptions.MonthFirst Return String.Format("{0}_{1:yyyyMMdd}{2}", Filename, DatetoSearchwith, FileExtension) Exit Select Case FileSearchOptions.NormalFiles Return String.Format(Filename + FileExtension) Case FileSearchOptions.DateinExtension Dim ExtensionFormat As String = (Convert.ToInt32(DatetoSearchwith.ToString("mm")).ToString() & DatetoSearchwith.ToString("dd")) '' Month in Double Digit If DatetoSearchwith.Month > 9 Then ExtensionFormat = (DatetoSearchwith.ToString("mmm")(0) & DatetoSearchwith.ToString("dd")) End If …

Member Avatar
+0 forum 0

1. Imports System.IO 2. Create class "CreateThumbnails" or any class and place following function inside that class You need one function to response call back to main function Function ImageAbortDummyCallback() As Boolean Return False End Function

Member Avatar
+0 forum 0

The End.