Assigning a field from a database to a JSON object.

Good day

I am fetching a field from the database and calculate the occurences of the field. I need to assign the field and the occurences to a JSON object. I used a stored procedure and ADO.Net to get the field to my C# code. How do I assign the field to a JSON object.

public static void Main(string[] args)

{

Elements elements = new Elements();

DataTable dt;

string resultss="";

elements.dataSet = Guid.NewGuid().ToString();

//this.completeDate = DateTime.Now.ToString("yyyy-MM-dd");

elements.completeDate = DateTime.Now;

elements.period = "201401";

elements.orgUnit = "qTz6ZHmOPus";

elements.dataValue = resultss;

DataJSON data = new DataJSON();

elements.dataSet = elements.dataSet.ToString().Substring(0, 10).Replace("-", "");

string results = JsonConvert.SerializeObject(elements);

Console.WriteLine(results);

StringBuilder sb = new StringBuilder();

string connString = ConnectionString; ;

string sprocname = "procRetrieve";

string spname = "getDataElements";

string paramName = "@json";

// Sample JSON string

string paramValue = "@jsonOutput";

using (SqlConnection conn = new SqlConnection(connString))

{

conn.Open();

//using (SqlCommand cmd = new SqlCommand(sprocname, conn))

//{

// // Set command object as a stored procedure

// cmd.CommandType = CommandType.StoredProcedure;

// using (SqlDataAdapter da = new SqlDataAdapter(cmd))

// {

// dt = new DataTable();

// da.Fill(dt);

// using (var parser = new ChoJSONWriter(sb))

// parser.Write(dt);

// }

// string res = JsonConvert.SerializeObject(dt);

// Console.WriteLine(res);

//}

using (SqlCommand cmd = new SqlCommand(spname, conn))

{

// Set command object as a stored procedure

cmd.CommandType = CommandType.StoredProcedure;

using (SqlDataAdapter da = new SqlDataAdapter(cmd))

{

dt = new DataTable();

da.Fill(dt);

using (var parser = new ChoJSONWriter(sb))

parser.Write(dt);

}

resultss = JsonConvert.SerializeObject(dt);

Console.WriteLine(resultss);

}

Console.ReadLine();

}

I want to take the results of the DataTable and put them on elements.dataValue=resultss;

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Madan Shekar7y ago
Accepted answer
if (dt.Rows.Count > 0)
{
Elements elements = new Elements();
foreach (DataRow rows in dt.Rows)
{

if (rows["databasecolumn name"] != DBNull.Value)
{
elements.dataValue = Convert.ToString(rows["databasecolumn name"]);
}
}
}
If it helps mark as answer .... any issue let me know ... Thanks
unathi guma7y ago
public static void Main(string[] args)

{

Elements elements = new Elements();

DataTable dt;

string resultss="";

elements.dataSet = Guid.NewGuid().ToString();

//this.completeDate = DateTime.Now.ToString("yyyy-MM-dd");

elements.completeDate = DateTime.Now;

elements.period = "201401";

elements.orgUnit = "qTz6ZHmOPus";

elements.dataValue = resultss;

DataJSON data = new DataJSON();

elements.dataSet = elements.dataSet.ToString().Substring(0, 10).Replace("-", "");

string results = JsonConvert.SerializeObject(elements);

Console.WriteLine(results);

StringBuilder sb = new StringBuilder();

string connString = ConnectionString; ;

string sprocname = "procRetrieve";

string spname = "getDataElements";

string paramName = "@json";

// Sample JSON string

string paramValue = "@jsonOutput";

using (SqlConnection conn = new SqlConnection(connString))

{

conn.Open();

//using (SqlCommand cmd = new SqlCommand(sprocname, conn))

//{

// // Set command object as a stored procedure

// cmd.CommandType = CommandType.StoredProcedure;

// using (SqlDataAdapter da = new SqlDataAdapter(cmd))

// {

// dt = new DataTable();

// da.Fill(dt);

// using (var parser = new ChoJSONWriter(sb))

// parser.Write(dt);

// }

// string res = JsonConvert.SerializeObject(dt);

// Console.WriteLine(res);

//}

using (SqlCommand cmd = new SqlCommand(spname, conn))

{

// Set command object as a stored procedure

cmd.CommandType = CommandType.StoredProcedure;

using (SqlDataAdapter da = new SqlDataAdapter(cmd))

{

dt = new DataTable();

da.Fill(dt);

using (var parser = new ChoJSONWriter(sb))

parser.Write(dt);

}

resultss = JsonConvert.SerializeObject(dt);

Console.WriteLine(resultss);

}

Console.ReadLine();

}

I want to take the results of the DataTable and put them on elements.dataValue=resultss;
Madan Shekar7y ago
please drop your code so that i can understand and try to solve .. Thanks