[object Object]
public static string GetDate(string mo, string dy, string yr) { List<dataclass> returndata = new List<dataclass>(); dataclass dc = new dataclass(); var json = ""; string date1 = mo.ToString() + "/" + dy.ToString() + "/" + yr.ToString() + " 8:00 AM"; if (date1.Length > 6) { DataSet ds = new DataSet(); DataTable dt = new DataTable(); string connStr = ConfigurationManager.ConnectionStrings["jsonobject"].ConnectionString; string cmdStr = "SELECT * FROM [jsondata] WHERE [datetime1]=@datetime1;"; using (SqlConnection conn = new SqlConnection(connStr)) { using (SqlCommand cmd = new SqlCommand(cmdStr, conn)) { conn.Open(); cmd.Parameters.AddWithValue("@datetime1", date1); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ds); dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { dc.idd = dr["idd"].ToString(); dc.datetime = dr["datetime1"].ToString(); dc.col1 = dr["col1"].ToString(); dc.col2 = dr["col2"].ToString(); dc.col3 = dr["col3"].ToString(); returndata.Add(dc); } } } } System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer(); json = serializer.Serialize(returndata); } else { json = "mo,dy,yr were null"; } return json; }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)