sql server - c# Local Database insert into doesn't work -


i tried many times insertion doesn't work! please me..

codes:

sqlconnection conn = new sqlconnection(@"data source=(localdb)\v11.0;attachdbfilename=|datadirectory|\database1.mdf;integrated security=true"); conn.open(); sqlcommand cmd = new sqlcommand("insert mytbl(id, nav) values('yek','du')", conn); //yek , du examples //following command doesn't work, //"insert mytbl(id, nav) values('"+tb.text+"','"+tb2.text+"')" cmd.executenonquery(); conn.close();

the whole user instance , attachdbfilename= approach flawed - @ best! when running app in visual studio, copying around .mdf file (from app_data directory output directory - typically .\bin\debug - app runs) , most likely, insert works fine - you're looking @ wrong .mdf file in end!

if want stick approach, try putting breakpoint on myconnection.close() call - , inspect .mdf file sql server mgmt studio express - i'm data there.

the real solution in opinion

  1. install sql server express (and you've done anyway)

  2. install sql server management studio express

  3. create database in ssms express, give logical name (e.g. victorydatabase)

  4. connect using logical database name (given when create on server) - , don't mess around physical database files , user instances. in case, connection string like:

    data source=.\\sqlexpress;database=victorydatabase;integrated security=true

    and else exactly same before...

also see aaron bertrand's excellent blog post bad habits kick: using attachdbfilename more background info.


-

Comments

Post a Comment

Popular posts from this blog

c# - ajax - How to receive data both html and json from server? -

i have referenced this topic , doesn't solve problem. i'm using mvc 5 c#. have used code receive data server data type json . $.ajax({ url: "/mycontroller/myaction", type: "post", datatype: "json", success: function (data) { if (data.result) { alert('successfull'); } else { alert(data.ex); } } }); and controller code: [httppost] public actionresult myaction() { try { return json(new { result = "true", ex = "" }); } catch (exception e) { return json(new { result = "false", ex = e.message }); } } i use way data type html: $.ajax({ url: "/mycontroller/myaction", type: "post", datatype: "html", success: function (data) { $(".mydiv").append(data); } }); and controller should be: [httppost] public actionresult myaction() { return partialview("_...
Read more

c# - SharpDX Toolkit models rendering inside out -

a little while ago decided switch xna sharpdx toolkit actively being supported , quite similar xna. while i've had no trouble @ creating 2d games decided attempt basic 3d game. can both model , it's texture load when renders shows texture on side facing away camera doesn't show @ in between. this code using set environment. vector3 cameraposition = new vector3(0, 0, -10f * 2.5f); vector3 cameratarget = vector3.zero; boundingsphere modelbounds = model.calculatebounds(); float fovangle = mathutil.degreestoradians(45); float aspectratio = (float)graphicsdevice.backbuffer.width / graphicsdevice.backbuffer.height; float near = 0.01f; float far = 100f; float scaling = 10f / modelbounds.radius; matrix translation = matrix.scaling(scaling) * matrix.rotationy((float)gametime.totalgametime.totalseconds) * matrix.translation(0, -modelbounds.center.y * scaling, 0); matrix lookat = matrix.lookatlh(cameraposition, cameratarget, vector3.u...
Read more