Comments by Zain -Ul- Arifeen (Top 24 by date)

Sir
i have installed time the fresh windows 8.1 in this computer in this current month but this machine get hang after three days or two days. i am using in this machine desktop base application.
desktop application details
C# language
.net framework 4.5
Digitalpersona SDK
Plz plz plz plz help me

if i take loop on it then duplicate value insert in the datagridview.

like my code

For example:

for(int i=0; i

try this code.....

sql.AppendLine("SELECT * FROM WP_advUploads");
sql.AppendLine("WHERE imageID='"+textbox1.Text+"'");

dear sir the database contains valid values.but I m getting error again and again. there is no row at position 8 or 2 or 4 etc

dear sir,
if u will guid me on this question with code or demo.
that is better for me.
thanx

Dear Sir,
my Sql Server Services and Sql Browser services is correctly running.but still give me this types of error. and the following is my connection string
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;

namespace ADMSV1
{
class ConnectionString
{
public static SqlConnection cnn = new SqlConnection("Data Source=zain\\sqlexpress;Initial Catalog=ADMSV01;Integrated Security=True");
}
}

R/Sir,

i want don't load my gridview from the old data(old records present in the table).so i want to load or show the current record when i entered from the text box.

like this

give the same types of Error

textbox for the date

Dear Sir,

i use the following code,but it does not pass values to the textbox in the user form fro the datagridview and give me this Error in the folowing statement;
Statement:txtusername.text=dr.Cells[0].Value.ToString();

Error:
"An unhandled exception of type 'System.NullReferenceException' occurred in Company Accounts.exe

Additional information: Object reference not set to an instance of an object."



///this is my formuserslection code.
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace Company_Accounts
{
public partial class FrmUserSelection : Form
{
DataSet ds = null; // Set null here
public FrmUserSelection()
{
InitializeComponent();

}

private void FrmUserSelection_Load(object sender, EventArgs e)
{

fillgrid();
ControlBox = false;
usdgv.Columns[0].SortMode = DataGridViewColumnSortMode.NotSortable;
txtwildsearch.Focus();
//this.usdgv.Columns["Password"].Visible = false;

}

private void fillgrid()
{
ds=new DataSet(); //Create new obj here
ConnectionString.cnn.Open();
SqlDataAdapter da = new SqlDataAdapter("select username as [User Name],Password,Title, userrole,logincomputer as [Login Computer] ,logindate as [Login Date] ,Logintime as [Login Time] from login", ConnectionString.cnn);
da.Fill(ds, "tbl_login");
usdgv.DataSource = ds.Tables["tbl_login"];
ConnectionString.cnn.Close();
}

private void usdgv_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
FrmUser.dr = usdgv.CurrentRow;
fillgrid();
this.Close();
}

private void btnwildsearch_Click(object sender, EventArgs e)
{
FrmUser.dr = usdgv.CurrentRow;
this.Close();
}

private void usdgv_CellClick(object sender, DataGridViewCellEventArgs e)
{
label1.Text ="" +usdgv.Columns[usdgv.CurrentCell.ColumnIndex].HeaderText + " ";
s1.Text = "" + usdgv.Columns[usdgv.CurrentCell.ColumnIndex].HeaderText + " ";
s2.Text = "" + usdgv.Columns[usdgv.CurrentCell.ColumnIndex].HeaderText + " ";
s3.Text = "" + usdgv.Columns[usdgv.CurrentCell.ColumnIndex].HeaderText + " ";
}

private void txtwildsearch_TextChanged(object sender, EventArgs e)
{
DataView dt = ds.Tables[0].DefaultView;
string tbcolumn;
try
{
tbcolumn = usdgv.Columns[usdgv.CurrentCell.ColumnIndex].HeaderText.ToString();
dt.RowFilter = string.Format("" + tbcolumn + " ='{0}'", txtwildsearch.Text);
if (dt.Count > 0)
{
usdgv.DataSource = dt;
}
else
{
usdgv.DataSource = 0;
}
if (usdgv.RowCount == 0)
{
usdgv.DataSource = ds.Tables[0].DefaultView;
}
}
catch (Exception)
{
}
}
}
}

////and this is the user form code.

public static DataGridViewRow dr;
FrmUserSelection fus = new FrmUserSelection();
private void btnsearch_Click(object sender, EventArgs e)
{
DataCollection();


}

private void DataCollection()
{
fus.ShowDialog();
txtusername.Text = dr.Cells[0].Value.ToString();
txtpassword.Text = dr.Cells[1].Value.ToString();
txttitle.Text = dr.Cells[2].Value.ToString(

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace Company_Accounts
{
public partial class MyMessageBox : Form
{

static MyMessageBox newMessageBox;
static string Button_id;
public static DataGridViewRow dr;
public Timer msgTimer;
int disposeFormTimer;
public MyMessageBox()
{
InitializeComponent();
}

private void MyMessageBox_Load(object sender, EventArgs e)
{
ControlBox = false;
disposeFormTimer = 30;
newMessageBox.lblTimer.Text = disposeFormTimer.ToString();
msgTimer = new Timer();
msgTimer.Interval = 1000;
msgTimer.Enabled = true;
msgTimer.Start();
msgTimer.Tick += new System.EventHandler(this.timer1_Tick );
}
public static string ShowBox(string txtMessage, string txtTitle)
{
newMessageBox = new MyMessageBox();
newMessageBox.label3.Text = txtTitle;
newMessageBox.label1.Text = txtMessage;
newMessageBox.ShowDialog();
return Button_id;
}

private void btnlist_Click(object sender, EventArgs e)
{
newMessageBox.msgTimer.Stop();
Button_id = "3";
this.Hide();
this.Close();

}

private void btnrenter_Click(object sender, EventArgs e)
{
newMessageBox.msgTimer.Stop();
Button_id = "1";
this.Close();

}

private void btnadd_Click(object sender, EventArgs e)
{
newMessageBox.msgTimer.Stop();

Button_id = "2";
this.Close();

}

private void timer1_Tick(object sender, EventArgs e)
{
disposeFormTimer--;

if (disposeFormTimer >= 0)
{
newMessageBox.lblTimer.Text = disposeFormTimer.ToString();
}
else
{
newMessageBox.msgTimer.Stop();
newMessageBox.msgTimer.Dispose();
newMessageBox.Dispose();
}
}
}
}
this my form code.

how to specify table or dataset in which you fatch data from database server in th datasource.
sir, i am the beginner of this language.
plz,plz,plz, help me

sir I want to complete remove the exit button from the title bar in windows form.

plz,plz,

thank you so much

plz, plz, sir ,can you explain me this in the form picture with code. plz, plz, plz, plz, plz,.....

plz,plz,plz,plz,plz sir write the complete code .or put statement in my code.Dn't mind it,because i am beginner..

This is My the First Form(Form1) Code.

private void btnsearch_Click(object sender, EventArgs e)
{
Form2 f2 = new Form2();
f2.Show();

}



And this is my second From(Form2 (datagridview)) Code.



public partial class form_userselection : Form
{

FrmUsers fpc = new FrmUsers();
DataSet ds = new DataSet();

public form_userselection()
{
InitializeComponent();
}

private void form_userselection_Load(object sender, EventArgs e)
{
try
{

SqlDataAdapter da = new SqlDataAdapter("select * from login", ConnectionString.cnn);

da.Fill(ds, "auth_table");
dataGridView1.DataSource = ds.Tables["auth_table"];


}
catch (Exception)
{

//throw;
}

}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{


FrmUsers fu = new FrmUsers();

fu.txtpassword.Text = dataGridView1.CurrentRow.Cells[0].Value.ToString();
fu.txttitle.Text = dataGridView1.CurrentRow.Cells[1].Value.ToString();
fu.txtuserrole.Text = dataGridView1.CurrentRow.Cells[2].Value.ToString();
fu.txtlogincmpt.Text = dataGridView1.CurrentRow.Cells[3].Value.ToString();
fu.txtlogindate.Text = dataGridView1.CurrentRow.Cells[4].Value.ToString();
fu.txtlogintime.Text = dataGridView1.CurrentRow.Cells[5].Value.ToString();

}
}
}

when i select one row from the datagridview ,the datagridview form disappear and does not set record to the text box in the form1.