asp.net webcontrols: Hello,
I have a value from another page called shipkey, I would like to use this
value
to populate the field shipkey in the detailsview for inserting a new record.
how would that be done correctly?

code:

<%@ Page Language="VB" MasterPageFile="~/Site.master"
AutoEventWireup="false" CodeFile="AddPackage.aspx.vb"
Inherits="Shipping_PreparePackage_AddPackage" title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1"
Runat="Server">
<br />
<asp:DetailsView ID="DetailsView1" runat="server"
AutoGenerateRows="False" DataKeyNames="CartonKey,ShipKey"
DataSourceID="SqlDataSource1" DefaultMode="Insert" Height="50px"
Width="125px">
<Fields>
<asp:BoundField DataField="CartonKey" HeaderText="CartonKey"
SortExpression="CartonKey" InsertVisible="False" />
<asp:BoundField DataField="ShipKey" HeaderText="ShipKey"
SortExpression="ShipKey" InsertVisible="False" NullDisplayText='' />
<asp:BoundField DataField="PackageID" HeaderText="PackageID"
SortExpression="PackageID" />
<asp:BoundField DataField="Length" HeaderText="Length"
SortExpression="Length" />
<asp:BoundField DataField="width" HeaderText="width"
SortExpression="width" />
<asp:CheckBoxField DataField="Breakable" HeaderText="Breakable"
SortExpression="Breakable" />
<asp:BoundField DataField="TrackingNumber"
HeaderText="TrackingNumber" SortExpression="TrackingNumber" />
<asp:BoundField DataField="Weight" HeaderText="Weight"
SortExpression="Weight" />
<asp:BoundField DataField="OverSize12" HeaderText="OverSize12"
SortExpression="OverSize12" />
<asp:BoundField DataField="height" HeaderText="height"
SortExpression="height" />
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True"
ShowInsertButton="True" />
</Fields>
</asp:DetailsView>
<br />
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$
ConnectionStrings:SilverQueen_Main_SystemConnectionString1 %>"
DeleteCommand="DELETE FROM [ShipCartonRecord] WHERE [CartonKey] =
@CartonKey AND [ShipKey] = @ShipKey"
InsertCommand="INSERT INTO [ShipCartonRecord] ([ShipKey],
[PackageID], [Length], [width], [Breakable], [TrackingNumber], [Weight],
[OverSize12], [height]) VALUES (@ShipKey, @PackageID, @Length, @width,
@Breakable, @TrackingNumber, @Weight, @OverSize12, @height)"
SelectCommand="SELECT [CartonKey], [ShipKey], [PackageID], [Length],
[width], [Breakable], [TrackingNumber], [Weight], [OverSize12], [height] FROM
[ShipCartonRecord] WHERE ([ShipKey] = @ShipKey)"
UpdateCommand="UPDATE [ShipCartonRecord] SET [PackageID] =
@PackageID, [Length] = @Length, [width] = @width, [Breakable] = @Breakable,
[TrackingNumber] = @TrackingNumber, [Weight] = @Weight, [OverSize12] =
@OverSize12, [height] = @height WHERE [CartonKey] = @CartonKey AND [ShipKey]
= @ShipKey">
<DeleteParameters>
<asp:Parameter Name="CartonKey" Type="Object" />
<asp:Parameter Name="ShipKey" Type="Object" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="PackageID" Type="String" />
<asp:Parameter Name="Length" Type="Int16" />
<asp:Parameter Name="width" Type="Int16" />
<asp:Parameter Name="Breakable" Type="Boolean" />
<asp:Parameter Name="TrackingNumber" Type="String" />
<asp:Parameter Name="Weight" Type="String" />
<asp:Parameter Name="OverSize12" Type="String" />
<asp:Parameter Name="height" Type="Int16" />
<asp:Parameter Name="CartonKey" Type="Object" />
<asp:Parameter Name="ShipKey" Type="Object" />
</UpdateParameters>
<SelectParameters>
<asp:QueryStringParameter Name="ShipKey"
QueryStringField="ShipKey" Type="Object" />
</SelectParameters>
<InsertParameters>
<asp:Parameter Name="CartonKey" Type="Object" />
<asp:Parameter Name="ShipKey" Type="Object" />
<asp:Parameter Name="PackageID" Type="String" />
<asp:Parameter Name="Length" Type="Int16" />
<asp:Parameter Name="width" Type="Int16" />
<asp:Parameter Name="Breakable" Type="Boolean" />
<asp:Parameter Name="TrackingNumber" Type="String" />
<asp:Parameter Name="Weight" Type="String" />
<asp:Parameter Name="OverSize12" Type="String" />
<asp:Parameter Name="height" Type="Int16" />
</InsertParameters>
</asp:SqlDataSource>
</asp:Content>

Hi Tdar,

As for the question about populate field of input control in DetailsView
(insertMode), I think we need to manually access the control collection and
find the control reference and assign the certain value(initial value). Is
the value passed from other page in the url querystring?

Anyway, since BoundField's insert textbox control is autogenerated, it'll
be hard for us to locate it through ID or index. IMO, we can convert that
field(column) into a template column so that we can use FindControl to
locate the control through the control ID. e.g:

the following page template use a DetailsView with one template
field(converted from bound field) for one column that need to set initial
value from querystring:

============================================
<div>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
DeleteCommand="DELETE FROM [Categories] WHERE [CategoryID] =
@CategoryID" InsertCommand="INSERT INTO [Categories] ([CategoryName],
[Description]) VALUES (@CategoryName, @Description)"
SelectCommand="SELECT [CategoryID], [CategoryName],
[Description] FROM [Categories]"
UpdateCommand="UPDATE [Categories] SET [CategoryName] =
@CategoryName, [Description] = @Description WHERE [CategoryID] =
@CategoryID">
<DeleteParameters>
<asp:Parameter Name="CategoryID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="CategoryName" Type="String" />
<asp:Parameter Name="Description" Type="String" />
<asp:Parameter Name="CategoryID" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="CategoryName" Type="String" />
<asp:Parameter Name="Description" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
<asp:DetailsView ID="DetailsView1" runat="server"
AllowPaging="True" AutoGenerateRows="False"
DataKeyNames="CategoryID" DataSourceID="SqlDataSource1"
DefaultMode="Insert"
Height="50px" Width="125px">
<Fields>
<asp:BoundField DataField="CategoryID"
HeaderText="CategoryID" InsertVisible="False"
ReadOnly="True" SortExpression="CategoryID" />
<asp:TemplateField HeaderText="CategoryName"
SortExpression="CategoryName">
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%#
Bind("CategoryName") %>'></asp:TextBox>
</EditItemTemplate>
<InsertItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%#
Bind("CategoryName") %>'></asp:TextBox>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%#
Bind("CategoryName") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="Description"
HeaderText="Description" SortExpression="Description" />
<asp:CommandField ShowEditButton="True"
ShowInsertButton="True" />
</Fields>
</asp:DetailsView>
================================

and below is the code in page_load where we get the value from url
querystring and set it to the input field in detailsview's insert template.

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string initVal = Request.QueryString["category"];
if (!string.IsNullOrEmpty(initVal))
{

((TextBox)DetailsView1.FindControl("TextBox1")).Text =
initVal ;
}
}
}


Hope this helps.

Regards,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

That worked thanks but I am getting that stupid "Disallowed implicit
conversion from data type sql_variant to data type uniqueidentifier, table
'SilverQueen_Main_System.dbo.ShipCartonRecord', column 'ShipKey'. Use the
CONVERT function to run this query. "

again ugh I checked the readonly field properties and the description that
said guid in that other problem we had before. I also created a new page and
tested the passed querystring a GUID to a test table(Ui data field in that
table) and it worked fine with the code you provided here.
So i know the data that I am putting into that field is correct and the
changes you described in this tread work, but then i get this error, ugh. Oh
cartonkey is the
Key field in the table.


addpackage.aspx
==========


<%@ Page Language="VB" MasterPageFile="~/Site.master"
AutoEventWireup="false" CodeFile="AddPackage.aspx.vb"
Inherits="Shipping_PreparePackage_AddPackage" title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1"
Runat="Server">
<asp:DetailsView ID="DetailsView1" runat="server"
AutoGenerateRows="False" DataKeyNames="CartonKey,ShipKey"
DataSourceID="SqlDataSource1" DefaultMode="Insert" Height="50px"
Width="125px">
<Fields>
<asp:BoundField DataField="CartonKey" HeaderText="CartonKey"
SortExpression="CartonKey" InsertVisible="False" />
<asp:TemplateField HeaderText="ShipKey" SortExpression="ShipKey">
<EditItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%#
Eval("ShipKey") %>'></asp:Label>
</EditItemTemplate>
<InsertItemTemplate>
<asp:TextBox ID="ShipKeyTxt" runat="server" Text='<%#
Bind("ShipKey") %>'></asp:TextBox>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%#
Bind("ShipKey") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="PackageID" HeaderText="PackageID"
SortExpression="PackageID" />
<asp:BoundField DataField="Length" HeaderText="Length"
SortExpression="Length" />
<asp:BoundField DataField="width" HeaderText="width"
SortExpression="width" />
<asp:BoundField DataField="OverSize12" HeaderText="OverSize12"
SortExpression="OverSize12" />
<asp:BoundField DataField="height" HeaderText="height"
SortExpression="height" />
<asp:BoundField DataField="TrackingNumber"
HeaderText="TrackingNumber" SortExpression="TrackingNumber" />
<asp:BoundField DataField="Weight" HeaderText="Weight"
SortExpression="Weight" />
<asp:CheckBoxField DataField="Breakable" HeaderText="Breakable"
SortExpression="Breakable" />
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True"
ShowInsertButton="True" />
</Fields>
</asp:DetailsView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$
ConnectionStrings:SilverQueen_Main_SystemConnectionString1 %>"
DeleteCommand="DELETE FROM [ShipCartonRecord] WHERE [CartonKey] =
@CartonKey AND [ShipKey] = @ShipKey"
InsertCommand="INSERT INTO [ShipCartonRecord] ([ShipKey],
[PackageID], [Length], [width], [OverSize12], [height], [TrackingNumber],
[Weight], [Breakable]) VALUES (@ShipKey, @PackageID, @Length, @width,
@OverSize12, @height, @TrackingNumber, @Weight, @Breakable)"
SelectCommand="SELECT [CartonKey], [ShipKey], [PackageID], [Length],
[width], [OverSize12], [height], [TrackingNumber], [Weight], [Breakable] FROM
[ShipCartonRecord] WHERE ([ShipKey] = @ShipKey)"
UpdateCommand="UPDATE [ShipCartonRecord] SET [PackageID] =
@PackageID, [Length] = @Length, [width] = @width, [OverSize12] = @OverSize12,
[height] = @height, [TrackingNumber] = @TrackingNumber, [Weight] = @Weight,
[Breakable] = @Breakable WHERE [CartonKey] = @CartonKey AND [ShipKey] =
@ShipKey">
<DeleteParameters>
<asp:Parameter Name="CartonKey" Type="Object" />
<asp:Parameter Name="ShipKey" Type="Object" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="PackageID" Type="String" />
<asp:Parameter Name="Length" Type="Int16" />
<asp:Parameter Name="width" Type="Int16" />
<asp:Parameter Name="OverSize12" Type="String" />
<asp:Parameter Name="height" Type="Int16" />
<asp:Parameter Name="TrackingNumber" Type="String" />
<asp:Parameter Name="Weight" Type="String" />
<asp:Parameter Name="Breakable" Type="Boolean" />
<asp:Parameter Name="CartonKey" Type="Object" />
<asp:Parameter Name="ShipKey" Type="Object" />
</UpdateParameters>
<SelectParameters>
<asp:QueryStringParameter DefaultValue="-1" Name="ShipKey"
QueryStringField="ShipKey"
Type="Object" />
</SelectParameters>
<InsertParameters>
<asp:Parameter Name="ShipKey" Type="Object" />
<asp:Parameter Name="PackageID" Type="String" />
<asp:Parameter Name="Length" Type="Int16" />
<asp:Parameter Name="width" Type="Int16" />
<asp:Parameter Name="OverSize12" Type="String" />
<asp:Parameter Name="height" Type="Int16" />
<asp:Parameter Name="TrackingNumber" Type="String" />
<asp:Parameter Name="Weight" Type="String" />
<asp:Parameter Name="Breakable" Type="Boolean" />
</InsertParameters>
</asp:SqlDataSource>

</asp:Content>

Hi Tdar,

Thanks for your response.
So your current problem turn to be type converting for guid type? To make
the problem simlified and specific, can you try creating a simple datatable
,with just 2 or 3 columns(and the guild column as the PK) and test it in
the page to reproduce the problem? That's can help us concencrate on the
concrete problem.

Regards,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Ok, but this is a second guid in the table not the guid that is pk..
PackageKey GUID <-- this is pk field
ShipKey GUID <-- this is second field and give me the problem.

If you want I can /well try to reporduce this in a small table/form.

But....

.. Stepping back maybe I should not be using guid.. If I intend to
replicate the database I though i needed guid, so i use using that instead of
a stepping int.. as a pk. I guess I dont know really where guid should be
used verses a stepping intergers.

If i get rid of the guid I guess I eliminate this problem I keep running
into, but I thought I saw something where you need to use guid if you are
going to replicate
your sql data. I have not had a chance to watch "A PRIMER TO PROPER SQL
SERVER DEVELOPMENT "



[quoted text, click to view]