|
I don't know exactly what you mean, but I understand it as the following.
If Sum(...) Is NULL, Use value XXX
You should look at the function COALESCE http://msdn.microsoft.com/en-us/library/ms190349(SQL.90).aspx[^]
And you would like to use it as so: COALESCE(SUM(Udgifter.Brugtbeløb),XXX) where XXX is the default value.
|
|
|
|
|
It works fine when SUM returns a value. If not the FormView is completely empty.
|
|
|
|
|
I Have Two Computers And I Want To Make One Of Them Server To The Other.
So When I Make A Web Sit On The Server Named "sanforjackass.ho", I Can See It From Other PC As "http://ComputerName/sanforjackass.ho" .
|
|
|
|
|
Basically you need to have on one machine IIS running, then configure IIS to host and execute your website.
|
|
|
|
|
Thanks.
But Can You Tell Me How To Do It Step By Step.
(I Should Put It In My First Q "What About OS? Does It Works If The Two Computers Have XP OS Or One Windows Server OS And The Other XP OS?")
|
|
|
|
|
|
Could you please tell me where do i get Advanced Tab after clicking on LAn Properties. I only found General And Authentication tabs pls reply.
Thanks
|
|
|
|
|
hi guys
i have developed for now several "middle-difficult" web applications. in short lines, they are all composed of custom controls inerhit from DataGrid or DetailsView, using sql queries to populate them with data. in some case their structure could be quite complex. my approach was this:
lets say we have somewhat complex query:
select
dip.id,
satnica_obilazak,
gg.naziv,
t.naziv,
klijenti,
iznos as dodatno,
(
select top 1 cijena_sata_rada_obilazak
from klijenti_cijene
where datum<=dip.datum and klijent_id=@klijent_id
order by datum DESC, id
) as cijena_sata_rada,
klijent_id
from (((
dnevni_izvjestaj_popis dip
inner join dnevni_izvjestaj_trgovine dit
on dit.izvjestaj_id=dip.id
)
left join dnevni_izvjestaj_troskovi ditr
on ditr.izvjestaj_id=dip.id)
inner join trgovine t
on t.id = dit.trgovina_id
)
inner join grupacije_gradovi gg
on gg.id=dip.grad
where
ditr.klijenti like ('%,'+@klijent_id+',%')
and tip_troska<>1
and tip_troska<>4
and tip_troska<>6
this is copy-paste from my project...
i made "SqlAnalize" class which is accepting string "sql" as argument. in global, it goes character by character and populate ArrayList of table names from sql string compering to joins (inner join, left join, outer join...).
after that i use DataAdapter to populate DataSet with all (or some) tables from sql query. when this is done, algorithm can put DropDownList, CheckBoxList (or whatever i need) in DataGrid.
so here i have ClassLibrary with several controls which works this way...
recently i had to develop some simmilar class like above, but for Xml source. this is where i met "problem". using xml, DataAdapter fills DataSet very "nice"... "nice" would be best word.... and here i met DataRelation class.
i started to study some "DataRelation" tutorials, and find content interesting...
so my question is simple:
my approach in developing "smart" DataGrid(edit, delete, javascript confirm, dropdown list, uploads, wysiwyg, that kind of stuff inside) is using only sql queries. analize somewhat complex query, pass few values via some property, and finaly bind it.
am i doing this wrong way? this DataRelation seems quite interesting. should i change approach? anyone who was working on similiar projects, how did you designed DataSets, DataTable, queries and relation between em?
thanks in advance... and srry for bad english 
|
|
|
|
|
KokosZG wrote: my approach in developing "smart" DataGrid(edit, delete, javascript confirm, dropdown list, uploads, wysiwyg, that kind of stuff inside) is using only sql queries. analize somewhat complex query, pass few values via some property, and finaly bind it.
am i doing this wrong way? this DataRelation seems quite interesting. should i change approach? anyone who was working on similiar projects, how did you designed DataSets, DataTable, queries and relation between em?
I cant understand these few lines 
Well, Regarding DataRelation, it is actually giving some restriction on update of data within a dataset. There is nothing to deal with database if you dont want to use Update to the Dataset again to the Database.
I generally dont use DataRelation as such, I keep foreign key on the database and handle the restriction in database. But seriously, it is nice to have. If you can implement a Relationship in the client end, you can throw error from the application itself, and dont require to run the update in the database.
Note: By client, I mean from Application.
Queries in Database is very different from the Query in DataSets. DataSets are in memory data, while DataBase is the actual storage place.
Please clarify what exactly the problem you are facing to help you ...
Cheers.
|
|
|
|
|
i will try to simplify as much as i can what i wrote ahead.
let's say i need WebControl that can manipulate data from database. WebControl should have 3 fields (columns). when editing or inserting data via this control, first field is plain text (TextBox), other two must be falling menus (DropDownList).
in database i have 3 tables
first table have this structure:
------------------------------------------
id | TextField | Foregin1_id | Foregin2_id
------------------------------------------
second and third have this structure:
---------
id | name
---------
i need to join first table with other two, then bind it to WebControl.
so this is my work:
1. i created custom control (class) "MyGird" inherited from the System.Web.UI.WebControls.DataGrid.
2. i created sql query
select
TextField, t2.name, t3.name
from (
table1 t1 inner join table2 t2
on t2.id=t1.Foregin1_id
)
inner join table3 t3
on t3.id=t1.Foregin2_id
3. i created some code in "MyGrid" that examines sql query, creates DataSet and fill it with all 3 tables, and finaly calls DataBind() function from it's base class System.Web.UI.WebControls.DataGrid.
After bind i have "custom datagird" MyGrid. i can edit MyGrid and manipulate (insert, delete, update) data from first table of database in many ways, depending on "some code i created".
so the "problem" is that this "some code i created" is not very "nice". some parts of code is hard to read. globaly this approach doesn't feels right.
so question is; can i use DataRelation for joining data from more tables instead of using sql join? DataRelation seems to me like thing i have been mising for creating "MyGrid" in right way....
|
|
|
|
|
can anybody help me , how to create a chart in crystalreport in bar template or bar model, can give me any link about this or can guid me?
|
|
|
|
|
|
Hi,
I want to update resource file that are already published
Is there any way?
Waiting for quick reply
Known is a drop, unknown is an ocean
|
|
|
|
|
|
Hi,
I have created a web survey control which is working fine, now I have to create same thing for desktop application [Survey control for desktop application].
Please let me know your suggestions.
Can I create a survey type of desktop application in WPF?
I am working in VisualStudio2008 using C#.
Thanks
|
|
|
|
|
Please do not cross post.
50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!
|
|
|
|
|
Why dont you try out Silverlight...
Silverlight 3.0 has out of browser support. So, you can make a web silverlight applet to work in desktop...
|
|
|
|
|
hi
I want to delete a file(xml file) on page_unload event
as
protected void Page_Unload(object sender, EventArgs e)
{
File.Delete(MapPath(@"~/App_Data/abc.xml"));
}
but it gives error "Object reference not set to an instance of an object." but it working fine on page_load event please suggest me if i am wrong.
Thanks in advanced
Abbas
|
|
|
|
|
Member 3169981,
When you write MapPath, by default it refers to Page.MapPath method. Now in Page_Unload method, page object can not be accessed, therefore Page.MapPath method throws an exception "object reference..."
Instead use, Server.MapPath to delete any file inside your Page_Unload method. Should be fine.
Thanks,
Arindam D Tewary
|
|
|
|
|
Thanks Arindam, now it's working with Server.MapPath()
|
|
|
|
|
Thanks,
Arindam D Tewary
|
|
|
|
|
I have a requirement to place to pagable grid inside a webform and display that form as a pop up from button click other window.
Pop up window should have to take the employee name search string and it should display all the emp details (Id(hided),Name,Deaprtment,Location)
in the gridview through bounded link and text controls.
upon selection of a perticular employee by clicking on the underlying linkbutton pop has to be closed and both name and departnames has to be passed back to the parent window.
i tried by implementing modelDialog windows method
these are the issues i found
1)I can't passback the Binding values to the javascript function
2)When i clicked on the linkbutton in the gridview a new browser window is opening with the do_postback.......... as its url
3)I have seen any javascript block executing on the page.
could anyone give me an idea about how to go ahead with this?
Thanks in advance for any suggestions.
|
|
|
|
|
Hii,
I am doing a community project.There client asked me to implement "cooliris" for pages.Could you guys can help me ?..any idea ?
With warm regards
|
|
|
|
|
Never heard of it but if you check out Google - the top search comes up with a site selling you a Flash 3d viewing app. Maybe that's what they want you to use - or something like it.
|
|
|
|
|
Hi,
I am using fileupload control in asp.net. am selecting the file using browse button of file upload control. But due to postback event of any other control on the page the content(file path) of the fileupload textbox gets cleared... Viewstate is enabled to this control.
How to solve this problem??? am using vs 2008 and c#...
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
