Re: how to highlight newly inserted record in a gridview with paging=true? - ASP.NET Discussion Boards

This will solve your problem to some extent:
<pre>
<asp:TextBox ID="TextBox1" runat="server" onkeypress="return dWd(this);" onkeyup="return dWd2(this);" onkeydown="return dWd2(this);" Width="20"></asp:TextBox>

<script language="javascript">
function dWd(e)
{

var wt=parseInt(e.style.width);
wt+=10;
e.style.width=wt + "px";

}

function dWd2(e)
{
if(event.keyCode==8)
{
if(parseInt(e.style.width)>20)
{
var wt=parseInt(e.style.width);
wt-=10;
e.style.width=wt + "px";
}
}
}
</script>
</pre>

CC26

Hi im actually working on a project. Actually its about storing and retrieving student details from the data base. I hav totally designed 3 webforms.
1st webform has a login form
2nd webform has 3 buttons in it
3rd webform has the grid view which displays the student records frm DB
Now heres the problem actually when i click button1 in my 2nd webform it must disable the edit and delete option of my grid view in the 3rd webform and wen i click button2 in 2nd webform it must enable the edit and delete option in my gridview in the 3rd webform. the edit and delete are link buttons.
Can anyone plzzz help me its bit urgent...
Thashif

Don't cross post Mad | :mad:

himanshu

i hav edited my post yaar... well sorry

try to transfer information from 2nd page to 3rd page on button click using session or querystring or any technique u r used to.Then according to the information enable or disable edit and deleted button.

CC26

hi
i have a gridview.
i am filling gridview through a view,
i am inserting a record through a storedprocedure and
i want to display the last inserted record as a last record and also i want to highlight the record as well as focus on the newly inserted record.

provide code for this one..

Koti

Assuming your first row of gridview is the last inserted record

in design mode provide backcolor in SelectedRowStyle or in your CSS.
then in ur insert function after Binding gridview write the below line

gridview1.SelectedIndex = 0;

The Code

In order to run the code below, you must first set up Membership. The simplest way to do this is to simply add to your web.config a very small section enabling RoleManager. This will automatically create the membership database in sqlexpress. You should probably add a couple users just so your gridview is not empty from the start. The code you need to add to an empty asp.net 2.0 web site project is as follows (put it in the <System.Web> section).

<roleManager enabled=“true“></roleManager>

Once you have done that, you can copy the code below to a new web page and simply run it.

Briefly, the way the code works is that when a row is inserted into the database the sqldatasource’s Inserted event is called. In this event, we take a look at the return parameter which comes from the sql:

InsertCommand=”INSERT INTO [Names] ([name]) VALUES (@name);SELECT @NewID = Scope_Identity()”

NewId is actually a return parameter, so we can get that back in the inserted event. Once we get the value back, we store it in viewstate so that on the upcoming page_prerender, we can check and see which row has that id in it, and then highlight that row. The reason we do it in prerender and not load is because the inserted event is processed after load and it would not work if we put it there.

So, here is the code! Good luck.

<%@ Page Language=”C#” %>

<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”>

<script runat=”server”>

// simple table named: Names. Two columns: id int, name varchar(64)

protected void ButtonInsert_Click(object sender, EventArgs e)

{

SqlDataSource1.InsertParameters["name"].DefaultValue = DateTime.Now.ToString();

int numInserted = SqlDataSource1.Insert();

GridView1.DataBind();

}

protected void SqlDataSource1_Inserted(object sender, SqlDataSourceStatusEventArgs e)

{

object newId = e.Command.Parameters["@NewId"].Value;

ViewState["NewId"] = Convert.ToInt32(newId);

}

protected void Page_PreRender(object sender, EventArgs e)

{

string newIdLast = string.Empty;

if (ViewState["NewId"] != null)

{

int newId = (int)ViewState["NewId"];

newIdLast = newId.ToString();

int rowCnt = 0;

foreach (GridViewRow row in GridView1.Rows)

{

string newIdText = row.Cells[1].Text;

if (newIdText.Equals(newIdLast))

{

//GridView1.EditIndex = rowCnt;

//GridView1.SelectedIndex = rowCnt;

row.Attributes.Add(“bgcolor”, “Gray”);

break;

}

rowCnt++;

}

}

}

</script>

<html xmlns=”http://www.w3.org/1999/xhtml” >

<head id=”Head1″ runat=”server”>

<title>Untitled Page</title>

</head>

<body>

<form id=”form1″ runat=”server”>

<div>

<h2>Example of GridView that shows highlighted last inserted row</h2>

<br />

<asp:GridView ID=”GridView1″ runat=”server” AutoGenerateColumns=”False” DataKeyNames=”id” DataSourceID=”SqlDataSource1″ >

<Columns>

<asp:CommandField ShowEditButton=”True” ShowDeleteButton=”True” />

<asp:BoundField DataField=”id” HeaderText=”id” InsertVisible=”False” ReadOnly=”True”

SortExpression=”id” />

<asp:BoundField DataField=”name” HeaderText=”name” SortExpression=”name” />

</Columns>

</asp:GridView>

<asp:SqlDataSource ID=”SqlDataSource1″ runat=”server” ConnectionString=”<%$ ConnectionStrings:ConnectionString %>“

DeleteCommand=”DELETE FROM [Names] WHERE [id] = @id”

InsertCommand=”INSERT INTO [Names] ([name]) VALUES (@name);SELECT @NewID = Scope_Identity()”

SelectCommand=”SELECT [id], [name] FROM [Names]“ UpdateCommand=”UPDATE [Names] SET [name] = @name WHERE [id] = @id” OnInserted=”SqlDataSource1_Inserted”>

<DeleteParameters>

<asp:Parameter Name=”id” Type=”Int32″ />

</DeleteParameters>

<UpdateParameters>

<asp:Parameter Name=”name” Type=”String” />

<asp:Parameter Name=”id” Type=”Int32″ />

</UpdateParameters>

<InsertParameters>

<asp:Parameter Name=”name” Type=”String” />

<asp:Parameter Direction=Output Name=”NewId” Size=4 Type=Int16 />

</InsertParameters>

</asp:SqlDataSource>

<br />

<br />

 <asp:Button ID=”ButtonInsert” runat=”server” OnClick=”ButtonInsert_Click” Text=”Insert Record” /></div>

</form>

</body>

</html>

Hi

I have a textbox suppose if i enter like abcdefg (assume width is 100)
and
if i enter like abcdefghijklmnopqrstuvwxyz the width should be increased based on the input which i am providing.

how to solve, let me know the code for this one...

Koti

This will solve your problem to some extent:

<asp:TextBox ID="TextBox1" runat="server" onkeypress="return dWd(this);" onkeyup="return dWd2(this);" onkeydown="return dWd2(this);"  Width="20"></asp:TextBox>

<script language="javascript">
function dWd(e)
    {
    
     var wt=parseInt(e.style.width);
     wt+=10;
     e.style.width=wt + "px";
    
    }
    
    function dWd2(e)
    {
    if(event.keyCode==8)
    {
     if(parseInt(e.style.width)>20)
     {
     var wt=parseInt(e.style.width);
     wt-=10;
     e.style.width=wt + "px";
     }
    }
    }
</script>

CC26

[Message Deleted]

Why to repost same question??????????????????????????????

himanshu

Please Don't Cross Post Dead | X|

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net
View My Recent Article

I need to implement address verification system to my customer portal.
How can i implement it? I am new to it.... do we need some third party control? :

You'll need to buy third party software (or create a database with every possible address yourself but I doubt you'll want to do that. QAS is a popular product but it isn't cheap IIRC.

Inderjeet Kaur wrote:
I need to implement address verification system to my customer portal.
How can i implement it? I am new to it.... do we need some third party control? :

You have came up with a bigger view of your problem ? What AVS will do ? What is the details requirements ? Did you tried anything ?

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net
View My Recent Article

No abhijit, i was learning what AVS is? I have complete database with user credentials.
So, shall we implement it on our end?
What i learnt abt AVS is it returns some code by
checking all the numeric values from the address.....So can we do the implementation at our end?
Any help will be appreciated

modified on Friday, June 19, 2009 12:00 AM

hi,
i am creating a site which has a paypal integration in it....
i am bit confused in selecting a paypal product.what i want to do is, when a user clicks a pay now button, a particular amount should pass to paypal for transaction and come back to my website again.
I went through paypal documents then i got PDT(Payment Data Transfer) but here they have not shown me how to send a particular amount.
As i am new to the paypal, i am bit confused.....plz help me.

coolsatty

Could you not try getting in contact with paypal tech support? I'm sure they'll be able to tell you the best option.

Hello All,

I want to get all System IP address Which is running from a DNS Server.

Thanks

Please Google first before you post , there are plenty examples

IP list, Check an IP number against a list in C#[^]

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
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

/// <summary><br />
    /// 获得客户端IP<br />
    /// </summary><br />
    /// <returns></returns><br />
    public static string GetClientIP()<br />
    {<br />
        string ip;<br />
        string[] temp;<br />
        bool isErr = false;<br />
        if (System.Web.HttpContext.Current.Request.ServerVariables["HTTP_X_ForWARDED_For"] == null)<br />
            ip = System.Web.HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"].ToString();<br />
        else<br />
            ip = System.Web.HttpContext.Current.Request.ServerVariables["HTTP_X_ForWARDED_For"].ToString();<br />
        if (ip.Length > 15)<br />
            isErr = true;<br />
        else<br />
        {<br />
            temp = ip.Split('.');<br />
            if (temp.Length == 4)<br />
            {<br />
                for (int i = 0; i < temp.Length; i++)<br />
                {<br />
                    if (temp[i].Length > 3) isErr = true;<br />
                }<br />
            }<br />
            else<br />
                isErr = true;<br />
        }<br />
        if (isErr)<br />
            return "1.1.1.1";<br />
        else<br />
            return ip;<br />
    }<br />

living none stoping.

Hi there..
I am a new user of .net and don't know much about it.I wanna make a application when i upload a video file it should be split into chunks and get uploaded simultaneously (means all the chunks get uploaded at the same time)but don't know how to split the single file into chunks and integrate it at the receiving end is well.
I hope you will help me as soon as possible.
Thanks In Advance

Thanks & Regards
Naved Mohammad

Only using HTML in client side cant do this. You need flash objects for this.

HTML Input type=file can only send files up in continuous stream. Smile | :)

Abhishek Sur

My Latest Articles
Working with Excel using MDAC

Basics on LINQ and Lambda Expressions

Create .NET Templates

Hi abhishek,
Thanks for replying man.I don't have any idea about flash objects,even i never ever heared about it is well,so Will you help or guide me to acheive this.
Hope you will reply as soon as possible. Smile

Thanks & Regards
Naved Mohammad