|
Create a stored procedure and get the data from multiple tables as per their relation in one result set and display them in grid view.
|
|
|
|
|
If these two tables are similar, you can use a UNION[^] clause.
If they have a foreign key relationship, you could join[^] the two tables and then display them together.
Or
DataRelation dr = new DataRelation("Relation", ds.SomeTable.Columns["code"], ds.OtherTable.Columns["pCode"]);
gView.DataSource = ds.SomeTable;
|
|
|
|
|
Hi,
EveryOne
Is there is any other way to display column data in descending order in asp.net Gridview.
|
|
|
|
|
|
Hi,
EveryOne
I read many articles from net regarding IsPostBack in asp.net, but still i can't understand it properly?
Can anyone explain me with Simple Code in asp.net, what is IsPostBack in asp.net and what is it's use?
So that i can understand it properly?
Thanks in Advance...
|
|
|
|
|
|
To put it simply
A web page uses the HTTP Protocol to a web server to receive and send HTML
http://www.w3schools.com/tags/ref_httpmethods.asp[^]
So when you request a webpage, the HTTP protocol calls that
GET
When you fill out a form, you have to send the changed page back to the server, so that is called
POST
When using Page.IsPostback
You are saying, if the page is posting back to the server.
eg. POST
Submitting a form, a Button Click and the code that fires when the button clicks
A dropdown list item is selected.
Or you are saying, If the page is not posting back to the server.
eg. GET
The form is loading for the first time
Example:
When you create a form, you create the HTML such as empty textboxes.
In Page Load, you can populate the empty textboxes with values
So in Page Load
If Not Page.IsPostback then
End if
|
|
|
|
|
hi every body after long tome i am using Asp.NEt 2010 but when i define class on page then it give error------
System.NullReferenceException: Object reference not set to an instance of an object.
at ttt.DBOpration..ctor() in f:\Piyush Project\WebSite\holyschoolmanagementsystem\App_Code\DBOpration.cs:line 20
at Default3.uxtxtbtnregister_Click(Object sender, EventArgs e) in f:\Piyush Project\WebSite\holyschoolmanagementsystem\Schoolregistration.aspx.cs:line 21
Piyush Vardhan Singh
p_vardhan14@rediffmail.com
Eventure Technology
http://holyschoolofvaranasi.blogspot.com
http://holytravelsofvaranasi.blogspot.com
|
|
|
|
|
Hi,
I want to display the column in descending order in gridview.And i want to change it in descending order in this code only, Can anyone help:-
This is my code:
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack == false)
{
bindgird();
}
}
void bindgird()
{
String str = "Select*from Customer_Details ";
if (ViewState["SortCol"] != null)
str += " Order by " + (string)ViewState["SortCol"];
DataSet ds = new DataSet();
SqlConnection con = new SqlConnection(Class1.con_String);
con.Open();
SqlDataAdapter da = new SqlDataAdapter(str,con);
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
con.Close();
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
bindgird();
}
protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
{
ViewState["SortCol"] = e.SortExpression;
bindgird();
}
}
Thanks in Advance.
|
|
|
|
|
|
I'm getting the following error after I upgraded my solution's .Net Framework from 3.5 to 4.5:
"Error 6 Custom tool error: Failed to generate code. Failed to generate code. Exception of type 'System.Data.Design.InternalException' was thrown. Exception of type 'System.Data.Design.InternalException' was thrown."
in this .xsd file:
="1.0"="utf-8"
<xs:schema id="DBParametersDS" targetNamespace="http://tempuri.org/DBParametersDS.xsd" xmlns:mstns="http://tempuri.org/DBParametersDS.xsd" xmlns="http://tempuri.org/DBParametersDS.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
<xs:annotation>
<xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
<DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
<Connections>
<Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="WebSrvViewingAdminConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="WebSrvViewingAdminConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.SrvViewingToolAdmin.Properties.Settings.GlobalReference.Default.WebSrvViewingAdminConnectionString" Provider="System.Data.SqlClient">
</Connection>
</Connections>
<Tables>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GetParameterTableAdapter" GeneratorDataComponentClassName="GetParameterTableAdapter" Name="GetParameter" UserDataComponentName="GetParameterTableAdapter">
<MainSource>
<DbSource ConnectionRef="WebSrvViewingAdminConnectionString (Settings)" DbObjectName="WebSrvAdmin.GetParameter" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
<CommandText>WebSrvAdmin.GetParameter</CommandText>
<Parameters>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ParameterName" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="PAR_PARAM_DATA" DataSetColumn="VALUE" />
</Mappings>
<Sources>
<DbSource ConnectionRef="NGSUPPORTConnectionString (Settings)" DbObjectName="WebSrvAdmin.GetParameter" DbObjectType="StoredProcedure" GenerateShortCommands="True" GeneratorSourceName="GetParameterValue" Modifier="Public" Name="GetParameterValue" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy" UserSourceName="GetParameterValue">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
<CommandText>WebSrvAdmin.GetParameter</CommandText>
<Parameters>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ParameterName" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
</Tables>
<Sources>
</Sources>
</DataSource>
</xs:appinfo>
</xs:annotation>
<xs:element name="DBParametersDS" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="DBParametersDS" msprop:Generator_DataSetName="DBParametersDS">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="GetParameter" msprop:Generator_UserTableName="GetParameter" msprop:Generator_RowDeletedName="GetParameterRowDeleted" msprop:Generator_RowChangedName="GetParameterRowChanged" msprop:Generator_RowClassName="GetParameterRow" msprop:Generator_RowChangingName="GetParameterRowChanging" msprop:Generator_RowEvArgName="GetParameterRowChangeEvent" msprop:Generator_RowEvHandlerName="GetParameterRowChangeEventHandler" msprop:Generator_TableClassName="GetParameterDataTable" msprop:Generator_TableVarName="tableGetParameter" msprop:Generator_RowDeletingName="GetParameterRowDeleting" msprop:Generator_TablePropName="GetParameter">
<xs:complexType>
<xs:sequence>
<xs:element name="VALUE" msprop:Generator_UserColumnName="VALUE" msprop:Generator_ColumnPropNameInRow="VALUE" msprop:Generator_ColumnVarNameInTable="columnVALUE" msprop:Generator_ColumnPropNameInTable="VALUEColumn">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>
Any ideas on how to resolve this?
|
|
|
|
|
Did you build a class against it using xsd.exe.
I make XSD files, but I've never used them in any project. I use the xsd.exe and create a class file, and use that file for referencing the XML it represents.
How are you using it?
|
|
|
|
|
I am looking for creation of project templates. Most of our projects are in similar fashion. It includes ASP.Net 4.5 framework, Entity Framework 5.0, Custom Loggging Framework developed by us internally, and then CSS & Script files. What I wanted is that the User should be able to provide the project name like the one which is provided by Visual Studio New Project Templates. Once the user provided the project name, a new project will be created with all the above said dlls, script files, css files etc.
Is there any way which I can develop this custom template. I know that there is something called ASP.Net BoilerPlate. But that is in MVC, and I need in ASP.Net Web Forms.
Any article or URL will be greatly appreciated.
|
|
|
|
|
Visual Studio gives you the option to create your own templates from existing projects.
|
|
|
|
|
Hi All,
I have a requirement to pass a hidden field value in one page to other page on button click and we have few validation on click event. I should not use query string concept and session variable concept. when I implementing with server.transfer I am getting error because my button is in update panel.Is there any alternative method to achieve this requirement?
Thanks In Advance,
Ramakrishna.
|
|
|
|
|
What's wrong with Session or QueryString? You can put something into a cookie or into application cache but session or query string are your best options.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
You can use session if data is not that big or you can use cross page posting like PreviousPage.FindControl
|
|
|
|
|
Hello
I am trying to add style to a aspx (vb) file but I get an error:
http://www.bayingwolf.com/attributes.jpg[^]
That erroneous underlined line is:
messageArea = Attributes.Add("style", "display:block")
and it refers to this label in my aspx file:
<asp:label id="messageArea" CssClass="formattedText" runat="server">style='display:none;'></asp:Label>
What is the correct way of displaying the label, please?
The CssClass is this:
.formattedText
{
font: normal 14px 'Droid Sans' , 'Trebuchet MS' , Arial, sans-serif;
color: #ffffff;
position: absolute;
top: 330px;
border: 1px solid white;
padding: 15px;
}
Thanks for any help.
|
|
|
|
|
Try this:
messageArea.Attributes.Add("style", "display:block")
There is a typo of extra ">" inside;
runat="server">style='display:none;'
|
|
|
|
|
Hello Peter
Many thanks for that. Those errors have gone now.
Previously, if I clicked on the upload button without selected any file, I got this message:
"Your file " & Convert.ToString(uploadControl.PostedFile.FileName) & " can not be uploaded.<br>File types allowed: .doc, .docx, .txt, .png, .gif, .bmp, .jpg, or .jpeg.<br>"
Now, I don't get any message on screen. Likewise, if I select an .asp file which is not, strictly speaking, allowed, no message appears either.
I just wonder if the CSS and/or ASP label:
<<pre>asp:label id="messageArea" CssClass="formattedText" runat="server" style='display:none;'></asp:Label is preventing the message(s) from appearing?
Thanks again.
|
|
|
|
|
I can only say that
style='display:none;'
will cause the "messageArea" label not to be shown.
|
|
|
|
|
I have removed that and I can now see the relevant text when I deliberately commit an error (wrong file type or no file). A step forward, thanks!
The only remaining problem is that when I remove
style='display:none;'
and before I attempt to upload anything, I can see on the screen a small white empty box with nothing in it. That box should really only appear with the error text when I have committed an error.
|
|
|
|
|
It should be this, but I haven't used it on a web form in a while
So I always remove the pervious style first, then add the style change, so I don't just add the same style back, resulting in 2 of the same styles.
With messageArea
.style.remove(HtmlTextWriterStyle.display)
.style.add(HtmlTextWriterStyle.display, "block")
End With
|
|
|
|
|
It is still there that box:
[^]
I have removed what I had in my aspx.vb file, namely:
'messageArea.Attributes.Add("style", "display:block")
and inserted your With | End With here:
Protected AllowedExtensions As String() = {".doc", ".docx", ".txt", ".png", ".gif", ".bmp", ".jpg", ".jpeg"}
Private Property Label As Object
Protected Sub uploadButton_Click(sender As [Object], e As EventArgs)
With messageArea
.Style.Remove(HtmlTextWriterStyle.Display)
.Style.Add(HtmlTextWriterStyle.Display, "block")
End With
Me.messageArea.Text = String.Empty
Try
I don't get any debug errors and I have had a look at a couple of Web examples:
http://msdn.microsoft.com/en-us/library/wc500chb.aspx[^]
so I am not sure why your script isn't working.
|
|
|
|
|
I looked at your message label in a post above, it looks correct to me.
To make the Label appear, it's display: inline-block;
and to make it not appear, it's display: none;
<asp:label runat="server" id="messageArea" CssClass="iForget" style="display: none"></asp:label>
You might just want to keep the label visible and just put something like
"Ready to upload image file" in it, and just change the text value.
Member 8761667 wrote: 'messageArea.Attributes.Add("style", "display:block")
You can do it that way, but you should really use the HtmlTextWriterStyle for that instead, then you can work with multiple styles.
FYI:
The code we are working with will override the CSS style.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
