Comments by Rajnish D mishra (Top 46 by date)

@Richard thanks for solution it work but one think is i also want EditItemTemplate for DropDownList can u help me

thanx @vimal vataliya u r solution rally help me

yes editText Contain some value which shows on debugging but cmd.ExecuteNonQuery() throws error No-value-given-for-one-or-more-required-parameters

i have this type of error

Thanx Alll And also Praveen k upadhyay i resolve my problem thanx for u giving me good guidance

Order_Id is my Primery key can i remove my order_id from procdure

Please tell me can my proc is wrong



Create proc InsertOrder
@Order_Id int,
@Product_Id int,
@Quantity nvarchar(50),
@Total_Price nvarchar(50)


AS
SET NOCOUNT ON
SET XACT_ABORT ON

BEGIN TRAN
SELECT * FROM dbo.Order_Table WHERE Order_Id = @Order_Id

begin

INSERT INTO dbo.Order_Table
(
Product_Id ,
Quantity ,
Total_Price
)
SELECT
@Product_Id ,
@Quantity ,
@Total_Price

select top 1 Order_Id from dbo.Order_Table order by 1 desc
end

COMMIT

@ryan in my table have data and above insertion is done but in may dataset not contain any row





Create proc InsertOrder
@Order_Id int,
@Product_Id int,
@Quantity nvarchar(50),
@Total_Price nvarchar(50)


AS
SET NOCOUNT ON
SET XACT_ABORT ON

BEGIN TRAN
SELECT * FROM dbo.Order_Table WHERE Order_Id = @Order_Id

begin

INSERT INTO dbo.Order_Table
(
Product_Id ,
Quantity ,
Total_Price
)
SELECT
@Product_Id ,
@Quantity ,
@Total_Price

select top 1 Order_Id from dbo.Order_Table order by 1 desc
end

COMMIT

where i write a comment means int KeyId

afeter u r guidance i taking total_price value in row but it cant happen

@Sinisa my html code

<script type="text/javascript">
$(function () {
$("[id*=txtQuantity]").val("0");
});
$("[id*=txtQuantity]").live("change", function () {
if (isNaN(parseInt($(this).val()))) {
$(this).val('0');
} else {
$(this).val(parseInt($(this).val()).toString());
}
});
$("[id*=txtQuantity]").live("keyup", function () {
if (!jQuery.trim($(this).val()) == '') {
if (!isNaN(parseFloat($(this).val()))) {

var row = $(this).closest("tr");
$("[id*=lblTotal]", row).html(parseFloat($(".price", row).html()) * parseFloat($(this).val()));
}
else {
var row = $(this).closest("tr");
$("[id*=lblTotal]", row).html(parseFloat($(".price", row).html()) * 0);
}
} else {
var row = $(this).closest("tr");
$("[id*=lblTotal]", row).html(parseFloat($(".price", row).html()) * 0);
$(this).val('');
}
var grandTotal = 0;
$("[id*=lblTotal]").each(function () {
grandTotal = grandTotal + parseFloat($(this).html());
});
$("[id*=lblGrandTotal]").html(grandTotal.toString());
});
</script>



<asp:GridView ID="GridView1" class="sorting" role="columnheader" TabIndex="0" aria-controls="example2"
aria-label=": activate to sort column ascending" CssClass="table table-striped dataTable"
aria-describedby="example2_info" runat="server" AutoGenerateColumns="false">
<columns>

<asp:TemplateField HeaderText="Product">
<itemtemplate>
<asp:Label ID="lblProduct" runat="server" Text='<%# Eval("Product_Name") %>'>'>


<asp:TemplateField HeaderText="ProductID" Visible="false">
<itemtemplate>
<asp:Label ID="lblProduct_Id" runat="server" Text='<%# Eval("Product_Id") %>'>'>


<asp:BoundField DataField="Unit_Price" HeaderText="Price" ItemStyle-CssClass="price" />

<asp:TemplateField HeaderText="Quantity">
<itemtemplate>
<asp:TextBox ID="txtQuantity" runat="server" Text='<%# Eval("ProdQuantity") %>'>' >


<asp:TemplateField HeaderText="Total">
<itemtemplate>

<asp:Label ID="lblTotal" runat="server" >






can u help my Total=price * Quantity
total price is calculate through jquery
please help
and thanx for reply

thanx @srikant

thanks @peter leow

obove given out put is genrate by my query and i have want expected out is any way ?

date_grid is inside gridview column

if i Add given_id on that Table so how it Possible please help Karen

R-05/001,R-05/002,R-05/003,R-05/004.........

how i generate month how to attached this month to as like R-04/23

its working fine but disable going again.....

Can we Call multiple JavaScript on ONCLICK ?in single button .if yes so how?

my program run without any error...and emulater(AVD) open but there not have my android appliction like .apk appliction

sorry boss....

thnx

please i have one request from u give me any link for android where i larn

thnx Peter Leow
really i doing more mistake but through ur help i understand clearly u r good programmer....thnx a lot

thnx bro

RadioButton cannot be resolved to a type MainActivity.java/test1/src/com/example/test1 line 27 Java
i correct my misstep
but this error what say how i resolve to type

by using substring i geting two alfhbet of emp_name but i have problam at after how to give sequence for apend name like ga1 ,om2,ra3...etc

thanx bro it raly help full

i want to create table for an employee and it contains 3 columns

id

name

address

where name should contain 3 sub columns like

firstname

middlename

lastname

so how can i will get this one

help me out from this one

thanx frend after struggling i do my work thnx vary much.

thnx frend for giving me ur time..
i have three text box and one button and gridview
i want to disply my value in gridview other then enter value in text box


mean when we enter 1,2,3 in all three text respectively
gridview show 4 to 100 number but not show 1,2,3

i do some try but it not proper

dt = new DataTable();
DataColumn dc1 = new DataColumn("text1");
DataColumn dc2 = new DataColumn("text2");
DataColumn dc3 = new DataColumn("text3");

dt.Columns.Add(dc1);
dt.Columns.Add(dc2);
dt.Columns.Add(dc3);
DataRow dr1 = dt.NewRow();


for (int i = 1; i< 201; i++)
{
dr1[0] = "";
dr1[1] = "";
dr1[2] = "";
Response.Write(i);

}


dt.Rows.Add(dr1) ;
GridView1.DataSource = dt;
GridView1.DataBind();

}

frend i see your code it run secssefull but cant show gridview

[txtbox1] [txtbox2] [txtbox3]
[button]

[ gridview show value other then enter in all 3 text box ]

sorry i disturb u ....i tried my self and i due this.... i am college stud..so i not have more well develop knowledge.

thanx

i got it..

Sampath Lokuge thanks to post .....this article ..

thanx...

how?