editing problem in gridview - ASP.NET Discussion Boards

Hi all!!!
I have a problem wich conversion format DateTime.
I create AjaxCalendar UserControl, an use it in my page, and I have a conversion format DateTime:

<br />
protected void AjaxCalendar_DataBinding(object sender, EventArgs e) {<br />
        try {<br />
            DateTime time = DateTime.Parse(TextDate.Text, new CultureInfo("en-GB"));<br />
        }<br />
        catch (Exception) {<br />
            TextDate.Text = string.Empty;<br />
            return;<br />
        }<br />
}<br />

and asp code of User Control:

<asp:TextBox ID="TextDate" runat="server" Width="70px" />
<Ajax:CalendarExtender ID="AjaxCalendar" runat="server" TargetControlID="TextDate" Format="dd/MM/yyyy" OnLoad="AjaxCalendar_DataBinding"/>

I load from database and add to database datatime from this control. When I use Visual Studio (I use Visual Studio 2008) this conversion work fine, but when i put my project page on IIS or on Server this conversion not work, and i obtain "String.Empty".
If I block this code I obtain data in format MM/dd/yyyy. In Regional Options i have selected format English and stat United Kingdom.
I write implicit conversion in this Mode ...ToString("dd/MM/yyyy") looks fine, but when i wont to add data in database with datetime i obtain error on dateTime.

Help me, PLEASE to create a conversion function or else, for work in IIS, or on Server.

hi i m using asp.net with c# and trying to edit gridview but it's give error
Must declare the variable '@pname'.
my code is
<asp:SqlDataSource ID="SqlDataSource1" Runat="server" ConnectionString="<%$ ConnectionStrings:mcplconnectionstring2 %>"
UpdateCommand="UPDATE [mat_in] SET [pname] = @pname, [qty] = @qty, [sno_to] = @sno_to,[sno_from]=@sno_from WHERE [materialrecipt_no] = @materialrecipt_no"
SelectCommand="SELECT [materialrecipt_no],[pname],[qty],[sno_to],[sno_from] FROM [mat_in]">
<UpdateParameters>
<asp:Parameter Type="string" Name="ProductName"></asp:Parameter>
<asp:Parameter Type="Decimal" Name="Quantity"></asp:Parameter>
<asp:Parameter Type="Decimal" Name="Sr No(Start)"></asp:Parameter>
<asp:Parameter Type="Decimal" Name="Sr No(End)"></asp:Parameter>
</UpdateParameters>
</asp:SqlDataSource>
<asp:GridView ID="GridView1" Runat="server" BorderColor="#3366CC" BorderStyle="None" CellPadding="4" BackColor="White"
BorderWidth="1px" AllowPaging="True" AutoGenerateColumns="False" DataKeyNames="materialrecipt_no" DataSourceID="SqlDataSource1">
<FooterStyle ForeColor="#003399" BackColor="#99CCCC"></FooterStyle>
<PagerStyle ForeColor="#003399" HorizontalAlign="Left" BackColor="#99CCCC"></PagerStyle>
<HeaderStyle ForeColor="#CCCCFF" Font-Bold="True" BackColor="#003399"></HeaderStyle>
<Columns>
<asp:CommandField ShowEditButton="True"></asp:CommandField>
<asp:BoundField ReadOnly="True" HeaderText="materialrecipt no" InsertVisible="False" DataField="materialrecipt_no"
SortExpression="materialrecipt_no"></asp:BoundField>
<asp:TemplateField SortExpression="ProductName" HeaderText="Product"><EditItemTemplate>
<asp:DropDownList ID="editProductName" Runat="server" DataSourceID="SqlDataSource1" DataTextField="pname"
DataValueField="pname" Text='<%# Bind("pname") %>'></asp:DropDownList>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" Runat="server" ErrorMessage="You must provide a Product Name."
ControlToValidate="editProductName">
*</asp:RequiredFieldValidator>
</EditItemTemplate>
<ItemTemplate>
<asp:Label Runat="server" Text='<%# Bind("pname") %>' ID="Label3"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField SortExpression="materialrecipt_no" HeaderText="Sr No"><EditItemTemplate>
<asp:TextBox ID="editUn" Runat="server" Text='<%# Bind("materialrecipt_no") %>' Columns="6">
</asp:TextBox>

</EditItemTemplate>
<ItemStyle HorizontalAlign="Right"></ItemStyle>
<ItemTemplate>
<asp:Label Runat="server" Text='<%# Bind("materialrecipt_no") %>' ID="Label4"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField SortExpression="qty" HeaderText="Quantity"><EditItemTemplate>
<asp:TextBox ID="editUnitPrice" Runat="server" Text='<%# Bind("qty") %>' Columns="6">
</asp:TextBox>

</EditItemTemplate>
<ItemStyle HorizontalAlign="Right"></ItemStyle>
<ItemTemplate>
<asp:Label Runat="server" Text='<%# Bind("qty") %>' ID="Label1"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField SortExpression="srno_to" HeaderText="Sr No(End)"><EditItemTemplate>
<asp:TextBox ID="editUnitsInStock" Runat="server" Text='<%# Bind("sno_to") %>' Columns="4"></asp:TextBox>
<asp:CompareValidator ID="CompareValidator2" Runat="server" ErrorMessage="You must provide a valid integer for Units In Stock."
ControlToValidate="editUnitsInStock" Operator="DataTypeCheck" Type="Integer">
*</asp:CompareValidator>
</EditItemTemplate>
<ItemStyle HorizontalAlign="Right"></ItemStyle>
<ItemTemplate>
<asp:Label Runat="server" Text='<%# Bind("sno_to") %>' ID="Label2"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField SortExpression="srno_from" HeaderText="Sr No(Start)"><EditItemTemplate>
<asp:TextBox ID="editUnitsInsr" Runat="server" Text='<%# Bind("sno_from") %>' Columns="4"></asp:TextBox>
<asp:CompareValidator ID="CompareValidator3" Runat="server" ErrorMessage="You must provide a valid integer for Units In Stock."
ControlToValidate="editUnitsInsr" Operator="DataTypeCheck" Type="Integer">
*</asp:CompareValidator>
</EditItemTemplate>
<ItemStyle HorizontalAlign="Right"></ItemStyle>
<ItemTemplate>
<asp:Label Runat="server" Text='<%# Bind("sno_from") %>' ID="Label3"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<SelectedRowStyle ForeColor="#CCFF99" Font-Bold="True" BackColor="#009999"></SelectedRowStyle>
<RowStyle ForeColor="#003399" BackColor="White"></RowStyle>
</asp:GridView>

pls help me
thanks in advance

Name of parameter should be "pname" not a "ProductName".

<asp:Parameter Type="string" Name="ProductName"></asp:Parameter>

<asp:Parameter Type="string" Name="pname"></asp:Parameter>

A DATAPOST COMPUTER CENTRE
(K.V Prajapati)

I have a gridview with autogeneratecolumn false.I have bind it with a data table dt.In dt there is a column named as "status" whose data type i bit.that means status can take either 0 or1.in gridview this column shows true or false.
I want to show "Read" and "Unread" for 0,1 respectively.
How can I do???
plz..help...

In GridView1_RowDataBound(),

try this,

if (e.Row.Cells[1].Text == "0")
{
e.Row.Cells[1].Text = "Read";
}

Use the GridView RowDataBound Event Delegate to change the value of one cell.

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)<br />
{<br />
    e.Row.Cells[0].Text = e.Row.Cells[0].Text == "0" ? "Unread" : "Read";<br />
}

Happy Coding...

You can also use case in query at time of retrieving data from database :-
For Example:-
case status when '0' then 'Unread' else 'Read' end as status

hiii
i m using asp.net
and facing problem in edit time,when i click on edit button all field are readonly they are not change in textbox(editable mode).
code is

<asp:GridView ID="GridView1" runat="server" BackColor="White" BorderColor="#E7E7FF"
BorderStyle="None" BorderWidth="1px" CellPadding="3"

GridLines="Horizontal" DataKeyNames="materialrecipt_no" PageSize="20"
Style="position: relative" Width="1064px"

AutoGenerateColumns="False" DataSourceID="SqlDataSource1"

OnRowEditing="GridView1_RowEditing" AllowPaging="True">
<FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" />
<RowStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" />
<SelectedRowStyle BackColor="#738A9C" Font-Bold="True"

ForeColor="#F7F7F7" />
<PagerStyle BackColor="#E7E7FF" ForeColor="#4A3C8C"

HorizontalAlign="Right" />
<HeaderStyle BackColor="#4A3C8C" Font-Bold="True"

ForeColor="#F7F7F7" />
<AlternatingRowStyle BackColor="#F7F7F7" />
<Columns>
<asp:CommandField ShowEditButton="True" />
<asp:BoundField DataField="materialrecipt_no"

HeaderText="Sr No" InsertVisible="False"
ReadOnly="True" SortExpression="materialrecipt_no" />
<asp:BoundField DataField="materialrecipt_date"

HeaderText="Entry Date"
SortExpression="materialrecipt_date" />
<asp:BoundField DataField="pname" HeaderText="Product

Name" SortExpression="pname" />
<asp:BoundField DataField="qty" HeaderText="Quantity"

SortExpression="qty" />
<asp:BoundField DataField="enterby" HeaderText="Enter By"

SortExpression="enterby" />
<asp:BoundField DataField="sno_to" HeaderText="Sr

No(End)" SortExpression="sno_to" />
<asp:BoundField DataField="sno_from" HeaderText="Sr

No(Start)" SortExpression="sno_from" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"

ConnectionString="<%$ ConnectionStrings:mcplConnectionString2 %>"
SelectCommand="SELECT * FROM [mat_in] ORDER BY

[materialrecipt_no] DESC"
UpdateCommand="Update [mat_in] set

[pname]=@pname,[qty]=@qty,[enterby]=@enterby,[sno_to]=@sno_to,[sno_from]=@sno_from

where [materialrecipt_no]=@materialrecipt_no"
></asp:SqlDataSource>

Post you server code also

Hi all,
i have deployed a site where a i am reading the username using User.Identity.Name.Remove(0, User.Identity.Name.IndexOf("\") + 1) and then validate this username in active directory. if exist proceed. Locally it is working well however when iam deploying iam disabling anonymous and checking only windows integrated security the first time i input the url a username and password is popping.
What i need is not to pop up this message and directly enter the site if validated.
Any sugesstions, thanks

Apperently, you also have Basic Authentication enabled. You need to disable it. Rose | [Rose]

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Thanks for ur reply.
No iam only enabling windows integrated and the popup msg is only showing the first time i enter the application URL.

Hi,

any body worked on ibm language ware,if worked pls suggest
how to integrate sql server to ibm language ware,it uses derby instead i want to integrate it to sql server..

pavithramukesh

pavithramukesh wrote:
any body worked on ibm language ware,if worked pls suggest

What does it has do with ASP.Net? WTF | :WTF:

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

i need use that with my .net project

Can we show the big size[200 MB] Video in the Web Site?. if it , can we show in the embeded control or is there any other control or easy technic for this.

Ofcourse you can! I don't know the length of the video, visitors of your website have to download the 200 MB of video to view the entire video. If the video is long enough to download the 200 Mb while playing you're fine, else the video will stop playing when the buffer is empty and start buffering the next part of the video. You may consider if this is actually what you want, you're going to use loads of bandwith when your website has a lot of visitors.

For embedding, try silverlight! I even managed to create my own video player with silverlight. If I can do it... You can Wink | ;)

.: I love it when a plan comes together :.
http://www.zonderpunt.nl

This is an around one hour video. what is silverlight, can i get some sample codes or helping links?

Can anybody help me
i am developing an online examination system
i want to display Questions one by one
how i can use move next,move previous,move last,move first

when you design the table, assign a unique number for each question (example: question no.). Say that, you are showing 15th question and the user wants to move to previous.
Now you have to show the 14th question. You can do it easily. Use session if you need.

Hi

When you select the rows from table sorted by some order let's say sorting by name you can ranking for selected rows and then get the rows where between 1 and 14

This sample query may help you:

DECLARE @PageIndex int = 1,
DECLARE @PageSize int = 14

SELECT * FROM
(
-- selecting the rows sorted by name
SELECT Row_NUMBER() OVER (ORDER BY Name DESC) AS Row,
Q.*
FROM Questions_Table Q
)
AS questions
WHERE Row BETWEEN CONVERT(nvarchar(10), ((@PageIndex - 1) * @PageSize + 1)) AND
CONVERT(nvarchar(10),@PageIndex*@PageSize)

Hope that helps

--
http://ashakthi.blogspot.com
http://kids-articles.blogspot.com

Hi, I downloaded .net framework 3.5 setup from microsoft site and installed it on my vista home premium.
But even after successful installation I am not able to see the framework installed anywhere on my system.
I cannot see it even in the programs folder or in the programs menu. I am not able to see the .net command prompt.
Is there anything missing in my installation. Please help!!

the default installation folder of .NET framework is in "[OS Drive]:\WINDOWS\Microsoft.NET\Framework"

regards...

You can also see it in Control Panel->Add Remove Programs.

or type 'Microsoft.Net' in Start->Run. And then open the folder Framework->v3.5.

Alternatively you can use the sample program downloadble from the following link to identify the .NET Framework version in your system.

http://msdn.microsoft.com/en-us/library/ydh6b3yb(VS.85).aspx[^]

Thanks .. I can work now Smile | :)

!!