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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SQL architecure basic question

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
Hey, I am new to SQL Server or RDBMS. I am a .Net developer. I would like to get SQL Server installed to my PC. I am seeing Microsoft SQL Server 2005 -> Configuration Tools in my Start Menu/Programs, which has server configuration, Error and usage reporting and Surface area configuration. What are they? Is SQL server already installed in my PC? I heard there are management studio but I am not seeing that. what are they? how do they work? any good article links to explain the basics? Thanks. -Jesu Benin.Software Professional

View Complete Post

More Related Resource Links

Some basic MVC question

  1. In regular asp net I can run (debug) the application but I can either "view in browser" that gives me the option to view the application and write code on same time.

In MVC I can't find this option.

  1. What is the basic DATA MODEL for working with SQL DB.

I mean with no any framework (entity framework, Sub sonic, Link to SQL etc')

I look for basic application that works with data but with no fw.

  1. What is the popular DB framework that working with data.
  2.  I am looking on  mvc series


C# Soup To Nuts  (the best series ever)


I watch some of the MVC video, seems that the music store is good but I have to wait to the other part.

Does any one know and recommend   a Microsoft MVC tutorial?





Very Basic Question - Error message running first page


Hi Everyone,

I am running Windows 7 and I have gone into Control Panel and activated all of the IIS Functions.

The web application I am running was downloaded from the net (and has worked on other machines previously).  Once I downloaded it, I moved it into C:/inetpub/wwwroot/code/main.asp

I am a bit of a novice at this!  But I am hoping someone can point me in the right direction!


I get the following error when I try and run the web application through IE:

"An error occurred on the server when processing the URL. Please contact the system administrator. If you are the system administrator please click here to find out more about this error."

(When i click the "click here" button it just goes to the IIS site).


Appreciate any help I can get!




Client ID basic question


Hi guys,

Is there any problem to use MANUALLY, within a Javascript, the client ID code?

Like that  ctl00_ContentPlaceHolderConteudo_pgtoiframe


I have one iFrame that need to access div style located in the parent page. So I've done that using manually the clientID code. The code works perfectly and It's still working fine right now.

Will I get errors or problems in the future using it in that manner????

Thank you


Basic question



           I m using VS 2005. When I create a website using VS 2005, it doesnt let me choose the solution folder it automatically creates the folder under My Document. Dont know why. I created website under say C:\Project\MyWebsite.


I have a page, with an image whose source is /image/xyz.gif. So I created a folder image under c:\Project\MyWebsite and have xyz.gif. But the page didnt show the image. If the image path is "image/xyz.gif" then it works. Isnt the directory that you create MyWebsite the root directory?.







Basic question about web services


I followed an example on how to create a simple web service that converts celsius to fahrenheit. It seems to work alright. After the conversion it outputs the new value in xml. What do you do with the value that's in xml? Do you use an Xmlreader to read it from the xml, or what is usually done after the value is generated in xml?


Basic Question on .NET CLR in SQL - Calling a function directly?

Hello, I have been reading up on CLR + SQL integration - My aim is to do an e-mail validation by calling RegEx functionality provided by the CLR.However from what I read and if I understand correct - I would need to create a .NET assembly and load it. I was wondering if there is an option to invoke .NET functions directly from SQL [e.g like create a function and access the .NET classes] . ?C# Fan! ananda84(at)gmail(dot)com

Basic Encryption Question

I have been looking at ways of encrypting querystrings and I have found a few good examples.. but, I just want some clarification on what is most often referred to as the EncryptionKey and the characters that are in that key....Is there basically an unlimited number of alphanumeric combinations that could be used in the following code as the encryption key, is there anything that someone should be CAREFUL about including in that key?thanks...using System.Security.Cryptography;private static string EncryptionKey = "!#$a54?3";/// other examples: "r0b1nr0y"///in a try-catch:key = System.Text.Encoding.UTF8.GetBytes(EncryptionKey.Substring(0, 8));DESCryptoServiceProvider des = new DESCryptoServiceProvider(); inputByteArray = Convert.FromBase64String(Input);

Quick basic question about TFS 2010

Is TFS a standalone platform or do I need to install SQL Server 2010 first?     Thanks, Joshua

Animation sample and basic XAML question.

I am trying to put into place the animation sample in http://msdn.microsoft.com/en-us/library/system.windows.media.animation.stringkeyframe.keytime.aspx It doesn't work. I have two questions. 1) The example lists both the XAML and the C# code. It doesn't seem that the two are tied together. In this example is the XAML and C# code just two ways of obtaining the same result? 2) When the Rectangle is constructed in the C# code the properties set and the delegate event 'Loaded' asssigned. How is this event triggered? Just for learning purposes I would like to have this rectangle move across the bounds of the application window when triggered and stop again under user control. I am not sure how to construct the restangle then have it tied to my main window. Thank you. Kevin

(basic) DESCENDANTS question (I think) :-)

I am trying to get (first level) DESCENDANTS' aggregation for two different hierarchy types and it seems that for parent-child hierarchies it works fine (first example) however for regular hierarchies (non parent-child) it does not work, returning the same level's data.  Am I missing something basic here? I would really like to get the aggregation working for non parent-child hierarchies but I'm stumped on the syntax or whether it is doable. thx much for any thoughts! Cos   --Adventure Works -- with Parent/Child Hierarchy -- works fine! with member measures.[Rollup Amount] as   Aggregate(Descendants([Account].[Accounts].CurrentMember,                                             1,                                             SELF),[Measures].[Amount]) select {[Measures].[Amount], measures.[Rollup Amount]      } on 0, nonempty([Account].[Accounts].levels(0).members,[Measures].[Amount]) on 1 from [Adventure Works]

Another basic Data Binding question

3 days ago (thanks to Olaf) I was able to make progress with binding a data collection to a DataGrid. Since then I have searched the web in vain for a VB example to enable me to switch off the DataGrid AutoGenerateColumns and enter my own columns and appropriate Paths to the Collection’s properties.   The following code works fine but I can’t work out how to enter my own individual columns etc. Can anyone give me the syntax for an example of one column please?   Why is it so difficult to find VB examples of WPF demos etc? (Nearly everything is in C#.)   I have some experience in Access VB so have picked VB in trying to use WPF. I would be grateful for any links to VB WPF resources. Option Explicit On Option Strict On Imports System.Collections.ObjectModel Partial Public Class DataGrid_FilledFromCodeBehind Private _ocEng As ObservableCollection(Of EnPlayer) Public Property EngSqd() As ObservableCollection(Of EnPlayer) Get Return _ocEng End Get Set(ByVal value As ObservableCollection(Of EnPlayer)) _ocEng = value End Set End Property Private Sub Window_Loaded(ByVal sender As System.Object, ByVal e As System.Windows.RoutedEventArgs) Handles MyBase.Loaded _ocEng = New ObservableCollection(Of EnPlayer)() For i = 0 To 4 EngSqd.Add(New EnPlayer(ref(i), names(i), ages(i), bat(i))) Next Me.DataCon

Basic Data Access question (ObjectDisposedExpection)

I am just starting to look at .NET 4.0 and Entity Framework 4 and having trouble finding the best way to achieve something. I'll explain with a quick example:I got my CategoryManager class that looks like this:public sealed class CategoryManager { public System.Data.Objects.ObjectSet<Category> Categories { get { try { StoreEntities storeDb = new StoreEntities();                    using (storeDb)                    {                        return storeDb.Categories;                    } } catch (Exception) { //TODO  throw; } } } public List<string> GetCategoryNames() { try { var categories = from category in this.Categories select category.Name; return categories.ToList();

.Net basic question.

Hi,I have a .net solution in C#. There are several .aspx pages in it. These pages have following as their first line. Not able to understand the meaning of it.I am new to it. Any help will be appreciated.<%@ Page language="c#" Codebehind="Abcd.aspx.cs" AutoEventWireup="true" Inherits="Template.Abcd" %>Also, all the more important. If you could suggest some beginners' tutorial for me as I do not have a programming background. I need to work on .Net in C#. Thanks again.

Very basic terminology SQL question

In the example, where Column B depends on Column A...

If I understand correctly, it is the same as saying Column B references Column A.
But would it be false to say, Column A references Column B? (I'm using the word "references" to mean "any form of relationship between two columns" in this example)?

Basic SSL question


Hi everyone,

I have a hosting provider that has given me a shared SSL domain, like https://mysite.sslcert32.com/.

I want to use it for an admin section of the site, just for that little extra security precaution. I have a page called adminLogin.aspx. Is there anything to set up in order to make the connection SSL or anything?

If i go to https://mysite.sslcert32.com/adminLogin.aspx, and then login to the site, it all seems to work and the next page is stil https in the address bar like,


So I guess my question is, is this working? Am i actually making a secure connection or is it just going through the motions?


Basic Web Forms Question Regarding Returning Html To The page


I have a web application I am working on but this is using simple web forms.

Long story short I want to create a commenting system similar to that of google sites for example.

All comments are saved to the database against a user id and submission id (meaning they are relevant to the page they are presented on).

Currently I am displaying them in a table using GridView which is kinda well annoying.

Is there anyway to return custom HTML from the server to a palceholder control or something of the like.

Basically run a for loop and fill up a placeholder control with html that will render appropriatelly

I know, its basic but I am a total noob.

Most basic question - launch form from a hyperlink?

I created my infopath 2003 form and linked it to a forms library on MOSS. But I can't see any way to launch the form except exposing the library and having the users click the New menu item. I'd sure prefer just to have a hyperlink on a page. Is there some way to do this? The form only sends an email, it does not need to populate the library. Thanks.
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