Comments by tastini (Top 72 by date)

No only one set, second line returns @returnvalue 0 as normal procedure.

please check the question now.. i changed the result.

can you help me please ...

if i use distinct , it will remove second one , my question something like pivot table.

i agree you are 100% correct. i use only excel but not macro not all the people knows macros and if we dont know macro we cant ask doubts?, somebody can help me from here to solve this issue, even i have no idea about coding in excel. I am sorry if i am in wrong place.

I try to run this code... i can see it is working but dont know how to use it properly. Really thanks for this help. i will try to figure it out how to run in my scenario.

really sorry , i never use vba code with excel. there is no other option that i can apply it will be really helpful.

i am using excel ,i am sorry i dont understand what you meant by code?

can you help me , how i can do it with macro?

not for one time use , doing it each 4days or something.

please check what i try to write as per your suggestion i try the pivot table. this is what i try now. if i give the location name directly its returns report, but my case lacation table is master so it will change,i cannot hard type the names. please check the query what i did the wrong here in this.
Select BrandName,Location
From
(
Select BrandName,Location,SLID From Sales) as BaseTable
Pivot
(
Count(SLID) For Location in (Select Name from MasterLocation)
) as PivotTable

can you give me sample code. it will help for me. Thanks

please check now.

No requirements , and this one is connecting to finger machine its a sdk. There is one dll file to run. The sad thing is i dont have much idea about it. Just want to know what is FAE ? atleast. I am sorry still i am not give you proper idea about my doubt.

not that way, copied only design. problem is now cant go back to old running application. showing the error even remove the form that i copied.

remove the obj folder(keep the obj folder only inside files remove). but no luck plus now cant build or rebuild the application. showing the same error.

everything is there, i check one by one. but Package\PackageTmp\Default.aspx not exist. Not sure even its creating when publishing.

You are amazing , your query is more understandable and idea is good also. last problem was data format in my asp. all now showing. Really really thanks.

CheckTime and TimeNow , not showing in the result? but in your query everything mention already.

this procedure returns correct data while am running from sql management studio. same procedure i am trying to call from asp.net gridview that time return only single row.

please check now... i update the question

You are totally right about this @RequestBy , am not initialize. your code look like really nice and understanding i will try this. really thanks for these codes.

i change to this way...
DECLARE ADMX CURSOR FOR SELECT Name, EmailID FROM EmployeeMaster WHERE Active = 'Y' AND Department='HR'
OPEN ADMX
FETCH ADMX INTO @AdminName, @AdminEmail
WHILE @@fetch_status = 0
BEGIN
DECLARE SND CURSOR FOR Select TrID From TrDocumentRequest Where EmailStatus IS NULL
OPEN SND
FETCH SND INTO @EmailStatus
WHILE @@fetch_status = 0
BEGIN
SET @TrID = (Select TrID From TrDocumentRequest Where EmailStatus IS NULL And Status=2 Group By TrID)
SET @DocumentName=(Select DocumentCode From TrDocumentRequest where TrID=@TrID)
SELECT @EmpName=Name FROM EmployeeMaster WHERE EmpID = (SELECT RequestBy FROM TrDocumentRequest WHERE TrID = @TrID)

now its inserting multiple times. and same giving error.

SET @TrID = (Select TrID From TrDocumentRequest Where EmailStatus IS NULL Group By TrID)
this line returns multiple rows. but i have to go through all the rows. and finaly i updating the the EmailStatus='Y' , give me suggession please.

please check my code now , how i can use pivot to my code.

Amazing, thanks really thanks... this is it. :)

still , please check my doubt , I have two tables, first table having itemcode and itemname and second table having only itemcode and branch. I want to retrieve data from second table if the search matches "itemname and branch" here am not passing itemcode. what I write that's not correct procedure.

But I want to pass ItemName value instead of ItemCode.

Here I am going to pass the ItemCode value for @ItemCode?

I have multiple branches ...

where I made default value as null ? how I can change it?

I am inserting Value , I pass all the parameters but Qty and totalused always inserting or updating "0" or NULL value.

when I am using the row number and filter its not giving any result without that its showing the data. really I don't know where is the problem.

Check this code , no errors but not return any data
strSql = "WITH TempTable AS (Select JobCode,CurrentStatus,ModelName,BrandName,ReceiptDate, ROW_NUMBER() OVER (ORDER BY " + OrderBy + ") AS 'RowNumber' FROM JobDetails WHERE 1 = 1 " + strFilter + ") SELECT * FROM TempTable WHERE RowNumber BETWEEN " + ((PageNo == 1) ? 1 : ((PageNo - 1) * RecCount) + 1).ToString() + " AND " + ((PageNo == 1) ? RecCount : (PageNo * RecCount)).ToString().ToString();"

yes it is ...

Please check my sql command.

integer

5.0958904109589036 this is the value showing if no variable use.

No Column Name "NULL"

i am getting null value using that query.

I am sorry to ask you , what I have to change in my query? its the same query am running except one that you mention (return to select) I tried that before but I got no column message. please edit it for me. just want to learn too.

I call this procedure from asp , and tried only select statement from sql

can u edit the code please bcoz I tried the decimal value. like this
if (e.Row.RowType == DataControlRowType.DataRow)
{
grTotal += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "WORKHRS"));
}
if (e.Row.RowType == DataControlRowType.Footer)
{
e.Row.Attributes.Add("class", "tfooter");
e.Row.Cells[3].Text = "Total Hours";
e.Row.Font.Bold = true;
((Label)e.Row.Cells[4].FindControl("lblTotal")).Text = grTotal.ToString();
}

but same effect

check workhrs value how its coming to grid "Datediff(n,I.CHECKTIME,O.CHECKTIME) / 60.00 AS WORKHRS"

Already tried with int32 but same effect, and I tried the decimal too.

this line having issue "int qty = Int32.Parse(WORKHRS.Text);"

its also not working *Schatak .

I try to edit this way... but still not succeeded anybody can help me to solve it fully....

if (e.Row.RowType == DataControlRowType.DataRow)
{
grTotal += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "WORKHRS"));
}
if (e.Row.RowType == DataControlRowType.Footer)
{
e.Row.Attributes.Add("class", "tfooter");
e.Row.Cells[3].Text = "Total Hours";
e.Row.Font.Bold = true;
((Label)e.Row.Cells[4].FindControl("lblTotal")).Text = grTotal.ToString();
}

Its not accepting still showing the error , "Additional information: Input string was not in a correct format."

Can you edit the code for me. I try to change the variables and binding values still not give me answer. Thanks.

no we need to make for users...

i want to make something that, my first table plus need to upload the file like pdf or word documents with it. its kind of hr program, if any user want to request for any document they will request to hr, through the system , now the hr want to upload original signed paper with the request. forget the old data.the coming request i want to upload the file with it . there is any option todo so.?

users will update when they request the document

I have no issues with date function there...

no I am not saying I want to store in TrID , may b you misunderstand me, this is the table of requesting some documents, I want to add signed request form with it. TrID is the key for both table. bcoz I have data already in first table, the second table is new. I can edit the second table. but how to achieve it? how I can add the request forms for all my old data. its like update the data with files.

I got it , but I am asking how I can upload under that column"TrID" you saw my second table? simply adding the one file to database there is 100 example I guess I can follow them but am getting trouble in this issue. please recheck.

its running in sql , how I can pass my parameters on this sp now.

private void FillGrid()
{

grvList.PageSize = Convert.ToInt16(drpRecords.SelectedValue.ToString());
int PageNumber = Convert.ToInt32(txtPageNo.Text);
LeaveRequestList objLst = new LeaveRequestList();
string strFilter = "";
string strFilter1 = "";
strFilter1 += " AND R.RequestBy ='" + Session["empid"].ToString() + "'";

if (txtLetterType.Text != "")
{
strFilter += " AND R.LeaveCode LIKE '%" + ExpertGeneric.CleanString(txtLetterType.Text) + "%'";
}

if (txtStatus.Text != "")
{
strFilter += " AND R.Status LIKE '%" + ExpertGeneric.CleanString(txtStatus.Text) + "%'";
}

objDB.strFilter = strFilter1 + strFilter;

int cnt = objDB.Count();
lblRecordNo.Text = "Total Rows : " + cnt.ToString("#0") + "   ";
int TotalPage = (cnt / grvList.PageSize) + ((cnt % grvList.PageSize) > 0 ? 1 : 0);
lblShowing.Text = " of " + TotalPage.ToString();
if (PageNumber > TotalPage)
{
txtPageNo.Text = TotalPage.ToString();
PageNumber = TotalPage;
}

DateTime dt2 = new DateTime();


Hashtable objHt = new Hashtable();
objHt.Add("@TrMode", "IE");
objHt.Add("@RequestBy", Session["empid"].ToString());
objHt.Add("@param1", grvList.PageSize);
objHt.Add("@param2", PageNumber);


DB.ExecuteSPorSQLNonQuery("Rpt_LeaveInformation", ref objHt, 1);


// objLst = objDB.GetListForGrid(grvList.PageSize, PageNumber, "RequestDate");
// objLst = objDB.GetListForGrid(Session["empid"].ToString());
grvList.DataSource = objLst;
grvList.DataBind();

foreach (GridViewRow gr in grvList.Rows)
{
if (gr.Cells[3].Text != "Requested")
{
((ImageButton)gr.FindControl("imgDelete")).Visible = false;
((ImageButton)gr.FindControl("imgEdit")).Visible = false;
}
}
}

how to do it correctly? really I am confusing.

can you solve it for me, in your way. really thankful to you.

Msg 102, Level 15, State 1, Procedure Rpt_LeaveInformation, Line 14
Incorrect syntax near '<'.

this is the error it shows. while executing the storeprocedure. and regarding that filter not important after its running properly I will check it. in these sp rownumber your are not mention. if you can ,pls give me note.

CREATE PROCEDURE EmployeeSales
@Employee int AS
SELECT SUM([Order Subtotals].Subtotal) AS Total
FROM Employees INNER JOIN
Orders INNER JOIN
[Order Subtotals] ON Orders.OrderID = [Order Subtotals].OrderID
ON Employees.EmployeeID = Orders.EmployeeID
WHERE (Employees.EmployeeID = @Employee)

in this example they retrieving two tables , how I can make it three. and how to pass the value.

cmd.CommandText = "StoredProcedureName";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = sqlConnection1;

in this example I guess they are running simply select statement no search. I mean no where command in that stored procedure. how to make it.

normally I am running the code in front end. I am not use storeprocedure if you can give me one code , I can use it. you have my tables and you know what I want. please give me the stored procedure.

Can you give me a stored procedure ?

Yes I did.. all the first one is primary key.

let me try, I am getting some other errors now, I will update you once I got run the program.

<div style="clear"></div>
<asp:GridView ID="grvList" runat="server" AutoGenerateColumns="False" CssClass="gridview" GridLines="Horizontal" OnRowDataBound="grvList_RowDataBound">
<alternatingrowstyle cssclass="alternate">
<columns> <asp:BoundField HeaderText="Sl. No.">
<HeaderStyle Width="60px" />
<asp:TemplateField HeaderText="Item">
<itemtemplate>
<asp:Label ID="txtItemCode" Text='<%# Bind("ItemCode") %>' runat="server">


<asp:TemplateField HeaderText="Quantity">
<itemtemplate>
<asp:TextBox ID="txtQuantity" Width="80px" TextMode="SingleLine" Text='<%# Bind("Quantity") %>' runat="server">

<HeaderStyle Width="100px" />

<asp:TemplateField HeaderText="Price">
<itemtemplate>
<asp:TextBox ID="txtPrice" Width="80px" TextMode="SingleLine" Text='<%# Bind("Price") %>' runat="server">

<HeaderStyle Width="100px" />

<asp:TemplateField HeaderText="Total">
<itemtemplate>
<asp:TextBox ID="txttotal" Width="80px" TextMode="SingleLine" runat="server">

<HeaderStyle Width="80px" />



this is my asp code.... you can help me in this code please.

sorry that my doubt is not clear. I am trying to add items into gridview, after that I save the gridview to database. my issue is when I am adding the items to gridview, I have 2 data, 1.qty 2. price, I want to show the total in third row. I mean multiple the data and qty show this data to total column. All the other data are coming except the total.

thanks it works , amazing. thanks really appreciate your help.

Thanks ... so instead of PID in that code want to make it ItemCode right?