|
|
I want to assign date from datatable format(01 Jan 2012) to excel element ..my prblm is while assigning to excel it changes to other format (01 01 2013)...plz give me solution to this...
|
|
|
|
|
I had similar problem with storing very long numbers in excel. I solved it by putting a single quote (') in front of the number. This way it was able to display the number properly and could also take this number in account in formulas and computations. Perhaps this trick could work on dates too. try putting '01 Jan 2012 in the excel and see if excel could recognize it as date.
Sadly, I don't have excel on this computer otherwise i would have tried it before posting.
Twenty years from now you will be more disappointed by the things that you didn't do than by the ones you did do. So throw off the bowlines. Sail away from the safe harbor. Catch the trade winds in your sails. Explore, Dream. Discover.
|
|
|
|
|
Hi,
Please enlight me how to insert/update/delete records based on generated textbox/checkbox.
I used the following code to generate the textbox/checkbox:
<asp:Repeater ID="myRepeater" runat="server" >
<HeaderTemplate>
<table >
<thead><tr>
<th>Terminal Tab</th>
<th>Terminal Attributes</th>
<th>Values
</th></tr></thead>
<tbody>
</HeaderTemplate>
<ItemTemplate>
<tr>
<td><%# Eval("TabName") %></td>
<td><%# Eval("TagName") %></td>
<td><%# GenerateTag(Eval("Datatype"))%></td>
</tr>
</ItemTemplate>
<FooterTemplate>
</tbody>
</table>
</FooterTemplate>
</asp:Repeater>
Below is the function of GenerateTag:
protected string GenerateTag(object objDataType)
{
String strTags = "";
switch (objDataType.ToString()) {
case "Char":
strTags = "<input id=tagText type=text />";
break;
case "Int":
strTags = "<input id=tagInt type=text />";
break;
case "Boolean":
strTags = "<input id=cbx type=checkbox />";
break;
default:
strTags = "<input id=strInput type=text />";
break;
}
return strTags;
}
I use the following SQL statement in myRepeater:
string strSQL = @"
Select T.ID
, T.TabID TabID
, Tab.Name TabName
, T.TagName
, T.AppID
, T.DataType
, T.MinLen
, T.MaxLen
, A.Name AppName
, T.Description
From TerminalAttrTag T
Left Join TerminalAttrApp A on T.AppID = A.ID
Left Join TerminalAttrTab Tab on T.TabID = Tab.ID
Where T.AppID = {0} or T.AppID = 1
Order by T.TabID, T.SeqNo
";
strSQL = String.Format(strSQL, AppID);
myRepeater.DataSource = bl.GetDataSet(ConnectionString, strSQL);
myRepeater.DataBind();
In screen, it shows:
Terminal Tab Attributes Values
Host Config Host Name (Textbox)
Host Config Host IP (Textbox)
Host Config Timeout (Textbox)
I can input below info:
Terminal Tab Attributes Values
Host Config Host Name Host Main
Host Config Host IP 172.1.1.1
Host Config Timeout 30
Now I want to be able to click "Add" button to input below record (2nd records).
Terminal Tab Attributes Values
Host Config Host Name Host Backup
Host Config Host IP 172.2.2.2
Host Config Timeout 50
I am thinking to use DetailsView but in the end I give up due to the dynamic generated textbox.
1. Please enlight me how I can add code in 'Add' button to insert records. Or which part of code need to be fixed or rewrite? And please advise the suitable way to handle this.
2. After problem of add/delete/update records solved, please enlight me how to loop through the records. I need to save all records to database or xml files.
Thank you for your patient.
|
|
|
|
|
Hi Guys ,
Whats the best way to implement a live update on an aspx page.Like commentary/score update of a live cricket match ?.Any good thoughts ? Please share
With Warm regards ![Smile | :)](https://www.codeproject.com/script/Forums/Images/smiley_smile.gif)
|
|
|
|
|
Depends on how live you want it to be.
For most applications you can get away with polling the server from the client using javascript in one way or another. Jquery has a neat ajax/[^] method that will take away some of the client side pain. You can use this to get part of a web page.
If you want something a little more live-like you could consider long-polling, where you request the data immediately and the server only responds when the information has changed, or the poll interval "times out". Once the poll is done, the client re-polls immediately and the process repeats.
There is a discussion of the topic here[^]. In the article he talks about a technology called SignalR, which will help you with the long polling stuff.
|
|
|
|
|
The answer will hugely depend on the source of data that is being served. If you have some source of data that you need to put on your webpage after a regular interval then it can be easily done using AJAX . in fact, you can do it using simple ASP.NET updatepanel and timer control only.
Here is a small article that shows how to use the timer to keep the page updating after some interval. IN this demo application, only server time is being shown live to the user after certain time interval. you can simply show your data instead of that.
AJAX for Beginners (Part 1) - Understanding ASP.NET AJAX Server Controls[^]
Twenty years from now you will be more disappointed by the things that you didn't do than by the ones you did do. So throw off the bowlines. Sail away from the safe harbor. Catch the trade winds in your sails. Explore, Dream. Discover.
|
|
|
|
|
Hi,
I have the following code for WoW Slider to populate images in a slide show. I want to know how to make this dynamic and populate it at runtime from database?
<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="member_post_banner.ascx.cs" Inherits="volow.member_post_banner" %>
<%@ Register Assembly="DevExpress.Web.ASPxEditors.v11.1, Version=11.1.4.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" Namespace="DevExpress.Web.ASPxEditors" TagPrefix="dx" %>
<div id="wowslider-container1">
<div class="ws_images"><ul>
<li><img src="../images/members/a54cfa97-04f1-11e2-bd34-00ffceb1d3b5/posts/9eeccaf5-512a-11e2-a96e-00ffceb1d3b5/1c957ee0-52cb-11e2-a96e-00ffceb1d3b5.jpg" alt="Yahoo!" title="Yahoo!" width="906px" height="360px" id="wows1_0"/></li>
<li><img src="../images/members/a54cfa97-04f1-11e2-bd34-00ffceb1d3b5/posts/9eeccaf5-512a-11e2-a96e-00ffceb1d3b5/3c0d94fb-52cb-11e2-a96e-00ffceb1d3b5.jpg" alt="Google" title="Google" width="906px" height="360px" id="wows1_1"/></li>
<li><img src="../images/members/a54cfa97-04f1-11e2-bd34-00ffceb1d3b5/posts/9eeccaf5-512a-11e2-a96e-00ffceb1d3b5/74fac6d2-52cb-11e2-a96e-00ffceb1d3b5.png" alt="Microsoft" title="Microsoft" width="906px" height="360px" id="wows1_2"/></li>
<li><img src="../images/members/a54cfa97-04f1-11e2-bd34-00ffceb1d3b5/posts/9eeccaf5-512a-11e2-a96e-00ffceb1d3b5/91ba430d-52d1-11e2-a96e-00ffceb1d3b5.png" alt="Apple" title="Apple" width="906px" height="360px" id="wows1_3"/></li>
<li><img src="../images/members/a54cfa97-04f1-11e2-bd34-00ffceb1d3b5/posts/9eeccaf5-512a-11e2-a96e-00ffceb1d3b5/99dc0aca-8d86-429e-8d16-ab3ef907536a.png" alt="Blackberry" title="Blackberry" width="906px" height="360px" id="wows1_4"/></li>
<li><img src="../images/members/a54cfa97-04f1-11e2-bd34-00ffceb1d3b5/posts/9eeccaf5-512a-11e2-a96e-00ffceb1d3b5/570e903d-52cb-11e2-a96e-00ffceb1d3b5.png" alt="Samsung" title="Samsung" width="906px" height="360px" id="wows1_5"/></li>
<li><img src="../images/members/a54cfa97-04f1-11e2-bd34-00ffceb1d3b5/posts/9eeccaf5-512a-11e2-a96e-00ffceb1d3b5/a9e6ef60-245d-442a-8016-acee45fa8b98.png" alt="Oracle" title="Oracle" width="906px" height="360px" id="wows1_6"/></li>
<li><img src="../images/members/a54cfa97-04f1-11e2-bd34-00ffceb1d3b5/posts/9eeccaf5-512a-11e2-a96e-00ffceb1d3b5/a6014d5b-fed0-4ca2-a686-0e591b43235e.png" alt="Cisco" title="Cisco" width="906px" height="360px" id="wows1_7"/></li>
<li><img src="../images/members/a54cfa97-04f1-11e2-bd34-00ffceb1d3b5/posts/9eeccaf5-512a-11e2-a96e-00ffceb1d3b5/ac068a56-52ca-11e2-a96e-00ffceb1d3b5.png" alt="Dell" title="Dell" width="906px" height="360px" id="wows1_8"/></li>
<li><img src="../images/members/a54cfa97-04f1-11e2-bd34-00ffceb1d3b5/posts/9eeccaf5-512a-11e2-a96e-00ffceb1d3b5/ae21819f-52d2-11e2-a96e-00ffceb1d3b5.png" alt="Acer" title="Acer" width="906px" height="360px" id="wows1_9"/></li>
<li><img src="../images/members/a54cfa97-04f1-11e2-bd34-00ffceb1d3b5/posts/9eeccaf5-512a-11e2-a96e-00ffceb1d3b5/b5021faa-5380-11e2-a96e-00ffceb1d3b5.png" alt="Cute" title="Cute" width="906px" height="360px" id="wows1_10"/></li>
</ul></div>
<div class="ws_bullets"><div>
<a href="#" title="Yahoo!"><img src="../images/members/a54cfa97-04f1-11e2-bd34-00ffceb1d3b5/posts/9eeccaf5-512a-11e2-a96e-00ffceb1d3b5/1c957ee0-52cb-11e2-a96e-00ffceb1d3b5.jpg" alt="Yahoo!" width="160px" height="100px" />1</a>
<a href="#" title="Google"><img src="../images/members/a54cfa97-04f1-11e2-bd34-00ffceb1d3b5/posts/9eeccaf5-512a-11e2-a96e-00ffceb1d3b5/3c0d94fb-52cb-11e2-a96e-00ffceb1d3b5.jpg" alt="Google" width="160px" height="100px" />2</a>
<a href="#" title="Microsoft"><img src="../images/members/a54cfa97-04f1-11e2-bd34-00ffceb1d3b5/posts/9eeccaf5-512a-11e2-a96e-00ffceb1d3b5/74fac6d2-52cb-11e2-a96e-00ffceb1d3b5.png" alt="Microsoft" width="160px" height="100px" />3</a>
<a href="#" title="Apple"><img src="../images/members/a54cfa97-04f1-11e2-bd34-00ffceb1d3b5/posts/9eeccaf5-512a-11e2-a96e-00ffceb1d3b5/91ba430d-52d1-11e2-a96e-00ffceb1d3b5.png" alt="Apple" width="160px" height="100px" />4</a>
<a href="#" title="Blackberry"><img src="../images/members/a54cfa97-04f1-11e2-bd34-00ffceb1d3b5/posts/9eeccaf5-512a-11e2-a96e-00ffceb1d3b5/99dc0aca-8d86-429e-8d16-ab3ef907536a.png" alt="Blackberry" width="160px" height="100px" />5</a>
<a href="#" title="Samsung"><img src="../images/members/a54cfa97-04f1-11e2-bd34-00ffceb1d3b5/posts/9eeccaf5-512a-11e2-a96e-00ffceb1d3b5/570e903d-52cb-11e2-a96e-00ffceb1d3b5.png" alt="Samsung" width="160px" height="100px" />6</a>
<a href="#" title="Oracle"><img src="../images/members/a54cfa97-04f1-11e2-bd34-00ffceb1d3b5/posts/9eeccaf5-512a-11e2-a96e-00ffceb1d3b5/a9e6ef60-245d-442a-8016-acee45fa8b98.png" alt="Oracle" width="160px" height="100px" />7</a>
<a href="#" title="Cisco"><img src="../images/members/a54cfa97-04f1-11e2-bd34-00ffceb1d3b5/posts/9eeccaf5-512a-11e2-a96e-00ffceb1d3b5/a6014d5b-fed0-4ca2-a686-0e591b43235e.png" alt="Cisco" width="160px" height="100px" />8</a>
<a href="#" title="Dell"><img src="../images/members/a54cfa97-04f1-11e2-bd34-00ffceb1d3b5/posts/9eeccaf5-512a-11e2-a96e-00ffceb1d3b5/ac068a56-52ca-11e2-a96e-00ffceb1d3b5.png" alt="Dell" width="160px" height="100px" />9</a>
<a href="#" title="Acer"><img src="../images/members/a54cfa97-04f1-11e2-bd34-00ffceb1d3b5/posts/9eeccaf5-512a-11e2-a96e-00ffceb1d3b5/ae21819f-52d2-11e2-a96e-00ffceb1d3b5.png" alt="Acer" width="160px" height="100px" />10</a>
<a href="#" title="Cute"><img src="../images/members/a54cfa97-04f1-11e2-bd34-00ffceb1d3b5/posts/9eeccaf5-512a-11e2-a96e-00ffceb1d3b5/b5021faa-5380-11e2-a96e-00ffceb1d3b5.png" alt="Cute" width="160px" height="100px" />11</a>
</div></div>
<a class="wsl" href="http://wowslider.com">jQuery 3d Gallery by WOWSlider.com v2.8</a>
<div class="ws_shadow"></div>
</div>
Technology News @ www.JassimRahma.com
|
|
|
|
|
Hi,
I am looking for a good CMS to use with ASP.NET project..
Do you recommand Umbarco or Joomla or ....?
Technology News @ www.JassimRahma.com
|
|
|
|
|
I have worked extensively with Joomla in the past. I also got some chance to work with Umbraco but that was only for one project. I think, since your project is in ASP.NET you should use Umbraco. This way you can use common nomenclature across your website and this CMS. Also, the knowledge of ASP.NET will come in handy if you need to have some customized behavior.
Twenty years from now you will be more disappointed by the things that you didn't do than by the ones you did do. So throw off the bowlines. Sail away from the safe harbor. Catch the trade winds in your sails. Explore, Dream. Discover.
|
|
|
|
|
I only used Umbraco among free CMS systems, but whenever I would recommend it depends on what do you want to use it for.
If you want it for small personal site, especially for yourself then it is good choice.
If you look for free solution to implement large project for your client, then it is neither free nor easy to customize.
Admin console is way too powerful with options to modify page templates, giving the client easy way to screw up developer's work. Also deployments are hell without paid addons if you have many page types.
--
"My software never has bugs. It just develops random features."
|
|
|
|
|
Is there any javascript slideshow control where i can bind it dynamically from database?
|
|
|
|
|
You would have to create a web service that returns your data in JSON, but not knowing what the data is prevents me from answering the question further.
Is it a image url?
HTML?
|
|
|
|
|
I have to show swf files in that control.
|
|
|
|
|
I'm still not clear on this.
For a SWF, a flash file, you can send parameters to the file in querystring within the flash object html. YouTube does this to show more movie files at the end of movie.
In flash, you have a stage that can pan or slide multiple other stages in the main container, producing a slideshow effect.
I just posted a slideshow tip/trick, you can put flash objects in the child containers and they will pan, but if you have audio in the flash, you will have overlapping audio tracks. The script could be expanded with a ajax call to a web service to get data, and repopulate the child containers with dynamic flash objects, or simply just change the flash movie url.
Display Advertising Filmstrip[^]
|
|
|
|
|
what exactly you would like to do ? can you explain your requirement (if possible).
Thanks
-Amit Gajjar (MinterProject)
|
|
|
|
|
I need slide show control to show swf files, that control i want to bind from database.
E.g
I have few files swf paths saved in my database and i want to bind that swf path files in slideshow control.
|
|
|
|
|
and i hv developed my website in my local system using c# and asp.net i want to upload that site to on registred website on free web hosting site...
|
|
|
|
|
Did you tried Google[^]? I don't know whether you are going to get it free. But if you spend a little then you can get the domain and hosting panel easily.
|
|
|
|
|
Now a days hosting price is very low. if this is for testing purpose then you can get free subdomain hosting very easily or you can purchase your own website in very few $.
godaddy is best with service and price. i am using it.
Thanks
-Amit Gajjar (MinterProject)
|
|
|
|
|
can u give me one registration form include only
-first name
-middle name
-last name
-gender
-date of birth
-address
-country
-state
-city
plz give me program for all above include and make with zip file
|
|
|
|
|
khusali wrote: plz give me program for all above include and make with zip file
This is not a question. What have you tried for this? Nothing? Just Google[^] it first.
|
|
|
|
|
With the help of ORM you can easily develop your desired application.
or you can get code from any opensource asp.net application. but no one will send you zip file. because all are busy with their work
best luck.
Thanks
-Amit Gajjar (MinterProject)
|
|
|
|
|
Firstly, this is not a question.
Secondly, Please don't ask for code here. Try to implement yourself and if you are stuck somewhere we will be more than happy to help. But don't just ask for code or don't expect us to do your work.
Twenty years from now you will be more disappointed by the things that you didn't do than by the ones you did do. So throw off the bowlines. Sail away from the safe harbor. Catch the trade winds in your sails. Explore, Dream. Discover.
|
|
|
|
|
How I cam embed the Slider control with SSRS for gague Chart.
My Question is how i can pass parameter to SSRS gague chart through slider control
|
|
|
|