How to alter column definition in SQL

Alter table test add constraint pk  primary key clustered(USerId)

Comments

Post a comment

Popular posts from this blog

StateCode and StatusCode Values for mostly used entities in Microsoft Dynamics CRM 2013

In this blog I have given a list of all StateCode and StatusCode of useful entities. Please refer MSDN for more details for any doubt if you have regarding any thing. I also have collected this through MSDN
The following table shows default Microsoft CRM values for StateCode and StatusCode. Each StateCode has its own default StatusCode value. For example, if a Product StateCode is 0 (Active), the default StatusCode is 1 (Active(default)). If the Product StateCode is 1 (InActive), the default StatusCode is 2 (Inactive(default)). Microsoft CRM only accepts StatusCodes that are valid for a particular StateCode.



Entity
Status (statecode)
Status Reason
(statuscode)
Account (account)
0
Active
1
Active
1
Inactive
2
Inactive
Activity (activitypointer)
0
Open
1
Open
1
Completed
2
Completed
2
Canceled
3
Canceled
Read more

How to import CSV files into DataTable in C#

Below is code the which you can use for converting a csv file into Data Table in C#. This method also handles comma values inside a double quoted value.1. Provide the file path of your csv file:string sCsvFilePath = @"C:\Downloads\Sample.csv";2. Call Custom Method:DataTable dtTable = ConvertCSVtoDataTable(sFilePath); 3. Copy and Paste below:publicstaticDataTable ConvertCSVtoDataTable(string sCsvFilePath) {     DataTable dtTable = newDataTable();     Regex CSVParser = newRegex(",(?=(?:[^\"]*\"[^\"]*\")*(?![^\"]*\"))");     using (StreamReader sr = newStreamReader(sCsvFilePath))     {         string[] headers = sr.ReadLine().Split(',');         foreach (string header in headers)         {             dtTable.Columns.Add(header);         }         while (!sr.EndOfStream)         {             string[] rows = CSVParser.Split(sr.ReadLine());             DataRow dr = dtTable.NewRow();             for (int i = 0; i < headers.Leng…
Read more

Search data in Gridview on Textbox Key press event using JQuery in Asp.Net- C#

Image
First of all add the following .js file, Link and the JavaScript to your <Head> tag ::

<head runat="server">
    <title></title>   
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
<script type="text/javascript" src="js/quicksearch.js"></script>
<script type="text/javascript">
    $(function () {
        $('.search_textbox').each(function (i) {
            $(this).quicksearch("[id*=gvDetails] tr:not(:has(th))", {
                'testQuery': function (query, txt, row) {
                    return $(row).children(":eq(" + i + ")").text().toLowerCase().indexOf(query[0].toLowerCase()) != -1;
                }
            });
        });
    });
</script>
</head>

// This Script dynamically searches the GridView cells and filters out the unwanted rows and di…
Read more
go to top image