One click gridview record update

March 31, 2011 - Posted in Access, Applications, ASP.NET - Permalink

Here is how you can update record in a gridview with just a one click.

Code:

<asp:TemplateField HeaderText=”Active”>
<ItemTemplate>
<asp:CheckBox ID=”ActiveCheckBox” runat=”server” Checked='<%# Bind(“Active”) %>’ />
<asp:LinkButton ID=”UpdateButton” runat=”server” CausesValidation=”True” CommandName=”Update” Text=”Update” />
</ItemTemplate>
<HeaderStyle CssClass=”datagrid-th” />
</asp:TemplateField>

Access Data Source

<asp:AccessDataSource ID=”RepoMgt” runat=”server” DataFile=”/my_folder/mydb.mdb”
DeleteCommand=”DELETE FROM [MyCars] WHERE [ID] = ?”
InsertCommand=”INSERT INTO [MyCars] ([Active]) VALUES (?)”
SelectCommand=”SELECT * FROM [MyCars] ORDER BY [Make], [Model]”
UpdateCommand=”UPDATE [MyCars] SET [Active] = ? WHERE [ID] = ?” >

Update Parameters

<UpdateParameters>
<asp:Parameter Name=”Active” Type=”Boolean” />
<asp:Parameter Name=”ID” Type=”Int32″ />
</UpdateParameters>

Microsoft SQL Express Version

March 30, 2011 - Posted in Applications, MS SQL - Permalink

To check MSSQL Version and service pack, create new query, pass below parameters and run the query.


select
serverproperty('ProductVersion') Version, 
serverproperty('Edition') Edition, 
serverproperty('ProductLevel') ProductLevel, 
serverproperty('ComputerNamePhysicalNetBIOS') PhysicalNetBIOS, 
serverproperty('ResourceVersion') ResourceVersion

Simple record query inside gridview

March 30, 2011 - Posted in Access, Applications, ASP.NET - Permalink

Here is simple record query inside the datagrid. I was looking for this solution which does not require code behind.

Access DB structure

Detail.aspx page code:

<form id=“form1” runat=“server”>
<div>
<asp:GridView ID=”GridView1″ runat=”server” AutoGenerateColumns=”False”
DataKeyNames=”ID” DataSourceID=”DetailView” GridLines=”None”>
<Columns>
<asp:TemplateField>
<ItemTemplate>
<table width=”660px” border=”0″ cellpadding=”0″ cellspacing=”0″>
<tr>
<td colspan=”4″>
<a href=”Detail.aspx?cid=<%#Container.DataItem(“ID”)%>&pic=p1″><img src=”images/<%# Container.DataItem(“Pic1″)%>” width=”75px” height=”54px” border=”0″/></a>&nbsp;
<%
Dim vid As String
vid = Request.QueryString( “cid” )
‘/ access db connection – MS Access 2007/10 driver * you can define your own sql connection
Dim ConnDB As New OleDbConnection(“Provider=Microsoft.ACE.OLEDB.12.0;Data Source=” & Server.MapPath(“/my_folder/my.mdb”))
Dim cmd As New OleDbCommand(“SELECT * FROM MyCars WHERE (ID = ” & vid & “);”, ConnDB)
Dim reader As OleDbDataReader

‘/ open connection
cmd.Connection.Open()
reader = cmd.ExecuteReader()
If reader.Read() Then
If (reader(“Pic2”).ToString() <> “np.jpg”) Then
%>
<a href=”Detail.aspx?cid=<%#Container.DataItem(“ID”)%>&pic=p2″><img src=”images/<%# Container.DataItem(“Pic2”)%>” width=”75px” height=”54px” border=”0″/></a>&nbsp;
<%
End If
If (reader(“Pic3”).ToString() <> “np.jpg”) Then
%>
<a href=”Detail.aspx?cid=<%#Container.DataItem(“ID”)%>&pic=p3″><img src=”images/<%# Container.DataItem(“Pic3”)%>” width=”75px” height=”54px” border=”0″/></a>&nbsp;
<%
End If
If (reader(“Pic4”).ToString() <> “np.jpg”) Then
%>
<a href=”Detail.aspx?cid=<%#Container.DataItem(“ID”)%>&pic=p4″><img src=”images/<%# Container.DataItem(“Pic4”)%>” width=”75px” height=”54px” border=”0″/></a>&nbsp;
<%
End If
If (reader(“Pic5”).ToString() <> “np.jpg”) Then
%>
<a href=”Detail.aspx?cid=<%#Container.DataItem(“ID”)%>&pic=p5″><img src=”images/<%# Container.DataItem(“Pic5”)%>” width=”75px” height=”54px” border=”0″/></a>&nbsp;
<%
End If
If (reader(“Pic6”).ToString() <> “np.jpg”) Then
%>
<a href=”Detail.aspx?cid=<%#Container.DataItem(“ID”)%>&pic=p6″><img src=”images/<%# Container.DataItem(“Pic6”)%>” width=”75px” height=”54px” border=”0″/></a>&nbsp;
<%
End If
If (reader(“Pic7”).ToString() <> “np.jpg”) Then
%>
<a href=”Detail.aspx?cid=<%#Container.DataItem(“ID”)%>&pic=p7″><img src=”images/<%# Container.DataItem(“Pic7”)%>” width=”75px” height=”54px” border=”0″/></a>&nbsp;
<%
End If
If (reader(“Pic8”).ToString() <> “np.jpg”) Then
%>
<a href=”Detail.aspx?cid=<%#Container.DataItem(“ID”)%>&pic=p8″><img src=”images/<%# Container.DataItem(“Pic8”)%>” width=”75px” height=”54px” border=”0″/></a>&nbsp;
<%
End If
End If
cmd.Connection.Close()
%>
</td>
</tr>
<tr>
<td><span>Year:</span></td><td><%# Container.DataItem(“vYear”)%></td>
<td><span>Exterior:</span></td><td><%# Container.DataItem(“Exterior”)%></td>
</tr>
<tr>
<td><span>Make:</span></td><td><%# Container.DataItem(“Make”)%></td>
<td><span>Interior:</span></td><td><%# Container.DataItem(“Interior”)%></td>
</tr>
<tr>
<td><span>Model:</span></td><td><%# Container.DataItem(“Model”)%></td>
<td><span>Starting Bid:</span></td><td><%# DataBinder.Eval(Container.DataItem, “sFloor”, “{0:c0}”) %></td>
</tr>
<tr>
<td><span>Mileage:</span></td><td><%# DataBinder.Eval(Container.DataItem, “Mileage”, “{0:#,##0} mi”)%></td>
<td><span>VIN:</span></td><td><%# Container.DataItem(“VIN”)%></td>
</tr>
</table>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<asp:AccessDataSource ID=”DetailView” runat=”server” DataFile=”/my_folder/mydb.mdb”
SelectCommand=”SELECT * FROM [MyCars] WHERE ([ID] = ?)”>
<SelectParameters>
<asp:QueryStringParameter Name=”ID” QueryStringField=”cid” Type=”Int32″ />
</SelectParameters>
</asp:AccessDataSource>
</div>
</form>

« Older Entries
Newer Entries »