Comments by Guruprasad.K.Basavaraju (Top 91 by date)

You are lucky, it looks like there is already an example..

http://datatables.net/blog/Inline_editing

You will need to modify the datatable scripts Sunil, I am not sure which methods but its possible with some good amount of effort.

http://www.jeasyui.com/tutorial/datagrid/datagrid12.php

Hi Balu,

Can you show me the code where you are creating this XML ?

Hi sunil, Yes I can see the image now. And I got what you are saying.
This functionality is simple. You need to register a javascript method for onchange event on the dropdown and in the javascript method make an ajax call with the value and bind the datatable again.

Sunil, Confused on whats needed . More info please. Also I cannot access the image so not sure what the issue is.

This might be tricky you may need to look at the tabletools source..

I guess I lost you, couldnt understand what you mean here. Are you saying u want the data in your PDF to be a hyperlink too ?

Sunil, since you are using the serverside Ajax call you cannot replicate the example you quoted. In that example its not the server side data that they are exporting

Great, if have the third element then you need the second span else you are right its not necessary.

Also please close this question by accepting the answer.

Sunil, Just checked the documentation and the table tools is a client side export using flash so it will not support exporting the whole table and it will always export whats currently displayed on the page. You may need to write your own method for getting the data from server and creating a file. What are the other issues that are currently open ?

Sunil, I guess I am having trouble getting the table tools work.. may need to start a new project and see. Will try tonight..

Check the updated Solution

Why was this answer down voted ??

are both lists are of same type ?

thanks and good luck!!

below link should be your bible.. do refer that often it will greatly help you.. only when you cannot figure it there you post for help..

https://datatables.net/api

Great..!!
Good luck..

My new article is here this week.. vote and download if you like..

http://www.codeproject.com/Articles/760609/Beginning-with-HTML-and-CSS-Part-Getting-Fanc

Oh sorry, I guess I am reading everything wrong today.. you know what the best way to do this is applying the class when you create the column. Like below. Remove fnDrawCallback that you added before and just use the below one. Notice sClass in the Company_name column


var tab = $('#myDataTable').dataTable({
"sDom": 'T<"clear">lfrtip',
"oTableTools": {
"sSwfPath": ""
},

"bServerSide": true,
"sAjaxSource": 'AjaxDataProvider',
"bJQueryUI": true,
"aoColumns": [
{"sName": "ID","bVisible":false},
{
"sName": "ID",
"bSearchable": false,
"bSortable": false,
"fnRender": function (oObj) {
}
},
{ "sName": "COMPANY_NAME", "sClass": "hidden-xs" },
{ "sName": "ADDRESS" },
{ "sName": "TOWN" }
]

});

Thats what you wanted isn't it ?

the below works...


var tab = $('#myDataTable').dataTable({
"sDom": 'T<"clear">lfrtip',
'fnDrawCallback': function () {
$('td:eq(1)').addClass('hidden-xs')
},
"oTableTools": {
"sSwfPath": "your path"
},

"bServerSide": true,
"sAjaxSource": 'AjaxDataProvider',
"bJQueryUI": true,
"aoColumns": [
{"sName": "ID","bVisible":false},
{
"sName": "ID",
"bSearchable": false,
"bSortable": false,
"fnRender": function (oObj) {
return '

Let me try this.

Can you try inspect element and see what class the TD has now ?

Vote Up..!! :)

Sorry.. see below..

<script type="text/javascript">



$(document).ready(function () {

$('#myDataTable').dataTable({

"bProcessing": true,
"bServerSide": true,
"sAjaxSource": 'DataProvider',
"bJQueryUI": true,
"aoColumns": [
{
"sName": "ID"
},
{ "sName": "COMPANY_NAME" },
{ "sName": "ADDRESS" },
{ "sName": "TOWN" }
]

});


});

$(function() {
$(".table tr").each(function() {
$(this).find('td:eq(2)').addClass("hidden-xs");
});
});
</script>

just add the below function after creating the column filter in your script..

$(function() {
$(".table tr").each(function() {
$(this).find('td:eq(2)').addClass("hidden-xs");
});
});

I need to setup a project for this, I haven't used export anytime. How did you solve the previous issue? Was it because of the missing SWF ?

Great, Thats because its only looking at the data that is currently displayed on the HTML and exporting it.

By the way what exactly what the issue ?

Sunil, Please click reply on my message :) else I would not know you asnwered my query.

Can you run this in chrome and click inspect element and see if the swf files are loaded ?

What version of tabletools have you imported ?

No, what plugin are you working with ? Also please close this question by accepting one of the answers above. The solutions above mine are also correct, please accept those too. We can look at your plugins in another thread.

These are really good SA.

Yes you can, I just posted a common function to use when exporting a table.

Day and night working and even better learning..!! Good luck!

np, I am from Blore...

I have updated the script above..

I cannot paste it here for some reason..

And about the error. looks like some pasting error.

Change it to below..

<pre>"fnRender": function (oObj) {
return '' + oObj.aData[0] + '';
}</pre>

Hyperlink isn't static here right ? its actually the ID values.. run this code you will see..

add this code above your script tag..

<style>
#myDataTable tr td a
{
text-decoration: none;
}

</style>

Action link are usually unlined in browser correct ? :) but yes, you can apply style to remove the underline

You can add another dummy column when you return the data and make that an Action link.

Try now...

You again replied to your own message :) See below for solution

Sunil, will check on this in the morning.. Please click on reply to my message that will trigger a notification to me. Otherwise I wouldn't know if you commented unless I come to this page again..

Just curios, why would you want to edit a link ?

Are you making this data table editable ?

Wish there was a way to up vote this reply. Simple and elegant explanation..

So what I understand is the Single Market is a single instance of the class and Combined Market is a collection, correct ?

Sunil, Guess I couldn't get the issue. Could you please explain ?

That should work.. thanks and you have a good one too..
If interested in HTML and CSS, I have recently written some articles on the same.. below is the link.

http://www.codeproject.com/script/Articles/MemberArticles.aspx?amid=10705317

Sunil,

You will need to create a list with the value to insert and value to select. In my example I create a list of string which is just one value in each list element.

Thats correct,

In my code both the page and the datatable are in the same controller so we dont have to specify it.

Keerthana, you cannot get the IMEI from a webpage for security reasons..

Goodluck.. will look at the other one today.

Sunil..

apply both to the Datatable..

like for instance..

var dt = $('#example').dataTable({..bla bla });
dt.edittable({..bla bla });

dt..columnFilter({ sPlaceHolder: "head:before",
aoColumns: [ { type: "text" },
{ type: "date-range" },
{ type: "date-range" }
]

});

is this not what you are looking for ?

$(document).ready(function(){
$('#example').dataTable()
.columnFilter({ sPlaceHolder: "head:before",
aoColumns: [ { type: "text" },
{ type: "date-range" },
{ type: "date-range" }
]

});
});

Hi Keerthana,

I dont have the full code and may not be able exactly point out the issue for this, please see below for another article on a similar topic.. Are you looking to get this IMEI on a windows App ? where are you using this ?

http://www.codeproject.com/Articles/161389/Windows-Mobile-Programming-Tricks-on-the-NET-Com

see below for solution 3.. that solution should work.. accept the answer if it solves your issue.. Thanks!!

What exactly is the question here ?

Do you mean which event to add this code/logic ?

Check the solution below.. thats just a rough idea of how to build a pivot.. modify it according to your table structure

could you please post your table structure ? You can use pivoting for this if the marks are stored in rows.

That's surprising.. What is the datatype of txtFrmDate ?

Dev, could you paste the value of the string "bccAddresses" by putting a break point please ?

hmmm.. don't know what to say.. The exact same code of yours works well for me..

I have screenshot but don't know how to send.

I guess the problem is not in your query but the C# code where you are adding the variable you are talking about. Can you paste a snippet of that part ?

I even tried the exact query of yours with my own table. See below, it works both in SQL and C#

Select
AVG(Weekdiff) as 'Response Time'
from
(select
TicketID,
MEPE_CREATE_DTM,
MEPE_TERM_DT,
DATEDIFF(hour,
MEPE_CREATE_DTM,
MEPE_TERM_DT) as actualhours,
DATEDIFF(day,
MEPE_CREATE_DTM,
MEPE_TERM_DT)actualdays,
DATEDIFF(hour,
MEPE_CREATE_DTM,
MEPE_TERM_DT)-( DATEDIFF(day,
MEPE_CREATE_DTM,
MEPE_TERM_DT)*13)- ((datediff(wk,
MEPE_CREATE_DTM,
MEPE_TERM_DT) * 2) - case
when datepart(dw,
CAST(MEPE_CREATE_DTM AS DATETIME)) = 1 then 1
else 0
end + case
when datepart(dw,
CAST(MEPE_TERM_DT AS DATETIME)) = 1 then 1
else 0
end)*11 as Weekdiff
FROM
(SELECT
[TicketID],
(CASE
WHEN DATEPART(hour,
CAST(MEPE_EFF_DT AS DATETIME)) > '17' then dateadd(hour,
6,
CAST (CAST(DATEPART(year,
(DATEADD (day,
1,
CAST(MEPE_EFF_DT AS DATETIME)))) AS varchar(4)) + '-' + CAST(DATEPART(month,
(DATEADD (day,
1,
CAST(MEPE_EFF_DT AS DATETIME)))) AS varchar(4)) + '-' + CAST(DATEPART(day,
(DATEADD (day,
1,
CAST(MEPE_EFF_DT AS DATETIME)))) AS varchar(4)) AS datetime))
WHEN DATEPART(hour,
CAST(MEPE_EFF_DT AS DATETIME)) < '6' then dateadd(hour,
6,
CAST (CAST(DATEPART(year,
CAST(MEPE_EFF_DT AS DATETIME)) AS varchar(4)) + '-' + CAST(DATEPART(month,
CAST(MEPE_EFF_DT AS DATETIME)) AS varchar(4)) + '-' + CAST(DATEPART(day,
CAST(MEPE_EFF_DT AS DATETIME)) AS varchar(4)) AS datetime))
WHEN DATEPART(dw,
CAST(MEPE_EFF_DT AS DATETIME)) = '7' then dateadd(hour,
6,
CAST (CAST(DATEPART(year,
(DATEADD (day,
2,
CAST(MEPE_EFF_DT AS DATETIME)))) AS varchar(4)) + '-' + CAST(DATEPART(month,
(DATEADD (day,
2,
CAST(MEPE_EFF_DT AS DATETIME)))) AS varchar(4)) + '-' + CAST(DATEPART(day,
(DATEADD (day,
2,
CAST(MEPE_EFF_DT AS DATETIME)))) AS varchar(4)) AS datetime))
WHEN DATEPART(dw,
CAST(MEPE_EFF_DT AS DATETIME)) = '1' then dateadd(hour,
6,
CAST (CAST(DATEPART(year,
(DATEADD (day,
1,
CAST(MEPE_EFF_DT AS DATETIME)))) AS varchar(4)) + '-' + CAST(DATEPART(month,
(DATEADD (day,
1,
CAST(MEPE_EFF_DT AS DATETIME)))) AS varchar(4)) + '-' + CAST(DATEPART(day,
(DATEADD (day,
1,
CAST(MEPE_EFF_DT AS DATETIME)))) AS varchar(4)) AS datetime))
ELSE CAST(MEPE_EFF_DT AS DATETIME)
end) AS MEPE_CREATE_DTM,
[MEPE_TERM_DT]
FROM
SOME_TABLE_OF_MY_OWN
WHERE
DATEDIFF(HOUR,CAST(MEPE_EFF_DT AS DATETIME),[MEPE_TERM_DT]) IS NOT NULL)x
where
DATEPART(WEEK, CAST(MEPE_CREATE_DTM AS DATETIME)) = DATEPART(WEEK, getdate())
)y

could you give couple of records from [LFM_Archive].[dbo].[IT_Track] table ?

I tried different DatePart queries from my c# code and it works perfect.


SqlConnection sqlConnection1 = GetConnection();
SqlCommand cmd = new SqlCommand();
SqlDataReader reader;
string str1 = "4/3/2014";
string str2 = "select datepart(dw,CAST('"+ str1 +"' AS DATETIME)) as ss;";
cmd.CommandText = str2 ;
cmd.CommandType = CommandType.Text;
cmd.Connection = sqlConnection1;

// sqlConnection1.Open();

reader = cmd.ExecuteReader();
string ssss = "";
while (reader.Read())
{
ssss = reader[0].ToString();
}

What line of this code is throwing the error ? Could you please post the complete error ?

what happens if you use return View(); instead of return PartialView();

Samy,
Please give an idea of the model you are working with, paste the model structure. Is it a IEnumerable or a list ?

What is Model.lstTrxn ? The second argument must be a list.

Below are two options.

Option 1:

foreach (XElement xE in list1)
{
string DrugName = xE.Element(ns+"DrugName").Value.ToString();
}

Option 2:

string[] drugs = (from el in root.Elements(ns + "PatientDrugDetail").Elements(ns+"DrugName") select el.Value.ToString()).ToArray();

Guess it was a typo :)

Guess, you might have misunderstood the concept of Partial view here or I am mis reading your issue. Could you please post a code snippet ?

string str = @"YOUR_XML_STRING";
XElement root= XElement.Parse(str);

Ah I see what you are saying. I guess we cannot marshall the list type.Below from stack overflow might be a way to solve your problem.

http://stackoverflow.com/questions/5102436/how-to-marshal-collection-in-c-sharp-to-pass-to-native-c-code

Sorry, :) new to code project.. moved it over to the comment section. Thanks "InsertCleverUserName" :)

Vedakumar, could you please refine your question? I guess we are getting lost in the long code lines above. Calc on grid is fairly simple , so if you could get the right question posted you will get a quick answer.

-Guru