|
There is no any in-built functionality to check the duplication at the
time of updating row.
On GridView1_RowUpdating event when you try to update your data to database,
you need to check the duplication manually.
So if there is duplication, you can simply avoid update and give proper message
or take action accordingly.
From following link you will get an idea.
http://www.aspdotnetcodes.com/GridView_Insert_Edit_Update_Delete.aspx[^]
Hope this will help!
Jinal Desai - LIVE
Experience is mother of sage....
|
|
|
|
|
Hi,
I had created Graphs using Fusion chart.
The graph is displayed.
I want to remove Fusionchart text or label in the graph ie "Fusion charts Evaluation" in the shockwave file.
Can we place a color strip to cover it?
I need the html code to cover the strip.
<embed style="WIDTH: 420px"
="" name="FC2Column" src="Charts/<%=chart%>?dataXML=<%=str_Xml%>&chartWidth=420&chartHeight=190" width="420" height="190" type="application/x-shockwave-flash" quality="high" bgcolor="#ffffff" />
Reference:http://www.fusioncharts.com
Thanks
S.Guhananth
|
|
|
|
|
It is only possible if you either purchase license version of fusion chart
or edit swf file and remove it manually.
However, it is illegal to use fusion chart in such way.
Following link will make it clear.
http://www.fusioncharts.com/forum/Topic24392-40-1.aspx[^]
Hope this will help!
Jinal Desai - LIVE
Experience is mother of sage....
|
|
|
|
|
Hi All,
I am showing some data in my web page which is coming from database sql.
When i exec proc in database then it shows 128 records but when i try to show data in web page on click of button then it does not get data. it still shows page is loading in task bar.
what could be the problem?
thanks in advance.
Regards,
Gourav tyagi
|
|
|
|
|
Your application does not connect to db wheather u get a Timeout error.
Please check that........
|
|
|
|
|
It may not be problem with SP.
It can be problem with connection string , passing wrong number or type of parameters to sp.
|
|
|
|
|
Is your connection to the database successful?
What is the error message that the browser shows?
Can you debug the application? If yes, check where are you getting the error and give details.
..Go Green..
|
|
|
|
|
In my application,i have many web pages. When certain conditions are met, i want to disable all the controls in the web page.
The problem is that when contorls are disabled, it is grayed out and users find difficulty to read the data in controls (textbox, radiobuttonlist, checkboxlist,drop down). Is there any solution to allow controls look as they are enabled even in disabled state.
Any help appreciated..............
|
|
|
|
|
Make Control Readonly property =true on page load.
Ex txtAddress.ReadOnly=true; on page_load
Hope this may help u...........
|
|
|
|
|
Its ok with textbox but still problem exists with other controls...
|
|
|
|
|
See below link you can make it using a Javascript
Link
|
|
|
|
|
Dear All,
I am new to Ajax Collapsible panel , I have a one gridview which is inside the collapsible panel.I need to bind this grid when i expand the collapsible panel by cliking on image Button.
Can any one help me
Thanks
Anil
|
|
|
|
|
Hi,
I need to do Click in and Click out functionality in dot net.
Can you anybody give idea plz?
Thanks,
Periyasamy.R
|
|
|
|
|
Please explain in detail what adjactly you mean by click in and click out? and what do you want
|
|
|
|
|
Hi,
Thank you for your reply. Its a advertisement. click-in is that the users are coming to our site by clicking(or using) other sites. click-out is that the users are going to other sites by clicking (or using) our site. Thats it. For this i need some basic ideas on implementation.
Regards,
Periyasamy.R
|
|
|
|
|
yes you have to do as same as sandeep said.
|
|
|
|
|
Hi,
Thank you very much for your idea.
Regards,
Periyasamy.R
|
|
|
|
|
Where ever you are advertising your site(putting a link), add a querystring that tell you it was directed from a certain site (you can also put site specific query string to know which site led to yours!). So now, when your site is hit, you can get from the querystring that it was directed to yours from XYZ place...
For going to other site from yours, you can always know that someone is navigating away from your site. Capture that in your event and use it the way you want. To be more sure, you can add some javascript code to the links that are being clicked. In the javascript code, using XMLHTTP Request handle the click event counter to your need.
|
|
|
|
|
Thank you for this information. I will try to implement this.
Regards,
Periyasamy.R
|
|
|
|
|
Hi, I could understand with your idea.Can you post some example?
Thanks you
Periyasamy.R
|
|
|
|
|
Hi,
Thank you very much for your idea. its very useful.
Regards,
Periyasamy.R
|
|
|
|
|
Hi all
I have a work to integrate two different web application in one
1. First one use Enterprise Library 4.1(say Microsoft.Practices. EnterpriseLibrary. Logging, Version=4.1.0.0)
On the other hand
2. Second one use two thirdparty
a) Enterprise Library 3.1(say Microsoft.Practices.EnterpriseLibrary.Logging, Version=3.1.0.0) and
b) CompositeWebClientLibrary-2008( say Microsoft.Practices.CompositeWeb.dll version 2.0.2)
We know, CompositeWebClientLibrary-2008 have strict dependence on Enterprise Library 3.1
* Based on above issues, I have to update Second one using Enterprise Library 4.1.
* Its clear to us: if we update Second one using Enterprise Library 4.1 the existing CompositeWebClientLibrary-2008 does not support Enterprise Library 4.1.( bcoz CompositeWebClientLibrary-2008 have strict dependence on Enterprise Library 3.1)
Please help me by informing about such CompositeWebClientLibrary that supports Enterprise Library 4.1
shahdat
|
|
|
|
|
Hi
I have a detailsview which uploads 4 files and uses the objectcontainerdatasource. However, what I would like to do is once I got my files from the fileupload object is to cast it to FileInfo type.
At the moment I can get hold of the files via detailsview but this is where I need help; as I have four files to upload, I want to save them to either an array, collection or list of type FileUpload or FileInfo (preferably FileInfo) along with two other properties and then to pass these values to a method that saves these files to a temporary location. This brings me to my next problem. In the method that saves the files to a temporay location, whilst I can do this with FileUpload, I want to return from this method the new file path location as a FileInfo type in order to use this in another method.
Can anyone help me with this?
|
|
|
|
|
Hi! I don't understand you at 100%. but maybe if you use a FileInfo[] fi = new FileInfo[4]... etc. And after store the images, you can use any to find it's path. like
String path = fi[0].FullName.subString(0, fi[0].FullName.LastIndexOf("/"));
String path = fi.DirectoryName;
|
|
|
|
|
Hello
I work on an intranet site management fees.
management part of review tired me, I chose to work with Excel for simplicity
That's what I want to do:
I have a listbox containing the modules , for a list of students registered in a module, the responsable for this must complete an authentication form.
I want that after authenticating the excel file containing the student opens (I do not know if this is the right method, you comments are welcome)
to export data from sqlserver to excel I used this code:
cn.Open();
SqlDataAdapter da = new SqlDataAdapter(@"DECLARE @MATIERE nvarchar(max)
SELECT @MATIERE =
STUFF(
(
select distinct ',[' + LIBELLE_MATIERE + ']'
from MATIERE where CODE_MODULE =11
for xml path('')
),
1,1,'')
DECLARE @SQL nvarchar(max)
SELECT @SQL = N'
select
*
from (
SELECT ETUDIANT.NUM_INSCRIPTION, ETUDIANT.NOM_PRENOM_ETUDIANT_ARABE,EXAMEN.CODE,
EXAMEN.NOTE,
MATIERE.LIBELLE_MATIERE
FROM ETUDIANT INNER JOIN
EXAMEN ON ETUDIANT.NUM_INSCRIPTION = EXAMEN.NUM_INSCRIPTION INNER JOIN
CAPITALISE_MODULE ON
ETUDIANT.NUM_INSCRIPTION = CAPITALISE_MODULE.NUM_INSCRIPTION INNER JOIN
MATIERE ON EXAMEN.CODE_MATIERE = MATIERE.CODE_MATIERE INNER JOIN
MODULE ON CAPITALISE_MODULE.CODE_MODULE = MODULE.CODE_MODULE
AND MATIERE.CODE_MODULE = MODULE.CODE_MODULE
WHERE (CAPITALISE_MODULE.CODE_MODULE = 11) AND
(CAPITALISE_MODULE.CODE_TYPE_RELATION_MODULE = 1)
) Data
PIVOT (
SUM(NOTE)
FOR LIBELLE_MATIERE
IN (
' + @MATIERE + '
)
) PivotTable
'
exec sp_executesql @SQL
", cn);
DataTable dt = new DataTable();
da.Fill(dt);
cn.Close();
Response.Clear();
Response.ContentType = "application/vnd.ms-excel";
string sep = "";
foreach (DataColumn dc in dt.Columns)
{
Response.Write(sep + dc.ColumnName);
sep = "\t";
}
Response.Write("\n");
int i;
foreach (DataRow dr in dt.Rows)
{
sep = "";
for (i = 0; i < dt.Columns.Count; i++)
{
Response.Write(sep + dr[i].ToString());
sep = "\t";
}
Response.Write("\n");
}
}
}
this code works with sql queries simple but with my query i had an empty excel file (I tried this query and she is correct).
Should I display data in gridview and the user clicks on a button to export to excel?
If a person already working on this project thank you to advise me.
Thank you very much.
|
|
|
|