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


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

Complexx AutoIncrment colum

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

Hi,

      I have a situation where I have to maintain auto incremental values based on values of other colum. Sample table is given below.

 

colA colB colC
1

View Complete Post


More Related Resource Links

display icon or colum for inserted file in infopath form

  
i have a list with infopath form and in this form i have insert file now i need naythin in the view say there is attached or insert file in this record like the icon for attachment or column display file name or his path ,somthink can i know in this record there is attachmentThanks for any help :) my blog is: http://www.waelk.com

Custom Ribbon and getSelectedItem Colum

  

Hello,

i have a problem to get a Colum Value of a selected Library Item when i click my custom Ribbon Button.

The Button call this Javascript function:

function showItemColum()
{
var selectedItems = SP.ListOperation.Selection.getSelectedItems();
var currentListGuid = SP.ListOperation.Selection.getSelectedList();
var context = SP.ClientContext.get_current();
var currentWeb = context.get_web();
var currentList = currentWeb.get_lists().getByID(currentListGuid);
var k;

if (k in selectedItems) {
var listitem = currentList.getItemById(selectedItems[k].id);
...
...
}
}

How can i get the Value of the Colum "Status" (for example)?

Thank you for help.


Problem retrieving bit colum with sqldatareader for vb class property

  

 I have a vb class that reads a single row of data from an SQL view. I want to add a property to it that will expose the value of a new bit field. But whatever I do my class always returns the value "false".

What am I doing wrong?

       Public ReadOnly Property IsPublished() As Boolean
            Get
                Return valPublished
            End Get
        End Property


Here's the relevant line from my datareader:
        Me.valPublished = Convert.ToBoolean(theObjectReader("Authorised"))Authorised is my bit field. I have tried it with and without the "ConvertToBoolean" statement.
When I response write the value of the property for rows where this field is true, it always shows false.

Any ideas?


Master-detail lookup Colum

  

I am looking for Master-detail lookup Column which will support unlimited depth of cascaded bound lookup

I checked different sources( MS forums, Google groups, etc ) and found http://sharepointfields.com/

Did anybody can share some own experience?


Master-detail lookup Colum

  

I am looking for Master-detail lookup Column which will support unlimited depth of cascaded bound lookup

I checked different sources( MS forums, Google groups, etc ) and found http://sharepointfields.com/

Did anybody can share some own experience?


Master-detail lookup Colum

  

I am looking for Master-detail lookup Column which will support unlimited depth of cascaded bound lookup

I checked different sources( MS forums, Google groups, etc ) and found http://sharepointfields.com/

Did anybody can share some own experience?


Master-detail lookup Colum

  

I am looking for Master-detail lookup Column which will support unlimited depth of cascaded bound lookup

I checked different sources( MS forums, Google groups, etc ) and found http://sharepointfields.com/

Did anybody can share some own experience?


Master-detail lookup Colum

  

I am looking for Master-detail lookup Column which will support unlimited depth of cascaded bound lookup

I checked different sources( MS forums, Google groups, etc ) and found http://sharepointfields.com/

Did anybody can share some own experience?


SSIS Custom Destination Component colum mapping issue

  

Hi ,

I am facing the below issue.

I am developed a custom destination component.I have custom UI also to set some properties.

Once i save the component and do the mapping in the Show Advance Editor Colum Mapping.This is working fine.

The problem starts Next.If I edit the component and do some changes  and say Ok ,In the output colum mapping all the mappings which i have already been set is getting removed.Then again i have to remap it.Ho to keep the existing mapping if we edit the component?

need help to solve this issue.


Matrix Column grouping - Total column incorrect when colum value is wrapped in a call to code

  

I have a column grouped matrix report that shows count, cost and duration.  Duration is time in seconds.  To format the time on the report as hh:mm:ss I send it through a code block that converts the int to a string. 

When the report is generated the total column is NOT code.convert(sum(Fields!Duration.Value)).  At first I thought it was taking the max value, then I thought it is was taking the first value.. not really sure how it is calculating the value.

I did trying wrapping the expression like this IIF(InScope("matrixgroup"), Code.Convert(Fields!Duration.Value), Code.Convert(Sum(Fields!Duration.Value))).  It didn't make a difference the column is still incorrect.

If I remove the Code.Convert from the column, the value is correct.

Does anyone have any suggestions?

 

 


Encrypt Existing Colum

  

i have table : tab1 (name,address) with existing data.

i want to encrypt address coulm with out creating any new colum . and user (who having read access) run Select * from tab1; he should display address colum with encrypt way like ***.

 

pls advice how i will procced .


SQl Server 2008 Version:
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