Comments by Abdul Samad KP (Top 78 by date)

You need to convert it to string
((CheckBox)dg.Controls[i]).Checked.ToString();
this will work.

You don't need a conditional operator (?:) operator because ((CheckBox)dg.Controls[i]).Checked return true or false only.

use Controls[i] instead of Controls(i)

How many items did you select? If you want to select multiple items press and hold control key then select items.

If you use dropdownlist then you can select only one item at a time. If you want to select multiple items then use listbox , so that the user can hold control key and select multiple items. Alternatively you can use CheckedListBox also

Set the windowState property of the form to maximized
remove your code and add below code in form load

this.WindowState=FormWindowState.Maximized;

I see two problems in your code
1. Rows[14] , 14 is your column number, not the row index
2. You have declared array of size 0

change
byte[] mydata = new byte[0];
mydata = (byte[])(this.abaanaDataSet.abaanaCC.Rows[14]["CCImage"]);


to

byte[] mydata = (byte[])(this.abaanaDataSet.abaanaCC.Rows[0]["CCImage]);

I assume you have CCImage is not null in row 1

If you want to pass 10 parameters , you have to add all of them to the list

You are right , since the controls are generated at runtime , you have to place your code outside the if(!IsPoastBack) block, but in that case your code should work properly.
So I am deleting my answer.
I guess the code you have posted is not the original one, because there are many errors in that.

When uploading you have to insert id to all rows, don't leave it blank. If you want to select the records like excel you can use

SELECT CASE WHEN Row_Number() OVER(ORDER BY ID) =1 THEN ID ELSE '' END AS [ID],Val1,val2,val3,val4,val5,val6,val7
FROM YourTable WHERE ID=@SearchingID

I think, this is not the right way to do it. You have to repeat the ID in all records belongs to it

Pls post your treeview binding code and code in the page load event

What is the ID of other tree rows?

Page load event is fired when a post back occurs, so pls check you have placed your treeview binding code inside a if(!IsPostback) checking

When are you binding the tree?
Inside page load?

You can use a gridview inside your gridview and bind the child gridview on databind event of the parent grid, or you can use a datarpeater control

Why are you binding tree view in Selected node changed event?
Because of this, the selection is resting, that is why you are always getting first node.
By the way , why are you assigning a text to a tree node?

Always use SQL parameters in your command instead of appending command with the values.

Here the problem is date format.
If you systems are using English culture then you can try
string s=" insert into payment (paid_date) values('"+h1.ToString("dd/MMM/yyyy") +"')";

What dates you expect if you select May/2015 and week 1?

How are you binding your grids, from a data table? What is the relationship between the grids?

after I edit solution1, it was not displaying so I added it again, but now it is coming twice

I think there is a mistake in your code for reading the text file
change
if (System.IO.File.Exists(lstImages.SelectedItem.ToString()))
to
if (System.IO.File.Exists(myFile))

The code you have posted is not delete code, it is just changing the visibility of the button and setting the command argument etc, I assume this is the code you are using in item data bound event of a gird. Please post the code in the Item Command event

As Karthik said , it is just checking any rows are there in the table. There is nothing to do with null , you can use like IF EXISTS(select top 1 1 from table) also

Your signup page is in a separate folder or in the main folder?
Can u please explain your folder structure

Why you are saving date as string in the DB?
Any way you can use DateTime.ParseExact to convert string to date
Have a look at https://msdn.microsoft.com/en-us/library/w2sa9yss(v=vs.110).aspx

It will work only in windows forms. In webforms, if you change item from your code , it will not fire the event, move your code in the selected item changed event to a separate method and call it wherever you need.

Is your data coming from database?

I think you are doing it wrong way, Instead of changing the read only property in the check box checked changed event, you can add edit item templates and make the row editable by setting grid view edit item index to that row

Check whether cookies are disabled in IE

In the SQL, NULL is treated as special types, so MT. TranStatus <> 'Cancel' will not include rows where MT. TranStatus is null.
To get your desired output, you can use ISNULL (MT. TranStatus,'') <> 'Cancel'

Since you are not changing your command text, you will have same data and schema in all tables

Assign DataPropertyName for all datagrid columns (you can do it in the designer)
It is better to create the datattable with your datagridview structure(columns) in the page load and bind it to the grid, so that you can easily handle the grid

Set
datagridview1.AutoGenerateColumns=false;

Just reverse the process
1. Declare the dataset
2. Read xml (ds.ReadXml("your xml filepath", XmlReadMode.ReadSchema);)
3. Get dgvDataTable from the ds and bind to grid
(If you have given a name to the datattable while declaring it(before saving) then you can get it by name like ds.Tables["dgvDataTable "]; or you can use index)
4. Get txtDataTable from the ds
5. Get textbox value from the txtDataTable
If you have marked "# of columns" as primary key then you can find the row by txtDataTable.Rows.Find(<column number="">)(this will return datarow) else you can use txtDataTable.Select("[# of columns]=<column number="">") (this will return datarow array)

6. Assign values to textbox

Why you are filling dataset multiple times?

How you are binding your DataGrid?
If you are binding from datatable try this
ds.Tables.Add((DataTable)DataGridview1.DataSource);

What you mean by display, as far as I know datatable is not a control and it cannot be used to display anything but bound to other controls to dispalay its contents.

Why you want that? use AutoScroll=True

No, you may need to copy the aspnet_client folder into your application folder

As Wes Aday said , @val is dbnull. To avoid this error use .ToString()

Cmd.ExecuteNonQuery()
TxtValue.Text = Cmd.Parameters("@val").Value.ToString()

What is dr.Close();
Where you are declaring your command and connection?
Have you initialized them?

You mean Global.asax ?

Design a page with a dropdown and a textbox or html editor control and a save button. Load all the template types (various stages) to dropdown list, so the user can select the template type and enter the templates with predefined tags and save it.
Then in your class, before sending email load the template and replace the tags.

Check all your where clauses
You must be missing =@Px in one of your where clause

Have you assigned a connection to the command?
like
cmd.Connection=yourconnection

Sorry I don’t have a sql2012 installed on my machine to test, but I think it will work if the time format is hh:mm:ss or hh:mm. Please check all rows are having values in this format.

"Insert into EmployeeMaster(Emp_EmployeeNumber,Emp_Surname,Emp_FirstName,Emp_OtherNames,Emp_TitleEmp_Gender,Emp_OfficePhoneExtension,Emp_YearsInService,Emp_DefaultHours,Emp_Status,Emp_DepartmentCode,Emp_DivisionCode,Emp_SectionCode,Emp_BranchCode,Emp_RegionCode,Emp_LocationCode,Emp_ReportTo,Emp_JobCode,Emp_ClassCode,Emp_PositionCode,Emp_Group1Code,Emp_Group2Code,Emp_Group3Code,Emp_EmploymentDate,Emp_EffectiveDate,Emp_EmploymentType,Emp_ReasonForChange,Emp_LastChangedBy,Emp_DateofChange,Emp_AlternateNumber1,Emp_PayPending) " & _
"Select @py ,Emp_EmployeeNumber,Emp_Surname,Emp_FirstName,Emp_OtherNames,Emp_TitleEmp_Gender,Emp_OfficePhoneExtension,Emp_YearsInService,Emp_DefaultHours,Emp_Status,Emp_DepartmentCode,Emp_DivisionCode,Emp_SectionCode,Emp_BranchCode,Emp_RegionCode,Emp_LocationCode,Emp_ReportTo,Emp_JobCode,Emp_ClassCode,Emp_PositionCode,Emp_Group1Code,Emp_Group2Code,Emp_Group3Code,Emp_EmploymentDate,Emp_EffectiveDate,Emp_EmploymentType,Emp_ReasonForChange,Emp_LastChangedBy,Emp_DateofChange,Emp_AlternateNumber1,Emp_PayPending EmployeeMaster where Emp_EmployeeNumber= @px " & _
"update employeeBenefits set EmployeeNo=@py where EmployeeNo=@px; " & _
"update EmployeeCareerHist set ECareer_EmployeeNumber=@py where ECareer_EmployeeNumber=@px; " & _
'' add remaining update statements here, sperate each statement with a semi column(;)

Change cellValue[j, k] = exlWs.Cells[j+1,k+1].ToString();
to cellValue[j, k] = exlWs.Cells[j+1,k+1].Value.ToString();

Can you post your code?

If it is in a common portal, you can check the Url in Application_BeginRequest event of global.asax and redirect them

I used to get this error in VS2008 (now I am using VS2010), if I open too many forms in the VS designer

You have to add parameters one by one

Did you try
window.opener.location.href = window.opener.location.href;
this is working for me

Did you try
INSERT INTO TW100NEL(ComponentNumber,ObjectDescription,Group,Quantity,Unit) VALUES(?,?,?,?,?)

As George Jonsson said there is no calendar column for Datagrid view, if you are using a custom datetime picker control, you can set MinDate.

If you want to provide user role based access then this will work, I have used this in a couple of projects, but I haven't used membership provider. There is no connection between application size and this. The only thing is, you have to override all methods as per your requirements

How you are binding your grid?

Sorry for that, I have deleted the comment,
So basically you want property like 'AutoCompleteCustomeSource' of textbox control, I think you can create a custom control for this
Have look at this, http://msdn.microsoft.com/en-us/library/7tas5c80(v=vs.110).aspx


http://msdn.microsoft.com/en-us/library/7tas5c80(v=vs.110).aspx

Change the line Dim da As New SqlCeDataAdapter(query, conn)
to Dim da As New SqlCeDataAdapter(bcmd, conn)

I think you can use 'Attach To Process' option available under VS tools menu

You have to add a space after the keyword INNER JOIN and also before the key word FROM

For example change the line "RA ON Courier.CourierID = RA.CourCompany INNER JOIN" & _
to "RA ON Courier.CourierID = RA.CourCompany INNER JOIN " & _

Sorry, I didn't get
What did you mean by dynamic?

The SQL Syntax is correct, what error message you are getting?

What exactly you want to do? Can you please explain in detail?

Sorry, I guess I did not understand your question correctly,
You want to add files to the visual studio project, or you are looking for the code to transfer files?

How you are inserting updated values into the log table?
I mean, if the user is updating multiple records at the same time, then the trigger will be executed only once and all the new records will be there in the inserted table. So your insert query should insert all records available in the Inserted table.
This is important if you are processing (like inner joining with some other tables or getting value into parameters and doing some calculation or checking some conditions) the records in the Inserted table before inserting into the log table