Re: gridview - ASP.NET Discussion Boards

First Prev Next

Re: Gridview

Baran M26-May-09 0:55

Baran M

26-May-09 0:55

Get something out of it

I need your help

Rahad Rahman26-May-09 0:28

Rahad Rahman

26-May-09 0:28

i want to convert sql data to Text.txt Format , How it Posible?

Re: I need your help

Ramesh Swaminathan26-May-09 0:36

Ramesh Swaminathan

26-May-09 0:36

First, this question is not related to asp.net.

If you want to convert SQL Server data into text format, you can use export/import feature available in the SQL Server Management Studio.

convert format DateTime in dd/MM/yyyy

wertyk25-May-09 23:49

wertyk

25-May-09 23:49

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.

error Must declare the variable '@pname'.

prateekfgiet25-May-09 23:48

prateekfgiet

25-May-09 23:48

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

Re: error Must declare the variable '@pname'.

adatapost26-May-09 1:09

adatapost

26-May-09 1:09

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)

gridview

jainiraj25-May-09 22:44

jainiraj

25-May-09 22:44

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...

Re: gridview

Baran M25-May-09 22:51

Baran M

25-May-09 22:51

In GridView1_RowDataBound(),

try this,

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

Re: gridview

Tuwing.Sabado25-May-09 23:05

Tuwing.Sabado

25-May-09 23:05

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...

Re: gridview

ais0725-May-09 23:46

ais07

25-May-09 23:46

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

editing problem in gridview

prateekfgiet25-May-09 22:37

prateekfgiet

25-May-09 22:37

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>

Re: editing problem in gridview

Baran M25-May-09 23:43

Baran M

25-May-09 23:43

Post you server code also

Security settings for single sign on web site

samerh25-May-09 22:05

samerh

25-May-09 22:05

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

Re: Security settings for single sign on web site

Manas Bhardwaj25-May-09 22:08

Manas Bhardwaj

25-May-09 22:08

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.

Re: Security settings for single sign on web site

samerh25-May-09 22:14

samerh

25-May-09 22:14

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.

ibm language ware

newmember2225-May-09 21:24

newmember22

25-May-09 21:24

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

Re: ibm language ware

Manas Bhardwaj25-May-09 22:07

Manas Bhardwaj

25-May-09 22:07

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.

Re: ibm language ware

newmember2226-May-09 5:15

newmember22

26-May-09 5:15

i need use that with my .net project

Video

Robymon25-May-09 21:22

Robymon

25-May-09 21:22

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.

Re: Video

Eduard Keilholz25-May-09 21:27

Eduard Keilholz

25-May-09 21:27

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

Re: Video

Robymon25-May-09 21:40

Robymon

25-May-09 21:40

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

How to navigate Next,Previous ,Last,First

govindi unal25-May-09 20:38

govindi unal

25-May-09 20:38

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

Re: How to navigate Next,Previous ,Last,First

Baran M25-May-09 21:06

Baran M

25-May-09 21:06

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.

Re: How to navigate Next,Previous ,Last,First

gottimukkala26-May-09 0:57

gottimukkala

26-May-09 0:57

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

.net framework 3.5

vishwjeet25-May-09 20:36

vishwjeet

25-May-09 20:36

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!!

Last Visit: 31-Dec-99 18:00 Last Update: 4-May-24 8:20

Refresh

ᐊ Prev 1...1952 1953 1954 195519561957 1958 1959 1960 1961 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.