I am writting below code for inserting but not inserted ma database,
please once check my code correct it
public partial class FacebookLogin : System.Web.UI.Page
{
string id;
string name;
string userName;
string email;
public void IData()
{
string strQuery;
SqlCommand cmd;
//insert
strQuery = "insert into customers (Id,Name,UserName,Email) values(@Id,@Name,@UserName,@Email)";
cmd = new SqlCommand(strQuery);
//cmd.Parameters.AddWithValue("@CustomerID", "A234");
//cmd.Parameters.AddWithValue("@CompanyName", "DCB");
cmd.Parameters.AddWithValue("@Id", id);
cmd.Parameters.AddWithValue("@Name", name);
cmd.Parameters.AddWithValue("@UserName", userName);
cmd.Parameters.AddWithValue("@Email", email);
InsertUpdateData(cmd);
}
private Boolean InsertUpdateData(SqlCommand cmd)
{
String strConnString = System.Configuration.ConfigurationManager.ConnectionStrings["conString"].
ConnectionString;
SqlConnection con = new SqlConnection(strConnString);
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
try
{
con.Open();
cmd.ExecuteNonQuery();
return true;
}
catch (Exception ex)
{
Response.Write(ex.Message);
return false;
}
finally
{
con.Close();
con.Dispose();
}
}
protected void Page_Load(object sender, EventArgs e)
{
FaceBookConnect.API_Key = "308366389297505";
FaceBookConnect.API_Secret = "3b25f3cb109f647b00c40c98a4190641";
if (!IsPostBack)
{
if (Request.QueryString["error"] == "access_denied")
{
ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('User has denied access.')", true);
return;
}
string code = Request.QueryString["code"];
if (!string.IsNullOrEmpty(code))
{
string data = FaceBookConnect.Fetch(code, "me");
FaceBookUser faceBookUser = new JavaScriptSerializer().Deserialize<FaceBookUser>(data);
faceBookUser.PictureUrl = string.Format("https://graph.facebook.com/{0}/picture", faceBookUser.Id);
pnlFaceBookUser.Visible = true;
id = faceBookUser.Id;
name = faceBookUser.UserName;
userName = faceBookUser.Name;
email= faceBookUser.Email;
ProfileImage.ImageUrl = faceBookUser.PictureUrl;
fbLogin.Enabled = false;
}
IData();
}
}
protected void Login(object sender, EventArgs e)
{
FaceBookConnect.Authorize("user_photos,email", Request.Url.AbsoluteUri.Split('?')[0]);
}
}
public class FaceBookUser
{
public string Id { get; set; }
public string Name { get; set; }
public string UserName { get; set; }
public string PictureUrl { get; set; }
public string Email { get; set; }
}