c# - Error populating dropdownlist from SQL Database -

-

so have add data connection vs project , i'm trying populate drop down menu created data tables coming database; however, when run code says, "login failed use 'username', on line: 

                    cmd.connection.open();

this c# code: 

 using system.web;  using system.web.security;  using system.web.ui;  using system.web.ui.webcontrols;  using system.web.ui.webcontrols.webparts;  using system.web.ui.htmlcontrols;  using system.data.sqlclient;      namespace test1234     {         public partial class home : system.web.ui.page         {             protected void page_load(object sender, eventargs e)             {                 populateddlist1();                 //populateddlist2();                 //populateddlist2_1();             }                 public void populateddlist1()             {                 sqlcommand cmd = new sqlcommand("select * [history]", new sqlconnection(configurationmanager.appsettings["connection"]));                 cmd.connection.open();                  sqldatareader ddlvalues;             ddlvalues = cmd.executereader();              dropdownlist1.datasource = ddlvalues;             dropdownlist1.datavaluefield = "serial";             dropdownlist1.datatextfield = "serial";             dropdownlist1.databind();              cmd.connection.close();             cmd.connection.dispose();          }//end populate 1      } }

this web.config code: 

<?xml version="1.0"?>  <!--   more information on how configure asp.net application, please visit   http://go.microsoft.com/fwlink/?linkid=169433   -->  <configuration>      <connectionstrings>         <add name="actionetitinventoryconnectionstring" connectionstring="data source=10.10.101.188;initial catalog=actionetitinventory;user id=rails.sa;password=actionet1234"             providername="system.data.sqlclient" />     </connectionstrings>     <system.web>       <compilation debug="true" targetframework="4.5" />       <httpruntime targetframework="4.5" />     </system.web>    <appsettings>     <add key="connection" value="data source=10.10.101.188;initial catalog=actionetitinventory;user id=rails.sa;password=***********;integrated security=true"/>   </appsettings>  </configuration> 

<appsettings>     <add key="connection" value="data source=10.10.101.188;initial catalog=actionetitinventory;user id=rails.sa;password=***********;integrated security=true"/>   </appsettings>

your connection string contains both login & password integrated security=true

if trying log on named login/password, either set integrated security=false or leave out altogether


Comments

Post a Comment

Popular posts from this blog

Fail to load namespace Spring Security http://www.springframework.org/security/tags -

-
i have problem namespace of spring security on xhtml page. don't understand why can't load uri, , have following issue: whitelabel error page application has no explicit mapping /error, seeing fallback. tue jul 21 16:58:12 utc 2015 there unexpected error (type=not found, status=404). please need help! possible uri has been changed? best regards you using incorrect namespace url. correct url http://www.springframework.org/schema/security the error page seeing spring source website since not recognize url. try visiting http://www.springsource.org/security/tags in browser update : spring security tags used in jsp page correct tag lib declaration is: <%@ taglib prefix="sec" uri="http://www.springframework.org/security/tags" %>
Read more

sql - MySQL query optimization using coalesce -

-
can explain me why second query faster first? (first 1 takes around 40 seconds, second 1 less 0.1) select releases.feature_code, releases.platform_id, version, release_date, general_available, uri, filesize, display_name, feature_name.full_name, if ((select exists(select 1 release_exceptions releases.feature_code = release_exceptions.feature_code , releases.platform_id = release_exceptions.platform_id , releases.version = release_exceptions.version) = 1), 1, 0) release_exceptions releases left outer join platform using(platform_id) left outer join feature_name using(feature_code) order version desc; ~~~ query 2 ------------------ ~~~ select feature_code, version, release_date, general_available, platform_id, uri, filesize, display_name, feature_name.full_name, coalesce(release_exceptions, 0) release_exceptions mus.releases left outer join ( select distinct feature_code, version, platform_id, 1 release_exceptions mus.release_exceptions ) release_exceptions using ...
Read more

unity3d - Unity local avoidance in user created world -

-
i'm using unity3d networked multiplayer online game have large complex 3d terrain scene forest, trees, cliff, hills, mountains, bounders, etc. players can build structures sort of minecraft, , put them anywhere in scene, or move them around anytime. aside human controlled players, there automated ai players , objects animals roaming around scene following path. the problem how make these automated ai players , animals, able navigate around static , dynamic player created structures, because path follow can blocked player created structures, or other players , other ai objects, cliffs etc. have find away around them or on track if tumble down off high cliff example. so made navmesh , used navagents, takes care of static, non moving objects, how make ai players navigate around each other , dynamic structures created players can number in hundreds? i thought of adding navmeshobstacle everything, result in being attached hundreds of objects since user created structures b...
Read more