Assigning a field from a database to a JSON object.

Question

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.

Madan Shekar · 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 guma · Answer

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 Shekar · Answer

please drop your code so that i can understand and try to solve .. Thanks

Assigning a field from a database to a JSON object.

Answers (3)