sql - Unable to connect to database C# -


i've been trying connect ms sql database through connection string in app.config, reason fails login, can't seem figure out.

this connection method:

public void con() {          string username = usernamebox.text;         string password = passwordbox.text;          bool loginfail;          sqlconnection conn = new sqlconnection(configurationmanager.connectionstrings["lagerconn"].connectionstring);          //search connstring user id= & password= , replace username , password textboxes         if (_connstring.contains("user id="))         {             _connstring = _connstring.replace("user id=;", "user id=" + username + ";");          }         if (_connstring.contains("password="))         {             _connstring = _connstring.replace("password=", "password='" + password + "'");         }          try         {             conn.open();             conn.close();             loginfail = false;         }catch         {             messagebox.show("login failed");             loginfail = true;         }         if(loginfail == false) //if login successful change next form , hide connect form         {             mainmenu secondform = new mainmenu();             secondform.show();             this.hide();          }      }`

and here app.config

        <add name="lagerconn" connectionstring="data source=lagerserver;initial catalog=lagerdb;persist security info=true;user id=;password="         providername="system.data.sqlclient" /> </connectionstrings>

i got exception

there's no point putting empty user id , password field in connection string @ all. leave them out altogether , rid of pointless persist security info too. use connection string builder, e.g.

sqlconnection builder = new sqlconnectionstringbuilder(configurationmanager.connectionstrings["lagerconn"].connectionstring);  builder.userid = userid; builder.password = password;  sqlconnection connection = new sqlconnection(builder.connectionstring);

after that, don't provide generic error message , ignore information system gives you. @ exception , tell went wrong.


Comments

Post a Comment

Popular posts from this blog

Python Kivy ListView: How to delete selected ListItemButton? -

Image
i'm trying learn kivy building simple todo-list app suggested dusty phillips, author of book "creating apps in kivy". this code far: from kivy.app import app kivy.uix.boxlayout import boxlayout kivy.properties import objectproperty kivy.uix.listview import listitembutton class taskbutton(listitembutton): pass class todoroot(boxlayout): task_input = objectproperty() task_list = objectproperty() def add_task(self): self.task_list.adapter.data.extend([self.task_input.text]) self.task_list._trigger_reset_populate() def del_task(self): pass class todoapp(app): def build(self): return todoroot() if __name__ == '__main__': todoapp().run() and kv file: #: import main todo #: import listadapter kivy.adapters.listadapter.listadapter #: import listitembutton kivy.uix.listview.listitembutton todoroot: <todoroot>: orientation: "vertical" task_input: task_input_view t...
Read more

ruby - How do I merge two hashes into a hash of arrays? -

http://codepad.org/wmyzqlis i'd merge these 2 arrays: a = { :a => 'a', :b => 'b', :d => 'd' } b = { :a => '1', :b => 'b', :c => 'c' } into hash looks this: {:a => ["a", "1"], :b => ["b", "b"], :c => [nil, "c"], :d => ["d", nil] } this doesn't work: p a.merge(b) { |k, v1, v2| [v1, v2] } # {:c=>"c", :a=>["a", "1"], :b=>["b", "b"], :d=>"d"} it's because hash#merge call block duplicate keys. a = { :a => 'a', :b => 'b', :d => 'd' } b = { :a => '1', :b => 'b', :c => 'c' } hash[(a.keys|b.keys).map { |key| [key, [a.fetch(key, nil), b.fetch(key, nil)]] }] # => {:a=>["a", "1"], :b=>["b", "b"], :d=>["d", nil], :c=>...
Read more