ASP.NET

only first row from datareader gets affected

14-May-09 2:50

If you want to navigate in code behind, use a link button, because a hyperlink, is going to navigate without any sort of postback.

Christian Graus

Driven to the arms of OSX by Vista.

"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )

svknair14-May-09 1:38

svknair

14-May-09 1:38

sqlstr = "select country , city FROM tbl_data WHERE RID in( " & ID & ") "

dr = ''''''''''''''''''''exexuting the reader

Ifdr.HasRows Then
Whiledr.Read
Dim datacountry =dr("country").ToString.Trim
Dim datacity =dr("city").ToString.Trim

MsgBox(datacountry & "===" & datacity)

sqlstr = "SELECT user FROM tbl_info " _
& " WHERE country='" & drpcountry.SelectedItem.Text & "' AND city='" & drp city.SelectedItem.Text & "'"
dr = ''''''''''''''''''''exexuting the reader
Ifdr.HasRows Then
Whiledr.Read

sqlstr = "IF EXISTS (SELECT user, country, city FROM tbl_info " _
& " WHERE user='" &dr("user").ToString.Trim & "'" _
& " AND country='" & datacountry & "' AND city='" & datacity & "')" _
& " UPDATE tbl_info set user='" &dr("user").ToString.Trim & "' " _
& " WHERE user='" &dr("user").ToString.Trim & "' AND country='" & datacountry & "' AND city='" & datacity & "' " _
& " Else " _
& " INSERT INTO tbl_info(user,country, city) " _
& " VALUES ('" &dr("user").ToString.Trim & "','" & datacountry & "','" & datacity & "')"

''''''''''exexuting the query........
End While
End If

End While
End If

but in this only the first record from the country and city gets affected.

all the records obtained in the reader shld get affected
how do i rectify it

Re: only first row from datareader gets affected

Christian Graus14-May-09 2:51

Re: only first row from datareader gets affected

14-May-09 2:51

Have you ever used a debugger ?

Ramesh Swaminathan14-May-09 2:52

Ramesh Swaminathan

14-May-09 2:52

From you code, it seems that the SqlDataReader variable 'dr' is re-builds again within the first while loop.

Use another variable for inner data reader.

Re: only first row from datareader gets affected

Christian Graus14-May-09 3:01

Basic Photography Web Site (PLZ H3LP IRGint!!!)

14-May-09 3:01

I was hoping to instead teach him how to debug his own code, one run through in the debugger should have told him what was wrong.

Brady Kelly14-May-09 0:59

Brady Kelly

14-May-09 0:59

I have something of a time issue, and I need to deliver a very basic, early edition of a web site within the next two days or so. I would like to have at least:

Three horizontal 'bands':
1) a flagship photo and some text at the top
2) a horizontal photo-film (with sprocket holes etc.) underneath that, with frames containing one photo for each of several categories, where clicking one opens a set of photos in the category in the bottom band
3) a bottom band containing pages of photos for a chosen category.

I would appreciate some suggestions on the quickest and easiest way to achieve this using ASDP.NET 'dirty tricks' and technologies. I think a DataList for the film strip and bottom band will be quickest, but how can I achieve the 'sprocketed frame' look quickly?

You really gotta try harder to keep up with everyone that's not on the short bus with you.
- John Simmons / outlaw programmer.

Re: Basic Photography Web Site (PLZ H3LP IRGint!!!)

Christian Graus14-May-09 1:09

table inside a href=".." Question?

14-May-09 1:09

The sprocket look is bound to be a bitmap with the filmstrip placed top and bottom with the photos in the middle. I would use a repeater, because of the level of control it gives you.

Checkout XARA

David Mujica14-May-09 3:31

David Mujica

14-May-09 3:31

I haven't used this tool yet, but I watched some demo videos and it looks really cool.

Xara Web Designer

http://www.xara.com/us/[^]

mrcooll14-May-09 0:59

mrcooll

14-May-09 0:59

hi all,
m trying to create email newsletter ,
and m putting content of the newsletter in a table and i want the user to be able to click on the table content to go to some link, it works fine on chrome but not in IE , here is my code.

//Email body is html format
<%-- <a href='someurl'>
'<table>
'newsletter data
'</table>
'</a>
--%>
and i forget something ,we cant but any script "onclick();" here because it will be disable by email engine .

thanks for all.

Re: table inside a href=".." Question?

jbracken197314-May-09 2:05

jbracken1973

14-May-09 2:05

I don’t think you can put a table inside a link, it is not a standard (W3C) so browsers will translate it differently. Instead put your link in your cell. Then perhaps use a style to make it not look like a link.

<table border="1">
<tr>
<td>
<a href="http://www.codeproject.com" style="text-decoration:none; color:Black; display:block;">
This is my news letter
</a>
</td>
</tr>
</table>

<br />
<table border="1"><br />
  <tr><br />
    <td><br />
      <a href="http://www.codeproject.com" style="text-decoration:none; color:Black; display:block;"><br />
        This is my news letter<br />
      </a><br />
    </td><br />
  </tr><br />
</table><br />

PS.. If you are trying to trick the end user to go to your site, many of them now require you to hold down a button to follow the link.

John

Re: table inside a href=".." Question?

Samer Aburabie14-May-09 2:10

Samer Aburabie

14-May-09 2:10

Hi there,
First of all table control cant be nested in (a) tag (this will not make the content clickable), second of all you should be using tr and td tags within a table ...

To solve this you could use the following example:
<table>
<tr>
<td>
<a href="Home.aspx">Hit Me</a>
</td>
</tr>
</table>

Here you are nesting the (a) element inside the table element in which it will be clickable according to the behaviour you want.

Hope that helped !

Sincerely Samer Abu Rabie

Imagination is more important than knowledge !

Problem while binding data to a DropDownList in GridView's EditItemTemplate column

YazhiniP14-May-09 0:32

YazhiniP

14-May-09 0:32

Hi,
I am a beginner in .NET.
I Placed a DropDownList in GridView's EditItemTemplate field.
Whenever i click the Edit Button i am getting a runtime error stating
"object Reference not set to an instance of the object".
That is,when i try to find the DropDownList using FindControl method,it is always null.
I have tried a lot of code in both GridView's RowBound and RowEditing events.
But,all the time i am getting the same error.
Below i have given the code that i tried in RowEditing event.
It will be very helpful if anyone help me in resolving this error.

.aspx source code

<asp:gridview id="gvDocumentDetails" runat="server" autogeneratecolumns="false" width="97%" autogenerateeditbutton="true"

="" ondatabinding="gvDocumentDetails_DataBinding" onrowediting="gvDocumentDetails_RowEditing" onrowupdating="gvDocumentDetails_RowUpdating" onrowdatabound="gvDocumentDetails_RowDataBound">

<columns>

<asp:boundfield headertext="Incident ID" datafield="Incident_ID">

<asp:boundfield headertext="Application" datafield="Application">

<asp:boundfield headertext="Type" datafield="Type">

<asp:boundfield headertext="Document Details" datafield="Document_Details">

<asp:boundfield headertext="Uploaded Date" datafield="Uploaded_Date">

<asp:templatefield headertext="Approval Status">

<itemtemplate>

<asp:label id="lblDocumentStatus" runat="server" text="<%#" eval("approval_status")="" %="">/>

<edititemtemplate>

<asp:dropdownlist id="ddlApprovalStatus" runat="server" datatextfield="Approval_Status" datavaluefield="Approval_Status_ID">

.cs file

protected void gvDocumentDetails_RowEditing(object sender, GridViewEditEventArgs e)

{

int intEditIndex;

intEditIndex = e.NewEditIndex;

gvDocumentDetails.EditIndex = e.NewEditIndex;

PopulateApprovalStatus(intEditIndex);

}

protected void PopulateApprovalStatus(int intRowIndex)

{

DataSet dsApprovalStatus = new DataSet();

DropDownList ddlApprovalStatus = null;

ObjReviewDocumentsBL.LoadApprovalStatus(out dsApprovalStatus);

ddlApprovalStatus = (DropDownList)gvDocumentDetails.Rows[intRowIndex].Cells[6].FindControl("ddlApprovalStatus");

ddlApprovalStatus.DataSource = dsApprovalStatus;

ddlApprovalStatus.DataBind();

}

I have checked the "dsApprovalStatus" dataset while debugging,and it has been filled by the LoadApprovalStatus() function.But, i m getting error in the following line.

ddlApprovalStatus.DataSource = dsApprovalStatus;

And ddlApprovalStatus value is null.

Thanks in advance...

Yazhini

Re: Problem while binding data to a DropDownList in GridView's EditItemTemplate column

Samer Aburabie14-May-09 2:23

Samer Aburabie

14-May-09 2:23

Hi there,
I think you already knew half the solution to your problem ... the returned null object from FindControl is because he really cant find it in Cell[6]... well try going more deeper ... use the debugger to see all controls inside Cell[6] and then in each one try finding your dropdownlist ... I think all you have to do is go one step deeper as I recall for the EditTemplate.

Sincerely Samer Abu Rabie

Imagination is more important than knowledge !

Re: Problem while binding data to a DropDownList in GridView's EditItemTemplate column

YazhiniP15-May-09 0:02

YazhiniP

15-May-09 0:02

Yes...i might have been given as Cell[5].But,that alone is not the mistake.
I have resolved the problem now...
I think the main mistake is that i haven't filled the Grid at the RowEditing event.
After doing that,i got it.
Anyhow,thanks for helping me...
Now,i have another doubt.
How to retrive the cell value of the BoundField in the RowUpdating event?.
For example,i have to retrive the IncidentNo whose ApprovalStatus has been edited and have to pass both the ApprovalStatus and IncidentNo values to another function.
Since The IncidentNo column is a BoundField control,how to get it's value in the RowUpdating event?

Yazhini

coding for scanner in aspx page

rummer14-May-09 0:02

14-May-09 0:02

i am taking a button in aspx page,so we want that when we click on button so my hp scanner will start.plz give some understandable code.
thanks and regrds
vivek

Paddy Boyd14-May-09 0:09

Paddy Boyd

14-May-09 0:09

Is your scanner on the server??

rummer14-May-09 0:18

14-May-09 0:18

ya my scanner is in the server

Paddy Boyd14-May-09 0:26

Paddy Boyd

14-May-09 0:26

So are you emailing somebody to get them to run round and put a bit of paper in the scanner before you click the button on your client machine?

rummer14-May-09 0:32

14-May-09 0:32

i have prepare an aspx page,in the page we are giving one field of imagemap.so we will take image by call hp scanner,

rummer14-May-09 0:52

14-May-09 0:52

ya i will put any paper or photo in my machine and when we click in my button so scanner will start

rummer14-May-09 0:57

14-May-09 0:57

so,plz give me some code for this

Christian Graus14-May-09 1:13