When working with Sitecore, it’s common to need content synchronization across environments. Today, I’ll walk you through the steps to sync content from Production to UAT/TEST and vice versa. Steps to Follow 1. Set Up Your Workspace Create a folder on your computer where you will manage the script files and exported data. Open the folder path in PowerShell to begin scripting. We need to run some scripts in PowerShell to update the folder with the basic requirements for syncing content. PS C:\Soft\ContentSync> dotnet new tool-manifest PS C:\Soft\ContentSync> dotnet nuget add source -n Sitecore https://nuget.sitecore.com/resources/v3/index.json PS C:\Soft\ContentSync> dotnet tool install Sitecore.CLI PS C:\Soft\ContentSync> dotnet sitecore cloud login If the above error occurs, you will need to run a different command to resolve the issue. PS C:\Soft\ContentSync> dotnet sitecore init now, Again run above command to open and authenticate with XM Cloud. It will be there a...
Here, I have created web method and used with ajax to get value .Here you can learn how to retun data in array and also created list of details class.
[WebMethod]
public static Details[] BindClass()
{
List<Details> Details = new List<Details>();
DataTable dt = new DataTable();
string Query = "select deptid, deptName from dept_master where Status=1";
using (SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"].ToString()))
{
using (SqlCommand cmd = new SqlCommand(Query, con))
{
con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
foreach (DataRow dtrow in dt.Rows)
{
Details Dsdetails = new Details();
Dsdetails.Id = Convert.ToInt32(dtrow["deptid"].ToString());
Dsdetails.Name = dtrow["deptName"].ToString();
Details.Add(Dsdetails);
}
}
}
return Details.ToArray();
}
Here i have created a class and inside that some properties for id and name
public class Details
{
public int Id { get; set; }
public string Name { get; set; }
}
[WebMethod]
public static Details[] BindClass()
{
List<Details> Details = new List<Details>();
DataTable dt = new DataTable();
string Query = "select deptid, deptName from dept_master where Status=1";
using (SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"].ToString()))
{
using (SqlCommand cmd = new SqlCommand(Query, con))
{
con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
foreach (DataRow dtrow in dt.Rows)
{
Details Dsdetails = new Details();
Dsdetails.Id = Convert.ToInt32(dtrow["deptid"].ToString());
Dsdetails.Name = dtrow["deptName"].ToString();
Details.Add(Dsdetails);
}
}
}
return Details.ToArray();
}
Here i have created a class and inside that some properties for id and name
public class Details
{
public int Id { get; set; }
public string Name { get; set; }
}
Comments
Post a Comment