Upload Attachment to SharePoint Site List Item

Application Form Window

CODE ---------------------- using System; using System.Windows.Forms; using System.IO; using System.Security; using spClient = Microsoft.SharePoint.Client; namespace Upload_Attachment_SP_Online { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void btnBrowse_Click(object sender, EventArgs e) { var file = openFileDialog1.ShowDialog(); if (file.ToString() == "OK") txtFilePath.Text = openFileDialog1.FileName.ToString(); var x = txtFilePath.Text.Split('\\'); txtFileName.Text = x[x.Length - 1]; } private void btnUpload_Click(object sender, EventArgs e) { try { using (spClient.ClientContext ctx = new spClient.ClientContext("https://contoso.sharepoint.com/tc/")) { SecureString upwd = new System.Net.NetworkCredential("", "password1").SecurePassword; ctx.Credentials = new spClient.SharePointOnlineCredentials("jon.smith@contoso.com", upwd); spClient.Web myWeb = ctx.Web; spClient.List oList = myWeb.Lists.GetByTitle("TestList"); spClient.CamlQuery camlQuery = new spClient.CamlQuery(); camlQuery.ViewXml = "<view><query><where><eq ><fieldref Name='Title'/>" + "<value Type='Text'>Item1</Value></Eq></Where></Query></View>"; spClient.ListItemCollection collListItem = oList.GetItems(camlQuery); ctx.Load(collListItem); ctx.ExecuteQuery(); spClient.AttachmentCreationInformation aci = new spClient.AttachmentCreationInformation(); byte[] bytes = File.ReadAllBytes(txtFilePath.Text); MemoryStream mStream = new MemoryStream(bytes); aci.ContentStream = mStream; aci.FileName = txtFileName.Text; foreach (spClient.ListItem oListItem in collListItem) { spClient.Attachment attachment = oListItem.AttachmentFiles.Add(aci); oListItem.Update(); } ctx.ExecuteQuery(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } } } }

Replace "Tab Character" in Excel Active Sheet

TAB - horizontal tab Decimal Value is 9

---

Private Sub Workbook_SheetActivate(ByVal Sh As Object)

Dim lRow As Long

Dim lCol As Long

   

    'Find the last non-blank cell in column A(1)

    lRow = Cells(Rows.Count, 1).End(xlUp).Row

   

    'Find the last non-blank cell in row 1

    lCol = Cells(1, Columns.Count).End(xlToLeft).Column

For i = 1 To lRow

    For j = 1 To lCol

        t = Cells(i, j).Value

        If (Len(t) > 0) Then

            If (Asc(Left(t, 1)) = 9) Then

                str1 = Mid(t, 2, Len(t))

                Cells(i, j).Value = str1

            End If

        End If

    Next

Next

End Sub

Rest API to check field value contains...

[site url]/_api/Web/Lists/GetByTitle('myList')/items/?$filter=substringof('ABC',Title)

Filter Unique Value in Array

var items = ['abc','pqr','abc','xyz','pqr','abc'];
var result = items.filter(UniqueElement); 

//result ['abc', 'pqr','xyz']


function UniqueElement(value, index, self) { 
    return self.indexOf(value) === index;
}

Simple way to Check if JSON is correct or not..

function IsJsonString(str) {
    try {
        JSON.parse(str);
    } catch (e) {
        return false;
    }
    return true;
}

Remove control characters from a string

function removeCC(s) {

  /* Remove NewLine, Carriage Return and Tab characters from a String  */

  r = "";
  for (i=0; i < s.length; i++) {
    if (s.charAt(i) != '\n' &&
        s.charAt(i) != '\r' &&
        s.charAt(i) != '\t') {
      r += s.charAt(i);
      }
    }
  return r;
  }

Same thing with regular expression

function removeCC(s){ 
  return s.replace(/[\n\r\t]/g," "); 
}

Custom button in DataTable

DataTable Example:

(1)Add custom button

"buttons": [{"text": ' Custom Button',
        "action": function () {
                                alert("Custom Button Clicked");
}
        },

]


(2) Button Menu

"buttons":[
                {
                extend: 'collection',
                text: 'Menu',
                className: "menuMain",
                autoClose: true,
                buttons: [
                    {
                        text: 'Item 1',
                        action: function () {
                            alert("Item 1 Selected");
                        }
                    },
                    {
                        text: 'Item 2',
                        action: function () {
                            alert("Item 2 Selected");
                        }
                    }
                ]                           
                             },
                  ]