|
yes, here is my form tag code:
<form id="form1" runat="server" style="width: 100%; height: 75%;">
<div>
<table border="0" width="100%">
<tr>
<td style="width: 5%"></td>
<td valign="top" style="width:20%;"><font face="Verdana" size="2">
<asp:Label ID="lblCompany" Width="100%" runat="server">Company</asp:Label></font></td>
<td valign="top" width="70%">
<asp:Label ID="lblCompany1" runat="server"></asp:Label></td>
<td width="5%"></td>
</tr>
<tr>
<td style="width: 5%"></td>
<td valign="top" style="width:20%;"><font face="Verdana" size="2">
<asp:Label ID="lblAddress" Width="100%" runat="server">Address</asp:Label></font></td>
<td valign="top" width="70%">
<asp:Label ID="lblAddress1" runat="server" TextMode="MultiLine"></asp:Label></td>
<td width="5%"></td>
</tr>
<tr>
<td style="width: 5%"></td>
<td valign="top" style="width:20%;"><font face="Verdana" size="2">
<asp:Label ID="lblTelephone" Width="100%" runat="server">Telephone</asp:Label></font></td>
<td valign="top" width="70%">
<asp:Label ID="lblTelephone1" runat="server"></asp:Label></td>
<td width="5%"></td>
</tr>
<tr>
<td style="width: 5%"></td>
<td valign="top" style="width:20%;"><font face="Verdana" size="2">
<asp:Label ID="lblFax" Width="100%" runat="server">Fax</asp:Label></font></td>
<td valign="top" width="70%">
<asp:Label ID="lblFax1" runat="server"></asp:Label></td>
<td width="5%"></td>
</tr>
<tr>
<td style="width: 5%"></td>
<td valign="top" style="width:20%;"><font face="Verdana" size="2">
<asp:Label ID="lblEmail" Width="100%" runat="server">Email</asp:Label></font></td>
<td valign="top" width="70%">
<asp:Label ID="lblEmail1" runat="server"></asp:Label></td>
<td width="5%"></td>
</tr>
</table>
<br /><br />
<asp:GridView ID="myGridView" runat="server" Width="483px" CellPadding="4" ForeColor="#333333" AutoGenerateColumns="False" DataSourceID="AccessDataSource1">
<Columns>
<asp:BoundField DataField="Sno" HeaderText="SNo" SortExpression="Sno" />
<asp:BoundField DataField="Partno" HeaderText="PartNo" SortExpression="Partno" />
<asp:BoundField DataField="mfg" HeaderText="Manufacturer" SortExpression="mfg" />
<asp:BoundField DataField="qty" HeaderText="Quantity" SortExpression="qty" />
<asp:BoundField DataField="price" HeaderText="Price" SortExpression="price" />
</Columns>
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#EFF3FB" />
<EditRowStyle BackColor="#2461BF" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/db1.mdb"
SelectCommand="SELECT [Sno], [Partno], [mfg], [qty], [price] FROM [RfqInfo]"></asp:AccessDataSource>
<br />
<br />
<table border="0" style="width: 100%">
<tr>
<td style="width: 5%"></td>
<td valign="top" style="width:20%;"><font face="Verdana" size="2">
<asp:Label ID="lblComments" Width="100%" runat="server">Comments</asp:Label></font></td>
<td valign="top" width="70%">
<asp:Label ID="lblComments1" runat="server" TextMode="MultiLine"></asp:Label></td>
<td width="5%"></td>
</tr>
<tr>
<td style="width: 5%; height: 26px;"></td>
<td valign="top" style="width:10%; height: 26px;"><font face="Verdana" size="2">
<asp:Button ID="btnSubmit" Width="100%" runat="server" Text="submit" OnClick="btnSubmit_Click"></asp:Button></font></td>
<td width="5%" style="height: 26px"></td>
</tr>
</table>
<asp:Button ID="BtnExport" runat="server" OnClick="BtnExport_Click"
Text="Export to Excel" />
</div>
</form>
|
|
|
|
|
This peace of code works fine for me. I executed that one and is performing well.
Apurva Kaushal
|
|
|
|
|
hmm...but whats wrong from my side:
I executed it again but still the same error persists
here is the error::
Control 'myGridView' of type 'GridView' must be placed inside a form tag with runat=server.
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.Web.HttpException: Control 'myGridView' of type 'GridView' must be placed inside a form tag with runat=server.
Source Error:
Line 63: System.IO.StringWriter stringWrite = new System.IO.StringWriter();
Line 64: System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
Line 65: myGridView.RenderControl(htmlWrite);
Line 66: Response.Write(stringWrite.ToString());
Line 67: Response.End();
|
|
|
|
|
its showing the error at Line 65.
|
|
|
|
|
In order to overcome the error, We have to override the below function.
public override void VerifyRenderingInServerForm(Control control)
{
}
Regards,
Jay 
|
|
|
|
|
Cool stuff man... I will rate this...
|
|
|
|
|
Thanks (For Nellai Website Too)
-- modified at 5:45 Wednesday 13th June, 2007
Regards,
Jay
|
|
|
|
|
DKalepu wrote: myGridView.RenderControl(htmlWrite);
You cannot render the GridView Control into HTML directly. Use DataGrid.
May be Jay_se is correct. But I haven't tried that before. We also had this issue before and we solve that using DataGrid. We can used JavaScript get the HTML String of the GridView and do the same.
|
|
|
|
|
Hi,
Venkatesh MookkanYou cannot render the GridView Control into HTML directly.
We Can do Vankat. It works fine too.
Regards,
Jay
|
|
|
|
|
If it works fine, then no problem for me man..
Thanks...
|
|
|
|
|
Hi, Thank you very much for the help Jay..
That piece of code solved my problem.....
Thank you so much once again to all of you for helping on my problem/
|
|
|
|
|
Asp.net
=======
I have master page.
when i redirect to different pages in master page, page refeshes.
is there any why i could do
--> page is redirected.
--> client doesnot feel refresh effect
server.transfer ("filename") gives error
Thank you
vijaya
vijaya
|
|
|
|
|
How to call login page on session timeout,pls send me code for this.
Thank you.
|
|
|
|
|
Redirect the user to the login page using response.redirect method.
Apurva Kaushal
|
|
|
|
|
This is ok,but on which event should i write this code pls reply.
|
|
|
|
|
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]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
