Before starting, you should make sure that `git status` is clean (i.e. there&#39;s no output from that command) to avoid losing work.  The simplest way to do what you want is probably:

    git reset --soft &lt;LAST-COMMIT-THAT&#39;S-OK&gt;
    git commit -m &#39;Many squashed commits&#39;
    git push --force origin master

You should bear in mind that this is rewriting history (that&#39;s why you need the `--force` option to `git push`) so you should avoid this if anyone else might have cloned or pulled from your repository.  For some more alternatives, see this question and its answers:

* https://stackoverflow.com/q/5189560/223092


I am creating a small helper function to return a `DataTable`. I would like to work across all providers that `ADO.Net` supports, so I thought about making everything use `IDbCommand` or `DbCommand` where possible.

I have reached a stumbling block with the following code:

        private static DataTable QueryImpl(ref IDbConnection conn, String SqlToExecute, CommandType CommandType, Array Parameters)
        {
            SetupConnection(ref conn);
            // set the capacity to 20 so the first 20 allocations are quicker...
            DataTable dt = new DataTable();
            using (IDbCommand cmd = conn.CreateCommand())
            {
                cmd.CommandText = SqlToExecute;
                cmd.CommandType = CommandType;
                if (Parameters != null &amp;&amp; Parameters.Length &gt; 0)
                {
                    for (Int32 i = 0; i &lt; Parameters.Length; i++)
                    {
                        cmd.Parameters.Add(Parameters.GetValue(i));
                    }
                }
                dt.Load(cmd.ExecuteReader(), LoadOption.OverwriteChanges);
            }
            return dt;
        }

When this code is executed, I receive an `InvalidCastException` which states the following:

&gt; The SqlParameterCollection only accepts non-null SqlParameter type objects, not String objects.

The code falls over on the line:

    cmd.Parameters.Add(Parameters.GetValue(i));

Any ideas? 

Any improvements to the above code is appreciated.

----

Actual solution: 


        private static readonly Regex regParameters = new Regex(@&quot;@\w+&quot;, RegexOptions.Compiled);
        private static DataTable QueryImpl(ref DbConnection conn, String SqlToExecute, CommandType CommandType, Object[] Parameters)
        {
            SetupConnection(ref conn);
            DataTable dt = new DataTable();
            using (DbCommand cmd = conn.CreateCommand())
            {
                cmd.CommandText = SqlToExecute;
                cmd.CommandType = CommandType;
                if (Parameters != null &amp;&amp; Parameters.Length &gt; 0)
                {
                    MatchCollection cmdParams = regParameters.Matches(cmd.CommandText);
                    List&lt;String&gt; param = new List&lt;String&gt;();
                    foreach (var el in cmdParams)
                    {
                        if (!param.Contains(el.ToString()))
                        {
                            param.Add(el.ToString());
                        }
                    }
                    Int32 i = 0;
                    IDbDataParameter dp;
                    foreach (String el in param)
                    {
                        dp = cmd.CreateParameter();
                        dp.ParameterName = el;
                        dp.Value = Parameters[i++];
                        cmd.Parameters.Add(dp);
                    }
                }
                dt.Load(cmd.ExecuteReader(), LoadOption.OverwriteChanges);
            }
            return dt;
        } 

Thanks for ideas/links etc. :)

Adding parameters to IDbCommand

I&#39;m trying to display image bytes which is saved in database as a `StreamedContent` in the `&lt;p:graphicImage&gt;` as follows:

&lt;!-- language: xhtml --&gt;

    &lt;p:graphicImage  value=&quot;#{item.imageF}&quot; width=&quot;50&quot;  id=&quot;grpImage&quot; height=&quot;80&quot;/&gt;

&lt;!-- language: java --&gt;

    private StreamedContent content; // getter and setter
    
    public StreamedContent getImageF() {
                
        if (student.getImage() != null) {
            InputStream is = new ByteArrayInputStream(student.getImage());
            System.out.println(&quot;Byte :&quot;+student.getImage());
            content = new DefaultStreamedContent(is, &quot;&quot;, student.getStuID());
            System.out.println(&quot;ddd ------------------------------- &quot; + content);
            return content;
        }

        return content;
    }
    
This returns a blank image. How is this caused and how can I solve it?

The stdout prints the following:

    INFO: Byte :[B@a2fb48
    INFO: ddd ------------------------------- org.primefaces.model.DefaultStreamedContent@b0887b
    INFO: Byte :[B@a2fb48
    INFO: ddd ------------------------------- org.primefaces.model.DefaultStreamedContent@1d06a92
    INFO: Byte :[B@d52f0b
    INFO: ddd ------------------------------- org.primefaces.model.DefaultStreamedContent@39a60
    INFO: Byte :[B@d52f0b
    INFO: ddd ------------------------------- org.primefaces.model.DefaultStreamedContent@8c3daa
    INFO: Byte :[B@124728a
    INFO: ddd ------------------------------- org.primefaces.model.DefaultStreamedContent@1dbe05b
    INFO: Byte :[B@124728a
    INFO: ddd ------------------------------- org.primefaces.model.DefaultStreamedContent@66a266
    INFO: Byte :[B@a2fb48
    INFO: ddd ------------------------------- org.primefaces.model.DefaultStreamedContent@1293976
    INFO: Byte :[B@a2fb48
    INFO: ddd ------------------------------- org.primefaces.model.DefaultStreamedContent@17b7399
    INFO: Byte :[B@d52f0b
    INFO: ddd ------------------------------- org.primefaces.model.DefaultStreamedContent@1e245a5
    INFO: Byte :[B@d52f0b
    INFO: ddd ------------------------------- org.primefaces.model.DefaultStreamedContent@4a7153
    INFO: Byte :[B@124728a
    INFO: ddd ------------------------------- org.primefaces.model.DefaultStreamedContent@1561bfd
    INFO: Byte :[B@124728a
    INFO: ddd ------------------------------- org.primefaces.model.DefaultStreamedContent@47a8c2



Display dynamic image from database or remote source with p:graphicImage and StreamedContent

&gt; **Possible Duplicate:**  
&gt; [How can I squash my last X commits together using git?](https://stackoverflow.com/questions/5189560/how-can-i-squash-my-last-x-commits-together-using-git)  

&lt;!-- End of automatically inserted text --&gt;

I have a project hosted on GitHub and I have a local clone. I have a load of small commits that I have already pushed up to GitHub. This has all been done using the default *master branch.

I got confused between merge --squash and rebase etc...
What is the most straightforward way of combining several historial commits in to one commit so that it pushes up to GitHub?

Git: simplest way of squashing commits on master

> Possible Duplicate: 
> <a href="https://stackoverflow.com/questions/5189560/how-can-i-squash-my-last-x-commits-together-using-git" target="_blank" rel="noopener noreferrer">How can I squash my last X commits together using git?</a>

I have a project hosted on GitHub and I have a local clone. I have a load of small commits that I have already pushed up to GitHub. This has all been done using the default *master branch.
I got confused between merge --squash and rebase etc...
What is the most straightforward way of combining several historial commits in to one commit so that it pushes up to GitHub?

I am in the process of setting up a git repository and attempting to link it to Heroku. When I run the command

    git push heroku master

I receive 

    Counting objects: 7, done.
    Delta compression using up to 2 threads.
    Compressing objects: 100% (5/5), done.
    Writing objects: 100% (7/7), 714 bytes, done.
    Total 7 (delta 1), reused 0 (delta 0)
    
    -----&gt; Heroku receiving push
    
     !     Heroku push rejected due to an unrecognized error.
     !     We&#39;ve been notified, see http://support.heroku.com if the problem persists.
    
    
    To git@heroku.com:morning-stream-3712.git
     ! [remote rejected] master -&gt; master (pre-receive hook declined)
    error: failed to push some refs to &#39;git@heroku.com:morning-stream-3712.git&#39;

I&#39;m not quite sure what other information would be helpful and what will just muddy the waters, so I&#39;ll just leave it at this for now. Any help getting my application pushed to Heroku would be greatly appreciated. Thanks.



git, Heroku: pre-receive hook declined

I created a new branch named `newbranch` from the `master` branch in git. Now I have done some work and want to merge `newbranch` to `master`; however, I have made some extra changes to `newbranch` and I want to merge `newbranch` up to the fourth-from-the-last commit to `master`.

I used `cherry-pick` but it shows the message to use the right options:

    git checkout master    
    git cherry-pick ^^^^HEAD newbranch

Can I use git `merge` to do it instead?

    git merge newbranch &lt;commitid&gt;

Merge up to a specific commit

I need to do a subtree merge for a specific branch, if it exists on a given remote repository. The problem is that the remote repository is not checked out locally, so I can&#39;t use `git branch -r`. All I have is a remote address, something like this  `https://github.com/project-name/project-name.git`.  Is there a way to list remote branches just by a remote address?  I couldn&#39;t find anything usefull :(

How to check if remote branch exists on a given remote repository?

&gt; **Possible Duplicate:**  
&gt; [Rolling back local and remote git repository by 1 commit](https://stackoverflow.com/questions/4647301/rolling-back-local-and-remote-git-repository-by-1-commit)  

&lt;!-- End of automatically inserted text --&gt;

How can I remove the last commit from a remote GIT repository such as I don&#39;t see it any more in the log?

If for example `git log` gives me the following commit history

    A-&gt;B-&gt;C-&gt;D[HEAD, ORIGIN]

how can I go to 

    A-&gt;B-&gt;C[HEAD,ORIGIN]

Thanks.


Remove last commit from remote git repository

I&#39;m using eclipse egit with github. I found something strange that I didn&#39;t change anything, but egit marked the file as &quot;changed&quot;. See the images:

1. the file &quot;run.bat&quot; is marked as &quot;changed&quot;

   ![enter image description here][1]

2. Compare with &quot;file in Git index&quot;, you can see nothing is different

   ![enter image description here][2]

3. Compare with &quot;file in HEAD&quot;, you can see nothing is different neither

   ![enter image description here][3]

My friend uses mac and I use windows, but we all configured git as &quot;commit unix lineend&quot;.. I also checked the lineend of my source and the HEAD, they are the same(I configured git to convert them to &quot;\r\n&quot; when pulling)

Where is wrong? Is it a bug of Egit?



  [1]: http://i.stack.imgur.com/I5RtP.jpg
  [2]: http://i.stack.imgur.com/wMb4S.png
  [3]: http://i.stack.imgur.com/HyVqd.png

There is nothing changed, but eclipse egit marks the file as changed

my author name in all my commits is coming up as *unknown* [https://github.com/freeenergy/Teacher-Login-Validation-Module][1]

did this

    $ git config --global user.name &quot;Firstname Lastname&quot;Sets the name of the user for all git instances on the system
    $ git config --global user.email &quot;your_email@youremail.com&quot;

but still the author/committer name shows [unknown]

 not knowing what I was doing I experimented with  setting $ GIT_AUTHOR_NAME=&quot;my name&quot; and it changed my name to my username [freeenergy] (I.E. my issue was fixed.)  But when I switched back to my other computer the issue was the same.

  [1]: https://github.com/freeenergy/Teacher-Login-Validation-Module



my config file now looks like this but is still committing as [unknown]

    [core]
    	repositoryformatversion = 0
    	filemode = false
    	bare = false
    	logallrefupdates = true
    	symlinks = false
    	ignorecase = true
    	hideDotFiles = dotGitOnly
    [remote &quot;origin&quot;]
    	url = git@github.com:freeenergy/my-project.git
    	fetch = +refs/heads/*:refs/remotes/origin/*
    [user]
        name = my name
        email = myEmail.com

Git author Unknown

I&#39;d like to reference commits in other repos (in this case submodules) in the github issues of my main repo. Is it possible to do so without typing the full hyperlink in a way similar to how github creates a shortened hyperlink from the commit number?

Cross-referencing commits in github

There was a good link here about how the zip/tarball string is created

https://stackoverflow.com/questions/6334040/when-i-download-a-zip-from-github-what-is-the-hex-string-at-the-end-of-the-file

But I&#39;m looking at the GitHub APIv3 and I was curious if I&#39;m missing something.

1. Is there a way to get the zip/tarball link via an API call?

2. If not, is there a way I can build that string without using the git binary or library? Meaning, can I use various API calls to pull out th data a need and assemble to URL I need?

I know the second question is a little unreasonable for stackoverflow and this is a bit of a fun project for me, so I would prefer on the second question if you just kind of nudged me in the right direction as opposed to throwing down a code snippet. Or just told me if it was possible.

GitHub Api download zip or tarball link

Is there anything out there like Github that is for your own local server?  I am curious if there is like a PHP script or even a desktop client that mimics Github&#39;s functionality, I love Github but it would be nice to host on my own server.

Apologies if this isn&#39;t considered &quot;programming&quot; enough but generally only programmers use GIT and Github


----------
## Update ##

First of all thanks for all the great suggestions, it is great to see there are options out there.  From what is posted here and from my googling I can say it looks like the best looking/most alike to Github solutions are coded in Ruby, which is great for some but I am a PHP kind of guy (for now).

Most of the PHP GIT viewers either are  outdated and abandoned projects or they just look like crap ( I realize I could fix them up to be more like Github) but I ran across something in PHP that looks promising so far.  It is called Glip it is on Github here https://github.com/patrikf/glip and to me it is the most attractive and easy to use solution I have found for PHP so far.  For the advanced Git user, it may not be enough but for me, I just wanted to be able to view a git repo and that provides that functionality.

Now my search still continues for the perfect solution, will I ever find it?  I hope so but, for now, this is we got.  I am considering writing my own, one that is attractive like Github and has other features like an Issue tracker for bug and feature requests.  All the ones I have seen so far are not so good

How can I have Github on my own server?

On http://github.com developer keep the HTML, CSS, JavaScript and images files of the project. How can I see the HTML output in browser?

For example this: https://github.com/necolas/css3-social-signin-buttons/blob/master/index.html

When I open this it doesn&#39;t show the rendered HTML of the code of author. It shows the page as a source code.

Is it possible to see it as rendered HTML directly? Otherwise I always need to download the whole ZIP just to see the result.

Content Type	Original Author	Original Content on Stackoverflow
Question	Gabe	View Question on Stackoverflow
Solution 1 - Git	Mark Longair	View Answer on Stackoverflow

Git: simplest way of squashing commits on master

Git Problem Overview

Git Solutions

Solution 1 - Git

Display dynamic image from database or remote source with p:graphicImage and StreamedContent

Adding parameters to IDbCommand

Attributions