ASP.NET

Re: Get all the values from HttpContext.Current.Cache

4-Jul-11 2:21

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

RaviRanjanKr4-Jul-11 6:33

RaviRanjanKr

4-Jul-11 6:33

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).

Only Save Contentpage

Elham M2-Jul-11 6:03

2-Jul-11 6:03

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

Not Active2-Jul-11 7:22

2-Jul-11 7:22

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

Elham M2-Jul-11 9:06

2-Jul-11 9:06

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 .

Not Active2-Jul-11 10:02

2-Jul-11 10:02

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

Elham M3-Jul-11 6:21

3-Jul-11 6:21

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

Not Active3-Jul-11 11:08

3-Jul-11 11:08

.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

Shameel3-Jul-11 20:38

3-Jul-11 20:38

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.

Elham M3-Jul-11 23:46

3-Jul-11 23:46

I've khnew this tag for print and I've used it but this tag just for print it's not for save button!

Shameel4-Jul-11 7:53

4-Jul-11 7:53

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.

Not Active4-Jul-11 8:32

4-Jul-11 8:32

You mean like what has already been suggested two days ago Roll eyes | :rolleyes:

Read the original question and the responses.

I know the language. I've read a book. - _Madmatt

Shameel4-Jul-11 8:47

4-Jul-11 8:47

yes, I did not read your response Roll eyes | :rolleyes:

Not Active4-Jul-11 2:19

4-Jul-11 2:19

This won't work for the OP. There is no printing involved, only display.

I know the language. I've read a book. - _Madmatt

Shameel4-Jul-11 7:44

4-Jul-11 7:44

My bad, I did not read the question properly, thanks for pointing out.

Linq to SQL dbml file

indian1431-Jul-11 13:19

1-Jul-11 13:19

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

Philippe Mori1-Jul-11 13:56

Philippe Mori

1-Jul-11 13:56

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

indian1431-Jul-11 14:54

1-Jul-11 14:54

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

Philippe Mori1-Jul-11 16:01

Philippe Mori

1-Jul-11 16:01

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

indian1431-Jul-11 19:12

1-Jul-11 19:12

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

Philippe Mori2-Jul-11 2:58

Philippe Mori

2-Jul-11 2:58

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)
    {
       // Empty enumerator
       var list = new List<MyData>();
       enumerable = list;
    }
    else
    {
       // Unknown problem --- rethrow the exception
       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

Not Active1-Jul-11 15:12

Linq to SQL is taking more memory

1-Jul-11 15:12

Perhaps you should be posting these questions to the Linq forum.

I know the language. I've read a book. - _Madmatt

indian14330-Jun-11 14:06

Re: Linq to SQL is taking more memory [modified]

30-Jun-11 14:06

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) : ""; //objCommon.GetDecryptedReport(encryptedBytes); //                       
            }
            
            return strQuarterlyUpdateDeltaReport;
        }

Thanks & Regards,

Abdul Aleem Mohammad
St Louis MO - USA

Not Active30-Jun-11 15:07