mfalac.com

Insert(), Update(), and Delete()

Fri, 04 Dec 2009 11:30:03 GMT Posted by mfalac

Dim productsAdapter As New NorthwindTableAdapters.ProductsTableAdapter()

productsAdapter.Delete(3)

productsAdapter.Update( _
"Chai", 1, 1, "10 boxes x 20 bags", 18.0, 39, 15, 10, False, 1)

productsAdapter.Insert( _
"New Product", 1, 1, "12 tins per carton", 14.95, 15, 0, 10, False)

Printer Friendly Comments (0) Tags: Update | insert | Delete | DAL

Tab Task Bar

Mon, 28 Dec 2009 02:28:43 GMT Posted by mfalac

First, I thought i fixed task bar :( anyway LinQ is not working in live server so i changed source to sql ere is the long boring code stil need to update >>>

<cc1:TabContainer ID="TabContainerTasks" runat="server" ActiveTabIndex="0">

<cc1:TabPanel runat="server" HeaderText="Today" ID="TabPanelToday">

Today

</HeaderTemplate>

<asp:UpdatePanel ID="UpdatePanelTaskListView" runat="server" >

<asp:SqlDataSource ID="SqlDataSourceToday" runat="server" ConflictDetection="CompareAllValues" ConnectionString="<%$ ConnectionStrings:me %>" OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT [Id], [Char], [Position], [TaskName], [TaskDate], [isComplete] FROM [ReorderTaskList] WHERE ([TaskDate] = @TaskDate) ORDER BY [Position]"

UpdateCommand="UPDATE ReorderTaskList SET Position = @Position, TaskName = @TaskName, isComplete = @isComplete, TaskDate = @TaskDate WHERE (Id = @original_Id)">

<asp:ControlParameter ControlID="LabelDateTime" DbType="Date" Name="TaskDate" PropertyName="Text" />

</SelectParameters>

<asp:Parameter Name="position" Type="Int32" />

<asp:Parameter Name="TaskName" />

<asp:Parameter Name="isComplete" />

<asp:Parameter Name="TaskDate" />

<asp:Parameter Name="original_id" Type="Int32" />

</UpdateParameters>

</asp:SqlDataSource>

<cc1:ReorderList ID="reorder" runat="server" AllowReorder="True" DataSourceID="SqlDataSourceToday" DataKeyField="Id" SortOrderField="Position" PostBackOnReorder="True" CallbackCssStyle="DragHandleClass">

</div></DragHandleTemplate>

<cc1:HoverMenuExtender ID="HoverMenuExtenderToday" runat="server" TargetControlID="TaskNameLabel" PopupControlID="PanelToday" OffsetX="-90" OffsetY="20" >

</cc1:HoverMenuExtender>

<%

--panel here --------------%><asp:Panel ID="PanelToday" runat="server" CssClass="popupControl1" >

<asp:UpdatePanel ID="UpdatePanel2" runat="server" UpdateMode="Conditional"><ContentTemplate>

<asp:Label ID="LabelId" Visible="false" runat="server" Text='<%# Eval("Id") %>' />

<asp:DetailsView ID="DetailsViewpop" runat="server" AutoGenerateRows="False" DataKeyNames="Id" DataSourceID="SqlDataSourcePopUp" DefaultMode="Edit" onitemupdated="DetailsViewpop_ItemUpdated" >

<asp:BoundField DataField="Id" HeaderText="Id" InsertVisible="False" ReadOnly="True" SortExpression="Id" Visible="False" />

<asp:BoundField DataField="TaskName" HeaderText="TaskName" SortExpression="TaskName" />

<asp:CheckBoxField DataField="isComplete" HeaderText="isComplete" SortExpression="isComplete" />

<asp:TemplateField HeaderText="TaskDate" SortExpression="TaskDate">

<asp:Calendar ID="Calendar1" Width="100%" Height="100%" SelectedDate='<%# Bind("TaskDate") %>' runat="server" ShowGridLines="True" ShowDayHeader="False" TitleFormat="Month"></asp:Calendar>

</EditItemTemplate>

<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("TaskDate") %>'></asp:TextBox>

</InsertItemTemplate>

<asp:Label ID="Label1" runat="server" Text='<%# Bind("TaskDate") %>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:CommandField ShowEditButton="True" />

</Fields>

</asp:DetailsView> </ContentTemplate>

</asp:UpdatePanel> <asp:SqlDataSource ID="SqlDataSourcePopUp" runat="server" ConnectionString="<%$ ConnectionStrings:me %>" SelectCommand="SELECT Id, TaskName, isComplete, TaskDate FROM ReorderTaskList WHERE (Id = @id)" UpdateCommand="UPDATE ReorderTaskList SET TaskName = @TaskName, isComplete = @isComplete, TaskDate = @TaskDate WHERE (Id = @Id)">

<asp:ControlParameter ControlID="LabelId" Name="id" PropertyName="Text" />

</SelectParameters>

<asp:Parameter Name="TaskName" />

<asp:Parameter Name="isComplete" />

<asp:Parameter Name="TaskDate" />

<asp:Parameter Name="Id" />

</UpdateParameters>

</asp:SqlDataSource> <br />

</asp:Panel>

<asp:Label ID="TaskNameLabel" runat="server" Text='<%# Eval("TaskName") %>' />

</ItemTemplate>

</cc1:ReorderList>

</ContentTemplate>

</asp:UpdatePanel>

</ContentTemplate>

</

<

cc1:TabPanel>cc1:TabPanel ID="TabPanelTomorrow" runat="server" HeaderText="Tomorrow">

<asp:UpdatePanel ID="UpdatePanelEditAndInsert" runat="server" UpdateMode="Conditional">

TODP: tomorrow here

</ContentTemplate>

</asp:UpdatePanel>

</ContentTemplate>

</

cc1:TabPanel>

<cc1:TabPanel ID="TabPanelPast" runat="server" HeaderText="Past">

<asp:UpdatePanel ID="UpdatePanel1" runat="server" UpdateMode="Conditional">

TODO: past here

</ContentTemplate>

</asp:UpdatePanel>

</ContentTemplate>

</

cc1:TabPanel>

<cc1:TabPanel ID="TabPanel1" runat="server" HeaderText="Add">

<ContentTemplate>TODO: Add a delete Task! should delete old month or second quater>????</ContentTemplate>

</

cc1:TabPanel>

</cc1:TabContainer>

Printer Friendly Comments (0) Tags: datepart | Update | Tab Container | PopUpExtender

army

Thu, 10 Jun 2010 03:58:38 GMT Posted by mfalac

now i am ın dogubeyazıt / agrı doıng my army thıngi :) ıf you want to contact me you can fınd me ın face book look mfalac not mehmet fatıh alac :D love you all

Printer Friendly Comments (0) Tags: Neptun | Update

cs.mfalac.com

Insert(), Update(), and Delete()

Tab Task Bar

army

These Articles Listed Under "Update" Tag

Tag Clouds

Category List