Implicit conversion from data type nvarchar to varbinary
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jignesh KumarPosted Dec 4, 2023, 7:10 AM
Hello Neeraj,
Please check your BankName Column DataType in SQL table. I think bankname column datatype is Binary and you are trying to insert nvarchar value to it.
neeraj kumarPosted Jan 11, 2024, 12:34 PM
Note:- The graph is loading after 30 seconds of page loading but I want to optimize the performance, the graph should also load as soon as the page is loaded, please suggest.
A graph has to be created which should be of donut type for the data coming from the procedure and the graph should be loaded immediately as soon as the webpage is opened.
For this type data-
AgeGroup No column name Sequence
18-20 215 1
21-25 2276 2
26-30 2626 3
31-35 1233 4
35-40 401 5
41-45 110 6
46-50 37 7
51-55 10 8
services:-
public List
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["InnovOneEntities1"].ToString()))
{
using (SqlCommand command = new SqlCommand("usp_AssociateJobAgeingDashBoard", con))
{
command.Parameters.AddWithValue("@intMappingId", 4002189);
command.Parameters.AddWithValue("@intClientId", 0);
command.Parameters.AddWithValue("@intFacilityId", 0);
command.CommandType = CommandType.StoredProcedure;
con.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
ageGroupData.Add(new
{
AgeGroup = reader[0].ToString(),
Value = (int)reader[1]
});
}
}
}
}
return ageGroupData;
}
Controller:-
[HttpPost]
public JsonResult GetAgeGroupData()
{
var ageGroupData = objUser.GetAgeGroupData();
return Json(ageGroupData, JsonRequestBehavior.AllowGet);
}
View:-
$(document).ready(function () {
//DashboardOfferReleased();
//DashboardAssociateAgeing();
//DashboardAssociateJobsAgeing();
loadAgeGroupDonutChartJOB();
});
function loadAgeGroupDonutChartJOB() {
$.ajax({
type: "POST",
url: '@Url.Action("GetAgeGroupData", "User")',
contentType: 'application/json',
success: function (response) {
if (response && response.length > 0) {
var labels = response.map(item => item.AgeGroup);
var data = response.map(item => item.Value);
renderDonutChart(labels, data);
} else {
console.log('No data available.');
}
},
error: function (error) {
console.error(JSON.stringify(error));
}
});
}
function renderDonutChart(labels, data) {
var options = {
series: data,
chart: {
type: 'donut',//'donut',
//height: 320,
},
labels: labels,
dataLabels: {
enabled: true,
formatter: function (val) {
return val.toFixed(0);
}
},
};
var chart = new ApexCharts(document.querySelector("#ageGroupDonutChart"), options);
chart.render();
}
Jayraj ChhayaPosted Dec 5, 2023, 9:25 AM
In SQL, implicit conversion refers to the automatic conversion of one data type to another by the database engine. However, not all data type conversions are supported implicitly, and it is important to understand the rules and limitations of implicit conversions.
When it comes to converting from the NVARCHAR data type to the VARBINARY data type, SQL Server does not support implicit conversion. This means that you cannot directly assign an NVARCHAR value to a VARBINARY column or variable without explicitly converting the data.
Amit MohantyPosted Dec 4, 2023, 10:08 AM
In your error its showing Procedure tr_Asso...._Insert, but in your post it's just a simple insert query. So please provide the original code so others can better understand the problem.
neeraj kumarPosted Dec 4, 2023, 8:36 AM
no datatype is nvarchar
pfa.