Error While Inserting A Data In Sql Table

Shraddha Ital

The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Table-valued parameter 7 ("@VoucherList"), row 0, column 0: Data type 0xF3 (user-defined table type) has a non-zero length database name specified. Database name is not allowed with a table-valued parameter, only schema name and type name are valid.

How Can I Solve This Error

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rafnas T P8y ago
can you post your procedure UspInsertUpdateDispatchPaymentDetail.
Rafnas T P8y ago
you wanted to pass data table in the place of VoucherID.
public DataTable InsertUpdateDispatchPaymentDetail(string DeliveryAddress, int DispatchByAM, int FinYearId, decimal Amount, string PaymentRmk, string FilePath, DataTable VoucherId)

{

DataTable dtDetail = new DataTable();

SqlParameter[] arrParam = new SqlParameter[7];

arrParam[0] = new SqlParameter("@DeliveryAddress", DeliveryAddress);

arrParam[1] = new SqlParameter("@DispatchByAM", DispatchByAM);

arrParam[2] = new SqlParameter("@FinYearId", FinYearId);

arrParam[3] = new SqlParameter("@Amount", Amount);

arrParam[4] = new SqlParameter("@PaymentRmk", PaymentRmk);

arrParam[5] = new SqlParameter("@FilePath", FilePath);

arrParam[6] = new SqlParameter("@VoucherList", VoucherId);

ds = SqlHelper.ExecuteDataset(strConnStringRemote, "UspInsertUpdateDispatchPaymentDetail", arrParam);

if (ds.Tables.Count > 0)

{

dtDetail = ds.Tables[0];

}

return dtDetail;

}

or you can pass just an id as an integer or string, why are you passing entair datatable.
Shraddha Ital8y ago
public DataTable InsertUpdateDispatchPaymentDetail(string DeliveryAddress, int DispatchByAM, int FinYearId, decimal Amount, string PaymentRmk, string FilePath, DataTable VoucherId)
{
DataTable dtDetail = new DataTable();
SqlParameter[] arrParam = new SqlParameter[7];
arrParam[0] = new SqlParameter("@DeliveryAddress", DeliveryAddress);
arrParam[1] = new SqlParameter("@DispatchByAM", DispatchByAM);
arrParam[2] = new SqlParameter("@FinYearId", FinYearId);
arrParam[3] = new SqlParameter("@Amount", Amount);
arrParam[4] = new SqlParameter("@PaymentRmk", PaymentRmk);
arrParam[5] = new SqlParameter("@FilePath", FilePath);
arrParam[6] = new SqlParameter("@VoucherList", VoucherId);
ds = SqlHelper.ExecuteDataset(strConnStringRemote, "UspInsertUpdateDispatchPaymentDetail", arrParam);
if (ds.Tables.Count > 0)
{
dtDetail = ds.Tables[0];
}
return dtDetail;
}
Rafnas T P8y ago
hi,
what is the 7 th parameter you are passing(@VoucherList)