Dear Friends,

<List>
<Entry>
<id>1</uid>
<lastName>abc</lastName>
<idList>
<id>
<id>1</uid>
<idType>pqr</idType>
<idNumber>1001</idNumber>
<idCountry>INDIA</idCountry>
</id>
<id>
<id>2</uid>
<idType>xyz</idType>
<idNumber>1002</idNumber>
<idCountry>USA</idCountry>
</id>
</idList>
</Entry>

Above is the xml i have in my database i want to read this information and return output as given below id LastName id idType idNumber idCountry 1 abc 1 pqr 1001 INDIA 1 abc 2 xyz 2001 USA i am using OPENXML in my stored procedure the code is as given below

		DECLARE @HANDLE INT 
		DECLARE @XMLDOC XML
		
		SET @XMLDOC = (select ofacList from tbl\_OFAC\_SDN\_List)

	        EXEC SP\_XML\_PREPAREDOCUMENT  @HANDLE OUTPUT,@XMLDOC
			
		SELECT \* FROM OPENXML(@HANDLE, '/List/Entry', 2)	
		WITH (\[id\] int, lastName nvarchar(100)) 

                    EXEC sp\_xml\_removedocument @HANDLE

till this all working fine but i don't know how to relate the id information with the main data and how to get the output as well as if i want to add this information into two table (tblmainTable and idDetailsTable) how i will manage it's relation. tblmainTable Record id LastName 1 abc idDetailsTable Records uid id idType idNumber idCountry 1 1 pqr 1001 INDIA 1 2 xyz 2001 USA please help me to come out of this. thanks and regard's in advance

Sasmi

modified on Tuesday, March 15, 2011 3:35 AM

Dear friends, This is head ache for me to handle this. i got one link to overcome this issue.. which is given below http://wiki.asp.net/page.aspx/1137/preventing-multiple-button-clicks/ its really grate but this is making issue for me my submit button is asp button which have Validation Group = 'Transfer' i have multiple text box on form which is handle dynamic when there is one scenario it is add Validation Group as 'Transfer' and remaining as 'NA' and vice versa. issue is create when this submit button click it is validate the page at this time it is validate each and every control even that control is having Validation group as 'NA'. Can any one help me to overcome this issue.

Sasmi

Dear Friend, help me come out of this issue.... i have one application on which more then 1000 user access daily and its create huge data transaction which need to be manage. we have maintainance plan which run on weekly basis. but still some time it slower down help me for this... tell me some good practice for this issue... i have some questions 1. What is statistics job does. 2.What task(s) is/are suitable for daily maintenance and what for weekly/monthly maintenance 3.Do database need to be offline while in some task, example : reorganize/rebuild index, Shrinking database, etc... (since we need to keep 90% uptime) 4.How long can check database integrity, reorganize/rebuild index, cleanup history be? 5.Should we do both reorganize and rebuild index? 6.Do we need to update statistic after reorganize index? Since rebuild index will auto update statistic Please help me asap.. thanks

Sasmi

Thanks for the quick reply... I am also think same but when i am using this Procedure in my application it is giving me same error can you explain me why this happening....

Dear Friend's, My Issue scenario is as follow's i have two servers Name "Server_A" "Server_B" In "Server_A" i have one Database "DB1" In "Server_B" i have one Database "DB2" in Database "DB1" of Server "Server_A" i have one table "tbl_ListOfCountry" now as per my business logic that table must be centralize where my client will update information and i need to use this table data in "Server_B". For that i have create one procedure which pull all the data of table "tbl_ListOfCountry" from "Server_A". for that i have created Synonym "tbl_ListOfCountry" using following syntex

CREATE SYNONYM [dbo].[tbl_ListOfCountry] FOR [Server_A].[DB1].[dbo].[tbl_ListOfCountry]

now for security purpose i have created one user "user1" with "Server Role" as "Public" and "User Mapping" as "db_datareader", "db_datawriter" and "public" in "Server_B" and Grant As Execute Permission of this user to my procedure "Proc1" which use to pull the record. now the main issue is started whenever i execute that procedure "Proc1" using "user1" login instead of "sa" it give me error Msg 18456, Level 14, State 1, Line 1 Login failed for user 'user1'. Please, help me to overcome this issue... Thanks in advanced..

Sasmi

Thanks for the response... Actually main thing is that the application is creating his own session id but the best practice for secure application i need to clear the application created session and want to create my own with some business logic so that there is no worry about hacking of the data which is very imp for my application.. Thanks once again

Sasmi

Dear Friends, When ever i login to my asp.net web application it create one session id where i stored some imp info for my application, but i want to provide it more security so need to destroyed application created session and want to create my own session id... So please help me for this, provide me some white paper or some good link Thanks in advanced, Regard's

Sasmi

Dear Friend's My Issue Scenario is ... I have one business dll in which i handle the business process, i use this dll for one web based application. after that i install that on application server it's work fine but when i update that dll i need to reinstall the web application which is time consuming process for myself as well as to my client... Is there any way to handle this as i know about patch update if this is the solution please give me any good help. Thanks in advanced.

Sasmi

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

i am talking about sql Server 2005...

hi Friend's Suppose i have one application which having session time out set as 45 min, now the scenario is suppose one user login and activate that session and close the browser without login off. what happen to that session? Is that session automatically terminate by garbage collection? Or still remain active and if so then how to handle this session? Thank's and regard's

Sasmi

Hi Friend, I have one question about database management... I have one Procedure which take 30 min to execute.... I have crate front end for that Process, the scenario is when user press the button to execute that Procedure but find no response and close the browser what happen for that procedure after this, i mean that procedure is executed but did't stop....that procedure is using server resource but unmanaged how to managed that. Thanks and regard's in advance.

Sasmi

Hi Friends, I am using a repeater control which have footer. i have placed a asp:label control in the footer. When i run the page label is showing its value like "1234.00" but i want to display like "1,234.00". How to do that. Thanks in advance. Regards, Gourav Tyagi.

Hi friends, I have installed my website to server under Default website in IIS. then i open a crystal report then it allows me to take print from crystal reports print option. but when i add new website in iis (on clicking the website then new website and add new website). then i installed my website their then i m not able to take print from crystal reports print option. the images of print button in crystal report are not displayed on their places and when i click there it gives JavaScript error. Please help me on this. Regards, Gourav Tyagi

Yes, Thanks now it working fine.... can i access any class property using this syntex? Thank you very much

Sasmi

I have change the property to public but still showing error "DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'IsVisible'."

Sasmi

when i run this it giving error "DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'IsVisible'."

Sasmi

Dear Friend I have one Grid contain hyperlink control, i want to set its visibility depend on Login Group, If User is "Guest" then User can not access the link but if that user is "Authorized" he can access that link. For this, i have created following code Form Syntex Level Code:

public partial class frmTest : System.Web.UI.Page
{
private bool IsVisible
{
get { return (Session["G_UserGroup"] == "9") ? true : false; }
}
}

Form Design:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="frmTest.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<asp:GridView ID="gvwOrders" runat="server" AutoGenerateColumns="False" CellPadding="4" ForeColor="#333333" GridLines="None" AllowSorting="True" OnSorting="gvwOrders_Sorting" EnableViewState="False">
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<Columns>
<asp:TemplateField HeaderText="Link">
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="http://www.google.com"
Visible='<%# Eval("IsVisible") %>'>Link</asp:HyperLink>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<RowStyle BackColor="#EFF3FB" />
<EditRowStyle BackColor="#2461BF" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
</form>
</body>
</html>

I try to use this way as Eval is use to access different properties. Please help me as i m going right way but issue is in syntex. Thanks and regards

sasmi

Dear Friend, Scenario I have one grid view showing user access model having field as 'User'(Textbox), 'Group'(Dropdown), 'View' (Checkbox), 'Edit'(Checkbox) column. I have on Data Set where i stored the data fetch from database. now i bind this dataset to Grid View Control DataSet ds = getData(); GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); Note: Where getData() method fetch the data from database. Problem i change only two record from all ten records, now i want to update only that record in my database how could i do this... Actually i know DataSet having HasChange() Method which use to know the changes in dataset but dont know how to use it for the above scenario.. Please help me Thanks and regard's in advance Sasmi

Dear Friends, i have one issue in using nested procedure, both procedure having hash table with same name because of which there is an issue for executing same procedure through ASP.net (it not showing issue in sql server) so i need how to find nested procedure from huge database Sasmi