92 Discussion / Question Topics
Remove Filter  | Good Day All i have the Following that table [CODE] ID | ACTV |VENU |STUD | TRIES ===================================== 1 1 4 162 0 2 4 5 104 0 3 8 5 138 0 4 15 2 68 0 5 15 4 291 0 6 21 4 171 0 7 22 …  |
| | Good Day All i have the Following Function [CODE] private static void OMEGA_calcActvEqv() { SqlConnection conn1 = CommonFunctions.getSQLConnectionForThread(THREAD_DATA[0].ToString()); string SQL = "SELECT MAX(D.OFFS + 1) * MAX(R.OFFS + 1) FROM TBL_ROWS R, TBL_CLMN D; SELECT MAX(OFFS + 1) FROM TBL_ROWS;"; SqlCommand cmd = new SqlCommand(SQL, conn1); SqlDataReader rdr = cmd.ExecuteReader(); … |
| | Good Day all i have the Following Query [CODE] DECLARE @CurrentTime DATETIME SET @CurrentTime = CURRENT_TIMESTAMP select tr.Descr [Room], tb.Purpose [Purpose], tb.Description [Description], convert(varchar,datepart(hour,tb.starttime))+':'+convert(varchar,datepart(minute,tb.starttime)) [Start Time], convert(varchar,datepart(hour,tb.endtime))+':'+convert(varchar,datepart(minute,tb.endtime)) [End Time], tu.name [Requested by] from tbl_booking tb inner join tbl_resource tr on tb.resources = tr.id inner join tbl_user tu on tu.id = … |
| | Good Day All I have a ASP.NET app. There is a button one of the pages. I have placed a Break point in the Click event and when i click the Button it does not even go to the Break Point it shows this [IMG]http://www.tiyaneproperties.co.za/SSIS/Strange.jpg[/IMG] Thanks |
| | Good Day All am restoring a Database Programatically in Sql. Now if the backup is located in the remote machine i use a Share [QUOTE]\\Vuyiswa\MyShare\[/QUOTE] but i will get the Following Error [QUOTE] Exception caught in: ExecuteStoredProc: The file "\\Vuyiswa\Databases\\REmoteTest33.mdf" is on a network path that is not supported for … |
| | Good Day all i have created a Global Variable as depicted in the following Pic [URL="http://www.tiyaneproperties.co.za/SSIS/pic1.JPG"]http://www.tiyaneproperties.co.za/SSIS/pic1.JPG[/URL] The Following Screen-shot shows how i created my Variable and its Properties [URL="http://www.tiyaneproperties.co.za/SSIS/pic2.JPG"]http://www.tiyaneproperties.co.za/SSIS/pic2.JPG [/URL] and the Following Screen-shot shows the Script Editor Properties [URL="http://www.tiyaneproperties.co.za/SSIS/pic3.JPG"] http://www.tiyaneproperties.co.za/SSIS/pic3.JPG[/URL] and the Last pic is the code that write … |
| | Good Day All I have the Following Query [CODE] DECLARE @CurrentTime DATETIME SET @CurrentTime = CURRENT_TIMESTAMP select tr.Descr [Room], tb.Purpose [Purpose], tb.Description [Description], convert(varchar,datepart(hour,tb.starttime))+':'+convert(varchar,datepart(minute,tb.starttime)) [Start Time], convert(varchar,datepart(hour,tb.endtime))+':'+convert(varchar,datepart(minute,tb.endtime)) [End Time], tu.name [Requested by] from tbl_booking tb inner join tbl_resource tr on tb.resources = tr.id inner join tbl_user tu on tu.id = … |
| | Good Day All I have a Package created and hosted in a Machine(Theresa) that has SQL 2008 and i have my Development Machine(Vuyiswa) that has IIS and am Debugging from the my machine. i have a ASP.NET 2.0 App and am executing a Package that in another machine. The First … |
| | Good Day all it is Probably a long day, i cant think Straight now. i have a table that looks like this [CODE] Nodeid Parent Description Type Curr ========================================================================================== 89 NULL Compulsory 1 10 90 89 B1052 3 10 2820 89 One of 2 10 [COLOR="red"] 4113 89 B1061 3 …  |
| | Good Day All I have SQL 200 and a SQL 2008 in one Machine. At First there was SQL 2000 and i install SQL 2008. Now we have a ilog Application written in C++. am not sure what that developer uses to connect to the SQL. Now the Application can … |
| | Good Day all I have a Usercontrol that has a Gridview and its hosted on my aspx page and the aspx page is defined like this [CODE]<%@ Page Language="C#" MasterPageFile="~/SubjectMasterPage.master" AutoEventWireup="true" CodeFile="SubjectStruct.aspx.cs" Inherits="SubjectStruct" Title="o! WebEditor : Subject Structure" %> <%@ Register Src="SubjectNote.ascx" TagName="SubjectNote" TagPrefix="uc4" %> <%@ Register Src="SubjectDetails.ascx" TagName="SubjectDetails" TagPrefix="uc2" … |
| | Good Day all I have an SP that is defined like this [CODE]ALTER PROCEDURE [dbo].[sp_Constraints_Update] @xml ntext, @TTBLType varchar(5) AS set nocount on DECLARE @xmldoc int DECLARE @sql varchar(8000) -- In one long sql string do all of the following --Create an internal representation of the XML document. EXEC sp_xml_preparedocument … |
| | Good Day all I have a Sp that is written like this set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[Import_RegistrationsXM] @xml ntext AS set nocount on DECLARE @doc int EXEC sp_xml_preparedocument @doc OUTPUT, @xml TRUNCATE TABLE _RegistrationXM INSERT INTO _RegistrationXM SELECT * FROM OPENXML ( @doc , 'Import/Item' … |
| | Good Day ALL I have a UserControl that has a Dropdownlist. In the Hosting Page i have a Ultrawebgrid that gets updated based on the Selecteindexchange event the the dropdown. I have have another Control on the Left hand side that needs to be Updated on Selecteindexchange of the Drop … |
| | Good Day All After Binding my Grid with 3 Columns , i found out that it Duplicates the Columns Twice. like this [code] Activity || Staff Member || Cycles || Activity || Staff Member || Cycles || Activity || Staff Member || Cycles =============================================================================== C[1] || DR Vuyiswa || Year … |
| | Good Morning All i have a Ultrawebgrid defined like this [code] <igtbl:UltraWebGrid ID="ultraGridStudentsMixTypes" runat="server" Style="left: -8px; top: 375px" OnInitializeLayout="ultraGridStudentsMixTypes_InitializeLayout" OnDataBound="ultraGridStudentsMixTypes_DataBound" OnSelectedRowsChange="ultraGridStudentsMixTypes_SelectedRowsChange"> <Bands> <igtbl:UltraGridBand> <RowEditTemplate> <br /> <p align="center"> <input id="igtbl_reOkBtn" onclick="igtbl_gRowEditButtonClick(event);" style="width: 50px" type="button" value="OK" /> <input id="igtbl_reCancelBtn" onclick="igtbl_gRowEditButtonClick(event);" style="width: 50px" type="button" value="Cancel" /></p> </RowEditTemplate> <RowTemplateStyle BackColor="Window" BorderColor="Window" BorderStyle="Ridge"> <BorderDetails … |
| | Good Morning All I have the Following code that sends an e-mail, let me first post the markup and the code behind. The following is the markup of my page [code] <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head … |
| | Good Evening All Am amazed that i cant use the Replace Function , its Probably the long that i had. i have the Following code [CODE] String Username = "Vuyiswa"; String Password = "secret"; String strBody = @"<p>Thank you for using !obooking System <br><br> Username:(Username)<br><br>Password:(Password)<br<br>Kind Regards !oBooking</p>"; strBody = Regex.Replace(strBody,Username,"(Username)"); … |
| | Good day All I have a Challenge. I have the Following StoredProcedure that is doing the Following [code] IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[temp]')) drop table [temp] --Creation of Temp1 SELECT MTN.ID,S.DESCR,ISNULL(MTN.CYCLETEMPLATE,C.CYCLES) AS CYCLETEMPLATE into temp FROM TBL_STAFF S INNER JOIN MTM_ACTV_STAFF MTN ON S.ID = … |
| | Good Afternoon All , i have a page that does some updates, and i have my own progress bar and there is a strange Ajax(i think so) progress bar that is showing and its making my page to be slow. [IMG]http://www.vbforums.com/attachment.php?attachmentid=71442&stc=1&d=1244725295[/IMG] As you can see there is a Small black … |
| | Good Day all i have a Ultrawebgrid i n my page and i display Data in this Way [CODE] STAFF CYCLES ========================= Galloway A Ms 20,22,23,24,25,26 Gama, E 20,22,24,25 Grieve S Ms 20,25,26 Jones D Dr 24,26[/CODE] and a user can select the Staff in the Grid by Holding a … |
| | Good Morning All For you to help me and understand my problem, i will have to explain everything in details. I have a usercontrol with with a textbox, this texdtbox changes values so am trapping the values on textchange. so i have set it to "Autopostback="true"" in the usercontrol and … |
| | Good Day All I have a textbox in a userControl and it has a Property "Autopostback" set to true, and as i know , this is encapsulated from the hosting page. now i need to set this property to true so that the Gridview in the Hosting page can recognize … |
| | Good Day I have a page that has a UserControl on it and i want to call a Method in the Host page that will fire when a textbox texchanged event got fire. [URL="http://www.vbforums.com/attachment.php?attachmentid=71093&stc=1&d=1242811920"]http://www.vbforums.com/attachment.php?attachmentid=71093&stc=1&d=1242811920[/URL] i want to Invoke the Function the the "[B]Remove Staff [/B]" Button that has been Disabled … |
| | Good Evening All I have a web Application that is compiling well with no Errors, i have Compiled each separately and worked well excluding the setup Project. i have to be honest, i once use the clean before i rebuilded the Solution and i came across this challenge. here is … |
| | Good Afternoon All I have a Control that looks like this [URL="http://www.tiyaneproperties.co.za/fading_Control.JPG"]http://www.tiyaneproperties.co.za/fading_Control.JPG[/URL] And this Control looks differently from versions of Internet explorer. In 7 and up it shows are the links shows you and in internet explorer 6 it shows the whole of it , if the list grows, it … |
| | Good Morning All I have a table named “Final” with Values like this [code] ID || DESCR || CYCLE ====================================== 1 || Earl G || 20 2 || Earl G || 21 3 || Earl G || 22 4 || Davidson I Dr || 20 5 || Davidson I Dr … |
| | Good Morning All I have a Menu Control [CODE] <asp:Menu ID="Menu2" runat="server" BackColor="AliceBlue" BorderColor="SteelBlue" BorderStyle="Solid" BorderWidth="1px" DynamicHorizontalOffset="2" Font-Names="Verdana" Font-Size="8pt" ForeColor="Black" Height="20px" OnMenuItemClick="menureplace_MenuItemClick" StaticSubMenuIndent="10px" Width="87px"> <DynamicHoverStyle BackColor="#7C6F57" ForeColor="White" /> <DynamicMenuStyle BackColor="White" BorderColor="Black" BorderStyle="Solid" BorderWidth="1px" /> <StaticSelectedStyle BackColor="#5D7B9D" /> <DynamicSelectedStyle BackColor="#5D7B9D" /> <DynamicMenuItemStyle Font-Names="Verdana" Font-Size="10pt" ForeColor="#C00000" HorizontalPadding="5px" VerticalPadding="2px" /> <Items> <asp:MenuItem Text="Replace … |
| | Good Morning Friends, I have a SP that is Supposed to Restore a Database from a Backup. In some Clients this works well but in those particular client its a Problem. The version is SQL 2005. Here is the Code that fails [CODE] set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go … |
| | Good Day All i have a table that carries a Field that has data like this [CODE] 10101010101010[/CODE] Now the Function that adds this 1's and 0's is working like this. If its selected insert "1" else "0", So if i can interpret the above if will be [CODE] 1 … |
| | Good Afternoon All In all my Application, i used to write my login screen and i will not have a problem. i have inherited the ASP.NET Application that uses a login control. Below are the pics of how it looks here is a code for Forget Password link [CODE] protected … |
| | Good Morning Guys I have a Problem on my ASP.NET Application. I have a Web setup Project created and it used to work fine before, but now , when i try to Compile it it gives a Warning [QUOTE]"Object reference not set to an instance of an object"[/QUOTE] And when … |
| | Good Morning All I have a WebSetup Project and a Installer Class. I want to accept User [QUOTE]Database, Server,Username,Password and E-mail[/QUOTE] This is what i did so far. I have created a Websetup Class installer that looks like this [CODE] namespace ClassLib { [RunInstaller(true)] public class ClassLib : Installer { … |
| | Good Morning All Am trying to Store the username of the User that will be loged on. choose to use the Profile, and i have done the following from the Web Config file [CODE] <profile enabled ="true"> <properties> <add name ="Username" readOnly ="false" allowAnonymous ="true"/> </properties> </profile> [/CODE] And am … |
| | Good evening Everyone My VS is behaving n an unnormal way. I have 9 Project in a Solution and i have set one of the Projects as a Startup Project and created a Setup project, after i Built it to create an exe, The Project that gets Started is not … |
| | Good Evening alL I have an ASP.NET Front end that seaches the Dates in certain Ranges. here is my Data Layer. [CODE] public DataTable Get_Date_by_Month(String Username,String Datefrom, String Dateto) { con = new OleDbConnection(strcon); DataTable Details = new DataTable(); da = new OleDbDataAdapter(); cmdselect = new OleDbCommand(); cmdselect.CommandTimeout = 0; … |
| | Good Afternoon All i think its Firday fever, am tired. I think this Happens sometimes. let me get to the Problem. Am doing an OleDb Project I have an Access DB and the table is Users , here are the Field and dataType ID = Autonumber(int) Firstname = TEXT LastName … |
| | Good Afternoon Guys Let me start here. i have been Builidng Win App and this was an easy task there. Now i have a Page that has a Datagridview and am Displaying this from a DataTable Through a SP like this [CODE] Create Proc [sde].[Check_Active_Valuation]as select LIS_KEY,FUNC_KEY,SUBSTRING(CONVERT(VARCHAR,V2.ADD_DATE,1),1,13)AS [ADD DATE],V2.NEW_IMPROVED_VALUE AS … |
| | hi All i realy need your Help. i have a Table named Property, this Table has a Field named "Lis_key" and Attrib_code and "Func_key", my Table can look like this [CODE] Lis_key ===========Attrib_code========================= Func_key====== ===================================================================== 01424545 1212033993 PV000000 01424545 Null GEOSS001 01424545 Null GEOSS002 01424545 Null GEOSS003 [/CODE] Figuire:1 Now … |
| | i have one Problem, please tell me what should i keep in mind, about the following Errors "Application uses Value of wrong type for the current operation" This is th errors in vb6 Set prmNum_key = ComNum_key.CreateParameter("Num_Key", adBigInt _ , adParamInput) Set prmExtension = ComExtension.CreateParameter("Extension", adBigInt _ , adParamInput, , … |
| | My company is using a third party software designed by other private company. there is a point where there is data redundacny on our tables and it requires me to do the data cleaning. i thought it would be better to fix the incorrect field with the procedure with those … |
| | hi Please help,i have installed Visual studio .net 2003. i code in C#, when i write my code, for example "Console." imidiately before i complete the statement it closes the application requesting to restart the application, and i wrote my code on a notepad making sure that the code is …  |
The End.