string StrQuery;
try
{
using (SqlConnection conn = new SqlConnection(ConnString))
{
using (SqlCommand comm = new SqlCommand())
{
comm.Connection = conn;
conn.Open();
for(int i=0; i< dataGridView1.Rows.Count;i++)
{
StrQuery= @"INSERT INTO tableName VALUES ("
+ dataGridView1.Rows[i].Cells["ColumnName"].Value +", "
+ dataGridView1.Rows[i].Cells["ColumnName"].Value +");";
comm.CommandText = StrQuery;
comm.ExecuteNonQuery();
}
}
}
i written the code like this.but i got error,use of un assigned local variable 'StrQuery'
Loading
VulpesPosted Sep 30, 2013, 11:15 AM
string StrQuery = null;
ClsConnect.conSql.Close();
}
Maneesh A NPosted Sep 30, 2013, 6:28 AM
private void fnInvoiceItemSave(int InvId)
{
string returnValue = "";
int RowCount = dgvSales.Rows.Count;
try
{
for (int i = 0; i < RowCount; i++)
{
G_Tea = Convert.ToInt32(G_iItemID).ToString();
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = new SqlCommand("prctblSalesInvoiceItemInsert", ClsConnect.conSql);
sda.SelectCommand.CommandType = CommandType.StoredProcedure;
int inSalesItemId = 0;
int G_ID = 0;
G_iItemID = G_ID;
//if (G_ID == '1')
//{
// sda.SelectCommand.Parameters.AddWithValue("@vTea", G_iItemID);
//}
//else if (Convert.ToString(dgvSales.Rows[i].Cells["SalesItemID"].Value) == "")
//{
// inSalesItemId = 0;
//}
//else
//{
// inSalesItemId = Convert.ToInt32(dgvSales.Rows[i].Cells["SalesItemID"].Value);
//}
sda.SelectCommand.Parameters.AddWithValue("@iSalesItemID", inSalesItemId);
sda.SelectCommand.Parameters.AddWithValue("@iSalesID", InvId);
//sda.SelectCommand.Parameters.AddWithValue("@iItemID", Convert.ToInt32(dgvSales.Rows[i].Cells["ItemID"].Value.ToString()));
sda.SelectCommand.Parameters.AddWithValue("@vItemCode", Convert.ToInt32(dgvSales.Rows[i].Cells["ItemCode"].Value.ToString()));
if (G_Tea == "10")
{
sda.SelectCommand.Parameters.AddWithValue("@vTea", G_Tea);
sda.SelectCommand.Parameters.AddWithValue("@vCoffee", 0);
sda.SelectCommand.Parameters.AddWithValue("@vMineral", 0);
sda.SelectCommand.Parameters.AddWithValue("@vPhotoCopy", 0);
sda.SelectCommand.Parameters.AddWithValue("@vFax", 0);
sda.SelectCommand.Parameters.AddWithValue("@vGeneratorCharge", 0);
sda.SelectCommand.Parameters.AddWithValue("@vMiscallaneous", 0);
}
else if (G_Tea == "11")
{
sda.SelectCommand.Parameters.AddWithValue("@vTea", 0);
sda.SelectCommand.Parameters.AddWithValue("@vCoffee", G_Tea);
sda.SelectCommand.Parameters.AddWithValue("@vMineral", 0);
sda.SelectCommand.Parameters.AddWithValue("@vPhotoCopy", 0);
sda.SelectCommand.Parameters.AddWithValue("@vFax", 0);
sda.SelectCommand.Parameters.AddWithValue("@vGeneratorCharge", 0);
sda.SelectCommand.Parameters.AddWithValue("@vMiscallaneous", 0);
}
else if (G_Tea == "12")
{
sda.SelectCommand.Parameters.AddWithValue("@vTea", 0);
sda.SelectCommand.Parameters.AddWithValue("@vCoffee", 0);
sda.SelectCommand.Parameters.AddWithValue("@vMineral", G_Tea);
sda.SelectCommand.Parameters.AddWithValue("@vPhotoCopy", 0);
sda.SelectCommand.Parameters.AddWithValue("@vFax", 0);
sda.SelectCommand.Parameters.AddWithValue("@vGeneratorCharge", 0);
sda.SelectCommand.Parameters.AddWithValue("@vMiscallaneous", 0);
}
else if (G_Tea == "13")
{
sda.SelectCommand.Parameters.AddWithValue("@vTea", 0);
sda.SelectCommand.Parameters.AddWithValue("@vCoffee", 0);
sda.SelectCommand.Parameters.AddWithValue("@vMineral", 0);
sda.SelectCommand.Parameters.AddWithValue("@vPhotoCopy", G_Tea);
sda.SelectCommand.Parameters.AddWithValue("@vFax", 0);
sda.SelectCommand.Parameters.AddWithValue("@vGeneratorCharge", 0);
sda.SelectCommand.Parameters.AddWithValue("@vMiscallaneous", 0);
}
else if (G_Tea == "14")
{
sda.SelectCommand.Parameters.AddWithValue("@vTea", 0);
sda.SelectCommand.Parameters.AddWithValue("@vCoffee", 0);
sda.SelectCommand.Parameters.AddWithValue("@vMineral", 0);
sda.SelectCommand.Parameters.AddWithValue("@vPhotoCopy", 0);
sda.SelectCommand.Parameters.AddWithValue("@vFax", G_Tea);
sda.SelectCommand.Parameters.AddWithValue("@vGeneratorCharge", 0);
sda.SelectCommand.Parameters.AddWithValue("@vMiscallaneous", 0);
}
else if (G_Tea == "15")
{
sda.SelectCommand.Parameters.AddWithValue("@vTea", 0);
sda.SelectCommand.Parameters.AddWithValue("@vCoffee", 0);
sda.SelectCommand.Parameters.AddWithValue("@vMineral", 0);
sda.SelectCommand.Parameters.AddWithValue("@vPhotoCopy", 0);
sda.SelectCommand.Parameters.AddWithValue("@vFax", 0);
sda.SelectCommand.Parameters.AddWithValue("@vGeneratorCharge", G_Tea);
sda.SelectCommand.Parameters.AddWithValue("@vMiscallaneous", 0);
}
else if (G_Tea == "16")
{
sda.SelectCommand.Parameters.AddWithValue("@vTea", 0);
sda.SelectCommand.Parameters.AddWithValue("@vCoffee", 0);
sda.SelectCommand.Parameters.AddWithValue("@vMineral", 0);
sda.SelectCommand.Parameters.AddWithValue("@vPhotoCopy", 0);
sda.SelectCommand.Parameters.AddWithValue("@vFax", 0);
sda.SelectCommand.Parameters.AddWithValue("@vGeneratorCharge", 0);
sda.SelectCommand.Parameters.AddWithValue("@vMiscallaneous", G_Tea);
}
sda.SelectCommand.Parameters.AddWithValue("@iItemID", G_Tea);
sda.SelectCommand.Parameters.AddWithValue("@iNos", dgvSales.Rows[i].Cells["Nos"].Value.ToString());
sda.SelectCommand.Parameters.AddWithValue("@deRate", Convert.ToDecimal(dgvSales.Rows[i].Cells["Rate"].Value.ToString()));
sda.SelectCommand.Parameters.AddWithValue("@deAmount", Convert.ToDecimal(dgvSales.Rows[i].Cells["Amount"].Value.ToString()));
string s = ClsConnect.conSql.State.ToString();
if (s == "Open")
{
ClsConnect.conSql.Close();
}
ClsConnect.conSql.Open();
//string StrQuery = null;
//// try
//{
// using (SqlConnection conn = new SqlConnection())
// {
// using (SqlCommand comm = new SqlCommand())
// {
// comm.Connection = conn;
// //conn.Open();
// for (int j = 0; j < dgvSales.Rows.Count; j++)
// {
// returnValue = @"INSERT INTO tblSalesItem VALUES (" + dgvSales.Rows[j].Cells["ItemName"].Value + ", " + dgvSales.Rows[j].Cells["ItemName"].Value + ");";
// comm.CommandText = StrQuery;
// //comm.ExecuteNonQuery();
// string s = ClsConnect.conSql.State.ToString();
// if (s == "Open")
// {
// ClsConnect.conSql.Close();
// }
// ClsConnect.conSql.Open();
// }
// }
// }
//}
}
}
catch (Exception ex)
{
returnValue = ex.Message;
}
}
******************************************************************************************************************************************************************************
private string fnInvoiceSaveUpdate(int Block)
{
string ReturnValue = "";
try
{
G_Tea = Convert.ToInt32(G_iItemID).ToString();
//G_GeneratorCharge = Convert.ToInt32(G_iItemID).ToString();
//G_Miscallaneous = Convert.ToInt32(G_iItemID).ToString();
DateTime InvDate = dtInvoiceDate.Value;
string CustName = txtCustName.Text;
decimal AmountTotal = objCfun.isNumatic(txtAmTotal.Text);
{
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = new SqlCommand("prctblSalesInvoiceInsertUpdate", ClsConnect.conSql);
sda.SelectCommand.CommandType = CommandType.StoredProcedure;
sda.SelectCommand.Parameters.AddWithValue("@iSalesID", G_InvID);
sda.SelectCommand.Parameters.AddWithValue("iItemID", G_iItemID);
sda.SelectCommand.Parameters.AddWithValue("@iAccID", G_iAccountID);
sda.SelectCommand.Parameters.AddWithValue("@vAccName", CustName);
sda.SelectCommand.Parameters.AddWithValue("@dInvoiceDate", InvDate.ToString("MM/dd/yyyy"));
sda.SelectCommand.Parameters.AddWithValue("@iSerialNo", txtSerialNo.Text);
sda.SelectCommand.Parameters.AddWithValue("@deTotAmount", AmountTotal);
//if (G_Tea == "10")
//{
// sda.SelectCommand.Parameters.AddWithValue("@vTea", G_iItemID);
// sda.SelectCommand.Parameters.AddWithValue("@vCofee", 0);
// sda.SelectCommand.Parameters.AddWithValue("@vMineral", 0);
// sda.SelectCommand.Parameters.AddWithValue("@vPhotoCopy", 0);
// sda.SelectCommand.Parameters.AddWithValue("@vFax", 0);
// sda.SelectCommand.Parameters.AddWithValue("@vGeneratorCharge", 0);
// sda.SelectCommand.Parameters.AddWithValue("@vMiscallaneous", 0);
//}
//else if (G_Tea == "11")
//{
// sda.SelectCommand.Parameters.AddWithValue("@vTea", 0);
// sda.SelectCommand.Parameters.AddWithValue("@vCofee", G_iItemID);
// sda.SelectCommand.Parameters.AddWithValue("@vMineral", 0);
// sda.SelectCommand.Parameters.AddWithValue("@vPhotoCopy", 0);
// sda.SelectCommand.Parameters.AddWithValue("@vFax", 0);
// sda.SelectCommand.Parameters.AddWithValue("@vGeneratorCharge", 0);
// sda.SelectCommand.Parameters.AddWithValue("@vMiscallaneous", 0);
//}
//else if (G_Tea == "12")
//{
// sda.SelectCommand.Parameters.AddWithValue("@vTea", 0);
// sda.SelectCommand.Parameters.AddWithValue("@vCofee", 0);
// sda.SelectCommand.Parameters.AddWithValue("@vMineral", G_iItemID);
// sda.SelectCommand.Parameters.AddWithValue("@vPhotoCopy", 0);
// sda.SelectCommand.Parameters.AddWithValue("@vFax", 0);
// sda.SelectCommand.Parameters.AddWithValue("@vGeneratorCharge", 0);
// sda.SelectCommand.Parameters.AddWithValue("@vMiscallaneous", 0);
//}
//else if (G_Tea == "13")
//{
// sda.SelectCommand.Parameters.AddWithValue("@vTea", 0);
// sda.SelectCommand.Parameters.AddWithValue("@vCofee", 0);
// sda.SelectCommand.Parameters.AddWithValue("@vMineral", 0);
// sda.SelectCommand.Parameters.AddWithValue("@vPhotoCopy", G_iItemID);
// sda.SelectCommand.Parameters.AddWithValue("@vFax", 0);
// sda.SelectCommand.Parameters.AddWithValue("@vGeneratorCharge", 0);
// sda.SelectCommand.Parameters.AddWithValue("@vMiscallaneous", 0);
//}
//else if (G_Tea == "14")
//{
// sda.SelectCommand.Parameters.AddWithValue("@vTea", 0);
// sda.SelectCommand.Parameters.AddWithValue("@vCofee", 0);
// sda.SelectCommand.Parameters.AddWithValue("@vMineral", 0);
// sda.SelectCommand.Parameters.AddWithValue("@vPhotoCopy", 0);
// sda.SelectCommand.Parameters.AddWithValue("@vFax", G_iItemID);
// sda.SelectCommand.Parameters.AddWithValue("@vGeneratorCharge", 0);
// sda.SelectCommand.Parameters.AddWithValue("@vMiscallaneous", 0);
//}
//else if (G_Tea == "15")
//{
// sda.SelectCommand.Parameters.AddWithValue("@vTea", 0);
// sda.SelectCommand.Parameters.AddWithValue("@vCofee", 0);
// sda.SelectCommand.Parameters.AddWithValue("@vMineral", 0);
// sda.SelectCommand.Parameters.AddWithValue("@vPhotoCopy", 0);
// sda.SelectCommand.Parameters.AddWithValue("@vFax", 0);
// sda.SelectCommand.Parameters.AddWithValue("@vMiscallaneous", 0);
// sda.SelectCommand.Parameters.AddWithValue("@vGeneratorCharge", G_iItemID);
// sda.SelectCommand.Parameters.AddWithValue("@vMiscallaneous", 0);
//}
//else if (G_Tea == "16")
//{
// sda.SelectCommand.Parameters.AddWithValue("@vTea", 0);
// sda.SelectCommand.Parameters.AddWithValue("@vCofee", 0);
// sda.SelectCommand.Parameters.AddWithValue("@vMineral", 0);
// sda.SelectCommand.Parameters.AddWithValue("@vPhotoCopy", 0);
// sda.SelectCommand.Parameters.AddWithValue("@vFax", 0);
// sda.SelectCommand.Parameters.AddWithValue("@vGeneratorCharge", 0);
// sda.SelectCommand.Parameters.AddWithValue("@vMiscallaneous", G_iItemID);
//}
// else if (G_Tea == "10")
// {
// sda.SelectCommand.Parameters.AddWithValue("@vTea", 0);
// sda.SelectCommand.Parameters.AddWithValue("@vCofee", 0);
// sda.SelectCommand.Parameters.AddWithValue("@vMineral", 0);
// sda.SelectCommand.Parameters.AddWithValue("@vPhotoCopy", 0);
//sda.SelectCommand.Parameters.AddWithValue("@vFax", 0);
//sda.SelectCommand.Parameters.AddWithValue("@vMiscallaneous", 0);
//}
//sda.SelectCommand.Parameters.AddWithValue("@iItemID", G_iItemID);
sda.SelectCommand.Parameters.AddWithValue("@Block", Block); ;
string s = ClsConnect.conSql.State.ToString();
if (s == "Open")
{
ClsConnect.conSql.Close();
}
ClsConnect.conSql.Open();
G_InvID = Convert.ToInt32(sda.SelectCommand.ExecuteScalar());
fnInvoiceItemSave(G_InvID);
ClsConnect.conSql.Close();
if (Block == 0)
{
MessageBox.Show(" Invoice Details insert Successfilly !!");
}
else
{
MessageBox.Show(" Invoice Details Update Successfilly !!");
}
}
}
catch (Exception ex)
{
ReturnValue = ex.Message;
}
return ReturnValue;
}
**********************************************************************************************************************************************************************************
SP
ALTER PROCEDURE [dbo].[prctblSalesInvoiceInsertUpdate]
(
@iSalesID int,
@iAccID int,
@vAccName varchar(50),
@dInvoiceDate datetime,
@iSerialNo int,
@deTotAmount decimal(18,2),
@iItemID int,
@Block int
)
AS
BEGIN
--select * from tblPurchaseInvoice
if(@Block=0)
begin
insert into tblSales
(
iAccID
,vAccName
,dInvoiceDate
,iSerialNo
,deTotAmount
,iItemID
)
values
(
@iAccID
,@vAccName
,@dInvoiceDate
,@iSerialNo
,@deTotAmount
,@iItemID
)
select scope_Identity() as ROID
end
else if(@Block=1)
begin
Update tblSales
set
iAccID =@iAccID
,vAccName =@vAccName
,dInvoiceDate =@dInvoiceDate
,iSerialNo =@iSerialNo
,deTotAmount =@deTotAmount
,iItemID =@iItemID
--where iSalesID =@iSalesID
--delete from tblPurchaseInvoiceItem where iPIMasterID=@iPIMasterID
where iItemID = @iItemID and iSalesID =@iSalesID and iAccID =@iAccID
select @iSalesID as ROID
end
END
****************************************************************************************************************************************************************************
SP
ALTER PROCEDURE [dbo].[prctblSalesInvoiceItemInsert]
(
@iSalesItemID int,
@iSalesID int,
@iItemID int,
@vItemCode varchar(50),
-- @vItemName varchar(50),
@vTea int,
@vCoffee int,
@vMineral int,
@vPhotoCopy int,
@vFax int,
@vGeneratorCharge int,
@vMiscallaneous int,
@iNos int,
@deRate decimal(18,2),
@deAmount decimal(18,2)
)
AS
SET NOCOUNT ON
BEGIN
IF exists(select iSalesItemID from tblSalesItem where iSalesItemID =@iSalesItemID)
begin
UPDATE tblSalesItem
SET
iSalesID = @iSalesID,
iItemID = @iItemID,
vItemCode = @vItemCode,
-- vItemName = @vItemName,
vTea = @vTea,
vCoffee = @vCoffee ,
vMineral = @vMineral,
vPhotoCopy = @vPhotoCopy,
vFax = @vFax ,
vGeneratorCharge = @vGeneratorCharge,
vMiscallaneous = @vMiscallaneous,
iNos = @iNos,
deRate = @deRate,
deAmount = @deAmount
WHERE iSalesItemID = @iSalesItemID and iItemID = @iItemID
end
ELSE
begin
INSERT INTO tblSalesItem
(
iSalesID,
iItemID,
vItemCode,
-- vItemName,
vTea,
vCoffee,
vMineral,
vPhotoCopy,
vFax,
vGeneratorCharge,
vMiscallaneous,
iNos,
deRate,
deAmount
)
VALUES
(
@iSalesID,
@iItemID,
@vItemCode,
-- @vItemName,
@vTea,
@vCoffee,
@vMineral,
@vPhotoCopy,
@vFax,
@vGeneratorCharge,
@vMiscallaneous,
@iNos,
@deRate,
@deAmount
)
end
END
VulpesPosted Sep 28, 2013, 6:35 AM
It sounds like there is something wrong with ConnString but as it's not defined or initialized within the snippet you posted I can't comment further at this stage.
Maneesh A NPosted Sep 28, 2013, 12:57 AM
THE CONNECTION STRING PROPERTY HAS NOT BEEN INITIALIZED,WHILE I GIVE string StrQuery = null;PLEASE CORRECT IT
VulpesPosted Sep 27, 2013, 9:35 AM
string StrQuery;
with:
string StrQuery = null;