.Net,Asp.Net and Sharepoint Forum

.Net,Asp.Net and Sharepoint Forum » Recent Posts http://www.codedefiner.com/forum/ Post your queries here en-US Thu, 11 Mar 2010 03:07:48 +0000 http://bbpress.org/?v=1.0.2 <![CDATA[Search]]> q http://www.codedefiner.com/forum/search.php jain on "How to create referiential integrity between two lists?" http://www.codedefiner.com/forum/topic.php?id=305#post-429 Thu, 04 Feb 2010 10:17:07 +0000 jain 429@http://www.codedefiner.com/forum/ hi, EmployeeDetails and LibraryDetails are tables? If these are tables, create primary key on EmployeeDetails for EmployeeId column and foriegn on LibraryDetails tabel EmployeeId column with reference to the primary key column of EmployeeDetails table. This will solve your problem. I missed any thing? elizas on "How to use "Windows Explorer" option to the Visual Studio tools menu for" http://www.codedefiner.com/forum/topic.php?id=307#post-428 Thu, 28 Jan 2010 06:57:10 +0000 elizas 428@http://www.codedefiner.com/forum/ Most of the times we need to refer to the folder path containing the project in Visual Studio platform, for that we need to go to Windows Explorer and then search for the folder name containing the project you are currently working on, then select the folder for further actions.Now by using this tip we can directly add the "Windows Explorer" in Visual Studio Tools menu for easy access. And by selecting the "Windows Explorer" option from the Tools menu we can directly go to the folder containg currently edited file selected of the running project in Visual Studio environment. Steps to Create new menu option in Tools Menu section : 1.Open the any ASP.NET Project using Visual Studio . 2.Click Tools menu, then External Tools... option from Tools Menu, then click Add. 3.Now enter the following data in respective textbox provied: Title: Windows Explorer Command: explorer.exe Arguments: /select,"$(ItemPath)" 4.Just leave Initial directoy textbox as blank, and click OK. 5.Now click on Tools menu, Windows Explorer option. Windows Explorer will open the folder path for the current project with selected the current file we are working on. bijayani on "ASP.Net Validators within Sharepoint" http://www.codedefiner.com/forum/topic.php?id=306#post-427 Thu, 28 Jan 2010 06:53:22 +0000 bijayani 427@http://www.codedefiner.com/forum/ Quite informative.. subhendu on "ASP.Net Validators within Sharepoint" http://www.codedefiner.com/forum/topic.php?id=306#post-426 Thu, 28 Jan 2010 06:51:00 +0000 subhendu 426@http://www.codedefiner.com/forum/ Nice post Eliza! I am sure Sharepoint guys in my wing would be glad. Will share this link with them. elizas on "ASP.Net Validators within Sharepoint" http://www.codedefiner.com/forum/topic.php?id=306#post-425 Thu, 28 Jan 2010 06:37:35 +0000 elizas 425@http://www.codedefiner.com/forum/ Many a times we have requirements of adding different client side validations on the web pages and the most convenient way to do this in ASP.Net is to use the existing set of validator controls.In SharePoint when we design custom webparts which takes some data as input, we might need to add some client side validations using ASP.Net validator controls, but there are a few things that always need to be taken care of while using ASP.Net validator controls within SharePoint custom webparts 1. Within a webpart we might have more than one control triggering server side postbacks. In this case the validator controls will validate with each and every postback, but the actual need might be to only validate the form with a single postback event, let's say through the "SUBMIT" button. To avoid this, one need to set the CausesValidation property to false for all those controls causing server side postabacks where you do not want the form to get validated. e.g. CausesValidation="false" 2. A SharePoint page can generally contain multiple webparts. So, if we have an ASP.Net validator control integrated within one webpart it's always going to create issues with the postback events from within other webparts present on the same page. To overcome this issue and restrict the validation to a specific webpart, ValidationGroup property can be used with a unique name within a specific webpart. All the controls (validator controls and controls to be validated) coming under a common validation logic should have the same ValidationGroup name. e.g. ValidationGroup="UniqueGroupName" 3. After having all these checks in place, there still remains a big problem which needs to be handled for ASP.Net validators within SharePoint. With ASP.Net validators within a webpart, when you try to edit the webpart properties, it does not allow you to save the changes within the property pane because of the validators (even with ValidationGroups set). To fix this you need to check for the Form Mode within the Page Load event of the webpart and then disable the ASP.Net validator controls when the form is in either EDIT or NEW mode. e.g. If SPContext.Current.FormContext.FormMode = SPControlMode.Edit Or SPContext.Current.FormContext.FormMode = SPControlMode.New Then 'Set the visibility of the required field control to False End If Note: From the above mentioned points, Point 1 & 2 are generic points which can be followed (or needs to be followed) inside general ASP.Net web pages as a better programming practice. vaibhavss on "How to create referiential integrity between two lists?" http://www.codedefiner.com/forum/topic.php?id=305#post-424 Mon, 18 Jan 2010 05:56:19 +0000 vaibhavss 424@http://www.codedefiner.com/forum/ Hi, I am running into a problem where I am having two lists say EmployeeDetails and LibraryDetails. In LibraryDetails i am having a lookup column say EmployeeId which derives from EmployeeDetails-->ID column. Now as the library details containg details books issued to the employees having EmployeeId in LibraryDetails-->EmployeeId column. If we delets the EmployeeDetails list item it can be removed and leaving LibraryDetails-->EmployeeId column leaving as "NULL". Please suggest how to restring deleting the ListItem which is lookuped in other list. Thanks In Anticipation. Vaibhav Bhagwat peter on "Service broker and MSMQ" http://www.codedefiner.com/forum/topic.php?id=304#post-423 Wed, 30 Sep 2009 06:52:32 +0000 peter 423@http://www.codedefiner.com/forum/ both are Queuing technologies only provided by Microsoft. Service broker is useful whenever you want maintain data in Queue at database(SQL Server 2005 & SQL Server 2008) and MSMQ(Microsoft Message Queue) is useful whenever you want to maintain Queue at application side srujana on "Service broker and MSMQ" http://www.codedefiner.com/forum/topic.php?id=304#post-422 Mon, 28 Sep 2009 07:17:02 +0000 srujana 422@http://www.codedefiner.com/forum/ What is service broker and MSMQ? codedefiner on "CLR integration in SQL Server" http://www.codedefiner.com/forum/topic.php?id=101#post-419 Sun, 20 Sep 2009 19:23:30 +0000 codedefiner 419@http://www.codedefiner.com/forum/ hi, EXEC sp_configure 'show advanced options' , '1'; go reconfigure; go EXEC sp_configure 'clr enabled' , '1' go reconfigure; you can enable service broker in SQL Server 2005 & SQL Server 2008. For more <a href="http://www.codedefiner.com/vbnet/CLRinSQL.aspx" rel="nofollow">http://www.codedefiner.com/vbnet/CLRinSQL.aspx</a> peter on "CLR integration in SQL Server" http://www.codedefiner.com/forum/topic.php?id=101#post-418 Sun, 20 Sep 2009 18:56:43 +0000 peter 418@http://www.codedefiner.com/forum/ Can you provide sample code for SQLCLR? srujana on "CLR integration in SQL Server" http://www.codedefiner.com/forum/topic.php?id=101#post-194 Sun, 13 Sep 2009 09:30:40 +0000 srujana 194@http://www.codedefiner.com/forum/ to know more about CLR integration in SQL Server visit <a href="http://www.codedefiner.com/vbnet/CLRinSQL.aspx" rel="nofollow">http://www.codedefiner.com/vbnet/CLRinSQL.aspx</a> peter on "CLR integration in SQL Server" http://www.codedefiner.com/forum/topic.php?id=101#post-193 Sun, 13 Sep 2009 09:28:58 +0000 peter 193@http://www.codedefiner.com/forum/ how to execute .Net programms in SQL Server? srujana on "Joins" http://www.codedefiner.com/forum/topic.php?id=32#post-126 Sun, 23 Aug 2009 16:37:51 +0000 srujana 126@http://www.codedefiner.com/forum/ Sometimes we have to maintain relation between two tables. maintaining relationship between tables in database with keys is called join. To join two tables, the column data types should be same on which the relation ship is maintaining. srujana on "subquery" http://www.codedefiner.com/forum/topic.php?id=33#post-125 Sun, 23 Aug 2009 16:32:07 +0000 srujana 125@http://www.codedefiner.com/forum/ A subquery is nothing but a query nested with in another query. Eg: Select * from emp_sal with (nolock) where emp_id in (Select id From emp_info with (Nolock)) Here "Select id From emp_info with (Nolock)" is called subquery. srujana on "primary key & Unique key" http://www.codedefiner.com/forum/topic.php?id=34#post-124 Sun, 23 Aug 2009 16:29:23 +0000 srujana 124@http://www.codedefiner.com/forum/ primary key is nothing but unique key for a table with no Null value Unique key also same as primary key but it may have Null values. Differences between Primary key and Unique key <ul> <li>primary key does not have Null values, but Unique key may have i.e, Primary Key = Unique + No Null values Unique Key = Unique + it may have Null values </li> <li>One table contains only one primary key, but it may contains more than one unique keys.</li> </ul> peter on "Alter table" http://www.codedefiner.com/forum/topic.php?id=31#post-123 Sun, 23 Aug 2009 16:23:29 +0000 peter 123@http://www.codedefiner.com/forum/ Alter Table [Table Name] Add Default (default value) For [Column Name] Eg: If you have emp table with id and salary column and both are numeric data types. Now you want to set default value 10000 for Salary column Alter Table emp Add Default (10000) For [salary] peter on "Alter table" http://www.codedefiner.com/forum/topic.php?id=31#post-122 Sun, 23 Aug 2009 16:07:52 +0000 peter 122@http://www.codedefiner.com/forum/ how to set default value for a column? jain on "Alter table" http://www.codedefiner.com/forum/topic.php?id=31#post-121 Sun, 23 Aug 2009 16:04:57 +0000 jain 121@http://www.codedefiner.com/forum/ We can also add identity column to existing table Alter Table [Table Name] Add id Numeric Identity(1,1) In Identity(1,1), first value 1 represents starting value and second value 1 represents incremental value. Eg: Alter Table emp_info Add emp_id Numeric Identity(1,1) peter on "Alter table" http://www.codedefiner.com/forum/topic.php?id=31#post-120 Sun, 23 Aug 2009 16:01:23 +0000 peter 120@http://www.codedefiner.com/forum/ how to add identity column to existing table? jain on "Alter table" http://www.codedefiner.com/forum/topic.php?id=31#post-119 Sun, 23 Aug 2009 15:57:58 +0000 jain 119@http://www.codedefiner.com/forum/ you can add column to existing table by using Alter Table [Table Name] Add [Column Name] [Column DataType] Eg: If you have a table emp_info with two columns sno,id. You want add one more column name to that table, then use following SQL Query to add column Alter Table emp_info Add name varchar(50) srujana on "Normalization" http://www.codedefiner.com/forum/topic.php?id=30#post-118 Sun, 23 Aug 2009 15:21:36 +0000 srujana 118@http://www.codedefiner.com/forum/ Normalization is the process of designing table structure for an application. The main aim of Normalization is to reduce the redundant table data to very minimum. The advantages of Normalization are <ul> <li>by using normalization data maintenance is simplified</li> <li>it allows data retrieval at optimal spped</li> <li>it improves the quality of design for an application by rationalization of table data</li> </ul> jain on "primary key & Unique key" http://www.codedefiner.com/forum/topic.php?id=34#post-117 Sun, 23 Aug 2009 15:02:36 +0000 jain 117@http://www.codedefiner.com/forum/ what is primary key and what is Unique key? and differences between them? rahim on "subquery" http://www.codedefiner.com/forum/topic.php?id=33#post-116 Sun, 23 Aug 2009 15:00:45 +0000 rahim 116@http://www.codedefiner.com/forum/ what is subquery and how to write subquery? mohan on "Joins" http://www.codedefiner.com/forum/topic.php?id=32#post-115 Sun, 23 Aug 2009 14:58:43 +0000 mohan 115@http://www.codedefiner.com/forum/ what is join? srujana on "Alter table" http://www.codedefiner.com/forum/topic.php?id=31#post-114 Sun, 23 Aug 2009 14:57:19 +0000 srujana 114@http://www.codedefiner.com/forum/ how to add column to table by Alter statement? peter on "Normalization" http://www.codedefiner.com/forum/topic.php?id=30#post-113 Sun, 23 Aug 2009 14:54:10 +0000 peter 113@http://www.codedefiner.com/forum/ What is Normalization and what are the advantages of Normalization? peter on "Global.asax" http://www.codedefiner.com/forum/topic.php?id=29#post-112 Fri, 21 Aug 2009 01:26:17 +0000 peter 112@http://www.codedefiner.com/forum/ It will tell the server what to do when the application first started or what to do when the application ended. It has several events like Application_Start, Application_End and so on..,which are executed whenever application started and whenever application ended. The events of an global.asax file are Application_Start: This will executed whenever application started. Application_End: This will executed whenever application ended. Application_Error: This will executed whenever application has some errors. Session_Start: This will executed whenever new session started in application. Session_End: This will executed whenever session ended. jain on "Global.asax" http://www.codedefiner.com/forum/topic.php?id=29#post-111 Fri, 21 Aug 2009 01:17:19 +0000 jain 111@http://www.codedefiner.com/forum/ What is global.asax file and how it is useful for an Asp.Net Application? srujana on "group by clause" http://www.codedefiner.com/forum/topic.php?id=28#post-110 Thu, 20 Aug 2009 10:33:56 +0000 srujana 110@http://www.codedefiner.com/forum/ hi, group by name itself has it's meaning. It is use ful to group the one or more columns in a table. For example, if we have a table called employee_info which has salaries of all employees. Columns of table are employee Id, branch, salary paid and month. If we want to know how much salary are we paying for all employees then we have to sum the all salaries based on month. Query look like "Select month,sum(salary) From employee_info with (nolock) Group by month" then we can get the total salary paid to all employees each month. Even you can group the more than one column also. For example, in the above example itself if we want to know to total salary paid to each branch for each month then we can pull data by suing below query "Select branch,month,sum(salary) From employee_info with (nolock) Group by branch,month" then we will get data based on branch and month rahim on "group by clause" http://www.codedefiner.com/forum/topic.php?id=28#post-109 Thu, 20 Aug 2009 10:22:44 +0000 rahim 109@http://www.codedefiner.com/forum/ what is group by clause and how use it? codedefiner on "19 Practical Points to be remembered while working on project/software Company" http://www.codedefiner.com/forum/topic.php?id=27#post-108 Wed, 19 Aug 2009 17:01:06 +0000 codedefiner 108@http://www.codedefiner.com/forum/ hi I agree with you Questpond. Even I am following the same principles what you mentioned. It is helpful for every person who are working in a group. keep it up. Questpond on "19 Practical Points to be remembered while working on project/software Company" http://www.codedefiner.com/forum/topic.php?id=27#post-107 Wed, 19 Aug 2009 11:55:56 +0000 Questpond 107@http://www.codedefiner.com/forum/ Introduction This article will talk about some important points we should note while working with tight dead line project. I am sure every one has some or other important points to share while working with software companies and projects. Do put your points here I will consolidate and make nice list, which will help the software professional community. I have been writing and recording lot of architecture related videos on design patterns, UML , estimation and C# projects. You can see the sample videos at <a href="http://www.questpond.com/FreeDesign1.htm" rel="nofollow">http://www.questpond.com/FreeDesign1.htm</a> . There is life outside projects….your life and your family. Love your work but not your project or the company. Many developers after a certain amount of time become possessive about the project and the company. Try to come on time and go on time. So that you do not get saturated and work on the project for a longer time and effectively. Do not try be a hero in the project. Because heroes also have to go through all hardships. So believe in equal load distribution which is not only good for the project but also for you on long run. Every project has parasite developers. In short every project has developers who constantly take help from others thus bringing down productivity. Yes its is possible that those are your friends , but remember one thing do not give fish to the needy teach him how to fish. If you are project manager you should analyze such kind of developers and ask for replacement and if you are a developer avoid doing their work from start to finish. Yes give them hint but do not do complete coding for them. Do not make projects your learning ground. Customer’s pay heavy for making software do not make it a learning ground. In many projects developers try to implement new technologies in mid of the project just by hearing jargons. Do not treat your project people as a resource. Project managers have these jargon of thinking every one as a resource. Thats bookish thinking. Any one working in a project is finally a human with emotions. The time you consider them as resource they will consider you as resource. Try to freeze your requirements before the start of the project. In practical scenarios it is very difficult to control the end customer. But if you can atleast control the changes that will make the project more comfortable. The best way to control changes is by taking official sign offs or non-official sign offs from the end Customer. Test, Test and Test. That’s the key to success for any software project. Do not hide your defects. Developers are the best guys who know where the code will crash. Do not hide it , analyze and fix it. Do not cheat and leave the same till it goes to the end client. Avoid ego issues during project. Many times in project developers and managers get stuck up with ego issues. Sometimes moving back makes the project move further. Tackle bigger problems of the project first. The best way to complete any project is to start those screens which are used by the customer more often. For instance every project has non-frequent masters code them later and start the transaction screens first. Many time developers end up doing nitty gritty work and forget the bigger part of the project. Do not talk about stars. Every project starts with talking about stars but later end up somewhere else. Developers talk about concept of OOP’s , full database normalization , design patterns etc etc. These fundamentals are important but it should not end up with only jargons. Some times practical deadlines makes it impossible to implement these features. Keep yourself flexible and compromise with quality when you have deadlines…..believe me its not a sin if customer is giving you unreasonable deadlines. Maintaining a right project hierarchy is very important i.e. the A model. In A model you have one senior person at the top , project manager , team leader , senior developers and then juniors. The right proportion of people from each grade is important. On any level if you have too much concentration you will have ego issue and promotion issues. Make yourself visible. If you think you have done something good show it , advertise it , make it visible. Will help you during your assesment. Avoid getting in to project politics. Peace of mind is the most important thing. Getting in to egos and politics will only complicate things. If you are working on maintenance project upgrade yourself time to time. In case you are maintaining some other Developers code do not criticize the code. Who knows in what circumstances was the project made. If you are project manager in the project do not make it a compulsory rule that you will never touch coding. Remember juniors respect their seniors if they sit with them for development and know their difficulties. If any resource is working on a project for more than a year his performance comes down. Prepare a proper KT plan and bring in new resources and roll the old resources off for some better prospects. Avoid unnecessary meetings. srujana on "dataset to xml file" http://www.codedefiner.com/forum/topic.php?id=26#post-106 Tue, 18 Aug 2009 12:27:05 +0000 srujana 106@http://www.codedefiner.com/forum/ we can write dataset data to an XML file by using dataset object "WriteXml" method. <code>ds.WriteXml(Server.MapPath("path of the XML file"))</code> for more <a href="http://www.codedefiner.com/datasettoxml.aspx" rel="nofollow">http://www.codedefiner.com/datasettoxml.aspx</a> peter on "dataset to xml file" http://www.codedefiner.com/forum/topic.php?id=26#post-105 Tue, 18 Aug 2009 12:23:13 +0000 peter 105@http://www.codedefiner.com/forum/ how to write dataset table data to xml file peter on "MSIL" http://www.codedefiner.com/forum/topic.php?id=17#post-104 Sun, 16 Aug 2009 12:45:44 +0000 peter 104@http://www.codedefiner.com/forum/ Yes. A couple of simple examples are that you can throw exceptions that are not derived from System.Exception, and you can have non-zero-based arrays.