.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

How to create a unique id along with string

Posted By:      Posted Date: October 25, 2010    Points: 0   Category :SharePoint


 I want to create a unique id column with string and unique number likeRSS-011. I want this as auto generated in sharepoint list, while i create for each new list item. How can i do this without going to code

View Complete Post

More Related Resource Links

Connestion string create any database server

This links important to how to create connection string to any data base sever.

Create unique constraint on a column which has null values

Hi All, I have a table suppose 'Temp' having one of the column as 'ColA' which has some null values as well as non null values. Now i have a requirement to create a unique constraint on it. We have tried but couldnt do it.Apart from having a trigger on insert and update statements is there any other alternate. Can any one please help me on this. Thanks & Regards, Srikanth  

101 question - New to VS 2010, create connection string to perform test with Oreilly txt book

Hello, I have installed VS 2010 Ultimate and it came with SQL 2008.  I am trying to figure out what version it is and also how to create a connection in place to keep using the Oreilly examples to hopefully learn how to develop in C#.  I have been learning but it is getting more difficult.   I try to follow the steps but it just does not make sense.  If anyone could provide some easy steps to check version and connection method to sql using 2010, I would be grateful. I did see a post for sql management(http://www.microsoft.com/downloads/details.aspx?FamilyID=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b&displaylang=en).  I am going to download to hopefully be able to view the database.  We have sql server 2008 at work and I have used the studio management for sql to run queries and would like to do the same with the version that was installed with the installation of 2010 ultimate.Hopefully I can get the connection to the database so I can start learning how to build a dictionary and list for some queries.  My goal is to create a aspx file that will show entries in a database we have at work.  Trying to take baby steps.Thanks for the help.

hyperlink text/now create string from label? please help



I have a datalist in a page which shows a username in a label from the database (theiruseridLabel)

I'm trying to take this username, find its profile.firstname and profile.company name, and then display them as the text in 2 hyperlinks.

i have the code below, but this doesnt work..? can anyone see why? there is no error, just the hyperlinks just show as 'hyperlink' rather than the names i want. Thanks!:

HyperLink hp2 = DataList1.Items[0].FindControl("HyperLink2") as HyperLink;
        HyperLink hp3 = DataList1.Items[0].FindControl("HyperLink3") as HyperLink;
        Label theiruseridLabel = DataList1.Items[0].FindControl("theiruseridLabel") as Label;

        string userName = Request["theiruseridLabel"];
        ProfileCommon userProfile = System.Web.Profile.ProfileBase.Create(userName, true) as ProfileCommon;
        hp2.Text = userProfile.FirstName;
        hp3.Text = userProfile.CompanyName;

Content Organizer - Target Location - Automatically create a folder for each unique value of a prope


I would like to create a content organizer rule to route documents from the drop off library to their final location in the document library.

I also want to create a subdirectory based off a metadata field, so that a folder gets created for each year.

There is a metadata field called "Document Classification Year".

I check the chebox to  "Automatically create a folder for each unique value of a property" and choose "Document Classification Year" as the field.

For "Specify the format for the folder name:" %2

I was hoping this would create a folder called "2010" if the meta data field "Document Classification Year" was entered as "2010".

But it creates TWO folders. The first folder it calls "Document Classification Year", the SECOND folder it calls "2010".

I don't need a folder called "Document Classification Year"! Just the folder "2010".

Can this be achieved without the content organizer??


Trying to create a unique workflow for every item in a library.

Hi all,

I'm trying to create a seperate collect feedback, collect approval, and send notification upon approval workflow for every document in a document library (you can imagine my terror when this was assigned).

I'm having trouble creating a seperate workflow for each document in a library.  Initially I started by creating a workflow in SPD that is triggered when an item is changed in the library and then looks for the title of the document to match it's parameter.  However, I was having a problem with the emails.  I would collect feedback, output a variable, but when I put that variable into an email body, all I would get was a number in the email.  But that's another issue for another thread I suppose. 

I also tried creating a different content type for each document.  However, for some reason the first content type I created appears in the drop down menu when I try to change a documents properties, but not the rest of the content types I created.

Any help will be greatly appreciated.  Thank you.

Create an Infopath form to generate unique number MOSS 2007


I created an infopath form that would auto generate a number to each form from following instructions at the following site.




I am wondering if it is possible to change the starting point of the ID field within sharepoint.  It starts at 1.  I would like it to start at 1000. and add 1 number each time a new infopath form is added. Or would I add a different field to accomplish this.

How can I create new textboxes with unique IDs?


Hello!  I'm creating a form.  This form includes some textboxes for user input.  Each user will have a different amount of input to provide and there's no way to predict how many textboxes to create at design time.  I have a button for adding a new textbox.  The click event is here below (I chose to limit random to 10 just for my testing):

protected void btnAdd_Click(object sender, EventArgs e)
Random random = new Random();
int intTextBoxID = random.Next(10);
TextBox txtJurisdiction = new TextBox();
txtJurisdiction.ID = "txtJurisdiction" + intTextBoxID.ToString();

This creates the same textbox over and over again with a different ID.  I need it to add a new textbox with each click.  Ideas?


Workflow create item returning integer... Should be a string.




Im passsing information to a new item in a different list using the create item workflow.


It seems to work from apart from one, critical field. The create item should (i hope) pass a valie from a field  'FIELD' in List A to 'FIELD' in ListB.   in list a the field is a lookup from a reference list.

The create new List item workflow ____ it but only returns the type as an integer (an its the oonly option) .

Can you explain where im going wrong?


Create Regular Expressions from a string programmatically


I have a situation where users can set up masks for items such as phone numbers or postal codes.  Behind the scenes in the program the mask is applied to these data values as appropriate so they can be displayed in message boxes or labels.  So for example, a user can save a mask for a phone number to be (###) ###-####, or a Canandian postal mask of &#& #&3 (Example Toronto postal code M4B 1B3).  As you can see from the two masks that # represents numbers and & represents characters.  Is there a way programmatically (VB would be nice) that you can take a mask similar to these and turn it into a regular expression pattern so the mask can be applied to a value?


Lou Davis

Create Sharepoint List Connection String


I'm trying to use SQL Reporting Services integrated with Sharepoint.  I'm trying to create a "Sharepoint List" data source.  I can't seem to find a working example of the connection string.

The article I read says:


data source=http://MySharePointWeb/MySharePointSite/




But it fails when I test the connection.

David Jenkins

How to create 3 tier application using LINQ

As you know that in 3 tier architecture there are three layers

User interface layer. (Is our Form in Windows application and .aspx page in Web application)
Data Access layer. (Which provides interface between Business logic layer and Database)
Business Logic layer.(Which stores your application logic)

Create ToolTip for GridView Header

The following allows you to add a tooltip to the header links of your GridView, a feature that is lacking.

How to Encrypt Query String Parameters in ASP.NET

Encrypt Query String Parameters in ASP.NET.u can send secure data one page another page u can also use query string to encrypt

Create And Run Excel Macro At Runtime in C#

You've been tasked with writing a Windows Form application using the .NET Framework that interacts with Microsoft Excel. If you are new to working with Excel in .NET and are having trouble learning how to format certain cells or cell ranges, then this little tip will come in handy. Rather than scour the internet hoping to find the correct set of constants or method syntax for formatting your spreadsheet, use the built in tools in Excel to write the familiar VBA code for you. Then, you can paste the VBA code generated by Excel into the sample C# code below and run it dynamically at runtime.

Create and Use a Typed DataSet by Using Visual C# .NET

This article shows you how to create and use a typed DataSet in a small Web application. Typed DataSets, which inherit from the DataSet class, create first-class members of a DataSet's DataTables and DataColumns, yielding the many benefits that come with the use of strong typing.

SQL Connection String

We can learn or know how can we connect the database from our .net. This will help for freshers or .NET beginners!
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