c# - 'System.Data.SqlClient.SqlException' How to fix? Visual Studio 2015 -

-

this question has answer here:

i'm trying put form variables database, however, i'm still new @ these things , i'm trying random copy pasted code internet learn. thing giving me problems

@using webmatrix.data; @using webmatrix.webdata; @using system.data.sqlclient;   @{     viewbag.title = "recruta";  }  @{       var nome = "";     var email = "";     var tel = "";     var adress = "";     var gender = "";      nome = request.form["nome"];     email = request.form["email"];     tel = request.form["tel"];     adress = request.form["adress"];     gender = request.form["gender"];      var db = database.open("usuarios");     var insertcommand = "insert usuarios (nome, email, tel, adress, gender) values(@0, @1, @2, @3, @4)";     db.execute(insertcommand, nome, email, tel, adress, gender);     response.redirect("~/usuarios");         }

this information given vs:

an exception of type 'system.data.sqlclient.sqlexception' occurred in system.data.dll not handled in user code  additional information: database 'c:\users\softinsa\documents\visual studio 2015\projects\best_prototype_01\best_prototype_01\app_data\usuarios.mdf' cannot opened because version 851. server supports version 706 , earlier. downgrade path not supported.  cannot attach file 'c:\users\softinsa\documents\visual studio 2015\projects\best_prototype_01\best_prototype_01\app_data\usuarios.mdf' database 'c:\users\softinsa\documents\visual studio 2015\projects\best_prototype_01\best_prototype_01\app_data\usuarios.mdf'.

and error lies apparently:

  db.execute(insertcommand, nome, email, tel, adress, gender);

i apologize if i'm posting dumb question, said, i'm still fresh in asp.net , it's endevours.

i appreciate reading , can help.

edit: tried using solutions on the database cannot opened because version 782. server supports version 706 , earlier. downgrade path not supported , none of them worked me, i'm using vs community edition 2015, default connections (localdb)\mssqllocaldb isn't issue here.

first, never ever code business logic inside asp.net mvc views.

second, exception quite clear:

the database '...' cannot opened because version 851. server supports version 706 , earlier. downgrade path not supported.

you don't have right version of sql server running on system. trying open newer database file format version have installed. either install correct version of sql server, or downgrade database file format.

this might related use of visual studio 2015 update 2.


Comments

Post a Comment

Popular posts from this blog

javascript - Laravel datatable invalid JSON response -

-
everything work fine on code below fetch user logs: js: <script> $(document).ready(function () { var table =$('#systemlogs').datatable({ responsive: true, processing: true, serverside: true, "language": { "url": "/datatables/media/plug-in/persian.json" }, ajax: '{!! url('/admin/systemlogs/data/systemlogsdatatable') !!}', columns: [ { data: 'name', name: 'name' }, { data: 'message_text', name: 'message_text' }, { data: 'remote_addr', name: 'remote_addr' }, { data: 'log_created_at', name: 'management_logs.created_at' }, { data: 'log_updated_at', name: 'management_logs.updated_at' }, ] }); }); </script> routes: route::get('/systemlogs/data/systemlogsdatatable','systemlogscontrolle...
Read more

java - Exception in thread "main" org.springframework.context.ApplicationContextException: Unable to start embedded container; -

-
i getting error when run spring application: exception in thread "main" org.springframework.context.applicationcontextexception: unable start embedded container; nested exception org.springframework.context.applicationcontextexception: unable start embeddedwebapplicationcontext due missing embeddedservletcontainerfactory bean. @ org.springframework.boot.context.embedded.embeddedwebapplicationcontext.onrefresh(embeddedwebapplicationcontext.java:124) @ org.springframework.context.support.abstractapplicationcontext.refresh(abstractapplicationcontext.java:476) @ org.springframework.boot.context.embedded.embeddedwebapplicationcontext.refresh(embeddedwebapplicationcontext.java:109) @ org.springframework.boot.springapplication.refresh(springapplication.java:691) @ org.springframework.boot.springapplication.run(springapplication.java:320) @ org.springframework.boot.springapplication.run(springapplication.java:952) @ org.springframework.boot.springa...
Read more

sql server 2008 - My Sql Code Get An Error Of Msg 245, Level 16, State 1, Line 1 Conversion failed when converting the varchar value '8:45 AM' to data type int -

-
msg 245, level 16, state 1, line 1 conversion failed when converting varchar value '8:45 am' data type int. script declare @specimenid bigint = 0, @script varchar(max); declare @starttime int = (select convert(int,substring(start_time,0,charindex(':', start_time)) - 12) appt appt._id=112601) --select @starttime set @script = 'select distinct ptlast_name + '', '' + pt.first_name patient_name, dbo.formatdate(pt.dob,''mm/dd/yyyy'') dob, (convert(varchar, (datediff(yy, dob, appt_date) - case when (month(dob) > month(appt_date)) or (month(dob) = month(appt_date) , day(dob) > day(appt_date)) 1 else 0 end)) + ''/'' + convert(varchar, (datediff(m, dateadd(yy, (datediff(yy, dob, appt_date) - case when (month(dob) > month(appt_date)) or (month(dob) = month(appt_date) , day(dob) > day(appt_date)) 1 else 0 end), d...
Read more