|
using (apReportDataContext context = new apReportDataContext())
{
var appointments = (
from app in context.t_msts
join li in context.Lead_In
on app.apm_LeadID equals li.iLeadID into app_li
from li in app_li.DefaultIfEmpty()
join cs in context.custContactInfos on li.iLeadID equals cs.id into li_cs
from cs in li_cs.DefaultIfEmpty()
join apm in context.atm_appointment_type_masts on app.apm_type_id equals apm.atm_id into cs_apm
from apm in cs_apm.DefaultIfEmpty()
select new
{
app.apm_id,
app.apm_name,
app.apm_desc,
app.apm_start_time,
cs.CustomerName,
apm.atm_type_name,
});
grv.DataSource = appointments.Distinct();
grv.DataBind();
}
this is generating me result as expected now i need to pass paameters to this when generate report button is clicked, i have a drop down and if drop down value !=0 then i have to pass the value of it and if another text box field is filled then i have to pass that also as a parameter
how can i do this?
|
|
|
|
|
You need to use where keyword here. It behaves same as the where clause in the SQL statements. Something like this:
from element in someIEnumerable
where element.property == someValue
select element
|
|
|
|
|
thanks for your reply
yes what you said is working but if suppose user not entering value of text box then the value will be empty, this will give error, i need to check as this for 5 input controls, and if a control value is not empty then i have to pass that one as a parameter. how to do this.
|
|
|
|
|
If those values are mandatory, use RequiredFieldValidator. If not, then you will have to check for the null values.
Since I do not know the exact scenario in your application, cannot provide any better solution.
|
|
|
|
|
Thanks again for your reply ..
finally i got a solution and i have done it as below.
using (apReportDataContext context = new apReportDataContext())
{
var appointments = (
from app in context.t_msts
join li in context.Lead_In on app.apm_LeadID equals li.iLeadID into app_li
from li in app_li.DefaultIfEmpty()
join cs in context.custContactInfos on li.iLeadID equals cs.id into li_cs
from cs in li_cs.DefaultIfEmpty()
join apm in context.atm_appointment_type_masts on app.apm_type_id equals apm.atm_id into cs_apm
from apm in cs_apm.DefaultIfEmpty()
select new
{
app.apm_id,
app.apm_name,
app.apm_desc,
app.apm_start_time,
cs.CustomerName,
apm.atm_type_name
}
);
if (dropdown.SelectedIndex != 0) appointments=
apps.Where(ap => ap.apm_ID.Equals(dropdown.SelectedValue));
grv.DataSource = appointments.Distinct();
grv.DataBind();
|
|
|
|
|
hello everybody,
in my web site i have two databases, ASPNETDB.MDF and a self created one (database.mdf). (The don't contain a lot of data yet) But i need a relationship (foreign key) between a table in ASPNETDB.MDF and a table in database.mdf.
So i guess i need to merge both databases first, would you just extend the "ASPNETDB.MDF" with the tables from "database.mdf" ? or better configure "database.mdf" for the asp.net Applicatoin Services and then delete "ASPNETDB.MDF" ? Is "ASPNETDB.MDF" even meant to be used in a production online web application?
(Right now i'm using sql server express but i will probably use sql server when deploying Site to a shared host)
thanks a lot for answers
|
|
|
|
|
Merge the two databases on One! and then make your relationship with tables.
|
|
|
|
|
Hi,
I am trying to bind a XML file to a grdiview and get an error:
The data source for GridView with id 'gvPhotos' did not have any properties or attributes from which to generate columns. Ensure that your data source has content.
I found out that I have to make and xsl format to solve this issue. Here is the original XML file.
What's the correct XSL format for it ? Thanks for the time and effort.
<gallery>
<settings>
<imagesFolder>friedmans-admin/Photos/</imagesFolder>
<bgImage alpha="100" source="images/bg.jpg"/>
<image align="center" cornerRadius="0" scaleMode="fill" transitionEffect="fade" useShadow="true"/>
<thumbnail width="60" height="40" cornerRadius="0" alpha="70" outlineColor="0xFFFFFF" outlineColorOnRollOver="0xFFFFFF" outlineColorOnClick="0x8B0000" useShadow="true" usePreview="true"/>
<thumbBar scrollSpeed="10" position="bottom"/>
<preview alpha="100" width="200" height="100" outlineColor="0xFFFFFF" useShadow="true" cornerRadius="0"/>
<caption position="bottom" visibleMode="onRollOver" bgAlpha="30" color="0xFFFFFF" bgColor="0x000000" fontName="Verdana" fontSize="12"/>
<slideshow start="false" delay="3" loop="true" stopAutoOnClick="true"/>
<preloader alpha="100" usePreloader="true" />
<buttons fullScreenButton="true" navigationButtons="true" slideshowButton="true" />
<sounds onRollOver="sounds/over.mp3" onClick="" />
<picasa user="" albumID="" />
</settings>
<items>
<item source="1.jpg" thumb="" description="Image 1" link="http://flash-gallery.com" target="_blank"/>
</items>
</gallery>
|
|
|
|
|
Hi,
I've written a stream to minify HTML code and I want to make it run every time a response is completed.
To do this, I've created a module that registers this stream using the Response.Filter property.
The problem is that on some pages of my website, I get an ObjectDisposedException while writing in the base stream (the original value of Response.Filter).
Any solutions?
PS: the only difference between the "working" pages and the "not working" pages, is that the not working page contains a TabControl.
I hope the TabControl isn't the cause of this exception!
|
|
|
|
|
Hi,
I have this class:
[Serializable]
public class Item
{
public string ProdName { get; set; }
public string Qty { get; set; }
}
[Serializable]
public class Order
{
public DateTime Dt;
public int CustomerId;
public List<Item> Items;
}
It's implemented in a separated assembly and is used in a lot of projects (the class is bigger than it appears here)
When I made a webService to return a List<item>, I have two problems.
1) The WebReference I add in the client has a definition of Order that the compiler thinks it's not from the assembly they are defined into. I can't cast. I have to create a List<item> and populate with the data returned from the WebMethod. Worst, It doesn't return a List<>, it returns an [].
2) The Item.Items is not a member of this new (mirror) type the webservice declares?
Is there a way to fix it? At least the #2?
Thanks,
Dirso
|
|
|
|
|
|
Hi!
1) I see, i think it would work, but the other problems keep comming
2) Didn't work for me. The Items are a IList<item> I tried to XmlInclude Item, but it still doesn't seem to be exported
Thanks,
Dirso
|
|
|
|
|
Dirso wrote: 1) The WebReference I add in the client has a definition of Order that the compiler thinks it's not from the assembly they are defined into. I can't cast. I have to create a List and populate with the data returned from the WebMethod. Worst, It doesn't return a List<>, it returns an [].
This is correct (and good!) behaviour. The web service is supposed to be agnostic of the client (for example a Java client can consume a .Net web service and vice versa). This is the reason the list is returned as an array, as all languages have the concept of an array, but not a list. The same goes for the Order type not casting, the message passed between the client and server is just a "value bag" that looks like an object, you are supposed to populate proper objects from them when then response is recieved. When you generate the client, a new class type is created. The generated class will have a different namespace but normally the same name as the originating server type. This won't cast as it is a completely different type as far as the runtime is concerned, you have to write a convertor if you wish to include the original class. Web Services != Object Orientation.
|
|
|
|
|
Yeah, you're right, it should be independent... it's just a lot of extra work (my objects are much more complex than what I showed).
Thanks,
Dirso
|
|
|
|
|
i am a learner in asp.net. i want to know about web service in asp.net.
why we user web service?
how to use?
if any category in web service?
Thanks
|
|
|
|
|
Any_India wrote: why we user web service?
To call methods on servers across a network, commonly the Internet or a Corporate Intranet.
Any_India wrote: how to use?
In general the web service publishes which methods are available and a tool is used to generate a set of client classes. The class used to communicate with the service is called a proxy.
Any_India wrote: if any category in web service?
I'm not 100% clear about this question. SOAP is the main technology this[^] explains the basics of a SOAP service for beginners to the subject. WCF is a Microsoft technology that is an enhancement over plain SOAP services. If you are going to implement a webservice in .net I'd start with WCF, it is easier IMO, and you can expose a plain SOAP endpoint if you need it.
|
|
|
|
|
Thanks for your reply.
now i will study your link details.if i got any help to implement web service plz help me.
|
|
|
|
|
Any_India wrote: got any help to implement web service plz help me.
I suggest you try and implement a web service first  ! If you get stuck, ask questions in this forum and someone (me if I am online and able) will help if they can. Good luck!
|
|
|
|
|
Hi,
what's the web way to develop a multi language website? what's your advise?
Thanks...
|
|
|
|
|
That's a really broad topic, and the strategies for coping with this are numerous. At the very least - don't fix your layout; remember that some people use RTL and others use LTR; don't hardcode any strings - at the least, they should come from a resource file; don't hardcode references to images - certain images mean different things in different countries, and always respect the culture settings.
|
|
|
|
|
I started work in Jordan, and I've very recently had to ford this stream myself.
Everything Pete says in his post is sound: Extract Strings and Image references to Resx files. For your Default.aspx page you'll have Default.aspx.resx for the Invariant culture (This should be English: the browsers default to US-English, but you can select Arabic as the culture in some browsers.) You can then add Default.aspx.ar.resx for generic Arabic and add regional variations e.g. Default.aspx.ar-JO.resx. Note that the where the value isn't available in the most specific resx file, .net applies the next most specific then the invariant. So Jordanian --> Generic Arabic --> Invariant. If the user's browser is set to Arabic culture, the framework will attempt to get the Arabic version of the page.
I also found it useful to remove any styling from the ASPX page, and put it into a theme / css. file. Additionally I try to avoid css styling involving the words "left" or "right" though these are needed occasionally. Luckily pretty much any asp.net property can be set through the meta:resourcekey attribute, which includes the CssClass attribute, overriding the default style .
I found these very helpful:
http://msdn.microsoft.com/en-us/library/c6zyy3s9.aspx[^]
and this if working with master pages:
Developing an ASP.NET page with MasterPage and Localization[^]
|
|
|
|
|
I have a dataGrid. Inside that gird i have text box. And there is textbox for search in outside the grid. once i enter searching criteria and press search button(outside the grid) it will search and focus to the first text box which inside the grid. it will work fine. but i hit enter key it will search but it does not focus to the datagrid first text box. please help me to focus the cursor to the first text box of datagrid when press enter
Note : All the controls are inside one updatepanel.
Dushan Perera
|
|
|
|
|
how to select design patterns according to project
|
|
|
|
|
It is mostly about experience. Design patterns get their name from their repetitive nature. When you have seen one type of problem often enough you can tell when a similar solution would apply. Patterns can be at very different levels of the software architecture though. A pattern like the Party pattern is pretty high level and implies data models. A pattern like Observer can be much lower level and might only apply to an event on a single control like a button click or it could be very high level and be applied to a message queue in an enterprise service bus.
Be careful about patterns. They can be a lot like fads. When Microsoft released the MVC framework tons of people decided that they had to shove all their projects into that pattern. But if you only ever have one view and that view has to re-implement a lot of the business rules that would also go in the model (client side validators in the view and further validation in the domain objects), you aren't buying yourself much.
|
|
|
|
|
anoop_m83 wrote: how to select design patterns according to project
Obiously, its is based on the requirement. At the time of design, one should decide, what pattern best suits for the requirement. At some point, tailoring of an existing pattern ,might be required also.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
