Here is my anchor tag which is in gridview. i need to display only that column which has data.
<a href="#" id='asc_<%# Eval("Id") %>' class="btn btn-primary btn-sm" onclick="getData(this);" title="data" style="display:none;" >Data
</a>
this is my function which is used to show pop up bind the data to pop up.
function getData(obj) {
var spl = obj.id.split('_');
var id = spl[1];
if (!isNullOrEmpty(id)) {
$.ajax({
url: "DataFiles.aspx/Description",
type: 'POST',
contentType: 'application/json;charset=utf-8',
datatype: 'json',
data: "{id:" + id + "}",
success: function (data) {
$('#DesPopUp').modal('show');
$('#listOfNotes').html('');
var divContent = '';
divContent += '<div class="pop-grid"> <table class="Grid"> <tbody> <tr>';
divContent += '<th> </th><th><u><b style="padding:40px;">Date</b></u></th>';
//divContent += '<th><u><b style="padding:40px;">Time</b></u></th>';
divContent += '<th><u><b style="padding:40px;">Event</b></u></th>';
divContent += '<th><u><b style="padding:45px;">Description</b></u></th>';
var i = 0;
$.each(data.d, function (key, val) {
i++;
divContent += '<tr>';
//divContent += '<div>1.</div>';
divContent += '<td><label><span>' + i + '</span> </td> <td><b>' + val["Date"] + '</b></label> </td>';
//divContent += '<td><label> ' + val["Time"] + '</label> </td>';
divContent += '<td><label> ' + val["Event"] + '</label> </td>';
divContent += '<td><label>' + val["Description"] + '</label> </td>';
divContent += '</tr>';
});
divContent += ' </tbody></table> </div>';
$('#listOfNotes').append(divContent);
},
error: function (data) {
//
}
});
}
}
function isNullOrEmpty(str) {
if (str != null && str != '')
return false;
else
return true;
}
requirement is to show only that column which has data , if no then hide that column in the grid.the id which i am passing to anchor tag is the key, if that id has data
in the database it wil bind to div else it wil be empty
now how to show grid column which has data hidde that column which doesnt have.
[WebMethod]
public static List<DiaryNotes> Description(string id)
{
using (var conn = new SqlConnection(PageBase.ConString))
{
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "SP_GetData";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id", id);
var dt = new DataTable();
dt.Load(cmd.ExecuteReader());
List<DiaryNotes> list = new List<DiaryNotes>();
try
{
foreach (DataRow row in dt.Rows)
{
DataNote dn = new DataNote();
dn.DataNoteDate = row["DataNoteDate"].ToString();
// dn.DataNoteTime = row["DataNoteTime"].ToString();
dn.Event = row["Event"].ToString();
dn.Description = row["Description"].ToString();
list.Add(dn);
}
}
catch (Exception)
{
throw;
}
return list;
}
}
please help ??
