ASP.NET

Re: ASP.NET Gridview, bring highlighted rows to top

19-Aug-09 21:40

What you can do , is to order by the Card numbers. do it on your SQL Side and the rows that have the card number you searched for will be on the top part

Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.somee.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Inderjeet Kaur19-Aug-09 22:41

Inderjeet Kaur

19-Aug-09 22:41

Hi
Order By wll bring the rows in asc or desc order. What if i want in between records on top

SELECT
*
FROM

(
SELECT
TranID AS TranID,
CardAcceptorIdCode as MerchantNumber,
PrimaryAccountNumber AS CardNumber,
TranTime as TxnDate,
TransactionAmount as TxnAmount,
CASE CCL1.LutDescription WHEN 'REDEMPTION' THEN 'PURCHASE' ELSE CCL1.LutDescription END as TxnType,
CASE CCL1.LutDescription WHEN 'REDEMPTION' THEN 'CR' WHEN CCL1.LutDescription THEN 'DR' END as DbCrdDetails,
LocalTxnDate,
LocalTxnTime,
PrimaryCurrencyCode AS Currency,
TxnCode_internal AS MTC,
ISNULL(ExcludeRecon, 0) AS ExcludeRecon
--CASE ExcludeRecon WHEN NULL THEN 0 ELSE ExcludeRecon END AS ExcludeRecon
FROM
CCardTransactions inner join
CCardLookup CCL1 on TranType = CCL1.LUTCode and TranType in (10,40,37,42,30) and CCL1.LUTID = 'LM'
WHERE
TRANTIME BETWEEN 'Jul 29 2009 12:00AM' AND 'Jul 29 2009 11:59PM' AND
CardAcceptorIdCode = 48484
) AS CCARDTRAN1

WHERE
CardNumber = '2423423453534556'
--ORDER BY CardNUmber

UNION ALL

SELECT
*
FROM

(
SELECT
TranID AS TranID,
CardAcceptorIdCode as MerchantNumber,
PrimaryAccountNumber AS CardNumber,
TranTime as TxnDate,
TransactionAmount as TxnAmount,
CASE CCL1.LutDescription WHEN 'REDEMPTION' THEN 'PURCHASE' ELSE CCL1.LutDescription END as TxnType,
CASE CCL1.LutDescription WHEN 'REDEMPTION' THEN 'CR' WHEN CCL1.LutDescription THEN 'DR' END as DbCrdDetails,
LocalTxnDate,
LocalTxnTime,
PrimaryCurrencyCode AS Currency,
TxnCode_internal AS MTC,
ISNULL(ExcludeRecon, 0) AS ExcludeRecon
--CASE ExcludeRecon WHEN NULL THEN 0 ELSE ExcludeRecon END AS ExcludeRecon
FROM
CCardTransactions inner join
CCardLookup CCL1 on TranType = CCL1.LUTCode and TranType in (10,40,37,42,30) and CCL1.LUTID = 'LM'
WHERE
TRANTIME BETWEEN 'Jul 29 2009 12:00AM' AND 'Jul 29 2009 11:59PM' AND
CardAcceptorIdCode = 48484
) AS CCARDTRAN2
WHERE

CardNumber <> '2423423453534556'

This is my query and i want top bring records searched by CardNUmber or TxnType on top

Inderjeet Kaur
Sr. Software Engg

Re: ASP.NET Gridview, bring highlighted rows to top

Vimalsoft(Pty) Ltd19-Aug-09 22:53

Re: ASP.NET Gridview, bring highlighted rows to top

19-Aug-09 22:53

You can choose if you want them asc or desc by adding something like

Order by CardNumber asc

Order by CardNumber desc

Hope this Helps

Sundeep Ganiga20-Aug-09 2:18

Sundeep Ganiga

20-Aug-09 2:18

Self Manipulation of Records of dataset is required here.
after binding the database initially and on card number entry,You try to highlight those matching rows and finally after completing highlight part,remove those all rows from dataset and insert at Top position and then rebind the Grid.This should be done at the end in order not to break performance issue.

Hope so I am correct.
All The Best Thumbs Up | :thumbsup:

Sundeep Ganiga
When the only tool you have is a hammer, everything looks like a nail.
Come Forth Yourself to Click "Good Answer" for any expected solution.
Let us Support our C Project Programmers who provide solutions here.

girdview and dropdown having listitem

haleemasher19-Aug-09 20:21

19-Aug-09 20:21

i want to edit a grid view which contain a dropdownlist which is not bound to any datasource i want to use ListItem. How can i do so? What changes i have to do for my solution?

<asp:TemplateField HeaderText="Variable Price">
                   <ItemTemplate>
                       <asp:Label ID="tbPrice" Width="100px" runat="server" />
                   </ItemTemplate>
                   <EditItemTemplate>
                       <asp:DropDownList   ID="ddlVariable"

                                           Width="100px"
                                           runat="server"  />


                   </EditItemTemplate>
               </asp:TemplateField>

Vimalsoft(Pty) Ltd19-Aug-09 20:35

19-Aug-09 20:35

Do you want to use them on the server side ?

haleemasher19-Aug-09 20:38

19-Aug-09 20:38

yeah on server side

Vimalsoft(Pty) Ltd19-Aug-09 20:41

19-Aug-09 20:41

that is Simple

DropDownList ddl = (DropDownList)e.Row.Cells[0].FindControl("ddlVariable");

as i dont know what column is this template field is, you can start counting from zero and but the correct index for the column

Hope this Helps

haleemasher19-Aug-09 22:24

19-Aug-09 22:24

what should be the code for server side scripting?

Vimalsoft(Pty) Ltd19-Aug-09 22:48

19-Aug-09 22:48

its what i gave you

Failed to convert parameter value from a String to a DateTime

4anusha420-Aug-09 1:47

4anusha4

20-Aug-09 1:47

there itself near the dropdown u can add listitems

haleemasher19-Aug-09 19:36

Re: Failed to convert parameter value from a String to a DateTime

19-Aug-09 19:36

i want to take values from textbox and using a submit button i want to submit the records.
when i run the project it give errorFailed to convert parameter value from a String to a DateTime
Here is my code plz chk and reply

protected void btnSubmit_Click(object sender, EventArgs e)
        {
            try
            {

                ErrorMessage.Text = "";
                cnx.Open();
                
                SqlCommand insertCmd = new SqlCommand("insert into Coupon_Info(ReceivingDate,Coupon_TypeID,Serial_Start,Serial_End,Recieved_By)values(@date,@CouponId,@Start,@End,@By)",cnx);
                
                
                insertCmd.Parameters.Add("@Date", SqlDbType.DateTime);
                insertCmd.Parameters["@Date"].Value = txtdate.Text;
                
                insertCmd.Parameters.Add("@CouponId", SqlDbType.TinyInt);
                insertCmd.Parameters["@CouponId"].Value = DropDownList1.Text;
                
                insertCmd.Parameters.Add("@Start", SqlDbType.BigInt);
                insertCmd.Parameters["@Start"].Value = txtbxFrom.Text;
                
                insertCmd.Parameters.Add("@End", SqlDbType.BigInt);
                insertCmd.Parameters["@End"].Value = txtbxTo.Text;
                
                insertCmd.Parameters.Add("@By", SqlDbType.NVarChar, 50);
                insertCmd.Parameters["@By"].Value = txtbxBy.Text;
                
                insertCmd.ExecuteNonQuery();
                ErrorMessage.Text = "Successful";
                cnx.Close();
            }
            catch (Exception ex)
            { ErrorMessage.Text = ex.Message; }
        }

haleemasher19-Aug-09 20:05