Skip to content

Instantly share code, notes, and snippets.

View gopigujjula's full-sized avatar

Gopikrishna Reddy Gujjula gopigujjula

View GitHub Profile
@gopigujjula
gopigujjula / DataRowState
Created April 18, 2013 13:18
DataRowState
using System;
using System.Data;
namespace DataTableRowState
{
public class BooksList
{
public static void Main(string[] args)
{
//This is the Datatable which contains book records.
@gopigujjula
gopigujjula / XMLGeneration
Created April 18, 2013 13:34
XML generation using XMLDocument
using System.Xml;
using System;
namespace SampleXmlTest
{
public class XmlClass
{
static void Main(string[] args)
{
try
@gopigujjula
gopigujjula / ExcelToDataTable
Created April 19, 2013 10:42
Loading Excel sheet to DataTable using Ole DB jet engine in C#
using System;
using System.Data;
using System.Data.OleDb;
namespace ExcelToDataTable
{
class LoadExcel
{
static void Main(string[] args)
{
#define parameters
$prefix = "sc901demo"
$PSScriptRoot = "D:\9"
$XConnectCollectionService = "$prefix.xconnect"
$sitecoreSiteName = "$prefix.local"
$SolrUrl = "https://localhost:8983/solr"
$SolrRoot = "C:\Sitecore9\solr-6.6.2"
$SolrService = "solr662"
$SqlServer = "(local)"
$SqlAdminUser = "sa"
@using Sitecore.Mvc
<!doctype html>
<html>
<head>
<title>Sitecore Demo</title>
<meta name="viewport" content="width=device-width, initial-scale=1">
</head>
<body>
<div>
using Sitecore.ContentSearch;
using Sitecore.ContentSearch.SearchTypes;
using Sitecore.ContentSearch.SolrProvider.SolrNetIntegration;
using SolrNet;
using SolrNet.Commands.Parameters;
using System.Web.Mvc;
namespace SC9SolrDemo.Controllers
{
public class GroupController : Controller
@using SolrNet;
@using Sitecore.ContentSearch.SearchTypes
@model SolrQueryResults<SearchResultItem>
@if (Model != null)
{
foreach (var group in Model.Grouping)
{
foreach (var grp in group.Value.Groups)
using SC9SolrDemo.Models;
using Sitecore.ContentSearch;
using Sitecore.ContentSearch.SearchTypes;
using Sitecore.ContentSearch.SolrProvider.SolrNetIntegration;
using SolrNet;
using SolrNet.Commands.Parameters;
using System.Collections.Generic;
using System.Linq;
using System.Web.Mvc;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
namespace SC9SolrDemo.Models
{
public class HighlightResult
{
public string Name { get; set; }
@model IEnumerable<SC9SolrDemo.Models.HighlightResult>
@if (Model != null)
{
<ul>
@foreach (var highlight in Model)
{
<li>
<h1>
@highlight.Name