Sorting problem in GridView [modified] - ASP.NET Discussion Boards

In the load event of the page you can check for the session and then if it is not available then user should be redirected to login page.

Apurva Kaushal

Hi,

if(session["LoginName"] == null)
{
response.redirect("Loginpage.aspx");
}

I hope this will help you.

Thanks and Regards,
Chetan Ranpariya

Go with Response.Redirect("urpage.aspx");

Regards,

Satips. Rose | [Rose]

hi, my last post i have already find out how to add the record. and i manage to add the record into the Movie Table. now i hav another problem which is in my form the actor n director have a dropdown list for user to choose n if in the dropdown list the the actor cannot be found the user can type in the name. how am i goin to do the code to detact if the dropdown list is empty then go to the textbox n add the name that they have key in? below is my code which i have done so far. Thanks a lot 4 the help

Protected Sub Submit_Click(ByVal sender As Object, ByVal e As System.EventArgs)

Dim Moviename
Dim Actorname
Dim Director
Dim Language
Dim Numberofdisc
Dim Studio
Dim ReleaseDate
Dim Price
Dim Quantity
Dim sql
Dim asql

Dim DBconn As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=" & Server.MapPath("dvd_rental.mdb"))

DBconn.Open()

Moviename = Request.Form("txtmovieName")
Actorname = Request.Form("txtActorname")
Director = Request.Form("txtDirector")
Language = Request.Form("txtLanguage")
Numberofdisc = Request.Form("txtNoofdisc")
Studio = Request.Form("txtStudio")
ReleaseDate = Request.Form("txtReleaseDate")
Price = Request.Form("txtPrice")
Quantity = Request.Form("txtQuantity")

sql = "INSERT INTO Movie(MovieName, MovieLanguage, Numberofdisc, Studio, ReleaseDate, Price, Quantity) "

sql = sql & "VALUES('" & Moviename & "'"
sql = sql & ",'" & Language & "'"
sql = sql & ",'" & Numberofdisc & "'"
sql = sql & ",'" & Studio & "'"
sql = sql & ",'" & ReleaseDate & "'"
sql = sql & ",'" & Price & "'"
sql = sql & ",'" & Quantity & "')"

asql = "INSERT INTO Actor(Actor Name)VALUES('" & Actorname & "')"

Dim dbq As New OleDb.OleDbCommand
dbq.CommandType = CommandType.Text
dbq.CommandText = asql
dbq.Connection = DBconn
dbq.ExecuteNonQuery()

Dim dbquery As New OleDb.OleDbCommand
dbquery.CommandType = CommandType.Text
dbquery.CommandText = sql
dbquery.Connection = DBconn
dbquery.ExecuteNonQuery()

DBconn.Close()
DBconn = Nothing

Response.Redirect("WebAddResult.aspx")
End Sub

function Table1_onclick() {

}

function Text1_onclick() {

}

Add new DVD Record

DVD Title:
Actor:	DataTextField="Actor_Name" DataValueField="Actor_Name" Width="132px"> SelectCommand="SELECT [Actor Name] AS Actor_Name FROM [Actor]">
Director:	DataTextField="Director_Name" DataValueField="Director_Name"> SelectCommand="SELECT [Director Name] AS Director_Name FROM [Director]">
Language:
Number of Disc:
Studio:
Release Date:
Price:
Quantity:

ling

ling

Hi,

What to do with the code?
Any question or error?

Thanks and Regards,
Chetan Ranpariya

hi. i would like to know wat code to use. my program does run n add 4 the dvd title, language, release date, studio, price n quantity. jus that my actor n director i nt sure wat code to use. thanks a lot 4 ur help Smile | :)

Hi,

Thats the question of logic.

First you should put an item in dropdownlist which can be used to indicate that no value is selected from the dropdownlist such as a "Other".

Then you should check for the value of dropdownlist in the form collection if it is "Other" or not.
It it is "Other" then you should go for the textbox value.
The code might be like following.

String strActor;
strActor= Request.Form["ddlActor"];
if(strMovieName == "Other")
{
strActor= Request.Form("txtActor");
}

The same thing you can implement for other stuff also.

I hope this will help you.

Thanks and Regards,
Chetan Ranpariya

I have Table News
NewsID, int
NewsHeadLint, varcahr(200)
OrderNews, int

I gridView Display as following query
Select ID,NewsHeadLine from News order By OrderNews DESC
----
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="NewsID" EmptyDataText="There are no data records to display."
DataSourceID="SqlDataSource1" Style="position: relative; left: 4px; top: 44px;" OnRowCommand="Grid1_Command" AllowPaging="True" PageSize="8" Width="571px" >
I have Add in gridView 2 buttonField
<asp:ButtonField ButtonType="Image" CommandName="CmdUp"..
<asp:ButtonField ButtonType="Image" CommandName="CmdDown"
..

CmdUP(command up) get the value of current order row and row the above in gridView and
swtich between them
In CS code
protected void Grid1_Command(object sender, System.Web.UI.WebControls.GridViewCommandEventArgs e)
{

// Object o = sender;

String z = (String)e.CommandArgument;

int indexGrid = Convert.ToInt16(z);
String CommandNamew = e.CommandName.ToString();
switch (CommandNamew)
{
//-------------------------------------------

case "CmdUp":
{

//I have write query and correctly excute in Database

String NewsIDcurrent = GridView1.DataKeys[indexGrid].Value.ToString().Trim(); //IDnews
//Response.Write(GridView1.DataKeys[Convert.ToInt16 (z)].Values[0].ToString());

SqlCommand Cmd = new SqlCommand();
Cmd.Connection = conn;

if ((indexGrid + 1) != GridView1.DataKeys.Count)
{

//NewsIDvalue this the current Id
String NewsIDunder = GridView1.DataKeys[indexGrid + 1].Value.ToString().Trim();
try
{
conn.Open();
//---Current
Cmd.CommandText = "Select OrderNews from News where NewsID=" + NewsIDcurrent;
int orderVal = (int)Cmd.ExecuteScalar();

Cmd.Parameters.Clear();

Cmd.CommandText = "Select OrderNews from News where NewsID=" + NewsIDunder;

int orderUnder = (int)Cmd.ExecuteScalar();
Cmd.Parameters.Clear();

Cmd.CommandText = "update News Set OrderNews=" + Convert.ToString(orderUnder) + " where NewsID=" + NewsIDcurrent;
Cmd.ExecuteNonQuery();

//--Under
Cmd.Parameters.Clear();

Cmd.CommandText = "update News Set OrderNews=" + Convert.ToString(orderVal) + " where NewsID=" + NewsIDunder;
Cmd.ExecuteNonQuery();

Cmd.Parameters.Clear();

// GridView1.DataBind();
}

catch (Exception ex)
{

}

finally
{
conn.Close();
// Response.Redirect("NewsCollection.aspx"); with it or without it
}

}

break;
}//end cmddown

case "CmdDown":
{

//I have write query and correctly excute in Database same idea as above

break;

}
default: { break; }

............

I have problem with this command( excute twice,or not display the result unless u refresh the browser..)what excatly best way to write and what event I must to write in the webpage(_Load _preRender..)

aj123

-- modified at 2:26 Wednesday 13th June, 2007

Hi friends,

If I am making my some member variable of a class as a static(say int i),then at each Page Postback i m able to manipulate(say increment) the previous value of i.My Question is whether by making member as a static are we making it to be remember by server during subsequent page requests..if so then how http is stateless..

Warm Regards,
Rahul Agarwal

Hi,

Remember that static members belongs to a class. Therefore whatever you do to it in a class will be remembered for the time that this application is running in it's own session (will not influence another user). But the problem is it will be reset when the application close.

Regards,

Elizma

Thanks..But I tried something like this..

static int i;
protected void Page_Load(object sender, EventArgs e){}protected void Button1_Click(object sender, EventArgs e)
{ i=i+1;
TextBox1.Text=i.ToString();
}

For each Button Click event, the value of "i" is incremented and displayed in the TextBox.

I have clicked the button 5 times and the text box shows 5 in it.

At this moment,when I opened another browse , copy - paste the same url
and I tried to click the button, it shows "6" in it.

Then why it working when i am opening the page in new browser window..My question is whether making it static will make it remember at server during subsequent page postbacks or not?
Warm Regards,
Rahul

according to me value of static variables is maintained at server till that variable is not assigned null value or u need to call the destructor to relase the memory occupied by that variable.Else server will maintain the varaibles value even if u close the application from client end.

Http is stateless, ASP.NET is not.
Http is the communication protocol that helps the browser and the web server talk and exchange HTML. Your ASP.NET website is also an application, but it runs inside an application domain within IIS.

SG

Thanks for answer..so static variable will be maintained at server during subsequent page requests..right?

That's right.

SG

Iam wriiten the code for ASp.Net 2.0 using the Control TRee View and database to display in a tree view.
But when I run the code Iam getting an error as

"The file web.sitemap required by XmlSiteMapProvider does not exist."

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: The file web.sitemap required by XmlSiteMapProvider does not exist.

Do you have a Web.sitemap file at the root level of your web site virtual folder ?

This must be a valid XML file with your menu description.

Regards,

Satips. Rose | [Rose]

Can u tell me how this could be checked abnd if not present what i should do?

first u put a SiteMapDataSource control on page.
then set it to ur Treeviews DataSourceID.
Before this make a web.sitemap and assign data what u want to show in Treeview.

Bajrang Singh
Using .net 2.0 (VS2005)

Please stop using 'urgent' in your message titles.

______________________
stuff + cats = awesome

i want to open a website e.g. youtube.com inside my site.is there any way to do it.
if yes?
then please help me how i can do it.
i really need ur help.

alok tripathi

Hi,

Put an IFRAME in your page and set its src property to the desired URL.

Thanks and Regards,
Chetan Ranpariya

Hi Alok

WE can use hyperlink (type the nameof the web site in ur form then drag the mouse right click select the option make hyperlink) to open any web site from your page, But exactly what u want i didnt got (Is it like in the same window u want to open ??)
Regards

Prakash Mishra(Banglore,India)

yes i want it to open it inside same window

alok tripathi

Go with IFrame and set the Src Property to the Desired URl which you want to Open in the Site.

Regards,

Satips. Rose | [Rose]