I wanted to create the Calendar with data from database.
I have a ItemId in the database with DateFrom and DateTo
ItemID DateFrom DateTo
1 10/01/2010 11/20/2010
2 10/14/2010 12/18/2010
I wanted to show these records in Calender. may be just view Only.
I have a calendar where all the dates from my database are selected/highlighted.I have to use a repeater because else it won't work, but now i want a single calendar where multiple dates are selected, instead of a single calendar for every date in my database.My code:
[Code]....
i have web application it should create single HTML page . that one HTML page should send to the customers.how to create HTML page .i created one page but it retriveing single record from the databse values . my problem is i have to pull all the records from the database and papulate the HTML page. but i am getting only onerecord on that page.my code as follows
string type = ds.Tables[0].Rows[i].ItemArray[4].ToString();
string WAIVN = ds.Tables[0].Rows[i].ItemArray[0].ToString();
string status = "cdcr";
[code]....
but iam not getting all records only single record only iam retriving
I have a gridview in which am binding all the values from database and when am editing the gridview by taking a ajax calendar extender in edititemtemplate its giving me this error.
AspCode
<asp:TemplateField ItemStyle-Width="250px" HeaderText="DeliveryDate">
<ItemTemplate>
<asp:Label ID="lblDeliveryDate" runat="server"
Text='<%# Eval("DeliveryDate")%>'></asp:Label>
[Code] .....
C# Code
protected void OrderDetails_RowUpdating(object sender, GridViewUpdateEventArgs e) {
DateTime del = (Convert.ToDateTime((TextBox)(OrderDetails.Rows[e.RowIndex].FindControl("txtDelDate"))));
}
Error : Unable to cast object of type 'System.Web.UI.WebControls.TextBox' to type 'System.IConvertible'.
how to create the xy table like above? Currently i have able to create to insert row table read from databse which is Worker Name. My problem know is to show column name also read from data and not key in manually. Her's is myb sample codewhich is i have able to show Roa read from database.
[Code]....
We are trying to implement a calendar in an asp.net page and link it a database. The calendar should highlights dates based on data in the database tables similar to airline ticket booking calendar.
View 2 Repliesthere are 5 records in xml and next set of 5 records to be inserted in a same xml using asp.net , but xml is a single file
whether we have to use batch files ?
That works very well with DataGrid, but I want to add a new Column to the DataGrid with the number of the database rows.
The column have to be the first Column of DataGrid.
I want to create a function (with for-loop) to count the number of the row of a DataGrid and write it into DataGrid's first Column.
The number of Rows gets the DataGrid by the SQL-Database.
The SQL Database shouldn't get a new Column. I just want to create the column dynamically.
How could I realize this ?
Here you can see my SourceCode:
[Code]....
Recently i am develop a tuition center management systemNow i want to show a timetable which admin can view and know what time the class room is emptyMy timetable is : On the top of x-axis is time (8am, 9am, ...)On the left of y-axis is date (monday, tuesday, ...)In database i will define the start time and end time for each class
View 6 RepliesI am unable to create dynamic menu from database. I have made two tables for this work.First table is Menu which stores menu id and its relevant name.
MId Text
------------
1 File
2 Edit
3 View
..
..
Second table is subMenu which stores submenus which will be linked to the menu table with menu id.
SId Text MID
-------------------
1 New 1
2 Open 1
3 Save 1
4 Cut 2
5 Copy 2
the menu should be created dynamically from the database, each menu should be displayed in single row
when we click on a menu the submenus are displayed in rows that in expand & contrast form
how to design & develope this page
I have used a microsoft tool before that was allowing me to automatically generate admin web pages from database tables. By admin web pages I mean pages that allow me to do CRUD operations on my tables.
View 1 Repliesi need to retrieve values from the database and provide it as a report to the user.
View 4 RepliesI would like to find out if there is anyone who would know how to read from a database then returns the same number of records that a stored procedure returns and display those records on the webpage there after pass the ID of the record to a variable to another stored procedure that displays the data related to the record that was clicked, I tried doing this in a asp.net repeater but I can't seem to be able to reference the controls inside the repeater.
<Repeater HTML Code>
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="OpenLogs.aspx.cs" Inherits="OpenLogs" EnableEventValidation="false" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
[Code]....
I am using jquery fullcalender..
I want to bind Events to each days of the calender dynamically from the json return by the ajax method..
I want to change calendar date backColor base on data from db, I only have vistual 2003 !
on mean time I have
[Code]....
[Code]....
when I click the day wich have data in db it change color , but I want the page load it change color !
Im having a hard time making ends meet with cenerio.
I have a daily task database that stores the
date, project number, start time, end time and total time
One date could have multiple entries.
I'm trying to link my data to a calender so when I pick a date all the daily tasks are pulled into a gridview.
Also I want the calendar to pull up a blank form where I can input all that info in if the date has no entries.
i have a gridview in each row of gridview row i hve 2 columns. in each row i need a button to enter date, when i click button one calender shld popup and data shld be display at end of the row
View 7 RepliesI need to bind some data to my ASP.Net 3.5 calendar control. The data will be appointments and the fields are appointment datetime and title. The title field should display in the proper day of the month. Also, when a user clicks on a date in the month calendar, they should be redirected to a form to add a new appointment.
View 1 Repliesi want to create an event scheduler which takes the event name and event date from the database and shows it on a calenderview control. i have done the rest of the stuff but i have to click on a data to see an event of the date it is not shown otherwise. can anybody tell how can i show the events that i get from db in calendar control when the page having the calender control is opened?
View 1 RepliesI am trying to set up a server on my own pc to test programs i am making, however i keep running into an issue with Access databases saying that it's not registered on my local machine or something like that. So i was thinking of trying MySql instead, but i cant figure out how to set up a database to run on my pc. I have done it using MySql Workbench before to connect to a database set up on my schools server, but that was an already set up database that they created for each student. I want to know how to set one up on my own pc. how to set this up? I tried the server administration section of MySql Workbench but it seems to ask for an existing database already.
View 1 RepliesI need to export large (more than 50 lakhs) datatable to a .csv file but i dont know how to code. I am creating a windows service ...
View 1 RepliesI'm new to ASP.net 3.5 and trying to create a test site so I can figure out how to use it in the real world. I have created a FormView (Formview1) based on a Client table using Linq Data Sources. The page includes a DropDownList to lookup Clients. I have added a list option (<asp:ListOption value="" Text="(Select Client)" and set AppendDataBoundItems=true so my added option is displayed. I decided to try to use Formview with only the Edit and Insert Modes, and I have set the Default Mode = Insert. When you open the page, a blank Client record is displayed.
The Client record contains serveral lookup fields and they have drop down lists for each. When I select a client from the Client DropDownList, is get the following message 'ddlClientType' has a SelectedValue which is invalid because it does not exist in the list of items I had this problem before and decided the best way to handle this (in the interim) was to turn off foreign key constraints for each of the lookup fields (e.g. ClientType) in SQL Server. That worked for 2-3 days. Now the problem has started again.
When I develop in other applications, I would simply create a lookup data source based on a Union Query with the actual data and a blank record. How can you do this using Linq DataSources. Can you get access and modify the queries?
I have an accessdatasource linked to MS Db query with three fields (date, SR, & CR).I also have an asp.calendar control on my aspx page.I am trying to figure out what OnDayRender code (or any other code) that I would need in order to change the cell color on the calendar based on the value of SR or CR in the query
View 1 RepliesI have a gridview that has 20 columns in it. 3 of them are date fields. I am using templatefields but not edittemplates, only itemtemplates because the users want to update multiple rows and then update the data all at once. I have a panel with an update panel and a calendar on it and in the grid I have a popup extendar added to the textbox in the cell to make the calendar show but I can't get the value from the popup calendar back to the cell. Does anybody have an example or is there a better way to do this?
Here is my templatefield:
[Code]....
This is my panel with the calendar in it:
[Code]....
i have gridview and in gridview i have create the textbox. i want add calendar with textbox in particular row cols of textbox .
View 4 Replies