Subscribe For Free Updates!

We'll not spam mate! We promise.

Showing posts with label Data Grid View. Show all posts
Showing posts with label Data Grid View. Show all posts

Aug 15, 2012

Show images in Grid View in android

Views:

Show images in Grid View in android
To day I will show how to Show or Bind images in Grid View in android .
Basically GridView is a ViewGroup that displays items in a two-dimensional, scrollable grid. The grid items are automatically inserted to the layout using a ListAdapter.
GridView Control or layout is one of the most useful layouts in android. Gridview is mainly useful when we want to show data in grid layout like displaying images or icons. This layout can be used to build applications like image viewer, audio or video players in order to show elements in grid manner.
In This Tutorial I will showing you how Images are binded in GridView .
When You Click or Tap on an image the Image will Open in activity with Full Sizes.



Jul 30, 2012

Grid View Copy Paste In Excel File

Views:

Grid View Copy Paste In Excel File
Today I Show how to Copy Paste Data In Data Grid View From an Excel File and From Excel From Copy Paste To Grid View .
As we know that Is Excel is A Grate Product of Microsoft. Excel File is most Probably use From Reporting , Graphs Making and Etc.  
User Always Wants Easiness in Software Application .

Copy Paste From Grid View to Excel File Provide Easy Ways for Reporting and Graphs Making.Excel File Copy Paste To Grid View Save Data Entry Operator Time and After Pasting  Data To Data Grid View We can Easily Save it To Data Base Just by clicking Button.

So lets start
First Drag Drop an Data Grid View on Windows Forms
Create  Columns in Data Grid View ID ,StudentName, Class,Sec,Batch,Fees.
Grid View Copy Paste In Excel File


Grid View Copy Paste In Excel File
 
First We enable Grid View to Copy data In Clip Board by writing Following line in Page load Event.
this.dataGridView1.ClipboardCopyMode = 
    DataGridViewClipboardCopyMode.EnableWithoutHeaderText;
and Write Download The Following Method For Copy Paste.
private void PasteClipboard()
        {
            try
            {
                string s = Clipboard.GetText();
                string[] lines = s.Split('\n');
                int iFail = 0, iRow = dataGridView1.CurrentCell.RowIndex;
                int iCol = dataGridView1.CurrentCell.ColumnIndex;
                DataGridViewCell oCell;
                foreach (string line in lines)
                {
                    if (iRow < dataGridView1.RowCount && line.Length > 0)
                    {
                        string[] sCells = line.Split('\t');
                        for (int i = 0; i < sCells.GetLength(0); ++i)
                        {
                            if (iCol + i < this.dataGridView1.ColumnCount)
                            {
                                oCell = dataGridView1[iCol + i, iRow];
                                if (!oCell.ReadOnly)
                                {
                                   
                                   
                             oCell.Value = Convert.ChangeType(sCells[i],
                                                       oCell.ValueType);
                             oCell.Style.BackColor = Color.Tomato;
                                   
                                    
                                }
                            }
                            else
                            { break; }
                        }
                        iRow++;
                    }
                    else
                    { break; }
                    if (iFail > 0)
                        MessageBox.Show(string.Format("{0} updates failed due" +
                                        " to read only column setting", iFail));
                }
            }
            catch (FormatException)
            {
   MessageBox.Show("The data you pasted is in the wrong format for the cell");
                return;
            }
        }


Now Write Some Code Behid in  dataGridView1_MouseClick Event For Display The Context menu
if (e.Button == MouseButtons.Right)
            {
                ContextMenu m = new ContextMenu();

                
   m.MenuItems.Add(new MenuItem("Paste"),, new EventHandler(BtPasteClick));
    var relativeMousePosition = dataGridView1.PointToClient(Cursor.Position);
      m.Show(dataGridView1, relativeMousePosition);


            }

and also Add Following Method same as it is After Above Method
private void BtPasteClick(object sender, EventArgs e)
        {
            string s = Clipboard.GetText();
            if (s.Length > 0)
            {
                PasteClipboard();
            }
            else
            {
                MessageBox.Show("Please Copy Some Data First "
                    , "[MOHAMMAD SAJJAD ASHRAF AWAN]"
                    , MessageBoxButtons.OK, MessageBoxIcon.Question);
            }
        }

So that it .
When You Copy Paste Data Always Remember Following Things .
1) Always Copy Equal Number of Cells mean When you Copy Data from Excel Must Copy equal or Less No. of Cells  According to Data Grid view .
2)You Must Add No .of Empty Row to Grid view  That you are Going to Paste.
3)always select Initial Cell of Grid View to Paste Data.

DOWNLOAD SOURCE CODE

SOME OUTPUT SCREEN SHORTS

Grid View Copy Paste In Excel File



Grid View Copy Paste In Excel File
Grid View Copy Paste In Excel File


Become a Fan

visual studio learn