.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

Having difficulty in the following ( Please suggest the way)

Posted By:      Posted Date: September 15, 2010    Points: 0   Category :ASP.Net
 
Hi all, iam facing the difficulty in the following I have stored the image path in to Databse Column named ImagePath Now if there is no Image Path in column then i have to display the 'No Image Found' message  else the Image path  accordingly. I tried the below  but confused SELECTCASE When (ImageInfo.ImagePath = null ) then 'Not Avaliable' when (ImageInfo.ImagePath != null ) then ' ' End As ImagePath How i get it working ????? RegardsRameez    


View Complete Post


More Related Resource Links

Binding WPF grid to ViewModel : Suggest the design

  
I have structure like this I have following structure BaseViewModel ViewModel1: BaseviewModel ViewModel2: BaseViewModel In grid i will be showing the data from both the ViewModel1 and ViewModel2 (some common data is there ) How should i go about this Expected functionality : IF i select any row in the grid i should get respective ViewModel    

Entity Framework and stored procedures with OUTPUT parameters (suggest API)

  
EF does handle stored procedures with OUTPUT parameters, but the generated methods are not the easiest to work with or safest you could ask for. The ObjectParameter objects you have to create, pass to the method and extract the value from are not type checked and reallyObjectParameter nameParam = new ObjectParameter( "Name", typeof(string)); ObjectParameter ageParam = new ObjectParameter( "Age", typeof(int)); context.GetPersonsNameAndAge( personId, nameParam, ageParam); string name = Convert.IsDBNull(nameParam.Value) ? null : (string)nameParam.Value; int? age = Convert.IsDBNull(ageParam.Value) ? null : (int?)ageParam.Value; is not what I would want to have to write.The ObjectParameter objects do make some sense for stored procedures that return both a resultset and some OUTPUT parameters, because in that case the OUTPUT parameters are only available after the resultset has been consumed and therefore you need some objects that will be populated after the ObjectResult<...> gets processed but for the stored procedures that do not return any resultset, there is no reason not to create the ObjectParameter objects within the method and extract the values there as well. So that the procedure above may be called asstring name; int? age; context.GetPersonsNameAndAge( personId, out name, out age); Things are not so simple for procedures returning both. I'm

I need a suggestion to bind the data in share point 2010 page.Suggest some right control to do this.

  
In my visual web part i need a control to display rows with grouping option. In my web part i am going to display all my document library and  announcement so that i need groping option. I need to do grouping option in the view.so what is the best control u suggest me to bind my data? 

Difficulty displaying a PDF form in VS2010 (64bit)

  
In VS2008 I was able to display a PDF form (Adobe) from a button control.  Using the same process I am not able to display a PDF form in VS2010.  Does anyone have any suggestions?

Suggest controls for the data format shown in message.

  
Hi all,  I have to display data in following format in asp.net. Please suggest me the best suited control for the same. Any help with code, rather than just the control names would be much appreciated.thanks in advance.-Harshal Month Category Budget ($) Actual ($) Updated Budget ($) Completed August 2009 --> CMG0 --> -$22,294,000.00 $0.00 -$22,294,000.00 Y TOTAL: -$22,294,000.00 $0.00 -$22,294,000.00   September 2009 --> CMG0 --> $0.00 $0.00 $0.00 Y TOTAL: $0.00 $0.00 $0.00   October 2009 --> CMG0 --> $0.00 $0.00 $0.00 Y TOTAL: $0.00 $0.00

Unit Test in MVC. What frameworks do you suggest?

  
Hello,What Unit Test Framework and Mock would you advice me for test MVC projects.Thank you,Miguel

Oracle 11g R2 64-bit linked server difficulty

  
We are re-integrating a business unit back into IT support this weekend. They have a Oracle production system that's been upgraded to 11G. The previous linked server worked fine. I'm trying to attach from an XP laptop that has a full blown Sql Server 2005 running. I've seen all the post about "in-process" and it doesn't work. I'm getting either 7303 or 7399 regardless of whether I use the Oracle or Microsoft driver. I can successfully connect and query the database from sql plus with no problem. I can create the linked server fine, it's just when I go to query that it errors. "The test connection to the linked server failed." An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "OraAGS". OLE DB provider "OraOLEDB.Oracle" for linked server "OraAGS" returned message "ORA-12154: TNS:could not resolve the connect identifier specified". (Microsoft SQL Server, Error: 7303 Could this be a problem with a 64-bit server connecting from a 32 bit client?? Thanks in advance..

Difficulty compiling IronPython WPF app into .exe when converting from .NET 3.5 to 4.0

  
We're developing an IronPython WPF/XAML app; it works fine in .NET 3.5 but now trying to move to IronPython 2.6.1 for .NET 4.0. We have a .csproj which we've updated to 4.0 - it mainly bundles our XAML and resources into a .dll - and everything works fine if we run interactively from the command prompt: ipy program.py   but when we try to build it into a standalone .exe using the pyc.py tool: C:\hs\dev\program>ipy.exe "c:\Program Files (x86)\IronPython 2.6 for .NET 4.0\Tools\Scripts\pyc.py" /main:program.py /platform:x86 /target:winexe program.py main_window.py model.py presenter.py wpf_helpers.py pyevent.py dialogs.py login.py k_ticket.py hs_quantity.py hssecdll.py debug_settings.py version_info.py it completes 'successfully' but then if I attempt to run it, the command prompt returns immediately and not even the login dialog appears. There are no error messages, or indications of a problem. This worked fine (with paths as appropriate to reference 3.5) in .NET 3.5, but is now a total mystery. I've tried a variety of pyc.py flags that seemed possibly relevant, but nothing makes it work. Suggestions for what this could be or where to look for problems appreciated! Trying to get this over to customer ASAP.

A transaction sql issue, Please see and suggest,,,,,,,,

  

There is a table

ID        Grade

1            a

1           b

2           a

3          a

3          b

4          a

4          b

 

I want to retrive the data and output as

ID      Grade

1         a|b

2          a

3         a|b

4         a|b

It looks that the data can not be  [group by] and join the string  in the same group by any existing system function,

We can use cursor to join those data by comparing the id

Do you have any better solution?

Thanks.


Oracle 11g R2 64-bit linked server difficulty

  

We are re-integrating a business unit back into IT support this weekend. They have a Oracle production system that's been upgraded to 11G. The previous linked server worked fine.

I'm trying to attach from an XP laptop that has a full blown Sql Server 2005 running. I've seen all the post about "in-process" and it doesn't work. I'm getting either 7303 or 7399 regardless of whether I use the Oracle or Microsoft driver. I can successfully connect and query the database from sql plus with no problem. I can create the linked server fine, it's just when I go to query that it errors.

"The test connection to the linked server failed."

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "OraAGS".
OLE DB provider "OraOLEDB.Oracle" for linked server "OraAGS" returned message "ORA-12154: TNS:could not resolve the connect identifier specified". (Microsoft SQL Server, Error: 7303

Could this be a problem with a 64-bit server connecting from a 32 bit client??

Thanks in advance..


Suggest me an IDEA

  

As I am new to Dot net I dont know the best solution for the requirement..

My requirement as follows ....

1) There are 5 dropdowns, If user selects the first one, the items of the second changes according to first selected drop down option

     Like Wise It follows for the rest drop downs..

2)  There are 4 options Emp No only,Id only,Both exists and none exists.When user gives selected last drop down,It have to check whether any record existed in the DB with the same drop downs selections

     If not exists then user has to check the any one of the above option button else the according to the Database entry the option should be highlighten and make rest all disabled. ( Option can be decided by Zero entry in the column if both values are zero's then it is non applicable)

3) According to the above selected option the textboxes which accepts emp No,Id should be readonly that is, if user gave Emp no only option the textbox which takes input for ID should contains value 0 and should be readonly. where as for the textbox EmpNo zero not allowed.

4) Textboxes should be dynamically created. And there should be a strict check for the values entereted by the user. Should not allow user to proceed furthur if there is any wrong input.

5) while entering inputs in between h

Can any one suggest?

  

I am working on Shopping Cart its almost done. But i need small help from you guys.In my application final Step when  customer try to  CheckOut  the products cart should be email with attachment as a PDF.

This application developed using vb.net.

I have completed till the checkout page. After that i am not geting any Idea how to send the cart Items to email as a PDF.

I tried to convert the webpage, repeater control to pdf but no luck...I can't spend money on thirdpaty tools.

Even i tried free One itextsharp but i could not get it..

check out page has  the following

1.products on a repeater control and some labels.and other server controls.

2.Images company Logo



Can any one tell me how to send the cart items as email in pdf format.

Is there any other best way  to send sales Quotation to customers on products.



Thanks in Advance....





Please Suggest a Query

  

Dear   frnds,

 

I have table like following.

 

 

 Col 1       Col 2

 

 X               A1

 X 

Need to devlop a wpf ip address control - suggest

  
Hi,

I need to develop an IP address control and it should have more features than the standard windows IP control i.e. it should allow cut/copy/paste of whole ip address. Selection of more than one octet through mouse and full set of navigational/validation features. So my question is:

1) Is there any third party wpf ip address control available (we tried a control developed for windows as hosted control but then there are issues like focus/validation not firing etc.)

2) What should be our approach 
    i) A composite control with four textboxes with a "." in between them - but then there will be a problem of selecting more than one octet and cut/copy/paste of whole ip address - will it be easy to implement ?
    ii) A masked text box approach - Is there any wpf masked textbox available - would it be suitable to          provide complex functionality/features - where to get sample code to start from- can somebody provide the links.

3) What should be a good time estimate to develop a full-fledged wpf ip control for an intermediate wpf programmer.

Looking for some suggestions/pointers.

Thanks in advance.

Anurodh

plz suggest some solution

  

i have dont the below query .....

select ticker, Company, Beneficiary, Nominee, address1, address2, address3, address4, PCode, Numshares, ShareDate, PercIC, CountryCode, HolderType, ALLDETAIL_20100923V1. RegAccNumber as RegAccNumber, ALLDETAIL_20100923V1. BenAccNumber as BenAccNumber, ShareCode, ARIndicator, ReconIndicator into ALLDETAIL_20100923V4 from ALLDETAIL_20100923V1, accountnumbermapping3

Suggest best way to do this approval workflow for share point form library.

  

I have created the Info path form.

Once the new form created i need to send the email to users which the user selected in the people picker field.

Is that possible to do this using Designer,or VS 2010.

Give some reference to do this.


Cross Database Module Signing Difficulty

  

Hello,

I am reading up on certificates and module signing and I can follow the example provided except that I want to clarify some confusing points for me. In my case I have 2 dbases so right there most tutorials fall out.

Generally speaking what I understand is that we create a user on dbase 2. We create the certificate on dbase2. We associate the cert with the user on dbase 2. We give the Cert user perms needed on dbase 2.

On dbase 1 we have an sp that needs the signature of the cert created on dbase2 so it has the proper authority context to execute. But how do I get that? The closest I came was reading this article (http://blogs.msdn.com/b/raulga/archive/2006/10/30/using-a-digital-signature-as-a-secondary-identity-to-replace-cross-database-ownership-chaining.aspx) which indicated that after creating the cert I then back it up and bring it into other dbases from the backup .cer file.

But this does not work. I get an error:

Msg 15556, Level 16, State 1, Line 1

Cannot decrypt or encrypt using the specified certificate, either because it has no private key or because the password provided for the private key is incorrect.

Well it a

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