|
RaviRanjankr wrote: one OP have already answered you
OP stands for Original Poster, i.e. the person who posted the question. OP does not relate to one who answers a question.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Mark Nischalke wrote: OP stands for Original Poster, i.e. the person who posted the question. OP does not relate to one who answers a question.
I was thinking OP stands for Other Person. that's why I used OP word. whatever,
thanks Mark to let me know the actual meaning of OP(Original Poster).
|
|
|
|
|
Hi every body
I want when user click save button the prompt show that user can save page with any extension like .htm but only save content page not master page please guide me
Thanks for your help
|
|
|
|
|
To do that you would need to create a create another page that does not use the master page or use CSS to remove the master page elements when it is displayed. Then have the user save that page. This is what most "printer friendly" pages do.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Could you explain more with some example I some confuse How can I create another page in the same time? I think your solution is correct but it's difficult too .
|
|
|
|
|
You can't create another page dynamically, which appears to be what your are thinking. You must create the page before hand, just like any other asp.net page in your application. Or you use CSS to remove the masterpage elements. This method is used extensively in SharePoint 2010.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
But It's Dynamic page and sorry How can I use css to remove masterpage?Which element in css?can you write your code its very necessary for me.Thanks
|
|
|
|
|
.hidden
{
visibility: none;
}
Elham M wrote: can you write your code
Sure. Contact me offline to discuss rates and requirements.
Elham M wrote: its very necessary for me
It is very necessary for me to get paid for my time and effort.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
You can create a separate CSS file for printing and set the
media="print" attribute in the
link tag. If you hide all master page elements in this CSS file, then those elements will not be printed.
|
|
|
|
|
I've khnew this tag for print and I've used it but this tag just for print it's not for save button!
|
|
|
|
|
You can use the same technique with a little tweak. Create two CSS files and make the master page elements invisible in the second css file. Create a new page that uses this css file. You can open this new page as a popup from your original page and save from the popup.
|
|
|
|
|
You mean like what has already been suggested two days ago
Read the original question and the responses.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
yes, I did not read your response
|
|
|
|
|
This won't work for the OP. There is no printing involved, only display.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
My bad, I did not read the question properly, thanks for pointing out.
|
|
|
|
|
Hi,
I have three tables in a dbml file and two Linq queries to get the data using Linqs. The first linq query gets some data from a table and then on this same collection we apply 2nd query. Eventhough after I check for the null value on the variable I get table not found exception.
So I want to check whether the table we applied the first linq has the required table or not. I am giving the code block below.
I want to check a specific table parallelDataContext.teQUTUDatas in dbml exists in database or not?
private int? GetTeQUTUData(int quarterlyUpdateJobId, int quarterlyUpdateSubscriptionId)
{
int? tuReportBinaryDataID = null;
if ((parallelDataContext != null) && (parallelDataContext.teQUTUDatas != null))
{
return parallelDataContext.teQUTUDatas.Where(d => d.QuarterlyUpdateJobID == quarterlyUpdateJobId &&
d.QuarterlyUpdateSubscriptionID == quarterlyUpdateSubscriptionId).
Select(a => a.TUReportBinaryDataID).FirstOrDefault();
}
else
return tuReportBinaryDataID;
}
Thanks & Regards,
Abdul Aleem Mohammad
St Louis MO - USA
|
|
|
|
|
Typically all tables should be created before using the database. Normally tables are created when the application is installed, updated or used for the first time thus a "table not found" would not occurs.
Philippe Mori
|
|
|
|
|
Actually in my case there are two different jobs that create the tables and fill the data. But when I am showing the view, I am showing all.
So when job1 runs it will not have some tables and when job2 the same it will not create some tables.
For every run all the tables will be dropped and then created and loads the data.
In that case I want to check before hand that whether the table exists or not. If it fails I want to return null or handle the situation.
Thanks & Regards,
Abdul Aleem Mohammad
St Louis MO - USA
|
|
|
|
|
Is there a reason to drop the table instead of simply deleting all rows ?
By the way if you have 2 independant jobs, there will always be a risk that the table get dropped between the time you make the check and the time you try to access the data.
Anyway, I would say that in this case (if you do drop the tables) the best solution is not to do the test the existance of the table but catch and handle the exception (you might check the error code or if the error message contains the name of the table and only handle the error if it is expected).
If the view run independly of the jobs, handling exception is a must as otherwise you will sometime have a bad timing where the table would be dropped just after you check its existance.
I think that you should avoid dropping and recreating the table as you will be able to avoid to deal with that problematic situation.
Philippe Mori
|
|
|
|
|
Hi,
No I cant stop dropping and creating the tables. They are actually old and new jobs so they run. I need to handle it in good way.
I thought if I could check the db before I run the get method, I can easily pass through this without exception.
I dont want it to go till exception, before that only I want to handle using if else.
Is there any way that either by using the context object or by using the dbml table object on the context, I can check for existence of any table.
Any help is welcome. Thanks in advance.
Thanks & Regards,
Abdul Aleem Mohammad
St Louis MO - USA
|
|
|
|
|
I don't know if Linq to SQL make this information available but you can always test it "directly" if you need to. Check online help or code to see if a method exists to check for the existance.
I think that in my case I was doing an SQL query to check the existance of columns in a table when doing database upgrade. For that, you should do a google search.
As I said, handling the exception would be in my opinion the way to handle that... as even if you check the existance of the table, there is a slim chance that the table is deleted by the job between the check and the actual use of the table.
Also checking the existance explicitly will required twice as must request to update your view except if you instead write SQL stored procedure but then you won't be able to use Linq to SQL as you do.
IEnumerable<MyData> GetData()
{
IEnumerable<MyData> enumerable = null;
try
{
var query =
from m in dataContext
select m;
enumerable = query.AsEnumerable();
}
catch (SQLException ex)
{
if (ex.SomeCheck)
{
var list = new List<MyData>();
enumerable = list;
}
else
{
throw;
}
}
return enumerable;
}
You might also check : http://stackoverflow.com/questions/4520209/how-to-check-if-table-exists-in-model-but-not-in-database[^]
Or
http://leedumond.com/blog/check-if-a-table-exists-in-a-sql-server-database/[^]
Or
http://stackoverflow.com/questions/167576/sql-server-check-if-table-exists[^]
But I have warn you that if the jobs and the view run asynchronously, there is a slim chance that you could have an exception even if you do the check. That percentage will depend mainly on how often jobs are run and the duration of operation. If jobs run every few seconds and check are done at a similar rate, there is an high probabily to have an exception even with a check. On the other hand, if update are done every few hours it might take year before the problem would occurs once.
The best way is to first add the exception check and test the code. If it works and you still want to add a check anyway and don't bother with the extra SQL request, you can then add that the check being confident that the catch would get the exception in case of a bad timing.
Philippe Mori
|
|
|
|
|
Perhaps you should be posting these questions to the Linq forum.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Hi All,
I have created few Linq Queries using Lambda expressions in my application, and I got feedback that my Linq Queries and Lambda expressions are taking more memory. I dont know how to see that, but he told me.
Can anybody please advice me how to create Linq and Lambda expressions by consuming very less memory. I am new to the Linq and Lambda. I am giving my code below please advice me any kind of help is greatly appreciated.
Either give me idea or links to write efficient linq and lambda's or give me any alternate solution if we have other that linq and lambda.
And one more thing is that we are using Linq to SQL to connect to the database.
Below is the Code:
public string GetQuarterlyUpdateTUCDataXml( int quarterlyUpdateJobId, int quarterlyUpdateSubscriptionId)
{
string strQuarterlyUpdateDeltaReport = null;
var quarterlyUpdateSubscription = parallelDataContext.teQUTUDatas.Where(c => c.QuarterlyUpdateJobID ==
quarterlyUpdateJobId && c.QuarterlyUpdateSubscriptionID == quarterlyUpdateSubscriptionId).ToList();
if ((quarterlyUpdateSubscription != null) &&
(quarterlyUpdateSubscription.Count > 0))
{
byte[] encryptedBytes = (from a in quarterlyUpdateSubscription
join
b in parallelDataContext.teBinaryDatas on
a.DeltaReportBinaryDataID equals b.BinaryDataID
select b.Data).FirstOrDefault().ToArray();
strQuarterlyUpdateDeltaReport = (encryptedBytes != null) ?
objCommon.GetDecryptedReportString(encryptedBytes) : "";
}
return strQuarterlyUpdateDeltaReport;
}
Thanks & Regards,
Abdul Aleem Mohammad
St Louis MO - USA
|
|
|
|
|
indian143 wrote: I dont know how to see that, but he told me.
Who told you there were using too much memory? How did they know? Did you ask? More memory compared to what? Is it the query or the data that is taking up too much memory?
Linq does use more memory than traditional ADO.NET but there isn't much you can do about it and the trade-off is more beneficial in ease of use, maintenance, extensibility and in some cases performance.
from a in quarterlyUpdateSubscription
join b in parallelDataContext.teBinaryDatas on
a.DeltaReportBinaryDataID equals b.BinaryDataID
select b.Data
Since we have no idea what data is behind this an accurate assessment can't be made. However, if there are large sets involved here it will of course use more memory to store and perform the query and join. If you can reduce the size of the set it may help.
I know the language. I've read a book. - _Madmatt
modified on Friday, July 1, 2011 12:19 AM
|
|
|
|
|
Hi,
Thanks for the reply, its not compared to any thing. But its taking 1 GB memory my architect said. And one more thing it could be data only that is taking more memory.
Now, I will put the question in different way
Can I tune my Linq and Lambda query to select less data and use less memory so that I can improve my functions performance? Below is the code.
Thanks for any kind of help, thanks in advance.
public string GetQuarterlyUpdateTUCDataXml( int quarterlyUpdateJobId, int quarterlyUpdateSubscriptionId)
{
string strQuarterlyUpdateDeltaReport = null;
var quarterlyUpdateSubscription = parallelDataContext.teQUTUDatas.Where(c => c.QuarterlyUpdateJobID ==
quarterlyUpdateJobId && c.QuarterlyUpdateSubscriptionID == quarterlyUpdateSubscriptionId).ToList();
if ((quarterlyUpdateSubscription != null) &&
(quarterlyUpdateSubscription.Count > 0))
{
byte[] encryptedBytes = (from a in quarterlyUpdateSubscription
join
b in parallelDataContext.teBinaryDatas on
a.DeltaReportBinaryDataID equals b.BinaryDataID
select b.Data).FirstOrDefault().ToArray();
strQuarterlyUpdateDeltaReport = (encryptedBytes != null) ?
objCommon.GetDecryptedReportString(encryptedBytes) : "";
}
return strQuarterlyUpdateDeltaReport;
}
Thanks & Regards,
Abdul Aleem Mohammad
St Louis MO - USA
|
|
|
|