|
mates,
how to come up with tblTemp using programming not sql.
or any ideas how to get with tblTemp.
tblItem {ORIGINAL TABLE}
CDATE ITEMCODE ITEMVALUE
2008-12-08 1001 4.5
2008-12-08 1002 7.3
2008-12-08 1003 0.5
2009-03-25 1001 1.2
2009-03-25 1002 0.3
2009-03-25 1003 3.4
tblTemp {I WANT THE RESULT LIKE THIS!}
CDATE 1001 1002 1003
2008-12-08 4.5 7.3 0.5
2009-03-25 1.2 0.3 3.4
in access i just use looping
with ds.Fields.count - 1 (where ds is Recordset)
but how will i do it in asp.net using Dataset not Recordset
or something. ( I dont want to use recordset)
C# コードMicrosoft End User
2000-2008
「「「「「「「「「「「「「「「「「「「「「「「「「「「「
The best things in life are free
」」」」」」」」」」」」」」」」」」」」」」」」」」」」
|
|
|
|
|
C#Coudou wrote: any ideas how to get with tblTemp
You could try taking him/her to a movie, maybe dinner... see where it goes from there? 
Seriously, though, I really don't understand your question. Why do you want to do it this way? Why don't you want to use SQL? SQL is infinitely better for querying data - that's what it does.
Please explain further?
|
|
|
|
|
GlobX wrote: Why don't you want to use SQL?
because i want to put in datatable as temptable not in sql, period.
and from datatable to gridview.
the problem is how will put in datatable.that is the question.
C# コードMicrosoft End User
2000-2008
「「「「「「「「「「「「「「「「「「「「「「「「「「「「
The best things in life are free
」」」」」」」」」」」」」」」」」」」」」」」」」」」」
|
|
|
|
|
Sorry, I still don't understand. I will leave this to someone else. Apologies.
|
|
|
|
|
ooppss. sorry. PROBLEM SOLVED. JUST IN TIME.
thanks anyway.
C# コードMicrosoft End User
2000-2008
「「「「「「「「「「「「「「「「「「「「「「「「「「「「
The best things in life are free
」」」」」」」」」」」」」」」」」」」」」」」」」」」」
|
|
|
|
|
C#Coudou wrote: PROBLEM SOLVED. JUST IN TIME.
thanks anyway.
Anyway it's better you close this question by posting the solution which you have find(Also clear the question too). Cheers.
|
|
|
|
|
You can create a datatable entirely in code, add the columns to it, and populate it, then just use it as if you had loaded it from a database.
Are you using C# or VB? I'll post a sample when I know which language you like.
Lisa Z. Morgan
|
|
|
|
|
Hi,
This is called Pivoting of Data.
Please have a look over my article: Pivoting DataTable Simplified[^]
This can get you a flexible and customized result with a clean code.
|
|
|
|
|
Good Evening My friends
I have been helping you , now its your turn to help 
Due to Limitations in the Telerik, meaning that there is no nice Pop Control , and i want to create my own as i did in my previous article. I have used the DevExpress Popup Control and i have a Telerik Gridview inside it and i can nicely search for records and i can select the record from the Grid and i have a button that saves take an ID of that record like
protected void btnselect_Click(object sender, EventArgs e)
{
String Ref =null;
foreach (GridDataItem dataItem in grdactsandbills.MasterTableView.Items)
{
CheckBox chkselect = (CheckBox)dataItem.FindControl("chkselect");
if (chkselect.Checked)
{
Label lblReferenceNumberID = (Label)dataItem.FindControl("lblID");
Ref = lblReferenceNumberID.Text;
}
}
txtreferencenumber.Text = Ref;
}
this Button is in a PopupModal(DevExpress) , when this button is Clicked if assign that value to a textbox that is not part of the modal. and you can see i am doing it on the server side and the break point goes there and the watch shows that yes the value has been assigned to the textbox, but after i close the pop, the Textbox is empty. I am just buffled by this. Below is my markup
<asp:UpdatePanel ID="Update1" runat="server">
<ContentTemplate>
<asp:Panel ID="ModalPanel" runat="server" HorizontalAlign="Center" Style="display: none" BackColor="Green">
<br />
<asp:Label ID="Label7" runat="server"></asp:Label>
<asp:Button ID="btnCancel" runat="server" Text="Close Me" />
</asp:Panel><table class="style1">
<tr>
<td>
<asp:Button ID="btnadd" runat="server" Text="Add" onclick="btnadd_Click"
Height="31px" Width="63px" />
</td>
<td>
<asp:Button ID="btnsearch" runat="server" Text="Search"
onclick="btnsearch_Click" Height="33px" Width="77px"
onclientclick="ShowLoginWindow() ;" />
</td>
</table>
<dx:ASPxPopupControl ID="DevxPopup" runat="server"
PopupHorizontalAlign="WindowCenter" PopupVerticalAlign="WindowCenter"
ClientInstanceName="DevxPopup" ClientIDMode="AutoID"
CssFilePath="~/App_Themes/BlackGlass/{0}/styles.css" CssPostfix="BlackGlass"
SpriteCssFilePath="~/App_Themes/BlackGlass/{0}/sprite.css"
HeaderText=".:::Search:::." Modal="True" AllowDragging="True"
AllowResize="True" AppearAfter="100" CloseAction="CloseButton"
DragElement="Window" Width="100%">
<ContentCollection>
<dx:PopupControlContentControl runat="server">
<asp:Panel ID="Panel" runat="server">
<br />
<table class="style3">
<tr>
<td>
<asp:Label ID="Label6" runat="server" Style="Float:right" Text="Reference Number:"></asp:Label>
</td>
<td class="style4">
<asp:TextBox ID="txtRefNumber" runat="server"></asp:TextBox>
</td>
<td class="style6">
<asp:Button ID="Button2" runat="server" OnClick="btnsearch_Click"
Text="Search" />
</td>
<td>
<asp:Button ID="btnselect" runat="server" Height="27px"
OnClick="btnselect_Click" Text="Pick" Width="73px"
OnClientClick="GetValue();" />
</td>
</tr>
</table>
<br />
</asp:Panel>
<telerik:RadGrid ID="grdactsandbills" runat="server"
AllowFilteringByColumn="True" AllowMultiRowSelection="True" AllowPaging="True"
AllowSorting="True" AutoGenerateColumns="False" GridLines="None"
ShowGroupPanel="True" Skin="Black">
<MasterTableView>
<Columns>
<telerik:GridTemplateColumn>
<ItemTemplate>
<asp:CheckBox ID="chkselect" runat="server"
/>
<asp:Label ID="lblID" runat="server" Text='<%# Eval("FilesID")%>'></asp:Label>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="Subject Title">
<ItemTemplate>
<asp:Label ID="lblSubjectTitleofbilActRef" runat="server"
Text='<%# Eval("Dateentered")%>'></asp:Label>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="Date Received">
<ItemTemplate>
<asp:Label ID="lblDateReceived" runat="server"
Text='<%# Eval("Dateneeded")%>'></asp:Label>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="Ministry ID">
<ItemTemplate>
<asp:Label ID="lblMinistryID" runat="server" Text='<%# Eval("Daysavailablebeforebringup")%>'></asp:Label>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="Date to AG">
<ItemTemplate>
<asp:Label ID="lblDatetoAGr" runat="server" Text='<%# Eval("Reasonsforbringup")%>'></asp:Label>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="Datereceived from AG">
<ItemTemplate>
<asp:Label ID="lblDatereceivedfromAG" runat="server"
Text='<%# Eval("Neededby")%>'></asp:Label>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="Date send M Signature">
<ItemTemplate>
<asp:Label ID="lblReferenceNumber" runat="server"
Text='<%# Eval("ReferenceNumber")%>'></asp:Label>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="Date send CS">
<ItemTemplate>
<asp:Label ID="lblDatesendCSr" runat="server" Text='<%# Eval("Dateentered")%>'></asp:Label>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="Date send HE signature">
<ItemTemplate>
<asp:Label ID="lblDatesendHEsignature" runat="server"
Text='<%# Eval("Enteredby")%>'></asp:Label>
</ItemTemplate>
</telerik:GridTemplateColumn>
</Columns>
<CommandItemSettings ExportToPdfText="Export to Pdf" />
<RowIndicatorColumn>
<HeaderStyle Width="20px" />
</RowIndicatorColumn>
<ExpandCollapseColumn>
<HeaderStyle Width="20px" />
</ExpandCollapseColumn>
</MasterTableView>
<SelectedItemStyle BackColor="#FF9966" />
<ClientSettings AllowDragToGroup="True">
<Selecting AllowRowSelect="True" />
<Scrolling AllowScroll="True" UseStaticHeaders="True" />
<Animation AllowColumnReorderAnimation="True"
AllowColumnRevertAnimation="True" />
</ClientSettings>
</telerik:RadGrid>
</dx:PopupControlContentControl>
</ContentCollection>
</dx:ASPxPopupControl>
</ContentTemplate>
</asp:UpdatePanel>
Thanks
Vuyiswa Maseko,
Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
Hi,
I have a seacrh which returns me a list of objectA.
Can I bind this list to gridview for display or which is the best way to do this .
Thanks
|
|
|
|
|
Yes, you can bind List to gridView for display.
This [^] looks as Bes and easiest way to do same.
You simply need to do:
GridView1.DataSource = myList
GrdiView1.DataBind();
myList can be ArrayList or any other list.
|
|
|
|
|
Good answer, 5.
------------------------------------
I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
CCC Link[ ^]
Trolls[ ^]
|
|
|
|
|
Hi all,
I Have created one User control DLL named WindowsControlLibrary through Windows Form Control Library in C#. Now i want to link that dll file to a asp page so that it can be viewed in the web page. Can anyone please help me how to add that user control in the asp page???
|
|
|
|
|
Hi,
Click here[^] and here[^]
The above approach will do the job for you but in my openion you must consider the following:
1. It will work on in Internet Explorer. No other browser will be able to run this.
2. There might be some functionality which will not work because of security issue.
|
|
|
|
|
Hi All,
We want to generate xml file based on schema file.
Only the xml file is generated we need to populate data by passing objects, because we need to generate so many xml file.
Final output should be a xml file with data.
New to xml,Please help me with this.
Thanks in advance
Ramkumar
("When you build bridges you can keep crossing them. ")
http://ramkumarishere.blogspot.com
|
|
|
|
|
From your schema file (*.xsd), you create classes with the xsd tool (I describe that in my article Bernie’s Trackviewer[^]). Then instantiate the objects from those classes, and finally write ("serialize") them to xml files.
|
|
|
|
|
thanks
Ramkumar
("When you build bridges you can keep crossing them. ")
http://ramkumarishere.blogspot.com
|
|
|
|
|
I understand how to use App_Offline.htm, and most of its caveats, but what I can't seem to find information on is how it deals with executing threads. What I'm concerned about specifically is this. Our company website allows our users to post online payments for their bill with us. Lets say we go to do production maintenance at night, and drop in App_Offline.htm. But we have 3 users submitting payments at that exact moment. I know that App_Offline.htm will block any further responses from coming from ASP.NET, but does it abort the web services calls, or does it allow them to finish, and only then tear down the sessions?
Thanks in advance.
|
|
|
|
|
If the file exists, then ASP.NET shuts down the application and sends the contents of the file back to the user's browser for any new requests to dynamic pages in the application.So in your case the server side code for payment process wont execute, because users are basically locked out of the application.
You can get more resources in
http://www.15seconds.com/issue/061207.htm[^]
Hope this will help.
|
|
|
|
|
Thanks for the reply, Shahriar. But I was referring more to what happens to any active Web Service calls being made. Let me try to explain it a different way. Let's say the payment process takes 30 seconds to return from a 3rd party vendor (they own the Web Service, we're just calling in to it). 10 seconds in to a call, we drop in App_Offline.htm, and shut the site down. Does the payment process Web Service call to our 3rd party vendor complete? Or is it aborted by the shutdown of our application. Either way, I know that the user is still going to see a "Site Offline" message.
Thanks again!
|
|
|
|
|
Hi,
I am very new to Ajax and was trying to use ajax control tab in asp.net.
I downloaded the Ajax toolkit 3.5 and added them in the toolbar. then i use the toolbar as follows in my ascx page.
<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="Default.ascx.cs" Inherits="MyProject.Default" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
<asp:TabContainer ID="MainView" runat="server" ActiveTabIndex="3"
Width="594px">
<asp:TabPanel runat="server" HeaderText="Submission" ID="TabPanel1">
</asp:TabPanel>
<asp:TabPanel ID="TabPanel2" runat="server" HeaderText="Transfers">
</asp:TabPanel>
<asp:TabPanel ID="TabPanel3" runat="server" HeaderText="Errors">
</asp:TabPanel>
<asp:TabPanel ID="TabPanel4" runat="server" HeaderText="Messages">
</asp:TabPanel>
</asp:TabContainer>
when i run it, it gave error like this:
Server Error in '/ICS' Application.
This page is missing a HtmlHead control which is required for the CSS stylesheet link that is being added. Please add <head 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.NotSupportedException: This page is missing a HtmlHead control which is required for the CSS stylesheet link that is being added. Please add <head runat="server" />.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[NotSupportedException: This page is missing a HtmlHead control which is required for the CSS stylesheet link that is being added. Please add <head runat="server" />.]
AjaxControlToolkit.ScriptObjectBuilder.RegisterCssReferences(Control control) +740
AjaxControlToolkit.ScriptControlBase.OnLoad(EventArgs e) +20
System.Web.UI.Control.LoadRecursive() +50
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627
I don't know where shall I get this HtmlHead Control and where to keep this. Can anyone guide me please ?
suchita
|
|
|
|
|
|
ya i did the same thing and it worked.
Thanks
suchita
|
|
|
|
|
Hi,
I have a list of doc files located on a server, I need to open them on a client side in asp .net form.
I don't want the users to be able to enter the directories or the files (security permissions) directly,
\\servername\c$\directory name, so I removed all security permissions, but I still want the users to be able to open
the files from the web site, can you help me?
thanks,
Yefi
modified on Tuesday, February 15, 2011 7:59 AM
|
|
|
|
|
You can receive the filename by a querystring.
string filename = Request.QueryString["filename"];
Then you can validate everything you need and, if the file is a simple textfile, you can open it and write all its contents to the page.
You can even do this with other file formats, but then you must set the document type and maybe need to use a page only to "download" the file.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
