Comments by Member 11952997 (Top 27 by date)

how can it possible sir?

simple say form1 is main form, also pass four different textbox. and two buttons.
when click 1st button it open new form2, form2 have datagridview,and when click datagridview cell_click event it pass data in form1's 1st two textbox.
now in form1 another button click it open form3, and form3 have datagridview,and when click datagridview cell_click event it pass data in form1's 2nd two textbox.

problem is when retrive form3 's data in form1 then form2 data in form1 not display, load event remove old data.

thank u sir.

i will check now..

ok.thanks a lot...

i use textbox, combobox, datetimepicker, and also image button use in form.

i am not use gridview to show data, i want to retrive or show data on form fields like example- in txtname= jigar , txtaddress=gujarat...this should fill in fields of forms in c#.net.

data table.

thank u sir, i will try, if any query then i will inform u.

on each button click display record in fields on forms in windows application c#.net.
means examlple- i create regestration form. many record i insert and save in database.
now i want to see first record then click on first button in form and it dispaly first inserted record.
then i want to see last record then click last button and it dispaly last record.
so that...
note- i want to see record in form fields.

ok..thank u so much sir..

sir,
how can i get api??

I want to create patch of my visual studio 2010's windows c# project .
I create .exe setup file of existing project.
how can i upgrade setup with new version???

thank you for suggestion sir,
but i cant understand.
give me another way.

I create .exe file of my c# windows application.
but next process of how can create patch file i dont know.
so how can i create patch file . please help me.

yes,
i need to create patch file but i dont know how to create to script of dabase and use in sql.

thank you for reply.
i use windows c# project form.
i use metroframework in c# page
in that i use metro fields.
like, metro datetime.
now i successfully create insert code , record save in database .
and display in metro grid.
now when i click grid's cell than all record display in form but date not display and generate error:- "The string was not recognized as a valid DateTime. There is an unknown word starting at index 0.
"
so help how can i retrive date on metro datetime

or give me hint how can retrive datetime on datetime picker.

thank you for your response sir,
my problem is not solve

below i send code on save button
now my problem is i want just simple code for update automatic field in database Expectedvisitortable

///code below////

private void btnSave_Click(object sender, EventArgs e)
{
txtTimeIn.Text = DateTime.Now.ToString("hh:mm:ss tt");
SqlConnection con = new SqlConnection(str);
con.Open();

if (txtVsitorFName.Text != "" && txtVsitorSName.Text != "" && txtCompanyName.Text != "" && txtCity.Text != "" && txtMobileNo.Text != "")
{
string sqll11 = "SELECT deptcode FROM DepartmentMaster where DepartmentName='" + cmdDepartmentName.Text + "'";
SqlCommand co1 = new SqlCommand(sqll11, con);
SqlDataReader myReade1 = co1.ExecuteReader();
while (myReade1.Read())
{
deptcode = Convert.ToInt32(myReade1.GetValue(0).ToString());
}
myReade1.Close();
string sqll111 = "SELECT vehclid FROM VehicalMaster where VehicalName='" + cmdVehicalType.Text + "'";
SqlCommand co11 = new SqlCommand(sqll111, con);
SqlDataReader myReade11 = co11.ExecuteReader();
while (myReade11.Read())
{
VehclId = Convert.ToInt32(myReade11.GetValue(0).ToString());
}
myReade11.Close();

if (MetroFramework.MetroMessageBox.Show(this, "Are You Really Save This Reocrd??", "GatePass Entry Page Save Warning", MessageBoxButtons.YesNo, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
string txtVisitorName = txtVsitorFName.Text.Trim() + " " + txtVsitorSName.Text.Trim(); //this is for combine name

string gatepasssave = "insert into GatePassEntryMaster (Vid,DeptCode,EntryNo,Date,VisitorName,VisitorFName,VisitorSName,ExtraPerson,CompanyName,City,MobileNo,VehicalType,VehicalNo,DepartmentName,PhotoId_Name,PhotoId_Number,OtherDepartmentName,ContactPersonName,timeIn,TimeOut,Reason,Remarks,CardIssueNo,MobCardIssueNo,PhotoId,IsLock) values ('" + vid + "','" + deptcode + "','" + txtentryno.Text + "','" + metrodatetime.Value.Date + "','" + txtVisitorName + "','" + txtVsitorFName.Text + "','" + txtVsitorSName.Text + "','" + cmbExtraPerson.Text + "','" + txtCompanyName.Text + "','" + txtCity.Text + "','" + txtMobileNo.Text + "','" + cmdVehicalType.Text + "','" + txtVehicalNo.Text + "','" + cmdDepartmentName.Text + "','" + cmbPhotoIdName.Text + "','" + txtPhotoIdNo.Text + "','" + txtOtherDepartment.Text + "','" + txtContactPersonName.Text + "','" + txtTimeIn.Text + "','" + txtTimeOut.Text + "','" + txtReason.Text + "','" + txtRemarks.Text + "','" + txtCardNo.Text + "','" + txtMoCardIssueNo.Text + "','" + pbpath + "',0)";

SqlCommand cmd = new SqlCommand(gatepasssave, con);

string updateexpectedmaster = "update ExpectedVisitorMaster set MobileNo='" + txtMobileNo.Text + "' where ExpectedVisitorvalue=" + xx;
SqlCommand cmdd = new SqlCommand(updateexpectedmaster, con);


cmdd.ExecuteNonQuery();
cmd.ExecuteNonQuery();



if (x == 0)
{
SqlConnection con22 = new SqlConnection(str);

if (txtVsitorFName.Text != "" && txtVsitorSName.Text != "" && txtCompanyName.Text != "" && txtCity.Text != "" && txtMobileNo.Text != "")
{
con22.Open();

string visitormastersave = ("insert into VisitorMaster (VisitorName,VisitorFName,VisitorSName,CompanyName,ShortAddressCity,PhotoId_Name,PhotoId_Number,MobileNo,PhotoPath) values ('" + txtVisitorName + "','" + txtVsitorFName.Text + "','" + t

sir I use that code given below:

string filename = Path.Combine(Application.StartupPath, "Image", ppath);

but generate error.

sir.
I use this project on network side.
i install setup file and sqlserver in user one pc. and only setup file install in user 2's pc. as per ago discussion error arise.

thank you so much sir for your reply,
sir, I create windows application in visual studio 2010 with sql server 2005, with windows 7 64 bit.
sir i didn't get such answer for solve my problm.
pls help me sir.

Login failed for user", The user is not associated with a trusted SQL Server connection.

sorry for late reply bro,
i send code below in visual studio 2010 with c#, i use metro framework.

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using MetroFramework.Forms;
using System.Data.Odbc;
using System.Data.SqlClient;
using System.Configuration;
using System.Media;
using System.Drawing.Imaging;
using Emgu.CV;
using Emgu.CV.UI;
using Emgu.CV.Structure;
using Emgu.Util;
using System.Runtime.InteropServices;

namespace Visitor_GatePass_Management_System
{
// public partial class VisitorMasterPage : Form

public partial class VisitorMasterPage : MetroForm
{

public VisitorMasterPage()
{
InitializeComponent();
}

private Emgu.CV.Capture _capture;
//private static Emgu.CV.Capture _capture;
private bool _captureInProgress;
//Emgu.CV.Capture _capture;
//bool _captureInProgress;

private void VisitorMasterPage_Load(object sender, EventArgs e)
{
lblpath.Text = "D:\\image.jpg";


}

private void btncapphonto_Click(object sender, EventArgs e)
{
if ((this.lblpath.Text.Trim().Length > 0))
{
if ((_capture==null))

{
try
{
//_capture = new Emgu.CV.Capture();

_capture = new Capture();
}
catch (NullReferenceException excpt)
{
MetroFramework.MetroMessageBox.Show(this, excpt.Message);
}
}
if (((_capture != null)))
{
if (_captureInProgress)
{
this.btncapphonto.Text = "Start Capture";
// this.Load +=new EventHandler(this.ProcessFrame);
//EventHandlerList list=(EventHandlerList)
Application.Idle -= new EventHandler(this.ProcessFrame);

this.pbphoto.Image.Save(this.lblpath.Text, ImageFormat.Jpeg);
this.pbphoto.ImageLocation = this.lblpath.Text;
}
else
{
// captureButton.Text = "Capture"
this.btncapphonto.Text = "Capture";
Application.Idle += new EventHandler(this.ProcessFrame);
}
_captureInProgress = !_captureInProgress;
}
}
else
{
MetroFramework.MetroMessageBox.Show(this, "Please set directory path for saving the image.");
}
}

private void ProcessFrame(object sender, EventArgs arg)
{
//Emgu.CV.Image[] frame(Emgu.CV.Structure.Bgr,Byte)= this._capture.QueryFrame;
Emgu.CV.Image<emgu.cv.structure.bgr, byte=""> frame = this._capture.QueryFrame();
Emgu.CV.Image<emgu.cv.structure.bgr, byte=""> frame1 = frame.Resize(150, 150, Emgu.CV.CvEnum.INTER.CV_INTER_LINEAR);
pbphoto.Image = frame1.Bitmap;
}

private void btnSaveVisitorMaster_Click(object sender, EventArgs e)
{

}

}
}