ASP.NET

Re: SQL/Item list collection

2-Aug-07 6:31

It depends. If you have a simple Yes and No in your drop down the probably not. If you have items that may be changing, it might make sense to load it from SQL. Sometimes it depends on what your client is willing to pay for.

Ben

wpoopsi2-Aug-07 6:38

wpoopsi

2-Aug-07 6:38

oh..ok, thanks. I had 55 names I added using the Item List. I converted an Access database to SQL Server for someone, but there's no data in it. I guess later whatever she wants, it can be changed. Thanks for your time, have a good day.

Crystal Reports and Reporting Services

ZeroInfinity2-Aug-07 4:50

ZeroInfinity

2-Aug-07 4:50

I need help on Crystal Reports or Reporting Services.
I have some variables that I get it from the user as textbox or dropdownlist control than pass it to the Crystal Report or the Reporting services.

But, I can not do this. I don't know how to pass the variables (parameters) I get from the user and show the Crystal Report to the user.

Could someone tell me how to do this please.

Thank you so much in advance.

control datagrid1_.... must be placed inside a form tag with runat=server.

MissionSuccess2-Aug-07 3:40

MissionSuccess

2-Aug-07 3:40

Respected Gurus
I have to export a datagrid to excel in asp.net1.1

my code is:---

Private Sub btnExport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnExport.Click
Response.ContentType = "application/vnd.ms-excel"
' Remove the charset from the Content-Type header.
Response.Charset = ""
' Turn off the view state.
Me.EnableViewState = False

'Dim tw As New System.IO.StringWriter
tw = New System.IO.StringWriter
'Dim hw As New System.Web.UI.HtmlTextWriter(tw)
hw = New System.Web.UI.HtmlTextWriter(tw)

' Get the HTML for the control.
DataGrid1.RenderControl(hw)
' Write the HTML back to the browser.
Response.Write(tw.ToString())
' End the response.
Response.End()
End Sub

whenever i run this code i got the error message that control datagrid1_....
must be placed inside a form tag with runat=server.

i chack the same.

Plz suggest.

hot regions on image maps

pipet20022-Aug-07 3:16

pipet2002

2-Aug-07 3:16

how can i make hot regions on an image map change colour with a change in some statement in the database

am trying

Open popup window from gridview

tahsinates2-Aug-07 3:06

2-Aug-07 3:06

Hello;
I want to open a popup window, which shows details of a product, from gridview.
I used imagebutton for that aim in gridview and the code of that is;

ImageButton ID="ImageButton3" runat="server" OnClientClick ="javascript:openEkBilgi('ekBilgi.aspx?Kod=<%# Eval('Kod') %>');" Height="21px" ImageUrl="~/images/makefileappwiz.ico"

and the javascript code is:

function openIcerik(pagename)
{
window.open(pagename,'icerik','width=500,height=550');
}

and the ekBilgi.aspx.cs code is:

public partial class ekBilgi : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string Kod = Request.QueryString["Kod"].ToString();
String con_str;
object obj;
SqlCommand cmd;
con_str = WebConfigurationManager.ConnectionStrings["EgitimConnectionString"].ConnectionString;
SqlConnection conn = new SqlConnection(con_str);
cmd = new SqlCommand("Select EkBilgi from Egitim where Kod=@Kod", conn);
cmd.Parameters.AddWithValue("Kod", Kod);
conn.Open();
obj = cmd.ExecuteScalar();
conn.Close();
Label1.Text = (string)obj;

}

}
}

but it doesn't work.
Can somebody help me...

kubben2-Aug-07 3:23

2-Aug-07 3:23

You javascript is not correct. You have:
openEkBilgi(
You need
window.open(

Hope that helps.
Ben

tahsinates2-Aug-07 3:41

2-Aug-07 3:41

Thanks for your help.
But I used javascript function, in it I used window.open() like below:

function openIcerik(pagename)
{
window.open(pagename,'icerik','width=500,height=550');
}
Function is coming from the imagebutton OnClientClick event, as below:
ImageButton ID="ImageButton3" runat="server" OnClientClick ="javascript:window.open('ekBilgi.aspx?Kod=<%# Eval('Kod') %>');" Height="21px" ImageUrl="~/images/makefileappwiz.ico"

I tried also your suggestion, but again it did not work.
Could you please look again for see is there anything wrong...
So thankss.

Tahsin Ateş

kubben2-Aug-07 3:48

2-Aug-07 3:48

Perhaps you should just add an anchor tag instead of the imagebutton:
<a id="hyperLink" title="icerik" target="_blank" href='<%# "ekBilgi.aspx?Kod="+DataBinder.Eval(Container.DataItem,"Kod").ToString() %>'>makefileappwiz</a>

You might want to try using DataBinder.Eval as well.

Hope that helps.
Ben

tahsinates2-Aug-07 3:59

2-Aug-07 3:59

Thank you very much, it works. But in my project I want to show that details in a small popup window. İf I can fix the size of that explorer page, It can also help me. Do you know how to do that.
Thank you very much...
Tahsin

kubben2-Aug-07 4:02

2-Aug-07 4:02

You could add some java script to the load event of that page and do these javascript functions:

window.moveTo(0,0);
window.resizeTo(500,500);

Ben

tahsinates2-Aug-07 4:04

2-Aug-07 4:04

So thanks.
Have a nice day...

tahsinates2-Aug-07 4:08

2-Aug-07 4:08

Sorry. my javascript knowledge is not good. Can you show how to write javascript in my page load event.
Thanks

kubben2-Aug-07 4:18

2-Aug-07 4:18

What version of visual studio are you using? .net 1.1 or .net 2.0? It affects the syntax a little bit. VB.net or C#?

Ben

tahsinates2-Aug-07 4:20

2-Aug-07 4:20

ASP.NET 2.0 and I am using C#.

Thank you.

Tahsin

kubben2-Aug-07 4:28

2-Aug-07 4:28

First in the page_load event of the for in the code behind. You will want to have:

If (!IsPostBack)
{
  Type t = this.Page.GetType();
  this.Page.ClientScript.RegisterClientScriptBlock(t, "resizeWindow", 
        "window.moveTo(0,0);window.resizeTo(500,500);", true);
}

So it will run once the first time the page is loaded.

Hope that helps.
Ben

tahsinates2-Aug-07 4:32