Comments by Member 10285877 (Top 60 by date)

sir but it show blank cell in excel sheet if datagridview columns visible false ..

ok sir its work thanku

ok sie but where i use include statment

sir i access c# window form to vb window from buttton click i click if button then it go to c# form

thanku sir

i solve that

when the conection open

sir all the project code...
problems occur

sir i have integer value that is 10 and one of the value is datetime that is datetime.now how calculate the days between the current month 10 date and the datetime.now date

sir i want zero if not match please help

ya sir how sir please send sample please

thanks sir

sir i have no code to written and i only want tutorial ar sample code for that

thanks sir its working

sir its out put is s0012
but i need s003

sir can u give me short example

thanks sir its working for me very thanks

thanks sir its working for me very thanks

thanks sir its working for me very thanks

sir only form1 datagridview data transfer to form2 datagridview

sir i do something like this but this is not best way and code is so large

if (dataGridView1.Rows.Count == 0)
{
MessageBox.Show("Please first a search a record");
return;
}
if (ch_cast.Checked == true)
{
dataGridView1.Columns[10].Visible = true;
}
else
{
dataGridView1.Columns[10].Visible = false;
}
if (ch_doa.Checked== true)
{

dataGridView1.Columns[8].Visible = true;
}
else
{
dataGridView1.Columns[8].Visible = false;
}
if (ch_dob.Checked == true)
{

dataGridView1.Columns[3].Visible = true;
}
else
{
dataGridView1.Columns[3].Visible = false;
}
if (ch_fn.Checked == true)
{

dataGridView1.Columns[6].Visible = true;
}
else
{
dataGridView1.Columns[6].Visible = false;
}
if (ch_mn.Checked == true)
{

dataGridView1.Columns[7].Visible = true;
}
else
{
dataGridView1.Columns[7].Visible = false;
}
if (ch_regno.Checked == true)
{

dataGridView1.Columns[9].Visible = true;
}
else
{
dataGridView1.Columns[9].Visible = false;
}
if (ch_smn.Checked == true)
{

dataGridView1.Columns[5].Visible = true;
}
else
{
dataGridView1.Columns[5].Visible = false;
}
if (checkBox1.Checked == true)
{

dataGridView1.Columns[11].Visible = true;
}
else
{
dataGridView1.Columns[11].Visible = false;
}

ya sir
Problem is that how to columns of table bind the checkboxlist

checked list box is different there show only datagridview columns

ok Sir I have a table with 20 columns and all the columns show in my datagridview.
bur user want there checkedboxlist and only datagridview shows those columns that user cheeked .

sir i have many columns in datagridview and show some columns in different time so i use checkboxlist and user select the columns from check-boxlist and display colmns in datagridview

thanku sir

sir i do that but i confuse some but now it working

thanks sir its work for me

sir its only return id 4 but i need id 4 and its related id for eg: 7 and its subid also need

i am use CheckedListBox?

sir in window application

sir one question sir how to minimize and maxi,ize form in according to main form when i minimize the main page all the form minimize and when i maximize all the form maximize i write code like this :-
private void frm_Main_Resize(object sender, EventArgs e)
{

if (this.WindowState == FormWindowState.Minimized)
{
foreach (Form frm in Application.OpenForms)
{
frm.WindowState = FormWindowState.Minimized;
}
}
else if (this.WindowState == FormWindowState.Normal)
{
foreach (Form frm in Application.OpenForms)
{
frm.WindowState = FormWindowState.Normal;
}
}
}

but sir i have no take mdi form

ya sir when i click menu item then form show me cnter in main page

sir please give me ans

ya sir before see change it color and change only that form that form i cal a function

when i send a sms FROM Phone to Website then its SMS data save to my website

for example : I send SMS like (xyz 1234) its save in my website database TABLE

from network sir

Sir my code like this

label59.Text = dr[50].ToString();

// string[] values = label59.Text.Split(',');
// Not solved

string[] values = label59.Text.Split(',');

for (int i = 0; i < this.checkedListBox1.Items.Count; i++)
{
checkedListBox1.SetItemChecked(i, false);
for (int x = 0; x < values.Length; x++)
{
if (this.checkedListBox1.Items[i].ToString() == values[x])
{
this.checkedListBox1.SetSelected(i, true);
this.checkedListBox1.SetItemChecked(i, true);
}
}
}

Sir how check items when it comes from databsae i tired but not solve sir please help

Sir how check items when it comes from databsae i tired but not solve sir please help

sir one question

ok Sir THanks

except first item it working

ya sir i see and impliment but not Check First item

sir my checbox items is : i,am,sumit,kaplesh amd my label items : i,am,kaplesh

sir it comapre wht first item not check even first item also in label

and compare each items to checkboxlist if found then check

ya sir i check more items

and sir label data comes from database

sir my label data is : i,am,sumit,kaplesh and i check only am,kaplesh so please suggest what i do

sIR IT ONLY cOMPARISON first index found then its goes next index otherwise not check the item of checbox list

Sir now work it properly thanku

Now sir this error come " InvalidArgument=Value of '3' is not valid for 'index'.
Parameter name: index"