|
Hi,
How do i calculate the Start_cell_number and end_cell_number from Start_Display_datetime and end_display_datetime calcultion.
here is my code .
TimeSpan timeSpan1 = TimeSpan.Parse("8:00");//5:00 AM Start_dispaly_dateitme
TimeSpan timeSpan2 = TimeSpan.Parse("9:00");// 9:00 AM end_display_datetime
TimeSpan timeSpanDiff = timeSpan2.Subtract(timeSpan1);//hours difference
int mins = timeSpanDiff.Hours * 60 + timeSpanDiff.Minutes;//total minutes
int cells = mins / 15;//count number of cells
Now how i calculate the Start_cell_number and end_cell _number ?
first cell contains name of machines and from second cell i have to calculate .
Any hint is highly apperciated.
Best regards
Rameez
|
|
|
|
|
Hi ,
iam facing difficulty in arranging data from database to table control or
Gridview like this
in first cell of table i want to display Vehicle name and from second table cell i want to display reservations against name of vehicle like this
iam getting Data into dataset .
Channel T1 T2 T3
C1 P1 NA P3
C2 NA P2 NA
Any help or hint?
Best regards
Rameez
|
|
|
|
|
Populate dataset and from there bind your dataset to gridview.i don't know if this will help
Gridview .datasource = dsvihicle
gridview.databind()
Mamphekgo
|
|
|
|
|
hi
m trying to store and retrieve image in sql database.
m having a problem in retrieving it....
all the bytes are not retrieved only first 13 bytes are retrieved..
can anybody help me with his... how can i retrieve all bytes from sql table..????
|
|
|
|
|
Member 3486231 wrote: all the bytes are not retrieved only first 13 bytes are retrieved..
Do you think the, problem is with visual studio or sqlserver? 
What is the data type in sqlserver?
Can you show some code?
EVEN THE WORD IMPOSSIBLE SAYS I M POSSIBLE.
|
|
|
|
|
hi everybody i have looked evrywhere but cant find the solution for this....
i want to display word document stored in sql database and i want to show
that document in browser....please help of point me in right direction
thanks in advance...
appu
|
|
|
|
|
Hi Appu,
I assume you have saved the word doc in the SQL Server as a byte array...
and here is the code..
byte[] byteArray = //Get your byte array - ( file content )and assign it here.
string sFileName = //Get your fileName and assign it here
Response.AppendHeader("Content-Type", "application/msword");
Response.AddHeader("Content-Disposition", "attachment; filename=" + sFileName);
Response.BinaryWrite(byteArray);
Response.End();
Hope it works
Thx,
Gayani
|
|
|
|
|
Hello All,
Have a problem where I would like to display a column only if a particular item is selected in a drop down.
To be more specific, I display some values in a gridview and the last column contains a link that removes (actually just archives by setting a bit flag) the row from being displayed in the "Active" view. If the user wants to see "Archived" rows, they would select it from the DropDownList and the page automatically posts and displays the archived items. But the last column with the link still appears. In this view, the "Remove" link is useless and somewhat unprofessional looking.
What I need help with is NOT showing that column when the SelectedIndex of the DropDown is == 1. If it is == 0 then I want the last column to show as normal.
I have tried "GridView.Columns.RemoveAt" which works the first time but doesn't show again.
So, is there anyway to hide a column on a postback and make if visible again.
Thanks in advance for any suggestions.
|
|
|
|
|
Sorry for the quick posting. I got it to work by:
if (blah blah)
{
GridView1.Column[4].Visible = false
}
else
{
true
}
Thanks anyway gang. Take care
|
|
|
|
|
This may seem like a very basic question but how to I get ASP.NET to authenticate based on the credentials provided in a .config file?
It's just for testing a site and when it's moved to production it will be in an SQL Database but whatever I do it tries to find an SQL database in ~/App_Data to load the authorization information from.
|
|
|
|
|
You probably have a sql-based membership provider configured in your web.config. Something like this:
<system.web>
...
<membership defaultProvider="xxx">
<providers>
<add name="xxx" type="System.Web.Security.SqlMembershipProvider" ... />
</providers>
</membership>
...
</system.web>
You will probably want to change the <membership> configuration to a different provider for your test environment.
|
|
|
|
|
Nope, that's the thing which is annoying me, the web.config is blank from providers but I looked through the assemblies in the Object Browser and couldn't see anything to change it to.
|
|
|
|
|
Hi,
On server side in form code behind class, I have a function
<AjaxPro.AjaxMethod()> _
Public Function test_get() As PROPREGLB.AssetQuerry
Dim v As PROPREGLB.AssetQuerry '
v = New PROPREGLB.AssetQuerry
v.AddNote("ASP.NET")
v.AddNote("2.0")
Return v
End Function
I call this function from my page javascript
function test()
{
var t;
debugger;
var retobj = AssetDataEntry.test_get();
}
when I debug retvalue,
I get retvalue as
__type "PROPREGLB.AssetQuerry, App_Code.hpedrzja, Version=1.0.5.31325, Culture=neutral, PublicKeyToken=null"
How to convert retval as the proper object of PROPREGLB.AssetQuerry
What kind of typecast has to be used.
I need to call methods available in
PROPREGLB.AssetQuerry class from the returned object in javascript also need to avail the existing data(inserted in the server side) in the javascript client side code.
any help will be highly apreciated.
regards
lee
Leya
|
|
|
|
|
Hey Guys
I want to display records from db having multilevel categories
ID, Name, Description, ParentID(ID of parent category).
I found many examples to show categories in heirarchical structure, BUT these are using Stored Procedures! Is there any efficient way to achieve this in C# ???
Thanks in Advance
Work Smart...
|
|
|
|
|
Hi All,
I have System.Xml.XmlDocument xmldc = new System.Xml.XmlDocument(); I am able to load values in to it from XML String.
Now I want to read these values in to DataSet object or DataTable object. But without writing it in to the file. By writing in to the file I can but I dont want to use it.
If you want we can write it in to XMLReader objet, shouldnt write in to the file, which is time consuming.
Any help is very usefull.
Thanks a Lot,
Aleem Mohammad.
S/W Engineer
Akebono Soft Technologies
aleem_abdul@akebonosoft.com.
|
|
|
|
|
Hi guys i having some probs ...,
Plz any one knows help me...,
On each monday one stored procedure have to run automatically...,
How can i do that?
Thanks & Regards,
NeW OnE,
please don't forget to vote on the post
|
|
|
|
|
I suggest you concentrate on one issue at a time.
|
|
|
|
|
leppie wrote: I suggest you concentrate on one issue at a time.
Yes, like hiring a developer. Oh no, how to do that? 
led mike
|
|
|
|
|
New one wrote: How can i do that?
With Sql Agent.
New one wrote: please don't forget to vote on the post
Done. Bad Question. Its in totally the wrong place with little/no relevant information.
|
|
|
|
|
Hi my dataset having multiple datatable...,
In runtime its creating multiple datatables...,
So we cant exactly tell how many datatables its having...,
Now all the datatables i want to write it in, different different excel file how to do that?,
Plz help me
Thanks & Regards,
NeW OnE,
please don't forget to vote on the post
|
|
|
|
|
Hi there
I have a page with a DDL which binds the data in the .aspx page rather than the code behind. It was all working nicely until I moved this page onto another computer - it was working on one with Visual Web Developer Xpress but now it won't work on Visual Studio 2005. I thought maybe it is because the versions of .Net are different. I'm a newbie so please don't patronise!
Here is a snippet of my code:
<body>
<form id="form1" runat="server">
<div>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:angell_eurosalesConnectionStringLocal %>"
SelectCommand="SELECT DISTINCT [BicCode], [Description], [BicCode] + ' : ' + [Description] AS CodeDesc
FROM [tblBicCode] WHERE LEN(LTRIM(BicCode))=1"></asp:SqlDataSource>
</div>
Please someone help me!
Lorna
|
|
|
|
|
Hello all,
I am opening a popup window on a link button click. When popup window opens user filled up the form and click on submit button then a mail goes to client and document get downloaded. Once the mail send and a popbox box shows user and promt him to save or open a document. I want to close the popup window and mail get send to admin. How can i do this.
i have tried following once mail get send
[code]
Page.ClientScript.RegisterStartupScript(GetType(Page), "Confirm", "CloseWindow()")
[/code]
but window isnot getting closed.
Please guide me.
Thanks
Rahul
People Laugh on me Because i am Different but i Laugh on them
Because they all are same.
|
|
|
|
|
btn_close.Attributes.Add("onclick", "window.close(); return false;");
Response.Write ("<script language = javascript>window.opener=self;window.close();</script>");
|
|
|
|
|
hi,
i have tried the code. Window is getting closed as soon as i click on button. But i want to close the window when mail get send to user and prompting user to download or save or cancel the document.
Thanks
People Laugh on me Because i am Different but i Laugh on them
Because they all are same.
|
|
|
|
|
So you want the user to recieve the e-mail, then after they have recieved it you want to provide a prompt or cancel or save the document before they close the window?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
