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


Top 5 Contributors of the Month
david stephan
Asad Ali
Fauzul Azmi
Post New Web Links

coding help needed

Posted By:      Posted Date: October 12, 2010    Points: 0   Category :Sql Server
 

Write a SELECT query to show those users who have not purchased a product with the following product’s title:

'Data Modeling ' In the result table, show users’ last names, email addresses, and the role names of these users

 

The table relation is as follows:

USER                                                                   USERROLE                                    ROLE

-------------        &


View Complete Post


More Related Resource Links

Help needed with coding an edit column

  

I have a GridView I've displayed using the following codes:

In the file root/App_Code/ConnectionManager.cs:

using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.Security;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Configuration;

namespace rankings
{
    internal sealed class ConnectionManager
    {
        public static SqlConnection GetConnection()
        {
            string connectionstring = ConfigurationManager.ConnectionStrings["yafnet"].ConnectionString;
            SqlConnection connection = new SqlConnection(connectionstring);
            connection.Open();
            return connection;
        }
    }
}


In the file root/App_Code/prDAC.

Coding / Programming Tips for C#

  
Using proper guidelines and a template-framed style of coding will really helps developer to enjoy the coding with more understandable, reliable code and application development.

The void is invariant

  
while back I described a kind of variance that we've supported since C# 2.0. When assigning a method group to a delegate type, such that both the selected method and the delegate target agree that their return type is a reference type, then the conversion is allowed to be covariant. That is, you can say:

Best Coding Techniques To Improve Performance for SharePoint Applications

  
As more developers write custom code by using the SharePoint Object Model, they encounter common issues that can affect application performance.

The following areas reflect the main issues encountered by developers as they write custom code by using the SharePoint object model:

§ Disposing of SharePoint objects

§ Caching data and objects

§ Writing code that is scalable

Response.BinaryWrite help needed

  

Hi all

Im new to .NET and stuck now, so i hope anyone can help my with my problem.

I have a MS SQL database where i have stored some documents as Binary data. I cant figure out how to retrieve them and show/download them in my browser.

I found some guides online and have try to put something together.


Download.aspx.cs:

private void Write()
 {
 int id = 0;
 string strID = Request.QueryString["id"];
 int.TryParse(strID, out id);

 var db = new ModelDataContext();
 var doc = db.DocumentDatas.Where(x => x.ID == id).FirstOrDefault();

 byte[] byteArray = File.ReadAllBytes(doc);

 Response.BinaryWrite(byteArray);
 }

How do i fill the byteArray with the data?

Thanks in advance :)

/Ryan


WebMatrix shorthand coding?

  

Will there be support for shorthand statements?

Example:

@if(1==1) @: works
@else @: doesn't work

as apposed to;

@if(1==1){
    <text>works</text>
}
else{
    <text>doesn't work</text>
}

Or perhaps ternary opperators? PHP like stuff ...


User messages without hard coding

  

Hi All,

 

How to manage user messages to avoid hardcoding messages accross the web application.

 

Regards,

 

Arun


help needed: Ldap User authentication using userDN and password

  

Hi

Is it possible to authenticate a user using userDN and password? If so, then tell me the syntax.So far i have tried to authenticate using username and password from my c# code using directoryentry which takes the parameters like domainname,username and password. But i need to authenticate using Userdn and password.



helped needed: ASP LDAP authentication failed in IE 8

  

I use the following code to do the user authentication through Active Directory using LDAP.

try
{
entry = new DirectoryEntry("LDAP://" + server, user_name, password);
if (!string.IsNullOrEmpty(entry.Name))
{
EmployeeNetId = entry.Username.Substring(0, 3);

// Retrieve EmployeeId, and Employee Full Name
GetEmployeeId(EmployeeNetId);
}
}
catch
{
EmployeeId = -1;
}

It works for Chrome, Firefox with no problem. But with IE 8, it works sometimes, and failed on some computers. When it failed, I figured that I need to check SSL 2.0 in IE 8 Internet Options.  It's weird because in those computers that IE 8 works, SSL 2.0 is also unchecked.

Am I using some deprecated method? Or How do I specifiy the SSL version options in the LDAP connection?


Invalid length for a Base-64 char array for my coding in ASP.net C#. How to solve it ?

  

Hi Friends ,

I have done encrypted password and decode but i got error  like  this  " Invalid length for a Base-64 char array" .

Pls help . Thanks

 

psswd = txtPassword.Text;

pwed = base64Decode(psswd);

public string base64Decode(string sData)
        {
            System.Text.UTF8Encoding encoder = new System.Text.UTF8Encoding();
            System.Text.Decoder utf8Decode = encoder.GetDecoder();
            byte[] todecode_byte = Convert.FromBase64String(sData);
            int charCount = utf8Decode.GetCharCount(todecode_byte, 0, todecode_byte.Length);
            char[] decoded_char = new char[charCount];
            utf8Decode.GetChars(todecode_byte, 0, todecode_byte.Length, decoded_char, 0);
            string result = new String(decoded_char); return result;
       

Better Coding: Better Coding with Visual Studio 2010

  

From functional IDE improvements to better support for parallel programming, Visual Studio 2010 comes with a host of new features to help meet the needs of today's demanding, ever-changing development environment. Doug Turnure provides an overview of the more important ones and practical advice on how to use them.

Doug Turnure

MSDN Magazine April 2010


Coding Tools: Improved Support For Parallelism In The Next Version Of Visual Studio

  

We take a look at planned support for parallel programming for both managed and native code in the next version of Visual Studio.

Stephen Toub and Hazim Shafi

MSDN Magazine October 2008


Toolbox: Realistic Test Data, Dare Obasanjo's Blog, Color-Coding Tools, and More

  

This month Scott shows how to generate realistic test data, visits Dare Obasanjo's blog, and demonstrates color coding code for better readability.

Scott Mitchell

MSDN Magazine October 2008


Toolbox: Save Coding Time, Manage Compressed Files, and More

  

Save Coding Time, Manage Compressed Files, and More

Scott Mitchell

MSDN Magazine January 2007


Data Points: Efficient Coding With Strongly Typed DataSets

  

Someone once said to me that the hallmark of a good developer is the desire to spend time efficiently. Developers are continually pursuing ways to make coding easier and faster, and to reduce the number of errors.

John Papa

MSDN Magazine December 2004


App Lockdown: Defend Your Apps and Critical User Info with Defensive Coding Techniques

  

Whether you're storing database connection strings, user credentials, or logon info, you'll need to practice good defensive programming techniques to avoid those surprise situations in which your data is exposed. In this article, author Kenny Kerry shows you how.

Kenny Kerr

MSDN Magazine November 2004


Help needed in selecting coulmns from 2 tables using entity framework

  

Hi all,

I have two tabels as mentioned below. I am using entity framework and vs2010.I am not able to write linq query to get data from both the tables. there is one to many relationship(for one category ther can be multiple articles). Please help me out as this is very urgent. Thanks in advance.

1) Article

ArticleID bigint Unchecked
CategoryID int Unchecked
ArticleName varchar(500) Unchecked
ArticleDesc nchar(1024) Unchecked
Categories: 
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