Comments by Madhugundi (Top 87 by date)

after @MonthId=

thank you consider my post please check the following code i am getting errors
if exists( select @MonthId= Id from HX_Month where MonthName=@monthNm)
begin
insert into HX_MonthInventory(MonthId,ItemId,StartingQty,NewShipmentQty,CreatedBy,CreatedOn ) values(@MonthId,@ItemId,@startingQty,@NewQty,@UserName,GETDATE())
end
else
begin
insert into HX_MonthInventory(MonthId,ItemId,StartingQty,NewShipmentQty,CreatedBy,CreatedOn ) values(@MonthId,@ItemId,@startingQty,@NewQty,@UserName,GETDATE())
end

Msg 102, Level 15, State 1, Procedure Usp_UpdateItemInventory, Line 24
Incorrect syntax near '='.
Msg 156, Level 15, State 1, Procedure Usp_UpdateItemInventory, Line 28
Incorrect syntax near the keyword 'else'.

means what

how please give me some sample code

Thanks amit its working fine by using the below code:
<asp:TextBox id="tb6" rows="5" CausesValidation="false" ValidationGroup="SearchBox" AutoPostBack="true" runat="server" />

Keep it up..

i have only textbox there is no button when i enter text on textbox it give the result for this i written code in textchanged event of textbox and also i set CausesValidation="false" property to textbox also child page validations are gets perform validation

Hi thanks to consider my post please read my post once again i have no validation on my master page i have only validations in my child page with validation group my problem is when i search from master page child page validations are gets executed so i want to stop validation on child page when i search in master page..

Hi Amit thanks to consider my post please read my post once again i have no validation on my master page i have only validations in my child page with validation group my problem is when i search from master page child page validations are gets executed so i want to stop validation on child page when i search in master page..

i done like but eventhough child page validations are performing

this is not suitable for my post i checked this code only one dropdownlist selected value only selected on editmode another one is not selected please look at code

<edititemtemplate>
<asp:Label ID="lblcomponentNameDrop" runat="server" Text='<%# Bind("ComponentName")%>' Visible = "false">
<asp:DropDownList ID="ddlEditComponentName" runat="server" DataTextField="ComponentName" Width="40%" DataValueField="ComponentId" >
<asp:RequiredFieldValidator ID="rfvEditComponenttName" runat="server" ErrorMessage="Please Select Component Name"
ControlToValidate="ddlEditComponentName" ValidationGroup="updateValidation">

thanks to consider my post please look at my post i am searching for multiple dropdownlists on gridview with editable

i am getting the value of label i.e (e.Row.FindControl("lblComponentNameDrop") as Label).Text but ddlcomponent is not able to find the label text where i am doing mistake please look at

if u find any link that contains multiple dropdownlist in gridview with editable please give me that link

i am also doing same in my code please look at

i am getting error on ddlcomponent dropdown like
Object reference not set to an instance of an object.

this is my code please look at


if (projectName != null)
{
projectName.DataTextField = MasterData.HXMasterData.HXProject.ProjectNameColumn.ColumnName;
projectName.DataValueField = MasterData.HXMasterData.HXProject.ProjectIdColumn.ColumnName;
projectName.DataSource = MasterData.HXMasterData.HXProject;
projectName.DataBind();
projectName.Items.FindByText((e.Row.FindControl("lblProjectNameDrop") as Label).Text).Selected = true;

}
DropDownList ddlcomponent = (DropDownList)e.Row.FindControl("ddlEditComponentName");
if (ddlcomponent != null)
{
ddlcomponent.Items.FindByText((e.Row.FindControl("lblComponentNameDrop") as Label).Text).Selected = true;

}

database

please give sample code i tried hard but not getting

its working fine for one dropdown list but i need this to multiple dropdowns

let me know the status

ya exactly i typed wrong urls but i dont know how to access pages from one website to another website page from database please consider my reply....

Thanks

Thanks to consider my comment and i need it as every month if January is no issues then it should give 0 like for each month.
Thanks

Thanks for reply i want to one more requirement here is that result set should be month report that i want to show in a Bar Chart;
Month OpenIssues closed
Jan 12 10
Feb 30 25

gridview should be converted into div and table into browser but in my webpage this is not done

still not getting the exact solution please give some more samples

thanks

thanks

Thanks how to change color of placeholder text

Thank you i got solution from ur code.

is there any free PDF componet for .net?

i am not able to get u please view my query this should return monthwise data where i have done mistake please find out.

SELECT
DATEPART(MONTH, convert(DATETIME,CreatedDateTime,13)) AS [Month of Year]
, Id AS [TotalShipOrders]
FROM ShipmentDetail
WHERE CONVERT(VARCHAR(7),CreatedDateTime,111)= convert(varchar(7),@CurrentDate,111)
UNION ALL
SELECT Month, NULL
FROM @Months

Thanks consider my post.

Thanks consider my post.

Thank you for consider my post.

yes i got the solution with some modification,that is as follows:

int Count = 0;
while (dr.Read())
{
Count = Count + dr.GetInt32(1);
}
dayChart.Titles.Add("Shipped Orders Per Day " +Count);

but i am not able to use dr object to next statement i.e the code as follows:

int Count = 0;
while (dr.Read())
{
Count = Count + dr.GetInt32(1);
}
dayChart.Titles.Add("Shipped Orders Per Day " +Count);
// here datareader vlues are not assigning why dr is gets closed?
dayChart.Series["DaySeries"].Points.DataBind(dr, "Hour Of Day", "Total", "Tooltip=Hour Of Day, Label=Total");

Thank you consider my post i tried with your code but i am not getting. it is giving an error like System.IndexOutOfRangeException: TotalCount

i tried it but not it retuns zero count for every hour

ya its working but instead of static date i want pass date as a variable like
Declare @CurrentDate varchar;
Set @CurrentDate=(select REPLACE('2012-07-26','-','/'));
in where condition how to concatinate % to C.
I am trying in where clause like '@CurrentDate%' i know it will be wrong.
so please help me i am new for sqlserver.

Thank You.

Based on 2012-07-25 this date i want get records from CreatedDateTime is like 2012-07-25 15:54:32.843 i am grouping by hour

Declare @Hours Table (Hour int);
Declare @i as int;
Set @i = 5
While @i < 24
Begin
Insert into @Hours
Values(@i);

Set @i = @i + 1;
End;

Select
[Hour of Day],
Count([TotalShipOrders]) as Total
From
(
SELECT
DATEPART(HOUR, convert(Datetime,CreatedDateTime,13)) AS [Hour of Day]
, Id AS [TotalShipOrders]
FROM ShipmentDetail where CONVERT(VARCHAR(10),CreatedDateTime,111) LIKE +2012-07-25 + '%'
Union ALL
SELECT Hour, NULL
From @Hours
) as Data

GROUP BY [Hour of Day]
ORDER BY [Hour of Day]

i want the where condition is like
where CONVERT(VARCHAR(10),CreatedDateTime,111) LIKE '2012-07-25 %'

2012-07-25 it is passed by user from Application.
CreatedDateTime is like 2012-07-25 15:54:32.843

Plese help how to place single quotes.

sorry i cant send script

i tried like ur post but i am getting Zero count for every hour

i tried like ur post but i am getting Zero count for every hour

it returns zero rows for every hour
ok in your post what is ordertm i have not any column like.

sorry i am new for this database someone as worked on shipdate instead of CreatedDateTime. So I didn't see that column.
Lastly i got solution by using one of proffessional post but i am not able write where condition on that post please check this:

Declare @Hours Table (Hour int);
Declare @i as int;
Set @i = 5
While @i < 24
Begin
Insert into @Hours
Values(@i);

Set @i = @i + 1;
End;

Select
[Hour of Day],
Count([TotalShipOrders]) as Total
From
(
SELECT
DATEPART(HOUR, convert(Datetime,CreatedDateTime,13)) AS [Hour of Day]
, Id AS [TotalShipOrders]
FROM ShipmentDetail where CONVERT(VARCHAR(10),CreatedDateTime,111) LIKE +2012-07-25 + '%'
Union ALL
SELECT Hour, NULL
From @Hours
) as Data

GROUP BY [Hour of Day]
ORDER BY [Hour of Day]

i want the where condition is like
where CONVERT(VARCHAR(10),CreatedDateTime,111) LIKE '2012-07-25 %'

2012-07-25 it is passed by user from Application.
CreatedDateTime is like 2012-07-25 15:54:32.843

Plese help how to place single quotes.

Hi i got the solution but i am not able get on a perticular date i.e
query like:
where CONVERT(VARCHAR(10),CreatedDateTime,111) LIKE ''' +2012-07-25 + '%''
plese check my where condition did i place single quptes are correct i am getting error is
The data types varchar and varchar are incompatible in the modulo operator.
Why i written like is i want to check on a perticular date from user on CreatedDateTime contains 2012-07-25.
I think is little bit configue to you but try to understand my problem and please place the single quotes in correct,
Thanking you.

yes i have data like:
2012-07-25 08:22:48.643(PST)
How is it possible just modify my code.

How to parse varchar to datetime in sql

while executing
select convert(datetime, (substring(ShipDate,1,5)+ substring(ShipDate,6,2) + substring(ShipDate,8,3) + substring(ShipDate,11,9)),105) as shipdate from ShipmentDetail this i am getting an error is like:

The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value.

if i use substring it am getting result but i am getting problem where 0,1,2,3,4,5,6,7,8,9 because i am extracting hours like,01,02,03,04,05,06,07,08,09

Hi,

Is it possible by using DatePart() method to get hours from datetime where date is in nvarchar.
I am trying to get that but getting an error like:
Msg 241, Level 16, State 1, Line 14
Conversion failed when converting date and/or time from character string.

the sample query is:

Declare @Hours Table (Hour int);

Declare @i as int;
Set @i = 0
While @i < 24
Begin
Insert into @Hours
Values(@i);

Set @i = @i + 1;
End;


Select
[Hour of Day],
Count([Total Calls]) as total
From
(
SELECT
DATEPART(HOUR, convert(Datetime,ShipDate,13)) AS [Hour of Day]
, Id AS [Total Calls]
FROM ShipmentDetail
Union ALL
SELECT Hour, NULL
From @Hours
) as Data

GROUP BY [Hour of Day]
ORDER BY [Hour of Day]

please modify the query.

Thanks&Regards,
Raghu.

No

Thank you

Plese help me how to replace '2012-07-25 15:54:32' to
'2012-25-07 15:54:32' using substring ?
Thanks for you spent your valuable time.

without changing the shipdate type nvarchar to datetime is not possible?

ShipDate Column Value is like: 2012-07-25 15:54:32 PDT

HI,
If u don't mind give me more clarity on this
in my table shipdate is in nvarchar type does here datepart() will work if it is how to convert nvarchart to date to get hour and also your query will written for each hour or only the orders existing hours.i am trying to get orders for every hour if orders are not there on a paticular hour it will return 0 on result.

please help me,

Thanks&Regards,
Raghu.

hi,
i executed my query based on your query but i am getting zero rows.
my query look like is
DECLARE @Sql NVARCHAR(300);
SET @Sql ='select case when cast(SUBSTRING(ShipDate,11, 3)as varchar)>12 then cast(SUBSTRING(ShipDate,11, 3)as varchar)-12 else cast(SUBSTRING(ShipDate,11, 3)as varchar) end as hours,
count(Id) as Total_orders from ShipmentDetail where (ShipDate)=''2012-07-26''group by cast(SUBSTRING(ShipDate,11, 3)as varchar)' ;

EXEC(@Sql);
print @Sql;

Thanks

Thanks

Thanks

Thanks

Thanks

give me one example

plz give me one example

thanks

Thanks

Thank you

Thank you

Thank u and give me code for how check whether the row deleted or not please

Thank you

Thank you

Thank you

Thanx

Thank you very much

Thank you very much

i am very sorry for incomplete question, thank you for your effort for my doutt but you given the solution for cross page submission i need postback submmission i.e in my webpage i have four textboxes, one gridview and one button(name=save) when i click the save button 1)textboxes data should be save into database abd also display into the gridview.
2) when i click any row into the gridview the row data should be bind to textboxes with in the page. please help me

Thnq

table name = Products
useid =101
start date = 10/11/2011
End date = 15/11/2011
i want retrieve data between these two dates