ASP.NET Discussion Boards

Compare Adjacent Rows of a GridView Control

Sridhar Narayanan7-Jun-07 20:08

7-Jun-07 20:08

Hi,

I have requirement in which i need to compare two adjacent rows of a GridView Control and if adjacent cells are not equal, the color of the cell needs to be changed.

for example

System A B C
Prod 10.11 sri win
QA 10.11 vel win
Prod 11.11 sri win
QA 12.11 vel win
Prod
QA
''
''
''
''

in this the background of sri and vel and 11.11 and 12.11 need to be changed

javascript doubt

saravanan057-Jun-07 19:36

saravanan05

7-Jun-07 19:36

hi friends

i create one checkbox and one button in webapplication.

if i click the checkbox the button is disable,how can i achive this through javascript

regards
saravanan

Re: javascript doubt

Sylvester george7-Jun-07 20:11

Sylvester george

7-Jun-07 20:11

button client side event
=======================
onclick = 'method(this.checked)'

javascript
==========
function method(state)
{
document.getElementById("buttonID").disabled = state
}

Regards,
Sylvester G
sylvester_g_m@yahoo.com

Re: javascript doubt

Biju Sam7-Jun-07 20:15

Biju Sam

7-Jun-07 20:15

call a function in the onchange event of the checkbox.

disableButton(checkboxname.Checked)
the function must be doing some thing like this.

function disableButton(var status)
{
if(status)
document.getElementById("btnName").disabled=true;
else
document.getElementById("btnName").disabled=false;
}

}

Biju S

Re: javascript doubt [modified]

Chetan Ranpariya7-Jun-07 20:20

Chetan Ranpariya

7-Jun-07 20:20

Hi,

See the following code.

<asp:CheckBox ID="chk" runat="server" />
<asp:Button ID="bttnClick" runat="server" Text="Disabled" />

//The follwoing is javascript function.
function makedisable(sender)
{
if(sender.checked == true)
{
document.getElementById("bttnClick").disabled = true;
}
else
{
document.getElementById("bttnClick").disabled = false;
}
}

//Write following line in Page_Load.
chk.Attributes.Add( "onclick", "javascript:makedisable(this);" );

I hope this will help you.

-- modified at 2:28 Friday 8th June, 2007

Thanks and Regards,
Chetan Ranpariya

detailsview as item template in datalist,asp.net2.0+c#

regin7-Jun-07 19:29

regin

7-Jun-07 19:29

im using a details view control as a item template in the datalist..
i have linkbutton in the datalist.eg empid
if i click on tat i have to show the detailsview of tat empid...one empid can contain many records...like contactaddress,permenent address..
how can i do this?
thanks in advance..

Re: detailsview as item template in datalist,asp.net2.0+c#

Sathesh Sakthivel7-Jun-07 19:33

Sathesh Sakthivel

7-Jun-07 19:33

Hey its very simple in the detials view you can able to show only one record ie., if you click any one of the empid it will show only the details abt that empid

For more detials Clickety[^]

Regards,

Satips. Rose | [Rose]

Re: detailsview as item template in datalist,asp.net2.0+c#

regin7-Jun-07 21:01

regin

7-Jun-07 21:01

hw can i take the empid n bind it withe the details view dynamically..?

Converting .html to .aspx

SPRC7-Jun-07 19:09

SPRC

7-Jun-07 19:09

I am in the process of learning ASP.NET and read that when using Visual Studio 2005, you can add an existing .html file to your project and just rename it to .aspx to automatically convert it to a ASP.NET Webform. I've even seen it done on an "eLearning" video demo with Visual Studio .NET. However, when I try to duplicate the demo using Visual Studio 2005, it doesn't add the page directive like on the demo.
Anyone have a clue what I'm doing wrong?

Re: Converting .html to .aspx

Expert Coming7-Jun-07 19:15

Expert Coming

7-Jun-07 19:15

It won't automatically add anything to the page. It will only change the file type.

The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo

Re: Converting .html to .aspx

Christian Graus7-Jun-07 20:36

Christian Graus

7-Jun-07 20:36

changing the file type will just change the file type. Create a new page, and copy your HTML into it, being careful not to copy over the directives at the top. It will be exactly the same, but now you can add server controls and code behind, if you want to.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

ObjectDataSource Issue

Expert Coming7-Jun-07 19:07

Expert Coming

7-Jun-07 19:07

First off I realize this is a common issue and has plenty of people saying they have fixed it.

I am using VS 2005, programming in C# and ASP.NET. I have a GridView and an ObjectDataSource my GridView will display the data, but not update. I am using a three-tier application design. My DAL has on table with SELECT and INSERT type methods. My BLL has SELECT, UPDATE, INSERT, and DELETE methods. My presentation layer contains the ObjectDataSource and GridView.

When I attempt to update I get the following error:

ObjectDataSource 'odsSubdivisions' could not find a non-generic method 'UpdateSubdivision' that has parameters: intID, szName, szCity, szState, szZIP, szLegal, Name, City, State, ZIP Code, Legal Description.

The last 5 parameters are added by the ObjectDataSource I believe. I have set the OldValuesParameterFormatString to {0}, which most solutions say to do, yet no avail. I am not using Optimistic Concurrency either.

Any other suggestions. I'll try anything.

The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo

How to store and get private key in certificates?

zechariah7-Jun-07 18:46

zechariah

7-Jun-07 18:46

Hi,
Is there anybody has experience on this? how to implement in ASP.NET? Thank you!

My head say go, my feet say no.

AJAX UpdatePanel related

larree117-Jun-07 18:01

larree11

7-Jun-07 18:01

Good day to all,

I have a few panels control inside one UpdatePanel (AJAX extension), these items have drag and drop features, upon dragging these panels and dropping them at a different location, a webservice will be called from client side to update the new location of the panel in the database.

The problem now is I have another dropdownlist outside this UpdatePanel which is databind. Whenever the location of any panel is dragged and moved to a new location, the item in the dropdownlist should be different as it uses a stored procedure which is somehow link to the above attribute.

The problem I'm facing now is that I'm unable to update the dropdownlist by using the ddltest.DataBind() unless I reload the whole page instead of using an UpdatePanel. I'm quite new to AJAX so feel free to correct me on my misconcept and advise me on how should I tackle this problem. Thanks in advance

Cheers

Re: AJAX UpdatePanel related

Venk25912-Jun-07 18:32

Venk259

12-Jun-07 18:32

Hi larree11
You can also place the dropdownlist inside the UpdatePanel. You have one updatepanel which contains a few panels. So whenever panel is drag and dropped you want to update the dropdownlist, so better, you place the dropdownlist box inside the updatepanel and in the drag and drop features update the dropdownlist values.

I think this will help you to resolve your problem

Re: AJAX UpdatePanel related

larree1112-Jun-07 19:17

larree11

12-Jun-07 19:17

Hi Venk259,

First thanks for the reply... I did try this method before but the dropdownlist did not reload with fresh data whenever i drag and drop a panel.

I have set the dropdownlist autopostback to true but its not refreshing. Any idea why is it like tat? by the way the web service called by the drag and drop is done on client side by calling the webservice using javascript. Any work around?

Cheers

I NEED SOURCE FORUM ASP.NET WITH C#

suchon_phuong7-Jun-07 17:35

suchon_phuong

7-Jun-07 17:35

CAN I HELP ME? I NEED SOURCE FORUM ASP.NET WITH C#.

Re: I NEED SOURCE FORUM ASP.NET WITH C#

Christian Graus7-Jun-07 18:11

Christian Graus

7-Jun-07 18:11

GOOGLE IT !!!!

There's at least one forum here on CP in C#, I thought.

how can I get the next item?

lockepeak7-Jun-07 16:52

lockepeak

7-Jun-07 16:52

c#:
THE dataset or (datatable) have much items.
when I click the button(button.text=next) ,how can I get the next item from the dataset or(datatalbe)?
please help me!

By the way :follow method could not get the right answer,allways get the inital value:
private void method1(object sender, EventArgs e)
{
i=(i+1);

}

Re: how can I get the next item?

Arun.Immanuel7-Jun-07 17:51

Arun.Immanuel

7-Jun-07 17:51

Use ViewState to hold the DataSet and the Increment counter.

Regards,
Arun Kumar.A

Re: how can I get the next item?

Christian Graus7-Jun-07 18:12

Christian Graus

7-Jun-07 18:12

Please don't cross post. Answering in the C# forum, I assumed it was a winforms app.

Do you want to do a postback to get a specific item ? why not write the SQL to return only that item, and store the index in viewstate ?

Invalid cast from System.String to System.Byte[ ] [modified]

ASPnoob7-Jun-07 16:41

ASPnoob

7-Jun-07 16:41

Hi, I get the following error message when I run my application in the browser.

"Invalid cast from System.String to System.Byte[ ]"

I have changed cmdInsert.Parameters.Add("@docContent",OdbcType.Text) to

cmdInsert.Parameters.Add("@docContent",OdbcType.Binary)

like someone had suggested, but it still does not work. I have checked other variables for type mismatch but didn't find any. If you see anything at all wrong with my code please point it out. I would really be grateful if you can show me what is causing VS2003 to throw the exception. Thank you in advance for your help.

The following is my code to help you better understand my situation.

Imports System.IO
Imports System.Data.Odbc
Public Class Upload
    Inherits System.Web.UI.Page

 Private Sub Submit1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Submit1.Click
        Dim strFileExtension As String
        Dim StrFileType As String
        Dim intFileLen As Integer
        Dim objStream As Stream
        Dim strInsert As String
        Dim myConnection As OdbcConnection
        Dim cmdInsert As OdbcCommand


        If Not IsNothing(txtFileContents.PostedFile) Then
            'Determines File Type
            strFileExtension = Right(txtFileContents.PostedFile.FileName, 4)
            Select Case strFileExtension.ToLower
                Case ".doc"
                    StrFileType = "doc"
                Case ".ppt"
                    StrFileType = "ppt"
                Case ".htm"
                    StrFileType = "htm"
                Case ".html"
                    StrFileType = "html"
                Case ".txt"
                    StrFileType = "txt"
                Case Else
                    StrFileType = "jpg"
            End Select
            'Grab the content of uploaded file
            intFileLen = txtFileContents.PostedFile.ContentLength
            Dim arrFile(intFileLen) As Byte
            objStream = txtFileContents.PostedFile.InputStream
            objStream.Read(arrFile, 0, intFileLen)


            'Add UpLoaded file to a database
            myConnection = New OdbcConnection("Provider=MySQLProv; Data Source=Data;User Id=myID;Password=myPWD")
            strInsert = "INSERT into QUsers (docTitle,docContent,docDate,docType) values (?,?,?,?,?)"
            cmdInsert = new odbcCommand(strInsert,myConnection)
            
            cmdInsert.Parameters.Add("@docID",OdbcType.int,30)           
            cmdInsert.Parameters["@docID"].Values =""

            cmdInsert.Parameters.Add("@docDate", OdbcType.TimeStame,14)             
            cmdInsert.Parameters["@docDate"].Values = DateTime.Now.ToShortDateString()

            cmdInsert.Parameters.Add("@docTitle", OdbcType.Varchar,30  )
            cmdInsert.Parameters["@docTitle"].Values = txtFileTitle.Text       
            
            cmdInsert.Parameters.Add("@docType", OdbcType.Varchar,30)
            cmdInsert.Parameters["@docType"].Values =StrFileType

            cmdInsert.Parameters.Add("@docContent",OdbcType.Binary)           
            cmdInsert.Parameters["@docContent"].Values =arrFile
            
            myConnection.Open()
            cmdInsert.ExecuteNonQuery()
            myConnection.Close()
        End If

    End Sub
End Class

-- modified at 23:26 Thursday 7th June, 2007

Re: Invalid cast from System.String to System.Byte[ ]

ASPnoob8-Jun-07 16:01

ASPnoob

8-Jun-07 16:01

Problem Solved.

IDENTITY_INSERT

seemamltn7-Jun-07 15:30

seemamltn

7-Jun-07 15:30

I am trying to insert an record in table but it gives me following error. What does it means

Cannot insert explicit value for identity column in table 'tb' when IDENTITY_INSERT is set to OFF.

seema

Re: IDENTITY_INSERT

Sathesh Sakthivel7-Jun-07 16:46

Sathesh Sakthivel

7-Jun-07 16:46

Hey this is not the right forum to ask this question.

pls move this question to sql/ado/ado.net forum.

And as you have stated above the problem is occurred because of the following. So

@@IDENTITY contains the last identity value generated by your statement. If you insert into a table that runs a trigger and generates another identity value, you will get back the last value generated in any table. To solve this problem you'll need to use SCOPE_IDENTITY to return the inserted value. Every procedure, trigger, function and batch is it's own scope. SCOPE_IDENTITY shows the most recently inserted IDENTITY in the current scope (which ignores any triggers that might fire).

If you want to insert a value into an identity column you can use the SET IDENTITY_INSERT statement

SET IDENTITY_INSERT Yaks ON
Insert Yaks (YakID, YakName) Values(1, 'Mac the Yak')
SET IDENTITY_INSERT Yaks OFF
select * from yaks

You can only turn on IDENTITY_INSERT for one table per session so it's always a good idea to turn it off when you're done with it.

Regards,

Satips. Rose | [Rose]

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.