196 Posted Topics
 | [QUOTE=khaled_jawaher;1230203]i want to know how to configure iis in order to access a remote microsoft access database in asp.net.permission how should it be,anonymous iis usrs,... any exact information pls thanks[/QUOTE] well anonymous should be selected. i think accessing the mdb database is not a problem , all you need to … |
| | Re: upload site Step 1 Ask them for FTP credentials Step 2 Download FileZilla , its Free Step 3 Log in with your Filezilla to the ftp, select port 21 Step 4 The Website Files normally stay in http folder copy them and you will find the default files like index Step 5: … |
| | Does the onselectedindexchanged gets Fired ? Place a BreakPoint on it and add a value so that the Javascript test can be true. |
| | Look at this [URL="http://www.dotnetfunda.com/articles/article808-how-to-write-a-simple-login-page-in-aspnet-.aspx"]How to write a Simple Login in ASP.NET[/URL] |
| | i haven't touched Windows app for some time now. But tell me what is the start-up object for the project. Is it a Window or a Class library ?  |
| | So what you want is to Simply Clear the Grid ? If so if you are using a Dataset , you just have to say [CODE]Dataset.Clear();[/CODE] [CODE]DataTable.Clear();[/CODE] Simple ne |
| | Re: ASP.net Ajax Am not sure if you can make a control defined on fly a trigger. [URL="http://msdn.microsoft.com/en-us/library/bb386454.aspx"] http://msdn.microsoft.com/en-us/library/bb386454.aspx[/URL]  |
| | well i created my login system and i manage it myself. on that part every time a user logs in i change the status in the profile in the database as online, and if another user tries to log in with a username that is online, i will just display … |
| | That is not correct , you need to create a parameter. and assign the value of the textbox to that parameter. First you need create a StoredProcedure that will do the inserts like this [CODE]Create proc sp_Add_Record ( @email_id int ) AS INSERT INTO Sample VALUES(@email_id) [/CODE] and in your … |
| | Re: update label you have a long code here . Can you point the line that you are having a problem with ? |
| | It is Very Difficult to Help someone who has not Started something. but logically this means that you need to use a Wizard control and Record the selected Questions and at the end give the results of the Test. |
| | |
| | Look at this [url]http://mysoftskill.blogspot.com/2009/11/syswebformspagerequestmanagerparsererro.html[/url] |
| | Good Day All I have an Sp and UDF. the UDF cant take #tables. so i want to incorporate the functionality that is being provided by the udf and make it part of the code. the first part of my statement creates a solid table that is being used in … |
| | Good Day All. Am binding the treeview from a Database and it gets populated and am sorting it after this way [CODE]SortTree(CurriculumTreeView);[/CODE] [CODE]private void SortTree(TreeView tv) { if (tv.Nodes != null) { for (int i = 0; i < tv.Nodes.Count; i++) { TreeNode node = tv.Nodes[i]; SortNode(node); } } }[/CODE] … |
| | Good Day All i have the Following sp [CODE]SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[sp_Timetable_View] @selectionType varchar(30), -- either Venues, Staff, Subjects, Curricula etc... @selectedItems ntext, @selectedTerms ntext AS /*This Part of the code was Representing the Sp Get_Staff_Cycles_For_TimeTable due to temp table scope , i …  |
| | I think you didnt Search enough, look at this [URL="http://sqlserver2000.databases.aspfaq.com/how-do-i-load-text-or-csv-file-data-into-sql-server.html"] http://sqlserver2000.databases.aspfaq.com/how-do-i-load-text-or-csv-file-data-into-sql-server.html[/URL] [URL="http://nathanbuggia.com/post/Import-a-CSV-File-into-SQL-Server-BULK-INSERT.aspx"] http://nathanbuggia.com/post/Import-a-CSV-File-into-SQL-Server-BULK-INSERT.aspx[/URL] [URL="http://blogs.techrepublic.com.com/datacenter/?p=317"] http://blogs.techrepublic.com.com/datacenter/?p=317[/URL] Kind Regards Vuyiswa Maseko |
| | Good Day I have posted this question before , i cant find it to continue from it. Let me start from Scratch because i did not find a Solution to this problem. in my page am using a Treeview Control show like this [URL="http://www.vuyiswamaseko.com/public/Wrong_Display.JPG"]http://www.vuyiswamaseko.com/public/Wrong_Display.JPG[/URL] and am loading data in SQL … |
| | Good Day All i have a Table with the ID Field that was not an identity Field. This Field has not Duplicates. Now later i want to Change this numeric Field as an Identity Field like this [CODE]--STEP 7 ADD THE IDENTITY BACK IN TABLE MTM_ACTV_STAFF ALTER TABLE [New_Jaco].[dbo].[MTM_ACTV_STAFF] ALTER … |
| | 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 … |
| | First thing, go to your toolbox and Add a Calender control , set the visibility to false, and add a textbox where there value will be passed too and a link button to invoke the calender. in the click event of your link button make the visibility of the calender … |
| | Re: VS 2008 help Good Day i want to help you , but i want to laugh at you on the statement you have made [QUOTE]Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.[/QUOTE] The Version of .NET are not the same and Visual Studios are the … |
| | This is not A Correct Approach for a login. This is simple you are Suppose to count the Records that matches the Where Clause and you have included having and Group by clause and that is incorrect. You need a simple statement like this [CODE]SELECT COUNT(*) FROM UsersPasswords WHERE Username … |
| | Good Day Why dont you mark your Post as Resolved because your post had been resolved here [URL="http://forums.asp.net/p/1477628/3439861.aspx"] http://forums.asp.net/p/1477628/3439861.aspx[/URL] |
| | Good Day These are two different Technologies,there might be a lot of tools that can convert this for you , but i myself i dont trust them , because a lot of them are not going a good Job. I will advice you to rewrite your application in ASP.NET than … |
| | Re: GrdiView use Template Fields like this [CODE] <asp:GridView ID="MYGRid" runat="server" AutoGenerateColumns="false"> <Columns> <asp:TemplateField > <ItemTemplate> <asp:CheckBox ID="ID" runat="server" /> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText ="Name"> <ItemTemplate> <asp:TextBox ID="textbox1" runat="server"></asp:TextBox> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText ="Mobile Number"> <ItemTemplate> <asp:TextBox ID="textbox2" runat="server"></asp:TextBox> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText ="Age"> <ItemTemplate> <asp:TextBox ID="textbox3" runat="server"></asp:TextBox> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText … |
| | Good Day Derice The Url will be Formed like this [QUOTE] [url]http://[Machinename]/[/url][Virtual Directory]/[/QUOTE] That will be the URL. Hope this Helps Vuyiswa Maseko |
| | He is Right, You need to do in Management Studio and use a Create Script. Am not Sure you can do this programatically |
| | This is how you can do it [url]http://www.webcheatsheet.com/ASP/get_current_page_url.php[/url] Kind Regards Vuyiswa Maseko |
| | 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 … |
| | I thought i understood what you wanted to do from the Beginning , can you please rephrase your question again. |
| | Well i think if you write you sql nicely and optimized, i don't think you will need a Data-reader. a Data-reader is known with its great performance. But if you have a little data to Display like drop-down , i will go for a data-table or data-set because the different … |
| | This is not Right [CODE] Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;Integrated Security=True;User Instance=True[/CODE] Go to get the Path and show it to use and we will tell you how to fit in the connection string |
| | If you want to be a good programmer one day, you need to read and practice and make research before you can ask someone. It seems that you did not even try , nor Google. the First thing you can do is to buy a book and read , this … |
| | Really my friend , you need to buy a Book and read. You cant learn everything on the internet. In some Forums they will delete your post. look at this articles [url]http://www.codeproject.com/KB/vb/N-Tier_Application_VB.aspx[/url] [url]http://www.codeproject.com/KB/tips/StoringConstring.aspx[/url] [url]http://www.codeproject.com/KB/cs/NTier.aspx[/url] [url]http://www.codeproject.com/KB/cs/N-Tier22.aspx[/url] [url]http://www.codeproject.com/KB/aspnet/Paging_without_a_Wizard.aspx[/url] Regards Vuyiswa Maseko |
| | 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 … |
The End.