title: add user and assign role in aspnet membership through sql servers SP
body: <p>Tech - asp.net 3.5, Sql server 2005</p>
  
  <p>I have integrate aspnet membership for my webapplication.</p>
  
  <p>I am adding some users (member) from importing excel file.</p>
  
  <p>So how can I add that user and role of that user in aspnet membership tables?</p>
  
  <p>NOTE - I have SP which is used to add member in DB from uploaded excel file, I have wrote insert trriger on membertable.</p>