ASP.NET Discussion Boards

Hyland Computer Systems15-Jul-07 12:39

15-Jul-07 12:39

Dear sirs:

I have a Web Form with an SqlDataSource with a simple select statement, and a GridView control that is tied to it. There is a ComboBox and a Submit button as well. When a selection is made (the first time) in the combo box and then the submit button is clicked, the Selecting Event for the SqlDataSource fires.

However, on subsequent "submits" I cannot get the event to fire again. What do I need to do to get this event to fire; thus letting me know that new data is being fetched from the database?

Thank you,

R. Hyland

Re: SqlDataSource Refresh Problem

Fayu15-Jul-07 17:56

Fayu

15-Jul-07 17:56

1. What is your query?
2. Attach the code you are using

Re: SqlDataSource Refresh Problem

Hyland Computer Systems16-Jul-07 5:10

Hyland Computer Systems

16-Jul-07 5:10

Fayu wrote:
1. What is your query?
2. Attach the code you are using

Here is the code for the SqlDataSource:

<<asp:sqldatasource
id="sqlDataSourceG5WingRailCar"
="" runat="server" connectionstring="<%$ ConnectionStrings:oracleConnectionString %>" providername="<%$ ConnectionStrings:oracleConnectionString.ProviderName %>" selectcommand="select distinct to_date( mh.historydatetime , 'DD-MM-YYYY' ) ,
rh.movedescription ,
( mds.pct_util * count( rh.movedescription ) )

from requesthistory rh

inner join movehistory mh on rh.itd_number = mh.itd_number
inner join movedescription mds on rh.movedescr_id = mds.movedescr_id

where rh.movedescr_id = 1 AND mh.discrepancy_id = 25 AND EXTRACT(MONTH FROM mh.historydatetime) = :MONTH_ID

group by to_date( mh.historydatetime , 'DD-MM-YYYY' ) ,
rh.movedescription ,
mds.pct_util

order by to_date( mh.historydatetime , 'DD-MM-YYYY' )" onselecting="sqlDataSourceG5WingRailCar_Selecting">
<<selectparameters>>

<<asp:controlparameter
="" controlid="dropDownListMonth" name="MONTH_ID" propertyname="SelectedValue">>

<>

<>

<>

There really is no code for the Selecting Event, other than just capturing some text into a label when the event occurs (for testing purposes).

Thanks

Classic ASP to C# ASP.net

deantheking15-Jul-07 8:44

deantheking

15-Jul-07 8:44

Hi

I am currently working on converting a classic asp page to c# asp.net . I have come across this and was wondering if anyone would know the c# equivalent. It basically runs through a url string and takes the values out after every '=' sign. I was wondering if anyone could help.

function findField( fieldName, postResponse )
items = split( postResponse, chr( 13 ) )
for idx = LBound( items ) to UBound( items )
item = replace( items( idx ), chr( 10 ), "" )
if InStr( item, fieldName & "=" ) = 1 then
' found
findField = right( item, len( item ) - len( fieldName ) - 1 )
Exit For
end if
next
end function

Thanks
Dean

Re: Classic ASP to C# ASP.net

Pete O'Hanlon15-Jul-07 9:58

Pete O'Hanlon

15-Jul-07 9:58

You would just use the Split('=') command on your string. For instance:

string[] replies = reply.Split('=');

Please visit http://www.readytogiveup.com/ and do something special today.
Deja View - the feeling that you've seen this post before.

Re: Classic ASP to C# ASP.net

Guffa15-Jul-07 15:03

Guffa

15-Jul-07 15:03

Ouch. First let's clean up that VBScript code:

Function FindField(ByVal fieldName, postResponse)
   fieldName = fieldName & "="
   items = Split(postResponse, vbCrLf)
   For idx = 0 to UBound(items)
      If InStr(item, fieldName) = 1 Then
         FindField = Mid(item, Len(fieldName) + 1)
         Exit For
      End If
   Next
End Function

Now it's easy to translate:

public string FindField(string fieldName, string postResponse) {
   fieldName += "=";
   foreach (string item in Regex.Split(postResponse, "\r\n")) {
      if (item.StartsWith(fieldName)) {
         return item.SubString(fieldName.Length);
      }
   }
}

---
single minded; short sighted; long gone;

editing selected rows in a gridview

sudheer babu kodavati15-Jul-07 1:28

sudheer babu kodavati

15-Jul-07 1:28

i have a grid view.now i have added a template field to it and placed a check box in it.now i want to edit the selected rows only on click of edit button which is placed below grid view.

i want to edit multiple rows of grid view whick are selected by a checkbox..can anyone send the code as soon as possible

Re: editing selected rows in a gridview

Manas Bhardwaj15-Jul-07 5:46

Manas Bhardwaj

15-Jul-07 5:46

sudheer babu kodavati wrote:
can anyone send the code as soon as possible

Can you send us the cash as soon as possible. Mad | :mad:

on a serious note, atleast try a bit and someone here can always help you if you are stuck somewhere. Dont expect someone to give you the cooked rice. Rose | [Rose]

Re: editing selected rows in a gridview

Paul Conrad15-Jul-07 5:59

Paul Conrad

15-Jul-07 5:59

Manas Bhardwaj wrote:
Can you send us the cash as soon as possible.

Just get his mailing address and send him an invoice Roll eyes | :rolleyes:

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

Word Document Headers & Footers in .NET [modified]

Nitin Varambally15-Jul-07 1:24

Nitin Varambally

15-Jul-07 1:24

Can anyone tell me how to add header and footer to a dynamically generated word document using .net 2.0 ? I am able to generate the word document but i am unable to add/make visible the headers and footers in the document. I want page numbers to be coming up in the footers and some text in the header for all the pages in the doc... A quick response will be very much helpful....

Nithin Kumar V, .NET Developer

-- modified at 9:12 Saturday 21st July, 2007

I am using ASP.NET for this purpose.. This should be interesting... i havent got exact solution yet... any help is very helpful...

Nithin Kumar V, .NET Developer

exports the dataset to excel using asp.net 2005 (vb.net)

Sonia Gupta15-Jul-07 0:04

Sonia Gupta

15-Jul-07 0:04

is there any link that exports the data to excel from dataset using asp.net 2005 (vb.net)

Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....

Re: exports the dataset to excel using asp.net 2005 (vb.net)

gauthee15-Jul-07 19:10

gauthee

15-Jul-07 19:10

Sonia,
This is the best link for the exporting task
http://www.eggheadcafe.com/articles/20021012.asp[^]

The sample code uses datareader just replace your code with your dataset.
Hope this helps!

Gautham

need yr help for SqlDataSource1.Select method

hurrem14-Jul-07 23:40

hurrem

14-Jul-07 23:40

Hello,
I really somebody's help, please,
I need to get the count of rows that are equal to the given string. but I don't know how to store the result. Here is the code:

SqlDataSource1.SelectCommand="SELECT count(paperID) FROM Papers WHERE (paperID="+paperID+")";
now I need to get the value of count(paperID) and give it to some variable, like this:

int selectedNum = SqlDataSource1.Select(); //here it asks for some arguments<br />
          if (selectedNum == 0)<br />
              try<br />
              {<br />
                  string insertID = "INSERT INTO Papers(paperID) VALUES (" + paperID + ");";<br />
                  SqlDataSource1.InsertCommand = insertID;<br />
                  SqlDataSource1.Insert();<br />
                  ok = true;<br />
              }<br />
              catch (Exception eee)<br />
              { ok = false; }

thank you!

Re: need yr help for SqlDataSource1.Select method

gauthee15-Jul-07 18:46

gauthee

15-Jul-07 18:46

hi,

first create a command object and then exectue the query i.e. select count(*) statement.
when executing the command object use the executescalar method and equate the result to an integer value.

the sample code:
sqlCommand cmd = new SqlCommand();
cmd.commandtype = commandtype.text
//assign your query to the command here
int count = cmd.executescalar()

....
carry on with your rest of the code, hope this helps.

Gautham

Re: need yr help for SqlDataSource1.Select method

hurrem15-Jul-07 21:58

hurrem

15-Jul-07 21:58

Thanx for your replay, but it shows me this error:
Error 1 Cannot implicitly convert type 'object' to 'int'. An explicit conversion exists (are you missing a cast?)

I changed it, but still I get this exception:

Exception Details: System.InvalidOperationException: <br />
ExecuteScalar: Connection property has not been initialized.<br />
<br />
Source Error:<br />
<br />
Line 52:            cmd.CommandText="SELECT count(paperID) FROM Papers WHERE (paperID="+paperID+")";<br />
Line 53: //assign your query to the command here<br />
Line 54:             int count=(int) cmd.ExecuteScalar();<br />

thanx

Re: need yr help for SqlDataSource1.Select method

arslanjatt15-Jul-07 18:52

arslanjatt

15-Jul-07 18:52

Let me know is paperID is ur parameter? If yes then when u r going to select then pass this parameter as well

int selectedNum = SqlDataSource1.select(paperID);

hope this will help u

Regards, Arslan Ilyas

Code analysis [modified]

ASPnoob14-Jul-07 20:37

ASPnoob

14-Jul-07 20:37

Hi, the following code is taken from a tutorial on reading blobs by Ganegoda.

Private Sub CreateImage(ByVal id As String)<br />
<br />
	Dim _con As New SqlConnection(System.Configuration.ConfigurationSettings.AppSettings("DB"))<br />
<br />
	Try<br />
		_con.Open()<br />
		Dim _cmd As SqlCommand = _con.CreateCommand()<br />
		_cmd.CommandText = "select logo from" + " pub_info where pub_id='" + id + "'"<br />
		Dim _buf As Byte() = CByte(_cmd.ExecuteScalar())<br />
		Response.ContentType = "image/gif"<br />
		Response.BinaryWrite(_buf)<br />
	Catch<br />
	Finally<br />
		_con.Close()<br />
	End Try<br />
End Sub

I am new to vb.net and not very familiar with it. I have 2 questions regarding the code above.
1) Why is there a plus sign before and after id in the line where pub_id='" + id + "'"?
2) From reading the MSDN, _con.CreateCommand() is supposed to create a connection and return a SqlCommand object associated with the current connection. However I'm still not clear as to what that means. Is it the same as the following?

<br />
Dim _cmd As SqlCommand <br />
Dim Filter as String<br />
Filter = "select logo from" + " pub_info where pub_id='" + id + "'"<br />
_cmd = New SqlCommand(Filter, _con) <br />

Thanks in advance for your help.

-- modified at 4:04 Sunday 15th July, 2007

Re: Code analysis

Guffa15-Jul-07 3:46

Guffa

15-Jul-07 3:46

ASPnoob wrote:
1) Why is there a plus sign before and after id in the line where pub_id='" + id + "'"?

The + operator is used for addition. When used on strings it means that the strings are concatenated.

ASPnoob wrote:
2) From reading the MSDN, _con.CreateCommand() is supposed to create a connection and return a SqlCommand object associated with the current connection. However I'm still not clear as to what that means.

This code:

Dim _cmd As SqlCommand = _con.CreateCommand()

is equivalent to:

Dim _cmd As New SqlCommand(Nothing, _con)

---
single minded; short sighted; long gone;

Re: Code analysis

Paul Conrad15-Jul-07 4:59

Paul Conrad

15-Jul-07 4:59

ASPnoob wrote:
Filter = "select logo from" + " pub_info where pub_id='" + id + "'"

Have to be careful with this code. It is prone to SQL Injection attacks. Look at this article[^] on preventing SQL injection attacks.

"I've seen more information on a frickin' sticky note!" - Dave Kreskowiak

Re: Code analysis

Mohammed Hameed15-Jul-07 8:21

Mohammed Hameed

15-Jul-07 8:21

Hi Ganegoda,
The + sign is nothing but used for string concatenation. have u noticed that 'id' is we are passing with the string where pub_id=....., thats why we need to concatenate with plus signs on both sides.

Take care.

Please let me know if you have still doubts.........

Best Regards,
Mohammed Hameed. Smile | :)

Be a good professional who shares programming secrets with others.

Controls are not displaying after hosting the Page

Kurian_Kurian14-Jul-07 14:23

Kurian_Kurian

14-Jul-07 14:23

Hi.I host one page,i done that page in C#[ASP.Net].i just add one Label and given Text as "Welcome" after hosting this page when i open this page the page is blank,when i take the source of the page am getting Label1.text=Welcome what is the problem.should i set any property.

Re: Controls are not displaying after hosting the Page

Manas Bhardwaj14-Jul-07 22:36

Manas Bhardwaj

14-Jul-07 22:36

Are you sure it is not invisible? :->

Re: Controls are not displaying after hosting the Page

Guffa14-Jul-07 23:02

Guffa

14-Jul-07 23:02

It sounds like you have put some code in the wrong place. The server code runs on the server and is not visible in the html source, so somehow you have put the code somewhere where it's not server code any more.

I can't tell you any more than that without seeing any code.

---
single minded; short sighted; long gone;

Re: Controls are not displaying after hosting the Page

Kurian_Kurian14-Jul-07 23:29

Kurian_Kurian

14-Jul-07 23:29

The Following code is SourceCode [ HTML Code ].In the HTML Code can see one Label Control and the Text is Welcome,even that also is not displaying after hosting this page.

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Photos.aspx.cs" Inherits="Photos" EnableSessionState="False" %>

<title>Untitled Page

<asp:label id="Label1" runat="server" style="z-index: 100; left: 188px; position: absolute;
top: 46px" text="Welcome" width="237px" backcolor="#0066FF" forecolor="White">

<asp:datagrid id="dgPhotos" runat="server" style="z-index: 102; left: 168px; position: absolute;
top: 79px" cellspacing="20" gridlines="None" onitemcreated="dgPhotos_ItemCreated">
<columns>
<asp:templatecolumn>
<itemtemplate>

<itemstyle font-bold="False" font-italic="False" font-overline="False" font-strikeout="False"
="" font-underline="False" horizontalalign="Center" verticalalign="Middle">

The Page Load Event as follows

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataSet ds = new DataSet();
DataTable dt = new DataTable("Photos");
dt.Columns.Add("Photos", Type.GetType("System.String"));
foreach (string Files in Directory.GetFiles(Request.MapPath("Photos"), "*.jpg"))
{

dt.Rows.Add(Files);
}
ds.Tables.Add(dt);
this.dgPhotos.DataSource = ds;
this.dgPhotos.DataBind();
}
}

Re: Controls are not displaying after hosting the Page

Guffa15-Jul-07 0:34

Guffa

15-Jul-07 0:34

Half of you code is missing or unreadable. Use the "Ignore HTML" option when you are posting markup code.

---
single minded; short sighted; long gone;

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