Comments by Umapathi K (Top 136 by date)

use separate function for that and place the function in page_load

nothing error in application problem in UI i think conflict in windows xp and windows 7 in using wpf [i am not sure]

how to mention the parameters if i use in string?

i did not use any xml coding in my project

ALTER PROCEDURE Recover_Truncated_Data_Proc
@Database_Name NVARCHAR(MAX),
@SchemaName_n_TableName NVARCHAR(MAX),
@Date_From datetime='1900/01/01',
@Date_To datetime ='9999/12/31'
AS
DECLARE @Fileid INT
DECLARE @Pageid INT
DECLARE @Slotid INT

DECLARE @ConsolidatedPageID VARCHAR(MAX)
Declare @AllocUnitID as bigint
Declare @TransactionID as VARCHAR(MAX)

/* Pick The actual data
*/
declare @temppagedata table
(
[ParentObject] sysname,
[Object] sysname,
[Field] sysname,
[Value] sysname)

declare @pagedata table
(
[Page ID] sysname,
[AllocUnitId] bigint,
[ParentObject] sysname,
[Object] sysname,
[Field] sysname,
[Value] sysname)


DECLARE Page_Data_Cursor CURSOR FOR
/*We need to filter LOP_MODIFY_ROW,LOP_MODIFY_COLUMNS from log for modified records & Get its Slot No, Page ID & AllocUnit ID*/
SELECT LTRIM(RTRIM(Replace([Description],'Deallocated',''))) AS [PAGE ID]
,[Slot ID],[AllocUnitId]
FROM sys.fn_dblog(NULL, NULL)
WHERE
AllocUnitId IN
(Select [Allocation_unit_id] from sys.allocation_units allocunits
INNER JOIN sys.partitions partitions ON (allocunits.type IN (1, 3)
AND partitions.hobt_id = allocunits.container_id) OR (allocunits.type = 2
AND partitions.partition_id = allocunits.container_id)
Where object_id=object_ID('' + @SchemaName_n_TableName + ''))
AND Operation IN ('LOP_MODIFY_ROW') AND [Context] IN ('LCX_PFS')
AND Description Like '%Deallocated%'
/*Use this subquery to filter the date*/

AND [TRANSACTION ID] IN (SELECT DISTINCT [TRANSACTION ID] FROM sys.fn_dblog(NULL, NULL)
WHERE Context IN ('LCX_NULL') AND Operation in ('LOP_BEGIN_XACT')
AND [Transaction Name]='TRUNCATE TABLE'
AND CONVERT(NVARCHAR(11),[Begin Time]) BETWEEN @Date_From AND @Date_To)

/****************************************/

GROUP BY [Description],[Slot ID],[AllocUnitId]
ORDER BY [Slot ID]

OPEN Page_Data_Cursor

FETCH NEXT FROM Page_Data_Cursor INTO @ConsolidatedPageID, @Slotid,@AllocUnitID

WHILE @@FETCH_STATUS = 0
BEGIN
DECLARE @hex_pageid AS VARCHAR(Max)
/*Page ID contains File Number and page number It looks like 0001:00000130.
In this example 0001 is file Number & 00000130 is Page Number & These numbers are in Hex format*/
SET @Fileid=SUBSTRING(@ConsolidatedPageID,0,CHARINDEX(':',@ConsolidatedPageID)) -- Seperate File ID from Page ID
SET @hex_pageid ='0x'+ SUBSTRING(@ConsolidatedPageID,CHARINDEX(':',@ConsolidatedPageID)+1,Len(@ConsolidatedPageID)) ---Seperate the page ID
SELECT @Pageid=Convert(INT,cast('' AS XML).value('xs:hexBinary(substring(sql:variable("@hex_pageid"),sql:column("t.pos")) )', 'varbinary(max)')) -- Convert Page ID from hex to integer
FROM (SELECT CASE substring(@hex_pageid, 1, 2) WHEN '0x' THEN 3 ELSE 0 END) AS t(pos)

DELETE @temppagedata
-- Now we need to get the actual data (After truncate) from the page

INSERT INTO @temppagedata EXEC( 'DBCC PAGE(' + @DataBase_Name + ', ' + @fileid + ', ' + @pageid + ', 1) with tableresults,no_infomsgs;');
---Check if any index page is there
If (Select Count(*) From @temppagedata Where [Field]='Record Type' And [Value]='INDEX_RECORD')=0
Begin
DELETE @temppagedata
INSERT INTO @temppagedata EXEC( 'DBCC PAGE(' + @DataBase_Name + ', ' + @fileid + ', ' + @pageid + ', 3) with tableresults,no_infomsgs;');
End
Else
Begin
DELETE @temppagedata
End

INSERT INTO @pagedata SELECT @ConsolidatedPageID,@AllocUnitID,[ParentObject],[Object],[Field] ,[Value] FROM @temppagedata
FETCH NEXT FROM Page_Data_Cursor INTO @ConsolidatedPageID, @Slotid,@AllocUnitID
END

CLOSE Page_Data_Cursor
DEALLOCATE Page_Data_Cursor

DECLARE @Newhexstring VARCHAR(MAX);

DECLARE @ModifiedRawData TABLE
(
[ID] INT IDENTITY(1,1),
[PAGE ID] VARCHAR(MAX),
[Slot ID] INT,
[AllocUnit

<asp:gridview ID="gvTest" runat="server" ShowFooter="true" AutoGenerateColumns="false">
<columns>
<asp:BoundField HeaderText="Name" ControlStyle-BackColor="GrayText" />

<columns>
<asp:BoundField HeaderText="Age" ControlStyle-BackColor="GrayText" />

<columns>
<asp:BoundField HeaderText="Address" ControlStyle-BackColor="GrayText" />





in .aspx i used like this but unable to see when i run the form

You may get post like business development officer job in IT field they need only b.tech with mba and you have exp as a developer so its easy to get in because its equal to consultant..

its not like that mr.prabhu i tried myself after i posted here i got the ans so i given answer plz think its an knowledge sharing nothing else..

mozilla and chrome..

Timestamp: 3/14/2013 4:45:22 PM
Error: TypeError: document.getElementById(...) is null


i am getting this error

function enableTextBox() {
var textBoxID = "<%= txtToDate.ClientID %>";
var textBoxID1 = "<%= txtfrmDate.ClientID %>";
if (document.getElementById("<%= ChkDate.ClientID %>").checked == true) {
document.getElementById(textBoxID).disabled = false;
document.getElementById(textBoxID1).disabled = false;
}
else {
document.getElementById(textBoxID).disabled = true;
document.getElementById(textBoxID1).disabled = true;
document.getElementById('<%= txtfrmDate.ClientID %>').value = "";
document.getElementById('<%= txtToDate.ClientID %>').value = "";
}
}


<asp:CheckBox ID="ChkDate" runat="server" Text="GRN Site Date" Checked="false" TextAlign="Left" OnChange="enableTextBox();"/>
  From Date  

<asp:TextBox ID="txtfrmDate" runat="server" CssClass="txtbox datebox" Style="z-index: 98; width: 100px;" Enabled="false">


<ajax:CalendarExtender
ID="CalendarExtender1" önClientShown="calendarShown" runat="server" TargetControlID="txtfrmDate"
PopupButtonID="Image2" Format="dd/MM/yyyy" CssClass="cal_Theme1">
<span class="tdMsg">*</span>

  To Date  
<asp:TextBox ID="txtToDate" runat="server" CssClass="txtbox datebox" Style="z-index: 98; width: 100px;" Enabled="false">


<ajax:CalendarExtender ID="CalendarExtender2" önClientShown="calendarShown" runat="server" TargetControlID="txtToDate"
PopupButtonID="Image2" Format="dd/MM/yyyy" CssClass="cal_Theme1">
<span class="tdMsg">*</span>


the above coding i am using to show calendar.. its working fine in mozilla but not workin in chrome and IE

<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js" type="text/Javascript"></script>
using this.,
in console i am not getting any error

its not working

its working fine in mozilla but not in IE and Chrome..

i am not getting any error at the same time message not delivering to which mobile number i preferred

its not working, it will work only on dedicated server?

for this should i have to register in ubaid.tk?

some forums suggesting me its only will work on dedicated server.., is this true?

some forums suggesting me its only will work on dedicated server.., is this true?

before send function i have created connect function to establish the connection so no need to mention again mobno and password in send function

yes i have

how to find port for my website

i am getting problem in port number of my website

error message like
Failure to send mail

i can get only fir row value other rows value unable to get

this is open chat. but i want like messages should not visible to all

i did the following steps
1. added custom actions from set and deployment
2. right click on install->added installer file which i have created
(in installer file i have created a input box to get input from user)
the problem is whether user entered wrong are left empty when then click ok set up installing i tried like when user given wrong password the set up should be stop but failure in this)

i have create one installer class but i am unable to design form (to enter password from user during installation)

how to make customize user form during setup and deployment? i am new to this please help me out

but i want to user have to enter product key during installation not after installation

how to use fromstream?

i didnt use any primary key and foreign key

columns can added that is not problem but how to mention for two columns (i.e. room no 4 booked for two days then have to combine two columns )

in datatable i am getting items value like this 31,32,33 thats why i used to array to split values

here i am getting name of items. but i want values because in checkboxlist checkbox text is "itemnames" but value is itemcode., using your given updation loop not entering inside

yes its checkboxlist name [please see my updated codings above]

checkboxes not getting check if items matches

yes its filled with data.., when form get load.

yes

FROM PAYMENT_DETAILS where PAYMENTMODE != 'CARD' AND PAYMENTMODE != 'CASH'
can u explain this please

i am using in this report in report its giving big straight line., i want bankname in second line., any idea about this?

can u more clear

i am using this to report., in report it occurs space thats why need to avoid null values

you are correct roomno in nvarchar. but i am not suppose to change into int., how to handle this

select * from [dbo].[String_Tokenizer]('1,2,3,4',',')
here parameter values you have given static but in my case i am retrieving from database table something like., [select menu_items_id from <tablename>] its output like 2,4,5,6,7 (how can i use select query into the parameter).,

in second line set @instr='2,3,177' you given static but when i try using select query (dynamic) i am getting error any idea about this?

its windows application., unable to get extension of .children and .rowdefinitions and.columndefinitions

working now.,.,

fixed?

object reference not to set an instance of the object.
i am getting this error

system.collections.generic.list[system.string]
getting this error

for (int i = 0; i < ch11.Items.Count; i++)
{
if (ch11.Items[i].Selected == true) //error in this line
{
total_items[items] = ch11.Items[i].Value;
items++;
}
}

thanx

when error message appears after that if user try to choose more than 2 checkbox getting select., it shud not happen

i am checking validation like if user select more than 2 items in a checkedlistbox should throw error and last selected checkbox should get uncheck. i am getting error message but last checkbox getting selected.

i am checking validation like if user select more than 2 items in a checkedlistbox should throw error and last selected checkbox should get uncheck. i am getting error message but last checkbox getting selected.

i am checking validation like if user select more than 2 items in a checkedlistbox should throw error and last selected checkbox should get uncheck. i am getting error message but last checkbox getting selected.

i am checking validation like if user select more than 2 items in a checkedlistbox should throw error and last selected checkbox should get uncheck. i am getting error message but last checkbox getting selected.

when user hits submit button with out enter anything in the 'txtemailid' textbox alerts should throw

nothing happend. jus form getting load thats it

i am getting following error

index was out of range,must be non-negative and less than the
size of the collection. parameter name:index

thanx

private void CreamofMushroom_CheckedChanged(object sender, EventArgs e)
{
int count = 0;
foreach (Control c in anyone.Controls)
{
CheckBox cb = c as CheckBox;
if (cb != null && cb.Checked)
{
count++;
}
}
}


i used above coding as u said., but all the 5 checkboxes are getting check.,

where to write this code?

i have to check two items, if one i can go with radio button

All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.

error like this

foreach (ListViewItem in listView1)

error in this line

i written in button click event

not working

not working

here semicolon in edit mode., user should not erase that.

need to show only time

i tried with alt+1q also., but not working

private void MDIParent1_KeyDown(object s, KeyEventArgs e)
{
if (e.Alt && e.KeyCode.ToString() == "Q")
{
this.KeyPreview = true;
MessageBox.Show("ad");
}
}

not working

1.00:00:00

getting output like this.

str = "USE MASTER RESTORE DATABASE bw FROM DISK = 'c:\\SQLBackup\\bw.bak' WITH MOVE 'bw' TO 'c:\\SQLBackup\\bw.mdf' , MOVE 'bw_Log' TO 'C:\\SQLBackup\\bw.ldf', REPLACE ";

i used above codig but its not restoring

str = "USE MASTER RESTORE DATABASE bw FROM DISK = 'c:\\SQLBackup\\bw.bak' WITH MOVE 'bw' TO 'c:\\SQLBackup\\bw.mdf' , MOVE 'bw_Log' TO 'C:\\SQLBackup\\bw.ldf', REPLACE ";

i used above coding but not restoring

str = @"RESTORE DATABASE bw FROM DISK = 'c:\SQLBackup\bw.bak' WITH MOVE 'bw' TO 'c:\SQLBackup\bw.mdf' , MOVE 'bw_Log' TO 'C:\SQLBackup\bw.ldf', REPLACE ";

this is what i written ., but still error

i have created another database called 'bww' as you said. error showing like this

the backup set holds a backup of a database other than the
existing 'bww' database
restore database is terminating abnormally

using system.data;

i am not asking solution here., just asking how could do this?

thanx

thanx a lot .,its working fine

i am new to ms-sql server . just i am expecting a thread not entire things

yes its checking

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If File.Exists("C:\WINDOWS\tscc.txt") Then
Me.Hide() 'it should get hide
successform.Show()
Else
Me.Show()
successform.Hide()
End If
End Sub

when hi.txt file exits successform.show() only should visible then self form should close. but i am getting both form, even though hi.txt exists . i.e consider if condition

no

ALTER PROCEDURE [dbo].[FETCHPERSONS_AMT]

@roomtype nvarchar(250)

AS
BEGIN
SELECT noofpersons,rent from roomtypes WHERE roomtype=@roomtype
END

this is SP

Error like., incorrect syntax near "FETCHPERSONS_AMT"

incorrect syntax near "FETCHPERSONS_AMT"

from database i getting value from 100,101,102.... 210 ., according to this i have to create buttons dynamically text of button is no's which i mentioned above

s

SqlCommand cmd = new SqlCommand("RoomDetails_Insertquery", gn.cn());
cmd.Parameters.AddWithValue("@type", 2);
cmd.Parameters.AddWithValue("@roomno", textBox1.Text);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.SelectCommand = cmd;

i dont want to display anything jus i need to get print

i am new to platform

how to call in windows form from app.config?

how to call in windows form from app.config?

where is that format?

i used rawprinter to print like receipt

i know very well what to do i am asking you how could make it?

i cant understand ., just tell me how to set serial key before installation the software.,

i am getting error in mode="On"

in your coding you mentioned redirecmode but in my web.config it not showing

..

can you guide me in that?

in the above link codes use to display all urls., but i want to restrict not to display some urls

one of its file not getting to read

insufficient data

hi amy its working partially., its showing fractions of sec and getting invisible .,

<script type="text/javascript">
function fn()
{
var ex=prompt("Enter Your Group","Give Your List Here");
document.getElementById("Label1").innerHtml=ex;
}

--
<form id="form1" runat="server">
<div>

<asp:Button ID="btnclick" Text="Add" runat="server" OnClientClick="fn()"/>
<asp:Label ID="Label1" runat="server">
<br />


above coding not working

i am getting error onclick() function in button event

can u give clear idea about this

answers???

when the form run its getting hide but when i give print that column also getting print.,

i cant get clear idea., in the css how to mention particularly button

no use in tat

i just copied from .aspx and did paste here but its not visible properly

TreeNode year = TNSelectedNode;


Session["Finyear"] = year.Value;


its not working

showing error like.,

object references not to set an object

its not working fine, by default its showing in master page.,

where i have to write coding ., in master page or in content page?

i used master page., should i have to use every pages all coding which is enable to show progress?

after i login i used master page., in the master page how to hide the other pages to restrict users

i tried this 2.,
but actuall my need is.,

if(id=="idvalue")
{
response.redirect("xxx.aspx")
}
else
{
respose.redirect("yyy.aspx")
}

in this calse if id is not match with idvalue its redirecting into xxx.aspx page.,.,,







Umapathi
9942676484

its not working

in my page no body tag., i used content place holder., where to write onkeypress="HotKeyClick();

in .aspx i used above coding to perform my task

here i given my coding., its not working



<script type="text/javascript" language="javascript">
var isCtrl=false;
document.attachEvent('onclick', KeysShortcut);
function KeysShortcut()
{
if (event.keyCode == 16)
{
isCtrl=true;
}
if (event.keyCode == 113 && isCtrl == true)
{
document.getElementById(ImageButton1).click();
}
}
</script>



<asp:ImageButton ID="ImageButton1" runat="server" ImageUrl="~/images/Login_0.png" önClick="ImageButton1_Click1" ToolTip="Click" />

its not working at all.,