Comments by Member 10755410 (Top 19 by date)

Thanks for the link. But i want to get object data. For eg in a screen we have a rectangle. I need to access the data associated with the rectangle and convert it into .net readable format.

i searched in google but not able to come up with something solid. It would be helpful if u cud send some links...

i have solved the issue. SInce the amount of data is more, it was causing the error.

if u add this in config file, the issue is solved.
<httpruntime executiontimeout="999" maxrequestlength="2097151">

i have updated my code.

i can get the row data from this event, but i am not able to pass them to the parent page. that i s where i am stuck with? i have to populate them in text box in the parent page.

what does that forcePostBack() function do?

<asp:TreeView ID="tvData" runat="server" Target="frm" Height="100%"
SkipLinkText="" Font-Bold="True" BorderColor="Black" ShowLines="True"
onselectednodechanged="tvData_SelectedNodeChanged" Width="240px">
<nodestyle font-size="Small">
<SelectedNodeStyle ForeColor="Red" />
<hovernodestyle forecolor="Red">
<leafnodestyle forecolor="Black" font-size="10pt">
<nodes>
<asp:TreeNode Text="Data" Value="Data">
<asp:TreeNode Text="Category" Value="Category">
<asp:TreeNode NavigateUrl="~/Country.aspx" Target="frm" Text="Country" Value="Country">

<asp:TreeNode Text="Sub Category" Value="Sub Category">
<asp:TreeNode NavigateUrl="~/City.aspx" Target="frm" Text="City"
Value="City">

i could but the team lead wants it to look more nice, so that is why i am trying this modal popup.

ok but how do we handle it in the code. i have to do some operations based on the return value.

I checked it and it is returning null only. How to handle null value there?

DECLARE @temp as int;
-- Insert statements for procedure here
SELECT @temp = (SELECT CAST(COUNT(1) AS BIT) AS Expr1
FROM ALARM_MSTR_ALARM_DETAIL
WHERE ALARM_TYPE_ID = @ALARM_TYPE_ID)

IF @temp <> 1
BEGIN
Delete from ALARM_MSTR_ALARM_TYPE where ALARM_TYPE_ID = @ALARM_TYPE_ID
SET @temp = 0;
END

RETURN @temp

I am returning a integer from the stored procedure. i tried to convert it to integer in the function but even then i am getting the same error.

DECLARE @temp as int;
-- Insert statements for procedure here
SELECT @temp = (SELECT CAST(COUNT(1) AS BIT) AS Expr1
FROM ALARM_MSTR_ALARM_DETAIL
WHERE ALARM_TYPE_ID = @ALARM_TYPE_ID)

IF @temp <> 1
BEGIN
Delete from ALARM_MSTR_ALARM_TYPE where ALARM_TYPE_ID = @ALARM_TYPE_ID
END
ELSE
SET @temp = 0;
RETURN @temp


public string DeleteAlarmType(int iAlarmId)
{
SqlParameter[] ParamAdd = new SqlParameter[1];
ParamAdd[0] = new SqlParameter("@ALARM_TYPE_ID", iAlarmId);

return SqlHelper.ExecuteScalar(ConfigurationManager.ConnectionStrings["MetaConnectionString"].ConnectionString, CommandType.StoredProcedure, "Delete_alarm_master_type", ParamAdd).ToString();
}

public string DeleteAlarmType(int iAlarmId)
{
SqlParameter[] ParamAdd = new SqlParameter[1];
ParamAdd[0] = new SqlParameter("@ALARM_TYPE_ID", iAlarmId);

return SqlHelper.ExecuteScalar(ConfigurationManager.ConnectionStrings["MetaConnectionString"].ConnectionString, CommandType.StoredProcedure, "Delete_alarm_master_type", ParamAdd).ToString();
}

I am getting error in the return statement.