can you pls tell me where i am doing mistake because this code only insert one value at a time

please suggest me to right way to do this
i want to create invoice receipt form

on save button click this code i have written


int lastid;
SqlConnection con = new SqlConnection(strConnString);
SqlCommand cmd = new SqlCommand(strConnString,con);

cmd.CommandText = "sp_insertinvoice";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Clear();


//cmd.Parameters
cmd.Parameters.AddWithValue("@invoice_date", txtDate.Text);
cmd.Parameters.AddWithValue("@Firm_name", txt_frmname.Text.Trim());
cmd.Parameters.AddWithValue("@Regis_id", txt_regno.Text.Trim());
cmd.Parameters.Add("@idcategory", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("@productname", ((TextBox)gridviewproduct.Rows[0].FindControl("grd_txt_productname")).Text);
cmd.Parameters.AddWithValue("@description", ((TextBox)gridviewproduct.Rows[0].FindControl("grd_txt_description")).Text);
cmd.Parameters.AddWithValue("@qty", ((TextBox)gridviewproduct.Rows[0].FindControl("grd_txt_price")).Text);
cmd.Parameters.AddWithValue("@price", ((TextBox)gridviewproduct.Rows[0].FindControl("grd_txt_price")).Text);



con.Open();
cmd.ExecuteNonQuery();
lastid = Convert.ToInt32(cmd.Parameters["@idcategory"].Value.ToString());




and procedure that i have created is this

ALTER PROCEDURE [dbo].[sp_insertinvoice] (
@invoice_date date,
@firm_name varchar,
@Regis_id varchar,
@idcategory int output,
@productname varchar,
@description varchar,
@qty int,
@price int
)
AS
BEGIN
SET NOCOUNT ON;
INSERT INTO tblInvoiceDetails(invoice_date,Firm_Name,Resigtration_no) VALUES
(@invoice_date,@firm_name,@Regis_id)
SET @idcategory=SCOPE_IDENTITY()
insert into tbl_ProductDetails values(@productname,@description,@qty,@price,@idcategory)
RETURN @idcategory
END

sorry sir i didnot get you can you pls tell me in details because i am new for sql.

but sir i want only data for my display
for eg i want all train number from site and this is not possible to take data manually

sry sir but u get me wrong i want to just tell me how to access that data pls dont get it in another way

actually i m fresher now and try to do this if i have not permission to access data

and if they not provide me the permission then is it possible to get data from their site

and also tell me some sample how to do this

yes

this is suitable code for my application in one span but if same fuctionality apply on second span it does not bind data in second span why???/

pls suggest me via code
but in case of window load is not an event of java script

and ur code is work for every span but problem is that if i m click on dropdown twice its contenct is append double time how can i prevent it to append again
i want to append hour in first drop down and minute in second drop down
hour in first is 0 to 23 and minute range is 0 to 59

sir ur code is work well with first span but did not work for second span what can i do
because it is worthless to write fuction again and again for every span

i am changing the text using doropdown list index change

can u please tell me what is client side and what is server

if u give me example of both then i can better understand it

<form id="form1" runat="server">
<header id="header">

CAF-T Home

<div class="HeaderRight">
<div class="Float">
<img src="images/user.png" alt="" />
</div>
<div class="Divi">
</div>
<div class="name">
<asp:Literal ID="litUser" runat="server">
</div>
<div class="Divi">
</div>
<div class="right_icon">
<img src="images/details.png" alt="" />
</div>
</div>
</header>



i have above code in which i have id header "CAF-T" i want to change this

i mean that i want to chek a strin like "abc " with a column value in one time which contain
abc,pqr,and many other string
not in loop

i use window application and after getting column name now i want whole value that is associated with get column

do u run this query in ur pc pls run it first on ur pc then tell me

okkkkk then tell me what keyword we will use in postgres database at the place of the INSTR in mysql

i want to check the table that are present in database or not this query return me boolan value

so i can use this boolean value in if -else control

what happen dear this query is not run at postgres database

it have a error in following line

text += item.Row.Field(0) + ", ";

yes sir i have two checklist box in first checklistbox1 i have some items(like fullname,address etc) in it same for the checklistbox2 i have some item(like f_name,l_name)


now i want a functionality that when i m click on fullname in checklistbox1 it can be split into fname and l_name item in checklistbox2


i hope u understand my question???????

sir i m a fresher now and start to learn .net

dear sir i have checklistbox and have more than one item in that checklistbox
now i want to check(select) more than one item in the checklistbox and provide the some condition on that when i finish checking

any type of format

any body here????

by this link this split the string on the basis of , ;and giving condition but i want to split them according artificial intelligence means automatically haryana goes into state database

sry i did not get u

whole address is in string format for example address is like

Lepton maps,570,udhyog vihar,phase-5,gurgaon,haryana-122016


i want to filter like
company name ---leptonmaps
plot no.-570
locality udhyog vihar
city gurgaon
state haryana
pincode 122016

thnks sir

thanks a lot
i have done it

what is correct form of this sql pls suggest me

pls sir help me

if this have no meaning of double quotes then how i use this string value in following query


dt = obj.GetDataTable("SELECT * from mobilesubscriberdata1 where m_date="+"'n'");


because i have an error when i using this above type pls suggest me for what type of modification required in above query.

what happen sir is there is any solution ;

yes

thnks a lot for help me

no software means sir he have not VS2012 but he have window Os so how can he run my .exe on him machine

yes sir on even OS

suppose we have 5 coloum in datagrid and we have lots of manipulation on column data(like remove space,remove special symbol etc).now i want to revert back only one step that i have made last. how it is possible pls help me

but sir i want revert back only one step ???? how it is possible??

but this application is not web based it is window based application sir

if (e.ColumnIndex == 5 && e.RowIndex != -1)
{
DataGridViewCheckBoxCell chk1 = griddatacleaning.Rows[e.RowIndex].Cells["copyfield"] as DataGridViewCheckBoxCell;
if (chk1.EditedFormattedValue.ToString() == "True")
{
Removedata data = new Removedata();
data.ShowDialog();
string text = data.txtremove;



string fieldname = griddatacleaning.Rows[e.RowIndex].Cells["field_name"].Value.ToString();
for (int a = 0; a < DGrid1.Rows.Count - 1; a++)
{
string val = DGrid1.Rows[a].Cells["new_" + fieldname.ToLower()].Value.ToString();
if (val.Contains(text))
{
DGrid1.Rows[a].Cells["new_" + fieldname.ToLower()].Value = val.Replace(text, string.Empty);
DGrid1.Refresh();

}
}
}
else
{
MessageBox.Show("First Check the Copy Field Column to Edit entire Column");
}

}

ComException was unhandeled


Excel cannot open the file 'cleaning_data.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.

dear sir when i m applying ur code in my project i m getting following error pls provide me the exact solution for this

Excel cannot open the file 'Test Input.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.

pls sir give me the exact solution of my problem

sry sir i can not get it is there are any other way for this

pls eleborate this sir