.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Post New Web Links

ASP.NET what should be my goal for next one year??

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :ASP.Net

i just completed a project with linq to sql and it was my first ever project after coming out of school. it was good for me as my first project taught me linq to sql. i learned a little bit of javascript and learned a little abt SQL server 2005 with that project.
Now, i really want to make career in asp.net and thus need guidance in getting on right track to learn everything related to asp.net.
How, to advance my skill in asp.net? Which technology should i focus on to get expertise? What should be my goal for next one year? After how much knowledge, i will be prepared for MCTS (70-515)?

i just completed a project with linq to sql and it was my first ever project after coming out of school. it was good for me as my fi

View Complete Post

More Related Resource Links

Editor's Note: A New Year-A Fresh Perspective


The results of our reader survey are in. This month, Howard Dierking shares the takeaways.

Howard Dierking

MSDN Magazine January 2008

Editor's Note: A New Year-A New Vista


Josh Trupin revs the engine to get us all ready for Windows Vista.

Joshua Trupin

MSDN Magazine January 2007

Editor's Note: Celebrating Our 20-Year Milestone


The world of software development is all about milestones. At the lowest level, a programmer has to create a certain set of functions in a fixed amount of time, and is then judged on this performance.

Joshua Trupin

MSDN Magazine January 2005

Help: Too many lines of code to achieve a simple goal: keep my NULL SQL values...


Hello all

What is the best way (best practice) to preserve my NULL SQL values in the database
during an insert/update operation (without receiving cast invalid errors)?
Also, how to display a string 'n/a' when a sql value is NULL?

My project is using FormView with Edit/Insert templates and classes to represent my tables

Goal1....: display 'n/a' when there are NULL SQL values in the database
Solution1: I am using ISNULL(field,'') in my store procedure for SELECT statements

Goal2....: if the fields are 'n/a', then save them back in the database as NULL
Solution2: on my insert/edit methods I am having to check the values being passed, i.e:

cmd.Parameters.Add(new SqlParameter("@scope", SqlDbType.NVarChar, 50));

if (item.Scope == "n/a")
 cmd.Parameters["@scope"].Value = DBNull.Value;
 cmd.Parameters["@scope"].Value = item.Scope;

Not to mention that for SQL DateType fields when you use ISNULL(field,'') the return string is '1/1/1900 12:00:00 AM'
and I have to change the field value in every field that represents a date, i.e:

protected void FormView1_DataBound(object sender, Sy

Calculating Full Year Total

Im creating a sales report in SSRS by pointing it at a cube in SSAS.  Im creating calculated members to aggregate my data in various ways so they can be shown on the report.   I have a FACT table containing sales figures and various dimension tables including a server created time dimension.   Ive managed to create pretty much everthing I need (e.g. Current YTD, Prior year YTD).  What I now need is a full year figure to compare current year sales to.   Below is what Im aiming for i.e. the total of 122712 from 2009 appearing against every month in 2010.   Fiscal Year Fiscal Month Count Full Prior Year sales 2009 Apr-09 9805     May-09 9942     Jun-09 8986     Jul-09 9696     Aug-09 8912     Sep-09 10097     Oct-09 11713     Nov-09 10434     Dec-09 8820     Jan-10 10821     Feb-10 11844     Mar-10 11645     Total 122712   2010 Apr-10 3517 122712   May-10 1669 122712   Jun-10 2518 122712   Jul-10 3306 122712   Ive been bashing my head against a brick wall with this one so any help would be gratefully received!

Quater and Year(Urgent)

  The following metric values are dependent upon the Completion data parameter.  Actually, a one to one mapping exist.   Metrics Parameter Count of valid credentials earned by Month Completion Date Parameter Current Month Count of valid credentials earned by Quarter Completion Date Parameter (options include) FY-Q1 FY-Q2 FY-Q3 FT-Q4 Count of valid credentials earned FYTD (Oct 1 = FY start) Completion Date Parameter Fiscal Year     how can i create the Multi select and how can i write the query  in dataset for feting the data from data base table .By defalut current month is selectd in multiselect plz let me know

Date format for Year, Year-Month, and Date (Year-Month-Day) where input is not known

I have a requirement to capture historical events in a table. Now some events will have only Year, some Year/Month, and remaining where Date is known. We should be able to store them in the column and be able to sort etc. When publishing the information, we should be able to publish as was the input, Year only, Year-Month only, or Date. I looked at the newer Date data type. I can insert a 4 digit year, but on retrieving it is YYYY-01-01. I do not know if it has input YYYY or YYYY-MM-DD and is indeed a Date or a Year. I am trying to avoid saving the format information in another column or something. For sorting, when records have same Year, I would have another column to do relative sorting... So question is - what are my best options with SQL/Entity Framework combo. And what others have done, when encountering similar - if any. Thanks in advance. --Sharad 

How I select Start of week is Friday from date of Year ?

Hello everyone, I am tring to solve How i select Start date is Friday from week? Details for which i want to show I have dtmDate column in a query. from that date i display week of that date as per using (ww,dtmDate) as dtmWeek, and parameters are StartDate & EndDate Suppose I select StartDate as 1/1/2007 & End Date as 12/31/2007   I  do not want to show Output as: Weeks                      Column1          Column2 1/1/2007 (Thuesday)       5                     6 1/2/2007 (Wed)               4                     2 | | 1/5/2007  (Friday)            1                      8 1/6/2007 (Saturday)        7                     

Display the Sum of hours and Month Year using sql Query

Hi,  I have,hours(in varchar),Id in table tbl_x ,i need the sum of hours, monthyear(eg. mar 2010)for the last three months.But with two separate queries i am getting these results.but actually i need in the following format   Month/Year      TotalHours-----------------    ----------------Mar 2010            0400Apr 2010             0450-----------------------------------to get month/Year i am using this querySELECT right(convert(varchar, fromdate, 106), 8) from tbl_x where id='11101' for the sum of hours SELECT SUM(CAST(hours AS INT))AS TOTALHRS FROM tbl_x WHERE id='11101'

report expression for month and year

Hi , Can anyone help me how to write a report expression to get the following out put? Actually this value is the month of previous month. I want to set default month name of the parameter to previous month. This is sep.So it should display like this; Aug - 10 Thanks shamen

Calculate Fiscal Year

HI Experts,  I need help in calculating Fiscal year for given Date.  My fiscal year begins on Oct 1st of every year and I also need to calculate Fiscal Day number of year,  EX: if Date in table is 2010-10-5 then my fiscal year start date should be 2010-10-01 and in my next column I should get day of year as 5    any help is greatly appreciated.  thanks, vishal   

Setting Kpi goal dynamically

Hi,  Is it possible to set up Kpi goal dynamically? I want the end user to be able to change the goal when they need it. They are accessing the cube from excel . Thanks, Beney  

Leep Year Issue

I use the following to get the start of a year period, it might be a fiscal or calandar year.Date.Parse(dtrSurveyData.Item("EndDate1").ToString()).AddDays(-364) I'm just setting a label to this date. If the user enters 12/31/2008 as the enddate1 it shows as 1/2/2008, because it was a leep year. I cannot just use the "1/1/" becuase they might be entering 7/1/2009 as the end of the fiscal year period. Any suggestions on how to handle the leep year?

YEAR --WEEK of the YEAR -- DAY of the WEEK to datetime

Good Evening Can someone help me covert a string in the format YEAR --WEEK of the YEAR(1-53)  -- DAY of the WEEK(1-7)to datetime ie 2010-38-6 is today = '2010-09-17'  valid sql server date nb day numbers are 1 to 7, 1= sunday thanks   David          

Simple goal but hard to execute it; Javascript or Asp.Net as best solution?


Hello all,

I've been struggling with this issue and I am sure there is a solution out there.
Basically I am trying to cache locally all the data that is sent to all TextBox(es) bound to a GridView.
Javascript would be best since that data would not be kept in the ViewState but at this point I am open to Asp.Net solution too.

I have a Timer and a GridView which pulls the data from one SQL table every X seconds.
This table has 2 fields: id (uniqueidentifier) and comments (varchar(max)) and the data changes every rapidly.

On every page refresh the whole GridView content is replaced with whatever data is in the table.
So that gives me a few scenarios I can think of....for instance:

First request:
ID=23FF803F-3AF0-45CA-B536-096A8E410BCD; Comments="Step 1"

Second request:
ID=23FF803F-3AF0-45CA-B536-096A8E410BCD; Comments="Step 2"

Goal: I'd like to keep the previous value so that Comments="Step 1, Step 2" and so on.

Bear in mind that on a subsequent request that same ID might not exist anymore and the cached info for that ID should also be gone.

Another idea would be to have a 3rd control (i.e,Label) which would hold all the previous values. That way, the user could see the latest values in the TextBox but all the cached previous

List of Month and Year in SSRS report parameter?

Hi, I have two parameters in my SSRS Report i.e. Month and Year. I want to show the list of all Months in dropdown and years for a particular range say 1995-Current Year.
Can any one suggest me the query for how to get it to work.
Thanks!! MCP
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend