Comments by advancedansh (Top 48 by date)

if i would provide u my API would u like to Help

Thanks for telling me ..but please help me about this topic act i have to work alot but i am not able to do that because i need basics about doing this.

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Drawing.Imaging;
using System.IO;

namespace temp
{
public partial class visitor : Form
{
SqlConnection con = new SqlConnection("server=BGIL001\\SQLEXPRESS;database=temp1;Integrated Security=SSPI");
SqlCommand cmd;
SqlDataAdapter adap;
public visitor()
{
InitializeComponent();
}

private void btnsave_Click(object sender, EventArgs e)
{
string FirstName = txtfirstname.Text;
string LastName = txtlastname.Text;

string EmailID = txtemailid.Text;
string IdentityOption = cbidentityyoption.SelectedItem.ToString();
string IdentityNo = txtidentityno.Text;
string Company = txtcompany.Text;
string Address = txtaddress.Text;
string City = txtcity.Text;

byte[] Image = readfile(txtbrowse.Text);
string ToMeet = txttomeet.Text;
string Department = txtdepartment.Text;
string Purpose = cbpurpose.SelectedText;
string VisitorType = cbvisitortype.SelectedText;


con.Open();
cmd = new SqlCommand("insert into visitor1(First_Name,Last_Name,Email_ID,Identity_Option,Identity_No,Company,Address,City,Picture,To_Meet,Department,Purpose,Visitor_type) values('" + txtfirstname.Text + "','" + txtlastname.Text + "','" + txtemailid.Text + "','" + cbidentityyoption.SelectedItem.ToString() + "','" + txtidentityno.Text + "','" + txtcompany.Text + "','" + txtaddress.Text + "','" + txtcity.Text + "','Image.value.toString()','" + txttomeet.Text + "','" + txtdepartment.Text + "','" + cbpurpose.SelectedItem.ToString() + "','" + cbvisitortype.SelectedItem.ToString() + "')", con);
cmd.ExecuteNonQuery();
con.Close();
}

private void btnbrowse_Click(object sender, EventArgs e)
{
openFileDialog1.Title = "insert an image";
openFileDialog1.InitialDirectory = System.Environment.GetFolderPath(Environment.SpecialFolder.Personal);
openFileDialog1.FileName = "";
openFileDialog1.Filter = "JPEG IMAGES|*.jpg|GIF IMAGES|*.gif";
openFileDialog1.ShowDialog();
string choosenfile = openFileDialog1.FileName;
txtbrowse.Text = openFileDialog1.FileName;
pbimagephoto.Load(choosenfile);
//pbimagephoto.Image = openFileDialog1.OpenFile(choosenfile);
}
byte[] readfile(string spath)
{
byte[] data = null;
FileInfo finfo = new FileInfo(spath);
long numbytes = finfo.Length;
FileStream fstream = new FileStream(spath, FileMode.Open, FileAccess.Read);
BinaryReader br = new BinaryReader(fstream);
data = br.ReadBytes((int)numbytes);
return data;
}

private void btnshow_Click(object sender, EventArgs e)
{



//Initialize SQL adapter.
adap = new SqlDataAdapter("Select Picture from visitor1 where Pass_Code=2", con);

//Initialize Dataset.
DataSet DS = new DataSet();

//Fill dataset with ImagesStore table.
adap.Fill(DS, "visitor1");

//Fill picturebox with image.
byte[] imageData = (byte[])DS.Tables["visitor1"].Rows[0]["Picture"];

//Initialize image variable
Image newImage;
//Read image data into a memory stream
using (MemoryStream ms = new MemoryStream(imageData, 0, imageData.Length))
{
ms.Write(imageData, 0, imageData.Length);

//Set image variable value u