|
asp_crazy_guy wrote: in datatable 3, I want results whose id is not zero in datable 2
Your example shows 0 PPP in datatable 3!
Assuming you dont want certain rows, two ways:
1. (better one): Do this in SQL query while fetching data filter out that are having ID 0
2. In code-behind, run two foreach loops. First one on table1 and second one on table 2. In first foreach, check the value of ID, and based on your condition if the row is fine add that to the third table.
Repeat the same with second foreach loop done on table2.
End result would be Table3 with data you want.
|
|
|
|
|
Thanks for the reply. I only want to filter out records in table3 which have zero id in table2 and have a non zero id in table1. The records with zero id in table 2 and not existing in table1 are to be included in table3.
Actual problem is that,
1) On a webform, there is a list of records returned from datatabase (table 1)
2) In edit form, user can edit these records from a checkbox list
3) Now for the newly selected records, I am having a zero id (all operation is done in datable)
4) For previously selected records they have a non zero id.
5) Table 1 is original records, table2 is new list after selection
6) Now on form update button I have to find which records to insert into database and which ones to drop, update etc
Hope you get my point. Can you help a little bit more ?
|
|
|
|
|
asp_crazy_guy wrote: 6) Now on form update button I have to find which records to insert into database and which ones to drop, update etc
Just use 2nd table for update. Why you need table1. Only table2 has the records that was selected and modified. No need of filter.
|
|
|
|
|
Hi How are you professional..
Just i need to know present i m working on vs2005 asp.net with c#,
my requirement is reports.
present i m using crystal report but i cannot able to understand how to do continuously reports using crystal reports. And do u know any best software for reports. and i need to provide interface to my support team bcos every time they will design reports.
|
|
|
|
|
|
I have a wdsl file and I need to create the proxy class to be able to call a web service from a .net application. Do I need the URL link of the web service in order to call the service?
I use the following syntax to generate the proxy class from wdsl as follows
wsdl /language:cs /protocol:soap c:\wdsl\Service1.wdsl
How do I import into my .net application that will call the class?
How do I call the service if I don't have the url link?
Sorry I am new to this
Thanks
|
|
|
|
|
I created a png background image with a transparent area. When I place it in my asp page, I get an image with a gray background instead of the transparent area. As I know, it should be transparent in my page as well. Any solution?
|
|
|
|
|
Which browser you are using? anyway refer this one PNG Fix[^]
|
|
|
|
|
Hi, I have a gridView with a colunm
Adress-A SiteName-A ServiceType-A Address-B SiteName-B ServiceType-B Edit-A Edit-B
it could be possible, if i click on Edit-A only the fields (Adress-A SiteName-A ServiceType-A) shown in edit mode and when i click on Edit-B the field (Address-B SiteName-B ServiceType-B) will show in edit mode in a grid.
KnightGuy
|
|
|
|
|
In the ItemCommand event find out which button was clicked by using the CommandArgument attr.
This could then fire a switch to choose the correct method (SetupFormA, SetupFormB) for looping thru the GridView so you can find and changing the the form fields required.
I haven't tired this myself but that's how I would go about it to start with.
|
|
|
|
|
How can i validate a masked text box with out accepting any blank spaces. When i custom validate a masked textbox by giving 0 or 9. it is accepting spacebar as well.
|
|
|
|
|
Mohan86 wrote: validate a masked text box with out accepting any blank spaces
What do you mean by validate a masked textbox? If it's a masked textbox it already is customized to accept certain formatted value.
Mohan86 wrote: When i custom validate a masked textbox by giving 0 or 9. it is accepting spacebar as well.
If you are using existing masked textbox(someones custom made), then look at the source code and handle it.
If you are making one yourself, then handle the issue. Regex or Javascript can be used to handle it.
Currently, it sounds like when you use 0 or 9, the masked expression used is faulty and accepts space.
|
|
|
|
|
GridView and ListView constrols have ItemCommand event where I can react to events generated by Button controls in the individual items. Is there a way to detect and handle events raised by non-Button controls (like CheckBox with AutoPostBack=true)? I spent several hours trying to do this but totally failed. Do you have any ideas? Any help appreciated.
|
|
|
|
|
|
Thanks for the reply. What exactly do you mean by using ItemCreated event in combination with event bubbling? I don't get it. I understand that I can create my own control derived from checkbox which, when checked, raises a bubble event which is then cought by the ListView. Is this what you meant?
Otherwise, the first link you posted provides a fairly easy solution, without event bubbling at all.
|
|
|
|
|
Member 1033907 wrote: Is this what you meant?
No. In ItemCreated, find the control and attach the hanlder. Though as you already saw, other approach could be done easily. It's just that event methods needs to be public or protected.
|
|
|
|
|
So I attach the handler and in the handler, call the RaiseBubbleEvent? I'am afraid I still don't quite get it but it's more a matter of curiosity now, I can put together some working solution.
|
|
|
|
|
i want to how to work with lostfocus event in asp.net
plz help with demo program which help me to understand
|
|
|
|
|
Nikhil Bhivgade wrote: how to work with lostfocus event in asp.net
Google for: onBlurr or onFocusOut + Javascript.
You will get lots of samples on them. Using Javascript, you can trap the event client side and process desired code in the method.
|
|
|
|
|
Dear Friends,
I am facing an amazing problem while working with oracle. The "connection was reset to the server" occurs only while requesting for more data(takes 8-10 minutes to execute). I changed the compilation debug=false and executionTimeout to 1200 under httpruntime element to increase timeout value in web.config file and it still doesn't work.
I couldn't figure it out. Could you please help on this issue?
Configuration: Oracle 10g
.Net Framework: 3.5 SP1 with MVC
IIS: 7
Windows 2008 Server
Thanks.
modified on Sunday, June 27, 2010 8:56 AM
|
|
|
|
|
Can we see the code that
requesting for more data
Vuyiswa Maseko,
Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
Hi,
the following query
# DECLARE @MATIERE nvarchar(max) <br />
# SELECT @MATIERE = <br />
# STUFF( <br />
# ( <br />
# select distinct ',[' + LIBELLE_MATIERE + ']' <br />
# from MATIERE where CODE_MODULE =11 <br />
# for xml path('') <br />
# ), <br />
# 1,1,'') <br />
# <br />
# DECLARE @SQL nvarchar(max) <br />
# SELECT @SQL = N' <br />
# select <br />
# * <br />
# from ( <br />
# <br />
# SELECT ETUDIANT.NUM_INSCRIPTION, ETUDIANT.NOM_PRENOM_ETUDIANT_ARABE,EXAMEN.CODE, <br />
# EXAMEN.NOTE, <br />
# MATIERE.LIBELLE_MATIERE <br />
# FROM ETUDIANT INNER JOIN <br />
# EXAMEN ON ETUDIANT.NUM_INSCRIPTION = EXAMEN.NUM_INSCRIPTION INNER JOIN <br />
# CAPITALISE_MODULE ON <br />
# ETUDIANT.NUM_INSCRIPTION = CAPITALISE_MODULE.NUM_INSCRIPTION INNER JOIN <br />
# MATIERE ON EXAMEN.CODE_MATIERE = MATIERE.CODE_MATIERE INNER JOIN <br />
# MODULE ON CAPITALISE_MODULE.CODE_MODULE = MODULE.CODE_MODULE <br />
# AND MATIERE.CODE_MODULE = MODULE.CODE_MODULE <br />
# WHERE (CAPITALISE_MODULE.CODE_MODULE = 11) AND <br />
# (CAPITALISE_MODULE.CODE_TYPE_RELATION_MODULE = 1) <br />
# ) Data <br />
# PIVOT ( <br />
# SUM(NOTE) <br />
# FOR LIBELLE_MATIERE <br />
# IN ( <br />
# ' + @MATIERE + ' <br />
# ) <br />
# ) PivotTable <br />
# ' <br />
# <br />
# exec sp_executesql @SQL
this query shows this:
num-inscription__NOM_PRENOM__subject1_____subject2_____
I want to display in a gridview with all columns are in edit mode except num_inscription and nom_prenom and then insert all in database .
Help me please.
Thanks
|
|
|
|
|
amina89 wrote: I want to display in a gridview with all columns are in edit mode except num_inscription and nom_prenom
If by default you want to show grid id edit mode, then use textboxes for subject1 & subject2 in ItemTemplate . Use labels for num_inscription & nom_prenom. Use standard way to insert the data.
If you have an event to change normal gridview to edit mode then, use textboxes for the editable fields in EditTemplate and labels for non-editable in edittemplate. On update of row, insert the data in database.
|
|
|
|
|
Hi;
but I do not know the number of subjects that is the title and the number of columns.
Thanks.
|
|
|
|
|
Hi,
I have implemented the ICallbackEventhander interface and successfully updating the page asynchroniously on keydown on a textbox. I tried to implement the same with the click event of the asp.net button or imagebutton's click event but RaiseCallback is invoked and then the GetCallbackResult() is called but the last client side javascript function is not called that infact updates the page, hence the page not updates. Also once the page is partially updated on keydown of textbox, after that no server side event is triggers. What could be the issue. Any code or reference url for the solution of this problem will be much appreciated.
Thanks,
Safvi
|
|
|
|